Schema for xenoMrna
  Database: ce4    Primary Table: xenoMrna    Row Count: 937,110   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 130int(10) unsigned
misMatches 86int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 1int(10) unsigned
qBaseInsert 51int(10) unsigned
tNumInsert 1int(10) unsigned
tBaseInsert 48int(10) unsigned
strand +-char(2)
qName CR714352varchar(255)
qSize 825int(10) unsigned
qStart 9int(10) unsigned
qEnd 276int(10) unsigned
tName chrIvarchar(255)
tSize 15072419int(10) unsigned
tStart 6039int(10) unsigned
tEnd 6303int(10) unsigned
blockCount 2int(10) unsigned
blockSizes 84,132,longblob
qStarts 9,144,longblob
tStarts 15066116,15066248,longblob

Connected Tables and Joining Fields
        ce4.all_est.qName (via xenoMrna.qName)
      ce4.all_mrna.qName (via xenoMrna.qName)
      ce4.refGene.name (via xenoMrna.qName)
      ce4.refSeqAli.qName (via xenoMrna.qName)
      ce4.xenoRefFlat.name (via xenoMrna.qName)
      ce4.xenoRefGene.name (via xenoMrna.qName)
      ce4.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
5851308600151148+-CR7143528259276chrI1507241960396303284,132,9,144,15066116,15066248,
7358800002256500+-AK192597263103169chrI1507241942119298685333,9,24,103,136,145,14773734,14801402,15030276,
58527315600446242748++AK31266915584841375chrI1507241974622777995114,54,135,42,84,484,1000,1093,1240,1291,74622,76020,76949,77105,77715,
58527315600446242748++AY00716216822111102chrI1507241974622777995114,54,135,42,84,211,727,820,967,1018,74622,76020,76949,77105,77715,
58527315600446242748++AY33576013532791170chrI1507241974622777995114,54,135,42,84,279,795,888,1035,1086,74622,76020,76949,77105,77715,
58527315600446242748++AY89081713532791170chrI1507241974622777995114,54,135,42,84,279,795,888,1035,1086,74622,76020,76949,77105,77715,
58527315600446242748++AY89081813532791170chrI1507241974622777995114,54,135,42,84,279,795,888,1035,1086,74622,76020,76949,77105,77715,
58527315600446242748++BT01951113532791170chrI1507241974622777995114,54,135,42,84,279,795,888,1035,1086,74622,76020,76949,77105,77715,
58527315600446242748++BT01951213532791170chrI1507241974622777995114,54,135,42,84,279,795,888,1035,1086,74622,76020,76949,77105,77715,
58527315600446242748++CR54196013502791170chrI1507241974622777995114,54,135,42,84,279,795,888,1035,1086,74622,76020,76949,77105,77715,

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