Schema for xenoMrna
  Database: panTro1    Primary Table: xenoMrna    Row Count: 7,188,682   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 2285int(10) unsigned
misMatches 59int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 2int(10) unsigned
qBaseInsert 214int(10) unsigned
tNumInsert 16int(10) unsigned
tBaseInsert 620int(10) unsigned
strand ++char(2)
qName AK093685varchar(255)
qSize 3101int(10) unsigned
qStart 543int(10) unsigned
qEnd 3101int(10) unsigned
tName chr1varchar(255)
tSize 229575298int(10) unsigned
tStart 1332int(10) unsigned
tEnd 4296int(10) unsigned
blockCount 17int(10) unsigned
blockSizes 42,90,435,474,26,143,398,14...longblob
qStarts 543,784,874,1309,1783,1809,...longblob
tStarts 1332,1573,1664,2483,2959,29...longblob

Connected Tables and Joining Fields
        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)
      panTro1.all_est.qName (via xenoMrna.qName)
      panTro1.all_mrna.qName (via xenoMrna.qName)
      panTro1.refGene.name (via xenoMrna.qName)
      panTro1.refSeqAli.qName (via xenoMrna.qName)
      panTro1.xenoRefFlat.name (via xenoMrna.qName)
      panTro1.xenoRefGene.name (via xenoMrna.qName)
      panTro1.xenoRefSeqAli.qName (via xenoMrna.qName)

Sample Rows
 
binmatchesmisMatchesrepMatchesnCountqNumInsertqBaseInserttNumInserttBaseInsertstrandqNameqSizeqStartqEndtNametSizetStarttEndblockCountblockSizesqStartstStarts
58522855900221416620++AK09368531015433101chr1229575298133242961742,90,435,474,26,143,398,141,265,7,25,12,15,9,6,3,253,543,784,874,1309,1783,1809,1952,2350,2491,2756,2763,2803,2815,2830,2839,2845,2848,1332,1573,1664,2483,2959,2986,3130,3530,3673,3939,3948,3992,4005,4022,4032,4039,4043,
58522855900221416620++AX74826031015433101chr1229575298133242961742,90,435,474,26,143,398,141,265,7,25,12,15,9,6,3,253,543,784,874,1309,1783,1809,1952,2350,2491,2756,2763,2803,2815,2830,2839,2845,2848,1332,1573,1664,2483,2959,2986,3130,3530,3673,3939,3948,3992,4005,4022,4032,4039,4043,
58526627400321512231++AK12599834535023453chr1229575298133242991442,90,570,895,541,265,7,25,12,15,9,6,3,256,502,743,833,1404,2299,2840,3105,3112,3152,3164,3179,3188,3194,3197,1332,1573,1664,2234,3130,3673,3939,3948,3992,4005,4022,4032,4039,4043,
5852091540011514420++AK057285216002160chr12295752981734429915365,474,26,143,398,141,265,7,25,12,15,9,6,3,256,0,365,839,865,1008,1406,1547,1812,1819,1859,1871,1886,1895,1901,1904,1734,2483,2959,2986,3130,3530,3673,3939,3948,3992,4005,4022,4032,4039,4043,
5851610350011513920++AM992870166001660chr12295752981734429914365,109,34,398,141,265,7,25,12,15,9,6,3,256,0,365,474,508,906,1047,1312,1319,1359,1371,1386,1395,1401,1404,1734,2483,3095,3130,3530,3673,3939,3948,3992,4005,4022,4032,4039,4043,
5851556320011512914++AM992877160401603chr12295752981745424713354,109,38,541,265,7,25,12,15,9,6,3,204,0,354,463,501,1042,1307,1314,1354,1366,1381,1390,1396,1399,1745,2483,3091,3130,3673,3939,3948,3992,4005,4022,4032,4039,4043,
58513962800115111078++AM992881144001439chr12295752981745424712354,127,397,265,7,25,12,15,9,6,3,204,0,354,481,878,1143,1150,1190,1202,1217,1226,1232,1235,1745,2465,3274,3673,3939,3948,3992,4005,4022,4032,4039,4043,
5851499310011514974++AM992878154501545chr12295752981745424915354,52,38,398,141,158,106,7,25,12,15,9,6,3,206,0,354,406,444,842,983,1141,1247,1254,1294,1306,1321,1330,1336,1339,1745,2516,3091,3130,3530,3673,3832,3939,3948,3992,4005,4022,4032,4039,4043,
5851554360011512914++AM992879160501605chr12295752981745424913354,109,38,541,265,7,25,12,15,9,6,3,206,0,354,463,501,1042,1307,1314,1354,1366,1381,1390,1396,1399,1745,2483,3091,3130,3673,3939,3948,3992,4005,4022,4032,4039,4043,
5851603340011512914++AM992871165201652chr12295752981745429613354,109,38,541,265,7,25,12,15,9,6,3,253,0,354,463,501,1042,1307,1314,1354,1366,1381,1390,1396,1399,1745,2483,3091,3130,3673,3939,3948,3992,4005,4022,4032,4039,4043,

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