Schema for knownToPfam
  Database: rn3    Primary Table: knownToPfam    Row Count: 8,814   Data last updated: 2004-06-16
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 X61294varchar(255) values primary ID
value PF00078varchar(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)
      rn3.dmBlastTab.query (via knownToPfam.name)
      rn3.drBlastTab.query (via knownToPfam.name)
      rn3.dupSpMrna.mrnaID (via knownToPfam.name)
      rn3.gnfAtlas2Distance.query (via knownToPfam.name)
      rn3.gnfAtlas2Distance.target (via knownToPfam.name)
      rn3.hgBlastTab.query (via knownToPfam.name)
      rn3.keggPathway.kgID (via knownToPfam.name)
      rn3.kgAlias.kgID (via knownToPfam.name)
      rn3.kgProtAlias.kgID (via knownToPfam.name)
      rn3.kgSpAlias.kgID (via knownToPfam.name)
      rn3.kgXref.kgID (via knownToPfam.name)
      rn3.knownBlastTab.query (via knownToPfam.name)
      rn3.knownBlastTab.target (via knownToPfam.name)
      rn3.knownCanonical.transcript (via knownToPfam.name)
      rn3.knownGene.name (via knownToPfam.name)
      rn3.knownGeneLink.name (via knownToPfam.name)
      rn3.knownGeneMrna.name (via knownToPfam.name)
      rn3.knownGenePep.name (via knownToPfam.name)
      rn3.knownIsoforms.transcript (via knownToPfam.name)
      rn3.knownToEnsembl.name (via knownToPfam.name)
      rn3.knownToGnfAtlas2.name (via knownToPfam.name)
      rn3.knownToLocusLink.name (via knownToPfam.name)
      rn3.knownToRefSeq.name (via knownToPfam.name)
      rn3.knownToSuper.gene (via knownToPfam.name)
      rn3.scBlastTab.query (via knownToPfam.name)
      knownGeneV39.knownToPfam.value (via knownToPfam.value)
      knownGeneV39.pfamDesc.pfamAC (via knownToPfam.value)

Sample Rows
 
namevalue
X61294PF00078
X61295PF00078
M26686PF01135
U92072PF00400
AF118889PF00400
AF118890PF00400
M61099PF00003
M61099PF01094
AF347030PF00782
AJ002967PF00307

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