Schema for dmBlastTab
  Database: hg38    Primary Table: dmBlastTab    Row Count: 6,031   Data last updated: 2024-08-19
Format description: Blast alignments of Drosophila genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query ENST00000389231.9varchar(255) values Name of sequence in this assembly (query)
target FBtr0445725varchar(255) values Name of sequence in other assembly (target)
identity 50.6float range Percent identity
aliLength 840int(10) unsigned range Length of alignment
mismatch 373int(10) unsigned range Number of mismatches
gapOpen 14int(10) unsigned range Number of gap openings
qStart 12int(10) unsigned range Start in query (0 based)
qEnd 832int(10) unsigned range End in query (non-inclusive)
tStart 7int(10) unsigned range Start in target (0 based)
tEnd 825int(10) unsigned range End in target (non-inclusive)
eValue 0double range Expectation value
bitScore 816double range Bit score

Connected Tables and Joining Fields
        hg38.bioCycPathway.kgID (via dmBlastTab.query)
      hg38.ccdsKgMap.geneId (via dmBlastTab.query)
      hg38.ceBlastTab.query (via dmBlastTab.query)
      hg38.drBlastTab.query (via dmBlastTab.query)
      hg38.foldUtr3.name (via dmBlastTab.query)
      hg38.foldUtr5.name (via dmBlastTab.query)
      hg38.gnfAtlas2Distance.query (via dmBlastTab.query)
      hg38.gnfAtlas2Distance.target (via dmBlastTab.query)
      hg38.gnfU95Distance.query (via dmBlastTab.query)
      hg38.gnfU95Distance.target (via dmBlastTab.query)
      hg38.humanHprdP2P.query (via dmBlastTab.query)
      hg38.humanHprdP2P.target (via dmBlastTab.query)
      hg38.humanVidalP2P.query (via dmBlastTab.query)
      hg38.humanVidalP2P.target (via dmBlastTab.query)
      hg38.humanWankerP2P.query (via dmBlastTab.query)
      hg38.humanWankerP2P.target (via dmBlastTab.query)
      hg38.keggPathway.kgID (via dmBlastTab.query)
      hg38.kgAlias.kgID (via dmBlastTab.query)
      hg38.kgColor.kgID (via dmBlastTab.query)
      hg38.kgProtAlias.kgID (via dmBlastTab.query)
      hg38.kgSpAlias.kgID (via dmBlastTab.query)
      hg38.kgTargetAli.qName (via dmBlastTab.query)
      hg38.kgXref.kgID (via dmBlastTab.query)
      hg38.knownAttrs.kgID (via dmBlastTab.query)
      hg38.knownBlastTab.query (via dmBlastTab.query)
      hg38.knownBlastTab.target (via dmBlastTab.query)
      hg38.knownCanonical.transcript (via dmBlastTab.query)
      hg38.knownCds.name (via dmBlastTab.query)
      hg38.knownGene.name (via dmBlastTab.query)
      hg38.knownGeneMrna.name (via dmBlastTab.query)
      hg38.knownGenePep.name (via dmBlastTab.query)
      hg38.knownIsoforms.transcript (via dmBlastTab.query)
      hg38.knownToEnsembl.name (via dmBlastTab.query)
      hg38.knownToGnfAtlas2.name (via dmBlastTab.query)
      hg38.knownToHprd.name (via dmBlastTab.query)
      hg38.knownToKeggEntrez.name (via dmBlastTab.query)
      hg38.knownToLocusLink.name (via dmBlastTab.query)
      hg38.knownToLynx.name (via dmBlastTab.query)
      hg38.knownToMrna.name (via dmBlastTab.query)
      hg38.knownToMrnaSingle.name (via dmBlastTab.query)
      hg38.knownToMupit.name (via dmBlastTab.query)
      hg38.knownToNextProt.name (via dmBlastTab.query)
      hg38.knownToPfam.name (via dmBlastTab.query)
      hg38.knownToRefSeq.name (via dmBlastTab.query)
      hg38.knownToSuper.gene (via dmBlastTab.query)
      hg38.knownToTag.name (via dmBlastTab.query)
      hg38.knownToU133.name (via dmBlastTab.query)
      hg38.knownToU95.name (via dmBlastTab.query)
      hg38.knownToVisiGene.name (via dmBlastTab.query)
      hg38.knownToWikipedia.name (via dmBlastTab.query)
      hg38.mmBlastTab.query (via dmBlastTab.query)
      hg38.rnBlastTab.query (via dmBlastTab.query)
      hg38.scBlastTab.query (via dmBlastTab.query)
      hg38.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
ENST00000389231.9FBtr044572550.6840373141283278250816
ENST00000261637.5FBtr007183325.832156139148669271760726631e-163576
ENST00000330877.7FBtr008399160.66427163330456234462e-148523
ENST00000374839.8FBtr007441747.45137702113681459e-25110
ENST00000271526.9FBtr007281039.251076113884913654726e-1683.2
ENST00000314163.12FBtr008740456.924481883044604453e-141499
ENST00000285814.9FBtr008426648.2511455215125171316e-25112
ENST00000537611.3FBtr030718022.915022781839466405082e-1891.3
ENST00000424405.5FBtr007693937.5208121444246492543e-36149
ENST00000295704.7FBtr033995336.5924614651525732432e-36150

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