Schema for fbSynonym
  Database: dm1    Primary Table: fbSynonym    Row Count: 276,161   Data last updated: 2004-06-28
Format description: Links all the names we call a gene to it's flybase ID
On download server: MariaDB table dump directory
fieldexampleSQL type info description
geneId FBgn0025724varchar(255) values FlyBase ID
name beta-coatomer proteinvarchar(255) values A name (synonym or real)

Connected Tables and Joining Fields
        dm1.bdgpExprLink.flyBaseId (via fbSynonym.geneId)
      dm1.bdgpGeneInfo.flyBaseId (via fbSynonym.geneId)
      dm1.bdgpNonCodingInfo.flyBaseId (via fbSynonym.geneId)
      dm1.bdgpSwissProt.flyBaseId (via fbSynonym.geneId)
      dm1.fbAllele.geneId (via fbSynonym.geneId)
      dm1.fbGene.geneId (via fbSynonym.geneId)
      dm1.fbPhenotype.geneId (via fbSynonym.geneId)
      dm1.fbTranscript.geneId (via fbSynonym.geneId)
      dm1.flyBaseSwissProt.flyBaseId (via fbSynonym.geneId)

Sample Rows
 
geneIdname
FBgn0025724beta-coatomer protein
FBgn0025724betaCop
FBgn0025724betaCop+
FBgn0025724beta'Cop
FBgn0025724dbetaCOP
FBgn0025724beta'-COP
FBgn0025724CG6699
FBgn0043467064Ya
FBgn0043467064Ya+
FBgn0043467064Y

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