Schema for xenoMrna
  Database: droGri1    Primary Table: xenoMrna    Row Count: 3,621,607   Data last updated: 2016-02-15
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 72int(10) unsigned
misMatches 9int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 2int(10) unsigned
qBaseInsert 317int(10) unsigned
tNumInsert 3int(10) unsigned
tBaseInsert 2659int(10) unsigned
strand +-char(2)
qName HP233754varchar(255)
qSize 1081int(10) unsigned
qStart 106int(10) unsigned
qEnd 504int(10) unsigned
tName scaffold_10008varchar(255)
tSize 7097int(10) unsigned
tStart 2545int(10) unsigned
tEnd 5285int(10) unsigned
blockCount 4int(10) unsigned
blockSizes 21,21,18,21,longblob
qStarts 106,431,465,483,longblob
tStarts 1812,2698,4060,4531,longblob

Connected Tables and Joining Fields
        droGri1.xenoRefFlat.name (via xenoMrna.qName)
      droGri1.xenoRefGene.name (via xenoMrna.qName)
      droGri1.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
58572900231732659+-HP2337541081106504scaffold_10008709725455285421,21,18,21,106,431,465,483,1812,2698,4060,4531,
58572900231732608+-HP2337541081106504scaffold_10008709730165705421,21,18,21,106,431,465,483,1392,1812,2698,4060,
5851645300163911287++HP558844560141835039scaffold_10030499919873491252,165,4183,4874,1987,3326,
5851645300163911287++HP558845546441835039scaffold_10030499919873491252,165,4183,4874,1987,3326,
585994500160611448+-BC153359227066816scaffold_100304999227438662117,27,66,789,1133,2698,
585852000218831749++DQ367851695258551scaffold_10030499925904444434,20,11,40,258,292,470,511,2590,3182,4107,4404,
5859444000000+-HP50329157687225scaffold_100304999374938871138,87,1112,
585774002100744989+-HP57188021334151503scaffold_1003381803605430520,12,12,12,25,415,435,1067,1079,1478,2750,2873,3338,3365,7795,
585839001160444863+-HP49614326347272423scaffold_1003381803625317520,5,36,11,20,727,747,752,2392,2403,2863,2979,3339,7692,7798,
585811200233432345+-HP5645323102291718scaffold_10033818051917629436,15,24,18,291,581,596,700,551,2762,2864,2971,

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