|
|---|
| |
Database: xenTro7 Primary Table: mgcFullMrna Row Count: 8,981 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 | 73 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
| matches | 971 | int(10) unsigned | range | Number of bases that match that aren't repeats |
| misMatches | 9 | 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 | 3 | int(10) unsigned | range | Number of inserts in target |
| tBaseInsert | 733474 | int(10) unsigned | range | Number of bases inserted in target |
| strand | - | char(2) | values | + or - for strand. First character query, second target (optional) |
| qName | BC159143 | varchar(255) | values | Query sequence name |
| qSize | 3063 | int(10) unsigned | range | Query sequence size |
| qStart | 1945 | int(10) unsigned | range | Alignment start position in query |
| qEnd | 2925 | int(10) unsigned | range | Alignment end position in query |
| tName | KB021649 | varchar(255) | values | Target sequence name |
| tSize | 215906545 | int(10) unsigned | range | Target sequence size |
| tStart | 27473 | int(10) unsigned | range | Alignment start position in target |
| tEnd | 761927 | int(10) unsigned | range | Alignment end position in target |
| blockCount | 4 | int(10) unsigned | range | Number of blocks in alignment |
| blockSizes | 97,226,192,465, | longblob | | Size of each block |
| qStarts | 138,235,461,653, | longblob | | Start of each block in query. |
| tStarts | 27473,27663,386798,761462, | longblob | | Start of each block in target. |
|
| |
|
|
|
Connected Tables and Joining Fields
|
|---|
| |
hgFixed.gbCdnaInfo.acc (via mgcFullMrna.qName)
hgFixed.gbSeq.acc (via mgcFullMrna.qName)
hgFixed.imageClone.acc (via mgcFullMrna.qName)
xenTro7.all_mrna.qName (via mgcFullMrna.qName)
xenTro7.mgcGenes.name (via mgcFullMrna.qName)
xenTro7.mrnaOrientInfo.name (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 |
|---|
| 73 | 971 | 9 | 0 | 0 | 0 | 0 | 3 | 733474 | - | BC159143 | 3063 | 1945 | 2925 | KB021649 | 215906545 | 27473 | 761927 | 4 | 97,226,192,465, | 138,235,461,653, | 27473,27663,386798,761462, |
| 585 | 1131 | 2 | 0 | 0 | 0 | 0 | 5 | 22779 | - | BC158298 | 1146 | 0 | 1133 | KB021649 | 215906545 | 36911 | 60823 | 6 | 389,218,119,138,127,142, | 13,402,620,739,877,1004, | 36911,39691,42987,46525,46757,60681, |
| 73 | 3585 | 5 | 2 | 0 | 1 | 38 | 26 | 30826 | - | BC088522 | 3658 | 0 | 3630 | KB021649 | 215906545 | 116442 | 150860 | 27 | 47,264,102,201,90,125,98,153,164,155,118,138,76,149,123,178,78,102,59,121,164,129,169,180,117,222,70, | 28,75,339,441,642,732,857,955,1108,1272,1427,1545,1683,1759,1908,2031,2247,2325,2427,2486,2607,2771,2900,3069,3249,3366,3588, | 116442,116490,116993,117367,120070,123411,125436,125892,127032,128024,129305,129593,129821,130550,131112,131368,141195,141603,14 ... |
| 586 | 1958 | 6 | 170 | 0 | 3 | 15 | 8 | 23448 | + | BC124046 | 2155 | 0 | 2149 | KB021649 | 215906545 | 180511 | 206093 | 11 | 17,12,15,131,240,87,98,135,1093,159,147, | 0,17,29,51,189,429,516,614,749,1843,2002, | 180511,180529,180543,180951,181082,198873,200179,203020,204692,205785,205946, |
| 73 | 1231 | 4 | 17 | 1 | 2 | 877 | 3 | 10967 | - | BC061422 | 2158 | 0 | 2130 | KB021649 | 215906545 | 254345 | 266565 | 5 | 103,406,320,255,169, | 28,145,551,1734,1989, | 254345,254448,254863,263572,266396, |
| 587 | 2358 | 2 | 0 | 0 | 0 | 0 | 5 | 6000 | + | BC075356 | 2504 | 116 | 2476 | KB021649 | 215906545 | 302785 | 311145 | 6 | 41,125,894,189,102,1009, | 116,157,282,1176,1365,1467, | 302785,304033,305246,308050,309356,310136, |
| 587 | 1976 | 0 | 35 | 0 | 0 | 0 | 1 | 700 | + | BC075503 | 2115 | 61 | 2072 | KB021649 | 215906545 | 338519 | 341230 | 2 | 147,1864, | 61,208, | 338519,339366, |
| 587 | 335 | 1 | 19 | 0 | 0 | 0 | 1 | 1351 | - | BC153746 | 1330 | 0 | 355 | KB021649 | 215906545 | 376590 | 378296 | 2 | 237,118, | 975,1212, | 376590,378178, |
| 589 | 3210 | 5 | 0 | 0 | 0 | 0 | 19 | 8769 | - | BC074716 | 3258 | 0 | 3215 | KB021649 | 215906545 | 536053 | 548037 | 20 | 71,15,494,207,155,156,309,213,123,165,113,136,134,103,132,131,143,173,112,130, | 43,114,129,623,830,985,1141,1450,1663,1786,1951,2064,2200,2334,2437,2569,2700,2843,3016,3128, | 536053,536125,536141,536636,537380,537686,538135,538530,538960,539165,539410,539618,539898,540393,540749,541390,542083,543197,54 ... |
| 589 | 2224 | 10 | 29 | 0 | 1 | 1 | 14 | 20917 | - | BC159311 | 2271 | 3 | 2267 | KB021649 | 215906545 | 550520 | 573700 | 15 | 210,165,133,162,41,296,67,167,147,131,157,194,132,91,170, | 4,215,380,513,675,716,1012,1079,1246,1393,1524,1681,1875,2007,2098, | 550520,550733,552363,559993,560587,563004,564359,565035,566265,567378,568302,570287,571001,571887,573530, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server