Schema for xenoMrna
  Database: canFam1    Primary Table: xenoMrna    Row Count: 6,535,821   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 9smallint(5) unsigned
matches 1300int(10) unsigned
misMatches 108int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 16int(10) unsigned
qBaseInsert 606int(10) unsigned
tNumInsert 11int(10) unsigned
tBaseInsert 137697int(10) unsigned
strand ++char(2)
qName AK055938varchar(255)
qSize 2185int(10) unsigned
qStart 164int(10) unsigned
qEnd 2178int(10) unsigned
tName chr1varchar(255)
tSize 124897793int(10) unsigned
tStart 3094723int(10) unsigned
tEnd 3233828int(10) unsigned
blockCount 19int(10) unsigned
blockSizes 24,276,19,65,45,111,42,63,3...longblob
qStarts 164,659,936,961,1038,1083,1...longblob
tStarts 3094723,3232082,3232358,323...longblob

Connected Tables and Joining Fields
        canFam1.all_est.qName (via xenoMrna.qName)
      canFam1.all_mrna.qName (via xenoMrna.qName)
      canFam1.refGene.name (via xenoMrna.qName)
      canFam1.refSeqAli.qName (via xenoMrna.qName)
      canFam1.xenoRefFlat.name (via xenoMrna.qName)
      canFam1.xenoRefGene.name (via xenoMrna.qName)
      canFam1.xenoRefSeqAli.qName (via xenoMrna.qName)
      hgFixed.gbCdnaInfo.acc (via xenoMrna.qName)
      hgFixed.gbMiscDiff.acc (via xenoMrna.qName)
      hgFixed.gbSeq.acc (via xenoMrna.qName)
      hgFixed.gbWarn.acc (via xenoMrna.qName)
      hgFixed.imageClone.acc (via xenoMrna.qName)

Sample Rows
 
binmatchesmisMatchesrepMatchesnCountqNumInsertqBaseInserttNumInserttBaseInsertstrandqNameqSizeqStartqEndtNametSizetStarttEndblockCountblockSizesqStartstStarts
91300108001660611137697++AK05593821851642178chr1124897793309472332338281924,276,19,65,45,111,42,63,32,108,58,138,94,94,58,54,45,10,72,164,659,936,961,1038,1083,1196,1242,1325,1364,1477,1555,1698,1822,1917,1976,2034,2079,2106,3094723,3232082,3232358,3232377,3232447,3232493,3232610,3232652,3232733,3232765,3233087,3233178,3233316,3233465,3233559,3233617, ...
9242130002283952767374+-BC0330083241553193chr11248977933116414318653128111,73,117,131,56,98,80,120,110,66,73,109,136,133,70,88,170,75,87,130,79,138,156,171,12,52,43,59,55,166,239,356,487,543,641,721,841,951,1017,1090,1199,1358,1491,1561,1649,1853,1938,2025,2157,2236,2376,2532,2834,2937,2989,3134 ...121711262,121743456,121745299,121746235,121747243,121749243,121751239,121752327,121753512,121754523,121754899,121757190,12175952 ...
9242930302273852667363+-BC05937534881493288chr11248977933116414318653127111,73,117,131,56,98,80,120,110,66,73,109,136,133,70,88,170,173,130,79,138,156,171,12,52,43,59,149,260,333,450,581,637,735,815,935,1045,1111,1184,1293,1452,1585,1655,1743,1947,2120,2252,2331,2471,2627,2929,3032,3084,3229,121711262,121743456,121745299,121746235,121747243,121749243,121751239,121752327,121753512,121754523,121754899,121757190,12175952 ...
9242930302273852667363+-D1248534931453284chr11248977933116414318653127111,73,117,131,56,98,80,120,110,66,73,109,136,133,70,88,170,173,130,79,138,156,171,12,52,43,59,145,256,329,446,577,633,731,811,931,1041,1107,1180,1289,1448,1581,1651,1739,1943,2116,2248,2327,2467,2623,2925,3028,3080,3225,121711262,121743456,121745299,121746235,121747243,121749243,121751239,121752327,121753512,121754523,121754899,121757190,12175952 ...
9242930302273852667363+-M5773634861363275chr11248977933116414318653127111,73,117,131,56,98,80,120,110,66,73,109,136,133,70,88,170,173,130,79,138,156,171,12,52,43,59,136,247,320,437,568,624,722,802,922,1032,1098,1171,1280,1439,1572,1642,1730,1934,2107,2239,2318,2458,2614,2916,3019,3071,3216,121711262,121743456,121745299,121746235,121747243,121749243,121751239,121752327,121753512,121754523,121754899,121757190,12175952 ...
60815562110071581522200+-AK230988208311926chr1124897793311660131405681874,136,133,70,88,170,51,155,131,81,133,163,165,66,26,21,39,65,1,75,234,367,437,525,696,747,902,1083,1164,1297,1460,1625,1710,1742,1765,1861,121757225,121759526,121762606,121764087,121764884,121766594,121767594,121769572,121771287,121776010,121776923,121778624,12178069 ...
9251128702261082667094+-DQ846654298502928chr1124897793311660131865152995,73,117,131,56,98,80,120,110,66,73,109,136,133,70,88,170,51,155,130,81,133,163,165,66,26,21,39,65,0,95,168,285,416,472,570,650,770,880,946,1019,1128,1287,1420,1490,1578,1749,1800,1955,2085,2166,2299,2462,2627,2712,2744,2767,28 ...121711278,121743456,121745299,121746235,121747243,121749243,121751239,121752327,121753512,121754523,121754899,121757190,12175952 ...
916213750293992129562+-AK041894248632127chr1124897793311689631484832231,3,77,119,113,64,71,111,132,32,128,70,88,122,27,123,131,80,133,160,3,207,3,34,37,114,233,346,410,481,592,724,756,884,954,1042,1224,1278,1413,1544,1624,1757,1917,1920,121749310,121749458,121751242,121752327,121753511,121754525,121754899,121757188,121759526,121761426,121762611,121764087,12176488 ...
9202446805151072567089+-AK1646193065862736chr11248977933116896318652826108,73,116,117,63,96,82,119,113,64,45,111,132,32,128,70,88,122,27,123,131,80,133,160,3,207,86,194,267,389,508,571,667,749,868,981,1045,1090,1201,1333,1365,1493,1563,1651,1833,1887,2022,2153,2233,2366,2526,2529,121711265,121743456,121745299,121746240,121747236,121749243,121751237,121752327,121753511,121754525,121754925,121757188,12175952 ...
920574730514952567051+-AK0888573096852761chr11248977933116896318652826108,73,116,117,63,96,82,119,113,64,71,111,132,32,128,70,88,122,27,135,131,80,133,160,3,207,85,193,266,388,507,570,666,748,867,980,1044,1115,1226,1358,1390,1518,1588,1676,1858,1912,2047,2178,2258,2391,2551,2554,121711265,121743456,121745299,121746240,121747236,121749243,121751237,121752327,121753511,121754525,121754899,121757188,12175952 ...

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.