|
|---|
| |
Database: danRer10 Primary Table: mgcFullMrna Row Count: 16,940 Data last updated: 2020-01-27
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 | 512 | 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 | 5 | int(10) unsigned | range | Number of inserts in target |
| tBaseInsert | 4602 | int(10) unsigned | range | Number of bases inserted in target |
| strand | - | char(2) | values | + or - for strand. First character query, second target (optional) |
| qName | BC059530 | varchar(255) | values | Query sequence name |
| qSize | 533 | int(10) unsigned | range | Query sequence size |
| qStart | 0 | int(10) unsigned | range | Alignment start position in query |
| qEnd | 512 | int(10) unsigned | range | Alignment end position in query |
| tName | chr1 | varchar(255) | values | Target sequence name |
| tSize | 58871917 | int(10) unsigned | range | Target sequence size |
| tStart | 6647 | int(10) unsigned | range | Alignment start position in target |
| tEnd | 11761 | int(10) unsigned | range | Alignment end position in target |
| blockCount | 6 | int(10) unsigned | range | Number of blocks in alignment |
| blockSizes | 113,64,137,111,76,11, | longblob | | Size of each block |
| qStarts | 21,134,198,335,446,522, | longblob | | Start of each block in query. |
| tStarts | 6647,6891,9557,10080,11549,... | longblob | | Start of each block in target. |
|
| |
|
|
|
Connected Tables and Joining Fields
|
|---|
| |
danRer10.all_mrna.qName (via mgcFullMrna.qName)
danRer10.mgcGenes.name (via mgcFullMrna.qName)
danRer10.mrnaOrientInfo.name (via mgcFullMrna.qName)
hgFixed.gbCdnaInfo.acc (via mgcFullMrna.qName)
hgFixed.gbSeq.acc (via mgcFullMrna.qName)
hgFixed.imageClone.acc (via mgcFullMrna.qName)
| |
|
|
|
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 | 512 | 0 | 0 | 0 | 0 | 0 | 5 | 4602 | - | BC059530 | 533 | 0 | 512 | chr1 | 58871917 | 6647 | 11761 | 6 | 113,64,137,111,76,11, | 21,134,198,335,446,522, | 6647,6891,9557,10080,11549,11750, |
| 585 | 2203 | 18 | 0 | 0 | 1 | 8 | 10 | 2166 | + | BC053114 | 2260 | 0 | 2229 | chr1 | 58871917 | 11986 | 16373 | 12 | 48,149,159,95,121,164,159,113,439,76,561,137, | 0,48,197,356,451,572,736,895,1008,1447,1523,2092, | 11986,12372,12794,13033,13211,13503,14031,14289,14698,15351,15675,16236, |
| 585 | 1412 | 11 | 0 | 0 | 1 | 3 | 11 | 5080 | + | BC153556 | 1450 | 0 | 1426 | chr1 | 58871917 | 27827 | 34330 | 13 | 128,153,93,66,126,82,92,134,106,159,74,130,80, | 0,128,281,374,440,566,648,740,874,980,1139,1213,1346, | 27827,29800,30079,31228,31399,31658,31813,32109,32377,32982,33505,34120,34250, |
| 585 | 1397 | 10 | 0 | 0 | 1 | 21 | 11 | 5080 | + | BC093351 | 1448 | 1 | 1429 | chr1 | 58871917 | 27843 | 34330 | 13 | 112,153,93,66,126,82,92,134,106,159,74,129,81, | 1,113,266,359,425,551,633,725,859,965,1124,1198,1348, | 27843,29800,30079,31228,31399,31658,31813,32109,32377,32982,33505,34120,34249, |
| 585 | 1270 | 9 | 0 | 0 | 0 | 0 | 11 | 5080 | + | BC164450 | 1348 | 34 | 1313 | chr1 | 58871917 | 27886 | 34245 | 12 | 69,153,93,66,126,82,92,134,106,159,74,125, | 34,103,256,349,415,541,623,715,849,955,1114,1188, | 27886,29800,30079,31228,31399,31658,31813,32109,32377,32982,33505,34120, |
| 585 | 847 | 6 | 0 | 0 | 0 | 0 | 5 | 1605 | + | BC092729 | 912 | 0 | 853 | chr1 | 58871917 | 36733 | 39191 | 6 | 145,238,152,119,87,112, | 0,145,383,535,654,741, | 36733,37983,38492,38757,38980,39079, |
| 585 | 2143 | 12 | 0 | 0 | 1 | 1 | 9 | 3046 | - | BC056707 | 2199 | 0 | 2156 | chr1 | 58871917 | 39324 | 44525 | 10 | 111,614,121,188,322,155,84,223,143,194, | 43,155,769,890,1078,1400,1555,1639,1862,2005, | 39324,39447,40318,40796,41250,41933,42172,42478,43287,44331, |
| 585 | 2207 | 0 | 0 | 0 | 0 | 0 | 7 | 2786 | - | BC053314 | 2267 | 0 | 2207 | chr1 | 58871917 | 44838 | 49831 | 8 | 712,584,129,147,120,150,171,194, | 60,772,1356,1485,1632,1752,1902,2073, | 44838,45787,47420,47660,47952,48434,48889,49637, |
| 585 | 2436 | 43 | 0 | 0 | 5 | 29 | 12 | 6862 | + | BC139693 | 2538 | 0 | 2508 | chr1 | 58871917 | 109797 | 119138 | 16 | 131,164,25,114,147,92,121,647,67,150,115,371,24,39,148,124, | 0,131,295,320,434,581,673,794,1441,1509,1659,1781,2162,2194,2236,2384, | 109797,110643,111175,111530,112244,115047,115237,117070,117731,117806,118302,118425,118796,118820,118859,119014, |
| 585 | 1792 | 17 | 0 | 0 | 0 | 0 | 7 | 3478 | + | BC095023 | 1828 | 0 | 1809 | chr1 | 58871917 | 119959 | 125246 | 8 | 77,164,25,117,141,122,121,1042, | 0,77,241,266,383,524,646,767, | 119959,120112,120863,120961,121701,122110,122328,124204, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server