sparql-examples

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

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

Query_146

rq turtle/ttl

Cell lines that are annotated as endothelial cells

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#>
# All cell line with a child of CL_0000115 A+ endothelial cell
select distinct ?cl ?cl_name ?xref_db ?xref_ac ?xref_label where {
  ?cl cello:derivedFromCellType ?celltype .
  ?cl cello:recommendedName ?cl_name .
  ?celltype  cello:isIdentifiedByXref ?xref .
  ?xref cello:more_specific_than* ?generic_concept .
  ?generic_concept skos:notation "CL_0000115" ; skos:inScheme db:CL . # endothelial cell
  ?xref cello:accession ?xref_ac ; cello:database ?xref_db; skos:prefLabel ?xref_label .
}
limit 1000
    
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v2("?celltype")
  v1("?cl"):::projected 
  v3("?cl_name"):::projected 
  v5("?generic_concept")
  v4("?xref")
  v6("?xref_ac"):::projected 
  v7("?xref_db"):::projected 
  v8("?xref_label"):::projected 
  c6(["CL_0000115"]):::literal 
  c8([https://purl.expasy.org/cellosaurus/rdf/db/CL]):::iri 
  v1 --"cello:derivedFromCellType"-->  v2
  v1 --"cello:recommendedName"-->  v3
  v2 --"cello:isIdentifiedByXref"-->  v4
  v4 --"cello:more_specific_than"-->  v5
  v5 --"skos:notation"-->  c6
  v5 --"skos:inScheme"-->  c8
  v4 --"cello:accession"-->  v6
  v4 --"cello:database"-->  v7
  v4 --"skos:prefLabel"-->  v8