sparql-examples

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

View the Project on GitHub German-BioImaging/sparql-examples

002

rq turtle/ttl

Federated query connecting to Uniprot proteins via Gene Identifier key-value annotation.

Use at


    PREFIX owl: <http://www.w3.org/2002/07/owl#>
    PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
    PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
    PREFIX dcterms: <http://purl.org/dc/terms/>
    PREFIX dc: <http://purl.org/dc/elements/1.1/>
    PREFIX omecore: <https://ld.openmicroscopy.org/core/>
    PREFIX omekg: <https://ld.openmicroscopy.org/omekg#>
    PREFIX obda: <https://w3id.org/obda/vocabulary#>
    PREFIX xml: <http://www.w3.org/XML/1998/namespace/>
    PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
    PREFIX kv: <http://www.openmicroscopy.org/ns/default/>
    PREFIX idr: <https://idr.openmicroscopy.org/>
    PREFIX up: <http://purl.uniprot.org/core/>
    PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
    prefix bgee: <http://purl.uniprot.org/bgee/>

    select distinct ?img ?bgee ?up_protein where {
      <https://idr.openmicroscopy.org/Project/52>
      dcterms:hasPart/dcterms:hasPart ?img .
      ?img a omecore:Image ;
           omecore:hasAnnotation/omecore:mapEntry [omecore:key ?key; omecore:value ?value] .
      filter(?key = "Gene Identifier")
      bind(iri(concat(str(bgee:),?value)) as ?bgee) .

      SERVICE <https://qlever.dev/api/uniprot> {
        ?up_protein a up:Protein ;
                    up:reviewed true ;
                    rdfs:seeAlso ?bgee .
        }
    }

graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v4("?bgee"):::projected 
  v2("?img"):::projected 
  v1("?key")
  v5("?up_protein"):::projected 
  v3("?value")
  a1((" "))
  a3((" "))
  a2((" "))
  c5([https://ld.openmicroscopy.org/core/Image]):::iri 
  c2([https://idr.openmicroscopy.org/Project/52]):::iri 
  c13(["true^^xsd:boolean"]):::literal 
  c11(["up:Protein"]):::iri 
  f0[["?key = 'Gene Identifier'"]]
  f0 --> v1
  c2 --"dcterms:hasPart"-->  a1
  a1 --"dcterms:hasPart"-->  v2
  v2 --"a"-->  c5
  a2 --https://ld.openmicroscopy.org/core/key-->  v1
  a2 --https://ld.openmicroscopy.org/core/value-->  v3
  v2 --https://ld.openmicroscopy.org/core/hasAnnotation-->  a3
  a3 --https://ld.openmicroscopy.org/core/mapEntry-->  a2
  bind1[/"concat(str(http://purl.uniprot.org/bgee/),?value)"/]
  v3 --o bind1
  bind1 --as--o v4
  subgraph s1["https://qlever.dev/api/uniprot"]
    style s1 stroke-width:4px;
    v5 --"a"-->  c11
    v5 --"up:reviewed"-->  c13
    v5 --"rdfs:seeAlso"-->  v4
  end