Schema for xenoMrna
  Database: dp2    Primary Table: xenoMrna    Row Count: 3,002,274   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 42int(10) unsigned
misMatches 1int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 0int(10) unsigned
qBaseInsert 0int(10) unsigned
tNumInsert 2int(10) unsigned
tBaseInsert 310int(10) unsigned
strand +-char(2)
qName AY069777varchar(255)
qSize 4882int(10) unsigned
qStart 4448int(10) unsigned
qEnd 4491int(10) unsigned
tName Contig1006_Contig943varchar(255)
tSize 3647374int(10) unsigned
tStart 2201int(10) unsigned
tEnd 2554int(10) unsigned
blockCount 3int(10) unsigned
blockSizes 16,6,21,longblob
qStarts 4448,4464,4470,longblob
tStarts 3644820,3644886,3645152,longblob

Connected Tables and Joining Fields
        dp2.all_est.qName (via xenoMrna.qName)
      dp2.all_mrna.qName (via xenoMrna.qName)
      dp2.xenoRefFlat.name (via xenoMrna.qName)
      dp2.xenoRefGene.name (via xenoMrna.qName)
      dp2.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
58542100002310+-AY069777488244484491Contig1006_Contig943364737422012554316,6,21,4448,4464,4470,3644820,3644886,3645152,
7397140026744349627+-AK032469346116722457Contig1006_Contig94336473742201351939530,22,26,16,17,1672,2360,2382,2424,2440,3295435,3323005,3373877,3644822,3645156,
7397140026744349627+-BC024863321814132198Contig1006_Contig94336473742201351939530,22,26,16,17,1413,2101,2123,2165,2181,3295435,3323005,3373877,3644822,3645156,
735510011552394661+-AK0337791630494705Contig1006_Contig94336473742201396918322,13,21,494,671,684,3250456,3644821,3645152,
738490011603986716++AK038198237618792132Contig1006_Contig94336473742203989012419,10,25,39,1879,1898,1908,2093,2203,406993,754792,988973,
58540000002310+-BC096884160010411081Contig1006_Contig943364737422042554316,6,18,1041,1057,1063,3644820,3644894,3645152,
73767001593542890++AK139047180813811523Contig1006_Contig94336473742204545177418,13,25,27,1381,1399,1412,1496,2204,14449,325137,545150,
7383400005752534++AK042483375833113398Contig1006_Contig94336473742204754825615,14,6,9,11,32,3311,3326,3340,3346,3355,3366,2204,2535,406920,406994,407058,754793,
7383400005752534++AK162860309248135Contig1006_Contig94336473742204754825615,14,6,9,11,32,48,63,77,83,92,103,2204,2535,406920,406994,407058,754793,
7366200003291714++AK048186317610281096Contig1006_Contig94336473742206293988416,15,14,23,1028,1044,1059,1073,2206,2538,23411,293965,

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