Skip to main content
Schema for knownToPfam
  Database: mm39    Primary Table: knownToPfam    Row Count: 419,889   Data last updated: 2026-07-12
Format description: Map a primary ID to another type of ID, label, quantity etc.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSMUST00000000001.6varchar(255) values primary ID
value PF00025varchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
ENSMUST00000000001.6PF00025
ENSMUST00000000001.6PF00503
ENSMUST00000000003.14PF00061
ENSMUST00000000010.10PF00046
ENSMUST00000000010.10PF04617
ENSMUST00000000028.15PF02724
ENSMUST00000000033.12PF00049
ENSMUST00000000033.12PF08365
ENSMUST00000000049.7PF00084
ENSMUST00000000049.7PF09014

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