Schema for knownToPfam
  Database: hg18    Primary Table: knownToPfam    Row Count: 100,691   Data last updated: 2009-03-03
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 uc009vjh.1varchar(255) values primary ID
value PF00001varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg18.bioCycPathway.kgID (via knownToPfam.name)
      hg18.ccdsKgMap.geneId (via knownToPfam.name)
      hg18.ceBlastTab.query (via knownToPfam.name)
      hg18.dmBlastTab.query (via knownToPfam.name)
      hg18.drBlastTab.query (via knownToPfam.name)
      hg18.foldUtr3.name (via knownToPfam.name)
      hg18.foldUtr5.name (via knownToPfam.name)
      hg18.gnfAtlas2Distance.query (via knownToPfam.name)
      hg18.gnfAtlas2Distance.target (via knownToPfam.name)
      hg18.gnfU95Distance.query (via knownToPfam.name)
      hg18.gnfU95Distance.target (via knownToPfam.name)
      hg18.humanHprdP2P.query (via knownToPfam.name)
      hg18.humanHprdP2P.target (via knownToPfam.name)
      hg18.humanVidalP2P.query (via knownToPfam.name)
      hg18.humanVidalP2P.target (via knownToPfam.name)
      hg18.humanWankerP2P.query (via knownToPfam.name)
      hg18.humanWankerP2P.target (via knownToPfam.name)
      hg18.keggPathway.kgID (via knownToPfam.name)
      hg18.kgAlias.kgID (via knownToPfam.name)
      hg18.kgColor.kgID (via knownToPfam.name)
      hg18.kgProtAlias.kgID (via knownToPfam.name)
      hg18.kgProtMap2.qName (via knownToPfam.name)
      hg18.kgSpAlias.kgID (via knownToPfam.name)
      hg18.kgTargetAli.qName (via knownToPfam.name)
      hg18.kgTxInfo.name (via knownToPfam.name)
      hg18.kgXref.kgID (via knownToPfam.name)
      hg18.knownBlastTab.query (via knownToPfam.name)
      hg18.knownBlastTab.target (via knownToPfam.name)
      hg18.knownCanonToDecipher.name (via knownToPfam.name)
      hg18.knownCanonical.protein (via knownToPfam.name)
      hg18.knownCanonical.transcript (via knownToPfam.name)
      hg18.knownGene.name (via knownToPfam.name)
      hg18.knownGeneMrna.name (via knownToPfam.name)
      hg18.knownGenePep.name (via knownToPfam.name)
      hg18.knownIsoforms.transcript (via knownToPfam.name)
      hg18.knownToAllenBrain.name (via knownToPfam.name)
      hg18.knownToDecipher.name (via knownToPfam.name)
      hg18.knownToEnsembl.name (via knownToPfam.name)
      hg18.knownToGnf1h.name (via knownToPfam.name)
      hg18.knownToGnfAtlas2.name (via knownToPfam.name)
      hg18.knownToHInv.name (via knownToPfam.name)
      hg18.knownToHprd.name (via knownToPfam.name)
      hg18.knownToKeggEntrez.name (via knownToPfam.name)
      hg18.knownToLocusLink.name (via knownToPfam.name)
      hg18.knownToMupit.name (via knownToPfam.name)
      hg18.knownToRefSeq.name (via knownToPfam.name)
      hg18.knownToSuper.gene (via knownToPfam.name)
      hg18.knownToTreefam.name (via knownToPfam.name)
      hg18.knownToU133.name (via knownToPfam.name)
      hg18.knownToU133Plus2.name (via knownToPfam.name)
      hg18.knownToU95.name (via knownToPfam.name)
      hg18.knownToVisiGene.name (via knownToPfam.name)
      hg18.mmBlastTab.query (via knownToPfam.name)
      hg18.rnBlastTab.query (via knownToPfam.name)
      hg18.scBlastTab.query (via knownToPfam.name)
      hg18.ucscScop.ucscId (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)
      hg18.pfamDesc.pfamAC (via knownToPfam.value)
      knownGeneV39.knownToPfam.value (via knownToPfam.value)
      knownGeneV39.pfamDesc.pfamAC (via knownToPfam.value)

Sample Rows
 
namevalue
uc009vjh.1PF00001
uc001aal.1PF00001
uc001aaw.1PF00001
uc001abd.1PF00001
uc001abw.1PF07647
uc001abw.1PF00536
uc001abx.1PF07647
uc001abx.1PF00536
uc009vjp.1PF03715
uc001aby.2PF03715

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