Schema for flyBaseToPfam
  Database: dm2    Primary Table: flyBaseToPfam    Row Count: 16,933   Data last updated: 2007-04-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 CG10000-RAvarchar(255) values primary ID
value PF00535varchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
CG10000-RAPF00535
CG10000-RAPF00652
CG10001-RAPF00001
CG10002-RAPF00250
CG10002-RAPF08430
CG10005-RAPF00100
CG10006-RAPF02535
CG10009-RAPF06524
CG10011-RAPF00023
CG10014-RAPF00612

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