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