. . . . "Like 'Get the classes of an ontology from space members', but links classes to the ontology via dct:isPartOf (the predicate used by the biochementity template). Returns the biochementities (owl:Class) that declare dct:isPartOf the given resource, restricted to nanopubs published by an admin, maintainer, or member of the space that maintains the resource. The maintaining space and its validated member public-key hashes are resolved server-side from the spaces repo (/repo/spaces); observers are excluded. Each class URI appears once, kept from the latest (by nanopub timestamp) member-published definition. Superclass labels are taken from the superclass' own rdfs:label when it is a biochementity in the same ontology. The status column is a multi-value literal listing the curation states that \"approved\", apply to the winning definition: \"deprecated\" (owl:DeprecatedClass), \"withdrawn\" (gen:WithdrawnTerm) and \"example\" (npx:ExampleNanopub), in that order. It replaces the former types column. A version counts as approved when the newest non-invalidated approval/disapproval nanopublication targeting it is an npx:approvesOf (latest wins across all publishers: a later npx:disapprovesOf neutralises an earlier approval, and a later approval reinstates it), its publisher signed with a key that belongs to a current member+ of the maintaining space, and that publisher is not the signer of the nanopublication being approved (self-approval never counts). The approve_target, disapprove_target and approval_choice columns are action data rather than content: exactly one of the two targets is non-empty per row -- approve_target while the row is unapproved, disapprove_target once it is approved -- so a view can offer a per-row approve/disapprove action whose label follows the current state, and approval_choice carries the matching npx predicate to pre-fill in the approval template. A contribution signed by a software agent (an npx:SoftwareAgent that declares its own key, e.g. a curation bot) counts as approved by default, on the grounds that the space admitted it as a member: no separate npx:approvesOf is needed. The default is only a starting point -- an outstanding member disapproval overrides it, and disapproving then re-approving returns the nanopublication to the explicit state. Human contributions carry no default and start out unapproved. The winning verdict per target is now selected by a max() over member-signed verdicts rather than by a nested not-exists, so the disapproval that overturns an approval must itself come from a member -- matching get-term-version-history, and keeping every federated call at one SERVICE level. Approval is judged on the winning definition only, so publishing a new version starts it out unapproved. Because approval nanopublications do not carry the owl:Class nanopub type they are absent from the type-scoped endpoint this query runs on, so the set of currently approved class nanopublications is resolved once per request by a self-contained sub-select that federates to /repo/full for the approvals and to /repo/spaces for the approvers' member keys. Note that \"withdrawn\" can never appear here because withdrawn classes are excluded by the filter below; the branch is kept so the expression matches the one in get-term-version-history and still works if that filter is ever relaxed. Classes whose winning definition types them gen:WithdrawnTerm are withdrawn from the vocabulary and are excluded entirely; withdrawal is judged on the winning definition only, so publishing a new version without that type reinstates the class. The last_modified_by/last_modified columns give the signer and timestamp of that latest definition; the signer name is resolved from the trust repo (/repo/trust) or left blank." . . . "Get the biochementities of an ontology from space members" . . "prefix owl: \n prefix rdfs: \n prefix dct: \n prefix np: \n prefix npa: \n prefix npx: \n prefix skos: \n prefix gen: \n prefix foaf: \n\n select ?class ?class_label ?description ?superclasses_multi_iri ?superclasses_label_multi\n ?status_multi\n ?last_modified_by (sample(?lmbl) as ?last_modified_by_label) ?last_modified\n (?np as ?override_target) ?approve_target ?disapprove_target ?approval_choice ?np ?np_label where {\n {\n select ?class ?class_label (?definition as ?description)\n (group_concat(distinct str(?superclass); separator=\" \") as ?superclasses_multi_iri)\n (group_concat(distinct replace(replace(coalesce(?superclass_lbl, str(?superclass)), \"\\\\\\\\\", \"\\\\\\\\\\\\\\\\\"), \"[\\r\\n]+\", \"\\\\\\\\n\"); separator=\"\\n\") as ?superclasses_label_multi)\n ?status_multi ?approve_target ?disapprove_target ?approval_choice\n (sample(?user) as ?last_modified_by) (sample(?date) as ?last_modified)\n ?np (\"^\" as ?np_label) where {\n values ?_ontology_multi_iri {}\n service {\n select (group_concat(?mpk; separator=\" \") as ?memberPubkeys) where {\n graph npa:graph { npa:thisRepo npa:hasCurrentSpaceState ?stateG . }\n values ?_ontology_multi_iri {}\n graph ?stateG {\n ?_ontology_multi_iri npa:isMaintainedBy? ?space .\n ?ri a gen:RoleInstantiation ; npa:forSpace ?space ; npa:forAgent ?agent ;\n npa:hasRoleType ?rt .\n filter(?rt in (gen:AdminRole, gen:MaintainerRole, gen:MemberRole))\n ?acct a npa:AccountState ; npa:agent ?agent ; npa:pubkey ?mpk .\n }\n }\n }\n graph npa:graph {\n ?np npx:hasNanopubType owl:Class .\n ?np npa:hasValidSignatureForPublicKeyHash ?pubkey .\n filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . }\n ?np dct:created ?date .\n ?np npx:introduces ?class .\n ?np np:hasAssertion ?a .\n optional { ?np npx:signedBy ?user . }\n }\n filter(contains(?memberPubkeys, ?pubkey))\n {\n select (group_concat(distinct ?apV; separator=\" \") as ?approvedNps)\n (group_concat(distinct ?disV; separator=\" \") as ?disapprovedNps) where {\n {\n select ?vTarget (max(concat(str(?vDate), \">\", str(?vNp), \">\", ?vMark)) as ?vWin) where {\n values ?_ontology_multi_iri {}\n service {\n select (group_concat(?vpk; separator=\" \") as ?vMemberPubkeys) where {\n graph npa:graph { npa:thisRepo npa:hasCurrentSpaceState ?vStateG . }\n values ?_ontology_multi_iri {}\n graph ?vStateG {\n ?_ontology_multi_iri npa:isMaintainedBy? ?vSpace .\n ?vRi a gen:RoleInstantiation ; npa:forSpace ?vSpace ; npa:forAgent ?vMember ;\n npa:hasRoleType ?vRt .\n filter(?vRt in (gen:AdminRole, gen:MaintainerRole, gen:MemberRole))\n ?vAcct a npa:AccountState ; npa:agent ?vMember ; npa:pubkey ?vpk .\n }\n }\n }\n service {\n select distinct ?vTarget ?vNp ?vDate ?vPubkey ?vMark where {\n graph npa:graph {\n ?vTarget npx:hasNanopubType owl:Class ; npx:signedBy ?targetAgent .\n ?vNp npx:signedBy ?vAgent ;\n npa:hasValidSignatureForPublicKeyHash ?vPubkey ;\n dct:created ?vDate ;\n np:hasAssertion ?vA .\n filter not exists { ?vInv npx:invalidates ?vNp ; npa:hasValidSignatureForPublicKeyHash ?vPubkey . }\n }\n graph ?vA { ?vAgent ?vPred ?vTarget . }\n values ?vPred { npx:approvesOf npx:disapprovesOf }\n filter(?vAgent != ?targetAgent)\n bind(if(?vPred = npx:approvesOf, \"a\", \"d\") as ?vMark)\n }\n }\n filter(contains(?vMemberPubkeys, ?vPubkey))\n } group by ?vTarget\n }\n bind(if(strends(?vWin, \"a\"), str(?vTarget), \"\") as ?apV)\n bind(if(strends(?vWin, \"d\"), str(?vTarget), \"\") as ?disV)\n }\n }\n {\n select (group_concat(distinct str(?saAgent); separator=\" \") as ?trustedBots) where {\n service {\n graph ?saA { ?saAgent a npx:SoftwareAgent . ?saKd npx:declaredBy ?saAgent . }\n }\n }\n }\n graph ?a {\n ?class dct:isPartOf ?_ontology_multi_iri .\n optional { ?class rdfs:label ?class_label . filter(lang(?class_label) = \"\") }\n optional { ?class skos:definition ?definition . }\n optional { ?class rdfs:subClassOf ?superclass . filter(isIRI(?superclass)) }\n }\n filter not exists { graph ?a { ?class a gen:WithdrawnTerm } }\n bind(coalesce(?user, ) as ?userSafe)\n bind(contains(concat(\" \", ?approvedNps, \" \"), concat(\" \", str(?np), \" \")) as ?explicitApproved)\n bind(contains(concat(\" \", ?disapprovedNps, \" \"), concat(\" \", str(?np), \" \")) as ?explicitDisapproved)\n bind(contains(concat(\" \", ?trustedBots, \" \"), concat(\" \", str(?userSafe), \" \")) as ?isTrustedBot)\n bind(?explicitApproved || (?isTrustedBot && !?explicitDisapproved) as ?isApproved)\n bind(if(?isApproved, \"\", str(?np)) as ?approve_target)\n bind(if(?isApproved, str(?np), \"\") as ?disapprove_target)\n bind(if(?isApproved, str(npx:disapprovesOf), str(npx:approvesOf)) as ?approval_choice)\n bind(replace(concat(\n if(?isApproved, \"approved\\n\", \"\"),\n if(exists { graph ?a { ?class a owl:DeprecatedClass } }, \"deprecated\\n\", \"\"),\n if(exists { graph ?a { ?class a gen:WithdrawnTerm } }, \"withdrawn\\n\", \"\"),\n if(exists { graph npa:graph { ?np npx:hasNanopubType npx:ExampleNanopub } }, \"example\\n\", \"\")\n ), \"\\n$\", \"\") as ?status_multi)\n filter not exists {\n graph npa:graph {\n ?np2 npx:hasNanopubType owl:Class .\n ?np2 npa:hasValidSignatureForPublicKeyHash ?pubkey2 .\n filter not exists { ?np2x npx:invalidates ?np2 ; npa:hasValidSignatureForPublicKeyHash ?pubkey2 . }\n ?np2 dct:created ?date2 .\n ?np2 npx:introduces ?class .\n ?np2 np:hasAssertion ?a2 .\n }\n filter(contains(?memberPubkeys, ?pubkey2))\n graph ?a2 { ?class dct:isPartOf ?_ontology_multi_iri . }\n filter(?date2 > ?date || (?date2 = ?date && str(?np2) > str(?np)))\n }\n optional {\n select ?superclass (sample(?sclbl) as ?superclass_lbl) where {\n values ?_ontology_multi_iri {}\n graph npa:graph { ?scnp npx:hasNanopubType owl:Class ; npx:introduces ?superclass ; np:hasAssertion ?sca . }\n graph ?sca { ?superclass dct:isPartOf ?_ontology_multi_iri ; rdfs:label ?sclbl . }\n } group by ?superclass\n }\n } group by ?class ?class_label ?definition ?status_multi ?approve_target ?disapprove_target ?approval_choice ?np\n }\n optional {\n service {\n select ?last_modified_by ?lmbl where {\n graph npa:graph { npa:thisRepo npa:hasCurrentTrustState ?tg . }\n graph ?tg { ?last_modified_by foaf:name ?lmbl . }\n }\n }\n }\n }\n group by ?class ?class_label ?description ?superclasses_multi_iri ?superclasses_label_multi ?status_multi ?last_modified_by ?last_modified ?approve_target ?disapprove_target ?approval_choice ?np ?np_label\n order by ?class_label" . . "Tobias Kuhn" . "2026-08-12T08:51:20Z"^^ . . . . . "Get the biochementities of an ontology from space members" . . . . . . "RSA" . "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB" . "M+5etTlKdGWYWUJt4sFtb75FcyrNOo6Som2vkR+ZS7L1Z62wOTp2cI4o0wKSfCxaQtgPFr+fnTmTRHBg8nmQ5WlkFK2YXPlBVSDkWkGCs1lGAK9sZB+Nad3TRSWyf4C09S4ultyqB0YY2NTbH54UH8K047hhO6L0yp8EPfM6FeY=" . . .