Nanopublications

Matches in Nanopublications for { ?s <https://w3id.org/kpxl/grlc/sparql> ?o ?g. }

Showing items 201 to 300 of ±493 with 100 items per page.

first
previous
next

get-projects sparql "PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX np: <http://www.nanopub.org/nschema#> PREFIX npa: <http://purl.org/nanopub/admin/> PREFIX npx: <http://purl.org/nanopub/x/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX dct: <http://purl.org/dc/terms/> PREFIX prov: <http://www.w3.org/ns/prov#> SELECT ?n1 ?label ?thing ?date where { GRAPH npa:graph { ?n1 npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?np2 npx:invalidates ?n1 ; npa:hasValidSignatureForPublicKey ?pubkey . } ?n1 dct:created ?date . ?n1 np:hasAssertion ?a . } graph ?a { ?thing a <https://w3id.org/fair/ff/terms/Project> . ?thing rdfs:label ?label . filter(contains(lcase(?label), lcase(?_searchterm)) ) } }" assertion.
get-proposals sparql "PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX np: <http://www.nanopub.org/nschema#> PREFIX npa: <http://purl.org/nanopub/admin/> PREFIX npx: <http://purl.org/nanopub/x/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX dct: <http://purl.org/dc/terms/> PREFIX prov: <http://www.w3.org/ns/prov#> SELECT ?n1 ?label ?thing ?date where { GRAPH npa:graph { ?n1 npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?np2 npx:invalidates ?n1 ; npa:hasValidSignatureForPublicKey ?pubkey . } ?n1 dct:created ?date . ?n1 np:hasAssertion ?a . } graph ?a { ?thing a <https://w3id.org/fair/ff/terms/Proposal> . ?thing rdfs:label ?label . filter(contains(lcase(?label), lcase(?_searchterm)) ) } }" assertion.
get-pre-registrations sparql "PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX np: <http://www.nanopub.org/nschema#> PREFIX npa: <http://purl.org/nanopub/admin/> PREFIX npx: <http://purl.org/nanopub/x/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX dct: <http://purl.org/dc/terms/> PREFIX prov: <http://www.w3.org/ns/prov#> SELECT ?n1 ?label ?thing ?date where { GRAPH npa:graph { ?n1 npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?np2 npx:invalidates ?n1 ; npa:hasValidSignatureForPublicKey ?pubkey . } ?n1 dct:created ?date . ?n1 np:hasAssertion ?a . } graph ?a { ?thing a <https://w3id.org/fair/ff/terms/Pre-Registration> . ?thing rdfs:label ?label . filter(contains(lcase(?label), lcase(?_searchterm)) ) } }" assertion.
get-dmps sparql "PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX np: <http://www.nanopub.org/nschema#> PREFIX npa: <http://purl.org/nanopub/admin/> PREFIX npx: <http://purl.org/nanopub/x/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX dct: <http://purl.org/dc/terms/> PREFIX prov: <http://www.w3.org/ns/prov#> SELECT ?n1 ?label ?thing ?date where { GRAPH npa:graph { ?n1 npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?np2 npx:invalidates ?n1 ; npa:hasValidSignatureForPublicKey ?pubkey . } ?n1 dct:created ?date . ?n1 np:hasAssertion ?a . } graph ?a { ?thing a <https://w3id.org/fair/ff/terms/Data-Management-Plan> . ?thing rdfs:label ?label . filter(contains(lcase(?label), lcase(?_searchterm)) ) } }" assertion.
get-datasets sparql "PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX np: <http://www.nanopub.org/nschema#> PREFIX npa: <http://purl.org/nanopub/admin/> PREFIX npx: <http://purl.org/nanopub/x/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX dct: <http://purl.org/dc/terms/> PREFIX prov: <http://www.w3.org/ns/prov#> SELECT ?n1 ?label ?thing ?date where { GRAPH npa:graph { ?n1 npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?np2 npx:invalidates ?n1 ; npa:hasValidSignatureForPublicKey ?pubkey . } ?n1 dct:created ?date . ?n1 np:hasAssertion ?a . } graph ?a { ?thing a <https://w3id.org/fair/ff/terms/Dataset> . ?thing rdfs:label ?label . filter(contains(lcase(?label), lcase(?_searchterm)) ) } }" assertion.
get-research-programmes sparql "PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX np: <http://www.nanopub.org/nschema#> PREFIX npa: <http://purl.org/nanopub/admin/> PREFIX npx: <http://purl.org/nanopub/x/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX dct: <http://purl.org/dc/terms/> PREFIX prov: <http://www.w3.org/ns/prov#> SELECT ?n1 ?label ?thing ?date where { GRAPH npa:graph { ?n1 npx:introduces ?thing . ?n1 npx:hasNanopubType <https://w3id.org/fair/ff/terms/Research-Programme> . ?n1 npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?np2 npx:invalidates ?n1 ; npa:hasValidSignatureForPublicKey ?pubkey . } ?n1 dct:created ?date . ?n1 rdfs:label ?label . filter(contains(lcase(?label), lcase(?_searchterm)) ) } }" assertion.
get-ethical-clearances sparql "PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX np: <http://www.nanopub.org/nschema#> PREFIX npa: <http://purl.org/nanopub/admin/> PREFIX npx: <http://purl.org/nanopub/x/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX dct: <http://purl.org/dc/terms/> PREFIX prov: <http://www.w3.org/ns/prov#> SELECT ?n1 ?label ?thing ?date where { GRAPH npa:graph { ?n1 npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?np2 npx:invalidates ?n1 ; npa:hasValidSignatureForPublicKey ?pubkey . } ?n1 dct:created ?date . ?n1 np:hasAssertion ?a . } graph ?a { ?thing a <https://w3id.org/fair/ff/terms/Ethical-Clearance> . ?thing rdfs:label ?label . filter(contains(lcase(?label), lcase(?_searchterm)) ) } }" assertion.
get-articles sparql "PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX np: <http://www.nanopub.org/nschema#> PREFIX npa: <http://purl.org/nanopub/admin/> PREFIX npx: <http://purl.org/nanopub/x/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX dct: <http://purl.org/dc/terms/> PREFIX prov: <http://www.w3.org/ns/prov#> SELECT ?n1 ?label ?thing ?date where { GRAPH npa:graph { ?n1 npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?np2 npx:invalidates ?n1 ; npa:hasValidSignatureForPublicKey ?pubkey . } ?n1 dct:created ?date . ?n1 np:hasAssertion ?a . } graph ?a { ?thing a <https://w3id.org/fair/ff/terms/Article> . ?thing rdfs:label ?label . filter(contains(lcase(?label), lcase(?_searchterm)) ) } }" assertion.
get-consortium-agreements sparql "PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX np: <http://www.nanopub.org/nschema#> PREFIX npa: <http://purl.org/nanopub/admin/> PREFIX npx: <http://purl.org/nanopub/x/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX dct: <http://purl.org/dc/terms/> PREFIX prov: <http://www.w3.org/ns/prov#> SELECT ?n1 ?label ?thing ?date where { GRAPH npa:graph { ?n1 npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?np2 npx:invalidates ?n1 ; npa:hasValidSignatureForPublicKey ?pubkey . } ?n1 dct:created ?date . ?n1 np:hasAssertion ?a . } graph ?a { ?thing a <https://w3id.org/fair/ff/terms/Consortium-Agreement> . ?thing rdfs:label ?label . filter(contains(lcase(?label), lcase(?_searchterm)) ) } }" assertion.
get-calls-for-proposals sparql "PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX np: <http://www.nanopub.org/nschema#> PREFIX npa: <http://purl.org/nanopub/admin/> PREFIX npx: <http://purl.org/nanopub/x/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX dct: <http://purl.org/dc/terms/> PREFIX prov: <http://www.w3.org/ns/prov#> SELECT ?n1 ?label ?thing ?date where { GRAPH npa:graph { ?n1 npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?np2 npx:invalidates ?n1 ; npa:hasValidSignatureForPublicKey ?pubkey . } ?n1 dct:created ?date . ?n1 np:hasAssertion ?a . } graph ?a { ?thing a <https://w3id.org/fair/ff/terms/Call-For-Proposal> . ?thing rdfs:label ?label . filter(contains(lcase(?label), lcase(?_searchterm)) ) } }" assertion.
get-all-user-intros sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npx: <http://purl.org/nanopub/x/> prefix npa: <http://purl.org/nanopub/admin/> prefix dct: <http://purl.org/dc/terms/> prefix foaf: <http://xmlns.com/foaf/0.1/> select ?user ?name ?intronp ?date ?pubkey ?pubkeyHash ?authoritative ?keyLocation where { graph npa:graph { ?intronp npa:hasValidSignatureForPublicKey ?introPubkey . filter not exists { ?intronpx npx:invalidates ?intronp ; npa:hasValidSignatureForPublicKey ?introPubkey . } ?intronp dct:created ?date . ?intronp np:hasAssertion ?a . } graph ?a { ?keydeclaration npx:declaredBy ?user . ?keydeclaration npx:hasPublicKey ?pubkey . optional { ?user foaf:name ?name . } optional { ?keydeclaration npx:hasKeyLocation ?keyLocation . } } bind(?pubkey = ?introPubkey as ?authoritative) bind(sha256(?pubkey) as ?pubkeyHash) } order by ?user desc(?authoritative) desc(?date)" assertion.
get-assertion-templates sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix nt: <https://w3id.org/np/o/ntemplate/> select ?np ?pubkey ?pubkeyhash ?date ?label ?tag ?unlisted ?creator where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np npa:hasValidSignatureForPublicKeyHash ?pubkeyhash . ?np npx:hasNanopubType nt:AssertionTemplate . ?np dct:created ?date . ?np np:hasAssertion ?a . optional { ?np npx:signedBy ?creator . } } graph ?a { ?a rdfs:label ?label . optional { ?a nt:hasTag ?tag . } bind(exists { ?a a nt:UnlistedTemplate } as ?unlisted) } } order by desc(?date)" assertion.
get-provenance-templates sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix nt: <https://w3id.org/np/o/ntemplate/> select ?np ?pubkey ?pubkeyhash ?date ?label ?creator where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np npa:hasValidSignatureForPublicKeyHash ?pubkeyhash . ?np npx:hasNanopubType nt:ProvenanceTemplate . ?np dct:created ?date . ?np np:hasAssertion ?a . optional { ?np npx:signedBy ?creator . } } graph ?a { ?a rdfs:label ?label . } } order by desc(?date)" assertion.
get-provenance-templates sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix nt: <https://w3id.org/np/o/ntemplate/> select ?np ?pubkey ?pubkeyhash ?date ?label ?creator where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np npa:hasValidSignatureForPublicKeyHash ?pubkeyhash . ?np npx:hasNanopubType nt:ProvenanceTemplate . ?np dct:created ?date . ?np np:hasAssertion ?a . optional { ?np npx:signedBy ?creator . } } graph ?a { ?a rdfs:label ?label . } } order by desc(?date)" assertion.
get-pubinfo-templates sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix nt: <https://w3id.org/np/o/ntemplate/> select ?np ?pubkey ?pubkeyhash ?date ?label ?creator where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np npa:hasValidSignatureForPublicKeyHash ?pubkeyhash . ?np npx:hasNanopubType nt:PubinfoTemplate . ?np dct:created ?date . ?np np:hasAssertion ?a . optional { ?np npx:signedBy ?creator . } } graph ?a { ?a rdfs:label ?label . } } order by desc(?date)" assertion.
get-pubinfo-templates sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix nt: <https://w3id.org/np/o/ntemplate/> select ?np ?pubkey ?pubkeyhash ?date ?label ?creator where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np npa:hasValidSignatureForPublicKeyHash ?pubkeyhash . ?np npx:hasNanopubType nt:PubinfoTemplate . ?np dct:created ?date . ?np np:hasAssertion ?a . optional { ?np npx:signedBy ?creator . } } graph ?a { ?a rdfs:label ?label . } } order by desc(?date)" assertion.
list_nonqualifed_fsr sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix fip: <https://w3id.org/fair/fip/terms/> select distinct ?np ?label (group_concat(distinct ?typelabel; separator = ", ") as ?types) ?date where { service <https://w3id.org/np/l/nanopub-query-1.1/repo/type/16fb6a38f21730f443f6fc7c4a7340a54364973a0b078db497206a13fc5d33f4> { select ?latest_curators_assertion where { graph npa:graph { <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> npa:hasValidSignatureForPublicKey ?curators_np_pk . ?latest_curators_np npa:hasValidSignatureForPublicKey ?curators_np_pk . filter not exists { ?latest_curators_npx npx:invalidates ?latest_curators_np ; npa:hasValidSignatureForPublicKey ?curators_np_pk . } ?latest_curators_np np:hasAssertion ?latest_curators_assertion . } graph npa:networkGraph { ?latest_curators_np (npx:supersedes)* <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> . filter not exists { ?latest_curators_npxx npx:supersedes ?latest_curators_np } } } } values ?service { <https://w3id.org/np/l/nanopub-query-1.1/repo/type/3ef5b11551ebc44e34f4bca614b387204447656ce195314532769ca7b20143fe> <https://w3id.org/np/l/nanopub-query-1.1/repo/type/070fa9a0f87a189bc2eb9d4c1a14f68f11538cc2229b9f4fd6ac026a3d2ce570> } service ?service { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?np npx:hasNanopubType <https://w3id.org/fair/3pff/3PFF-event> . } filter not exists { ?np npx:hasNanopubType fip:FAIR-Implementation-Community . } filter not exists { ?np npx:hasNanopubType fip:FAIR-Implementation-Profile . } filter not exists { ?np npx:hasNanopubType fip:Semantic-Interoperability-Profile . } ?np dct:created ?date . filter(str(?date) > "2022") ?np np:hasAssertion ?a . } graph ?a { #?thing a <https://w3id.org/fair/fip/terms/FAIR-Supporting-Resource> . ?thing a ?type . ?thing rdfs:label ?labelx . } } filter( ?type != <https://w3id.org/fair/fip/terms/FAIR-Supporting-Resource> ) filter( ?type != <https://w3id.org/fair/fip/terms/Available-FAIR-Supporting-Resource> ) filter( ?type != <https://w3id.org/fair/fip/terms/FAIR-Supporting-Resource-to-be-Developed> ) filter( ?type != <https://w3id.org/fair/fip/terms/FAIR-Enabling-Resource> ) filter( ?type != <https://w3id.org/fair/fip/terms/Available-FAIR-Enabling-Resource> ) filter( ?type != <https://w3id.org/fair/fip/terms/FAIR-Enabling-Resource-to-be-Developed> ) bind(replace(str(?type), '^.*/([^/]+)$', '$1') as ?typelabel) bind(str(?labelx) as ?label) optional { select ?np ?disapproval { service <https://w3id.org/np/l/nanopub-query-1.1/repo/type/39692876d0a7881c82e9a2cb6dc8859fb16fa69fb41cea2ace2f8fa70bc52aed> { graph npa:graph { ?disapproval npa:hasValidSignatureForPublicKey ?dpubkey . ?disapproval np:hasAssertion ?da . filter not exists { ?disapprovalx npx:invalidates ?disapproval ; npa:hasValidSignatureForPublicKey ?dpubkey . } } graph ?latest_curators_assertion { ?dpubkeys npx:hasPublicKey ?dpubkey . } graph ?da { ?dsomebody npx:disapprovesOf ?np . } } } } filter(!bound(?disapproval)) optional { select ?np ?qualification { service <https://w3id.org/np/l/nanopub-query-1.1/repo/type/cd51a3ac3e109fd12aacd5a324e14ebff644ce209c916e4250a3f50c2ddf0051> { graph npa:graph { ?qualification npa:hasValidSignatureForPublicKey ?qpubkey . ?qualification np:hasAssertion ?qa . filter not exists { ?qualificationx npx:invalidates ?qualification ; npa:hasValidSignatureForPublicKey ?qpubkey . } } graph ?latest_curators_assertion { ?qpubkeys npx:hasPublicKey ?qpubkey . } graph ?qa { ?qsomebody npx:qualifies ?np . } } } } filter(!bound(?qualification)) } group by ?np ?label ?date order by desc(?date)" assertion.
get-assertion-templates sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix nt: <https://w3id.org/np/o/ntemplate/> select ?np ?pubkey ?pubkeyhash ?date ?label ?tag ?unlisted ?creator where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np npa:hasValidSignatureForPublicKeyHash ?pubkeyhash . ?np npx:hasNanopubType nt:AssertionTemplate . ?np dct:created ?date . ?np np:hasAssertion ?a . optional { ?np npx:signedBy ?creator . } } optional { graph ?a { ?a rdfs:label ?label } } optional { graph ?a { ?a nt:hasTag ?tag . } } graph ?a { bind(exists { ?a a nt:UnlistedTemplate } as ?unlisted) } } order by desc(?date)" assertion.
get-assertion-templates sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix nt: <https://w3id.org/np/o/ntemplate/> select ?np ?pubkey ?pubkeyhash ?date ?label ?tag ?unlisted ?creator where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np npa:hasValidSignatureForPublicKeyHash ?pubkeyhash . ?np npx:hasNanopubType nt:AssertionTemplate . ?np dct:created ?date . ?np np:hasAssertion ?a . optional { ?np npx:signedBy ?creator . } } optional { graph ?a { ?a rdfs:label ?label } } optional { graph ?a { ?a nt:hasTag ?tag . } } bind(exists { graph ?a { ?a a nt:UnlistedTemplate } } as ?unlisted) } order by desc(?date)" assertion.
find-gofair-qualified-things sparql "PREFIX prov: <http://www.w3.org/ns/prov#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix fip: <https://w3id.org/fair/fip/terms/> select distinct ?thing ?label ?description ?np ?date ?pubkey ?retraction ?newversion ?qualifier ?qualification_np (group_concat(distinct ?recommender; separator=" ") as ?recommenders) (group_concat(distinct ?recommendation_np; separator=" ") as ?recommendation_nps) (count(distinct ?recommender) as ?recommender_count) where { graph npa:graph { <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> npa:hasValidSignatureForPublicKey ?curators_np_pk . ?latest_curators_np npa:hasValidSignatureForPublicKey ?curators_np_pk . filter not exists { ?latest_curators_npx npx:invalidates ?latest_curators_np ; npa:hasValidSignatureForPublicKey ?curators_np_pk . } ?latest_curators_np np:hasAssertion ?latest_curators_assertion . } graph npa:networkGraph { ?latest_curators_np (npx:supersedes)* <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> . filter not exists { ?latest_curators_npxx npx:supersedes ?latest_curators_np } } graph npa:graph { ?np npx:hasNanopubType ?__type_iri . ?np npa:hasValidSignatureForPublicKey ?pubkey . optional { ?retraction npx:retracts ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } optional { ?newversion npx:supersedes ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np (npx:introduces|npx:describes) ?thing . ?np rdfs:label ?label . ?np dct:description ?description . ?np dct:created ?date . filter(str(?date) > "2022") } bind(concat(" ",lcase(str(?label))," ",lcase(str(?description))," ") as ?text) filter( contains(?text, lcase(str(?_searchterm))) ) optional { graph npa:graph { ?disapproval npa:hasValidSignatureForPublicKey ?dpubkey . } graph ?latest_curators_assertion { ?dpubkeys npx:hasPublicKey ?dpubkey . } graph npa:graph { filter not exists { ?disapproval_x npx:invalidates ?disapproval ; npa:hasValidSignatureForPublicKey ?dpubkey . } ?disapproval np:hasAssertion ?da . } graph ?da { ?dsomebody ( npx:disapproves-of | npx:disapprovesOf ) ?np . } } filter(!bound(?disapproval)) # Faster than "filter not exists" for some reason optional { graph npa:graph { ?qualification_np npx:hasNanopubType npx:qualifies . ?qualification_np npa:hasValidSignatureForPublicKey ?qpubkey . } graph ?latest_curators_assertion { ?qpubkeys npx:hasPublicKey ?qpubkey . } graph npa:graph { filter not exists { ?qualification_np_x npx:invalidates ?qualification_np ; npa:hasValidSignatureForPublicKey ?qpubkey . } ?qualification_np np:hasAssertion ?qa . } graph ?qa { ?qualifier npx:qualifies ?np . } } optional { graph npa:graph { ?recommendation_np npx:hasNanopubType fip:recommended-by . ?recommendation_np npa:hasValidSignatureForPublicKey ?rpubkey . filter not exists { ?recommendation_np_x npx:invalidates ?recommendation_np ; npa:hasValidSignatureForPublicKey ?rpubkey . } ?recommendation_np np:hasAssertion ?ra . ?recommendation_np np:hasProvenance ?rp . } graph ?ra { ?thing fip:recommended-by ?recommender . } graph ?rp { ?ra fip:wasDerivedFrom ?rfip_np . } graph npa:graph { ?rfip_np npx:hasNanopubType fip:Reference-FAIR-Implementation-Profile . ?rfip_np npa:hasValidSignatureForPublicKey ?rfip_pubkey . filter not exists { ?rfip_np_x npx:invalidates ?rfip_np ; npa:hasValidSignatureForPublicKey ?rfip_pubkey . } } graph npa:graph { ?rfip_qualification_np npx:hasNanopubType npx:qualifies . ?rfip_qualification_np npa:hasValidSignatureForPublicKey ?rfip_qpubkey . } graph ?latest_curators_assertion { ?rfip_qpubkeys npx:hasPublicKey ?rfip_qpubkey . } graph npa:graph { filter not exists { ?rfip_qualification_np_x npx:invalidates ?rfip_qualification_np ; npa:hasValidSignatureForPublicKey ?rfip_qpubkey . } ?rfip_qualification_np np:hasAssertion ?rfip_qa . } graph ?qa { ?rfip_qualifier npx:qualifies ?rfip_np . } } } group by ?thing ?label ?description ?np ?date ?pubkey ?retraction ?newversion ?qualifier ?qualification_np order by desc(?recommender_count) asc(?label)" assertion.
find-gofair-qualified-things sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix fip: <https://w3id.org/fair/fip/terms/> prefix prov: <http://www.w3.org/ns/prov#> select distinct ?thing ?label ?description ?np ?date ?pubkey ?retraction ?newversion ?qualifier ?qualification_np (group_concat(distinct ?recommender; separator=" ") as ?recommenders) (group_concat(distinct ?recommendation_np; separator=" ") as ?recommendation_nps) (count(distinct ?recommender) as ?recommender_count) where { graph npa:graph { <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> npa:hasValidSignatureForPublicKey ?curators_np_pk . ?latest_curators_np npa:hasValidSignatureForPublicKey ?curators_np_pk . filter not exists { ?latest_curators_npx npx:invalidates ?latest_curators_np ; npa:hasValidSignatureForPublicKey ?curators_np_pk . } ?latest_curators_np np:hasAssertion ?latest_curators_assertion . } graph npa:networkGraph { ?latest_curators_np (npx:supersedes)* <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> . filter not exists { ?latest_curators_npxx npx:supersedes ?latest_curators_np } } graph npa:graph { ?np npx:hasNanopubType ?__type_iri . ?np npa:hasValidSignatureForPublicKey ?pubkey . optional { ?retraction npx:retracts ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } optional { ?newversion npx:supersedes ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np (npx:introduces|npx:describes) ?thing . ?np rdfs:label ?label . ?np dct:description ?description . ?np dct:created ?date . filter(str(?date) > "2022") } bind(concat(" ",lcase(str(?label))," ",lcase(str(?description))," ") as ?text) filter( contains(?text, lcase(str(?_searchterm))) ) optional { graph npa:graph { ?disapproval npa:hasValidSignatureForPublicKey ?dpubkey . } graph ?latest_curators_assertion { ?dpubkeys npx:hasPublicKey ?dpubkey . } graph npa:graph { filter not exists { ?disapproval_x npx:invalidates ?disapproval ; npa:hasValidSignatureForPublicKey ?dpubkey . } ?disapproval np:hasAssertion ?da . } graph ?da { ?dsomebody ( npx:disapproves-of | npx:disapprovesOf ) ?np . } } filter(!bound(?disapproval)) # Faster than "filter not exists" for some reason optional { graph npa:graph { ?qualification_np npx:hasNanopubType npx:qualifies . ?qualification_np npa:hasValidSignatureForPublicKey ?qpubkey . } graph ?latest_curators_assertion { ?qpubkeys npx:hasPublicKey ?qpubkey . } graph npa:graph { filter not exists { ?qualification_np_x npx:invalidates ?qualification_np ; npa:hasValidSignatureForPublicKey ?qpubkey . } ?qualification_np np:hasAssertion ?qa . } graph ?qa { ?qualifier npx:qualifies ?np . } } optional { graph npa:graph { ?recommendation_np npx:hasNanopubType fip:recommended-by . ?recommendation_np npa:hasValidSignatureForPublicKey ?rpubkey . filter not exists { ?recommendation_np_x npx:invalidates ?recommendation_np ; npa:hasValidSignatureForPublicKey ?rpubkey . } ?recommendation_np np:hasAssertion ?ra . ?recommendation_np np:hasProvenance ?rp . } graph ?ra { ?thing fip:recommended-by ?recommender . } graph ?rp { ?ra prov:wasDerivedFrom ?rfip_np . } graph npa:graph { ?rfip_np npx:hasNanopubType fip:Reference-FAIR-Implementation-Profile . ?rfip_np npa:hasValidSignatureForPublicKey ?rfip_pubkey . filter not exists { ?rfip_np_x npx:invalidates ?rfip_np ; npa:hasValidSignatureForPublicKey ?rfip_pubkey . } } graph npa:graph { ?rfip_qualification_np npx:hasNanopubType npx:qualifies . ?rfip_qualification_np npa:hasValidSignatureForPublicKey ?rfip_qpubkey . } graph ?latest_curators_assertion { ?rfip_qpubkeys npx:hasPublicKey ?rfip_qpubkey . } graph npa:graph { filter not exists { ?rfip_qualification_np_x npx:invalidates ?rfip_qualification_np ; npa:hasValidSignatureForPublicKey ?rfip_qpubkey . } ?rfip_qualification_np np:hasAssertion ?rfip_qa . } graph ?qa { ?rfip_qualifier npx:qualifies ?rfip_np . } } } group by ?thing ?label ?description ?np ?date ?pubkey ?retraction ?newversion ?qualifier ?qualification_np order by desc(?recommender_count) asc(?label)" assertion.
find-gofair-qualified-things sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix fip: <https://w3id.org/fair/fip/terms/> prefix prov: <http://www.w3.org/ns/prov#> select distinct ?thing ?label ?description ?np ?date ?pubkey ?retraction ?newversion ?qualifier ?qualification_np (group_concat(distinct ?recommender; separator=" ") as ?recommenders) (group_concat(distinct ?recommendation_np; separator=" ") as ?recommendation_nps) (count(distinct ?recommender) as ?recommender_count) where { graph npa:graph { <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> npa:hasValidSignatureForPublicKey ?curators_np_pk . ?latest_curators_np npa:hasValidSignatureForPublicKey ?curators_np_pk . filter not exists { ?latest_curators_npx npx:invalidates ?latest_curators_np ; npa:hasValidSignatureForPublicKey ?curators_np_pk . } ?latest_curators_np np:hasAssertion ?latest_curators_assertion . } graph npa:networkGraph { ?latest_curators_np (npx:supersedes)* <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> . filter not exists { ?latest_curators_npxx npx:supersedes ?latest_curators_np } } graph npa:graph { ?np npx:hasNanopubType ?__type_iri . ?np npa:hasValidSignatureForPublicKey ?pubkey . optional { ?retraction npx:retracts ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } optional { ?newversion npx:supersedes ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np (npx:introduces|npx:describes) ?thing . ?np rdfs:label ?label . ?np dct:description ?description . ?np dct:created ?date . filter(str(?date) > "2022") } bind(concat(" ",lcase(str(?label))," ",lcase(str(?description))," ") as ?text) filter( contains(?text, lcase(str(?_searchterm))) ) optional { graph npa:graph { ?disapproval npa:hasValidSignatureForPublicKey ?dpubkey . } graph ?latest_curators_assertion { ?dpubkeys npx:hasPublicKey ?dpubkey . } graph npa:graph { filter not exists { ?disapproval_x npx:invalidates ?disapproval ; npa:hasValidSignatureForPublicKey ?dpubkey . } ?disapproval np:hasAssertion ?da . } graph ?da { ?dsomebody ( npx:disapproves-of | npx:disapprovesOf ) ?np . } } filter(!bound(?disapproval)) # Faster than "filter not exists" for some reason optional { optional { graph npa:graph { ?recommendation_np npx:hasNanopubType fip:recommended-by . ?recommendation_np npa:hasValidSignatureForPublicKey ?rpubkey . filter not exists { ?recommendation_np_x npx:invalidates ?recommendation_np ; npa:hasValidSignatureForPublicKey ?rpubkey . } ?recommendation_np np:hasAssertion ?ra . ?recommendation_np np:hasProvenance ?rp . } graph ?ra { ?thing fip:recommended-by ?recommender . } graph ?rp { ?ra prov:wasDerivedFrom ?rfip_np . } graph npa:graph { ?rfip_np npx:hasNanopubType fip:Reference-FAIR-Implementation-Profile . ?rfip_np npa:hasValidSignatureForPublicKey ?rfip_pubkey . ?latest_rfip_np npa:hasValidSignatureForPublicKey ?rfip_pubkey . filter not exists { ?latest_rfip_npx npx:invalidates ?latest_rfip_np ; npa:hasValidSignatureForPublicKey ?rfip_pubkey . } } graph npa:networkGraph { ?latest_rfip_np (npx:supersedes)* ?rfip_np . } graph ?rfip_qa { ?rfip_qualifier npx:qualifies ?latest_rfip_np . } graph npa:graph { ?rfip_qualification_np np:hasAssertion ?rfip_qa . ?rfip_qualification_np npx:hasNanopubType npx:qualifies . ?rfip_qualification_np npa:hasValidSignatureForPublicKey ?rfip_qpubkey . filter not exists { ?rfip_qualification_np_x npx:invalidates ?rfip_qualification_np ; npa:hasValidSignatureForPublicKey ?rfip_qpubkey . } } graph ?latest_curators_assertion { ?rfip_qpubkeys npx:hasPublicKey ?rfip_qpubkey . } } graph npa:graph { ?qualification_np npx:hasNanopubType npx:qualifies . ?qualification_np npa:hasValidSignatureForPublicKey ?qpubkey . } graph ?latest_curators_assertion { ?qpubkeys npx:hasPublicKey ?qpubkey . } graph npa:graph { filter not exists { ?qualification_np_x npx:invalidates ?qualification_np ; npa:hasValidSignatureForPublicKey ?qpubkey . } ?qualification_np np:hasAssertion ?qa . } graph ?qa { ?qualifier npx:qualifies ?np . } } } group by ?thing ?label ?description ?np ?date ?pubkey ?retraction ?newversion ?qualifier ?qualification_np order by desc(?recommender_count) asc(?label)" assertion.
fer_search sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix fip: <https://w3id.org/fair/fip/terms/> prefix search: <http://www.openrdf.org/contrib/lucenesail#> select distinct ?np ?thing ?description ?label ?date ?types ?qualifier (group_concat(distinct ?community; separator=" ") as ?communities) ?maxscore where { { select ?np ?thing ?label ?date (group_concat(distinct ?type; separator=" ") as ?types) (max(?score) as ?maxscore) ?latest_curators_assertion where { graph npa:graph { <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> npa:hasValidSignatureForPublicKey ?curators_np_pk . ?latest_curators_np npa:hasValidSignatureForPublicKey ?curators_np_pk . filter not exists { ?latest_curators_npx npx:invalidates ?latest_curators_np ; npa:hasValidSignatureForPublicKey ?curators_np_pk . } ?latest_curators_np np:hasAssertion ?latest_curators_assertion . } graph npa:networkGraph { ?latest_curators_np (npx:supersedes)* <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> . filter not exists { ?latest_curators_npxx npx:supersedes ?latest_curators_np } } graph npa:graph { ?np rdfs:label ?label ; npa:hasValidSignatureForPublicKey ?pubkey ; dct:created ?date . ?np npx:introduces|npx:describes ?thing . filter(str(?date) > "2022") filter exists { ?np npx:hasNanopubType ?fsr_type . values ?fsr_type { fip:FAIR-Enabling-Resource fip:FAIR-Supporting-Resource fip:Available-FAIR-Enabling-Resource } } filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } ?np npx:hasNanopubType ?__type_iri . ?np npx:hasNanopubType ?type . filter(?type != fip:FAIR-Enabling-Resource) filter(?type != fip:Available-FAIR-Enabling-Resource) filter(?type != fip:FAIR-Enabling-Resource-to-be-Developed) filter(?type != fip:FAIR-Supporting-Resource) filter(?type != fip:Available-FAIR-Supporting-Resource) filter(?type != fip:FAIR-Supporting-Resource-to-be-Developed) filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } ?np search:matches [ search:query ?_query ; search:property rdfs:label ; search:score ?score ; search:snippet ?snippet ] . bind(iri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256("http://purl.org/nanopub/x/disapprovesOf"))) as ?disappr_service) filter not exists { service ?disappr_service { graph npa:graph { ?disapproval_np np:hasAssertion ?da ; npa:hasValidSignatureForPublicKey ?dpubkey . filter not exists { ?disapproval_npx npx:invalidates ?disapproval_np ; npa:hasValidSignatureForPublicKey ?dpubkey . } } graph ?latest_curators_assertion { ?qpubkeys npx:hasPublicKey ?dpubkey . } graph ?da { ?disapprover npx:disapprovesOf ?np . } } } } group by ?np ?thing ?label ?date ?latest_curators_assertion order by desc(?maxscore) limit 20 } optional { service <https://w3id.org/np/l/nanopub-query-1.1/repo/full> { graph npa:graph { ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?i . } graph ?a { ?thing rdfs:comment ?description . } } } bind(iri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256("http://purl.org/nanopub/x/qualifies"))) as ?qualifies_service) optional { service ?qualifies_service { graph npa:graph { ?qualification_np np:hasAssertion ?qa ; npa:hasValidSignatureForPublicKey ?qpubkey . filter not exists { ?qualification_npx npx:invalidates ?qualification_np ; npa:hasValidSignatureForPublicKey ?qpubkey . } } graph ?latest_curators_assertion { ?qpubkeys npx:hasPublicKey ?qpubkey . } graph ?qa { ?qualifier npx:qualifies ?np . } } } bind(iri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256("https://w3id.org/fair/fip/terms/FIP-Declaration"))) as ?fip_service) optional { service ?fip_service { graph npa:graph { ?decl_np np:hasAssertion ?decl_a ; npa:hasValidSignatureForPublicKey ?decl_pubkey . filter not exists { ?decl_npx npx:invalidates ?decl_np ; npa:hasValidSignatureForPublicKey ?decl_pubkey . } } graph ?decl_a { ?decl a fip:FIP-Declaration . # ---- # not really needed but seems to make query faster: values ?use { fip:declares-current-use-of fip:declares-planned-use-of fip:declares-planned-development-of fip:declares-planned-replacement-of } ?decl ?use ?thing . # ---- ?decl fip:declared-by ?community . } } } } group by ?np ?thing ?description ?label ?date ?types ?qualifier ?maxscore order by desc(?maxscore)" assertion.
get-fer-types sparql "#+ summary: Get types of FAIR-Enabling Resources #+ endpoint: https://query.np.trustyuri.net/repo/empty #+ method: GET prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix fip: <https://w3id.org/fair/fip/terms/> select ?type (count(distinct ?np) as ?count) where { { bind(iri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(fip:FAIR-Enabling-Resource)))) as ?fer_service) service ?fer_service { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey ; npx:hasNanopubType fip:FAIR-Enabling-Resource . ?np dct:created ?date . filter(str(?date) > "2022") filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np npx:hasNanopubType ?type . filter(?type != fip:FAIR-Enabling-Resource) filter(?type != fip:Available-FAIR-Enabling-Resource) filter(?type != fip:FAIR-Enabling-Resource-to-be-Developed) filter(?type != fip:FAIR-Supporting-Resource) filter(?type != fip:Available-FAIR-Supporting-Resource) filter(?type != fip:FAIR-Supporting-Resource-to-be-Developed) filter(strstarts(str(?type), str(fip:))) } } } union { bind(iri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(fip:FAIR-Supporting-Resource)))) as ?fer_service) service ?fer_service { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey ; npx:hasNanopubType fip:FAIR-Supporting-Resource . ?np dct:created ?date . filter(str(?date) > "2022") filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np npx:hasNanopubType ?type . filter(?type != fip:FAIR-Enabling-Resource) filter(?type != fip:Available-FAIR-Enabling-Resource) filter(?type != fip:FAIR-Enabling-Resource-to-be-Developed) filter(?type != fip:FAIR-Supporting-Resource) filter(?type != fip:Available-FAIR-Supporting-Resource) filter(?type != fip:FAIR-Supporting-Resource-to-be-Developed) filter(strstarts(str(?type), str(fip:))) } } } } group by ?type order by desc(?count)" assertion.
get-fer-types sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix fip: <https://w3id.org/fair/fip/terms/> select ?type (count(distinct ?np) as ?count) where { { bind(iri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(fip:FAIR-Enabling-Resource)))) as ?fer_service) service ?fer_service { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey ; npx:hasNanopubType fip:FAIR-Enabling-Resource . ?np dct:created ?date . filter(str(?date) > "2022") filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np npx:hasNanopubType ?type . values ?type { fip:Authentication-and-authorization-service fip:Editor fip:FAIR-Representation-Service fip:FAIR-Supporting-Software fip:Identifier-service fip:Provenance-Tracking-Service fip:Registry fip:Validation-Service fip:Web-API fip:FAIR-Specification fip:Communication-protocol fip:Crosswalk fip:FAIR-Implementation-Profile fip:Knowledge-representation-language fip:Metadata-schema fip:Metadata-data-linking-schema fip:Provenance-model fip:Semantic-model fip:Structured-vocabulary fip:FAIR-Data-Policy fip:Data-usage-license fip:Metadata-preservation-policy fip:Persistency-Policy fip:FAIR-Practice } } } } union { bind(iri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(fip:FAIR-Supporting-Resource)))) as ?fer_service) service ?fer_service { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey ; npx:hasNanopubType fip:FAIR-Supporting-Resource . ?np dct:created ?date . filter(str(?date) > "2022") filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np npx:hasNanopubType ?type . values ?type { fip:Authentication-and-authorization-service fip:Editor fip:FAIR-Representation-Service fip:FAIR-Supporting-Software fip:Identifier-service fip:Provenance-Tracking-Service fip:Registry fip:Validation-Service fip:Web-API fip:FAIR-Specification fip:Communication-protocol fip:Crosswalk fip:FAIR-Implementation-Profile fip:Knowledge-representation-language fip:Metadata-schema fip:Metadata-data-linking-schema fip:Provenance-model fip:Semantic-model fip:Structured-vocabulary fip:FAIR-Data-Policy fip:Data-usage-license fip:Metadata-preservation-policy fip:Persistency-Policy fip:FAIR-Practice } } } } } group by ?type order by desc(?count)" assertion.
fers_by_type sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix fip: <https://w3id.org/fair/fip/terms/> prefix search: <http://www.openrdf.org/contrib/lucenesail#> select distinct ?np ?thing ?description ?label ?date ?types ?qualifier (group_concat(distinct ?community; separator=" ") as ?communities) ?maxscore where { { select ?latest_curators_assertion where { graph npa:graph { <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> npa:hasValidSignatureForPublicKey ?curators_np_pk . ?latest_curators_np npa:hasValidSignatureForPublicKey ?curators_np_pk . filter not exists { ?latest_curators_npx npx:invalidates ?latest_curators_np ; npa:hasValidSignatureForPublicKey ?curators_np_pk . } ?latest_curators_np np:hasAssertion ?latest_curators_assertion . } graph npa:networkGraph { ?latest_curators_np (npx:supersedes)* <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> . filter not exists { ?latest_curators_npxx npx:supersedes ?latest_curators_np } } } } { select ?np ?thing ?label ?description ?date (group_concat(distinct ?type; separator=" ") as ?types) where { graph npa:graph { ?np rdfs:label ?label ; dct:description ?description ; npa:hasValidSignatureForPublicKey ?pubkey ; dct:created ?date . ?np npx:introduces|npx:describes ?thing . filter(str(?date) > "2022") filter exists { ?np npx:hasNanopubType ?fsr_type . values ?fsr_type { fip:FAIR-Enabling-Resource fip:FAIR-Supporting-Resource } } filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } ?np npx:hasNanopubType ?_type_iri . ?np npx:hasNanopubType ?type . values ?type { fip:Authentication-and-authorization-service fip:Editor fip:FAIR-Representation-Service fip:FAIR-Supporting-Software fip:Identifier-service fip:Provenance-Tracking-Service fip:Registry fip:Validation-Service fip:Web-API fip:FAIR-Specification fip:Communication-protocol fip:Crosswalk fip:FAIR-Implementation-Profile fip:Knowledge-representation-language fip:Metadata-schema fip:Metadata-data-linking-schema fip:Provenance-model fip:Semantic-model fip:Structured-vocabulary fip:FAIR-Data-Policy fip:Data-usage-license fip:Metadata-preservation-policy fip:Persistency-Policy fip:FAIR-Practice } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } filter not exists { graph ?da { ?disapprover npx:disapprovesOf ?np . } graph npa:graph { ?disapproval_np np:hasAssertion ?da ; npa:hasValidSignatureForPublicKey ?dpubkey . filter not exists { ?disapproval_npx npx:invalidates ?disapproval_np ; npa:hasValidSignatureForPublicKey ?dpubkey . } } graph ?latest_curators_assertion { ?qpubkeys npx:hasPublicKey ?dpubkey . } } } group by ?np ?thing ?label ?description ?date } optional { graph ?qa { ?qualifier npx:qualifies ?np . } graph npa:graph { ?qualification_np np:hasAssertion ?qa ; npa:hasValidSignatureForPublicKey ?qpubkey . filter not exists { ?qualification_npx npx:invalidates ?qualification_np ; npa:hasValidSignatureForPublicKey ?qpubkey . } } graph ?latest_curators_assertion { ?qpubkeys npx:hasPublicKey ?qpubkey . } } optional { graph npa:graph { ?decl_np npx:hasNanopubType fip:FIP-Declaration . ?decl_np np:hasAssertion ?decl_a ; npa:hasValidSignatureForPublicKey ?decl_pubkey . filter not exists { ?decl_npx npx:invalidates ?decl_np ; npa:hasValidSignatureForPublicKey ?decl_pubkey . } } graph ?decl_a { ?decl a fip:FIP-Declaration . # ---- # not really needed but seems to make query faster: values ?use { fip:declares-current-use-of fip:declares-planned-use-of fip:declares-planned-development-of fip:declares-planned-replacement-of } ?decl ?use ?thing . # ---- ?decl fip:declared-by ?community . } } } group by ?np ?thing ?description ?label ?date ?types ?qualifier ?maxscore order by desc(?maxscore)" assertion.
fers_by_type sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix fip: <https://w3id.org/fair/fip/terms/> prefix search: <http://www.openrdf.org/contrib/lucenesail#> select distinct ?np ?thing ?description ?label ?date ?types ?qualifier (group_concat(distinct ?community; separator=" ") as ?communities) ?maxscore where { { select ?latest_curators_assertion where { graph npa:graph { <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> npa:hasValidSignatureForPublicKey ?curators_np_pk . ?latest_curators_np npa:hasValidSignatureForPublicKey ?curators_np_pk . filter not exists { ?latest_curators_npx npx:invalidates ?latest_curators_np ; npa:hasValidSignatureForPublicKey ?curators_np_pk . } ?latest_curators_np np:hasAssertion ?latest_curators_assertion . } graph npa:networkGraph { ?latest_curators_np (npx:supersedes)* <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> . filter not exists { ?latest_curators_npxx npx:supersedes ?latest_curators_np } } } } { select ?np ?thing ?label ?description ?date (group_concat(distinct ?type; separator=" ") as ?types) where { graph npa:graph { ?np rdfs:label ?label ; dct:description ?description ; npa:hasValidSignatureForPublicKey ?pubkey ; dct:created ?date . ?np npx:introduces|npx:describes ?thing . filter(str(?date) > "2022") filter exists { ?np npx:hasNanopubType ?fsr_type . values ?fsr_type { fip:FAIR-Enabling-Resource fip:FAIR-Supporting-Resource } } filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } ?np npx:hasNanopubType ?_type_iri . ?np npx:hasNanopubType ?type . values ?type { fip:Authentication-and-authorization-service fip:Editor fip:FAIR-Representation-Service fip:FAIR-Supporting-Software fip:Identifier-service fip:Provenance-Tracking-Service fip:Registry fip:Validation-Service fip:Web-API fip:Communication-protocol fip:Crosswalk fip:FAIR-Implementation-Profile fip:Knowledge-representation-language fip:Metadata-schema fip:Metadata-data-linking-schema fip:Provenance-model fip:Semantic-model fip:Structured-vocabulary fip:FAIR-Data-Policy fip:Data-usage-license fip:Metadata-preservation-policy fip:Persistency-Policy fip:FAIR-Practice } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } filter not exists { graph ?da { ?disapprover npx:disapprovesOf ?np . } graph npa:graph { ?disapproval_np np:hasAssertion ?da ; npa:hasValidSignatureForPublicKey ?dpubkey . filter not exists { ?disapproval_npx npx:invalidates ?disapproval_np ; npa:hasValidSignatureForPublicKey ?dpubkey . } } graph ?latest_curators_assertion { ?qpubkeys npx:hasPublicKey ?dpubkey . } } } group by ?np ?thing ?label ?description ?date } optional { graph ?qa { ?qualifier npx:qualifies ?np . } graph npa:graph { ?qualification_np np:hasAssertion ?qa ; npa:hasValidSignatureForPublicKey ?qpubkey . filter not exists { ?qualification_npx npx:invalidates ?qualification_np ; npa:hasValidSignatureForPublicKey ?qpubkey . } } graph ?latest_curators_assertion { ?qpubkeys npx:hasPublicKey ?qpubkey . } } optional { graph npa:graph { ?decl_np npx:hasNanopubType fip:FIP-Declaration . ?decl_np np:hasAssertion ?decl_a ; npa:hasValidSignatureForPublicKey ?decl_pubkey . filter not exists { ?decl_npx npx:invalidates ?decl_np ; npa:hasValidSignatureForPublicKey ?decl_pubkey . } } graph ?decl_a { ?decl a fip:FIP-Declaration . # ---- # not really needed but seems to make query faster: values ?use { fip:declares-current-use-of fip:declares-planned-use-of fip:declares-planned-development-of fip:declares-planned-replacement-of } ?decl ?use ?thing . # ---- ?decl fip:declared-by ?community . } } } group by ?np ?thing ?description ?label ?date ?types ?qualifier ?maxscore order by desc(?maxscore)" assertion.
get-fer-types sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix fip: <https://w3id.org/fair/fip/terms/> select ?type (count(distinct ?np) as ?count) where { { bind(iri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(fip:FAIR-Enabling-Resource)))) as ?fer_service) service ?fer_service { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey ; npx:hasNanopubType fip:FAIR-Enabling-Resource . ?np dct:created ?date . filter(str(?date) > "2022") filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np npx:hasNanopubType ?type . values ?type { fip:Authentication-and-authorization-service fip:Editor fip:FAIR-Representation-Service fip:FAIR-Supporting-Software fip:Identifier-service fip:Provenance-Tracking-Service fip:Registry fip:Validation-Service fip:Web-API fip:Communication-protocol fip:Crosswalk fip:FAIR-Implementation-Profile fip:Knowledge-representation-language fip:Metadata-schema fip:Metadata-data-linking-schema fip:Provenance-model fip:Semantic-model fip:Structured-vocabulary fip:FAIR-Data-Policy fip:Data-usage-license fip:Metadata-preservation-policy fip:Persistency-Policy fip:FAIR-Practice } } } } union { bind(iri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(fip:FAIR-Supporting-Resource)))) as ?fer_service) service ?fer_service { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey ; npx:hasNanopubType fip:FAIR-Supporting-Resource . ?np dct:created ?date . filter(str(?date) > "2022") filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np npx:hasNanopubType ?type . values ?type { fip:Authentication-and-authorization-service fip:Editor fip:FAIR-Representation-Service fip:FAIR-Supporting-Software fip:Identifier-service fip:Provenance-Tracking-Service fip:Registry fip:Validation-Service fip:Web-API fip:Communication-protocol fip:Crosswalk fip:FAIR-Implementation-Profile fip:Knowledge-representation-language fip:Metadata-schema fip:Metadata-data-linking-schema fip:Provenance-model fip:Semantic-model fip:Structured-vocabulary fip:FAIR-Data-Policy fip:Data-usage-license fip:Metadata-preservation-policy fip:Persistency-Policy fip:FAIR-Practice } } } } } group by ?type order by desc(?count)" assertion.
get-projects sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select ?project ?label ?np ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?project . filter(strstarts(str(?project), "https://w3id.org/kpxl/custom/project/terms/")) ?np npx:hasNanopubType <https://w3id.org/kpxl/gen/terms/NanodashProject> . ?np rdfs:label ?label . ?np np:hasAssertion ?a . filter not exists { ?npx npx:introduces ?project . ?npx dct:created ?datex . filter(?datex > ?date) } } } order by ?label" assertion.
get-type-overview-last-12-months sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> select ?type ?month ?npCount ?npCountType where { { select ?type ?month (count(?np) as ?npCount) where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . ?np dct:creator ?_creator_iri . ?np npx:hasNanopubType ?type . bind(substr(str(?date), 0, 8) as ?month) bind(now() as ?now) bind(concat(str(year(?now)), '-', if(month(?now)>9,'','0'), str(month(?now))) as ?lastMonth) bind(concat(str(year(?now)-1), '-', if(month(?now)>9,'','0'), str(month(?now))) as ?firstMonth) filter(?month > ?firstMonth && ?month <= ?lastMonth) } } group by ?type ?month order by ?type desc(?month) } { select ?type (count(?np) as ?npCountType) where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . ?np dct:creator ?_creator_iri . ?np npx:hasNanopubType ?type . bind(substr(str(?date), 0, 8) as ?month) bind(now() as ?now) bind(concat(str(year(?now)), '-', if(month(?now)>9,'','0'), str(month(?now))) as ?lastMonth) bind(concat(str(year(?now)-1), '-', if(month(?now)>9,'','0'), str(month(?now))) as ?firstMonth) filter(?month > ?firstMonth && ?month <= ?lastMonth) } } group by ?type order by desc(?npCountType) } } order by desc(?npCountType) ?type desc(?month)" assertion.
get-filtered-nanopub-list sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select ?np ?label ?date (group_concat(?t; separator=' ') as ?types) ?pubkey where { graph npa:graph { #=================== MULTI-VALUE PLACEHOLDER ====================#------ config: ------ { select ?pubkey { # <- VAR pubkey #bind("1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 2a6683923dcbd9810ef4e5debda8c4152c297b12303e286622bbbb0ed1884384" as ?_pubkeys) bind(?_pubkeys as ?v) # <- VAR _pubkeys {select*{optional{?a ?b ?c}}limit 1} # (for some Virtuoso v.) # values ?x{0 1 2 3 4 5 6 7 8 9} values ?y{0 1 2 3 4 5 6 7 8 9} # bind((10*?x)+?y as ?n) # (works for a maximum of 100 values) # bind(" " as ?sep) # (separator as regex-compatible character) # <- CONST sep bind(concat("^([^",?sep,"]*",?sep,"){",str(?n),"}") as ?p) # bind(concat(?sep,".*") as ?p0) # filter(if(?n=0,true,regex(?v,?p))) # (=0 check for Virtuoso) # bind(replace(if(?n=0,?v,replace(?v,?p,"")),?p0,"") as ?pubkey) # <- VAR pubkey } } # #================================================================#--------------------- ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } #=================== MULTI-VALUE PLACEHOLDER ====================#------ config: ------ { select ?type { # <- VAR type #bind("https://w3id.org/kpxl/grlc/grlc-query http://purl.org/nanopub/x/ExampleNanopub" as ?_types) bind(?_types as ?v) # <- VAR _types {select*{optional{?a ?b ?c}}limit 1} # (for some Virtuoso v.) # values ?x{0 1 2 3 4 5 6 7 8 9} values ?y{0 1 2 3 4 5 6 7 8 9} # bind((10*?x)+?y as ?n) # (works for a maximum of 100 values) # bind(" " as ?sep) # (separator as regex-compatible character) # <- CONST sep bind(concat("^([^",?sep,"]*",?sep,"){",str(?n),"}") as ?p) # bind(concat(?sep,".*") as ?p0) # filter(if(?n=0,true,regex(?v,?p))) # (=0 check for Virtuoso) # bind(replace(if(?n=0,?v,replace(?v,?p,"")),?p0,"") as ?typel) # <- VAR type bind(uri(?typel) as ?type) } } # #================================================================#--------------------- ?np npx:hasNanopubType ?type . ?np npx:hasNanopubType ?t . optional { ?np dct:created ?date } optional { ?np rdfs:label ?label } } } group by ?np ?label ?date ?pubkey order by desc(?date) limit 100" assertion.
get-filtered-nanopub-list sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select ?np ?label ?date (group_concat(?t; separator=' ') as ?types) ?pubkey where { graph npa:graph { #=================== MULTI-VALUE PLACEHOLDER ====================#------ config: ------ { select ?pubkey { # <- VAR pubkey #bind("1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 2a6683923dcbd9810ef4e5debda8c4152c297b12303e286622bbbb0ed1884384" as ?_pubkeys) bind(?__pubkeys as ?v) # <- VAR _pubkeys {select*{optional{?a ?b ?c}}limit 1} # (for some Virtuoso v.) # values ?x{0 1 2 3 4 5 6 7 8 9} values ?y{0 1 2 3 4 5 6 7 8 9} # bind((10*?x)+?y as ?n) # (works for a maximum of 100 values) # bind(" " as ?sep) # (separator as regex-compatible character) # <- CONST sep bind(concat("^([^",?sep,"]*",?sep,"){",str(?n),"}") as ?p) # bind(concat(?sep,".*") as ?p0) # filter(if(?n=0,true,regex(?v,?p))) # (=0 check for Virtuoso) # bind(replace(if(?n=0,?v,replace(?v,?p,"")),?p0,"") as ?pubkey) # <- VAR pubkey } } # #================================================================#--------------------- ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } #=================== MULTI-VALUE PLACEHOLDER ====================#------ config: ------ { select ?type { # <- VAR type #bind("https://w3id.org/kpxl/grlc/grlc-query http://purl.org/nanopub/x/ExampleNanopub" as ?_types) bind(?__types as ?v) # <- VAR _types {select*{optional{?a ?b ?c}}limit 1} # (for some Virtuoso v.) # values ?x{0 1 2 3 4 5 6 7 8 9} values ?y{0 1 2 3 4 5 6 7 8 9} # bind((10*?x)+?y as ?n) # (works for a maximum of 100 values) # bind(" " as ?sep) # (separator as regex-compatible character) # <- CONST sep bind(concat("^([^",?sep,"]*",?sep,"){",str(?n),"}") as ?p) # bind(concat(?sep,".*") as ?p0) # filter(if(?n=0,true,regex(?v,?p))) # (=0 check for Virtuoso) # bind(replace(if(?n=0,?v,replace(?v,?p,"")),?p0,"") as ?typel) # <- VAR type bind(uri(?typel) as ?type) } } # #================================================================#--------------------- ?np npx:hasNanopubType ?type . ?np npx:hasNanopubType ?t . optional { ?np dct:created ?date } optional { ?np rdfs:label ?label } } } group by ?np ?label ?date ?pubkey order by desc(?date) limit 100" assertion.
get-filtered-nanopub-list sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select ?np ?label ?date (group_concat(?t; separator=' ') as ?types) ?pubkey where { graph npa:graph { #=================== MULTI-VALUE PLACEHOLDER ====================#------ config: ------ { select ?pubkey { # <- VAR pubkey #bind("1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 2a6683923dcbd9810ef4e5debda8c4152c297b12303e286622bbbb0ed1884384" as ?_pubkeys) bind(?__pubkeys as ?v) # <- VAR _pubkeys {select*{optional{?a ?b ?c}}limit 1} # (for some Virtuoso v.) # values ?x{0 1 2 3 4 5 6 7 8 9} values ?y{0 1 2 3 4 5 6 7 8 9} # bind((10*?x)+?y as ?n) # (works for a maximum of 100 values) # bind(" " as ?sep) # (separator as regex-compatible character) # <- CONST sep bind(concat("^([^",?sep,"]*",?sep,"){",str(?n),"}") as ?p) # bind(concat(?sep,".*") as ?p0) # filter(if(?n=0,true,regex(?v,?p))) # (=0 check for Virtuoso) # bind(replace(if(?n=0,?v,replace(?v,?p,"")),?p0,"") as ?pubkey) # <- VAR pubkey } } # #================================================================#--------------------- ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } #=================== MULTI-VALUE PLACEHOLDER ====================#------ config: ------ { select ?type { # <- VAR type #bind("https://w3id.org/kpxl/grlc/grlc-query http://purl.org/nanopub/x/ExampleNanopub" as ?_types) bind(?__types as ?v) # <- VAR _types {select*{optional{?a ?b ?c}}limit 1} # (for some Virtuoso v.) # values ?x{0 1 2 3 4 5 6 7 8 9} values ?y{0 1 2 3 4 5 6 7 8 9} # bind((10*?x)+?y as ?n) # (works for a maximum of 100 values) # bind(" " as ?sep) # (separator as regex-compatible character) # <- CONST sep bind(concat("^([^",?sep,"]*",?sep,"){",str(?n),"}") as ?p) # bind(concat(?sep,".*") as ?p0) # filter(if(?n=0,true,regex(?v,?p))) # (=0 check for Virtuoso) # bind(replace(if(?n=0,?v,replace(?v,?p,"")),?p0,"") as ?typel) # <- VAR type bind(uri(?typel) as ?type) } } # #================================================================#--------------------- ?np npx:hasNanopubType ?type . ?np npx:hasNanopubType ?t . ?np dct:created ?date . #bind("2024-11-30" as ?__endtime) bind(coalesce(?__endtime, "9999") as ?endtime) filter(?endtime > str(?date)) #bind("2024-11-29" as ?__starttime) bind(coalesce(?__starttime, "0000") as ?starttime) filter(?starttime < str(?date)) optional { ?np rdfs:label ?label } } } group by ?np ?label ?date ?pubkey order by desc(?date) limit 100" assertion.
get-filtered-nanopub-list sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select ?np ?label ?date (group_concat(distinct ?t; separator=' ') as ?types) ?pubkey where { graph npa:graph { #=================== MULTI-VALUE PLACEHOLDER ====================#------ config: ------ { select ?pubkey { # <- VAR pubkey #bind("1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 2a6683923dcbd9810ef4e5debda8c4152c297b12303e286622bbbb0ed1884384" as ?_pubkeys) bind(?__pubkeys as ?v) # <- VAR _pubkeys {select*{optional{?a ?b ?c}}limit 1} # (for some Virtuoso v.) # values ?x{0 1 2 3 4 5 6 7 8 9} values ?y{0 1 2 3 4 5 6 7 8 9} # bind((10*?x)+?y as ?n) # (works for a maximum of 100 values) # bind(" " as ?sep) # (separator as regex-compatible character) # <- CONST sep bind(concat("^([^",?sep,"]*",?sep,"){",str(?n),"}") as ?p) # bind(concat(?sep,".*") as ?p0) # filter(if(?n=0,true,regex(?v,?p))) # (=0 check for Virtuoso) # bind(replace(if(?n=0,?v,replace(?v,?p,"")),?p0,"") as ?pubkey) # <- VAR pubkey } } # #================================================================#--------------------- ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } #=================== MULTI-VALUE PLACEHOLDER ====================#------ config: ------ { select ?type { # <- VAR type #bind("https://w3id.org/kpxl/grlc/grlc-query http://purl.org/nanopub/x/ExampleNanopub" as ?_types) bind(?__types as ?v) # <- VAR _types {select*{optional{?a ?b ?c}}limit 1} # (for some Virtuoso v.) # values ?x{0 1 2 3 4 5 6 7 8 9} values ?y{0 1 2 3 4 5 6 7 8 9} # bind((10*?x)+?y as ?n) # (works for a maximum of 100 values) # bind(" " as ?sep) # (separator as regex-compatible character) # <- CONST sep bind(concat("^([^",?sep,"]*",?sep,"){",str(?n),"}") as ?p) # bind(concat(?sep,".*") as ?p0) # filter(if(?n=0,true,regex(?v,?p))) # (=0 check for Virtuoso) # bind(replace(if(?n=0,?v,replace(?v,?p,"")),?p0,"") as ?typel) # <- VAR type bind(uri(?typel) as ?type) } } # #================================================================#--------------------- ?np npx:hasNanopubType ?type . ?np npx:hasNanopubType ?t . ?np dct:created ?date . #bind("2024-11-30" as ?__endtime) bind(coalesce(?__endtime, "9999") as ?endtime) filter(?endtime > str(?date)) #bind("2024-11-29" as ?__starttime) bind(coalesce(?__starttime, "0000") as ?starttime) filter(?starttime < str(?date)) optional { ?np rdfs:label ?label } } } group by ?np ?label ?date ?pubkey order by desc(?date) limit 100" assertion.
get-owners sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?owner ?np ?pubkeyhash ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkeyhash . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkeyhash . } ?np dct:created ?date . ?np np:hasAssertion ?a . } graph ?a { ?_unit_iri gen:hasOwner ?owner . } }" assertion.
get-members sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix foaf: <http://xmlns.com/foaf/0.1/> select ?member ?np ?pubkeyhash ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkeyhash . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkeyhash . } ?np dct:created ?date . ?np np:hasAssertion ?a . } graph ?a { ?_unit_iri foaf:member ?member . } }" assertion.
get-spaces sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select ?space ?label ?np ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?space . ?np npx:hasNanopubType <https://w3id.org/kpxl/gen/terms/Space> . ?np rdfs:label ?label . ?np np:hasAssertion ?a . filter not exists { ?npx npx:introduces ?space . ?npx dct:created ?datex . filter(?datex > ?date) } } } order by ?label" assertion.
get-spaces sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select ?space ?label ?type ?np ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?space . ?np npx:hasNanopubType <https://w3id.org/kpxl/gen/terms/Space> . ?np npx:hasNanopubType ?type . filter(?type != <https://w3id.org/kpxl/gen/terms/Space>) ?np rdfs:label ?label . ?np np:hasAssertion ?a . filter not exists { ?npx npx:introduces ?space . ?npx dct:created ?datex . filter(?datex > ?date) } } } order by ?label" assertion.
search-templates sparql "prefix nt: <https://w3id.org/np/o/ntemplate/> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix dct: <http://purl.org/dc/terms/> prefix search: <http://www.openrdf.org/contrib/lucenesail#> select distinct ?thing ?label ?description ?np ?pubkey ?date where { graph npa:graph { ?np npx:hasNanopubType nt:AssertionTemplate . ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . ?np rdfs:label ?label . optional { ?np dct:description ?description . } ?np np:hasAssertion ?thing . } ?np search:matches [ search:query ?_query ; search:property rdfs:label ; search:score ?score ; search:snippet ?snippet ] . } limit 10" assertion.
get-pinned-templates sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?space ?template ?tag ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . optional { ?np rdfs:label ?label } } graph ?a { ?space gen:hasPinnedTemplate ?template . optional { ?template gen:hasTag ?tag . } } } order by desc(?date)" assertion.
get-pinned-templates sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?template ?tag ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . optional { ?np rdfs:label ?label } } graph ?a { ?_space_iri gen:hasPinnedTemplate ?template . optional { ?template gen:hasTag ?tag . } } } order by desc(?date)" assertion.
search-templates sparql "prefix nt: <https://w3id.org/np/o/ntemplate/> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix dct: <http://purl.org/dc/terms/> prefix search: <http://www.openrdf.org/contrib/lucenesail#> select distinct ?thing ?label ?description ?pubkey ?date where { graph npa:graph { ?thing npx:hasNanopubType nt:AssertionTemplate . ?thing npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?thing ; npa:hasValidSignatureForPublicKey ?pubkey . } ?thing dct:created ?date . ?thing rdfs:label ?label . optional { ?thing dct:description ?description . } } ?np search:matches [ search:query ?_query ; search:property rdfs:label ; search:score ?score ; search:snippet ?snippet ] . } limit 10" assertion.
search-templates sparql "prefix nt: <https://w3id.org/np/o/ntemplate/> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix dct: <http://purl.org/dc/terms/> prefix search: <http://www.openrdf.org/contrib/lucenesail#> select distinct ?thing ?label ?description ?pubkey ?date where { graph npa:graph { ?thing npx:hasNanopubType nt:AssertionTemplate . ?thing npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?thing ; npa:hasValidSignatureForPublicKey ?pubkey . } ?thing dct:created ?date . ?thing rdfs:label ?label . optional { ?thing dct:description ?description . } } ?thing search:matches [ search:query ?_query ; search:property rdfs:label ; search:score ?score ; search:snippet ?snippet ] . } limit 10" assertion.
get-pinned-templates sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?template ?tag ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . optional { ?np rdfs:label ?label } } graph ?a { ?_space_iri gen:hasPinnedTemplate ?template . optional { ?template gen:hasPinGroupTag ?tag . } } } order by desc(?date)" assertion.
get-pinned-queries sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?template ?tag ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . optional { ?np rdfs:label ?label } } graph ?a { ?_space_iri gen:hasPinnedQuery ?template . optional { ?template gen:hasPinGroupTag ?tag . } } } order by desc(?date)" assertion.
get-pinned-queries sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?query ?tag ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . optional { ?np rdfs:label ?label } } graph ?a { ?_space_iri gen:hasPinnedQuery ?query . optional { ?query gen:hasPinGroupTag ?tag . } } } order by desc(?date)" assertion.
get-quarterly-active-organic-user-count sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix prov: <http://www.w3.org/ns/prov#> prefix foaf: <http://xmlns.com/foaf/0.1/> select ?quarter (count(distinct ?userid) as ?usercount) where { { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:creator ?userid . ?np dct:created ?date . } } union { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np np:hasAssertion ?assertion . ?np np:hasProvenance ?prov . ?np dct:created ?date . } graph ?prov { ?assertion prov:wasAttributedTo ?userid . } } filter not exists { graph npa:graph { ?np npa:hasSubIri ?userid . } } filter(str(?date) > "2022") filter(str(?date) < "2023-10-03" || str(?date) > "2023-10-12") filter(str(?date) < "2024-09-27" || str(?date) > "2024-10-07") bind(substr(str(?date), 0, 8) as ?month) bind(replace(?month, "-0[1-3]$", "-Q1") as ?quarter_temp1) bind(replace(?quarter_temp1, "-0[4-6]$", "-Q2") as ?quarter_temp2) bind(replace(?quarter_temp2, "-0[7-9]$", "-Q3") as ?quarter_temp3) bind(replace(?quarter_temp3, "-1[0-9]$", "-Q4") as ?quarter) } group by ?quarter order by desc(?quarter)" assertion.
find-things sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix dct: <http://purl.org/dc/terms/> prefix search: <http://www.openrdf.org/contrib/lucenesail#> select distinct ?thing ?label ?description ?np ?pubkey ?date where { graph npa:graph { ?np npx:hasNanopubType ?__type_iri . ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . ?np npx:introduces|npx:describes|npx:embeds ?thing . ?np rdfs:label ?label . optional { ?np dct:description ?description . } ?np np:hasAssertion ?a . } ?np search:matches [ search:query ?_query ; search:property rdfs:label ; search:score ?score ; search:snippet ?snippet ] . } limit 10" assertion.
get-spaces sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select ?space ?label ?type ?np ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?space . ?np npx:hasNanopubType <https://w3id.org/kpxl/gen/terms/Space> . ?np npx:hasNanopubType ?__type_iri . filter(?__type_iri != <https://w3id.org/kpxl/gen/terms/Space>) bind(?__type_iri as ?type) ?np rdfs:label ?label . ?np np:hasAssertion ?a . filter not exists { ?npx npx:introduces ?space . ?npx dct:created ?datex . filter(?datex > ?date) } } } order by ?label" assertion.
get-admins sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?admin ?np ?pubkeyhash ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkeyhash . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkeyhash . } ?np dct:created ?date . ?np np:hasAssertion ?a . } graph ?a { ?_unit_iri gen:hasAdmin ?admin . } }" assertion.
find-valid-gofair-qualified-things sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix fip: <https://w3id.org/fair/fip/terms/> prefix prov: <http://www.w3.org/ns/prov#> select distinct ?thing ?label ?description ?np ?date ?pubkey ?qualifier ?qualification_np (group_concat(distinct ?recommender; separator=" ") as ?recommenders) (group_concat(distinct ?recommendation_np; separator=" ") as ?recommendation_nps) (count(distinct ?recommender) as ?recommender_count) where { graph npa:graph { <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> npa:hasValidSignatureForPublicKey ?curators_np_pk . ?latest_curators_np npa:hasValidSignatureForPublicKey ?curators_np_pk . filter not exists { ?latest_curators_npx npx:invalidates ?latest_curators_np ; npa:hasValidSignatureForPublicKey ?curators_np_pk . } ?latest_curators_np np:hasAssertion ?latest_curators_assertion . } graph npa:networkGraph { ?latest_curators_np (npx:supersedes)* <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> . filter not exists { ?latest_curators_npxx npx:supersedes ?latest_curators_np } } graph npa:graph { ?np npx:hasNanopubType ?__type_iri . ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np (npx:introduces|npx:describes) ?thing . ?np rdfs:label ?label . ?np dct:description ?description . ?np dct:created ?date . filter(str(?date) > "2022") } bind(concat(" ",lcase(str(?label))," ",lcase(str(?description))," ") as ?text) filter( contains(?text, lcase(str(?_searchterm))) ) optional { graph npa:graph { ?disapproval npa:hasValidSignatureForPublicKey ?dpubkey . } graph ?latest_curators_assertion { ?dpubkeys npx:hasPublicKey ?dpubkey . } graph npa:graph { filter not exists { ?disapproval_x npx:invalidates ?disapproval ; npa:hasValidSignatureForPublicKey ?dpubkey . } ?disapproval np:hasAssertion ?da . } graph ?da { ?dsomebody ( npx:disapproves-of | npx:disapprovesOf ) ?np . } } filter(!bound(?disapproval)) # Faster than "filter not exists" for some reason optional { optional { graph npa:graph { ?recommendation_np npx:hasNanopubType fip:recommended-by . ?recommendation_np npa:hasValidSignatureForPublicKey ?rpubkey . filter not exists { ?recommendation_np_x npx:invalidates ?recommendation_np ; npa:hasValidSignatureForPublicKey ?rpubkey . } ?recommendation_np np:hasAssertion ?ra . ?recommendation_np np:hasProvenance ?rp . } graph ?ra { ?thing fip:recommended-by ?recommender . } graph ?rp { ?ra prov:wasDerivedFrom ?rfip_np . } graph npa:graph { ?rfip_np npx:hasNanopubType fip:Reference-FAIR-Implementation-Profile . ?rfip_np npa:hasValidSignatureForPublicKey ?rfip_pubkey . ?latest_rfip_np npa:hasValidSignatureForPublicKey ?rfip_pubkey . filter not exists { ?latest_rfip_npx npx:invalidates ?latest_rfip_np ; npa:hasValidSignatureForPublicKey ?rfip_pubkey . } } graph npa:networkGraph { ?latest_rfip_np (npx:supersedes)* ?rfip_np . } graph ?rfip_qa { ?rfip_qualifier npx:qualifies ?latest_rfip_np . } graph npa:graph { ?rfip_qualification_np np:hasAssertion ?rfip_qa . ?rfip_qualification_np npx:hasNanopubType npx:qualifies . ?rfip_qualification_np npa:hasValidSignatureForPublicKey ?rfip_qpubkey . filter not exists { ?rfip_qualification_np_x npx:invalidates ?rfip_qualification_np ; npa:hasValidSignatureForPublicKey ?rfip_qpubkey . } } graph ?latest_curators_assertion { ?rfip_qpubkeys npx:hasPublicKey ?rfip_qpubkey . } } graph npa:graph { ?qualification_np npx:hasNanopubType npx:qualifies . ?qualification_np npa:hasValidSignatureForPublicKey ?qpubkey . } graph ?latest_curators_assertion { ?qpubkeys npx:hasPublicKey ?qpubkey . } graph npa:graph { filter not exists { ?qualification_np_x npx:invalidates ?qualification_np ; npa:hasValidSignatureForPublicKey ?qpubkey . } ?qualification_np np:hasAssertion ?qa . } graph ?qa { ?qualifier npx:qualifies ?np . } } } group by ?thing ?label ?description ?np ?date ?pubkey ?retraction ?newversion ?qualifier ?qualification_np order by desc(?recommender_count) asc(?label)" assertion.
get-latest-users sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npx: <http://purl.org/nanopub/x/> prefix npa: <http://purl.org/nanopub/admin/> prefix dct: <http://purl.org/dc/terms/> prefix foaf: <http://xmlns.com/foaf/0.1/> select ?user (min(?date) as ?date) where { graph npa:graph { ?intronp npa:hasValidSignatureForPublicKey ?introPubkey . filter not exists { ?intronpx npx:retracts ?intronp ; npa:hasValidSignatureForPublicKey ?pubkey . } filter not exists { ?intronp npx:supersedes ?intronpx . } ?intronp dct:created ?date . ?intronp np:hasAssertion ?a . } graph ?a { ?keydeclaration npx:declaredBy ?user . ?keydeclaration npx:hasPublicKey ?pubkey . } } group by ?user order by desc(?date)" assertion.
get-latest-users sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npx: <http://purl.org/nanopub/x/> prefix npa: <http://purl.org/nanopub/admin/> prefix dct: <http://purl.org/dc/terms/> prefix foaf: <http://xmlns.com/foaf/0.1/> select ?user (min(?date) as ?date) where { graph npa:graph { ?intronp npa:hasValidSignatureForPublicKey ?introPubkey . filter not exists { ?intronpx npx:retracts ?intronp ; npa:hasValidSignatureForPublicKey ?pubkey . } filter not exists { ?intronp npx:supersedes ?intronpx . } ?intronp dct:created ?date . ?intronp np:hasAssertion ?a . } graph ?a { ?keydeclaration npx:declaredBy ?user . ?keydeclaration npx:hasPublicKey ?pubkey . } } group by ?user order by desc(?date) limit 100" assertion.
get-most-recent-nanopubs sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> select distinct ?np ?label ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:created ?date . optional { ?np rdfs:label ?label . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } filter not exists { ?np npx:hasNanopubType npx:retracts . } } } order by desc(?date) limit 100" assertion.
multi_placeholder-test sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> select ?np ?label ?date where { graph npa:graph { values ?_type_multi_iri {} ?np npx:hasNanopubType ?_type_multi_iri . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . optional { ?np rdfs:label ?label } } } order by desc(?date) limit 100" assertion.
get-space-member-roles sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?role ?roleNoun ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . } graph ?a { ?role a gen:SpaceMemberRole . ?role gen:hasRoleNoun ?roleNoun . ?role gen:isRoleOf ?_space_iri . } } order by desc(?date)" assertion.
get-space-members sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?member ?role ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . } graph ?a { values ?_role_multi_iri {} ?member ?_role_multi_iri ?_space_iri . bind(?_role_multi_iri as ?role) } } order by desc(?date)" assertion.
optional_multi_placeholder-test sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> select ?np ?label ?date where { graph npa:graph { values ?__type_multi_iri {} ?np npx:hasNanopubType ?_type_multi_iri . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . optional { ?np rdfs:label ?label } } } order by desc(?date) limit 100" assertion.
optional_multi_placeholder-test sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> select ?np ?label ?date where { graph npa:graph { values ?__type_multi_iri {} ?np npx:hasNanopubType ?__type_multi_iri . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . optional { ?np rdfs:label ?label } } } order by desc(?date) limit 100" assertion.
get-space-member-roles sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix owl: <http://www.w3.org/2002/07/owl#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?role ?roleName ?isInverse (group_concat(?eq; separator=' ') as ?equivalent) (group_concat(?inv; separator=' ') as ?inverse) ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . } graph ?a { ?role a gen:SpaceMemberRole . ?role dct:title ?roleName . ?role gen:isRoleOf ?_space_iri . bind( exists { ?role a gen:InverseSpaceMemberRole } as ?isInverse ) optional { ?role owl:equivalentProperty ?eq } optional { ?role owl:inverseOf ?inv } } } group by ?role ?roleName ?isInverse ?np ?pubkey ?date order by desc(?date)" assertion.
get-space-members sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?member ?role ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . } { { graph ?a { values ?_role_multi_iri {} ?member ?_role_multi_iri ?_space_iri . bind(?_role_multi_iri as ?role) } } union { graph ?a { values ?_invrole_multi_iri {} ?_space_iri ?_invrole_multi_iri ?member . bind(?_invrole_multi_iri as ?role) } } } } order by desc(?date)" assertion.
get-space-members sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?member ?role ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . } { { graph ?a { values ?__role_multi_iri {} ?member ?__role_multi_iri ?_space_iri . bind(?__role_multi_iri as ?role) } } union { graph ?a { values ?__invrole_multi_iri {} ?_space_iri ?__invrole_multi_iri ?member . bind(?__invrole_multi_iri as ?role) } } } } order by desc(?date)" assertion.
get-space-members sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?member ?role ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . } { { graph ?a { values ?__role_multi_iri {} ?member ?__role_multi_iri ?_space_iri . bind(?__role_multi_iri as ?role) } } union { graph ?a { values ?__invrole_multi_iri {} ?_space_iri ?__invrole_multi_iri ?member . bind(?__invrole_multi_iri as ?role) } } } filter(bound(?role)) } order by desc(?date)" assertion.
get-space-members sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?member ?role ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . } { { graph ?a { values ?_role_multi_iri {} filter(bound(?_role_multi_iri)) ?member ?_role_multi_iri ?_space_iri . bind(?_role_multi_iri as ?role) } } union { graph ?a { values ?_invrole_multi_iri {} filter(bound(?_invrole_multi_iri)) ?_space_iri ?_invrole_multi_iri ?member . bind(?_invrole_multi_iri as ?role) } } } } order by desc(?date)" assertion.
get-space-members sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?member ?role ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . } { { graph ?a { values ?__role_multi_iri {} filter(bound(?__role_multi_iri)) ?member ?__role_multi_iri ?_space_iri . bind(?__role_multi_iri as ?role) } } union { graph ?a { values ?__invrole_multi_iri {} filter(bound(?__invrole_multi_iri)) ?_space_iri ?__invrole_multi_iri ?member . bind(?__invrole_multi_iri as ?role) } } } } order by desc(?date)" assertion.
get-space-members sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?member ?role ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . } { { graph ?a { values ?__role_multi_iri {} filter(bound(?__role_multi_iri)) bind(?__role_multi_iri as ?r) ?member ?r <https://w3id.org/spaces/nanopub/nanosessions/session24> . bind(?r as ?role) } } union { graph ?a { values ?__invrole_multi_iri {} filter(bound(?__invrole_multi_iri)) bind(?__invrole_multi_iri as ?i) <https://w3id.org/spaces/nanopub/nanosessions/session24> ?i ?member . bind(?i as ?role) } } } } order by desc(?date)" assertion.
get-space-members sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?member ?role ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . } { { graph ?a { values ?__role_multi_iri {} filter(bound(?__role_multi_iri)) bind(?__role_multi_iri as ?r) ?member ?r ?_space_iri . bind(?r as ?role) } } union { graph ?a { values ?__invrole_multi_iri {} filter(bound(?__invrole_multi_iri)) bind(?__invrole_multi_iri as ?i) ?_space_iri ?i ?member . bind(?i as ?role) } } } } order by desc(?date)" assertion.
get-admins sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?admin ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . } graph ?a { values ?_space_multi_iri {} ?_space_multi_iri gen:hasAdmin ?admin . } }" assertion.
get-space-member-roles sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix owl: <http://www.w3.org/2002/07/owl#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?role ?roleName ?isInverse (group_concat(?eq; separator=' ') as ?equivalent) (group_concat(?inv; separator=' ') as ?inverse) ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . } graph ?a { ?role a gen:SpaceMemberRole . ?role dct:title ?roleName . values ?_space_multi_iri {} ?role gen:isRoleOf ?_space_multi_iri . bind( exists { ?role a gen:InverseSpaceMemberRole } as ?isInverse ) optional { ?role owl:equivalentProperty ?eq } optional { ?role owl:inverseOf ?inv } } } group by ?role ?roleName ?isInverse ?np ?pubkey ?date order by desc(?date)" assertion.
get-space-members sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?member ?role ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . } values ?_space_multi_iri {} { { graph ?a { values ?__role_multi_iri {} filter(bound(?__role_multi_iri)) bind(?__role_multi_iri as ?r) ?member ?r ?_space_multi_iri . bind(?r as ?role) } } union { graph ?a { values ?__invrole_multi_iri {} filter(bound(?__invrole_multi_iri)) bind(?__invrole_multi_iri as ?i) ?_space_multi_iri ?i ?member . bind(?i as ?role) } } } } order by desc(?date)" assertion.
get-pinned-queries sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?query ?tag ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . optional { ?np rdfs:label ?label } } graph ?a { values ?_space_multi_iri {} ?_space_multi_iri gen:hasPinnedQuery ?query . optional { ?query gen:hasPinGroupTag ?tag . } } } order by desc(?date)" assertion.
get-pinned-templates sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?template ?tag ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . optional { ?np rdfs:label ?label } } graph ?a { values ?_space_multi_iri {} ?_space_multi_iri gen:hasPinnedTemplate ?template . optional { ?template gen:hasPinGroupTag ?tag . } } } order by desc(?date)" assertion.
get-views-for-space sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?query ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . } graph ?a { values ?_space_multi_iri {} ?_space_multi_iri gen:hasView ?query . } } order by desc(?date)" assertion.
get-messages-about-nanosession24 sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix schema: <https://schema.org/> select ?text ?np ?creator ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np dct:creator ?creator . ?np np:hasAssertion ?a . } graph ?a { ?a rdfs:label ?text . ?a schema:about <https://w3id.org/spaces/nanopub/nanosessions/session24> . } } order by desc(?date)" assertion.
get-space-member-roles sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix owl: <http://www.w3.org/2002/07/owl#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?role ?roleName ?isInverse (group_concat(?eq; separator=' ') as ?equivalent) (group_concat(?inv; separator=' ') as ?inverse) ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . } graph ?a { ?role a gen:SpaceMemberRole . ?role dct:title ?roleName . values ?_space_multi_iri {} ?role gen:isRoleOf ?_space_multi_iri . bind( exists { ?role a gen:InverseSpaceMemberRole } as ?isInverse ) optional { ?role owl:equivalentProperty ?eq } optional { ?role owl:inverseOf ?inv } } } group by ?role ?roleName ?isInverse ?np ?pubkey ?date order by desc(?date)" assertion.
get-space-member-roles sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix owl: <http://www.w3.org/2002/07/owl#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?role ?roleTitle (group_concat(?eq; separator=' ') as ?equivalent) (group_concat(?inv; separator=' ') as ?inverse) ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?rel_a . } graph ?rel_a { #values ?_space_multi_iri {} ?_space_multi_iri gen:hasRole ?role . } graph npa:graph { ?role_np npx:embeds ?role . ?role_np np:hasAssertion ?role_a . } graph ?role_a { ?role a gen:SpaceMemberRole . ?role dct:title ?roleTitle . optional { ?role gen:hasRegularProperty ?eq } optional { ?role gen:hasInverseProperty ?inv } } } group by ?role ?roleTitle ?np ?pubkey ?date order by desc(?date)" assertion.
get-space-member-roles sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix owl: <http://www.w3.org/2002/07/owl#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?role ?roleTitle (group_concat(?reg; separator=' ') as ?regularProperties) (group_concat(?inv; separator=' ') as ?inverseProperties) ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?rel_a . } graph ?rel_a { #values ?_space_multi_iri {} ?_space_multi_iri gen:hasRole ?role . } graph npa:graph { ?role_np npx:embeds ?role . ?role_np np:hasAssertion ?role_a . } graph ?role_a { ?role a gen:SpaceMemberRole . ?role dct:title ?roleTitle . optional { ?role gen:hasRegularProperty ?reg } optional { ?role gen:hasInverseProperty ?inv } } } group by ?role ?roleTitle ?np ?pubkey ?date order by desc(?date)" assertion.
get-space-member-roles sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix owl: <http://www.w3.org/2002/07/owl#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> prefix schema: <http://schema.org/> select ?role ?roleLabel ?roleName ?roleTitle (group_concat(?reg; separator=' ') as ?regularProperties) (group_concat(?inv; separator=' ') as ?inverseProperties) ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?rel_a . } graph ?rel_a { #values ?_space_multi_iri {} ?_space_multi_iri gen:hasRole ?role . } graph npa:graph { ?role_np npx:embeds ?role . ?role_np np:hasAssertion ?role_a . } graph ?role_a { ?role a gen:SpaceMemberRole . ?role rdfs:label ?roleLabel . ?role dct:title ?roleTitle . ?role schema:name ?roleName . optional { ?role gen:hasRegularProperty ?reg } optional { ?role gen:hasInverseProperty ?inv } } } group by ?role ?roleLabel ?roleName ?roleTitle ?np ?pubkey ?date order by desc(?date)" assertion.
get-space-member-roles sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix owl: <http://www.w3.org/2002/07/owl#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> prefix schema: <http://schema.org/> select ?role ?roleLabel ?roleName ?roleTitle (group_concat(?reg; separator=' ') as ?regularProperties) (group_concat(?inv; separator=' ') as ?inverseProperties) ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?rel_a . } graph ?rel_a { values ?_space_multi_iri {} ?_space_multi_iri gen:hasRole ?role . } graph npa:graph { ?role_np npx:embeds ?role . ?role_np np:hasAssertion ?role_a . } graph ?role_a { ?role a gen:SpaceMemberRole . ?role rdfs:label ?roleLabel . ?role dct:title ?roleTitle . ?role schema:name ?roleName . optional { ?role gen:hasRegularProperty ?reg } optional { ?role gen:hasInverseProperty ?inv } } } group by ?role ?roleLabel ?roleName ?roleTitle ?np ?pubkey ?date order by desc(?date)" assertion.
get-latest-nanopubs-by-pubkey sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> select distinct ?np ?label ?date where { graph npa:graph { values ?_memberHash_multi {} ?np npa:hasValidSignatureForPublicKeyHash ?_memberHash_multi . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?_memberHash_multi . } ?np dct:created ?date . optional { ?np rdfs:label ?label . } filter not exists { ?np npx:hasNanopubType npx:retracts . } } } order by desc(?date) limit 100" assertion.
get-messages-about-ko2025lecture9 sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix schema: <https://schema.org/> select ?text ?np ?user ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np dct:creator ?user . ?np np:hasAssertion ?a . } graph ?a { ?a rdfs:label ?text . ?a schema:about <https://w3id.org/spaces/knowledgepixels/ko2025lecture9> . } } order by desc(?date)" assertion.
subj-refs sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix prov: <http://www.w3.org/ns/prov#> prefix foaf: <http://xmlns.com/foaf/0.1/> select ?pred ?obj ?date ?creator where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:created ?date . ?np dct:creator ?creator . ?np np:hasAssertion ?assertion . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } graph ?assertion { ?_subj_iri ?pred ?obj . } } order by desc(?date)" assertion.
query sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix prov: <http://www.w3.org/ns/prov#> prefix foaf: <http://xmlns.com/foaf/0.1/> select ?pred ?obj ?date ?creator where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:created ?date . ?np dct:creator ?creator . ?np np:hasAssertion ?assertion . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } graph ?assertion { ?_subj_iri ?pred ?obj . } } order by desc(?date)" assertion.
subj-refs sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix prov: <http://www.w3.org/ns/prov#> prefix tpff: <https://w3id.org/fair/3pff/> select ?event ?eventName ?eventDate ?npDate ?np where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:created ?npDate . ?np dct:creator ?creator . ?np np:hasAssertion ?assertion . ?np npx:introduces ?event . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } graph ?assertion { ?event a tpff:3PFF-event . ?event rdfs:label ?eventName . ?event dct:date ?eventDate . } } order by desc(?eventDate)" assertion.
get-3pff-events sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix prov: <http://www.w3.org/ns/prov#> prefix tpff: <https://w3id.org/fair/3pff/> select ?event ?eventName ?eventDate ?npDate ?np where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:created ?npDate . ?np dct:creator ?creator . ?np np:hasAssertion ?assertion . ?np npx:introduces ?event . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } graph ?assertion { ?event a tpff:3PFF-event . ?event rdfs:label ?eventName . ?event dct:date ?eventDate . } } order by desc(?eventDate)" assertion.
get-3pff-events sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix prov: <http://www.w3.org/ns/prov#> prefix tpff: <https://w3id.org/fair/3pff/> select ?event ?eventName ?eventShortName ?eventLongName ?eventType ?eventTypeName ?eventDate ?eventOrganizer ?eventMoreInfoLink ?np ?npCreator ?npDate where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:created ?npDate . ?np dct:creator ?npCreator . ?np np:hasAssertion ?assertion . ?np npx:introduces ?event . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } graph ?assertion { ?event a tpff:3PFF-event . ?event rdfs:label ?eventName . bind(replace(str(?eventName), ' ?\\|.*$', '') as ?eventShortName) bind(replace(str(?eventName), '^.*\\| ?(.*)$', '$1') as ?eventLongName) ?event dct:date ?eventDate . ?event tpff:has-event-organizer ?eventOrganizer . values ?eventType { tpff:In-Person-Event tpff:Hybrid-Event tpff:Virtual-Event } ?event a ?eventType . bind(replace(str(?eventType), '^.*/', '') as ?eventTypeName) ?event rdfs:seeAlso ?eventMoreInfoLink . } } order by desc(?eventDate)" assertion.
get-3pff-events sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix prov: <http://www.w3.org/ns/prov#> prefix tpff: <https://w3id.org/fair/3pff/> select ?event ?eventName ?eventShortName ?eventLongName ?eventType ?eventTypeName ?eventDate ?eventOrganizer ?eventMoreInfoLink ?np ?npCreator ?npDate where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:created ?npDate . ?np dct:creator ?npCreator . ?np np:hasAssertion ?assertion . ?np npx:introduces ?event . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } graph ?assertion { ?event a tpff:3PFF-event . ?event rdfs:label ?eventName . bind(replace(str(?eventName), ' ?\\|.*$', '') as ?eventShortName) bind(replace(str(?eventName), '^.*\\| ?(.*)$', '$1') as ?eventLongName) ?event dct:date ?eventDate . optional { ?event tpff:has-event-organizer ?eventOrganizer . } optional { values ?eventType { tpff:In-Person-Event tpff:Hybrid-Event tpff:Virtual-Event } ?event a ?eventType . bind(replace(str(?eventType), '^.*/', '') as ?eventTypeName) } optional { ?event rdfs:seeAlso ?eventMoreInfoLink . } } } order by desc(?eventDate)" assertion.
get-3pff-events sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix prov: <http://www.w3.org/ns/prov#> prefix tpff: <https://w3id.org/fair/3pff/> select ?event ?eventName ?eventShortName ?eventLongName ?eventType ?eventTypeName ?eventDate ?eventOrganizer ?eventFacilitator ?eventMoreInfoLink ?np ?npCreator ?npDate where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:created ?npDate . ?np dct:creator ?npCreator . ?np np:hasAssertion ?assertion . ?np npx:introduces ?event . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } graph ?assertion { ?event a tpff:3PFF-event . ?event rdfs:label ?eventName . bind(replace(str(?eventName), ' ?\\|.*$', '') as ?eventShortName) bind(replace(str(?eventName), '^.*\\| ?(.*)$', '$1') as ?eventLongName) ?event dct:date ?eventDate . optional { ?event tpff:has-event-organizer ?eventOrganizer . } optional { ?event tpff:has-event-facilitator ?eventFacilitator . } optional { values ?eventType { tpff:In-Person-Event tpff:Hybrid-Event tpff:Virtual-Event } ?event a ?eventType . bind(replace(str(?eventType), '^.*/', '') as ?eventTypeName) } optional { ?event rdfs:seeAlso ?eventMoreInfoLink . } } } order by desc(?eventDate)" assertion.
get-3pff-events sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix prov: <http://www.w3.org/ns/prov#> prefix tpff: <https://w3id.org/fair/3pff/> select ?event ?eventSeries ?eventName ?eventShortName ?eventLongName ?eventType ?eventTypeName ?eventDate ?eventOrganizer ?eventFacilitator ?eventMoreInfoLink ?np ?npCreator ?npDate where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:created ?npDate . ?np dct:creator ?npCreator . ?np np:hasAssertion ?assertion . ?np npx:introduces ?event . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } graph ?assertion { ?event a tpff:3PFF-event . ?event rdfs:label ?eventName . bind(replace(str(?eventName), ' ?\\|.*$', '') as ?eventShortName) bind(replace(str(?eventName), '^([A-Z0-9]{2,3}).*$', '$1') as ?eventSeries) bind(replace(str(?eventName), '^.*\\| ?(.*)$', '$1') as ?eventLongName) ?event dct:date ?eventDate . optional { ?event tpff:has-event-organizer ?eventOrganizer . } optional { ?event tpff:has-event-facilitator ?eventFacilitator . } optional { values ?eventType { tpff:In-Person-Event tpff:Hybrid-Event tpff:Virtual-Event } ?event a ?eventType . bind(replace(str(?eventType), '^.*/', '') as ?eventTypeName) } optional { ?event rdfs:seeAlso ?eventMoreInfoLink . } } } order by ?eventSeries desc(?eventDate)" assertion.
get-3pff-events sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix prov: <http://www.w3.org/ns/prov#> prefix tpff: <https://w3id.org/fair/3pff/> select ?event ?eventSeries ?eventName ?eventShortName ?eventLongName ?eventType ?eventTypeName ?eventDate ?eventOrganizer ?eventOrganizerLabel ?eventFacilitator ?eventFacilitatorLabel ?eventMoreInfoLink ?eventMoreInfoLinkLabel ?np ?npCreator ?npDate where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:created ?npDate . ?np dct:creator ?npCreator . ?np np:hasAssertion ?assertion . ?np npx:introduces ?event . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } graph ?assertion { ?event a tpff:3PFF-event . ?event rdfs:label ?eventName . bind(replace(str(?eventName), ' ?\\|.*$', '') as ?eventShortName) bind(replace(str(?eventName), '^([A-Z0-9]{2,3}).*$', '$1') as ?eventSeries) bind(replace(str(?eventName), '^.*\\| ?(.*)$', '$1') as ?eventLongName) ?event dct:date ?eventDate . optional { ?event tpff:has-event-organizer ?eventOrganizer . bind(replace(str(?eventOrganizer), '^.*[/#]([^#/\\?]+)[#/]?(\\?.*)?$', '$1') as ?eventOrganizerLabel) } optional { ?event tpff:has-event-facilitator ?eventFacilitator . bind(replace(str(?eventFacilitator), '^.*[/#]([^#/\\?]+)[#/]?(\\?.*)?$', '$1') as ?eventFacilitatorLabel) } optional { values ?eventType { tpff:In-Person-Event tpff:Hybrid-Event tpff:Virtual-Event } ?event a ?eventType . bind(replace(str(?eventType), '^.*/', '') as ?eventTypeName) } optional { ?event rdfs:seeAlso ?eventMoreInfoLink . bind(replace(str(?eventMoreInfoLink), '^.*[/#]([^#/\\?]+)[#/]?(\\?.*)?$', '$1') as ?eventMoreInfoLinkLabel) } } } order by ?eventSeries desc(?eventDate)" assertion.
test sparql "select * where { bind("first version" as ?t) }" assertion.
test sparql "select * where { bind("second version" as ?t) }" assertion.
test sparql "select * where { bind("third version" as ?t) }" assertion.
get-bdj-nanopubs sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix oa: <http://www.w3.org/ns/oa#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix pav: <http://purl.org/pav/> prefix bibo: <http://purl.org/ontology/bibo/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> select distinct ?np ?label (coalesce(?firstAuthor, min(?author), min(?creator)) as ?mainAuthor) (if(if(count(distinct ?author)>0, count(distinct ?author), count(distinct ?creator)) > 1, "et al.", "") as ?authorEtAl) ?date where { graph npa:graph { ?np dct:created ?date . ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np rdfs:label ?label . ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?i . filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } optional { graph ?i { ?np pav:authoredBy ?author . } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList ?hasElement ?author . filter(strstarts(str(?hasElement), str(rdf:_))) } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList rdf:_1 ?firstAuthor . } } } group by ?np ?label ?date order by desc(?date)" assertion.
get-latest-bdj-nanopubs sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix oa: <http://www.w3.org/ns/oa#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix pav: <http://purl.org/pav/> prefix bibo: <http://purl.org/ontology/bibo/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> select distinct ?np ?label (coalesce(?firstAuthor, min(?author), min(?creator)) as ?mainAuthor) (if(if(count(distinct ?author)>0, count(distinct ?author), count(distinct ?creator)) > 1, "et al.", "") as ?authorEtAl) ?date where { graph npa:graph { ?np dct:created ?date . ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np rdfs:label ?label . ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?i . filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } optional { graph ?i { ?np pav:authoredBy ?author . } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList ?hasElement ?author . filter(strstarts(str(?hasElement), str(rdf:_))) } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList rdf:_1 ?firstAuthor . } } } group by ?np ?label ?date order by desc(?date) limit 20" assertion.
get-latest-bdj-nanopubs sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix oa: <http://www.w3.org/ns/oa#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix pav: <http://purl.org/pav/> prefix bibo: <http://purl.org/ontology/bibo/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> select distinct ?np ?label (coalesce(?firstAuthor, min(?author), min(?creator)) as ?mainAuthor) (if(if(count(distinct ?author)>0, count(distinct ?author), count(distinct ?creator)) > 1, "et al.", "") as ?authorEtAl) ?timestamp (substr(str(?timestamp), 0, 11) as ?date) where { graph npa:graph { ?np dct:created ?timestamp . ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np rdfs:label ?label . ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?i . filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } optional { graph ?i { ?np pav:authoredBy ?author . } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList ?hasElement ?author . filter(strstarts(str(?hasElement), str(rdf:_))) } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList rdf:_1 ?firstAuthor . } } } group by ?np ?label ?timestamp order by desc(?timestamp) limit 10" assertion.
get-latest-rio-nanopubs sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix oa: <http://www.w3.org/ns/oa#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix pav: <http://purl.org/pav/> prefix bibo: <http://purl.org/ontology/bibo/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> select distinct ?np ?label (coalesce(?firstAuthor, min(?author), min(?creator)) as ?mainAuthor) (if(if(count(distinct ?author)>0, count(distinct ?author), count(distinct ?creator)) > 1, "et al.", "") as ?authorEtAl) ?timestamp (substr(str(?timestamp), 0, 11) as ?date) where { graph npa:graph { ?np dct:created ?timestamp . ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np rdfs:label ?label . ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?i . filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } optional { graph ?i { ?np pav:authoredBy ?author . } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList ?hasElement ?author . filter(strstarts(str(?hasElement), str(rdf:_))) } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList rdf:_1 ?firstAuthor . } } } group by ?np ?label ?timestamp order by desc(?timestamp) limit 10" assertion.
get-latest-rio-nanopubs sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix oa: <http://www.w3.org/ns/oa#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix pav: <http://purl.org/pav/> prefix bibo: <http://purl.org/ontology/bibo/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> select distinct ?np ?label (coalesce(?firstAuthor, min(?author), min(?creator)) as ?mainAuthor) (if(if(count(distinct ?author)>0, count(distinct ?author), count(distinct ?creator)) > 1, " et al.", "") as ?authorEtAl) ?timestamp (substr(str(?timestamp), 0, 11) as ?date) where { graph npa:graph { ?np dct:created ?timestamp . ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np rdfs:label ?label . ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?i . filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } optional { graph ?i { ?np pav:authoredBy ?author . } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList ?hasElement ?author . filter(strstarts(str(?hasElement), str(rdf:_))) } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList rdf:_1 ?firstAuthor . } } } group by ?np ?label ?timestamp order by desc(?timestamp) limit 10" assertion.
get-latest-rio-nanopubs sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix oa: <http://www.w3.org/ns/oa#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix pav: <http://purl.org/pav/> prefix bibo: <http://purl.org/ontology/bibo/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> select distinct ?np ?label (coalesce(?firstAuthor, min(?author), min(?creator)) as ?mainAuthor) (if(if(count(distinct ?author)>0, count(distinct ?author), count(distinct ?creator)) > 1, " et al.", "") as ?authorEtAl) ?timestamp (substr(str(?timestamp), 0, 11) as ?date) where { graph npa:graph { ?np dct:created ?timestamp . ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np rdfs:label ?label . ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?i . filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } optional { graph ?i { ?np pav:authoredBy ?author . } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList ?hasElement ?author . filter(strstarts(str(?hasElement), str(rdf:_))) } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList rdf:_1 ?firstAuthor . } } } group by ?np ?label ?timestamp order by desc(?timestamp) limit 10" assertion.
get-latest-rio-nanopubs sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix oa: <http://www.w3.org/ns/oa#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix pav: <http://purl.org/pav/> prefix bibo: <http://purl.org/ontology/bibo/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> select distinct ?np ?label (coalesce(?firstAuthor, min(?author), min(?creator)) as ?mainAuthor) (if(if(count(distinct ?author)>0, count(distinct ?author), count(distinct ?creator)) > 1, " et al.", "") as ?authorEtAl) ?timestamp (substr(str(?timestamp), 0, 11) as ?date) where { graph npa:graph { ?np dct:created ?timestamp . ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np rdfs:label ?label . ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?i . filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } optional { graph ?i { ?np pav:authoredBy ?author . } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList ?hasElement ?author . filter(strstarts(str(?hasElement), str(rdf:_))) } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList rdf:_1 ?firstAuthor . } } } group by ?np ?label ?timestamp order by desc(?timestamp) limit 10" assertion.

first
previous
next