|
|
Database: panTro6 Primary Table: all_mrna Row Count: 4,101   Data last updated: 2018-05-30
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 | 1088 | 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 | 9 | int(10) unsigned | range | Number of inserts in target |
tBaseInsert | 10853 | int(10) unsigned | range | Number of bases inserted in target |
strand | - | char(2) | values | + or - for strand. First character query, second target (optional) |
qName | AK305957 | varchar(255) | values | Query sequence name |
qSize | 2116 | int(10) unsigned | range | Query sequence size |
qStart | 0 | int(10) unsigned | range | Alignment start position in query |
qEnd | 1088 | int(10) unsigned | range | Alignment end position in query |
tName | chr1 | varchar(255) | values | Target sequence name |
tSize | 224244399 | int(10) unsigned | range | Target sequence size |
tStart | 353 | int(10) unsigned | range | Alignment start position in target |
tEnd | 12294 | int(10) unsigned | range | Alignment end position in target |
blockCount | 10 | int(10) unsigned | range | Number of blocks in alignment |
blockSizes | 86,190,65,139,35,99,229,74,... | longblob | | Size of each block |
qStarts | 1028,1114,1304,1369,1508,15... | longblob | | Start of each block in query. |
tStarts | 353,579,1170,1759,2339,2455... | longblob | | Start of each block in target. |
|
| |
|
|
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 | 1088 | 0 | 0 | 0 | 0 | 0 | 9 | 10853 | - | AK305957 | 2116 | 0 | 1088 | chr1 | 224244399 | 353 | 12294 | 10 | 86,190,65,139,35,99,229,74,98,73, | 1028,1114,1304,1369,1508,1543,1642,1871,1945,2043, | 353,579,1170,1759,2339,2455,6196,7387,7927,12221, |
585 | 1092 | 1 | 0 | 0 | 0 | 0 | 9 | 10853 | - | AK306018 | 2127 | 0 | 1093 | chr1 | 224244399 | 353 | 12299 | 10 | 86,190,65,139,35,99,229,74,98,78, | 1034,1120,1310,1375,1514,1549,1648,1877,1951,2049, | 353,579,1170,1759,2339,2455,6196,7387,7927,12221, |
585 | 2602 | 9 | 0 | 0 | 0 | 0 | 12 | 4493 | - | AK305526 | 2631 | 5 | 2616 | chr1 | 224244399 | 22943 | 30047 | 13 | 1260,207,100,67,132,153,68,77,140,70,94,139,104, | 15,1275,1482,1582,1649,1781,1934,2002,2079,2219,2289,2383,2522, | 22943,25731,26023,26124,26275,27040,27335,27489,27908,28117,28280,29557,29943, |
585 | 2012 | 1 | 0 | 0 | 0 | 0 | 14 | 10999 | - | AY665280 | 2013 | 0 | 2013 | chr1 | 224244399 | 23829 | 36841 | 15 | 374,207,168,132,78,68,77,140,70,94,139,104,122,70,170, | 0,374,581,749,881,959,1027,1104,1244,1314,1408,1547,1651,1773,1843, | 23829,25731,26023,26275,27115,27335,27489,27908,28117,28280,29557,29943,30253,30579,36671, |
585 | 2304 | 1 | 0 | 0 | 0 | 0 | 9 | 3583 | - | AK306494 | 2322 | 2 | 2307 | chr1 | 224244399 | 39619 | 45507 | 10 | 944,81,77,40,156,471,102,303,24,107, | 15,959,1040,1117,1157,1313,1784,1886,2189,2213, | 39619,40782,40964,41127,41288,41616,42178,42384,43612,45400, |
585 | 1707 | 5 | 0 | 0 | 0 | 0 | 2 | 827 | + | AK306758 | 1724 | 0 | 1712 | chr1 | 224244399 | 89325 | 91864 | 3 | 138,92,1482, | 0,138,230, | 89325,89935,90382, |
9 | 1191 | 0 | 0 | 0 | 0 | 0 | 9 | 65561 | - | AK306081 | 1245 | 0 | 1191 | chr1 | 224244399 | 997940 | 1064692 | 10 | 327,47,80,134,167,124,111,97,88,16, | 54,381,428,508,642,809,933,1044,1141,1229, | 997940,1000809,1012974,1013222,1036137,1037298,1051192,1053172,1063849,1064676, |
9 | 1786 | 3 | 0 | 0 | 0 | 0 | 13 | 70806 | - | AK306595 | 1843 | 0 | 1789 | chr1 | 224244399 | 997940 | 1070535 | 14 | 327,47,80,134,167,124,111,97,88,91,111,99,72,241, | 54,381,428,508,642,809,933,1044,1141,1229,1320,1431,1530,1602, | 997940,1000809,1012974,1013222,1036137,1037298,1051192,1053172,1063849,1064676,1066268,1067087,1068764,1070294, |
9 | 1828 | 1 | 0 | 0 | 0 | 0 | 13 | 70806 | - | AK305026 | 1855 | 0 | 1829 | chr1 | 224244399 | 997940 | 1070575 | 14 | 327,47,80,134,167,124,111,97,88,91,111,99,72,281, | 26,353,400,480,614,781,905,1016,1113,1201,1292,1403,1502,1574, | 997940,1000809,1012974,1013222,1036137,1037298,1051192,1053172,1063849,1064676,1066268,1067087,1068764,1070294, |
74 | 3064 | 2 | 0 | 0 | 0 | 0 | 24 | 39112 | - | AK305700 | 3085 | 0 | 3066 | chr1 | 224244399 | 1283499 | 1325677 | 25 | 450,77,96,66,134,120,59,104,84,99,129,94,217,90,135,62,119,96,81,162,60,78,191,138,125, | 19,469,546,642,708,842,962,1021,1125,1209,1308,1437,1531,1748,1838,1973,2035,2154,2250,2331,2493,2553,2631,2822,2960, | 1283499,1284434,1284809,1285530,1285708,1286691,1287335,1287740,1288226,1288959,1289511,1291202,1291649,1296895,1297158,1298569, ... |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|