Schema for gene
  Database: uniProt    Primary Table: gene    Row Count: 28,538,862   Data last updated: 2018-04-07
Format description: Gene/accession relationship. Both sides can be multiply valued.
On download server: MariaDB table dump directory
fieldexampleSQL type description
acc Q6GZX4char(12) Primary accession
val FV3-001Rvarchar(255) Single gene name
isPrimary 1tinyint(4) True if primary gene name, false if a synonym

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

Sample Rows
 
accvalisPrimary
Q6GZX4FV3-001R1
Q6GZX3FV3-002L1
Q197F8IIV3-002R1
Q197F7IIV3-003L1
Q6GZX2FV3-003R1
Q6GZX1FV3-004R1
Q197F5IIV3-005L1
Q6GZX0FV3-005R1
Q91G88IIV6-006L1
Q6GZW9FV3-006R1

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