| field | example | SQL type | info | description |
|---|
| bin | 608 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
| matches | 868 | int(10) unsigned | range | Number of bases that match that aren't repeats |
| misMatches | 0 | int(10) unsigned | range | Number of bases that don't match |
| repMatches | 202 | int(10) unsigned | range | Number of bases that match but are part of repeats |
| nCount | 0 | int(10) unsigned | range | Number of 'N' bases |
| qNumInsert | 0 | int(10) unsigned | range | Number of inserts in query |
| qBaseInsert | 0 | int(10) unsigned | range | Number of bases inserted in query |
| tNumInsert | 0 | int(10) unsigned | range | Number of inserts in target |
| tBaseInsert | 0 | int(10) unsigned | range | Number of bases inserted in target |
| strand | + | char(2) | values | + or - for strand. First character query, second target (optional) |
| qName | ENSMUST00000193812.1 | varchar(255) | values | Query sequence name |
| qSize | 1070 | int(10) unsigned | range | Query sequence size |
| qStart | 0 | int(10) unsigned | range | Alignment start position in query |
| qEnd | 1070 | int(10) unsigned | range | Alignment end position in query |
| tName | chr1 | varchar(255) | values | Target sequence name |
| tSize | 195471971 | int(10) unsigned | range | Target sequence size |
| tStart | 3073252 | int(10) unsigned | range | Alignment start position in target |
| tEnd | 3074322 | int(10) unsigned | range | Alignment end position in target |
| blockCount | 1 | int(10) unsigned | range | Number of blocks in alignment |
| blockSizes | 1070, | longblob | | Size of each block |
| qStarts | 0, | longblob | | Start of each block in query. |
| tStarts | 3073252, | longblob | | Start of each block in target. |