sparql-examples

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

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

Query_128

rq turtle/ttl

Top 100 agents used to transform cell lines

Use at


PREFIX cello: <https://purl.expasy.org/cellosaurus/rdf/ontology/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
select ?transformant_name (count(distinct ?cl) as ?cl_count) where {
  ?cl cello:transformedBy ?annot.
  ?annot rdfs:label ?transformant_name .
}
group by ?transformant_name
order by desc(count(?annot))
limit 100
    
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v4("?_anon_ec727cdef44145fc8400f88674993a19490")
  v2("?annot")
  v1("?cl"):::projected 
  v5("?cl_count")
  v3("?transformant_name"):::projected 
  a1((" "))
  v1 --"cello:transformedBy"-->  v2
  v2 --"rdfs:label"-->  v3
  bind2[/"count(?annot)"/]
  v2 --o bind2
  bind2 --as--o v4
  bind3[/"count(?cl)"/]
  v1 --o bind3
  bind3 --as--o v5