Schema for knownToPfam
  Database: mm7    Primary Table: knownToPfam    Row Count: 23,187   Data last updated: 2005-11-17
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_011283varchar(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)
      mm7.affyGnfU74ADistance.query (via knownToPfam.name)
      mm7.affyGnfU74ADistance.target (via knownToPfam.name)
      mm7.affyGnfU74BDistance.query (via knownToPfam.name)
      mm7.affyGnfU74BDistance.target (via knownToPfam.name)
      mm7.affyGnfU74CDistance.query (via knownToPfam.name)
      mm7.affyGnfU74CDistance.target (via knownToPfam.name)
      mm7.dmBlastTab.query (via knownToPfam.name)
      mm7.drBlastTab.query (via knownToPfam.name)
      mm7.dupSpMrna.mrnaID (via knownToPfam.name)
      mm7.foldUtr3.name (via knownToPfam.name)
      mm7.foldUtr5.name (via knownToPfam.name)
      mm7.gnfAtlas2Distance.query (via knownToPfam.name)
      mm7.gnfAtlas2Distance.target (via knownToPfam.name)
      mm7.hgBlastTab.query (via knownToPfam.name)
      mm7.keggPathway.kgID (via knownToPfam.name)
      mm7.kgAlias.kgID (via knownToPfam.name)
      mm7.kgProtAlias.kgID (via knownToPfam.name)
      mm7.kgSpAlias.kgID (via knownToPfam.name)
      mm7.kgXref.kgID (via knownToPfam.name)
      mm7.knownBlastTab.query (via knownToPfam.name)
      mm7.knownBlastTab.target (via knownToPfam.name)
      mm7.knownCanonical.transcript (via knownToPfam.name)
      mm7.knownGene.name (via knownToPfam.name)
      mm7.knownGeneLink.name (via knownToPfam.name)
      mm7.knownGeneMrna.name (via knownToPfam.name)
      mm7.knownGenePep.name (via knownToPfam.name)
      mm7.knownIsoforms.transcript (via knownToPfam.name)
      mm7.knownToAllenBrain.name (via knownToPfam.name)
      mm7.knownToEnsembl.name (via knownToPfam.name)
      mm7.knownToGnfAtlas2.name (via knownToPfam.name)
      mm7.knownToKeggEntrez.name (via knownToPfam.name)
      mm7.knownToLocusLink.name (via knownToPfam.name)
      mm7.knownToRefSeq.name (via knownToPfam.name)
      mm7.knownToVisiGene.name (via knownToPfam.name)
      mm7.rnBlastTab.query (via knownToPfam.name)
      mm7.scBlastTab.query (via knownToPfam.name)
      knownGeneV39.knownToPfam.value (via knownToPfam.value)
      knownGeneV39.pfamDesc.pfamAC (via knownToPfam.value)

Sample Rows
 
namevalue
NM_011283PF03607
AK004781PF00505
NM_011441PF00505
NM_025300PF01305
BC068230PF01305
NM_008866PF02230
AK050549PF02230
NM_011541PF01096
NM_011541PF07500
BC083127PF01096

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