Schema for dmBlastTab
  Database: mm8    Primary Table: dmBlastTab    Row Count: 5,614   Data last updated: 2007-07-18
Format description: Blast alignments of Drosophila genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query AY633741varchar(255) values Name of sequence in this assembly (query)
target CG2182-RAvarchar(255) values Name of sequence in other assembly (target)
identity 42.86float range Percent identity
aliLength 378int(10) unsigned range Length of alignment
mismatch 208int(10) unsigned range Number of mismatches
gapOpen 5int(10) unsigned range Number of gap openings
qStart 0int(10) unsigned range Start in query (0 based)
qEnd 373int(10) unsigned range End in query (non-inclusive)
tStart 0int(10) unsigned range Start in target (0 based)
tEnd 375int(10) unsigned range End in target (non-inclusive)
eValue 8e-76double range Expectation value
bitScore 280double range Bit score

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

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
AY633741CG2182-RA42.863782085037303758e-76280
AY179967CG8948-RC42.116153337160196166e-129458
AB018574CG5790-RA34.785062778385291315993e-73272
AY176042CG11148-RC43.59784014244985406180.000000000000374.7
AB013345CG9361-RA55.152721202027112724e-80295
AY171234CG5890-RA51.242019421721432041e-55212
AB001539CG12792-RA51.94439200511446244565e-130461
AF386076CG12608-RA27.6639425911038143858e-31131
AY590892CG3585-RA37.75115559522281089229334180648
M77174CG33950-RA29.422682154386165270399434700936

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