Schema for knownToPfam
  Database: hg17    Primary Table: knownToPfam    Row Count: 35,789   Data last updated: 2005-07-14
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 NM_001005484varchar(255) values primary ID
value PF00001varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg17.bioCycPathway.kgID (via knownToPfam.name)
      hg17.ccdsKgMap.geneId (via knownToPfam.name)
      hg17.ceBlastTab.query (via knownToPfam.name)
      hg17.dmBlastTab.query (via knownToPfam.name)
      hg17.drBlastTab.query (via knownToPfam.name)
      hg17.dupSpMrna.mrnaID (via knownToPfam.name)
      hg17.foldUtr3.name (via knownToPfam.name)
      hg17.foldUtr5.name (via knownToPfam.name)
      hg17.gladHumESDistance.query (via knownToPfam.name)
      hg17.gladHumESDistance.target (via knownToPfam.name)
      hg17.gnfAtlas2Distance.query (via knownToPfam.name)
      hg17.gnfAtlas2Distance.target (via knownToPfam.name)
      hg17.gnfU95Distance.query (via knownToPfam.name)
      hg17.gnfU95Distance.target (via knownToPfam.name)
      hg17.humanHprdP2P.query (via knownToPfam.name)
      hg17.humanHprdP2P.target (via knownToPfam.name)
      hg17.humanVidalP2P.query (via knownToPfam.name)
      hg17.humanVidalP2P.target (via knownToPfam.name)
      hg17.humanWankerP2P.query (via knownToPfam.name)
      hg17.humanWankerP2P.target (via knownToPfam.name)
      hg17.keggPathway.kgID (via knownToPfam.name)
      hg17.kgAlias.kgID (via knownToPfam.name)
      hg17.kgProtAlias.kgID (via knownToPfam.name)
      hg17.kgSpAlias.kgID (via knownToPfam.name)
      hg17.kgTargetAli.qName (via knownToPfam.name)
      hg17.kgXref.kgID (via knownToPfam.name)
      hg17.knownBlastTab.query (via knownToPfam.name)
      hg17.knownBlastTab.target (via knownToPfam.name)
      hg17.knownCanonical.transcript (via knownToPfam.name)
      hg17.knownExpDistance.query (via knownToPfam.name)
      hg17.knownExpDistance.target (via knownToPfam.name)
      hg17.knownGene.name (via knownToPfam.name)
      hg17.knownGeneLink.name (via knownToPfam.name)
      hg17.knownGeneMrna.name (via knownToPfam.name)
      hg17.knownGenePep.name (via knownToPfam.name)
      hg17.knownIsoforms.transcript (via knownToPfam.name)
      hg17.knownToAllenBrain.name (via knownToPfam.name)
      hg17.knownToEnsembl.name (via knownToPfam.name)
      hg17.knownToGnf1h.name (via knownToPfam.name)
      hg17.knownToGnfAtlas2.name (via knownToPfam.name)
      hg17.knownToHInv.name (via knownToPfam.name)
      hg17.knownToHprd.name (via knownToPfam.name)
      hg17.knownToKeggEntrez.name (via knownToPfam.name)
      hg17.knownToLocusLink.name (via knownToPfam.name)
      hg17.knownToRefSeq.name (via knownToPfam.name)
      hg17.knownToSuper.gene (via knownToPfam.name)
      hg17.knownToU133.name (via knownToPfam.name)
      hg17.knownToU133Plus2.name (via knownToPfam.name)
      hg17.knownToU95.name (via knownToPfam.name)
      hg17.knownToVisiGene.name (via knownToPfam.name)
      hg17.mmBlastTab.query (via knownToPfam.name)
      hg17.rankProp.query (via knownToPfam.name)
      hg17.rankProp.target (via knownToPfam.name)
      hg17.rnBlastTab.query (via knownToPfam.name)
      hg17.scBlastTab.query (via knownToPfam.name)
      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)
      knownGeneV39.knownToPfam.value (via knownToPfam.value)
      knownGeneV39.pfamDesc.pfamAC (via knownToPfam.value)

Sample Rows
 
namevalue
NM_001005484PF00001
NM_001005221PF00001
BC024295PF07647
AK054643PF07647
NM_152486PF07647
AK022756PF03715
AK092491PF03715
NM_015658PF03715
BC003555PF03715
NM_198317PF00651

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