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. |