Schema for fbGene
  Database: dm1    Primary Table: fbGene    Row Count: 44,661   Data last updated: 2004-06-28
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
        dm1.bdgpExprLink.flyBaseId (via fbGene.geneId)
      dm1.bdgpGeneInfo.flyBaseId (via fbGene.geneId)
      dm1.bdgpNonCodingInfo.flyBaseId (via fbGene.geneId)
      dm1.bdgpSwissProt.flyBaseId (via fbGene.geneId)
      dm1.fbAllele.geneId (via fbGene.geneId)
      dm1.fbPhenotype.geneId (via fbGene.geneId)
      dm1.fbSynonym.geneId (via fbGene.geneId)
      dm1.fbTranscript.geneId (via fbGene.geneId)
      dm1.flyBaseSwissProt.flyBaseId (via fbGene.geneId)

Sample Rows
 
geneIdgeneSymgeneName
FBgn0025724betaCopbeta-coatomer protein
FBgn0043467064Yan/a
FBgn00103471.28n/a
FBgn002661510-4n/a
FBgn0067637106yn/a
FBgn0011557107.1n/a
FBgn0010339128upupstream of RpIII128
FBgn000567313601360 element
FBgn00663201360Tn/a
FBgn002023814-3-3epsilonn/a

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