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: "RANtwPAT8bDZLzpoegkPyNcCcGbK9XN2ga4BcpsRTI0PA"
  }
}
rows {
  namespace {
    name: "this"
    value {
      prefix_id: 1
    }
  }
}
rows {
  prefix {
    value: "https://w3id.org/np/RANtwPAT8bDZLzpoegkPyNcCcGbK9XN2ga4BcpsRTI0PA/"
  }
}
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: "https://w3id.org/kpxl/grlc/"
  }
}
rows {
  namespace {
    name: "grlc"
    value {
      prefix_id: 4
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://purl.org/dc/terms/"
  }
}
rows {
  namespace {
    name: "dct"
    value {
      prefix_id: 5
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "https://w3id.org/np/o/ntemplate/"
  }
}
rows {
  namespace {
    name: "nt"
    value {
      prefix_id: 6
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://purl.org/nanopub/x/"
  }
}
rows {
  namespace {
    name: "npx"
    value {
      prefix_id: 7
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://www.w3.org/2001/XMLSchema#"
  }
}
rows {
  namespace {
    name: "xsd"
    value {
      prefix_id: 8
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://www.w3.org/2000/01/rdf-schema#"
  }
}
rows {
  namespace {
    name: "rdfs"
    value {
      prefix_id: 9
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "https://orcid.org/"
  }
}
rows {
  namespace {
    name: "orcid"
    value {
      prefix_id: 10
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://www.w3.org/ns/prov#"
  }
}
rows {
  namespace {
    name: "prov"
    value {
      prefix_id: 11
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://xmlns.com/foaf/0.1/"
  }
}
rows {
  namespace {
    name: "foaf"
    value {
      prefix_id: 12
      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: 13
    }
    o_iri {
      prefix_id: 3
    }
  }
}
rows {
  name {
    value: "get-templates-by-user"
  }
}
rows {
  name {
    value: "description"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 2
    }
    p_iri {
      prefix_id: 5
    }
    o_literal {
      lex: "Returns the assertion templates created by the given user. Supports both template identity shapes: for templates with embedded identity (anchored via the npx:embeds triple), the label, tags, and publish link are based on the embedded template node (the IRI external references should carry); for legacy templates, the nanopub URI is used and the node is the assertion graph URI. Multiple tags are concatenated into one multi-value column, and dual labels collapse to one (untagged-language label preferred). Governed versions are deduplicated within the user\'s own output: of the user\'s non-invalidated versions declaring the same dct:isVersionOf plus gen:governedBy pair, only the newest is listed (no space-membership check, as the list reflects what the user created; the winners are materialized once in a single-row group_concat sub-select sharing no variables with the outer query)."
    }
    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: 5
      name_id: 14
    }
    o_iri {
      prefix_id: 14
    }
  }
}
rows {
  name {
    value: "grlc-query"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 13
      name_id: 10
    }
    o_iri {
      prefix_id: 4
      name_id: 16
    }
  }
}
rows {
  name {
    value: "label"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 9
    }
    o_literal {
      lex: "Get templates by given user"
    }
  }
}
rows {
  name {
    value: "endpoint"
  }
}
rows {
  prefix {
    value: "https://w3id.org/np/l/nanopub-query-1.1/repo/type/"
  }
}
rows {
  name {
    value: "79342356d3a68063a627e83ac34b376479e438abb8a4c4b27d49f845f537dc8d"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 4
    }
    o_iri {
      prefix_id: 15
    }
  }
}
rows {
  name {
    value: "sparql"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 4
    }
    o_literal {
      lex: "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nprefix dct: <http://purl.org/dc/terms/>\nprefix np: <http://www.nanopub.org/nschema#>\nprefix npa: <http://purl.org/nanopub/admin/>\nprefix npx: <http://purl.org/nanopub/x/>\nprefix nt: <https://w3id.org/np/o/ntemplate/>\nprefix gen: <https://w3id.org/kpxl/gen/terms/>\n\nselect (concat(\"<span><a href=\\\"/publish?template=\", encode_for_uri(str(?template_iri)), \"\\\">\", coalesce(min(?ulabel), min(?anylabel)), \"</a></span>\") as ?label) (group_concat(distinct replace(replace(str(?tag), \"\\\\\\\\\", \"\\\\\\\\\\\\\\\\\"), \"[\\r\\n]+\", \"\\\\\\\\n\"); separator=\"\\n\") as ?tags_multi) ?date ?np (\"^\" as ?np_label) where {\n  {\n    select (group_concat(?w1; separator=\"|\") as ?winners) where {\n      {\n        select ?gKind ?gSpace (max(concat(str(?gDate), \">\", str(?gNp))) as ?maxW) where {\n          graph npa:graph {\n            ?gNp npx:signedBy ?_user_iri ;\n                 npa:hasValidSignatureForPublicKey ?gPubkey ;\n                 dct:created ?gDate ;\n                 npx:embeds ?gVersion ;\n                 np:hasAssertion ?gA .\n            filter not exists { ?gInv npx:invalidates ?gNp ; npa:hasValidSignatureForPublicKey ?gPubkey . }\n          }\n          graph ?gA { ?gVersion dct:isVersionOf ?gKind ; gen:governedBy ?gSpace . }\n        } group by ?gKind ?gSpace\n      }\n      bind(concat(str(?gKind), \">\", str(?gSpace), \">\", ?maxW) as ?w1)\n    }\n  }\n  graph npa:graph {\n    ?np npx:signedBy ?_user_iri .\n    ?np npa:hasValidSignatureForPublicKey ?pubkey .\n    filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }\n    ?np npx:hasNanopubType nt:AssertionTemplate .\n    ?np dct:created ?date .\n    ?np np:hasAssertion ?a .\n  }\n  optional {\n    graph npa:graph { ?np npx:embeds ?tnode . }\n    graph ?a { ?tnode a nt:AssertionTemplate . }\n  }\n  bind(coalesce(?tnode, ?a) as ?t)\n  bind(if(?t = ?a, ?np, ?t) as ?template_iri)\n  graph ?a { ?t rdfs:label ?anylabel . }\n  optional { graph ?a { ?t rdfs:label ?ulabel . filter(lang(?ulabel) = \"\") } }\n  optional { graph ?a { ?t nt:hasTag ?tag . } }\n  filter not exists { graph ?a { ?t a nt:UnlistedTemplate } }\n  optional { graph ?a { ?t dct:isVersionOf ?kind ; gen:governedBy ?space . } }\n  bind(concat(\"|\", coalesce(?winners, \"\"), \"|\") as ?wlist)\n  filter( !bound(?kind)\n    || !contains(?wlist, concat(\"|\", str(?kind), \">\", str(?space), \">\"))\n    || contains(?wlist, concat(\"|\", str(?kind), \">\", str(?space), \">\", str(?date), \">\", str(?np), \"|\")) )\n} group by ?template_iri ?date ?np\norder by desc(?date)"
    }
  }
}
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: 11
      name_id: 21
    }
    o_iri {
      prefix_id: 10
    }
    g_iri {
      prefix_id: 2
      name_id: 7
    }
  }
}
rows {
  name {
    value: "name"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 10
      name_id: 22
    }
    p_iri {
      prefix_id: 12
    }
    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: 5
      name_id: 24
    }
    o_literal {
      lex: "2026-07-09T17:40:51Z"
      datatype: 1
    }
  }
}
rows {
  name {
    value: "creator"
  }
}
rows {
  quad {
    p_iri {
    }
    o_iri {
      prefix_id: 10
      name_id: 22
    }
  }
}
rows {
  prefix {
    value: "https://creativecommons.org/licenses/by/4.0/"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 5
      name_id: 14
    }
    o_iri {
      prefix_id: 16
      name_id: 2
    }
  }
}
rows {
  name {
    value: "embeds"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 7
      name_id: 26
    }
    o_iri {
      prefix_id: 2
      name_id: 12
    }
  }
}
rows {
  name {
    value: "supersedes"
  }
}
rows {
  name {
    value: "RAS7TYM9bUPRh21GQ58dkxDM0Nv3rLGoMkHa29QW3sFCA"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 7
      name_id: 27
    }
    o_iri {
      prefix_id: 1
    }
  }
}
rows {
  name {
    value: "wasCreatedFromProvenanceTemplate"
  }
}
rows {
  name {
    value: "RA7lSq6MuK_TIC6JMSHvLtee3lpLoZDOqLJCLXevnrPoU"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 6
    }
    o_iri {
      prefix_id: 1
    }
  }
}
rows {
  name {
    value: "wasCreatedFromPubinfoTemplate"
  }
}
rows {
  name {
    value: "RA0J4vUn_dekg-U1kK3AOEt02p9mT2WO03uGxLDec1jLw"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 6
    }
    o_iri {
      prefix_id: 1
    }
  }
}
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: 6
    }
    o_iri {
      prefix_id: 1
    }
  }
}
rows {
  name {
    value: "sig"
  }
}
rows {
  name {
    value: "hasAlgorithm"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 2
    }
    p_iri {
      prefix_id: 7
    }
    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: "pk0C5X4uzRwEtg7FfgarsgXQsl/TxjWFdCRAIrlJCovjF/p+w9z7G+vy06sYEBVEozE+7sIrxFk2UTdGVa0tkxSbo7mtPR6K/CtSWjiERIBWUtC112LD43dXTacPPNA4MxzpGYVI/90DdrFOM/pFYcehdbFW9aUFNE04F0kSfKk="
    }
  }
}
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: 7
      name_id: 41
    }
    o_iri {
      prefix_id: 10
      name_id: 22
    }
  }
}