Koetai SPARQL examples

Community-curated SPARQL example queries for multiple life-science endpoints.

View the Project on GitHub Koetai/sparql-examples

all_potential_links_to_external_resource

rq turtle/ttl

This query renders all potential identifiers that can be used to generate a federated query again IDR rdf

Use at

PREFIX ome: <https://ld.openmicroscopy.org/core/>
SELECT ?key WHERE {
  { SELECT DISTINCT ?key WHERE { ?e ome:key ?key } }
  FILTER( STRENDS(?key, " ID") || STRENDS(?key, " URL")
       || CONTAINS(?key, "Identifier") || CONTAINS(?key, "Accession")
       || CONTAINS(?key, "UniProt")  || CONTAINS(?key, "Entrez")
       || CONTAINS(?key, "RefSeq")   || CONTAINS(?key, "Ensembl")
       || CONTAINS(?key, "GenBank")  || CONTAINS(?key, "HGNC")
       || CONTAINS(?key, "GeneID")   || CONTAINS(?key, "LocusLink")
       || CONTAINS(?key, "EMPIAR")   || CONTAINS(?key, "BioStudies")
       || CONTAINS(?key, "PubMed")   || CONTAINS(?key, "DOI")
       || CONTAINS(?key, "Addgene")  || CONTAINS(?key, "GI Number") )
}
ORDER BY ?key

graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v2("?e")
  v1("?key"):::projected 
  f0[["(ends-with(?key,' ID') || (ends-with(?key,' URL') || (contains(?key,'Identifier') || (contains(?key,'Accession') || (contains(?key,'UniProt') || (contains(?key,'Entrez') || (contains(?key,'RefSeq') || (contains(?key,'Ensembl') || (contains(?key,'GenBank') || (contains(?key,'HGNC') || (contains(?key,'GeneID') || (contains(?key,'LocusLink') || (contains(?key,'EMPIAR') || (contains(?key,'BioStudies') || (contains(?key,'PubMed') || (contains(?key,'DOI') || (contains(?key,'Addgene') || contains(?key,'GI Number'))))))))))))))))))"]]
  f0 --> v1
  v2 --https://ld.openmicroscopy.org/core/key-->  v1