Schema for bdgpToPfam
  Database: dm1    Primary Table: bdgpToPfam    Row Count: 15,754   Data last updated: 2005-01-08
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 CG11023-RAvarchar(255) values primary ID
value PF02902varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        dm1.arbExpDistance.query (via bdgpToPfam.name)
      dm1.arbExpDistance.target (via bdgpToPfam.name)
      dm1.bdgpBlastTab.query (via bdgpToPfam.name)
      dm1.bdgpBlastTab.target (via bdgpToPfam.name)
      dm1.bdgpCanonical.transcript (via bdgpToPfam.name)
      dm1.bdgpGene.name (via bdgpToPfam.name)
      dm1.bdgpGenePep.name (via bdgpToPfam.name)
      dm1.bdgpIsoforms.transcript (via bdgpToPfam.name)
      dm1.bdgpSwissProt.bdgpName (via bdgpToPfam.name)
      dm1.bdgpToCanonical.name (via bdgpToPfam.name)
      dm1.bdgpToLocusLink.name (via bdgpToPfam.name)
      dm1.bdgpToRefSeq.name (via bdgpToPfam.name)
      dm1.blastFBPep00.name (via bdgpToPfam.name)
      dm1.drBlastTab.query (via bdgpToPfam.name)
      dm1.fbTranscript.transcriptId (via bdgpToPfam.name)
      dm1.hgBlastTab.query (via bdgpToPfam.name)
      dm1.pscreen.geneIds (via bdgpToPfam.name)
      dm1.scBlastTab.query (via bdgpToPfam.name)
      knownGeneV39.knownToPfam.value (via bdgpToPfam.value)

Sample Rows
 
namevalue
CG11023-RAPF02902
CG31973-RBPF01607
CG31973-RBPF01522
CG31973-RAPF01607
CG31973-RAPF01522
CG11372-RAPF00337
CG11374-RAPF00337
CG11450-RAPF00010
CG11376-RAPF06920
CG12178-RAPF00999

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