|
|
Database: felCat3 Primary Table: all_mrna Row Count: 4,918   Data last updated: 2020-08-21
Format description: Summary info about a patSpace alignment On download server: MariaDB table dump directory
field | example | SQL type | info | description |
bin | 585 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
matches | 412 | 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 | 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 | 2 | int(10) unsigned | range | Number of inserts in target |
tBaseInsert | 8026 | int(10) unsigned | range | Number of bases inserted in target |
strand | - | char(2) | values | + or - for strand. First character query, second target (optional) |
qName | JV728516 | varchar(255) | values | Query sequence name |
qSize | 4750 | int(10) unsigned | range | Query sequence size |
qStart | 332 | int(10) unsigned | range | Alignment start position in query |
qEnd | 744 | int(10) unsigned | range | Alignment end position in query |
tName | scaffold_100063 | varchar(255) | values | Target sequence name |
tSize | 43920 | int(10) unsigned | range | Target sequence size |
tStart | 5628 | int(10) unsigned | range | Alignment start position in target |
tEnd | 14066 | int(10) unsigned | range | Alignment end position in target |
blockCount | 3 | int(10) unsigned | range | Number of blocks in alignment |
blockSizes | 118,105,189, | longblob | | Size of each block |
qStarts | 4006,4124,4229, | longblob | | Start of each block in query. |
tStarts | 5628,11207,13877, | 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 |
---|
585 | 412 | 0 | 0 | 0 | 0 | 0 | 2 | 8026 | - | JV728516 | 4750 | 332 | 744 | scaffold_100063 | 43920 | 5628 | 14066 | 3 | 118,105,189, | 4006,4124,4229, | 5628,11207,13877, |
585 | 241 | 0 | 0 | 0 | 0 | 0 | 1 | 2127 | - | JV728390 | 1764 | 180 | 421 | scaffold_100240 | 15041 | 6058 | 8426 | 2 | 133,108, | 1343,1476, | 6058,8318, |
585 | 158 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | + | AM489518 | 677 | 517 | 677 | scaffold_100412 | 10214 | 3253 | 3412 | 2 | 32,127, | 517,550, | 3253,3285, |
585 | 183 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | + | AM746385 | 667 | 483 | 667 | scaffold_100412 | 10214 | 3253 | 3437 | 1 | 184, | 483, | 3253, |
585 | 182 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | + | AM746432 | 682 | 495 | 679 | scaffold_100412 | 10214 | 3253 | 3437 | 1 | 184, | 495, | 3253, |
585 | 185 | 2 | 0 | 0 | 0 | 0 | 1 | 1 | + | AM746430 | 670 | 475 | 662 | scaffold_100412 | 10214 | 3253 | 3441 | 2 | 140,47, | 475,615, | 3253,3394, |
585 | 186 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | + | AM746436 | 661 | 473 | 661 | scaffold_100412 | 10214 | 3253 | 3441 | 1 | 188, | 473, | 3253, |
585 | 189 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | + | AM746374 | 455 | 264 | 455 | scaffold_100412 | 10214 | 3253 | 3444 | 1 | 191, | 264, | 3253, |
585 | 188 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | + | AM746425 | 606 | 414 | 606 | scaffold_100412 | 10214 | 3253 | 3445 | 1 | 192, | 414, | 3253, |
585 | 187 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | + | AM746445 | 610 | 418 | 610 | scaffold_100412 | 10214 | 3253 | 3445 | 1 | 192, | 418, | 3253, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|