Schema for xenoMrna
  Database: sarHar1    Primary Table: xenoMrna    Row Count: 5,781,174   Data last updated: 2016-02-27
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 283int(10) unsigned
misMatches 49int(10) unsigned
repMatches 0int(10) unsigned
nCount 72int(10) unsigned
qNumInsert 3int(10) unsigned
qBaseInsert 471int(10) unsigned
tNumInsert 3int(10) unsigned
tBaseInsert 501int(10) unsigned
strand +-char(2)
qName AK097335varchar(255)
qSize 1823int(10) unsigned
qStart 730int(10) unsigned
qEnd 1605int(10) unsigned
tName chr1_GL834412_randomvarchar(255)
tSize 2180112int(10) unsigned
tStart 4041int(10) unsigned
tEnd 4946int(10) unsigned
blockCount 4int(10) unsigned
blockSizes 96,148,94,66,longblob
qStarts 730,886,1036,1539,longblob
tStarts 2175166,2175341,2175492,217...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)
      sarHar1.all_mrna.qName (via xenoMrna.qName)
      sarHar1.refGene.name (via xenoMrna.qName)
      sarHar1.refSeqAli.qName (via xenoMrna.qName)
      sarHar1.xenoRefFlat.name (via xenoMrna.qName)
      sarHar1.xenoRefGene.name (via xenoMrna.qName)
      sarHar1.xenoRefSeqAli.qName (via xenoMrna.qName)

Sample Rows
 
binmatchesmisMatchesrepMatchesnCountqNumInsertqBaseInserttNumInserttBaseInsertstrandqNameqSizeqStartqEndtNametSizetStarttEndblockCountblockSizesqStartstStarts
5852834907234713501+-AK09733518237301605chr1_GL834412_random218011240414946496,148,94,66,730,886,1036,1539,2175166,2175341,2175492,2176005,
585992100001743+-AY270035514118238chr1_GL834412_random218011240534916266,54,118,184,2175196,2176005,
5856120001161116++JO4103453896161258chr1_GL834412_random21801125541655613239,42,161,216,55416,55571,
5856120001161116++JO4313331882136233chr1_GL834412_random21801125541655613239,42,136,191,55416,55571,
5856120001161116++JO6229953050142239chr1_GL834412_random21801125541655613239,42,142,197,55416,55571,
5856120001161116++JO6229993868142239chr1_GL834412_random21801125541655613239,42,142,197,55416,55571,
5865758700291711176+-JO3232301167245998chr1_GL834412_random2180112183607195445892,31,62,62,171,106,65,73,245,337,426,488,550,721,860,925,1984667,1984855,1988139,1990167,1990645,1995153,1995292,1996432,
5865758700291711176+-JO4136161208235988chr1_GL834412_random2180112183607195445892,31,62,62,171,106,65,73,235,327,416,478,540,711,850,915,1984667,1984855,1988139,1990167,1990645,1995153,1995292,1996432,
5865758700291711176+-JO4384051199242995chr1_GL834412_random2180112183607195445892,31,62,62,171,106,65,73,242,334,423,485,547,718,857,922,1984667,1984855,1988139,1990167,1990645,1995153,1995292,1996432,
5865758700291711176+-JO5567081155234987chr1_GL834412_random2180112183607195445892,31,62,62,171,106,65,73,234,326,415,477,539,710,849,914,1984667,1984855,1988139,1990167,1990645,1995153,1995292,1996432,

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