Schema for knownToPfam
  Database: hg16    Primary Table: knownToPfam    Row Count: 30,467   Data last updated: 2004-04-15
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 AK093438varchar(255) values primary ID
value PF03133varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg16.bioCycPathway.kgID (via knownToPfam.name)
      hg16.dmBlastTab.query (via knownToPfam.name)
      hg16.drBlastTab.query (via knownToPfam.name)
      hg16.dupSpMrna.mrnaID (via knownToPfam.name)
      hg16.foldUtr3.name (via knownToPfam.name)
      hg16.foldUtr5.name (via knownToPfam.name)
      hg16.gnfAtlas2Distance.query (via knownToPfam.name)
      hg16.gnfAtlas2Distance.target (via knownToPfam.name)
      hg16.gnfU95Distance.query (via knownToPfam.name)
      hg16.gnfU95Distance.target (via knownToPfam.name)
      hg16.hg17Kg.name (via knownToPfam.name)
      hg16.keggPathway.kgID (via knownToPfam.name)
      hg16.kgAlias.kgID (via knownToPfam.name)
      hg16.kgProtAlias.kgID (via knownToPfam.name)
      hg16.kgXref.kgID (via knownToPfam.name)
      hg16.knownBlastTab.query (via knownToPfam.name)
      hg16.knownBlastTab.target (via knownToPfam.name)
      hg16.knownCanonical.transcript (via knownToPfam.name)
      hg16.knownGene.name (via knownToPfam.name)
      hg16.knownGeneLink.name (via knownToPfam.name)
      hg16.knownGeneMrna.name (via knownToPfam.name)
      hg16.knownGenePep.name (via knownToPfam.name)
      hg16.knownIsoforms.transcript (via knownToPfam.name)
      hg16.knownToEnsembl.name (via knownToPfam.name)
      hg16.knownToGnfAtlas2.name (via knownToPfam.name)
      hg16.knownToHInv.name (via knownToPfam.name)
      hg16.knownToLocusLink.name (via knownToPfam.name)
      hg16.knownToRefSeq.name (via knownToPfam.name)
      hg16.knownToSuper.gene (via knownToPfam.name)
      hg16.knownToU133.name (via knownToPfam.name)
      hg16.knownToU95.name (via knownToPfam.name)
      hg16.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
AK093438PF03133
NM_003327PF00020
X75962PF00020
AK027277PF00036
AF153686PF00036
AF178986PF00036
AY050570PF01762
AK056065PF00179
AK075017PF00179
AK093239PF00858

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