Schema for sgdToPfam
  Database: sacCer2    Primary Table: sgdToPfam    Row Count: 4,718   Data last updated: 2009-02-24
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 YAL063Cvarchar(255) values primary ID
value PF00624varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        sacCer2.ceBlastTab.query (via sgdToPfam.name)
      sacCer2.choExpDistance.query (via sgdToPfam.name)
      sacCer2.choExpDistance.target (via sgdToPfam.name)
      sacCer2.dmBlastTab.query (via sgdToPfam.name)
      sacCer2.drBlastTab.query (via sgdToPfam.name)
      sacCer2.esRegGeneToModule.gene (via sgdToPfam.name)
      sacCer2.esRegGeneToMotif.gene (via sgdToPfam.name)
      sacCer2.esRegUpstreamRegion.name (via sgdToPfam.name)
      sacCer2.hgBlastTab.query (via sgdToPfam.name)
      sacCer2.mmBlastTab.query (via sgdToPfam.name)
      sacCer2.rnBlastTab.query (via sgdToPfam.name)
      sacCer2.sgdAbundance.name (via sgdToPfam.name)
      sacCer2.sgdBlastTab.query (via sgdToPfam.name)
      sacCer2.sgdBlastTab.target (via sgdToPfam.name)
      sacCer2.sgdCanonical.transcript (via sgdToPfam.name)
      sacCer2.sgdDescription.name (via sgdToPfam.name)
      sacCer2.sgdGene.name (via sgdToPfam.name)
      sacCer2.sgdIsoforms.transcript (via sgdToPfam.name)
      sacCer2.sgdLocalization.name (via sgdToPfam.name)
      sacCer2.sgdPep.name (via sgdToPfam.name)
      sacCer2.sgdToName.name (via sgdToPfam.name)
      sacCer2.sgdToSwissProt.name (via sgdToPfam.name)

Sample Rows
 
namevalue
YAL063CPF00624
YAL062WPF00208
YAL062WPF02812
YAL061WPF00107
YAL060WPF00107
YAL058WPF00262
YAL054CPF00501
YAL051WPF00172
YAL049CPF01738
YAL048CPF00036

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