Schema for goaPart
  Database: go    Primary Table: goaPart    Row Count: 378,374,005   Data last updated: 2018-04-27
On download server: MariaDB table dump directory
fieldexampleSQL type
dbObjectId A0A000varchar(255)
dbObjectSymbol moeA5varchar(255)
notId  varchar(255)
goId GO:0003824varchar(255)
aspect Fvarchar(255)

Connected Tables and Joining Fields
        ce2.sangerCanonical.protein (via goaPart.dbObjectId)
      ce2.sangerGene.proteinID (via goaPart.dbObjectId)
      ce2.sangerLinks.protName (via goaPart.dbObjectId)
      ce4.sangerCanonical.protein (via goaPart.dbObjectId)
      ce4.sangerGene.proteinID (via goaPart.dbObjectId)
      ce4.sangerLinks.protName (via goaPart.dbObjectId)
      ce6.sangerCanonical.protein (via goaPart.dbObjectId)
      ce6.sangerGene.proteinID (via goaPart.dbObjectId)
      ce6.sangerLinks.protName (via goaPart.dbObjectId)
      dm1.bdgpCanonical.protein (via goaPart.dbObjectId)
      dm1.bdgpGene.proteinID (via goaPart.dbObjectId)
      dm1.bdgpSwissProt.swissProtId (via goaPart.dbObjectId)
      dm1.flyBaseSwissProt.swissProtId (via goaPart.dbObjectId)
      hg16.kgProtAlias.alias (via goaPart.dbObjectId)
      hg16.kgProtMap.qName (via goaPart.dbObjectId)
      hg16.kgXref.spID (via goaPart.dbObjectId)
      hg17.kgProtAlias.alias (via goaPart.dbObjectId)
      hg17.kgProtMap.qName (via goaPart.dbObjectId)
      hg17.kgSpAlias.spID (via goaPart.dbObjectId)
      hg17.kgXref.spID (via goaPart.dbObjectId)
      hg18.kgSpAlias.spID (via goaPart.dbObjectId)
      hg18.kgXref.spID (via goaPart.dbObjectId)
      hg19.kgSpAlias.spID (via goaPart.dbObjectId)
      hg19.kgXref.spID (via goaPart.dbObjectId)
      hg38.kgSpAlias.spID (via goaPart.dbObjectId)
      hg38.kgXref.spID (via goaPart.dbObjectId)
      knownGeneV39.kgProtAlias.alias (via goaPart.dbObjectId)
      knownGeneV39.kgSpAlias.spID (via goaPart.dbObjectId)
      knownGeneV39.kgXref.spID (via goaPart.dbObjectId)
      mm10.kgSpAlias.spID (via goaPart.dbObjectId)
      mm10.kgXref.spID (via goaPart.dbObjectId)
      mm7.kgProtAlias.alias (via goaPart.dbObjectId)
      mm7.kgProtMap.qName (via goaPart.dbObjectId)
      mm7.kgSpAlias.spID (via goaPart.dbObjectId)
      mm7.kgXref.spID (via goaPart.dbObjectId)
      mm8.kgProtAlias.alias (via goaPart.dbObjectId)
      mm8.kgProtMap.qName (via goaPart.dbObjectId)
      mm8.kgSpAlias.spID (via goaPart.dbObjectId)
      mm8.kgXref.spID (via goaPart.dbObjectId)
      mm9.kgSpAlias.spID (via goaPart.dbObjectId)
      mm9.kgXref.spID (via goaPart.dbObjectId)
      proteome.spOldNew.acc (via goaPart.dbObjectId)
      proteome.spReactomeEvent.spID (via goaPart.dbObjectId)
      proteome.spReactomeId.spID (via goaPart.dbObjectId)
      rn3.kgProtAlias.alias (via goaPart.dbObjectId)
      rn3.kgProtMap.qName (via goaPart.dbObjectId)
      rn3.kgSpAlias.spID (via goaPart.dbObjectId)
      rn3.kgXref.spID (via goaPart.dbObjectId)
      rn4.rgdGene2ToUniProt.value (via goaPart.dbObjectId)
      sacCer1.sgdCanonical.protein (via goaPart.dbObjectId)
      sacCer1.sgdGene.proteinID (via goaPart.dbObjectId)
      sacCer1.sgdToSwissProt.value (via goaPart.dbObjectId)
      sacCer2.sgdCanonical.protein (via goaPart.dbObjectId)
      sacCer2.sgdGene.proteinID (via goaPart.dbObjectId)
      sacCer2.sgdToSwissProt.value (via goaPart.dbObjectId)
      sacCer3.sgdCanonical.protein (via goaPart.dbObjectId)
      sacCer3.sgdGene.proteinID (via goaPart.dbObjectId)
      sacCer3.sgdToSwissProt.value (via goaPart.dbObjectId)
      uniProt.accToKeyword.acc (via goaPart.dbObjectId)
      uniProt.accToTaxon.acc (via goaPart.dbObjectId)
      uniProt.citation.acc (via goaPart.dbObjectId)
      uniProt.comment.acc (via goaPart.dbObjectId)
      uniProt.description.acc (via goaPart.dbObjectId)
      uniProt.displayId.acc (via goaPart.dbObjectId)
      uniProt.extDbRef.acc (via goaPart.dbObjectId)
      uniProt.feature.acc (via goaPart.dbObjectId)
      uniProt.gene.acc (via goaPart.dbObjectId)
      uniProt.geneLogic.acc (via goaPart.dbObjectId)
      uniProt.info.acc (via goaPart.dbObjectId)
      uniProt.otherAcc.acc (via goaPart.dbObjectId)
      uniProt.protein.acc (via goaPart.dbObjectId)
      visiGene.gene.uniProt (via goaPart.dbObjectId)
      dm1.bdgpSwissProt.spSymbol (via goaPart.dbObjectSymbol)
      dm1.flyBaseSwissProt.spSymbol (via goaPart.dbObjectSymbol)
      hg16.dupSpMrna.dupProteinID (via goaPart.dbObjectSymbol)
      hg16.dupSpMrna.proteinID (via goaPart.dbObjectSymbol)
      hg16.kgProtAlias.displayID (via goaPart.dbObjectSymbol)
      hg16.kgXref.spDisplayID (via goaPart.dbObjectSymbol)
      hg16.knownCanonical.protein (via goaPart.dbObjectSymbol)
      hg16.spMrna.spID (via goaPart.dbObjectSymbol)
      hg17.dupSpMrna.dupProteinID (via goaPart.dbObjectSymbol)
      hg17.dupSpMrna.proteinID (via goaPart.dbObjectSymbol)
      hg17.kgProtAlias.displayID (via goaPart.dbObjectSymbol)
      hg17.kgSpAlias.alias (via goaPart.dbObjectSymbol)
      hg17.kgXref.spDisplayID (via goaPart.dbObjectSymbol)
      hg17.knownCanonical.protein (via goaPart.dbObjectSymbol)
      hg17.spMrna.spID (via goaPart.dbObjectSymbol)
      hg18.kgXref.spDisplayID (via goaPart.dbObjectSymbol)
      hg18.spMrna.spID (via goaPart.dbObjectSymbol)
      hg19.kgXref.spDisplayID (via goaPart.dbObjectSymbol)
      hg19.spMrna.spID (via goaPart.dbObjectSymbol)
      hg38.kgXref.spDisplayID (via goaPart.dbObjectSymbol)
      hg38.spMrna.spID (via goaPart.dbObjectSymbol)
      knownGeneV39.kgProtAlias.displayID (via goaPart.dbObjectSymbol)
      knownGeneV39.kgSpAlias.alias (via goaPart.dbObjectSymbol)
      knownGeneV39.kgXref.spDisplayID (via goaPart.dbObjectSymbol)
      knownGeneV39.knownCanonical.protein (via goaPart.dbObjectSymbol)
      mm10.kgXref.spDisplayID (via goaPart.dbObjectSymbol)
      mm10.spMrna.spID (via goaPart.dbObjectSymbol)
      mm39.spMrna.spID (via goaPart.dbObjectSymbol)
      mm7.dupSpMrna.dupProteinID (via goaPart.dbObjectSymbol)
      mm7.dupSpMrna.proteinID (via goaPart.dbObjectSymbol)
      mm7.kgProtAlias.displayID (via goaPart.dbObjectSymbol)
      mm7.kgSpAlias.alias (via goaPart.dbObjectSymbol)
      mm7.kgXref.spDisplayID (via goaPart.dbObjectSymbol)
      mm7.knownCanonical.protein (via goaPart.dbObjectSymbol)
      mm7.spMrna.spID (via goaPart.dbObjectSymbol)
      mm8.dupSpMrna.dupProteinID (via goaPart.dbObjectSymbol)
      mm8.dupSpMrna.proteinID (via goaPart.dbObjectSymbol)
      mm8.kgProtAlias.displayID (via goaPart.dbObjectSymbol)
      mm8.kgSpAlias.alias (via goaPart.dbObjectSymbol)
      mm8.kgXref.spDisplayID (via goaPart.dbObjectSymbol)
      mm8.knownCanonical.protein (via goaPart.dbObjectSymbol)
      mm8.spMrna.spID (via goaPart.dbObjectSymbol)
      mm9.kgXref.spDisplayID (via goaPart.dbObjectSymbol)
      mm9.spMrna.spID (via goaPart.dbObjectSymbol)
      proteome.spOldNew.newDisplayId (via goaPart.dbObjectSymbol)
      proteome.spOldNew.oldDisplayId (via goaPart.dbObjectSymbol)
      rn3.dupSpMrna.dupProteinID (via goaPart.dbObjectSymbol)
      rn3.dupSpMrna.proteinID (via goaPart.dbObjectSymbol)
      rn3.kgProtAlias.displayID (via goaPart.dbObjectSymbol)
      rn3.kgSpAlias.alias (via goaPart.dbObjectSymbol)
      rn3.kgXref.spDisplayID (via goaPart.dbObjectSymbol)
      rn3.knownCanonical.protein (via goaPart.dbObjectSymbol)
      rn3.spMrna.spID (via goaPart.dbObjectSymbol)
      rn4.spMrna.spID (via goaPart.dbObjectSymbol)
      uniProt.displayId.val (via goaPart.dbObjectSymbol)
      go.term.acc (via goaPart.goId)

Sample Rows
 
dbObjectIddbObjectSymbolnotIdgoIdaspect
A0A000moeA5GO:0003824F
A0A000moeA5GO:0003870F
A0A000moeA5GO:0009058P
A0A000moeA5GO:0030170F
A0A000moeA5GO:0033014P
A0A001moeD5GO:0000166F
A0A001moeD5GO:0005524F
A0A001moeD5GO:0016020C
A0A001moeD5GO:0016021C
A0A001moeD5GO:0016887F

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