Schema for bdgpGeneInfo
  Database: dm1    Primary Table: bdgpGeneInfo    Row Count: 13,472   Data last updated: 2004-06-18
Format description: Berkeley Drosophila Genome Project Protein-Coding Genes track additional information
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bdgpName CG10000varchar(255) values BDGP annotation gene name
flyBaseId FBgn0039596varchar(255) values FlyBase FBgn ID
go  longblob   comma-sep list of GO numeric IDs
symbol CG10000varchar(255) values symbolic gene name
cytorange  varchar(255) values cytorange
cdna_clone  varchar(255) values comma-sep list of cdna clone IDs

Connected Tables and Joining Fields
        dm1.bdgpExprLink.bdgpName (via bdgpGeneInfo.bdgpName)
      dm1.bdgpToCanonical.value (via bdgpGeneInfo.bdgpName)
      dm1.bdgpExprLink.flyBaseId (via bdgpGeneInfo.flyBaseId)
      dm1.bdgpNonCodingInfo.flyBaseId (via bdgpGeneInfo.flyBaseId)
      dm1.bdgpSwissProt.flyBaseId (via bdgpGeneInfo.flyBaseId)
      dm1.fbAllele.geneId (via bdgpGeneInfo.flyBaseId)
      dm1.fbGene.geneId (via bdgpGeneInfo.flyBaseId)
      dm1.fbPhenotype.geneId (via bdgpGeneInfo.flyBaseId)
      dm1.fbSynonym.geneId (via bdgpGeneInfo.flyBaseId)
      dm1.fbTranscript.geneId (via bdgpGeneInfo.flyBaseId)
      dm1.flyBaseSwissProt.flyBaseId (via bdgpGeneInfo.flyBaseId)
      dm1.bdgpNonCodingInfo.go (via bdgpGeneInfo.go)
      go.term.acc (via bdgpGeneInfo.go)

Sample Rows
 
bdgpNameflyBaseIdgosymbolcytorangecdna_clone
CG10000FBgn0039596CG10000
CG10001FBgn0039595AR-2
CG10002FBgn0000659fkh
CG10005FBgn0037972CG10005
CG10006FBgn0036461CG10006
CG10007FBgn0037971CG10007
CG10009FBgn0026400Noa36
CG10011FBgn0039590CG10011
CG10013FBgn0038012CG10013
CG10014FBgn0038000CG10014

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