Schema for drBlastTab
  Database: mm9    Primary Table: drBlastTab    Row Count: 12,923   Data last updated: 2013-10-11
Format description: Blast alignments of Zebrafish genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query uc008pgu.2varchar(255) values Name of sequence in this assembly (query)
target ENSDART00000102566varchar(255) values Name of sequence in other assembly (target)
identity 84.45float range Percent identity
aliLength 2972int(10) unsigned range Length of alignment
mismatch 336int(10) unsigned range Number of mismatches
gapOpen 20int(10) unsigned range Number of gap openings
qStart 40int(10) unsigned range Start in query (0 based)
qEnd 2936int(10) unsigned range End in query (non-inclusive)
tStart 46int(10) unsigned range Start in target (0 based)
tEnd 2968int(10) unsigned range End in target (non-inclusive)
eValue 0double range Expectation value
bitScore 4737double range Bit score

Connected Tables and Joining Fields
        knownGeneV39.bioCycPathway.kgID (via drBlastTab.query)
      knownGeneV39.ceBlastTab.query (via drBlastTab.query)
      knownGeneV39.dmBlastTab.query (via drBlastTab.query)
      knownGeneV39.drBlastTab.query (via drBlastTab.query)
      knownGeneV39.foldUtr3.name (via drBlastTab.query)
      knownGeneV39.foldUtr5.name (via drBlastTab.query)
      knownGeneV39.gnfAtlas2Distance.query (via drBlastTab.query)
      knownGeneV39.gnfAtlas2Distance.target (via drBlastTab.query)
      knownGeneV39.kgAlias.kgID (via drBlastTab.query)
      knownGeneV39.kgColor.kgID (via drBlastTab.query)
      knownGeneV39.kgProtAlias.kgID (via drBlastTab.query)
      knownGeneV39.kgSpAlias.kgID (via drBlastTab.query)
      knownGeneV39.kgTargetAli.qName (via drBlastTab.query)
      knownGeneV39.kgXref.kgID (via drBlastTab.query)
      knownGeneV39.knownAttrs.kgID (via drBlastTab.query)
      knownGeneV39.knownBlastTab.query (via drBlastTab.query)
      knownGeneV39.knownBlastTab.target (via drBlastTab.query)
      knownGeneV39.knownCanonical.protein (via drBlastTab.query)
      knownGeneV39.knownCanonical.transcript (via drBlastTab.query)
      knownGeneV39.knownCds.name (via drBlastTab.query)
      knownGeneV39.knownGene.name (via drBlastTab.query)
      knownGeneV39.knownGeneMrna.name (via drBlastTab.query)
      knownGeneV39.knownGenePep.name (via drBlastTab.query)
      knownGeneV39.knownIsoforms.transcript (via drBlastTab.query)
      knownGeneV39.knownToEnsembl.name (via drBlastTab.query)
      knownGeneV39.knownToGnfAtlas2.name (via drBlastTab.query)
      knownGeneV39.knownToHprd.name (via drBlastTab.query)
      knownGeneV39.knownToLocusLink.name (via drBlastTab.query)
      knownGeneV39.knownToMrna.name (via drBlastTab.query)
      knownGeneV39.knownToMrnaSingle.name (via drBlastTab.query)
      knownGeneV39.knownToMupit.name (via drBlastTab.query)
      knownGeneV39.knownToPfam.name (via drBlastTab.query)
      knownGeneV39.knownToRefSeq.name (via drBlastTab.query)
      knownGeneV39.knownToSuper.gene (via drBlastTab.query)
      knownGeneV39.knownToTag.name (via drBlastTab.query)
      knownGeneV39.knownToU133.name (via drBlastTab.query)
      knownGeneV39.knownToU95.name (via drBlastTab.query)
      knownGeneV39.knownToVisiGene.name (via drBlastTab.query)
      knownGeneV39.knownToWikipedia.name (via drBlastTab.query)
      knownGeneV39.mmBlastTab.query (via drBlastTab.query)
      knownGeneV39.rnBlastTab.query (via drBlastTab.query)
      knownGeneV39.scBlastTab.query (via drBlastTab.query)
      knownGeneV39.ucscScop.ucscId (via drBlastTab.query)
      mm9.affyGnfU74ADistance.query (via drBlastTab.query)
      mm9.affyGnfU74ADistance.target (via drBlastTab.query)
      mm9.affyGnfU74BDistance.query (via drBlastTab.query)
      mm9.affyGnfU74BDistance.target (via drBlastTab.query)
      mm9.affyGnfU74CDistance.query (via drBlastTab.query)
      mm9.affyGnfU74CDistance.target (via drBlastTab.query)
      mm9.bioCycPathway.kgID (via drBlastTab.query)
      mm9.ccdsKgMap.geneId (via drBlastTab.query)
      mm9.ceBlastTab.query (via drBlastTab.query)
      mm9.dmBlastTab.query (via drBlastTab.query)
      mm9.foldUtr3.name (via drBlastTab.query)
      mm9.foldUtr5.name (via drBlastTab.query)
      mm9.gnfAtlas2Distance.query (via drBlastTab.query)
      mm9.gnfAtlas2Distance.target (via drBlastTab.query)
      mm9.hgBlastTab.query (via drBlastTab.query)
      mm9.keggPathway.kgID (via drBlastTab.query)
      mm9.kgAlias.kgID (via drBlastTab.query)
      mm9.kgColor.kgID (via drBlastTab.query)
      mm9.kgProtAlias.kgID (via drBlastTab.query)
      mm9.kgProtMap2.qName (via drBlastTab.query)
      mm9.kgSpAlias.kgID (via drBlastTab.query)
      mm9.kgTargetAli.qName (via drBlastTab.query)
      mm9.kgTxInfo.name (via drBlastTab.query)
      mm9.kgXref.kgID (via drBlastTab.query)
      mm9.knownBlastTab.query (via drBlastTab.query)
      mm9.knownBlastTab.target (via drBlastTab.query)
      mm9.knownCanonical.protein (via drBlastTab.query)
      mm9.knownCanonical.transcript (via drBlastTab.query)
      mm9.knownGene.name (via drBlastTab.query)
      mm9.knownGeneMrna.name (via drBlastTab.query)
      mm9.knownGenePep.name (via drBlastTab.query)
      mm9.knownIsoforms.transcript (via drBlastTab.query)
      mm9.knownToAllenBrain.name (via drBlastTab.query)
      mm9.knownToEnsembl.name (via drBlastTab.query)
      mm9.knownToGnfAtlas2.name (via drBlastTab.query)
      mm9.knownToKeggEntrez.name (via drBlastTab.query)
      mm9.knownToLocusLink.name (via drBlastTab.query)
      mm9.knownToPfam.name (via drBlastTab.query)
      mm9.knownToRefSeq.name (via drBlastTab.query)
      mm9.knownToSuper.gene (via drBlastTab.query)
      mm9.knownToVisiGene.name (via drBlastTab.query)
      mm9.rnBlastTab.query (via drBlastTab.query)
      mm9.scBlastTab.query (via drBlastTab.query)
      mm9.ucscScop.ucscId (via drBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
uc008pgu.2ENSDART0000010256684.4529723362040293646296804737
uc009eyu.2ENSDART0000009200640.53375185982447153624e-62236
uc009gic.2ENSDART0000014263351.824131943241254168e-125444
uc007ygu.1ENSDART0000005493452.431858621820391925e-39157
uc008nzl.1ENSDART0000008433447.59477219629500274794e-120429
uc009ghk.2ENSDART0000001596751.2418175112342554105e-75279
uc007wyt.1ENSDART0000012838378.67361513033603601e-162570
uc009eyt.1ENSDART0000004745267.49203422020301798e-76280
uc008nys.2ENSDART0000001320386.7197112900971097101607
uc007yhj.1ENSDART0000015123270.5715294386015280151802107

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