Schema for wMel Alignments - Regions with Sequence Similarity to wMel Genome Assembly
|
|
Database: dm6 Primary Table: wMel1_megablast Row Count: 54
field | example | SQL type | info |
bin | 631 | smallint(5) unsigned | range |
matches | 417 | int(10) unsigned | range |
misMatches | 220 | 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 | AE017196 | varchar(255) | values |
qSize | 1267782 | int(10) unsigned | range |
qStart | 935850 | int(10) unsigned | range |
qEnd | 936489 | int(10) unsigned | range |
tName | chr2L | varchar(255) | values |
tSize | 23513712 | int(10) unsigned | range |
tStart | 6061203 | int(10) unsigned | range |
tEnd | 6061842 | int(10) unsigned | range |
blockCount | 5 | int(10) unsigned | range |
blockSizes | 60,8,314,5,250, | longblob | |
qStarts | 331293,331354,331362,331677... | 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 | 417 | 220 | 0 | 0 | 2 | 2 | 2 | 2 | - | AE017196 | 1267782 | 935850 | 936489 | chr2L | 23513712 | 6061203 | 6061842 | 5 | 60,8,314,5,250, | 331293,331354,331362,331677,331682, | 6061203,6061263,6061272,6061586,6061592, |
662 | 201 | 87 | 0 | 0 | 0 | 0 | 0 | 0 | + | AE017196 | 1267782 | 472364 | 472652 | chr2L | 23513712 | 10190177 | 10190465 | 1 | 288, | 472364, | 10190177, |
664 | 262 | 107 | 0 | 0 | 3 | 8 | 3 | 8 | - | AE017196 | 1267782 | 300702 | 301079 | chr2L | 23513712 | 10357051 | 10357428 | 7 | 85,4,9,21,155,3,92, | 966703,966788,966792,966805,966829,966984,966988, | 10357051,10357139,10357147,10357156,10357177,10357333,10357336, |
676 | 377 | 188 | 0 | 0 | 4 | 8 | 4 | 5 | - | AE017196 | 1267782 | 954443 | 955016 | chr2L | 23513712 | 12000141 | 12000711 | 9 | 90,6,116,5,255,14,7,4,68, | 312766,312856,312863,312979,312986,313244,313258,313265,313271, | 12000141,12000232,12000238,12000356,12000361,12000616,12000631,12000639,12000643, |
693 | 228 | 112 | 0 | 0 | 1 | 1 | 1 | 1 | + | AE017196 | 1267782 | 892064 | 892405 | chr2R | 25286936 | 14253745 | 14254086 | 3 | 257,6,77, | 892064,892321,892328, | 14253745,14254003,14254009, |
693 | 91 | 37 | 0 | 0 | 0 | 0 | 0 | 0 | + | AE017196 | 1267782 | 893000 | 893128 | chr2R | 25286936 | 14254852 | 14254980 | 1 | 128, | 893000, | 14254852, |
719 | 467 | 251 | 0 | 0 | 3 | 4 | 5 | 10 | + | AE017196 | 1267782 | 935559 | 936281 | chr2R | 25286936 | 17596192 | 17596920 | 9 | 67,13,3,8,113,11,323,19,161, | 935559,935628,935641,935644,935652,935765,935777,936100,936120, | 17596192,17596259,17596275,17596281,17596291,17596405,17596416,17596740,17596759, |
719 | 134 | 60 | 0 | 0 | 1 | 1 | 1 | 1 | + | AE017196 | 1267782 | 936429 | 936624 | chr2R | 25286936 | 17597068 | 17597263 | 3 | 48,5,141, | 936429,936478,936483, | 17597068,17597116,17597122, |
732 | 709 | 393 | 0 | 0 | 5 | 12 | 6 | 15 | - | AE017196 | 1267782 | 418482 | 419596 | chr2R | 25286936 | 19393115 | 19394232 | 12 | 120,134,11,19,7,58,6,224,10,103,10,400, | 848186,848306,848440,848454,848476,848483,848541,848549,848774,848784,848890,848900, | 19393115,19393238,19393376,19393387,19393406,19393415,19393475,19393481,19393705,19393716,19393819,19393832, |
756 | 135 | 59 | 0 | 0 | 0 | 0 | 0 | 0 | - | AE017196 | 1267782 | 969315 | 969509 | chr2R | 25286936 | 22493307 | 22493501 | 1 | 194, | 298273, | 22493307, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
wMel Alignments (wMel1_alignments) Track Description
|
|
|