sparql-examples

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

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

Query_151

rq turtle/ttl

Registered name(s) of some cell lines

Use at


PREFIX cello: <https://purl.expasy.org/cellosaurus/rdf/ontology/>
select ?cl ?cl_name
        (count(?registered_name) as ?registered_name_count)
        (group_concat(?registered_name ; separator=' , ') as ?registered_names)
where {
        ?cl cello:registeredName ?registered_name .
    ?cl cello:recommendedName ?cl_name .
}
group by ?cl ?cl_name
order by ?cl
limit 100
    
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v1("?cl"):::projected 
  v3("?cl_name"):::projected 
  v2("?registered_name"):::projected 
  v4("?registered_name_count")
  v5("?registered_names")
  v1 --"cello:registeredName"-->  v2
  v1 --"cello:recommendedName"-->  v3
  bind2[/"count(?registered_name)"/]
  v2 --o bind2
  bind2 --as--o v4
  bind3[/"?registered_name"/]
  v2 --o bind3
  bind3 --as--o v5