Schema for drBlastTab
  Database: hg19    Primary Table: drBlastTab    Row Count: 13,545   Data last updated: 2024-08-23
Format description: Blast alignments of Zebrafish genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query ENST00000229633.7_4varchar(255) values Name of sequence in this assembly (query)
target ENSDART00000110100.4varchar(255) values Name of sequence in other assembly (target)
identity 57.24float range Percent identity
aliLength 152int(10) unsigned range Length of alignment
mismatch 63int(10) unsigned range Number of mismatches
gapOpen 2int(10) unsigned range Number of gap openings
qStart 30int(10) unsigned range Start in query (0 based)
qEnd 182int(10) unsigned range End in query (non-inclusive)
tStart 8int(10) unsigned range Start in target (0 based)
tEnd 158int(10) unsigned range End in target (non-inclusive)
eValue 2e-50double range Expectation value
bitScore 195double 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.knownCanonToDecipher.name (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.knownToDecipher.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
ENST00000229633.7_4ENSDART00000110100.457.241526323018281582e-50195
ENST00000410068.5_5ENSDART00000144353.273.94449111215458224710643
ENST00000239174.7_8ENSDART00000110682.444.3132514112029703131e-47187
ENST00000528416.6_8ENSDART00000014031.1178.95399736039003977e-149524
ENST00000367963.8_7ENSDART00000182270.161.95573217121594235950737
ENST00000538234.5_10ENSDART00000016310.766.5451414512050804937e-178621
ENST00000382263.3_3ENSDART00000061351.757.38305122415320153129e-87318
ENST00000358522.7_7ENSDART00000129055.356.33632217910072085937e-173605
ENST00000370250.8_7ENSDART00000182680.150.838423601824838288440675
ENST00000374606.10_4ENSDART00000053936.776.07117280011701176e-46179

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