Schema for knownToPfam
  Database: mm39    Primary Table: knownToPfam    Row Count: 107,088   Data last updated: 2024-08-15
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.5varchar(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.5PF00025
ENSMUST00000000001.5PF00503
ENSMUST00000000003.14PF00061
ENSMUST00000000010.9PF00046
ENSMUST00000000010.9PF04617
ENSMUST00000000028.14PF02724
ENSMUST00000000033.12PF00049
ENSMUST00000000033.12PF08365
ENSMUST00000000049.6PF00084
ENSMUST00000000049.6PF09014

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