#
# example SPARQL query 107
#

@prefix schema: <https://schema.org/> . 
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> . 
@prefix sh: <http://www.w3.org/ns/shacl#> . 
@prefix cello: <https://purl.expasy.org/cellosaurus/rdf/ontology/> .


cello:Query_107 a sh:SPARQLExecutable ;
    sh:prefixes _:sparql_examples_prefixes ;
    rdfs:comment """Cell lines resistant to vincaleukoblastine"""@en ; 
    schema:keywords "resistance" ; 
    schema:target <https://sparql.cellosaurus.org/sparql> ; 
    sh:select """
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
    """
    .