Schema for wRi Alignments - Regions with Sequence Similarity to wRi Genome Assembly
|
|
Database: dm6 Primary Table: wRi1_megablast Row Count: 55
field | example | SQL type | info |
bin | 631 | smallint(5) unsigned | range |
matches | 415 | int(10) unsigned | range |
misMatches | 216 | int(10) unsigned | range |
repMatches | 0 | int(10) unsigned | range |
nCount | 0 | int(10) unsigned | range |
qNumInsert | 2 | int(10) unsigned | range |
qBaseInsert | 2 | int(10) unsigned | range |
tNumInsert | 2 | int(10) unsigned | range |
tBaseInsert | 2 | int(10) unsigned | range |
strand | - | char(2) | values |
qName | CP001391 | varchar(255) | values |
qSize | 1445873 | int(10) unsigned | range |
qStart | 995742 | int(10) unsigned | range |
qEnd | 996375 | int(10) unsigned | range |
tName | chr2L | varchar(255) | values |
tSize | 23513712 | int(10) unsigned | range |
tStart | 6061203 | int(10) unsigned | range |
tEnd | 6061836 | int(10) unsigned | range |
blockCount | 5 | int(10) unsigned | range |
blockSizes | 60,8,314,7,242, | longblob | |
qStarts | 449498,449559,449567,449882... | longblob | |
tStarts | 6061203,6061263,6061272,606... | longblob | |
|
| |
|
|
Sample Rows
|
|
bin | matches | misMatches | repMatches | nCount | qNumInsert | qBaseInsert | tNumInsert | tBaseInsert | strand | qName | qSize | qStart | qEnd | tName | tSize | tStart | tEnd | blockCount | blockSizes | qStarts | tStarts |
---|
631 | 415 | 216 | 0 | 0 | 2 | 2 | 2 | 2 | - | CP001391 | 1445873 | 995742 | 996375 | chr2L | 23513712 | 6061203 | 6061836 | 5 | 60,8,314,7,242, | 449498,449559,449567,449882,449889, | 6061203,6061263,6061272,6061586,6061594, |
662 | 200 | 88 | 0 | 0 | 0 | 0 | 0 | 0 | - | CP001391 | 1445873 | 266524 | 266812 | chr2L | 23513712 | 10190177 | 10190465 | 1 | 288, | 1179061, | 10190177, |
664 | 261 | 108 | 0 | 0 | 3 | 8 | 3 | 8 | - | CP001391 | 1445873 | 511090 | 511467 | chr2L | 23513712 | 10357051 | 10357428 | 7 | 85,4,9,21,155,3,92, | 934406,934491,934495,934508,934532,934687,934691, | 10357051,10357139,10357147,10357156,10357177,10357333,10357336, |
676 | 380 | 183 | 0 | 0 | 5 | 10 | 5 | 7 | - | CP001391 | 1445873 | 1017239 | 1017812 | chr2L | 23513712 | 12000141 | 12000711 | 11 | 90,6,113,8,17,3,233,14,7,4,68, | 428061,428151,428158,428271,428281,428300,428303,428539,428553,428560,428566, | 12000141,12000232,12000238,12000353,12000361,12000378,12000383,12000616,12000631,12000639,12000643, |
693 | 228 | 112 | 0 | 0 | 1 | 1 | 1 | 1 | + | CP001391 | 1445873 | 954937 | 955278 | chr2R | 25286936 | 14253745 | 14254086 | 3 | 257,6,77, | 954937,955194,955201, | 14253745,14254003,14254009, |
693 | 92 | 36 | 0 | 0 | 0 | 0 | 0 | 0 | + | CP001391 | 1445873 | 955873 | 956001 | chr2R | 25286936 | 14254852 | 14254980 | 1 | 128, | 955873, | 14254852, |
719 | 467 | 251 | 0 | 0 | 3 | 4 | 5 | 10 | + | CP001391 | 1445873 | 995445 | 996167 | chr2R | 25286936 | 17596192 | 17596920 | 9 | 67,13,3,8,113,11,322,20,161, | 995445,995514,995527,995530,995538,995651,995663,995985,996006, | 17596192,17596259,17596275,17596281,17596291,17596405,17596416,17596739,17596759, |
719 | 135 | 59 | 0 | 0 | 1 | 1 | 1 | 1 | + | CP001391 | 1445873 | 996315 | 996510 | chr2R | 25286936 | 17597068 | 17597263 | 3 | 48,5,141, | 996315,996364,996369, | 17597068,17597116,17597122, |
732 | 700 | 404 | 0 | 0 | 4 | 10 | 5 | 13 | + | CP001391 | 1445873 | 329971 | 331085 | chr2R | 25286936 | 19393115 | 19394232 | 10 | 120,134,11,19,7,290,10,104,9,400, | 329971,330091,330225,330239,330261,330268,330559,330569,330676,330685, | 19393115,19393238,19393376,19393387,19393406,19393415,19393705,19393716,19393820,19393832, |
756 | 114 | 47 | 0 | 0 | 0 | 0 | 0 | 0 | - | CP001391 | 1445873 | 1032159 | 1032320 | chr2R | 25286936 | 22493340 | 22493501 | 1 | 161, | 413553, | 22493340, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
wRi Alignments (wRi1_alignments) Track Description
|
|
|