Schema for flyBaseToCG
  Database: dm3    Primary Table: flyBaseToCG    Row Count: 21,243   Data last updated: 2008-10-21
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 CG00000varchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
CG00000-RACG00000
CG00000-RBCG00000
CG10000-RACG10000
CG10001-RACG10001
CG10002-RACG10002
CG10002-RBCG10002
CG10005-RACG10005
CG10006-RACG10006
CG10006-RBCG10006
CG10007-RACG10007

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