| field | example | SQL type | info | description |
|---|
| bin | 658 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
| matches | 596 | int(10) unsigned | range | Number of bases that match that aren't repeats |
| misMatches | 2 | int(10) unsigned | range | Number of bases that don't match |
| repMatches | 118 | int(10) unsigned | range | Number of bases that match but are part of repeats |
| nCount | 1 | int(10) unsigned | range | Number of 'N' bases |
| qNumInsert | 1 | int(10) unsigned | range | Number of inserts in query |
| qBaseInsert | 1 | 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 | DQ386479 | varchar(255) | values | Query sequence name |
| qSize | 718 | int(10) unsigned | range | Query sequence size |
| qStart | 0 | int(10) unsigned | range | Alignment start position in query |
| qEnd | 718 | int(10) unsigned | range | Alignment end position in query |
| tName | JH739889 | varchar(255) | values | Target sequence name |
| tSize | 22321128 | int(10) unsigned | range | Target sequence size |
| tStart | 9579351 | int(10) unsigned | range | Alignment start position in target |
| tEnd | 9580068 | int(10) unsigned | range | Alignment end position in target |
| blockCount | 2 | int(10) unsigned | range | Number of blocks in alignment |
| blockSizes | 641,76, | longblob | | Size of each block |
| qStarts | 0,642, | longblob | | Start of each block in query. |
| tStarts | 9579351,9579992, | longblob | | Start of each block in target. |
US Server