Skip to main content
Schema for knownToSuper
  Database: hg19    Primary Table: knownToSuper    Row Count: 791,654   Data last updated: 2025-09-29
Format description: Map protein superfamilies to known genes
On download server: MariaDB table dump directory
fieldexampleSQL type description
gene ENST00000000233.10_4varchar(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
        hg19.bioCycPathway.kgID (via knownToSuper.gene)
      hg19.ceBlastTab.query (via knownToSuper.gene)
      hg19.dmBlastTab.query (via knownToSuper.gene)
      hg19.drBlastTab.query (via knownToSuper.gene)
      hg19.foldUtr3.name (via knownToSuper.gene)
      hg19.foldUtr5.name (via knownToSuper.gene)
      hg19.gnfAtlas2Distance.query (via knownToSuper.gene)
      hg19.gnfAtlas2Distance.target (via knownToSuper.gene)
      hg19.gnfU95Distance.query (via knownToSuper.gene)
      hg19.gnfU95Distance.target (via knownToSuper.gene)
      hg19.humanHprdP2P.query (via knownToSuper.gene)
      hg19.humanHprdP2P.target (via knownToSuper.gene)
      hg19.humanVidalP2P.query (via knownToSuper.gene)
      hg19.humanVidalP2P.target (via knownToSuper.gene)
      hg19.humanWankerP2P.query (via knownToSuper.gene)
      hg19.humanWankerP2P.target (via knownToSuper.gene)
      hg19.keggPathway.kgID (via knownToSuper.gene)
      hg19.kgAlias.kgID (via knownToSuper.gene)
      hg19.kgColor.kgID (via knownToSuper.gene)
      hg19.kgProtAlias.kgID (via knownToSuper.gene)
      hg19.kgProtMap2.qName (via knownToSuper.gene)
      hg19.kgSpAlias.kgID (via knownToSuper.gene)
      hg19.kgTargetAli.qName (via knownToSuper.gene)
      hg19.kgTxInfo.name (via knownToSuper.gene)
      hg19.kgXref.kgID (via knownToSuper.gene)
      hg19.knownAttrs.kgID (via knownToSuper.gene)
      hg19.knownBlastTab.query (via knownToSuper.gene)
      hg19.knownBlastTab.target (via knownToSuper.gene)
      hg19.knownCanonical.transcript (via knownToSuper.gene)
      hg19.knownCds.name (via knownToSuper.gene)
      hg19.knownGene.name (via knownToSuper.gene)
      hg19.knownGeneMrna.name (via knownToSuper.gene)
      hg19.knownGenePep.name (via knownToSuper.gene)
      hg19.knownGeneTxMrna.name (via knownToSuper.gene)
      hg19.knownGeneTxPep.name (via knownToSuper.gene)
      hg19.knownIsoforms.transcript (via knownToSuper.gene)
      hg19.knownToAllenBrain.name (via knownToSuper.gene)
      hg19.knownToEnsembl.name (via knownToSuper.gene)
      hg19.knownToGnfAtlas2.name (via knownToSuper.gene)
      hg19.knownToHInv.name (via knownToSuper.gene)
      hg19.knownToHprd.name (via knownToSuper.gene)
      hg19.knownToKeggEntrez.name (via knownToSuper.gene)
      hg19.knownToLocusLink.name (via knownToSuper.gene)
      hg19.knownToLynx.name (via knownToSuper.gene)
      hg19.knownToMrna.name (via knownToSuper.gene)
      hg19.knownToMrnaSingle.name (via knownToSuper.gene)
      hg19.knownToMupit.name (via knownToSuper.gene)
      hg19.knownToNextProt.name (via knownToSuper.gene)
      hg19.knownToPfam.name (via knownToSuper.gene)
      hg19.knownToRefSeq.name (via knownToSuper.gene)
      hg19.knownToTag.name (via knownToSuper.gene)
      hg19.knownToTreefam.name (via knownToSuper.gene)
      hg19.knownToU133.name (via knownToSuper.gene)
      hg19.knownToU133Plus2.name (via knownToSuper.gene)
      hg19.knownToU95.name (via knownToSuper.gene)
      hg19.knownToVisiGene.name (via knownToSuper.gene)
      hg19.knownToWikipedia.name (via knownToSuper.gene)
      hg19.mmBlastTab.query (via knownToSuper.gene)
      hg19.rnBlastTab.query (via knownToSuper.gene)
      hg19.scBlastTab.query (via knownToSuper.gene)
      hg19.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.10_45254051780
ENST00000000412.350911291823.5e-37
ENST00000000442.11_8485081254220
ENST00000000442.11_857716751624.1e-33
ENST00000001008.6_5819012483900.00000000000001
ENST00000001008.6_5484392744150.000000000046
ENST00000001008.6_5484522334161.9e-36
ENST00000001008.6_554534222680
ENST00000001146.7_748264444900
ENST00000002125.9_453335414100

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