Schema for scBlastTab
  Database: hg38    Primary Table: scBlastTab    Row Count: 2,362   Data last updated: 2023-08-23
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
ENST00000261637.5YBL004W26.716894661618132493160122607e-58222
ENST00000330877.7YNL220W57.1142917733245514292e-132467
ENST00000478253.6YNR064C22.79272198661325202880.00000000000566.6
ENST00000354619.10YML130C35.294081961760460694173e-53204
ENST00000285814.9YNL110C35.2512270110132651789e-1782.4
ENST00000418909.6YAL047C30.5917010672544173425070.0000146.2
ENST00000340766.9YER133W85.76302430230413035e-159555
ENST00000685872.1YGL049C36.772911451291311785638411e-34144
ENST00000642017.2YBR035C38.05226123638261162284e-36145

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