Schema for xenoMrna
  Database: macEug2    Primary Table: xenoMrna    Row Count: 6,759,450   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 140int(10) unsigned
misMatches 41int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 0int(10) unsigned
qBaseInsert 0int(10) unsigned
tNumInsert 0int(10) unsigned
tBaseInsert 0int(10) unsigned
strand ++char(2)
qName JI430307varchar(255)
qSize 393int(10) unsigned
qStart 210int(10) unsigned
qEnd 391int(10) unsigned
tName ABQO010000375varchar(255)
tSize 938int(10) unsigned
tStart 551int(10) unsigned
tEnd 732int(10) unsigned
blockCount 1int(10) unsigned
blockSizes 181,longblob
qStarts 210,longblob
tStarts 551,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)
      macEug2.all_est.qName (via xenoMrna.qName)
      macEug2.all_mrna.qName (via xenoMrna.qName)
      macEug2.xenoRefFlat.name (via xenoMrna.qName)
      macEug2.xenoRefGene.name (via xenoMrna.qName)
      macEug2.xenoRefSeqAli.qName (via xenoMrna.qName)

Sample Rows
 
binmatchesmisMatchesrepMatchesnCountqNumInsertqBaseInserttNumInserttBaseInsertstrandqNameqSizeqStartqEndtNametSizetStarttEndblockCountblockSizesqStartstStarts
58514041000000++JI430307393210391ABQO0100003759385517321181,210,551,
58514058000000+-JP3281081063509707ABQO0100003759385517491198,509,189,
58510644000000++HP503938523337487ABQO0100003759385527021150,337,552,
58511247000000++HP479561453293452ABQO0100003759385527111159,293,552,
58511451000000++JP344452618433598ABQO0100003759385527171165,433,552,
58516020000000++JI895261929748928ABQO0100003759385527321180,748,552,
58516020000000++JP043533929748928ABQO0100003759385527321180,748,552,
58515048000000++AK17472273214212ABQO0100003759385527501198,14,552,
58514354000011++CU67913511108421039ABQO0100003759385527502128,69,842,970,552,681,
5857335000000+-JO680000629519627ABQO0100003759386087161108,519,222,

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