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