Schema for flyBaseToUniProt
  Database: dm3    Primary Table: flyBaseToUniProt    Row Count: 23,413   Data last updated: 2008-10-24
Format description: Generic 2-column name-alias association.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name CG00000-RAvarchar(255) values Item name (shared with a track table).
alias Q29QE1varchar(255) values Another commonly used name for this item.

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

Sample Rows
 
namealias
CG00000-RAQ29QE1
CG00000-RBQ29QE1
CG10000-RAQ8MYY6
CG10001-RAQ9NBC8
CG10002-RAn/a
CG10002-RBn/a
CG10005-RAQ8MYX4
CG10006-RAQ9VUI9
CG10006-RBA4IJ72
CG10007-RAQ9VGF5

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