Schema for knownToPfam
  Database: mm10    Primary Table: knownToPfam    Row Count: 105,610   Data last updated: 2019-09-20
Format description: Map a primary ID to another type of ID, label, quantity etc.
fieldexampleSQL type info description
name ENSMUST00000000001.4varchar(255) values primary ID
value PF00025varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        mm10.bioCycPathway.kgID (via knownToPfam.name)
      mm10.ccdsKgMap.geneId (via knownToPfam.name)
      mm10.ceBlastTab.query (via knownToPfam.name)
      mm10.dmBlastTab.query (via knownToPfam.name)
      mm10.drBlastTab.query (via knownToPfam.name)
      mm10.foldUtr3.name (via knownToPfam.name)
      mm10.foldUtr5.name (via knownToPfam.name)
      mm10.hgBlastTab.query (via knownToPfam.name)
      mm10.keggPathway.kgID (via knownToPfam.name)
      mm10.kgAlias.kgID (via knownToPfam.name)
      mm10.kgColor.kgID (via knownToPfam.name)
      mm10.kgProtAlias.kgID (via knownToPfam.name)
      mm10.kgProtMap2.qName (via knownToPfam.name)
      mm10.kgSpAlias.kgID (via knownToPfam.name)
      mm10.kgTargetAli.qName (via knownToPfam.name)
      mm10.kgTxInfo.name (via knownToPfam.name)
      mm10.kgXref.kgID (via knownToPfam.name)
      mm10.knownAttrs.kgID (via knownToPfam.name)
      mm10.knownBlastTab.query (via knownToPfam.name)
      mm10.knownBlastTab.target (via knownToPfam.name)
      mm10.knownCanonical.transcript (via knownToPfam.name)
      mm10.knownCds.name (via knownToPfam.name)
      mm10.knownGene.name (via knownToPfam.name)
      mm10.knownGeneMrna.name (via knownToPfam.name)
      mm10.knownGenePep.name (via knownToPfam.name)
      mm10.knownIsoforms.transcript (via knownToPfam.name)
      mm10.knownToEnsembl.name (via knownToPfam.name)
      mm10.knownToKeggEntrez.name (via knownToPfam.name)
      mm10.knownToLocusLink.name (via knownToPfam.name)
      mm10.knownToLynx.name (via knownToPfam.name)
      mm10.knownToMrna.name (via knownToPfam.name)
      mm10.knownToMrnaSingle.name (via knownToPfam.name)
      mm10.knownToRefSeq.name (via knownToPfam.name)
      mm10.knownToSuper.gene (via knownToPfam.name)
      mm10.knownToTag.name (via knownToPfam.name)
      mm10.knownToVisiGene.name (via knownToPfam.name)
      mm10.knownToWikipedia.name (via knownToPfam.name)
      mm10.rnBlastTab.query (via knownToPfam.name)
      mm10.scBlastTab.query (via knownToPfam.name)
      mm10.ucscScop.ucscId (via knownToPfam.name)
      mm10.pfamDesc.pfamAC (via knownToPfam.value)

Sample Rows
 
namevalue
ENSMUST00000000001.4PF00025
ENSMUST00000000001.4PF00503
ENSMUST00000000003.13PF00061
ENSMUST00000000010.8PF00046
ENSMUST00000000010.8PF04617
ENSMUST00000000028.13PF02724
ENSMUST00000000033.11PF00049
ENSMUST00000000033.11PF08365
ENSMUST00000000049.5PF00084
ENSMUST00000000049.5PF09014

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