| field | example | SQL type | info | description |
|---|
| bin | 76 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
| matches | 3205 | 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 | 429 | 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 | 2 | int(10) unsigned | range | Number of inserts in target |
| tBaseInsert | 453383 | int(10) unsigned | range | Number of bases inserted in target |
| strand | - | char(2) | values | + or - for strand. First character query, second target (optional) |
| qName | NM_001011874 | varchar(255) | values | Query sequence name |
| qSize | 3652 | int(10) unsigned | range | Query sequence size |
| qStart | 0 | int(10) unsigned | range | Alignment start position in query |
| qEnd | 3634 | 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 | 3214481 | int(10) unsigned | range | Alignment start position in target |
| tEnd | 3671498 | int(10) unsigned | range | Alignment end position in target |
| blockCount | 3 | int(10) unsigned | range | Number of blocks in alignment |
| blockSizes | 2487,200,947, | longblob | | Size of each block |
| qStarts | 18,2505,2705, | longblob | | Start of each block in query. |
| tStarts | 3214481,3421701,3670551, | longblob | | Start of each block in target. |