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

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

Sample Rows
 
namealias
CG10000-RAQ8MYY6
CG10001-RAQ9NBC8
CG10002-RAP14734
CG10002-RAQ3YNB8
CG10002-RAQ7YU22
CG10005-RAQ8MYX4
CG10006-RAQ9VUI9
CG10007-RAQ9VGF5
CG10009-RAQ9VAU9
CG10011-RAQ9VAU5

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