Schema for dmBlastTab
  Database: hg16    Primary Table: dmBlastTab    Row Count: 29,322   Data last updated: 2004-03-30
Format description: Blast alignments of Drosophila genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query AB000114varchar(255) values Name of sequence in this assembly (query)
target FBgn0036040varchar(255) values Name of sequence in other assembly (target)
identity 28.64float range Percent identity
aliLength 213int(10) unsigned range Length of alignment
mismatch 121int(10) unsigned range Number of mismatches
gapOpen 5int(10) unsigned range Number of gap openings
qStart 85int(10) unsigned range Start in query (0 based)
qEnd 292int(10) unsigned range End in query (non-inclusive)
tStart 264int(10) unsigned range Start in target (0 based)
tEnd 452int(10) unsigned range End in target (non-inclusive)
eValue 0.00000000000005double range Expectation value
bitScore 75.48double range Bit score

Connected Tables and Joining Fields
        hg16.bioCycPathway.kgID (via dmBlastTab.query)
      hg16.drBlastTab.query (via dmBlastTab.query)
      hg16.dupSpMrna.mrnaID (via dmBlastTab.query)
      hg16.foldUtr3.name (via dmBlastTab.query)
      hg16.foldUtr5.name (via dmBlastTab.query)
      hg16.gnfAtlas2Distance.query (via dmBlastTab.query)
      hg16.gnfAtlas2Distance.target (via dmBlastTab.query)
      hg16.gnfU95Distance.query (via dmBlastTab.query)
      hg16.gnfU95Distance.target (via dmBlastTab.query)
      hg16.hg17Kg.name (via dmBlastTab.query)
      hg16.keggPathway.kgID (via dmBlastTab.query)
      hg16.kgAlias.kgID (via dmBlastTab.query)
      hg16.kgProtAlias.kgID (via dmBlastTab.query)
      hg16.kgXref.kgID (via dmBlastTab.query)
      hg16.knownBlastTab.query (via dmBlastTab.query)
      hg16.knownBlastTab.target (via dmBlastTab.query)
      hg16.knownCanonical.transcript (via dmBlastTab.query)
      hg16.knownGene.name (via dmBlastTab.query)
      hg16.knownGeneLink.name (via dmBlastTab.query)
      hg16.knownGeneMrna.name (via dmBlastTab.query)
      hg16.knownGenePep.name (via dmBlastTab.query)
      hg16.knownIsoforms.transcript (via dmBlastTab.query)
      hg16.knownToEnsembl.name (via dmBlastTab.query)
      hg16.knownToGnfAtlas2.name (via dmBlastTab.query)
      hg16.knownToHInv.name (via dmBlastTab.query)
      hg16.knownToLocusLink.name (via dmBlastTab.query)
      hg16.knownToPfam.name (via dmBlastTab.query)
      hg16.knownToRefSeq.name (via dmBlastTab.query)
      hg16.knownToSuper.gene (via dmBlastTab.query)
      hg16.knownToU133.name (via dmBlastTab.query)
      hg16.knownToU95.name (via dmBlastTab.query)
      hg16.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
AB000114FBgn003604028.642131215852922644520.0000000000000575.48
AB000220FBgn001126031.156263532351643656471.3999999999999998e-68257.7
AB000277FBgn001063337.071166727909003804968.3e-1682.8
AB000449FBgn002788940.1734619361343113471.5e-65246.5
AB000459FBgn003810822.872231309262193565670.00002948.14
AB000460FBgn003810822.872231309262193565670.0000348.14
AB000461FBgn003810822.872231309262193565670.00001848.14
AB000462FBgn005177229.299965230129170117950.000004249.68
AB000468FBgn003738442.37592911311902583120.000000000361.23
AB000509FBgn002631937.9118210143785502254051.6999999999999998e-31134

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