|
|---|
| |
Database: caePb1 Primary Table: xenoMrna Row Count: 2,969,697 Data last updated: 2016-02-16
On download server: MariaDB table dump directory
| field | example | SQL type |
|---|
| bin | 585 | smallint(5) unsigned |
| matches | 760 | int(10) unsigned |
| misMatches | 178 | int(10) unsigned |
| repMatches | 0 | int(10) unsigned |
| nCount | 0 | int(10) unsigned |
| qNumInsert | 5 | int(10) unsigned |
| qBaseInsert | 67 | int(10) unsigned |
| tNumInsert | 6 | int(10) unsigned |
| tBaseInsert | 1087 | int(10) unsigned |
| strand | +- | char(2) |
| qName | AF150958 | varchar(255) |
| qSize | 1089 | int(10) unsigned |
| qStart | 84 | int(10) unsigned |
| qEnd | 1089 | int(10) unsigned |
| tName | chrUn | varchar(255) |
| tSize | 207333000 | int(10) unsigned |
| tStart | 19625 | int(10) unsigned |
| tEnd | 21650 | int(10) unsigned |
| blockCount | 7 | int(10) unsigned |
| blockSizes | 237,73,146,126,143,120,93, | longblob |
| qStarts | 84,324,397,549,676,831,996, | longblob |
| tStarts | 207311350,207311640,2073120... | longblob |
|
| |
|
|
|
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 | 760 | 178 | 0 | 0 | 5 | 67 | 6 | 1087 | +- | AF150958 | 1089 | 84 | 1089 | chrUn | 207333000 | 19625 | 21650 | 7 | 237,73,146,126,143,120,93, | 84,324,397,549,676,831,996, | 207311350,207311640,207312054,207312630,207312865,207313071,207313282, |
| 585 | 62 | 28 | 0 | 0 | 0 | 0 | 0 | 0 | +- | M19971 | 1378 | 837 | 927 | chrUn | 207333000 | 57635 | 57725 | 1 | 90, | 837, | 207275275, |
| 585 | 1437 | 336 | 0 | 49 | 5 | 212 | 17 | 2913 | +- | AF166168 | 2234 | 0 | 2034 | chrUn | 207333000 | 78791 | 83526 | 18 | 99,93,108,138,144,168,88,84,77,274,2,208,135,95,8,61,4,36, | 0,99,192,306,444,588,827,915,1008,1085,1359,1361,1590,1830,1925,1933,1994,1998, | 207249474,207249834,207249977,207250661,207250846,207251096,207251454,207251851,207251993,207252118,207252425,207252609,20725283 ... |
| 585 | 1478 | 355 | 0 | 49 | 7 | 461 | 17 | 2853 | +- | AF166167 | 2527 | 0 | 2343 | chrUn | 207333000 | 78791 | 83526 | 18 | 99,93,108,138,144,168,88,84,77,274,2,208,135,95,8,62,51,48, | 0,99,192,306,444,588,827,915,1008,1085,1359,1361,1590,1830,1925,1933,2076,2295, | 207249474,207249834,207249977,207250661,207250846,207251096,207251454,207251851,207251993,207252118,207252425,207252609,20725283 ... |
| 585 | 66 | 36 | 0 | 0 | 0 | 0 | 0 | 0 | +- | AB170093 | 1414 | 855 | 957 | chrUn | 207333000 | 91067 | 91169 | 1 | 102, | 855, | 207241831, |
| 585 | 66 | 36 | 0 | 0 | 0 | 0 | 0 | 0 | +- | AB173982 | 1611 | 857 | 959 | chrUn | 207333000 | 91067 | 91169 | 1 | 102, | 857, | 207241831, |
| 585 | 66 | 36 | 0 | 0 | 0 | 0 | 0 | 0 | +- | AF065389 | 1405 | 812 | 914 | chrUn | 207333000 | 91067 | 91169 | 1 | 102, | 812, | 207241831, |
| 585 | 66 | 36 | 0 | 0 | 0 | 0 | 0 | 0 | +- | AF121344 | 3175 | 852 | 954 | chrUn | 207333000 | 91067 | 91169 | 1 | 102, | 852, | 207241831, |
| 585 | 66 | 36 | 0 | 0 | 0 | 0 | 0 | 0 | +- | AK013350 | 3141 | 802 | 904 | chrUn | 207333000 | 91067 | 91169 | 1 | 102, | 802, | 207241831, |
| 585 | 66 | 36 | 0 | 0 | 0 | 0 | 0 | 0 | +- | AK015705 | 1116 | 559 | 661 | chrUn | 207333000 | 91067 | 91169 | 1 | 102, | 559, | 207241831, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server