sparql-examples

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

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

Query_127

rq turtle/ttl

Top 100 parent cell lines (from which other cell lines have been derived)

Use at


PREFIX cello: <https://purl.expasy.org/cellosaurus/rdf/ontology/>
select ?cl ?cl_name (count(?child) as ?child_count) where {
  ?cl cello:recommendedName ?cl_name .
  ?cl cello:hasChildCellLine ?child .
}
group by ?cl ?cl_name
order by desc(count(?child))
limit 100
    
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v4("?_anon_39b94405334d4c98a94d4349b2e252703")
  v3("?child"):::projected 
  v5("?child_count")
  v1("?cl"):::projected 
  v2("?cl_name"):::projected 
  a1((" "))
  v1 --"cello:recommendedName"-->  v2
  v1 --"cello:hasChildCellLine"-->  v3
  bind2[/"count(?child)"/]
  v3 --o bind2
  bind2 --as--o v4
  bind3[/"count(?child)"/]
  v3 --o bind3
  bind3 --as--o v5