| field | example | SQL type | description |
|---|
| bin | 585 | smallint(5) unsigned | Indexing field to speed chromosome range queries. |
| level | 1 | int(10) unsigned | Level of alignment |
| tName | chr1 | varchar(255) | Target chromosome |
| tStart | 35488 | int(10) unsigned | Start on target |
| tEnd | 35531 | int(10) unsigned | End on target |
| strand | + | char(1) | Orientation of query. + or - |
| qName | NW_016828873v1 | varchar(255) | Query chromosome |
| qStart | 45359 | int(10) unsigned | Start on query |
| qEnd | 45404 | int(10) unsigned | End on query |
| chainId | 4573 | int(10) unsigned | Associated chain Id with alignment details |
| ali | 43 | int(10) unsigned | Bases in gap-free alignments |
| score | 1985 | double | Score - a number proportional to 100x matching bases |
| qOver | -1 | int(11) | Overlap with parent gap on query side. -1 for undefined |
| qFar | -1 | int(11) | Distance from parent gap on query side. -1 for undefined |
| qDup | 0 | int(11) | Bases with two or more copies in query. -1 for undefined |
| type | top | varchar(255) | Syntenic type: gap/top/syn/nonsyn/inv |
| tN | 0 | int(11) | Unsequenced bases on target. -1 for undefined |
| qN | 0 | int(11) | Unsequenced bases on query. -1 for undefined |
| tR | 11 | int(11) | RepeatMasker bases on target. -1 for undefined |
| qR | 20 | int(11) | RepeatMasker bases on query. -1 for undefined |
| tNewR | -1 | int(11) | Lineage specific repeats on target. -1 for undefined |
| qNewR | -1 | int(11) | Lineage specific repeats on query. -1 for undefined |
| tOldR | -1 | int(11) | Bases of ancient repeats on target. -1 for undefined |
| qOldR | -1 | int(11) | Bases of ancient repeats on query. -1 for undefined |
| tTrf | 0 | int(11) | Bases of tandem repeats on target. -1 for undefined |
| qTrf | 20 | int(11) | Bases of tandem repeats on query. -1 for undefined |