Skip to main content
Schema for drBlastTab
  Database: hg19    Primary Table: drBlastTab    Row Count: 13,785   Data last updated: 2025-09-29
Format description: Blast alignments of Zebrafish genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query ENST00000922753.1_1varchar(255) values Name of sequence in this assembly (query)
target ENSDART00000112784.4varchar(255) values Name of sequence in other assembly (target)
identity 64.94float range Percent identity
aliLength 77int(10) unsigned range Length of alignment
mismatch 27int(10) unsigned range Number of mismatches
gapOpen 0int(10) unsigned range Number of gap openings
qStart 0int(10) unsigned range Start in query (0 based)
qEnd 77int(10) unsigned range End in query (non-inclusive)
tStart 0int(10) unsigned range Start in target (0 based)
tEnd 77int(10) unsigned range End in target (non-inclusive)
eValue 2e-18double range Expectation value
bitScore 87.8double range Bit score

Connected Tables and Joining Fields
        hg19.bioCycPathway.kgID (via drBlastTab.query)
      hg19.ceBlastTab.query (via drBlastTab.query)
      hg19.dmBlastTab.query (via drBlastTab.query)
      hg19.foldUtr3.name (via drBlastTab.query)
      hg19.foldUtr5.name (via drBlastTab.query)
      hg19.gnfAtlas2Distance.query (via drBlastTab.query)
      hg19.gnfAtlas2Distance.target (via drBlastTab.query)
      hg19.gnfU95Distance.query (via drBlastTab.query)
      hg19.gnfU95Distance.target (via drBlastTab.query)
      hg19.humanHprdP2P.query (via drBlastTab.query)
      hg19.humanHprdP2P.target (via drBlastTab.query)
      hg19.humanVidalP2P.query (via drBlastTab.query)
      hg19.humanVidalP2P.target (via drBlastTab.query)
      hg19.humanWankerP2P.query (via drBlastTab.query)
      hg19.humanWankerP2P.target (via drBlastTab.query)
      hg19.keggPathway.kgID (via drBlastTab.query)
      hg19.kgAlias.kgID (via drBlastTab.query)
      hg19.kgColor.kgID (via drBlastTab.query)
      hg19.kgProtAlias.kgID (via drBlastTab.query)
      hg19.kgProtMap2.qName (via drBlastTab.query)
      hg19.kgSpAlias.kgID (via drBlastTab.query)
      hg19.kgTargetAli.qName (via drBlastTab.query)
      hg19.kgTxInfo.name (via drBlastTab.query)
      hg19.kgXref.kgID (via drBlastTab.query)
      hg19.knownAttrs.kgID (via drBlastTab.query)
      hg19.knownBlastTab.query (via drBlastTab.query)
      hg19.knownBlastTab.target (via drBlastTab.query)
      hg19.knownCanonical.transcript (via drBlastTab.query)
      hg19.knownCds.name (via drBlastTab.query)
      hg19.knownGene.name (via drBlastTab.query)
      hg19.knownGeneMrna.name (via drBlastTab.query)
      hg19.knownGenePep.name (via drBlastTab.query)
      hg19.knownGeneTxMrna.name (via drBlastTab.query)
      hg19.knownGeneTxPep.name (via drBlastTab.query)
      hg19.knownIsoforms.transcript (via drBlastTab.query)
      hg19.knownToAllenBrain.name (via drBlastTab.query)
      hg19.knownToEnsembl.name (via drBlastTab.query)
      hg19.knownToGnfAtlas2.name (via drBlastTab.query)
      hg19.knownToHInv.name (via drBlastTab.query)
      hg19.knownToHprd.name (via drBlastTab.query)
      hg19.knownToKeggEntrez.name (via drBlastTab.query)
      hg19.knownToLocusLink.name (via drBlastTab.query)
      hg19.knownToLynx.name (via drBlastTab.query)
      hg19.knownToMrna.name (via drBlastTab.query)
      hg19.knownToMrnaSingle.name (via drBlastTab.query)
      hg19.knownToMupit.name (via drBlastTab.query)
      hg19.knownToNextProt.name (via drBlastTab.query)
      hg19.knownToPfam.name (via drBlastTab.query)
      hg19.knownToRefSeq.name (via drBlastTab.query)
      hg19.knownToSuper.gene (via drBlastTab.query)
      hg19.knownToTag.name (via drBlastTab.query)
      hg19.knownToTreefam.name (via drBlastTab.query)
      hg19.knownToU133.name (via drBlastTab.query)
      hg19.knownToU133Plus2.name (via drBlastTab.query)
      hg19.knownToU95.name (via drBlastTab.query)
      hg19.knownToVisiGene.name (via drBlastTab.query)
      hg19.knownToWikipedia.name (via drBlastTab.query)
      hg19.mmBlastTab.query (via drBlastTab.query)
      hg19.rnBlastTab.query (via drBlastTab.query)
      hg19.scBlastTab.query (via drBlastTab.query)
      hg19.ucscScop.ucscId (via drBlastTab.query)
      knownGeneV39.bioCycPathway.kgID (via drBlastTab.query)
      knownGeneV39.ceBlastTab.query (via drBlastTab.query)
      knownGeneV39.dmBlastTab.query (via drBlastTab.query)
      knownGeneV39.drBlastTab.query (via drBlastTab.query)
      knownGeneV39.foldUtr3.name (via drBlastTab.query)
      knownGeneV39.foldUtr5.name (via drBlastTab.query)
      knownGeneV39.gnfAtlas2Distance.query (via drBlastTab.query)
      knownGeneV39.gnfAtlas2Distance.target (via drBlastTab.query)
      knownGeneV39.kgAlias.kgID (via drBlastTab.query)
      knownGeneV39.kgColor.kgID (via drBlastTab.query)
      knownGeneV39.kgProtAlias.kgID (via drBlastTab.query)
      knownGeneV39.kgSpAlias.kgID (via drBlastTab.query)
      knownGeneV39.kgTargetAli.qName (via drBlastTab.query)
      knownGeneV39.kgXref.kgID (via drBlastTab.query)
      knownGeneV39.knownAttrs.kgID (via drBlastTab.query)
      knownGeneV39.knownBlastTab.query (via drBlastTab.query)
      knownGeneV39.knownBlastTab.target (via drBlastTab.query)
      knownGeneV39.knownCanonical.protein (via drBlastTab.query)
      knownGeneV39.knownCanonical.transcript (via drBlastTab.query)
      knownGeneV39.knownCds.name (via drBlastTab.query)
      knownGeneV39.knownGene.name (via drBlastTab.query)
      knownGeneV39.knownGeneMrna.name (via drBlastTab.query)
      knownGeneV39.knownGenePep.name (via drBlastTab.query)
      knownGeneV39.knownIsoforms.transcript (via drBlastTab.query)
      knownGeneV39.knownToEnsembl.name (via drBlastTab.query)
      knownGeneV39.knownToGnfAtlas2.name (via drBlastTab.query)
      knownGeneV39.knownToHprd.name (via drBlastTab.query)
      knownGeneV39.knownToLocusLink.name (via drBlastTab.query)
      knownGeneV39.knownToMrna.name (via drBlastTab.query)
      knownGeneV39.knownToMrnaSingle.name (via drBlastTab.query)
      knownGeneV39.knownToMupit.name (via drBlastTab.query)
      knownGeneV39.knownToPfam.name (via drBlastTab.query)
      knownGeneV39.knownToRefSeq.name (via drBlastTab.query)
      knownGeneV39.knownToSuper.gene (via drBlastTab.query)
      knownGeneV39.knownToTag.name (via drBlastTab.query)
      knownGeneV39.knownToU133.name (via drBlastTab.query)
      knownGeneV39.knownToU95.name (via drBlastTab.query)
      knownGeneV39.knownToVisiGene.name (via drBlastTab.query)
      knownGeneV39.knownToWikipedia.name (via drBlastTab.query)
      knownGeneV39.mmBlastTab.query (via drBlastTab.query)
      knownGeneV39.rnBlastTab.query (via drBlastTab.query)
      knownGeneV39.scBlastTab.query (via drBlastTab.query)
      knownGeneV39.ucscScop.ucscId (via drBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
ENST00000922753.1_1ENSDART00000112784.464.94772700770772e-1887.8
ENST00000229633.7_4ENSDART00000110100.457.241526323018281582e-50195
ENST00000932304.1_1ENSDART00000131767.262.646211851317979105830639
ENST00000239174.7_8ENSDART00000110682.444.3132514112029703131e-47187
ENST00000528416.6_9ENSDART00000014031.1178.95399736039003977e-149524
ENST00000950109.1_1ENSDART00000193876.173.6579720541795079501246
ENST00000949099.1_1ENSDART00000165505.266.879813018169772199801358
ENST00000925226.1_1ENSDART00000162350.247.165627613058906523e-143506
ENST00000367963.8_8ENSDART00000182270.161.95573217121594235950737
ENST00000358522.7_9ENSDART00000129055.356.33632217910072085937e-173605

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