A set of SPARQL examples that are used in different SIB resources
Cell lines resistant to vincaleukoblastine
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