|
|
Database: ce6 Primary Table: all_mrna Row Count: 9,972   Data last updated: 2020-08-20
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 | 2504 | 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 | 11 | int(10) unsigned | range | Number of inserts in target |
tBaseInsert | 6710 | int(10) unsigned | range | Number of bases inserted in target |
strand | + | char(2) | values | + or - for strand. First character query, second target (optional) |
qName | AB096875 | varchar(255) | values | Query sequence name |
qSize | 2504 | int(10) unsigned | range | Query sequence size |
qStart | 0 | int(10) unsigned | range | Alignment start position in query |
qEnd | 2504 | int(10) unsigned | range | Alignment end position in query |
tName | chrI | varchar(255) | values | Target sequence name |
tSize | 15072421 | int(10) unsigned | range | Target sequence size |
tStart | 71857 | int(10) unsigned | range | Alignment start position in target |
tEnd | 81071 | int(10) unsigned | range | Alignment end position in target |
blockCount | 12 | int(10) unsigned | range | Number of blocks in alignment |
blockSizes | 75,80,251,77,162,184,320,16... | longblob | | Size of each block |
qStarts | 0,75,155,406,483,645,829,11... | longblob | | Start of each block in query. |
tStarts | 71857,72510,72646,72940,736... | 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 | 2504 | 0 | 0 | 0 | 0 | 0 | 11 | 6710 | + | AB096875 | 2504 | 0 | 2504 | chrI | 15072421 | 71857 | 81071 | 12 | 75,80,251,77,162,184,320,162,205,87,135,766, | 0,75,155,406,483,645,829,1149,1311,1516,1603,1738, | 71857,72510,72646,72940,73604,74624,75170,75950,76948,77712,79312,80305, |
585 | 385 | 5 | 0 | 0 | 0 | 0 | 2 | 99 | - | U68258 | 405 | 7 | 397 | chrI | 15072421 | 109570 | 110059 | 3 | 213,122,55, | 8,221,343, | 109570,109834,110004, |
73 | 1475 | 3 | 0 | 0 | 0 | 0 | 5 | 3637 | + | U67864 | 1483 | 5 | 1483 | chrI | 15072421 | 128694 | 133809 | 6 | 202,180,167,451,82,396, | 5,207,387,554,1005,1087, | 128694,128944,129166,132102,132611,133413, |
586 | 4492 | 2 | 0 | 0 | 0 | 0 | 18 | 3703 | - | AF229855 | 4494 | 0 | 4494 | chrI | 15072421 | 146622 | 154819 | 19 | 126,132,678,211,125,200,170,298,298,449,157,214,292,252,204,390,159,78,61, | 0,126,258,936,1147,1272,1472,1642,1940,2238,2687,2844,3058,3350,3602,3806,4196,4355,4433, | 146622,146792,147053,147783,148098,149059,149302,149519,150390,150733,151226,151460,152068,152406,152705,152955,153394,153602,15 ... |
587 | 1695 | 0 | 0 | 0 | 0 | 0 | 6 | 3129 | - | DQ904352 | 1695 | 0 | 1695 | chrI | 15072421 | 343543 | 348367 | 7 | 109,140,810,142,182,252,60, | 0,109,249,1059,1201,1383,1635, | 343543,343896,345023,346377,346563,346795,348307, |
642 | 977 | 1 | 0 | 0 | 0 | 0 | 3 | 168 | + | LC127219 | 994 | 0 | 978 | chrIV | 17493785 | 7576164 | 7577310 | 4 | 195,67,122,594, | 0,195,262,384, | 7576164,7576432,7576545,7576716, |
588 | 4030 | 4 | 21 | 0 | 2 | 2 | 14 | 13528 | + | AF348166 | 4077 | 20 | 4077 | chrI | 15072421 | 443999 | 461582 | 17 | 113,123,91,75,138,110,278,167,136,176,139,1386,4,45,444,568,62, | 20,133,256,347,422,560,670,948,1115,1251,1427,1566,2952,2957,3002,3446,4015, | 443999,444256,444996,446710,446916,450199,450484,451297,455358,455548,456858,457238,459571,459575,459621,460952,461520, |
589 | 854 | 0 | 7 | 0 | 0 | 0 | 5 | 3272 | + | FJ174666 | 861 | 0 | 861 | chrI | 15072421 | 557433 | 561566 | 6 | 142,140,157,162,97,163, | 0,142,282,439,601,698, | 557433,558406,559509,559708,560704,561403, |
589 | 1310 | 0 | 303 | 0 | 0 | 0 | 3 | 2628 | + | FJ174668 | 1613 | 0 | 1613 | chrI | 15072421 | 557433 | 561674 | 4 | 142,140,361,970, | 0,142,282,643, | 557433,558406,559509,560704, |
589 | 1255 | 0 | 303 | 0 | 0 | 0 | 4 | 2670 | + | FJ174667 | 1558 | 0 | 1558 | chrI | 15072421 | 557446 | 561674 | 5 | 129,140,157,162,970, | 0,129,269,426,588, | 557446,558406,559509,559708,560704, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|