Skip to main content
Schema for knownToSuper
  Database: mm39    Primary Table: knownToSuper    Row Count: 705,961   Data last updated: 2026-07-12
Format description: Map protein superfamilies to known genes
On download server: MariaDB table dump directory
fieldexampleSQL type description
gene ENSMUST00000000001.6varchar(255) Known gene ID
superfamily 47895int(11) Superfamily ID
start 60int(11) Start of superfamily domain in protein (0 based)
end 181int(11) End (noninclusive) of superfamily domain
eVal 2.8026e-45float E value of superfamily assignment

Connected Tables and Joining Fields
        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)
      mm39.bioCycPathway.kgID (via knownToSuper.gene)
      mm39.ceBlastTab.query (via knownToSuper.gene)
      mm39.dmBlastTab.query (via knownToSuper.gene)
      mm39.drBlastTab.query (via knownToSuper.gene)
      mm39.foldUtr3.name (via knownToSuper.gene)
      mm39.foldUtr5.name (via knownToSuper.gene)
      mm39.hgBlastTab.query (via knownToSuper.gene)
      mm39.kgAlias.kgID (via knownToSuper.gene)
      mm39.kgColor.kgID (via knownToSuper.gene)
      mm39.kgProtAlias.kgID (via knownToSuper.gene)
      mm39.kgSpAlias.kgID (via knownToSuper.gene)
      mm39.kgTargetAli.qName (via knownToSuper.gene)
      mm39.kgXref.kgID (via knownToSuper.gene)
      mm39.knownAttrs.kgID (via knownToSuper.gene)
      mm39.knownBlastTab.query (via knownToSuper.gene)
      mm39.knownBlastTab.target (via knownToSuper.gene)
      mm39.knownCanonical.transcript (via knownToSuper.gene)
      mm39.knownCds.name (via knownToSuper.gene)
      mm39.knownGene.name (via knownToSuper.gene)
      mm39.knownGeneMrna.name (via knownToSuper.gene)
      mm39.knownIsoforms.transcript (via knownToSuper.gene)
      mm39.knownToEnsembl.name (via knownToSuper.gene)
      mm39.knownToLocusLink.name (via knownToSuper.gene)
      mm39.knownToMrna.name (via knownToSuper.gene)
      mm39.knownToMrnaSingle.name (via knownToSuper.gene)
      mm39.knownToMupit.name (via knownToSuper.gene)
      mm39.knownToNextProt.name (via knownToSuper.gene)
      mm39.knownToPfam.name (via knownToSuper.gene)
      mm39.knownToRefSeq.name (via knownToSuper.gene)
      mm39.knownToTag.name (via knownToSuper.gene)
      mm39.knownToVisiGene.name (via knownToSuper.gene)
      mm39.knownToWikipedia.name (via knownToSuper.gene)
      mm39.rnBlastTab.query (via knownToSuper.gene)
      mm39.scBlastTab.query (via knownToSuper.gene)
      mm39.ucscScop.ucscId (via knownToSuper.gene)

Sample Rows
 
genesuperfamilystartendeVal
ENSMUST00000000001.647895601812.8026e-45
ENSMUST00000000001.652540143520
ENSMUST00000000003.145081461710
ENSMUST00000000010.10466891712475.5e-29
ENSMUST00000000028.1564182141040.000013
ENSMUST00000000028.15641821892260.000013
ENSMUST00000000033.125699416918.4e-21
ENSMUST00000000049.757535203450
ENSMUST00000000080.85766781980.00000039
ENSMUST00000000080.8576672313175e-28

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