sparql-examples

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

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

Query_107

rq turtle/ttl

Cell lines resistant to vincaleukoblastine

Use at


PREFIX cello: <https://purl.expasy.org/cellosaurus/rdf/ontology/>
PREFIX db: <https://purl.expasy.org/cellosaurus/rdf/db/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
select ?cl ?cl_name ?substance_label ?substance_notation where {
  ?cl cello:hasResistance ?substance .
  ?cl cello:recommendedName ?cl_name .
  ?substance cello:isIdentifiedByXref ?substance_xref .
  ?substance_xref skos:prefLabel ?substance_label ; skos:notation ?substance_notation .
  ?substance_xref cello:more_specific_than* ?generic_concept . # Note: it can be specific as well
  ?generic_concept skos:notation "CHEBI_27375" .   # CHEBI_27375 = vincaleukoblastine
  ?generic_concept skos:inScheme db:ChEBI .
}
limit 100
    
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v1("?cl"):::projected 
  v3("?cl_name"):::projected 
  v7("?generic_concept")
  v2("?substance")
  v5("?substance_label"):::projected 
  v6("?substance_notation"):::projected 
  v4("?substance_xref")
  c9([https://purl.expasy.org/cellosaurus/rdf/db/ChEBI]):::iri 
  c7(["CHEBI_27375"]):::literal 
  v1 --"cello:hasResistance"-->  v2
  v1 --"cello:recommendedName"-->  v3
  v2 --"cello:isIdentifiedByXref"-->  v4
  v4 --"skos:prefLabel"-->  v5
  v4 --"skos:notation"-->  v6
  v4 --"cello:more_specific_than"-->  v7
  v7 --"skos:notation"-->  c7
  v7 --"skos:inScheme"-->  c9