Skip to main content
Schema for scBlastTab
  Database: hg38    Primary Table: scBlastTab    Row Count: 2,363   Data last updated: 2025-09-26
Format description: Blast alignments of S. cerevisiae 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 YBR058Cvarchar(255) values Name of sequence in other assembly (target)
identity 28.38float range Percent identity
aliLength 874int(10) unsigned range Length of alignment
mismatch 477int(10) unsigned range Number of mismatches
gapOpen 32int(10) unsigned range Number of gap openings
qStart 11int(10) unsigned range Start in query (0 based)
qEnd 833int(10) unsigned range End in query (non-inclusive)
tStart 4int(10) unsigned range Start in target (0 based)
tEnd 781int(10) unsigned range End in target (non-inclusive)
eValue 9e-73double range Expectation value
bitScore 270double range Bit score

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

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
ENST00000389231.9YBR058C28.38874477321183347819e-73270
ENST00000330877.7YNL220W57.1142917733245514292e-132467
ENST00000933281.1YDR023W47.2448920113147304492e-115410
ENST00000962856.1YER157W23.9463541117116700696833e-39158
ENST00000943172.1YBL040C49.7419390425211252183e-47182
ENST00000354619.10YML130C35.294081961760460694173e-53204
ENST00000918001.1YDR337W30.25119772241401152310.0000000652
ENST00000418909.6YAL047C30.5917010672544173425070.0000146.2
ENST00000340766.9YER133W85.76302430230413035e-159555
ENST00000913493.1YDR457W52.02421197438204240285132689e-125445

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