Schema for fbGene
  Database: dm2    Primary Table: fbGene    Row Count: 57,068   Data last updated: 2006-01-27
Format description: Links FlyBase IDs, gene symbols and gene names
On download server: MariaDB table dump directory
fieldexampleSQL type info description
geneId FBgn0025724varchar(255) values FlyBase ID
geneSym betaCopvarchar(255) values Short gene symbol
geneName beta-coatomer proteinvarchar(255) values Gene name - up to a couple of words

Connected Tables and Joining Fields
        dm2.bdgpExprLink.flyBaseId (via fbGene.geneId)
      dm2.fbAllele.geneId (via fbGene.geneId)
      dm2.fbPhenotype.geneId (via fbGene.geneId)
      dm2.fbSynonym.geneId (via fbGene.geneId)
      dm2.fbTranscript.geneId (via fbGene.geneId)
      dm2.flyBase2004Xref.fbgn (via fbGene.geneId)

Sample Rows
 
geneIdgeneSymgeneName
FBgn0025724betaCopbeta-coatomer protein
FBgn0070058&lgr;attPattP recombination target site
FBgn0043467064Ya064Ya
FBgn00103471.281.28
FBgn002661510-410-4
FBgn0067637106y106y
FBgn0011557107.1107.1
FBgn00700571111
FBgn0010339128upupstream of RpIII128
FBgn000567313601360 element

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