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_00090

Proteins which are linked to a disease and that do not have orthologs/paralogs in mouse

Use at

PREFIX : <http://nextprot.org/rdf/>
PREFIX db: <http://nextprot.org/rdf/db/>
PREFIX nextprot_cv: <http://nextprot.org/rdf/terminology/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

SELECT DISTINCT ?entry WHERE {
 ?entry :isoform ?iso.
 {
 ?iso :medical / rdf:type :Disease.
 } union {
 ?iso :uniprotKeyword / :term ?kw .
 ?kw :termType "Disease"^^xsd:string
 filter (?kw != nextprot_cv:KW-0656)
 }
 FILTER NOT EXISTS { ?entry :reference / :provenance db:MGI . }
}
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v1("?entry"):::projected 
  v2("?iso")
  v3("?kw")
  a2((" "))
  a3((" "))
  a1((" "))
  c12(["Disease"]):::literal 
  c7([":Disease"]):::iri 
  c3([":db/MGI"]):::iri 
  f0[["not  "]]
  subgraph f0e0["Exists Clause"]
    e0v1 --":reference"-->  e0a1
    e0a1 --":provenance"-->  e0c3
    e0v1("?entry"):::projected 
    e0a1((" ")):::projected 
    e0c3([":db/MGI"]):::iri 
  end
  f0--EXISTS--> f0e0
  f0 --> v1
  f0 --> c1
  f0 --> a1
  f0 --> c2
  f0 --> c3
  v1 --":reference"-->  a1
  a1 --":provenance"-->  c3
  v1 --":isoform"-->  v2
  subgraph union0[" Union "]
  subgraph union0l[" "]
    style union0l fill:#abf,stroke-dasharray: 3 3;
    f1[["?kw != ':terminology/KW-0656'"]]
    f1 --> v3
    v2 --":uniprotKeyword"-->  a3
    a3 --":term"-->  v3
    v3 --":termType"-->  c12
  end
  subgraph union0r[" "]
    style union0r fill:#abf,stroke-dasharray: 3 3;
    v2 --":medical"-->  a2
    a2 --"a"-->  c7
  end
  union0r <== or ==> union0l
  end