Skip to main content
Schema for knownToSuper
  Database: hg38    Primary Table: knownToSuper    Row Count: 815,853   Data last updated: 2025-09-26
Format description: Map protein superfamilies to known genes
On download server: MariaDB table dump directory
fieldexampleSQL type description
gene ENST00000000233.10varchar(255) Known gene ID
superfamily 52540int(11) Superfamily ID
start 5int(11) Start of superfamily domain in protein (0 based)
end 178int(11) End (noninclusive) of superfamily domain
eVal 0float E value of superfamily assignment

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

Sample Rows
 
genesuperfamilystartendeVal
ENST00000000233.105254051780
ENST00000000412.850911291825.9e-37
ENST00000000442.11485081254220
ENST00000000442.1157716751625.2e-33
ENST00000001008.6819012483900.000000000000017
ENST00000001008.6484392744150.000000000079
ENST00000001008.6484522334163.3e-36
ENST00000001008.654534222680
ENST00000001146.748264444900
ENST00000002125.953335414100

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