Schema for flyBaseToPfam
  Database: dm3    Primary Table: flyBaseToPfam    Row Count: 16,584   Data last updated: 2008-10-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 CG00000-RAvarchar(255) values primary ID
value PF00620varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        dm3.arbExpDistance.query (via flyBaseToPfam.name)
      dm3.arbExpDistance.target (via flyBaseToPfam.name)
      dm3.ceBlastTab.query (via flyBaseToPfam.name)
      dm3.drBlastTab.query (via flyBaseToPfam.name)
      dm3.flyBase2004Xref.name (via flyBaseToPfam.name)
      dm3.flyBaseBlastTab.query (via flyBaseToPfam.name)
      dm3.flyBaseBlastTab.target (via flyBaseToPfam.name)
      dm3.flyBaseCanonical.transcript (via flyBaseToPfam.name)
      dm3.flyBaseGene.name (via flyBaseToPfam.name)
      dm3.flyBaseIsoforms.transcript (via flyBaseToPfam.name)
      dm3.flyBaseNoncoding.name (via flyBaseToPfam.name)
      dm3.flyBasePep.name (via flyBaseToPfam.name)
      dm3.flyBaseToCG.name (via flyBaseToPfam.name)
      dm3.flyBaseToDescription.name (via flyBaseToPfam.name)
      dm3.flyBaseToRefSeq.name (via flyBaseToPfam.name)
      dm3.flyBaseToUniProt.name (via flyBaseToPfam.name)
      dm3.flyP2P.query (via flyBaseToPfam.name)
      dm3.flyP2P.target (via flyBaseToPfam.name)
      dm3.hgBlastTab.query (via flyBaseToPfam.name)
      dm3.mmBlastTab.query (via flyBaseToPfam.name)
      dm3.rnBlastTab.query (via flyBaseToPfam.name)
      dm3.scBlastTab.query (via flyBaseToPfam.name)

Sample Rows
 
namevalue
CG00000-RAPF00620
CG00000-RAPF00621
CG00000-RBPF00620
CG00000-RBPF00621
CG10000-RAPF00535
CG10000-RAPF00652
CG10001-RAPF00001
CG10005-RAPF00100
CG10006-RAPF02535
CG10006-RBPF02535

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