Schema for dmBlastTab
  Database: hg17    Primary Table: dmBlastTab    Row Count: 27,014   Data last updated: 2006-01-31
Format description: Blast alignments of Drosophila genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query AB000409varchar(255) values Name of sequence in this assembly (query)
target CG17342-RAvarchar(255) values Name of sequence in other assembly (target)
identity 57.43float range Percent identity
aliLength 343int(10) unsigned range Length of alignment
mismatch 134int(10) unsigned range Number of mismatches
gapOpen 4int(10) unsigned range Number of gap openings
qStart 43int(10) unsigned range Start in query (0 based)
qEnd 374int(10) unsigned range End in query (non-inclusive)
tStart 112int(10) unsigned range Start in target (0 based)
tEnd 455int(10) unsigned range End in target (non-inclusive)
eValue 2e-114double range Expectation value
bitScore 409double range Bit score

Connected Tables and Joining Fields
        hg17.bioCycPathway.kgID (via dmBlastTab.query)
      hg17.ccdsKgMap.geneId (via dmBlastTab.query)
      hg17.ceBlastTab.query (via dmBlastTab.query)
      hg17.drBlastTab.query (via dmBlastTab.query)
      hg17.dupSpMrna.mrnaID (via dmBlastTab.query)
      hg17.foldUtr3.name (via dmBlastTab.query)
      hg17.foldUtr5.name (via dmBlastTab.query)
      hg17.gladHumESDistance.query (via dmBlastTab.query)
      hg17.gladHumESDistance.target (via dmBlastTab.query)
      hg17.gnfAtlas2Distance.query (via dmBlastTab.query)
      hg17.gnfAtlas2Distance.target (via dmBlastTab.query)
      hg17.gnfU95Distance.query (via dmBlastTab.query)
      hg17.gnfU95Distance.target (via dmBlastTab.query)
      hg17.humanHprdP2P.query (via dmBlastTab.query)
      hg17.humanHprdP2P.target (via dmBlastTab.query)
      hg17.humanVidalP2P.query (via dmBlastTab.query)
      hg17.humanVidalP2P.target (via dmBlastTab.query)
      hg17.humanWankerP2P.query (via dmBlastTab.query)
      hg17.humanWankerP2P.target (via dmBlastTab.query)
      hg17.keggPathway.kgID (via dmBlastTab.query)
      hg17.kgAlias.kgID (via dmBlastTab.query)
      hg17.kgProtAlias.kgID (via dmBlastTab.query)
      hg17.kgSpAlias.kgID (via dmBlastTab.query)
      hg17.kgTargetAli.qName (via dmBlastTab.query)
      hg17.kgXref.kgID (via dmBlastTab.query)
      hg17.knownBlastTab.query (via dmBlastTab.query)
      hg17.knownBlastTab.target (via dmBlastTab.query)
      hg17.knownCanonical.transcript (via dmBlastTab.query)
      hg17.knownExpDistance.query (via dmBlastTab.query)
      hg17.knownExpDistance.target (via dmBlastTab.query)
      hg17.knownGene.name (via dmBlastTab.query)
      hg17.knownGeneLink.name (via dmBlastTab.query)
      hg17.knownGeneMrna.name (via dmBlastTab.query)
      hg17.knownGenePep.name (via dmBlastTab.query)
      hg17.knownIsoforms.transcript (via dmBlastTab.query)
      hg17.knownToAllenBrain.name (via dmBlastTab.query)
      hg17.knownToEnsembl.name (via dmBlastTab.query)
      hg17.knownToGnf1h.name (via dmBlastTab.query)
      hg17.knownToGnfAtlas2.name (via dmBlastTab.query)
      hg17.knownToHInv.name (via dmBlastTab.query)
      hg17.knownToHprd.name (via dmBlastTab.query)
      hg17.knownToKeggEntrez.name (via dmBlastTab.query)
      hg17.knownToLocusLink.name (via dmBlastTab.query)
      hg17.knownToPfam.name (via dmBlastTab.query)
      hg17.knownToRefSeq.name (via dmBlastTab.query)
      hg17.knownToSuper.gene (via dmBlastTab.query)
      hg17.knownToU133.name (via dmBlastTab.query)
      hg17.knownToU133Plus2.name (via dmBlastTab.query)
      hg17.knownToU95.name (via dmBlastTab.query)
      hg17.knownToVisiGene.name (via dmBlastTab.query)
      hg17.mmBlastTab.query (via dmBlastTab.query)
      hg17.rankProp.query (via dmBlastTab.query)
      hg17.rankProp.target (via dmBlastTab.query)
      hg17.rnBlastTab.query (via dmBlastTab.query)
      hg17.scBlastTab.query (via dmBlastTab.query)
      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)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
AB000409CG17342-RA57.433431344433741124552e-114409
AB000460CG7518-RB22.872231309262193565670.0000348.1
AB000461CG7518-RB22.872231309262193565670.0000248.1
AB000463CG11628-RA36.174727128752783220.00237.4
AB000781CG9491-RA27.8620112951481167092011170.00000000362
AB000815CG8727-RA58.011817224422341839.999999999999999e-55209
AB001025CG10844-RD43.782990152632132842111532447402204
AB001328CG2913-RA43.4820710240203522481e-31133
AB001535CG30078-RA29.855933661415671657351e-55215
AB002292CG8557-RA31.499055021917698616010425e-114409

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