sparql-examples

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

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

32

Find UniProtKB entries with more than 1 Topological domain annotation

Use at

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX up: <http://purl.uniprot.org/core/>

SELECT 
    ?protein 
    (GROUP_CONCAT(?comment; separator=", ") AS ?comments)
WHERE
{
    ?protein a up:Protein ;
            up:annotation ?annotation . 
    ?annotation rdf:type up:Topological_Domain_Annotation ;
            rdfs:comment ?comment .
} 
GROUP BY ?protein 
HAVING (COUNT(?annotation) > 1)
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v4("?_anon_aaf95e3c346c4c97af230d5bcfeba8ab6080")
  v2("?annotation")
  v3("?comment"):::projected 
  v5("?comments")
  v1("?protein"):::projected 
  a1((" "))
  c5(["up:Topological_Domain_Annotation"]):::iri 
  c3(["up:Protein"]):::iri 
  f0[[" > '1^^xsd:integer'"]]
  f0 --> a1
  v1 --"a"-->  c3
  v1 --"up:annotation"-->  v2
  v2 --"a"-->  c5
  v2 --"rdfs:comment"-->  v3
  bind3[/"count(?annotation)"/]
  v2 --o bind3
  bind3 --as--o v4
  bind4[/"?comment"/]
  v3 --o bind4
  bind4 --as--o v5