Schema for drBlastTab
  Database: hg38    Primary Table: drBlastTab    Row Count: 13,556   Data last updated: 2023-08-22
Format description: Blast alignments of Zebrafish genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query ENST00000370447.3varchar(255) values Name of sequence in this assembly (query)
target ENSDART00000192225.1varchar(255) values Name of sequence in other assembly (target)
identity 45.12float range Percent identity
aliLength 328int(10) unsigned range Length of alignment
mismatch 156int(10) unsigned range Number of mismatches
gapOpen 7int(10) unsigned range Number of gap openings
qStart 76int(10) unsigned range Start in query (0 based)
qEnd 393int(10) unsigned range End in query (non-inclusive)
tStart 118int(10) unsigned range Start in target (0 based)
tEnd 433int(10) unsigned range End in target (non-inclusive)
eValue 2e-56double range Expectation value
bitScore 218double range Bit score

Connected Tables and Joining Fields
        hg38.bioCycPathway.kgID (via drBlastTab.query)
      hg38.ccdsKgMap.geneId (via drBlastTab.query)
      hg38.ceBlastTab.query (via drBlastTab.query)
      hg38.dmBlastTab.query (via drBlastTab.query)
      hg38.foldUtr3.name (via drBlastTab.query)
      hg38.foldUtr5.name (via drBlastTab.query)
      hg38.gnfAtlas2Distance.query (via drBlastTab.query)
      hg38.gnfAtlas2Distance.target (via drBlastTab.query)
      hg38.gnfU95Distance.query (via drBlastTab.query)
      hg38.gnfU95Distance.target (via drBlastTab.query)
      hg38.humanHprdP2P.query (via drBlastTab.query)
      hg38.humanHprdP2P.target (via drBlastTab.query)
      hg38.humanVidalP2P.query (via drBlastTab.query)
      hg38.humanVidalP2P.target (via drBlastTab.query)
      hg38.humanWankerP2P.query (via drBlastTab.query)
      hg38.humanWankerP2P.target (via drBlastTab.query)
      hg38.keggPathway.kgID (via drBlastTab.query)
      hg38.kgAlias.kgID (via drBlastTab.query)
      hg38.kgColor.kgID (via drBlastTab.query)
      hg38.kgProtAlias.kgID (via drBlastTab.query)
      hg38.kgSpAlias.kgID (via drBlastTab.query)
      hg38.kgTargetAli.qName (via drBlastTab.query)
      hg38.kgXref.kgID (via drBlastTab.query)
      hg38.knownAttrs.kgID (via drBlastTab.query)
      hg38.knownBlastTab.query (via drBlastTab.query)
      hg38.knownBlastTab.target (via drBlastTab.query)
      hg38.knownCanonical.transcript (via drBlastTab.query)
      hg38.knownCds.name (via drBlastTab.query)
      hg38.knownGene.name (via drBlastTab.query)
      hg38.knownGeneMrna.name (via drBlastTab.query)
      hg38.knownGenePep.name (via drBlastTab.query)
      hg38.knownIsoforms.transcript (via drBlastTab.query)
      hg38.knownToEnsembl.name (via drBlastTab.query)
      hg38.knownToGnfAtlas2.name (via drBlastTab.query)
      hg38.knownToHprd.name (via drBlastTab.query)
      hg38.knownToKeggEntrez.name (via drBlastTab.query)
      hg38.knownToLocusLink.name (via drBlastTab.query)
      hg38.knownToLynx.name (via drBlastTab.query)
      hg38.knownToMrna.name (via drBlastTab.query)
      hg38.knownToMrnaSingle.name (via drBlastTab.query)
      hg38.knownToMupit.name (via drBlastTab.query)
      hg38.knownToNextProt.name (via drBlastTab.query)
      hg38.knownToPfam.name (via drBlastTab.query)
      hg38.knownToRefSeq.name (via drBlastTab.query)
      hg38.knownToSuper.gene (via drBlastTab.query)
      hg38.knownToTag.name (via drBlastTab.query)
      hg38.knownToU133.name (via drBlastTab.query)
      hg38.knownToU95.name (via drBlastTab.query)
      hg38.knownToVisiGene.name (via drBlastTab.query)
      hg38.knownToWikipedia.name (via drBlastTab.query)
      hg38.mmBlastTab.query (via drBlastTab.query)
      hg38.rnBlastTab.query (via drBlastTab.query)
      hg38.scBlastTab.query (via drBlastTab.query)
      hg38.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
ENST00000370447.3ENSDART00000192225.145.123281567763931184332e-56218
ENST00000409123.5ENSDART00000192353.15010642332130171202e-1891.3
ENST00000389231.9ENSDART00000148666.369.088282449118331083201145
ENST00000380338.9ENSDART00000021502.955.5856521283256805557e-105379
ENST00000626639.1ENSDART00000157450.274.5161215231262296190881
ENST00000409122.7ENSDART00000124559.358.951907717269156308204e-60231
ENST00000261637.5ENSDART00000166591.256.832810116811027842279303006
ENST00000371436.10ENSDART00000105394.379.33508557049904670677
ENST00000333407.11ENSDART00000103592.647.563071522030702982e-79294
ENST00000370445.5ENSDART00000190933.187.042473111413871173645e-122435

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