rows {
  options {
    physical_type: PHYSICAL_STREAM_TYPE_QUADS
    max_name_table_size: 128
    max_prefix_table_size: 16
    max_datatype_table_size: 16
    logical_type: LOGICAL_STREAM_TYPE_DATASETS
    version: 2
  }
}
rows {
  prefix {
    value: "https://w3id.org/np/"
  }
}
rows {
  name {
    value: "RAkb9lmkKVrKgmBNiYuK1GSmTL5xlHVRVpbsCiVVROuPo"
  }
}
rows {
  namespace {
    name: "this"
    value {
      prefix_id: 1
    }
  }
}
rows {
  prefix {
    value: "https://w3id.org/np/RAkb9lmkKVrKgmBNiYuK1GSmTL5xlHVRVpbsCiVVROuPo/"
  }
}
rows {
  name {
  }
}
rows {
  namespace {
    name: "sub"
    value {
      prefix_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://www.nanopub.org/nschema#"
  }
}
rows {
  namespace {
    name: "np"
    value {
      prefix_id: 3
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://purl.org/dc/terms/"
  }
}
rows {
  namespace {
    name: "dct"
    value {
      prefix_id: 4
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "https://w3id.org/np/o/ntemplate/"
  }
}
rows {
  namespace {
    name: "nt"
    value {
      prefix_id: 5
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://purl.org/nanopub/x/"
  }
}
rows {
  namespace {
    name: "npx"
    value {
      prefix_id: 6
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://www.w3.org/2001/XMLSchema#"
  }
}
rows {
  namespace {
    name: "xsd"
    value {
      prefix_id: 7
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://www.w3.org/2000/01/rdf-schema#"
  }
}
rows {
  namespace {
    name: "rdfs"
    value {
      prefix_id: 8
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "https://orcid.org/"
  }
}
rows {
  namespace {
    name: "orcid"
    value {
      prefix_id: 9
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://www.w3.org/ns/prov#"
  }
}
rows {
  namespace {
    name: "prov"
    value {
      prefix_id: 10
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://xmlns.com/foaf/0.1/"
  }
}
rows {
  namespace {
    name: "foaf"
    value {
      prefix_id: 11
      name_id: 2
    }
  }
}
rows {
  name {
    value: "hasAssertion"
  }
}
rows {
  name {
    value: "assertion"
  }
}
rows {
  name {
    value: "Head"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 1
      name_id: 1
    }
    p_iri {
      prefix_id: 3
      name_id: 3
    }
    o_iri {
      prefix_id: 2
    }
    g_iri {
    }
  }
}
rows {
  name {
    value: "hasProvenance"
  }
}
rows {
  name {
    value: "provenance"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 3
    }
    o_iri {
      prefix_id: 2
    }
  }
}
rows {
  name {
    value: "hasPublicationInfo"
  }
}
rows {
  name {
    value: "pubinfo"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 3
    }
    o_iri {
      prefix_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://www.w3.org/1999/02/22-rdf-syntax-ns#"
  }
}
rows {
  name {
    value: "type"
  }
}
rows {
  name {
    value: "Nanopublication"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 12
    }
    o_iri {
      prefix_id: 3
    }
  }
}
rows {
  name {
    value: "get-biochementities-from-space-members"
  }
}
rows {
  name {
    value: "description"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 2
    }
    p_iri {
      prefix_id: 4
    }
    o_literal {
      lex: "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."
    }
    g_iri {
      prefix_id: 2
      name_id: 4
    }
  }
}
rows {
  name {
    value: "license"
  }
}
rows {
  prefix {
    value: "http://www.apache.org/licenses/"
  }
}
rows {
  name {
    value: "LICENSE-2.0"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 4
      name_id: 14
    }
    o_iri {
      prefix_id: 13
    }
  }
}
rows {
  prefix {
    value: "https://w3id.org/kpxl/grlc/"
  }
}
rows {
  name {
    value: "grlc-query"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 12
      name_id: 10
    }
    o_iri {
      prefix_id: 14
      name_id: 16
    }
  }
}
rows {
  name {
    value: "label"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 8
    }
    o_literal {
      lex: "Get the biochementities of an ontology from space members"
    }
  }
}
rows {
  name {
    value: "endpoint"
  }
}
rows {
  prefix {
    value: "https://w3id.org/np/l/nanopub-query-1.1/repo/type/"
  }
}
rows {
  name {
    value: "e8cc5bb29ec5597303f8f101c65c545dc124ee0df68ce733764b03adc3237184"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 14
    }
    o_iri {
      prefix_id: 15
    }
  }
}
rows {
  name {
    value: "sparql"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 14
    }
    o_literal {
      lex: "prefix owl: <http://www.w3.org/2002/07/owl#>\n  prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>\n  prefix dct: <http://purl.org/dc/terms/>\n  prefix np: <http://www.nanopub.org/nschema#>\n  prefix npa: <http://purl.org/nanopub/admin/>\n  prefix npx: <http://purl.org/nanopub/x/>\n  prefix skos: <http://www.w3.org/2004/02/skos/core#>\n  prefix gen: <https://w3id.org/kpxl/gen/terms/>\n  prefix foaf: <http://xmlns.com/foaf/0.1/>\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 <https://w3id.org/np/l/nanopub-query-1.1/repo/spaces> {\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 <https://w3id.org/np/l/nanopub-query-1.1/repo/spaces> {\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 <https://w3id.org/np/l/nanopub-query-1.1/repo/full> {\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 <https://w3id.org/np/l/nanopub-query-1.1/repo/type/77757cabf6184c51c20b8b0fe5dc5e1365b7f628448335184ad54319a0affdfc> {\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, <http://purl.org/nanopub/temp/none>) 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 <https://w3id.org/np/l/nanopub-query-1.1/repo/trust> {\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"
    }
  }
}
rows {
  name {
    value: "wasAttributedTo"
  }
}
rows {
  name {
    value: "0000-0002-1267-0234"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 2
      name_id: 4
    }
    p_iri {
      prefix_id: 10
      name_id: 21
    }
    o_iri {
      prefix_id: 9
    }
    g_iri {
      prefix_id: 2
      name_id: 7
    }
  }
}
rows {
  name {
    value: "name"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 9
      name_id: 22
    }
    p_iri {
      prefix_id: 11
    }
    o_literal {
      lex: "Tobias Kuhn"
    }
    g_iri {
      prefix_id: 2
      name_id: 9
    }
  }
}
rows {
  name {
    value: "created"
  }
}
rows {
  datatype {
    value: "http://www.w3.org/2001/XMLSchema#dateTime"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 1
      name_id: 1
    }
    p_iri {
      prefix_id: 4
      name_id: 24
    }
    o_literal {
      lex: "2026-08-12T08:51:20Z"
      datatype: 1
    }
  }
}
rows {
  name {
    value: "creator"
  }
}
rows {
  quad {
    p_iri {
    }
    o_iri {
      prefix_id: 9
      name_id: 22
    }
  }
}
rows {
  prefix {
    value: "https://creativecommons.org/publicdomain/zero/1.0/"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 4
      name_id: 14
    }
    o_iri {
      prefix_id: 16
      name_id: 2
    }
  }
}
rows {
  name {
    value: "embeds"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 6
      name_id: 26
    }
    o_iri {
      prefix_id: 2
      name_id: 12
    }
  }
}
rows {
  name {
    value: "supersedes"
  }
}
rows {
  name {
    value: "RAyPwuo3lQ0wzSQaYHf30hkeI5BzKljRxp9hHJqsl9p9c"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 6
      name_id: 27
    }
    o_iri {
      prefix_id: 1
    }
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 8
      name_id: 17
    }
    o_literal {
      lex: "Get the biochementities of an ontology from space members"
    }
  }
}
rows {
  name {
    value: "wasCreatedFromProvenanceTemplate"
  }
}
rows {
  name {
    value: "RA7lSq6MuK_TIC6JMSHvLtee3lpLoZDOqLJCLXevnrPoU"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 5
      name_id: 29
    }
    o_iri {
      prefix_id: 1
    }
  }
}
rows {
  name {
    value: "wasCreatedFromPubinfoTemplate"
  }
}
rows {
  name {
    value: "RACJ58Gvyn91LqCKIO9zu1eijDQIeEff28iyDrJgjSJF8"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 5
    }
    o_iri {
      prefix_id: 1
    }
  }
}
rows {
  name {
    value: "RAoTD7udB2KtUuOuAe74tJi1t3VzK0DyWS7rYVAq1GRvw"
  }
}
rows {
  quad {
    o_iri {
    }
  }
}
rows {
  name {
    value: "RAukAcWHRDlkqxk7H2XNSegc1WnHI569INvNr-xdptDGI"
  }
}
rows {
  quad {
    o_iri {
    }
  }
}
rows {
  name {
    value: "wasCreatedFromTemplate"
  }
}
rows {
  name {
    value: "RAEFAt-QcFK0ZhqfvlsmS10BnzGJA0xwOICZXkO-ai87k"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 5
    }
    o_iri {
      prefix_id: 1
    }
  }
}
rows {
  name {
    value: "sig"
  }
}
rows {
  name {
    value: "hasAlgorithm"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 2
    }
    p_iri {
      prefix_id: 6
    }
    o_literal {
      lex: "RSA"
    }
  }
}
rows {
  name {
    value: "hasPublicKey"
  }
}
rows {
  quad {
    p_iri {
    }
    o_literal {
      lex: "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB"
    }
  }
}
rows {
  name {
    value: "hasSignature"
  }
}
rows {
  quad {
    p_iri {
    }
    o_literal {
      lex: "M+5etTlKdGWYWUJt4sFtb75FcyrNOo6Som2vkR+ZS7L1Z62wOTp2cI4o0wKSfCxaQtgPFr+fnTmTRHBg8nmQ5WlkFK2YXPlBVSDkWkGCs1lGAK9sZB+Nad3TRSWyf4C09S4ultyqB0YY2NTbH54UH8K047hhO6L0yp8EPfM6FeY="
    }
  }
}
rows {
  name {
    value: "hasSignatureTarget"
  }
}
rows {
  quad {
    p_iri {
    }
    o_iri {
      prefix_id: 1
      name_id: 1
    }
  }
}
rows {
  name {
    value: "signedBy"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 6
      name_id: 42
    }
    o_iri {
      prefix_id: 9
      name_id: 22
    }
  }
}