Schema for bdgpSwissProt
  Database: dm1    Primary Table: bdgpSwissProt    Row Count: 18,746   Data last updated: 2005-01-08
Format description: Berkeley Drosophile Genome Project Protein-Coding Genes track additional information plus SwissProt acc & desc
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bdgpName CG11023-RAvarchar(255) values BDGP annotation gene name
flyBaseId FBgn0031208varchar(255) values FlyBase FBgn ID
go  longblob   comma-sep list of GO numeric IDs
symbol CG11023varchar(255) values symbolic gene name
cytorange  varchar(255) values cytorange
swissProtId Q86BM6varchar(255) values SwissProt ID
spGeneName CG11023-PAvarchar(255) values (long) gene name from SwissProt
spSymbol Q86BM6varchar(255) values symbolic-looking gene id from SwissProt

Connected Tables and Joining Fields
        dm1.arbExpDistance.query (via bdgpSwissProt.bdgpName)
      dm1.arbExpDistance.target (via bdgpSwissProt.bdgpName)
      dm1.bdgpBlastTab.query (via bdgpSwissProt.bdgpName)
      dm1.bdgpBlastTab.target (via bdgpSwissProt.bdgpName)
      dm1.bdgpCanonical.transcript (via bdgpSwissProt.bdgpName)
      dm1.bdgpGene.name (via bdgpSwissProt.bdgpName)
      dm1.bdgpGenePep.name (via bdgpSwissProt.bdgpName)
      dm1.bdgpIsoforms.transcript (via bdgpSwissProt.bdgpName)
      dm1.bdgpToCanonical.name (via bdgpSwissProt.bdgpName)
      dm1.bdgpToLocusLink.name (via bdgpSwissProt.bdgpName)
      dm1.bdgpToPfam.name (via bdgpSwissProt.bdgpName)
      dm1.bdgpToRefSeq.name (via bdgpSwissProt.bdgpName)
      dm1.blastFBPep00.name (via bdgpSwissProt.bdgpName)
      dm1.drBlastTab.query (via bdgpSwissProt.bdgpName)
      dm1.fbTranscript.transcriptId (via bdgpSwissProt.bdgpName)
      dm1.hgBlastTab.query (via bdgpSwissProt.bdgpName)
      dm1.pscreen.geneIds (via bdgpSwissProt.bdgpName)
      dm1.scBlastTab.query (via bdgpSwissProt.bdgpName)
      dm1.bdgpExprLink.flyBaseId (via bdgpSwissProt.flyBaseId)
      dm1.bdgpGeneInfo.flyBaseId (via bdgpSwissProt.flyBaseId)
      dm1.bdgpNonCodingInfo.flyBaseId (via bdgpSwissProt.flyBaseId)
      dm1.fbAllele.geneId (via bdgpSwissProt.flyBaseId)
      dm1.fbGene.geneId (via bdgpSwissProt.flyBaseId)
      dm1.fbPhenotype.geneId (via bdgpSwissProt.flyBaseId)
      dm1.fbSynonym.geneId (via bdgpSwissProt.flyBaseId)
      dm1.fbTranscript.geneId (via bdgpSwissProt.flyBaseId)
      dm1.flyBaseSwissProt.flyBaseId (via bdgpSwissProt.flyBaseId)
      dm1.flyBaseSwissProt.spSymbol (via bdgpSwissProt.spSymbol)
      go.goaPart.dbObjectSymbol (via bdgpSwissProt.spSymbol)
      knownGeneV39.kgProtAlias.displayID (via bdgpSwissProt.spSymbol)
      knownGeneV39.kgSpAlias.alias (via bdgpSwissProt.spSymbol)
      knownGeneV39.kgXref.spDisplayID (via bdgpSwissProt.spSymbol)
      knownGeneV39.knownCanonical.protein (via bdgpSwissProt.spSymbol)
      proteome.spOldNew.newDisplayId (via bdgpSwissProt.spSymbol)
      proteome.spOldNew.oldDisplayId (via bdgpSwissProt.spSymbol)
      uniProt.displayId.val (via bdgpSwissProt.spSymbol)
      dm1.bdgpCanonical.protein (via bdgpSwissProt.swissProtId)
      dm1.bdgpGene.proteinID (via bdgpSwissProt.swissProtId)
      dm1.flyBaseSwissProt.swissProtId (via bdgpSwissProt.swissProtId)
      go.goaPart.dbObjectId (via bdgpSwissProt.swissProtId)
      knownGeneV39.kgProtAlias.alias (via bdgpSwissProt.swissProtId)
      knownGeneV39.kgSpAlias.spID (via bdgpSwissProt.swissProtId)
      knownGeneV39.kgXref.spID (via bdgpSwissProt.swissProtId)
      proteome.spOldNew.acc (via bdgpSwissProt.swissProtId)
      proteome.spReactomeEvent.spID (via bdgpSwissProt.swissProtId)
      proteome.spReactomeId.spID (via bdgpSwissProt.swissProtId)
      uniProt.accToKeyword.acc (via bdgpSwissProt.swissProtId)
      uniProt.accToTaxon.acc (via bdgpSwissProt.swissProtId)
      uniProt.citation.acc (via bdgpSwissProt.swissProtId)
      uniProt.comment.acc (via bdgpSwissProt.swissProtId)
      uniProt.description.acc (via bdgpSwissProt.swissProtId)
      uniProt.displayId.acc (via bdgpSwissProt.swissProtId)
      uniProt.extDbRef.acc (via bdgpSwissProt.swissProtId)
      uniProt.feature.acc (via bdgpSwissProt.swissProtId)
      uniProt.gene.acc (via bdgpSwissProt.swissProtId)
      uniProt.geneLogic.acc (via bdgpSwissProt.swissProtId)
      uniProt.info.acc (via bdgpSwissProt.swissProtId)
      uniProt.otherAcc.acc (via bdgpSwissProt.swissProtId)
      uniProt.protein.acc (via bdgpSwissProt.swissProtId)
      visiGene.gene.uniProt (via bdgpSwissProt.swissProtId)

Sample Rows
 
bdgpNameflyBaseIdgosymbolcytorangeswissProtIdspGeneNamespSymbol
CG11023-RAFBgn0031208CG11023Q86BM6CG11023-PAQ86BM6
CG2671-RFFBgn0002121l(2)glQ8IPV5CG2671-PBQ8IPV5
CG2671-REFBgn0002121l(2)glQ8IPV5CG2671-PBQ8IPV5
CG2671-RDFBgn0002121l(2)glQ8IPV5CG2671-PBQ8IPV5
CG2671-RCFBgn0002121l(2)glQ8IPV5CG2671-PBQ8IPV5
CG2671-RBFBgn0002121l(2)glQ8IPV5CG2671-PBQ8IPV5
CG2671-RAFBgn0002121l(2)glQ8IPV5CG2671-PBQ8IPV5
CG2657-RAFBgn0031209CG2657Q9VPI2CG2657 proteinQ9VPI2
CG31973-RBFBgn0051973CG31973Q9VPI3CG31973 proteinQ9VPI3
CG31973-RAFBgn0051973CG31973Q9VPI3CG31973 proteinQ9VPI3

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