Schema for sangerToPfam
  Database: ce2    Primary Table: sangerToPfam    Row Count: 16,101   Data last updated: 2005-05-03
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 Y74C9A.3varchar(255) values primary ID
value PF05891varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        ce2.dmBlastTab.query (via sangerToPfam.name)
      ce2.hgBlastTab.query (via sangerToPfam.name)
      ce2.kimExpDistance.query (via sangerToPfam.name)
      ce2.kimExpDistance.target (via sangerToPfam.name)
      ce2.orfToGene.name (via sangerToPfam.name)
      ce2.sangerBlastTab.query (via sangerToPfam.name)
      ce2.sangerBlastTab.target (via sangerToPfam.name)
      ce2.sangerCanonical.transcript (via sangerToPfam.name)
      ce2.sangerGene.name (via sangerToPfam.name)
      ce2.sangerIsoforms.transcript (via sangerToPfam.name)
      ce2.sangerLinks.orfName (via sangerToPfam.name)
      ce2.sangerPep.name (via sangerToPfam.name)
      ce2.sangerToKim.name (via sangerToPfam.name)
      ce2.sangerToRefSeq.name (via sangerToPfam.name)

Sample Rows
 
namevalue
Y74C9A.3PF05891
Y74C9A.4aPF00320
Y74C9A.4aPF00249
Y74C9A.4bPF00320
Y74C9A.4bPF00249
Y48G1C.4PF00614
Y48G1C.5PF02206
Y48G1C.5PF00102
Y48G1C.2PF00069
Y48G1C.2PF00017

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