Schema for xenoMrna
  Database: triMan1    Primary Table: xenoMrna    Row Count: 5,331,650   Data last updated: 2016-02-27
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 170int(10) unsigned
misMatches 25int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 1int(10) unsigned
qBaseInsert 105int(10) unsigned
tNumInsert 1int(10) unsigned
tBaseInsert 4921int(10) unsigned
strand +-char(2)
qName CU691461varchar(255)
qSize 1300int(10) unsigned
qStart 18int(10) unsigned
qEnd 318int(10) unsigned
tName AHIN01157057varchar(255)
tSize 22366int(10) unsigned
tStart 855int(10) unsigned
tEnd 5971int(10) unsigned
blockCount 2int(10) unsigned
blockSizes 112,83,longblob
qStarts 18,235,longblob
tStarts 16395,21428,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)
      triMan1.all_mrna.qName (via xenoMrna.qName)
      triMan1.xenoRefFlat.name (via xenoMrna.qName)
      triMan1.xenoRefGene.name (via xenoMrna.qName)
      triMan1.xenoRefSeqAli.qName (via xenoMrna.qName)

Sample Rows
 
binmatchesmisMatchesrepMatchesnCountqNumInsertqBaseInserttNumInserttBaseInsertstrandqNameqSizeqStartqEndtNametSizetStarttEndblockCountblockSizesqStartstStarts
5851702500110514921+-CU691461130018318AHIN011570572236685559712112,83,18,235,16395,21428,
58570113400157612721+-JO399675123490982AHIN0115705722366856144127136,178,191,108,90,59,73,90,226,404,595,703,793,909,7954,9447,10655,11816,16415,18396,21437,
5851175285001104915930+-JL98838323211381702AHIN01157057223668561824610188,138,175,170,137,178,193,106,93,82,138,326,464,639,809,946,1124,1317,1423,1620,4120,5839,6080,6557,7953,9447,10655,11818,16415,21428,
58514513420011041118888+-JL988382251821899AHIN01157057223668562153712168,167,186,138,175,170,137,178,193,106,93,82,2,170,337,523,661,836,1006,1143,1321,1514,1620,1817,829,2111,4122,5839,6080,6557,7953,9447,10655,11818,16415,21428,
58510690014812973++JV691485629465628AHIN01157057223668573945282,33,465,595,857,3912,
585176230014824864++JV62392427324271AHIN01157057223668575920382,58,59,24,154,212,857,3912,5861,
5854989700142511349++JO50526810854461083AHIN011570572236685712801682,64,90,108,191,60,446,570,634,724,832,1023,857,3906,5861,10442,11520,12741,
58554611600268511357++JP00936710603291059AHIN011570572236685712876682,55,90,109,191,135,329,462,517,624,733,924,857,3915,5861,10441,11520,12741,
5851165243002571115883++JV51491619985331998AHIN0115705722366857181481282,58,90,107,183,178,137,165,3,177,137,91,533,663,721,811,927,1110,1288,1425,1590,1593,1770,1907,857,3912,5861,10442,11528,12741,14276,15639,15806,16109,16389,18057,
5851267250002441015870++JO54376420134442005AHIN0115705722366857182441182,64,90,108,191,178,137,166,177,138,186,444,568,632,722,830,1021,1199,1336,1504,1681,1819,857,3906,5861,10442,11520,12741,14276,15639,16109,16389,18058,

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