Schema for feature
  Database: uniProt    Primary Table: feature    Row Count: 19,889,871   Data last updated: 2018-04-06
Format description: A description of part of a protein
On download server: MariaDB table dump directory
fieldexampleSQL type description
acc Q6GZX4char(12) Primary accession
start 0int(11) Start coordinate (zero based)
end 256int(11) End coordinate (non-inclusive)
featureClass 1int(11) ID of featureClass
featureType 1int(11) ID of featureType
softEndBits 0tinyint(4) 1 for start <, 2 for start ?, 4 for end >, 8 for end ?
featureId 1int(11)  

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

Sample Rows
 
accstartendfeatureClassfeatureTypesoftEndBitsfeatureId
Q6GZX402561101
Q6GZX413172200
Q6GZX303201302
Q6GZX33003183400
Q6GZX32622952500
Q197F804581603
Q197F701561704
Q6GZX20324800
Q6GZX2324381905
Q6GZX106011006

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