Schema for flyBaseSwissProt
  Database: dm1    Primary Table: flyBaseSwissProt    Row Count: 15,257   Data last updated: 2004-06-17
Format description: FlyBase acc to SwissProt acc, plus some other SwissProt info
On download server: MariaDB table dump directory
fieldexampleSQL type info description
flyBaseId FBgn0010339varchar(255) values FlyBase FBgn ID
swissProtId P32234varchar(255) values SwissProt ID
spGeneName GTP-binding protein 128UPvarchar(255) values (long) gene name from SwissProt
spSymbol 128U_DROMEvarchar(255) values symbolic-looking gene id from SwissProt

Connected Tables and Joining Fields
        dm1.bdgpExprLink.flyBaseId (via flyBaseSwissProt.flyBaseId)
      dm1.bdgpGeneInfo.flyBaseId (via flyBaseSwissProt.flyBaseId)
      dm1.bdgpNonCodingInfo.flyBaseId (via flyBaseSwissProt.flyBaseId)
      dm1.bdgpSwissProt.flyBaseId (via flyBaseSwissProt.flyBaseId)
      dm1.fbAllele.geneId (via flyBaseSwissProt.flyBaseId)
      dm1.fbGene.geneId (via flyBaseSwissProt.flyBaseId)
      dm1.fbPhenotype.geneId (via flyBaseSwissProt.flyBaseId)
      dm1.fbSynonym.geneId (via flyBaseSwissProt.flyBaseId)
      dm1.fbTranscript.geneId (via flyBaseSwissProt.flyBaseId)
      dm1.bdgpSwissProt.spSymbol (via flyBaseSwissProt.spSymbol)
      go.goaPart.dbObjectSymbol (via flyBaseSwissProt.spSymbol)
      knownGeneV39.kgProtAlias.displayID (via flyBaseSwissProt.spSymbol)
      knownGeneV39.kgSpAlias.alias (via flyBaseSwissProt.spSymbol)
      knownGeneV39.kgXref.spDisplayID (via flyBaseSwissProt.spSymbol)
      knownGeneV39.knownCanonical.protein (via flyBaseSwissProt.spSymbol)
      proteome.spOldNew.newDisplayId (via flyBaseSwissProt.spSymbol)
      proteome.spOldNew.oldDisplayId (via flyBaseSwissProt.spSymbol)
      uniProt.displayId.val (via flyBaseSwissProt.spSymbol)
      dm1.bdgpCanonical.protein (via flyBaseSwissProt.swissProtId)
      dm1.bdgpGene.proteinID (via flyBaseSwissProt.swissProtId)
      dm1.bdgpSwissProt.swissProtId (via flyBaseSwissProt.swissProtId)
      go.goaPart.dbObjectId (via flyBaseSwissProt.swissProtId)
      knownGeneV39.kgProtAlias.alias (via flyBaseSwissProt.swissProtId)
      knownGeneV39.kgSpAlias.spID (via flyBaseSwissProt.swissProtId)
      knownGeneV39.kgXref.spID (via flyBaseSwissProt.swissProtId)
      proteome.spOldNew.acc (via flyBaseSwissProt.swissProtId)
      proteome.spReactomeEvent.spID (via flyBaseSwissProt.swissProtId)
      proteome.spReactomeId.spID (via flyBaseSwissProt.swissProtId)
      uniProt.accToKeyword.acc (via flyBaseSwissProt.swissProtId)
      uniProt.accToTaxon.acc (via flyBaseSwissProt.swissProtId)
      uniProt.citation.acc (via flyBaseSwissProt.swissProtId)
      uniProt.comment.acc (via flyBaseSwissProt.swissProtId)
      uniProt.description.acc (via flyBaseSwissProt.swissProtId)
      uniProt.displayId.acc (via flyBaseSwissProt.swissProtId)
      uniProt.extDbRef.acc (via flyBaseSwissProt.swissProtId)
      uniProt.feature.acc (via flyBaseSwissProt.swissProtId)
      uniProt.gene.acc (via flyBaseSwissProt.swissProtId)
      uniProt.geneLogic.acc (via flyBaseSwissProt.swissProtId)
      uniProt.info.acc (via flyBaseSwissProt.swissProtId)
      uniProt.otherAcc.acc (via flyBaseSwissProt.swissProtId)
      uniProt.protein.acc (via flyBaseSwissProt.swissProtId)
      visiGene.gene.uniProt (via flyBaseSwissProt.swissProtId)

Sample Rows
 
flyBaseIdswissProtIdspGeneNamespSymbol
FBgn0010339P32234GTP-binding protein 128UP128U_DROME
FBgn0010340P81928RPII140-upstream protein140U_DROME
FBgn0020238P9217714-3-3 protein epsilon (Suppressor of Ras1 3-9)143E_DROME
FBgn0004907P2931014-3-3-like protein (Leonardo protein) (14-3-3 zeta)143Z_DROME
FBgn0000093P16909Histone-like protein 18C18C_DROME
FBgn0005776P36179Protein phosphatase PP2A, 65 kDa regulatory subunit (Protein phosphatase PP2A regulatory subunit A) (PR65)2AAA_DROME
FBgn0004889P36872Protein phosphatase PP2A, 55 kDa regulatory subunit (Protein phosphatase PP2A regulatory subunit B) (PR55) (Twins protein)2ABA_DROME
FBgn0033988Q9V785SH3 domain-binding protein 5-like (Parcase protein)3BP5_DROME
FBgn0000644P11450Follicle cell protein 3C-13C1_DROME
FBgn0010434Q9V8R9Protein 4.1 homolog (Coracle protein)41_DROME

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