Schema for xenoMrna
  Database: droMoj1    Primary Table: xenoMrna    Row Count: 3,820,206   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 81int(10) unsigned
misMatches 8int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 2int(10) unsigned
qBaseInsert 2065int(10) unsigned
tNumInsert 3int(10) unsigned
tBaseInsert 11448int(10) unsigned
strand +-char(2)
qName AK157191varchar(255)
qSize 3320int(10) unsigned
qStart 361int(10) unsigned
qEnd 2515int(10) unsigned
tName contig_0varchar(255)
tSize 53787int(10) unsigned
tStart 306int(10) unsigned
tEnd 11843int(10) unsigned
blockCount 4int(10) unsigned
blockSizes 27,11,27,24,longblob
qStarts 361,2359,2370,2491,longblob
tStarts 41944,52007,52384,53457,longblob

Connected Tables and Joining Fields
        droMoj1.all_mrna.qName (via xenoMrna.qName)
      droMoj1.xenoRefFlat.name (via xenoMrna.qName)
      droMoj1.xenoRefGene.name (via xenoMrna.qName)
      droMoj1.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
5858180022065311448+-AK15719133203612515contig_05378730611843427,11,27,24,361,2359,2370,2491,41944,52007,52384,53457,
5854200012111489++BC068191177014481492contig_05378730911840221,21,1448,1471,309,11819,
5854200012111489++BC068191177014861530contig_05378730911840221,21,1486,1509,309,11819,
58566100236211467++BC057290592048014904contig_05378730911843321,21,25,4801,4834,4879,309,1374,11818,
585366000000++CR6527591274749contig_05378712081250142,7,1208,
585808003809427769+-BX648730810758026699contig_053787137529232514,16,15,15,28,5802,5817,5835,6656,6671,24555,25049,25290,52007,52384,
585808004814427769+-AK02211431429311833contig_053787137529232514,16,15,15,28,931,946,963,1784,1805,24555,25049,25290,52007,52384,
58538000001376++BC0595051449880918contig_05378713771791217,21,880,897,1377,1770,
5855610000310403++BC050861296324772534contig_053787138011840410,21,5,21,2477,2487,2508,2513,1380,1770,11454,11819,
5855810000310401++BC058108235618791938contig_053787138011840412,21,5,21,1879,1891,1912,1917,1380,1770,11454,11819,

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