Schema for geneLogic
  Database: uniProt    Primary Table: geneLogic    Row Count: 23,299,631   Data last updated: 2018-04-07
Format description: Gene including and/or logic if multiple
On download server: MariaDB table dump directory
fieldexampleSQL type description
acc Q6GZX4char(12) Primary accession
val ORFNames=FV3-001R;longtext Gene(s) and logic to relate them.

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

Sample Rows
 
accval
Q6GZX4ORFNames=FV3-001R;
Q6GZX3ORFNames=FV3-002L;
Q197F8ORFNames=IIV3-002R;
Q197F7ORFNames=IIV3-003L;
Q6GZX2ORFNames=FV3-003R;
Q6GZX1ORFNames=FV3-004R;
Q197F5ORFNames=IIV3-005L;
Q6GZX0ORFNames=FV3-005R;
Q91G88ORFNames=IIV6-006L;
Q6GZW9ORFNames=FV3-006R;

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