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: "RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ" } } rows { namespace { name: "this" value { prefix_id: 1 } } } rows { prefix { value: "https://w3id.org/np/RAlNHKBFeDjfV_7y4W6RMhJ5huw-RGoSIoYbq8XYm9opQ/" } } 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-latest-users-with-type" } } rows { name { value: "description" } } rows { quad { s_iri { prefix_id: 2 } p_iri { prefix_id: 4 } o_literal { lex: "Returns the latest 100 users who have introduced themselves, newest first, with their display name, a type column (software agent if declared npx:SoftwareAgent, human if an ORCID, unknown otherwise), a joined column (creation time of their earliest introduction) and a status column marking users not yet approved in the trust state; for those, approve_target holds their current (latest non-invalidated) introduction nanopub." } 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 latest users with name and type" } } } rows { name { value: "endpoint" } } rows { prefix { value: "https://w3id.org/np/l/nanopub-query-1.1/repo/type/" } } rows { name { value: "77757cabf6184c51c20b8b0fe5dc5e1365b7f628448335184ad54319a0affdfc" } } 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 np: \nprefix npx: \nprefix npa: \nprefix dct: \nprefix foaf: \n\nselect ?user_iri (sample(?name) as ?user_iri_label) (if(?isBot, \"\360\237\244\226 software agent\", if(strstarts(str(?user_iri), \"https://orcid.org/\") || strstarts(str(?user_iri), \"http://orcid.org/\"), \"\360\237\221\244 human\", \"\342\235\224 unknown\")) as ?type) (str(?mindate) as ?joined) (if(?isApproved, \"\", \"\342\217\263 not yet approved\") as ?status) (if(?isApproved, \"\", strafter(max(concat(str(?introDate), \" \", str(?currentIntro))), \" \")) as ?approve_target) where {\n {\n select ?user_iri (min(?date) as ?mindate) where {\n graph npa:graph {\n ?intronp npa:hasValidSignatureForPublicKey ?introPubkey .\n filter not exists { ?intronpx npx:retracts ?intronp ; npa:hasValidSignatureForPublicKey ?pubkey . }\n filter not exists { ?intronp npx:supersedes ?intronpx . }\n ?intronp dct:created ?date .\n ?intronp np:hasAssertion ?a .\n }\n graph ?a {\n ?keydeclaration npx:declaredBy ?user_iri .\n ?keydeclaration npx:hasPublicKey ?pubkey .\n }\n }\n group by ?user_iri\n order by desc(?mindate)\n limit 100\n }\n {\n select (concat(\" \", group_concat(distinct str(?approvedAgent); separator=\" \"), \" \") as ?approvedAgents) where {\n service {\n graph npa:graph { npa:thisRepo npa:hasCurrentTrustState ?tg . }\n graph ?tg { ?acct npa:agent ?approvedAgent ; npa:trustStatus ?trustStatus . }\n values ?trustStatus { npa:loaded npa:toLoad }\n }\n }\n }\n bind(contains(?approvedAgents, concat(\" \", str(?user_iri), \" \")) as ?isApproved)\n bind(exists { graph ?a2 { ?user_iri a npx:SoftwareAgent } } as ?isBot)\n optional { graph ?a3 { ?kd3 npx:declaredBy ?user_iri . ?user_iri foaf:name ?name } }\n optional {\n graph npa:graph {\n ?currentIntro npa:hasValidSignatureForPublicKey ?currentPubkey ; np:hasAssertion ?a4 ; dct:created ?introDate .\n filter not exists { ?invalidating npx:invalidates ?currentIntro ; npa:hasValidSignatureForPublicKey ?currentPubkey . }\n }\n graph ?a4 { ?kd4 npx:declaredBy ?user_iri . }\n }\n}\ngroup by ?user_iri ?mindate ?isBot ?isApproved\norder by desc(?mindate)" } } } 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-09-25T08:36:50Z" datatype: 1 } } } rows { name { value: "creator" } } rows { quad { p_iri { } o_iri { prefix_id: 9 name_id: 22 } } } rows { prefix { value: "https://creativecommons.org/licenses/by/4.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: "RAvlxWqDNtsqXPDqPmXG0-IOysqKAvUVpftJbQ7hoJcWg" } } 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 latest users with name and type" } } } 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: "RA-N4_kFxcruvBTlo1yJv29E4SLOXsx5KO_th69PprMrA" } } rows { quad { p_iri { prefix_id: 5 } o_iri { prefix_id: 1 } } } rows { name { value: "RACJ58Gvyn91LqCKIO9zu1eijDQIeEff28iyDrJgjSJF8" } } rows { quad { o_iri { } } } rows { name { value: "RARJj78P72NR5edKOnu_f4ePE9NYYuW2m2pM-fEoobMBk" } } rows { quad { o_iri { } } } rows { name { value: "RAoTD7udB2KtUuOuAe74tJi1t3VzK0DyWS7rYVAq1GRvw" } } 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: "Rxu4JAb6cVLNotS0Aa9RlXgVvX52YJd4WgsZ9IE2u289aMvjO1ANEa1weQljcnKn7anFcUpSGC6m+9rUepPW/EjOvSPXFbGEYP7Qm4hCW8y2x0sHHhkuuF+G2u1el9UzhwLEzJ4uTplxCGJSZHAjwc7u9Avqe3iAnZuABysU+ZI=" } } } 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: 43 } o_iri { prefix_id: 9 name_id: 22 } } }