162_common_taxon_of_a_uniref_cluster

rq turtle/ttl

Find the common taxon (the lowest taxon shared by all members) of the UniRef100 cluster that human TP53 (P04637) belongs to, and how many sequences that cluster groups together. up:commonTaxon is precomputed per UniRef cluster from its actual members, not a general-purpose lowest-common-ancestor function over two arbitrary organisms

Use at

PREFIX up: <http://purl.uniprot.org/core/>
PREFIX uniref: <http://purl.uniprot.org/uniref/>

SELECT ?cluster (COUNT(?member) AS ?memberCount) (SAMPLE(?rawCommonTaxonName) AS ?commonTaxonName)
WHERE {
  BIND(uniref:UniRef100_P04637 AS ?cluster)
  ?cluster up:member ?member ;
    up:commonTaxon ?commonTaxon .
  ?commonTaxon up:scientificName ?rawCommonTaxonName .
}
GROUP BY ?cluster
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v1("?cluster"):::projected 
  v3("?commonTaxon")
  v6("?commonTaxonName")
  v2("?member"):::projected 
  v5("?memberCount")
  v4("?rawCommonTaxonName"):::projected 
  bind0[/"http://purl.uniprot.org/uniref/UniRef100_P04637"/]
  bind0 --as--o v1
  v1 --"up:member"-->  v2
  v1 --"up:commonTaxon"-->  v3
  v3 --"up:scientificName"-->  v4
  bind3[/"count(?member)"/]
  v2 --o bind3
  bind3 --as--o v5
  bind4[/"sample(?rawCommonTaxonName)"/]
  v4 --o bind4
  bind4 --as--o v6