Schema for bdgpNonCodingInfo
  Database: dm1    Primary Table: bdgpNonCodingInfo    Row Count: 2,165   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 1360{}1005varchar(255) values BDGP annotation gene name
flyBaseId FBti0020116varchar(255) values FlyBase FBgn ID
go  longblob   comma-sep list of GO numeric IDs
symbol 1360{}1005varchar(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.bdgpNonCoding.name (via bdgpNonCodingInfo.bdgpName)
      dm1.bdgpExprLink.flyBaseId (via bdgpNonCodingInfo.flyBaseId)
      dm1.bdgpGeneInfo.flyBaseId (via bdgpNonCodingInfo.flyBaseId)
      dm1.bdgpSwissProt.flyBaseId (via bdgpNonCodingInfo.flyBaseId)
      dm1.fbAllele.geneId (via bdgpNonCodingInfo.flyBaseId)
      dm1.fbGene.geneId (via bdgpNonCodingInfo.flyBaseId)
      dm1.fbPhenotype.geneId (via bdgpNonCodingInfo.flyBaseId)
      dm1.fbSynonym.geneId (via bdgpNonCodingInfo.flyBaseId)
      dm1.fbTranscript.geneId (via bdgpNonCodingInfo.flyBaseId)
      dm1.flyBaseSwissProt.flyBaseId (via bdgpNonCodingInfo.flyBaseId)
      dm1.bdgpGeneInfo.go (via bdgpNonCodingInfo.go)
      go.term.acc (via bdgpNonCodingInfo.go)

Sample Rows
 
bdgpNameflyBaseIdgosymbolcytorangecdna_clone
1360{}1005FBti00201161360{}1005
1360{}1032FBti00201431360{}1032
1360{}1044FBti00201551360{}1044
1360{}1082FBti00201931360{}1082
1360{}1083FBti00201941360{}1083
1360{}1096FBti00202071360{}1096
1360{}1113FBti00202241360{}1113
1360{}1114FBti00202251360{}1114
1360{}1118FBti00202291360{}1118
1360{}1119FBti00202301360{}1119

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