Skip to main content
Schema for drBlastTab
  Database: hg19    Primary Table: drBlastTab    Row Count: 13,939   Data last updated: 2026-07-16
Format description: Blast alignments of Zebrafish genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query ENST00000950109.2_2varchar(255) values Name of sequence in this assembly (query)
target ENSDART00000193876.1varchar(255) values Name of sequence in other assembly (target)
identity 73.65float range Percent identity
aliLength 797int(10) unsigned range Length of alignment
mismatch 205int(10) unsigned range Number of mismatches
gapOpen 4int(10) unsigned range Number of gap openings
qStart 1int(10) unsigned range Start in query (0 based)
qEnd 795int(10) unsigned range End in query (non-inclusive)
tStart 0int(10) unsigned range Start in target (0 based)
tEnd 795int(10) unsigned range End in target (non-inclusive)
eValue 0double range Expectation value
bitScore 1246double 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
ENST00000950109.2_2ENSDART00000193876.173.6579720541795079501246
ENST00000932304.1_2ENSDART00000131767.262.646211851317979105830639
ENST00000239174.7_8ENSDART00000110682.444.3132514112029703131e-47187
ENST00000370250.9_8ENSDART00000182680.150.838423601824838288440675
ENST00000367963.8_8ENSDART00000182270.161.95573217121594235950737
ENST00000969278.2_2ENSDART00000132354.252.8650716411043405052e-94344
ENST00001143377.1_1ENSDART00000131846.270.42693178948734206930932
ENST00001145751.1_1ENSDART00000078167.543.1331315991732832992e-48190
ENST00000389428.8_4ENSDART00000123661.472.7999624814139981599901478
ENST00000910739.2_2ENSDART00000154684.245.98970462191596839280729

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