Schema for xenoMrna
  Database: felCat3    Primary Table: xenoMrna    Row Count: 7,637,769   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
fieldexampleSQL type
bin 585smallint(5) unsigned
matches 98int(10) unsigned
misMatches 31int(10) unsigned
repMatches 0int(10) unsigned
nCount 0int(10) unsigned
qNumInsert 1int(10) unsigned
qBaseInsert 20int(10) unsigned
tNumInsert 1int(10) unsigned
tBaseInsert 17int(10) unsigned
strand +-char(2)
qName BC040257varchar(255)
qSize 1731int(10) unsigned
qStart 1int(10) unsigned
qEnd 150int(10) unsigned
tName scaffold_0varchar(255)
tSize 75651int(10) unsigned
tStart 1872int(10) unsigned
tEnd 2018int(10) unsigned
blockCount 2int(10) unsigned
blockSizes 33,96,longblob
qStarts 1,54,longblob
tStarts 73633,73683,longblob

Connected Tables and Joining Fields
        felCat3.all_est.qName (via xenoMrna.qName)
      felCat3.all_mrna.qName (via xenoMrna.qName)
      felCat3.refGene.name (via xenoMrna.qName)
      felCat3.refSeqAli.qName (via xenoMrna.qName)
      felCat3.xenoRefFlat.name (via xenoMrna.qName)
      felCat3.xenoRefGene.name (via xenoMrna.qName)
      felCat3.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
585983100120117+-BC04025717311150scaffold_07565118722018233,96,1,54,73633,73683,
585983100120117+-BC105070109031180scaffold_07565118722018233,96,31,84,73633,73683,
585983100120117+-BC105072109031180scaffold_07565118722018233,96,31,84,73633,73683,
5851013100120117+-AR3223008481153scaffold_07565118722021236,96,1,57,73630,73683,
585103917500358069036+-AK3452301894721866scaffold_0756515449156997362,145,114,153,176,192,72,72,795,940,1055,1208,1384,1794,59952,63868,64618,67892,68382,69624,70130,
585103217100221969047+-AK3519591521821504scaffold_0756515449156997354,137,113,159,176,192,72,82,436,573,687,846,1022,1432,59952,63876,64618,67886,68382,69624,70130,
585102919100225869029+-BC1030261600961574scaffold_0756515450156997354,137,113,159,176,232,49,96,450,587,701,860,1036,1525,59952,63876,64618,67886,68382,69624,70152,
5855037000111421382+-AK055331259113522039scaffold_075651582477793185,185,203,1352,1651,1836,67872,68373,69624,
58548864000021403+-AK126927351624102962scaffold_075651582477793173,176,203,2410,2583,2759,67872,68382,69624,
5858371030017242042+-JO585608170601012scaffold_1485258487836047390295345,168,122,143,162,0,417,585,707,850,45849,47207,47537,47660,48669,

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