Schema for xenoMrna
  Database: caeRem2    Primary Table: xenoMrna    Row Count: 2,617,160   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 63int(10) unsigned
misMatches 21int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 1int(10) unsigned
qBaseInsert 1int(10) unsigned
tNumInsert 1int(10) unsigned
tBaseInsert 92697int(10) unsigned
strand +-char(2)
qName AK034342varchar(255)
qSize 3073int(10) unsigned
qStart 1338int(10) unsigned
qEnd 1423int(10) unsigned
tName chrUnvarchar(255)
tSize 161944676int(10) unsigned
tStart 10360int(10) unsigned
tEnd 103141int(10) unsigned
blockCount 2int(10) unsigned
blockSizes 40,44,longblob
qStarts 1338,1379,longblob
tStarts 161841535,161934272,longblob

Connected Tables and Joining Fields
        caeRem2.all_est.qName (via xenoMrna.qName)
      caeRem2.all_mrna.qName (via xenoMrna.qName)
      caeRem2.xenoRefFlat.name (via xenoMrna.qName)
      caeRem2.xenoRefGene.name (via xenoMrna.qName)
      caeRem2.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
58563210011192697+-AK034342307313381423chrUn16194467610360103141240,44,1338,1379,161841535,161934272,
5856921001115811547++AK23193617471601408chrUn1619446761736319000245,45,160,1363,17363,18955,
5852141100036873819++BC12594046764631474chrUn1619446761788119024484,75,84,81,463,610,970,1393,17881,18081,18472,18943,
5852481510025932711++AF04601017764511443chrUn1619446761789019000375,144,180,451,972,1263,17890,18481,18820,
585100470017581978++EF62535810189914chrUn1619446761789019015275,72,9,842,17890,18943,
585170820037623873++BC10515042617491763chrUn1619446761789019015475,36,69,72,749,905,1262,1691,17890,18099,18466,18943,
585179790037503867++AK12260017684651473chrUn1619446761789019015454,57,75,72,465,621,966,1401,17890,18099,18460,18943,
585179790037503867++AK12647343823991407chrUn1619446761789019015454,57,75,72,399,555,900,1335,17890,18099,18460,18943,
585179790037503867++AY42200220417301738chrUn1619446761789019015454,57,75,72,730,886,1231,1666,17890,18099,18460,18943,
585179790037503867++BC06085719195961604chrUn1619446761789019015454,57,75,72,596,752,1097,1532,17890,18099,18460,18943,

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