Schema for fbGene
  Database: dm3    Primary Table: fbGene    Row Count: 57,068   Data last updated: 2006-10-11
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
        dm3.bdgpExprLink.flyBaseId (via fbGene.geneId)
      dm3.fbAllele.geneId (via fbGene.geneId)
      dm3.fbPhenotype.geneId (via fbGene.geneId)
      dm3.fbSynonym.geneId (via fbGene.geneId)
      dm3.fbTranscript.geneId (via fbGene.geneId)
      dm3.flyBase2004Xref.fbgn (via fbGene.geneId)
      dm3.pscreen.geneIds (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.