|
|
Database: anoGam1 Primary Table: all_mrna Row Count: 71,133   Data last updated: 2019-12-06
Format description: Summary info about a patSpace alignment On download server: MariaDB table dump directory
field | example | SQL type | info | description |
bin | 586 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
matches | 438 | int(10) unsigned | range | Number of bases that match that aren't repeats |
misMatches | 6 | int(10) unsigned | range | Number of bases that don't match |
repMatches | 0 | 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 | 5 | int(10) unsigned | range | Number of inserts in target |
tBaseInsert | 1267 | int(10) unsigned | range | Number of bases inserted in target |
strand | + | char(2) | values | + or - for strand. First character query, second target (optional) |
qName | BX009327 | varchar(255) | values | Query sequence name |
qSize | 464 | int(10) unsigned | range | Query sequence size |
qStart | 15 | int(10) unsigned | range | Alignment start position in query |
qEnd | 459 | int(10) unsigned | range | Alignment end position in query |
tName | chr2L | varchar(255) | values | Target sequence name |
tSize | 48795086 | int(10) unsigned | range | Target sequence size |
tStart | 224339 | int(10) unsigned | range | Alignment start position in target |
tEnd | 226050 | int(10) unsigned | range | Alignment end position in target |
blockCount | 6 | int(10) unsigned | range | Number of blocks in alignment |
blockSizes | 13,114,25,109,143,40, | longblob | | Size of each block |
qStarts | 15,28,142,167,276,419, | longblob | | Start of each block in query. |
tStarts | 224339,224353,224752,225672... | longblob | | Start of each block in target. |
|
| |
|
|
Connected Tables and Joining Fields
|
|
Sample Rows
|
|
bin | matches | misMatches | repMatches | nCount | qNumInsert | qBaseInsert | tNumInsert | tBaseInsert | strand | qName | qSize | qStart | qEnd | tName | tSize | tStart | tEnd | blockCount | blockSizes | qStarts | tStarts |
---|
586 | 438 | 6 | 0 | 0 | 0 | 0 | 5 | 1267 | + | BX009327 | 464 | 15 | 459 | chr2L | 48795086 | 224339 | 226050 | 6 | 13,114,25,109,143,40, | 15,28,142,167,276,419, | 224339,224353,224752,225672,225861,226010, |
586 | 267 | 0 | 0 | 0 | 0 | 0 | 4 | 1261 | + | BX036105 | 268 | 1 | 268 | chr2L | 48795086 | 224386 | 225914 | 5 | 9,71,25,109,53, | 1,10,81,106,215, | 224386,224396,224752,225672,225861, |
586 | 259 | 3 | 0 | 0 | 0 | 0 | 3 | 1260 | + | BX027358 | 274 | 0 | 262 | chr2L | 48795086 | 224443 | 225965 | 4 | 24,25,109,104, | 0,24,49,158, | 224443,224752,225672,225861, |
586 | 125 | 0 | 0 | 0 | 0 | 0 | 1 | 895 | + | BX032624 | 127 | 2 | 127 | chr2L | 48795086 | 224751 | 225771 | 2 | 26,99, | 2,28, | 224751,225672, |
586 | 315 | 2 | 0 | 0 | 1 | 1 | 2 | 176 | + | BX034813 | 318 | 0 | 318 | chr2L | 48795086 | 225740 | 226233 | 4 | 41,151,98,27, | 0,41,193,291, | 225740,225861,226012,226206, |
586 | 864 | 8 | 0 | 0 | 1 | 1 | 4 | 170 | - | BX009328 | 887 | 12 | 885 | chr2L | 48795086 | 225864 | 226906 | 6 | 33,207,48,490,90,4, | 2,35,242,291,781,871, | 225864,225903,226206,226254,226811,226902, |
586 | 631 | 1 | 0 | 0 | 0 | 0 | 2 | 68 | - | BX034814 | 645 | 2 | 634 | chr2L | 48795086 | 226203 | 226903 | 3 | 541,85,6, | 11,552,637, | 226203,226811,226897, |
586 | 375 | 1 | 0 | 0 | 0 | 0 | 1 | 67 | - | BX027359 | 394 | 5 | 381 | chr2L | 48795086 | 226461 | 226904 | 2 | 283,93, | 13,296, | 226461,226811, |
586 | 420 | 0 | 0 | 0 | 0 | 0 | 1 | 67 | - | BX036106 | 424 | 4 | 424 | chr2L | 48795086 | 226461 | 226948 | 2 | 283,137, | 0,283, | 226461,226811, |
586 | 936 | 6 | 0 | 0 | 1 | 1 | 3 | 146 | + | BX016808 | 948 | 0 | 943 | chr2L | 48795086 | 226697 | 227785 | 5 | 47,28,753,84,30, | 0,47,76,829,913, | 226697,226811,226839,227670,227755, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|