sparql-examples

A set of SPARQL examples that are used in different SIB resources

View the Project on GitHub sib-swiss/sparql-examples

neXtProt/NXQ_09447

Check there are no entries with a keyword in the category "Cellular component" that does not apply to human proteins

Use at

PREFIX : <http://nextprot.org/rdf/>
PREFIX cv: <http://nextprot.org/rdf/terminology/>

select distinct ?entry where {  # Include ?kw if result is not 0 to identify problem keyword
  values ?kw {
  cv:KW-0042 # Antenna complex
  cv:KW-0052 # Apoplast
  cv:KW-0134 # Cell wall
  cv:KW-0151 # Chlorosome
  cv:KW-0166 # Nematocyst
  cv:KW-0188 # Copulatory plug
  cv:KW-0193 # Cuticle
  cv:KW-0281 # Fimbrium
  cv:KW-0304 # Gas vesicle
  cv:KW-0327 # Glycosome
  cv:KW-0330 # Glyoxysome
  cv:KW-0377 # Hydrogenosome
  cv:KW-0419 # Kinetoplast
  cv:KW-0542 # Nucleomorph
  cv:KW-0574 # Periplasm
  cv:KW-0603 # Photosystem I
  cv:KW-0604 # Photosystem II
  cv:KW-0605 # Phycobilisome
  cv:KW-0674 # Reaction center
  cv:KW-0793 # Thylakoid
  cv:KW-0842 # Viral occlusion body
  cv:KW-0875 # Capsule
  cv:KW-0934 # Plastid
  cv:KW-0974 # Archaeal flagellum
  cv:KW-0975 # Bacterial flagellum
  cv:KW-1001 # Plastid inner membrane
  cv:KW-1002 # Plastid outer membrane
  cv:KW-1025 # Mitosome
  cv:KW-1031 # Host cell junction
  cv:KW-1034 # Host cell projection
  cv:KW-1035 # Host cytoplasm
  cv:KW-1036 # Host cytoplasmic vesicle
  cv:KW-1038 # Host endoplasmic reticulum
  cv:KW-1039 # Host endosome
  cv:KW-1040 # Host Golgi apparatus
  cv:KW-1041 # Host lipid droplet
  cv:KW-1042 # Host lysosome
  cv:KW-1043 # Host membrane
  cv:KW-1045 # Host mitochondrion
  cv:KW-1048 # Host nucleus
  cv:KW-1049 # Host periplasm
  cv:KW-1050 # Host thylakoid
  cv:KW-1266 # Target cell cytoplasm
  }
  ?entry :isoform /:keyword /:term ?kw.
}
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v2("?entry"):::projected 
  v1("?kw")
  a1((" "))
  a2((" "))
  bind0[/VALUES ?kw/]
  bind0-->v1
  bind00([":terminology/KW-0042"])
  bind00 --> bind0
  bind01([":terminology/KW-0052"])
  bind01 --> bind0
  bind02([":terminology/KW-0134"])
  bind02 --> bind0
  bind03([":terminology/KW-0151"])
  bind03 --> bind0
  bind04([":terminology/KW-0166"])
  bind04 --> bind0
  bind05([":terminology/KW-0188"])
  bind05 --> bind0
  bind06([":terminology/KW-0193"])
  bind06 --> bind0
  bind07([":terminology/KW-0281"])
  bind07 --> bind0
  bind08([":terminology/KW-0304"])
  bind08 --> bind0
  bind09([":terminology/KW-0327"])
  bind09 --> bind0
  bind010([":terminology/KW-0330"])
  bind010 --> bind0
  bind011([":terminology/KW-0377"])
  bind011 --> bind0
  bind012([":terminology/KW-0419"])
  bind012 --> bind0
  bind013([":terminology/KW-0542"])
  bind013 --> bind0
  bind014([":terminology/KW-0574"])
  bind014 --> bind0
  bind015([":terminology/KW-0603"])
  bind015 --> bind0
  bind016([":terminology/KW-0604"])
  bind016 --> bind0
  bind017([":terminology/KW-0605"])
  bind017 --> bind0
  bind018([":terminology/KW-0674"])
  bind018 --> bind0
  bind019([":terminology/KW-0793"])
  bind019 --> bind0
  bind020([":terminology/KW-0842"])
  bind020 --> bind0
  bind021([":terminology/KW-0875"])
  bind021 --> bind0
  bind022([":terminology/KW-0934"])
  bind022 --> bind0
  bind023([":terminology/KW-0974"])
  bind023 --> bind0
  bind024([":terminology/KW-0975"])
  bind024 --> bind0
  bind025([":terminology/KW-1001"])
  bind025 --> bind0
  bind026([":terminology/KW-1002"])
  bind026 --> bind0
  bind027([":terminology/KW-1025"])
  bind027 --> bind0
  bind028([":terminology/KW-1031"])
  bind028 --> bind0
  bind029([":terminology/KW-1034"])
  bind029 --> bind0
  bind030([":terminology/KW-1035"])
  bind030 --> bind0
  bind031([":terminology/KW-1036"])
  bind031 --> bind0
  bind032([":terminology/KW-1038"])
  bind032 --> bind0
  bind033([":terminology/KW-1039"])
  bind033 --> bind0
  bind034([":terminology/KW-1040"])
  bind034 --> bind0
  bind035([":terminology/KW-1041"])
  bind035 --> bind0
  bind036([":terminology/KW-1042"])
  bind036 --> bind0
  bind037([":terminology/KW-1043"])
  bind037 --> bind0
  bind038([":terminology/KW-1045"])
  bind038 --> bind0
  bind039([":terminology/KW-1048"])
  bind039 --> bind0
  bind040([":terminology/KW-1049"])
  bind040 --> bind0
  bind041([":terminology/KW-1050"])
  bind041 --> bind0
  bind042([":terminology/KW-1266"])
  bind042 --> bind0
  v2 --":isoform"-->  a1
  a1 --":keyword"-->  a2
  a2 --":term"-->  v1