Schema for dmBlastTab
  Database: hg18    Primary Table: dmBlastTab    Row Count: 5,946   Data last updated: 2009-03-03
Format description: Blast alignments of Drosophila genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query uc010fpt.1varchar(255) values Name of sequence in this assembly (query)
target CG8668-RAvarchar(255) values Name of sequence in other assembly (target)
identity 33.73float range Percent identity
aliLength 249int(10) unsigned range Length of alignment
mismatch 158int(10) unsigned range Number of mismatches
gapOpen 4int(10) unsigned range Number of gap openings
qStart 72int(10) unsigned range Start in query (0 based)
qEnd 318int(10) unsigned range End in query (non-inclusive)
tStart 332int(10) unsigned range Start in target (0 based)
tEnd 577int(10) unsigned range End in target (non-inclusive)
eValue 1e-36double range Expectation value
bitScore 150double range Bit score

Connected Tables and Joining Fields
        hg18.bioCycPathway.kgID (via dmBlastTab.query)
      hg18.ccdsKgMap.geneId (via dmBlastTab.query)
      hg18.ceBlastTab.query (via dmBlastTab.query)
      hg18.drBlastTab.query (via dmBlastTab.query)
      hg18.foldUtr3.name (via dmBlastTab.query)
      hg18.foldUtr5.name (via dmBlastTab.query)
      hg18.gnfAtlas2Distance.query (via dmBlastTab.query)
      hg18.gnfAtlas2Distance.target (via dmBlastTab.query)
      hg18.gnfU95Distance.query (via dmBlastTab.query)
      hg18.gnfU95Distance.target (via dmBlastTab.query)
      hg18.humanHprdP2P.query (via dmBlastTab.query)
      hg18.humanHprdP2P.target (via dmBlastTab.query)
      hg18.humanVidalP2P.query (via dmBlastTab.query)
      hg18.humanVidalP2P.target (via dmBlastTab.query)
      hg18.humanWankerP2P.query (via dmBlastTab.query)
      hg18.humanWankerP2P.target (via dmBlastTab.query)
      hg18.keggPathway.kgID (via dmBlastTab.query)
      hg18.kgAlias.kgID (via dmBlastTab.query)
      hg18.kgColor.kgID (via dmBlastTab.query)
      hg18.kgProtAlias.kgID (via dmBlastTab.query)
      hg18.kgProtMap2.qName (via dmBlastTab.query)
      hg18.kgSpAlias.kgID (via dmBlastTab.query)
      hg18.kgTargetAli.qName (via dmBlastTab.query)
      hg18.kgTxInfo.name (via dmBlastTab.query)
      hg18.kgXref.kgID (via dmBlastTab.query)
      hg18.knownBlastTab.query (via dmBlastTab.query)
      hg18.knownBlastTab.target (via dmBlastTab.query)
      hg18.knownCanonToDecipher.name (via dmBlastTab.query)
      hg18.knownCanonical.protein (via dmBlastTab.query)
      hg18.knownCanonical.transcript (via dmBlastTab.query)
      hg18.knownGene.name (via dmBlastTab.query)
      hg18.knownGeneMrna.name (via dmBlastTab.query)
      hg18.knownGenePep.name (via dmBlastTab.query)
      hg18.knownIsoforms.transcript (via dmBlastTab.query)
      hg18.knownToAllenBrain.name (via dmBlastTab.query)
      hg18.knownToDecipher.name (via dmBlastTab.query)
      hg18.knownToEnsembl.name (via dmBlastTab.query)
      hg18.knownToGnf1h.name (via dmBlastTab.query)
      hg18.knownToGnfAtlas2.name (via dmBlastTab.query)
      hg18.knownToHInv.name (via dmBlastTab.query)
      hg18.knownToHprd.name (via dmBlastTab.query)
      hg18.knownToKeggEntrez.name (via dmBlastTab.query)
      hg18.knownToLocusLink.name (via dmBlastTab.query)
      hg18.knownToMupit.name (via dmBlastTab.query)
      hg18.knownToPfam.name (via dmBlastTab.query)
      hg18.knownToRefSeq.name (via dmBlastTab.query)
      hg18.knownToSuper.gene (via dmBlastTab.query)
      hg18.knownToTreefam.name (via dmBlastTab.query)
      hg18.knownToU133.name (via dmBlastTab.query)
      hg18.knownToU133Plus2.name (via dmBlastTab.query)
      hg18.knownToU95.name (via dmBlastTab.query)
      hg18.knownToVisiGene.name (via dmBlastTab.query)
      hg18.mmBlastTab.query (via dmBlastTab.query)
      hg18.rnBlastTab.query (via dmBlastTab.query)
      hg18.scBlastTab.query (via dmBlastTab.query)
      hg18.ucscScop.ucscId (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
uc010fpt.1CG8668-RA33.732491584723183325771e-36150
uc003szn.1CG12054-RA44.212331183623012319.999999999999999e-43169
uc003trd.1CG4326-RA35.79956101210771020.0000000000000273.9
uc003uid.1CG11144-RA47.648904081732872389200778
uc010gfz.1CG4867-RA62.82782310720782e-22100
uc010ggq.1CG9310-RD63.973581183273741204786e-124441
uc003syt.1CG11648-RE50.891125501602721182307.000000000000001e-23104
uc003ugs.2CG3268-RA48.8534815564557845348788.000000000000001e-82301
uc003tqg.1CG8860-RA86.5767900670671e-1887.4
uc003szf.1CG15093-RA49.49293146141334303213e-79291

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