Schema for knownToPfam
  Database: mm9    Primary Table: knownToPfam    Row Count: 51,198   Data last updated: 2011-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 uc007aew.1varchar(255) values primary ID
value PF03607varchar(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)
      mm9.affyGnfU74ADistance.query (via knownToPfam.name)
      mm9.affyGnfU74ADistance.target (via knownToPfam.name)
      mm9.affyGnfU74BDistance.query (via knownToPfam.name)
      mm9.affyGnfU74BDistance.target (via knownToPfam.name)
      mm9.affyGnfU74CDistance.query (via knownToPfam.name)
      mm9.affyGnfU74CDistance.target (via knownToPfam.name)
      mm9.bioCycPathway.kgID (via knownToPfam.name)
      mm9.ccdsKgMap.geneId (via knownToPfam.name)
      mm9.ceBlastTab.query (via knownToPfam.name)
      mm9.dmBlastTab.query (via knownToPfam.name)
      mm9.drBlastTab.query (via knownToPfam.name)
      mm9.foldUtr3.name (via knownToPfam.name)
      mm9.foldUtr5.name (via knownToPfam.name)
      mm9.gnfAtlas2Distance.query (via knownToPfam.name)
      mm9.gnfAtlas2Distance.target (via knownToPfam.name)
      mm9.hgBlastTab.query (via knownToPfam.name)
      mm9.keggPathway.kgID (via knownToPfam.name)
      mm9.kgAlias.kgID (via knownToPfam.name)
      mm9.kgColor.kgID (via knownToPfam.name)
      mm9.kgProtAlias.kgID (via knownToPfam.name)
      mm9.kgProtMap2.qName (via knownToPfam.name)
      mm9.kgSpAlias.kgID (via knownToPfam.name)
      mm9.kgTargetAli.qName (via knownToPfam.name)
      mm9.kgTxInfo.name (via knownToPfam.name)
      mm9.kgXref.kgID (via knownToPfam.name)
      mm9.knownBlastTab.query (via knownToPfam.name)
      mm9.knownBlastTab.target (via knownToPfam.name)
      mm9.knownCanonical.protein (via knownToPfam.name)
      mm9.knownCanonical.transcript (via knownToPfam.name)
      mm9.knownGene.name (via knownToPfam.name)
      mm9.knownGeneMrna.name (via knownToPfam.name)
      mm9.knownGenePep.name (via knownToPfam.name)
      mm9.knownIsoforms.transcript (via knownToPfam.name)
      mm9.knownToAllenBrain.name (via knownToPfam.name)
      mm9.knownToEnsembl.name (via knownToPfam.name)
      mm9.knownToGnfAtlas2.name (via knownToPfam.name)
      mm9.knownToKeggEntrez.name (via knownToPfam.name)
      mm9.knownToLocusLink.name (via knownToPfam.name)
      mm9.knownToRefSeq.name (via knownToPfam.name)
      mm9.knownToSuper.gene (via knownToPfam.name)
      mm9.knownToVisiGene.name (via knownToPfam.name)
      mm9.rnBlastTab.query (via knownToPfam.name)
      mm9.scBlastTab.query (via knownToPfam.name)
      mm9.ucscScop.ucscId (via knownToPfam.name)
      knownGeneV39.knownToPfam.value (via knownToPfam.value)
      knownGeneV39.pfamDesc.pfamAC (via knownToPfam.value)
      mm9.pfamDesc.pfamAC (via knownToPfam.value)

Sample Rows
 
namevalue
uc007aew.1PF03607
uc007aex.2PF03607
uc007aey.1PF00505
uc007aez.1PF00505
uc007afa.1PF00505
uc007afc.1PF00505
uc007afd.2PF01305
uc007aff.2PF01305
uc007afg.1PF02230
uc007afh.1PF02230

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