Matches in Nanopublications for { ?s <https://w3id.org/kpxl/grlc/sparql> ?o ?g. }
- get-publications 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 fabio: <http://purl.org/spar/fabio/> prefix bibo: <http://purl.org/ontology/bibo/> prefix foaf: <http://xmlns.com/foaf/0.1/> select ?paper ?paper_label ?journal ?journal_label ?publication_date (group_concat(str(?author_id); separator=" ") as ?authors_multi_iri) (group_concat(replace(replace(?author_name, "\\\\", "\\\\\\\\"), "\\n", "\\\\n"); separator="\n") as ?authors_label_multi) ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType fabio:ScholarlyWork . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np np:hasAssertion ?a . ?np npx:introduces ?paper . } graph ?a { ?paper dct:title ?paper_label . ?paper bibo:authorList ?author_list . optional { ?paper dct:date ?publication_date . } ?author_list ?rdfseqpred ?author_id . filter(strstarts(str(?rdfseqpred), "http://www.w3.org/1999/02/22-rdf-syntax-ns#_")) ?author_id foaf:name ?author_name . optional { ?paper dct:isPartOf ?journal . ?journal dct:title ?journal_label . } } } group by ?paper ?paper_label ?journal ?journal_label ?publication_date ?np order by desc(?publication_date)" assertion.
- get-publications 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 fabio: <http://purl.org/spar/fabio/> prefix bibo: <http://purl.org/ontology/bibo/> prefix foaf: <http://xmlns.com/foaf/0.1/> select ?paper ?paper_label ?journal ?journal_label ?publication_date (group_concat(str(?author_id); separator=" ") as ?authors_multi_iri) (group_concat(replace(replace(?author_name, "\\\\", "\\\\\\\\"), "\\n", "\\\\n"); separator="\n") as ?authors_label_multi) ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType fabio:ScholarlyWork . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np np:hasAssertion ?a . ?np npx:introduces ?paper . } graph ?a { ?paper dct:title ?paper_label . ?paper bibo:authorList ?author_list . optional { ?paper dct:date ?publication_date . } ?author_list ?rdfseqpred ?author_id . filter(strstarts(str(?rdfseqpred), "http://www.w3.org/1999/02/22-rdf-syntax-ns#_")) optional { ?author_id foaf:name ?author_name_raw . } bind(coalesce(?author_name_raw, "") as ?author_name) optional { ?paper dct:isPartOf ?journal . ?journal dct:title ?journal_label . } } } group by ?paper ?paper_label ?journal ?journal_label ?publication_date ?np order by desc(?publication_date)" assertion.
- get-messages-about-resource-and-parts 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 ?about ?text (group_concat(concat('<span><a href="', str(?link), '">link</a></span>'); separator=", ") as ?link) ?user ?date ?np ("^" as ?np_label) 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 ?about . values ?_resource_multi_iri {} filter( strstarts(str(?about), str(?_resource_multi_iri)) || exists { graph npa:graph { ?np2 npa:hasValidSignatureForPublicKeyHash ?pubkey2 . filter not exists { ?npx2 npx:invalidates ?np2 ; npa:hasValidSignatureForPublicKeyHash ?pubkey2 . } ?np2 np:hasAssertion ?a2 . } graph ?a2 { { ?about dct:isPartOf ?_resource_multi_iri . } union { ?_resource_multi_iri dct:hasPart ?about . } } } ) optional { ?a rdfs:seeAlso ?link . } } } group by ?about ?text ?user ?date ?np order by desc(?date)" assertion.
- get-messages-about-resource-and-parts 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 ?about ?text (group_concat(concat('<span><a href="', str(?link), '">link</a></span>'); separator=", ") as ?link) ?user ?date ?np ("^" as ?np_label) 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 ?about . values ?_resource_multi_iri {} filter( strstarts(str(?about), str(?_resource_multi_iri)) || exists { graph npa:graph { ?np2 npa:hasValidSignatureForPublicKeyHash ?pubkey2 . filter not exists { ?npx2 npx:invalidates ?np2 ; npa:hasValidSignatureForPublicKeyHash ?pubkey2 . } ?np2 np:hasAssertion ?a2 . } graph ?a2 { { ?about dct:isPartOf ?_resource_multi_iri . } union { ?_resource_multi_iri dct:hasPart ?about . } } } || exists { graph npa:graph { ?np3 npa:hasValidSignatureForPublicKeyHash ?pubkey3 . filter not exists { ?npx3 npx:invalidates ?np3 ; npa:hasValidSignatureForPublicKeyHash ?pubkey3 . } ?np3 np:hasAssertion ?a3 . } graph ?a3 { ?about dct:isPartOf ?mid . } filter( strstarts(str(?mid), str(?_resource_multi_iri)) || exists { graph npa:graph { ?np4 npa:hasValidSignatureForPublicKeyHash ?pubkey4 . filter not exists { ?npx4 npx:invalidates ?np4 ; npa:hasValidSignatureForPublicKeyHash ?pubkey4 . } ?np4 np:hasAssertion ?a4 . } graph ?a4 { { ?mid dct:isPartOf ?_resource_multi_iri . } union { ?_resource_multi_iri dct:hasPart ?mid . } } } ) } ) optional { ?a rdfs:seeAlso ?link . } } } group by ?about ?text ?user ?date ?np order by desc(?date)" assertion.
- get-poster-presentations-for-event 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 ?poster ?poster_label ?date (group_concat(str(?author); separator=" ") as ?authors_multi_iri) (group_concat(replace(replace(?authorname, "\\\\", "\\\\\\\\"), "\\n", "\\\\n"); separator="\n") as ?authors_label_multi) ?np ("^" as ?np_label) where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } ?np dct:created ?npdate . ?np np:hasAssertion ?a . ?np npx:introduces ?poster . } values ?_event_multi_iri {} graph ?a { ?poster a gen:PosterPresentation . ?poster dct:isPartOf ?_event_multi_iri . ?poster dct:creator ?author . optional { ?author rdfs:label ?authorname . } optional { ?poster rdfs:label ?poster_label . } optional { ?poster dct:date ?date . } } } group by ?poster ?poster_label ?date ?np order by desc(?date)" assertion.
- get-paragraphs sparql "prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 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/> prefix kpxlt: <https://w3id.org/kpxl/gen/terms/> select ?title ?content ?date ?np 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 { ?paragraph schema:title ?title . ?paragraph rdf:type kpxlt:Paragraph . ?paragraph kpxlt:hasContent ?content . values ?_resource_multi_iri {} ?paragraph schema:isPartOf ?_resource_multi_iri . } } order by ?title" assertion.
- get-presentation-details 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 rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix wd: <http://www.wikidata.org/entity/> prefix schema: <https://schema.org/> select ?property ?property_label ?value ?value_label where { bind(?_resourceNp_iri as ?np) graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np np:hasAssertion ?a . ?np npx:introduces ?_resource_iri . } graph ?a { ?_resource_iri ?pred ?value . optional { ?value rdfs:label ?value_label_raw . } } bind(?pred as ?property) bind( if(?pred = rdf:type && ?value = wd:Q604733, "Presentation", if(?pred = rdf:type && ?value = <https://w3id.org/kpxl/gen/terms/PosterPresentation>, "Poster presentation", ?value_label_raw)) as ?value_label) bind( if(?pred = rdf:type, "Type", if(?pred = rdfs:label, "Title", if(?pred = dct:date, "Date", if(?pred = wd:P823, "Speaker", if(?pred = dct:creator, "Author", if(?pred = dct:isPartOf, "Part of", if(?pred = dct:description, "Description", if(?pred = rdfs:seeAlso, "Link", if(?pred = schema:about, "Topic", str(?pred)))))))))) as ?property_label) bind( if(?pred = rdf:type, 0, if(?pred = rdfs:label, 1, if(?pred = dct:date, 2, if(?pred = wd:P823, 3, if(?pred = dct:creator, 4, if(?pred = dct:isPartOf, 5, if(?pred = dct:description, 6, if(?pred = rdfs:seeAlso, 7, if(?pred = schema:about, 8, 99))))))))) as ?sort) } order by ?sort" assertion.
- get-paragraphs sparql "prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 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/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?title ?content ?date ?np 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 { ?paragraph schema:title ?title . ?paragraph rdf:type gen:Paragraph . ?paragraph gen:hasContent ?content . values ?_resource_multi_iri {} ?paragraph schema:isPartOf ?_resource_multi_iri . optional { ?paragraph gen:hasPositionString ?position } } } order by ?position ?title" assertion.
- get-paragraphs sparql "prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 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/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?title ?content ?date ?np 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 { ?paragraph schema:title ?title . ?paragraph rdf:type gen:Paragraph . ?paragraph gen:hasContent ?content . values ?_resource_multi_iri {} ?paragraph schema:about ?_resource_multi_iri . optional { ?paragraph gen:hasPositionString ?position } } } order by ?position ?title" assertion.
- get-spaces-and-roles-for-user 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/> prefix schema: <http://schema.org/> select ?space ?space_label (group_concat(distinct str(?role); separator=" ") as ?roles_multi_iri) (group_concat(distinct replace(replace(?roleLabel, "\\\\", "\\\\\\\\"), "\\n", "\\\\n"); separator="\\n") as ?roles_label_multi) where { { { graph npa:graph { ?spaceRole_np npx:hasNanopubType gen:SpaceMemberRole . ?spaceRole_np npa:hasValidSignatureForPublicKeyHash ?spaceRole_pubkey . filter not exists { ?spaceRole_npx npx:invalidates ?spaceRole_np ; npa:hasValidSignatureForPublicKeyHash ?spaceRole_pubkey . } ?spaceRole_np np:hasAssertion ?spaceRole_a . } graph ?spaceRole_a { ?space gen:hasRole ?role . } } union { bind(<https://w3id.org/np/RA_eEJjQbxzSqYSwPzfjzOZi5sMPpUmHskFNsgJYSws8I/adminRole> as ?role) } } graph ?role_a { ?role a gen:SpaceMemberRole . ?role rdfs:label ?roleLabel . ?role dct:title ?roleTitle . ?role schema:name ?roleName . } graph npa:graph { ?role_np npx:embeds ?role . ?role_np np:hasAssertion ?role_a . } { { graph ?role_a { ?role gen:hasRegularProperty ?reg . } graph ?link_a { ?_agent_iri ?reg ?space . } } union { graph ?role_a { ?role gen:hasInverseProperty ?inv . } graph ?link_a { ?space ?inv ?_agent_iri . } } } graph npa:graph { ?link_np np:hasAssertion ?link_a . ?link_np npa:hasValidSignatureForPublicKeyHash ?link_pubkey . filter not exists { ?link_npx npx:invalidates ?link_np ; npa:hasValidSignatureForPublicKeyHash ?link_pubkey . } } optional { graph npa:graph { ?space_np npx:introduces ?space . ?space_np npa:hasValidSignatureForPublicKeyHash ?space_pubkey . filter not exists { ?space_npx npx:invalidates ?space_np ; npa:hasValidSignatureForPublicKeyHash ?space_pubkey . } ?space_np rdfs:label ?space_label . } } } group by ?space ?space_label order by ?space_label" assertion.
- get-spaces-and-roles-for-user 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/> prefix schema: <http://schema.org/> select ?space ?space_label (group_concat(distinct str(?role); separator=" ") as ?roles_multi_iri) (group_concat(distinct replace(replace(?roleName, "\\\\", "\\\\\\\\"), "\\n", "\\\\n"); separator="\\n") as ?roles_label_multi) where { { { graph npa:graph { ?spaceRole_np npx:hasNanopubType gen:SpaceMemberRole . ?spaceRole_np npa:hasValidSignatureForPublicKeyHash ?spaceRole_pubkey . filter not exists { ?spaceRole_npx npx:invalidates ?spaceRole_np ; npa:hasValidSignatureForPublicKeyHash ?spaceRole_pubkey . } ?spaceRole_np np:hasAssertion ?spaceRole_a . } graph ?spaceRole_a { ?space gen:hasRole ?role . } } union { bind(<https://w3id.org/np/RA_eEJjQbxzSqYSwPzfjzOZi5sMPpUmHskFNsgJYSws8I/adminRole> as ?role) } } graph ?role_a { ?role a gen:SpaceMemberRole . ?role rdfs:label ?roleLabel . ?role dct:title ?roleTitle . ?role schema:name ?roleName . } graph npa:graph { ?role_np npx:embeds ?role . ?role_np np:hasAssertion ?role_a . } { { graph ?role_a { ?role gen:hasRegularProperty ?reg . } graph ?link_a { ?_agent_iri ?reg ?space . } } union { graph ?role_a { ?role gen:hasInverseProperty ?inv . } graph ?link_a { ?space ?inv ?_agent_iri . } } } graph npa:graph { ?link_np np:hasAssertion ?link_a . ?link_np npa:hasValidSignatureForPublicKeyHash ?link_pubkey . filter not exists { ?link_npx npx:invalidates ?link_np ; npa:hasValidSignatureForPublicKeyHash ?link_pubkey . } } optional { graph npa:graph { ?space_np npx:introduces ?space . ?space_np npa:hasValidSignatureForPublicKeyHash ?space_pubkey . filter not exists { ?space_npx npx:invalidates ?space_np ; npa:hasValidSignatureForPublicKeyHash ?space_pubkey . } ?space_np rdfs:label ?space_label . } } } group by ?space ?space_label order by ?space_label" assertion.
- get-spaces-and-roles-for-user 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/> prefix schema: <http://schema.org/> select ?space ?space_label (group_concat(distinct str(?role); separator=" ") as ?roles_multi_iri) (group_concat(distinct ?roleName; separator="\n") as ?roles_label_multi) where { { { graph npa:graph { ?spaceRole_np npx:hasNanopubType gen:SpaceMemberRole . ?spaceRole_np npa:hasValidSignatureForPublicKeyHash ?spaceRole_pubkey . filter not exists { ?spaceRole_npx npx:invalidates ?spaceRole_np ; npa:hasValidSignatureForPublicKeyHash ?spaceRole_pubkey . } ?spaceRole_np np:hasAssertion ?spaceRole_a . } graph ?spaceRole_a { ?space gen:hasRole ?role . } } union { bind(<https://w3id.org/np/RA_eEJjQbxzSqYSwPzfjzOZi5sMPpUmHskFNsgJYSws8I/adminRole> as ?role) } } graph ?role_a { ?role a gen:SpaceMemberRole . ?role rdfs:label ?roleLabel . ?role dct:title ?roleTitle . ?role schema:name ?roleName . } graph npa:graph { ?role_np npx:embeds ?role . ?role_np np:hasAssertion ?role_a . } { { graph ?role_a { ?role gen:hasRegularProperty ?reg . } graph ?link_a { ?_agent_iri ?reg ?space . } } union { graph ?role_a { ?role gen:hasInverseProperty ?inv . } graph ?link_a { ?space ?inv ?_agent_iri . } } } graph npa:graph { ?link_np np:hasAssertion ?link_a . ?link_np npa:hasValidSignatureForPublicKeyHash ?link_pubkey . filter not exists { ?link_npx npx:invalidates ?link_np ; npa:hasValidSignatureForPublicKeyHash ?link_pubkey . } } optional { graph npa:graph { ?space_np npx:introduces ?space . ?space_np npa:hasValidSignatureForPublicKeyHash ?space_pubkey . filter not exists { ?space_npx npx:invalidates ?space_np ; npa:hasValidSignatureForPublicKeyHash ?space_pubkey . } ?space_np rdfs:label ?space_label . } } } group by ?space ?space_label order by ?space_label" assertion.
- get-all-fdos 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: <http://schema.org/> select ?fdo ?np ?label ?profile ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . values ?type { <https://w3id.org/fdof/ontology#FAIRDigitalObject> <http://purl.org/nanopub/x/RoCrateNanopub> } ?np npx:hasNanopubType ?type . ?np npx:introduces ?fdo . ?np np:hasAssertion ?a . optional { ?np rdfs:label ?label } } graph ?a { { ?fdo dct:conformsTo ?profile . } union { ?meta dct:conformsTo ?profile . ?meta schema:about ?fdo . } } } order by desc(?date)" assertion.
- find-fdos 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: <http://schema.org/> prefix fdof: <https://w3id.org/fdof/ontology#> select ?fdo ?profile ?np ?label ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . values ?type { fdof:FAIRDigitalObject npx:RoCrateNanopub } ?np npx:hasNanopubType ?type . ?np npx:introduces ?fdo . ?np np:hasAssertion ?assertion . ?np rdfs:label ?label . filter(contains(lcase(?label), ?_query)) } graph ?assertion { { ?fdo dct:conformsTo ?profile . } union { ?metadata dct:conformsTo ?profile . ?metadata schema:about ?fdo . } } } order by desc(?date)" assertion.
- get-latest-nanopubs-from-pubkeys 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 ?pubkey ?date where { #==================== MULTI-VALUE PLACEHOLDER =====================#------ config: ------ { select ?pkh { # <- VAR pkh bind(?_pubkeyhashes as ?vs) # <- VAR _pubkeyhashes {select*{optional{<x:> <x:> <x:>}}} # (for some Virtuoso ver.) # 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 up to a maximum of 100 values) # bind(" " as ?sep) # (separator as single regex-compatible char) # <- CONST sep bind(concat("^([^",?sep,"]*",?sep,"){",str(?n),"}") as ?p) # bind(concat(?sep,".*") as ?p0) # filter(if(?n=0,true,regex(?vs,?p))) # (?n=0 check for Viruoso) # bind(replace(if(?n=0,?vs,replace(?vs,?p,"")),?p0,"") as ?pkh) # <- VAR pkh filter(!bound(?pkh) || exists {?any_np npa:hasValidSignatureForPublicKeyHash ?pkh }) # Filter out the hashes for which no repo exists; try to do this better with future versions of Nanopub Query } } # #==================================================================#--------------------- bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/pubkey/", ?pkh)) as ?pubkeyservice) service ?pubkeyservice { select ?np ?pubkey ?date ?label { { select ?np ?pubkey ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:created ?date . } } order by desc(?date) } graph npa:graph { ?np dct:creator ?__userid_iri . optional { ?np rdfs:label ?label } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } filter not exists { ?np npx:hasNanopubType npx:retracts . } } } limit 100 } } order by desc(?date) limit 100" assertion.
- get-newer-versions-of-np sparql "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/> select ?newerVersion ?date ?retractedBy ?supersededBy where { graph npa:graph { ?_np_iri npa:hasValidSignatureForPublicKey ?pubkey . } graph npa:networkGraph { ?newerVersion (npx:supersedes)* ?_np_iri . } graph npa:graph { filter exists { ?newerVersion npa:hasValidSignatureForPublicKey ?pubkey . } ?newerVersion dct:created ?date . } optional { graph npa:graph { ?retractedBy npx:retracts ?newerVersion ; npa:hasValidSignatureForPublicKey ?pubkey . } } optional { graph npa:graph { ?supersededBy npx:supersedes ?newerVersion ; npa:hasValidSignatureForPublicKey ?pubkey . } } } order by desc(?date) ?newerVersion" assertion.
- find_nanopubs_with_pattern 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 ?graphpred ?subj ?pred ?obj ?date ?pubkey where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?__pubkey . bind(?__pubkey as ?pubkey) filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . ?np ?__graphpred_iri ?g . bind(?__graphpred_iri as ?graphpred) values ?graphpred { np:hasAssertion np:hasProvenance np:hasPublicationInfo } } graph ?g { ?__subj_iri ?__pred_iri ?__obj_iri . bind(?__subj_iri as ?subj) bind(?__pred_iri as ?pred) bind(?__obj_iri as ?obj) } }" assertion.
- find_nanopubs_with_pattern 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 ?graphpred ?subj ?pred ?obj ?date ?pubkey where { graph ?g { ?__subj_iri ?__pred_iri ?__obj_iri . bind(?__subj_iri as ?subj) bind(?__pred_iri as ?pred) bind(?__obj_iri as ?obj) } graph npa:graph { ?np ?__graphpred_iri ?g . bind(?__graphpred_iri as ?graphpred) values ?graphpred { np:hasAssertion np:hasProvenance np:hasPublicationInfo } } graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?__pubkey . bind(?__pubkey as ?pubkey) filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . } }" assertion.
- find_nanopubs_with_pattern 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 ?graphpred ?subj ?pred ?obj ?date ?pubkey where { graph ?g { ?__subj_iri ?__pred_iri ?__obj_iri . bind(?__subj_iri as ?subj) bind(?__pred_iri as ?pred) bind(?__obj_iri as ?obj) } graph npa:graph { ?np ?__graphpred_iri ?g . bind(?__graphpred_iri as ?graphpred) values ?graphpred { np:hasAssertion np:hasProvenance np:hasPublicationInfo } } graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?__pubkey . bind(?__pubkey as ?pubkey) filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . } } limit 1000" assertion.
- find_valid_nanopubs_with_pattern 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 ?graphpred ?subj ?pred ?obj ?date ?pubkey where { graph ?g { ?__subj_iri ?__pred_iri ?__obj_iri . bind(?__subj_iri as ?subj) bind(?__pred_iri as ?pred) bind(?__obj_iri as ?obj) } graph npa:graph { ?np ?__graphpred_iri ?g . bind(?__graphpred_iri as ?graphpred) values ?graphpred { np:hasAssertion np:hasProvenance np:hasPublicationInfo } } graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?__pubkey . bind(?__pubkey as ?pubkey) filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . } } limit 1000" assertion.
- find_nanopubs_with_pattern 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 ?graphpred ?subj ?pred ?obj ?date ?pubkey where { graph ?g { ?__subj_iri ?__pred_iri ?__obj_iri . bind(?__subj_iri as ?subj) bind(?__pred_iri as ?pred) bind(?__obj_iri as ?obj) } graph npa:graph { ?np ?__graphpred_iri ?g . bind(?__graphpred_iri as ?graphpred) values ?graphpred { np:hasAssertion np:hasProvenance np:hasPublicationInfo } } graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?__pubkey . bind(?__pubkey as ?pubkey) ?np dct:created ?date . } } limit 1000" assertion.
- find-valid-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 ?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.
- 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 . ?np dct:created ?date . ?np npx:introduces|npx:describes ?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.
- find-valid-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 ?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.
- fulltext-search-on-labels-all 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 ?np ?label ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?__pubkey . optional { ?np rdfs:label ?label . } ?np dct:created ?date . } ?np search:matches [ search:query ?_query ; search:property rdfs:label ; search:score ?score ; search:snippet ?snippet ] . } limit 100" assertion.
- get-cite-nanopubs 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 ?creator ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np npx:hasNanopubType <http://purl.org/spar/cito/cites> . ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:signedBy ?creator . optional { ?np rdfs:label ?label } } } order by desc(?date)" assertion.
- get-latest-fers 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 where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . optional { ?np rdfs:label ?label } } } order by desc(?date) limit 10" assertion.
- get-leidenu-datasets sparql "prefix prov: <http://www.w3.org/ns/prov#> prefix schema: <https://schema.org/> 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 distinct ?dataset ?label ?repository where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np np:hasProvenance ?p . } graph ?a { ?dataset a <http://purl.org/dc/dcmitype/Dataset> . optional { ?dataset dct:title ?label . } optional { ?dataset schema:maintainer ?repository . } } graph ?p { ?a prov:wasAttributedTo <https://ror.org/027bh9e22> . } }" assertion.
- get-core-np-info 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 (coalesce(?signer, min(?declaredCreator)) as ?creator) (coalesce(?firstAuthor, min(?author), min(?creator)) as ?mainAuthor) (if(count(distinct ?author)>0,count(distinct ?author),count(distinct ?creator)) as ?authorCount) ?introducedThing ?label ?date where { graph npa:graph { bind(replace(str(<https://w3id.org/kpxl/pensoft/bdj/np/RAgwnIlPtxRUkDoaT2xei8lmhQniGaWwZAQgHsCHuuCAk>), "^.*[^a-zA-Z0-9-_](RA[a-zA-Z0-9-_]{43})$", "$1") as ?ac) ?np npa:artifactCode ?ac . optional {<x:> <x:> ?_np_iri} # for grlc to pick up the placeholder ?np npa:hasHeadGraph ?h . ?np dct:created ?date . ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np rdfs:label ?label . ?np np:hasPublicationInfo ?i . ?np dct:creator ?declaredCreator . optional { ?np npx:signedBy ?signer . } optional { ?np npx:introduces ?introducedThing . } } 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 ?signer ?introducedThing ?label ?date ?firstAuthor" assertion.
- get-core-np-info 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 (coalesce(?signer, min(?declaredCreator)) as ?creator) (coalesce(?firstAuthor, min(?author), min(?creator)) as ?mainAuthor) (if(count(distinct ?author)>0,count(distinct ?author),count(distinct ?creator)) as ?authorCount) ?introducedThing ?label ?date where { graph npa:graph { bind(replace(str(?_np_iri), "^.*[^a-zA-Z0-9-_](RA[a-zA-Z0-9-_]{43})$", "$1") as ?ac) ?np npa:artifactCode ?ac . optional {<x:> <x:> ?_np_iri} # for grlc to pick up the placeholder ?np npa:hasHeadGraph ?h . ?np dct:created ?date . ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np rdfs:label ?label . ?np np:hasPublicationInfo ?i . ?np dct:creator ?declaredCreator . optional { ?np npx:signedBy ?signer . } optional { ?np npx:introduces ?introducedThing . } } 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 ?signer ?introducedThing ?label ?date ?firstAuthor" assertion.
- get-templates-with-uri sparql "prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix dct: <http://purl.org/dc/terms/> 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 nt: <https://w3id.org/np/o/ntemplate/> select ?np ?npLabel ?date ?pubkey where { graph ?assertion { ?statement ?relation ?_thing_iri . values ?relation { rdf:subject rdf:predicate rdf:object nt:possibleValue } } graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np np:hasAssertion ?assertion . ?np dct:created ?date . optional { ?np rdfs:label ?npLabel } } } limit 1000" assertion.
- get-templates-with-uri sparql "prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix dct: <http://purl.org/dc/terms/> 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 nt: <https://w3id.org/np/o/ntemplate/> select distinct ?np ?npLabel ?date ?pubkey where { graph ?assertion { ?statement ?relation ?_thing_iri . values ?relation { rdf:subject rdf:predicate rdf:object nt:possibleValue } } graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np np:hasAssertion ?assertion . ?np dct:created ?date . optional { ?np rdfs:label ?npLabel } } } limit 1000" assertion.
- get-templates-with-uri sparql "prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix dct: <http://purl.org/dc/terms/> 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 nt: <https://w3id.org/np/o/ntemplate/> select distinct ?np ?npLabel ?date ?pubkey where { graph ?assertion { ?statement ?relation ?_thing_iri . values ?relation { rdf:subject rdf:predicate rdf:object nt:possibleValue } } graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } filter not exists { ?np npx:hasType nt:UnlistedTemplate . } ?np np:hasAssertion ?assertion . ?np dct:created ?date . optional { ?np rdfs:label ?npLabel } } } limit 1000" assertion.
- get-templates-with-uri sparql "prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix dct: <http://purl.org/dc/terms/> 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 nt: <https://w3id.org/np/o/ntemplate/> select distinct ?np ?npLabel ?date ?pubkey where { graph ?assertion { ?statement ?relation ?_thing_iri . values ?relation { rdf:subject rdf:predicate rdf:object nt:possibleValue } } graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } filter not exists { ?np npx:hasNanopubType nt:UnlistedTemplate . } ?np np:hasAssertion ?assertion . ?np dct:created ?date . optional { ?np rdfs:label ?npLabel } } } limit 1000" 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.
- get-nanopubs-for-pubkey sparql "prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select ?np where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?_pubkeyhash . } }" assertion.
- get-nanopubs-for-pubkey-and-type sparql "prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select distinct ?np where { { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?_pubkeyhash . ?np npx:hasNanopubType ?__type_iri . } } union { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?_pubkeyhash . ?np npx:invalidates ?npx . ?npx npx:hasNanopubType ?__type_iri . } } }" assertion.
- get-nanopubs-for-pubkey-and-type sparql "prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select distinct ?np where { { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?_pubkeyhash . ?np npx:hasNanopubType ?_type_iri . } } union { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?_pubkeyhash . ?np npx:invalidates ?npx . ?npx npx:hasNanopubType ?_type_iri . } } }" assertion.
- get-highlighted-implied-relations sparql "prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 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 oa: <http://www.w3.org/ns/oa#> select ?subject ?predicate ?object ?source ?np ?label ?annotator ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:introduces ?annotation . ?np npx:signedBy ?annotator . optional { ?np rdfs:label ?label } } graph ?a { ?annotation a oa:Annotation . ?annotation oa:motivatedBy oa:highlighting . ?annotation oa:hasTarget ?target . optional { ?target oa:hasSource ?sourcex . } bind(coalesce(?sourcex, ?target) as ?source) ?annotation oa:hasBody ?relation . ?relation rdf:subject ?subject . ?relation rdf:predicate ?predicate . ?relation rdf:object ?object . } } order by desc(?date)" assertion.
- testing... sparql "prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 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 oa: <http://www.w3.org/ns/oa#> select ?subject ?predicate ?object ?source ?np ?label ?annotator ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:introduces ?annotation . ?np npx:signedBy ?annotator . optional { ?np rdfs:label ?label } } graph ?a { ?annotation a oa:Annotation . ?annotation oa:motivatedBy oa:highlighting . ?annotation oa:hasTarget ?target . optional { ?target oa:hasSource ?sourcex . } bind(coalesce(?sourcex, ?target) as ?source) ?annotation oa:hasBody ?relation . ?relation rdf:subject ?subject . ?relation rdf:predicate ?predicate . ?relation rdf:object ?object . } } order by desc(?date)" assertion.
- testing... sparql "prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 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 oa: <http://www.w3.org/ns/oa#> select ?subject ?predicate ?object ?source ?np ?label ?annotator ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:introduces ?annotation . ?np npx:signedBy ?annotator . optional { ?np rdfs:label ?label } } graph ?a { ?annotation a oa:Annotation . ?annotation oa:motivatedBy oa:highlighting . ?annotation oa:hasTarget ?target . optional { ?target oa:hasSource ?sourcex . } bind(coalesce(?sourcex, ?target) as ?source) ?annotation oa:hasBody ?relation . ?relation rdf:subject ?subject . ?relation rdf:predicate ?predicate . ?relation rdf:object ?object . } } order by desc(?date)" assertion.
- testing... sparql "prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 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 oa: <http://www.w3.org/ns/oa#> select ?subject ?predicate ?object ?source ?np ?label ?annotator ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:introduces ?annotation . ?np npx:signedBy ?annotator . optional { ?np rdfs:label ?label } } graph ?a { ?annotation a oa:Annotation . ?annotation oa:motivatedBy oa:highlighting . ?annotation oa:hasTarget ?target . optional { ?target oa:hasSource ?sourcex . } bind(coalesce(?sourcex, ?target) as ?source) ?annotation oa:hasBody ?relation . ?relation rdf:subject ?subject . ?relation rdf:predicate ?predicate . ?relation rdf:object ?object . } } order by desc(?date)" assertion.
- testing sparql "prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 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 oa: <http://www.w3.org/ns/oa#> select ?subject ?predicate ?object ?source ?np ?label ?annotator ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:introduces ?annotation . ?np npx:signedBy ?annotator . optional { ?np rdfs:label ?label } } graph ?a { ?annotation a oa:Annotation . ?annotation oa:motivatedBy oa:highlighting . ?annotation oa:hasTarget ?target . optional { ?target oa:hasSource ?sourcex . } bind(coalesce(?sourcex, ?target) as ?source) ?annotation oa:hasBody ?relation . ?relation rdf:subject ?subject . ?relation rdf:predicate ?predicate . ?relation rdf:object ?object . } } order by desc(?date)" assertion.
- testing sparql "prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 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 oa: <http://www.w3.org/ns/oa#> select ?subject ?predicate ?object ?source ?np ?label ?annotator ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:introduces ?annotation . ?np npx:signedBy ?annotator . optional { ?np rdfs:label ?label } } graph ?a { ?annotation a oa:Annotation . ?annotation oa:motivatedBy oa:highlighting . ?annotation oa:hasTarget ?target . optional { ?target oa:hasSource ?sourcex . } bind(coalesce(?sourcex, ?target) as ?source) ?annotation oa:hasBody ?relation . ?relation rdf:subject ?subject . ?relation rdf:predicate ?predicate . ?relation rdf:object ?object . } } order by desc(?date)" assertion.
- testing sparql "prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 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 oa: <http://www.w3.org/ns/oa#> select ?subject ?predicate ?object ?source ?np ?label ?annotator ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:introduces ?annotation . ?np npx:signedBy ?annotator . optional { ?np rdfs:label ?label } } graph ?a { ?annotation a oa:Annotation . ?annotation oa:motivatedBy oa:highlighting . ?annotation oa:hasTarget ?target . optional { ?target oa:hasSource ?sourcex . } bind(coalesce(?sourcex, ?target) as ?source) ?annotation oa:hasBody ?relation . ?relation rdf:subject ?subject . ?relation rdf:predicate ?predicate . ?relation rdf:object ?object . } } order by desc(?date)" assertion.
- get-term-definitions 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 ?creator ?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|npx:describes|npx:embeds ?_term_iri . optional { ?np rdfs:label ?label . } optional { ?np npx:signedBy ?creator . } } } 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 . filter not exists { ?thing npx:hasNanopubType nt:UnlistedTemplate . } ?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-term-definitions 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 ?npLabel ?creator ?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|npx:describes|npx:embeds ?_term_iri . optional { ?np rdfs:label ?npLabel . } optional { ?np npx:signedBy ?creator . } } } order by desc(?date)" assertion.
- get-maintained-resources 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 ?resource ?label ?np ?pubkey ?date where { graph npa:graph { ?np npx:hasNanopubType gen:MaintainedResource . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?resource . optional { ?np rdfs:label ?label } } } order by desc(?date)" assertion.
- get-maintained-resources 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 ?resource ?label ?space ?np ?pubkey ?date where { graph npa:graph { ?np npx:hasNanopubType gen:MaintainedResource . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?resource . ?np np:hasAssertion ?a . optional { ?np rdfs:label ?label } } graph ?a { ?resource gen:isMaintainedBy ?space . } } order by desc(?date)" assertion.
- get-classes-of-ontology sparql "prefix owl: <http://www.w3.org/2002/07/owl#> 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 ?class ?label ?np ?pubkey ?date where { values ?_ontology_multi_iri {} graph npa:graph { ?np npx:hasNanopubType owl:Class . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?class . ?np np:hasAssertion ?a . optional { ?np rdfs:label ?label } } graph ?a { ?class dct:partOf ?_ontology_multi_iri . } } order by desc(?date)" assertion.
- get-views-for-resource 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 ?view ?label ?np ?pubkey ?date where { values ?_resource_multi_iri {} graph npa:graph { ?np npx:hasNanopubType gen:hasView . ?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 { ?_resource_multi_iri gen:hasView ?view . } } order by desc(?date)" assertion.
- get-all-fsr 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 ?thing ?label ?description (group_concat(distinct ?type; separator=" ") as ?types) ?np ?date 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 . 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 np:hasAssertion ?a . } graph ?a { ?thing rdfs:comment ?description . } filter not exists { graph npa:graph { ?disapproval_np npx:hasNanopubType <http://purl.org/nanopub/x/disapprovesOf> . ?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 ?description ?label ?date order by ?label" assertion.
- get-view-displays 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 ?view ?label ?np ?pubkey ?date where { values ?_resource_multi_iri {} graph npa:graph { ?np npx:hasNanopubType gen:ViewDisplay . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:embeds ?display . ?np np:hasAssertion ?a . optional { ?np rdfs:label ?label } } graph ?a { ?display gen:isDisplayOfView ?view . ?display gen:isDisplayFor ?_resource_multi_iri . } } order by desc(?date)" assertion.
- get-messages-about-resource 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 . values ?_resource_multi_iri {} ?a schema:about ?_resource_multi_iri . } } order by desc(?date)" assertion.
- get-view-displays 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 ?view ?label ?np ?pubkey ?date where { values ?_resource_multi_iri {} graph npa:graph { ?np npx:hasNanopubType gen:ViewDisplay . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:embeds ?display . ?np np:hasAssertion ?a . optional { ?np rdfs:label ?label } } graph ?a { ?display gen:isDisplayOfView ?view . ?display gen:isDisplayFor ?_resource_multi_iri . } } order by desc(?date)" assertion.
- get-maintained-resources 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 ?resource ?label (?_space_multi_iri as ?space) ?np ?pubkey ?date where { values ?_space_multi_iri {} graph npa:graph { ?np npx:hasNanopubType gen:MaintainedResource . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?resource . ?np np:hasAssertion ?a . optional { ?np rdfs:label ?label } } graph ?a { ?resource gen:isMaintainedBy ?_space_multi_iri . } } order by desc(?date)" assertion.
- get-maintained-resources 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 ?resource ?label (?__space_multi_iri as ?space) ?np ?pubkey ?date where { values ?_space_multi_iri {} graph npa:graph { ?np npx:hasNanopubType gen:MaintainedResource . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?resource . ?np np:hasAssertion ?a . optional { ?np rdfs:label ?label } } graph ?a { ?resource gen:isMaintainedBy ?__space_multi_iri . } } order by desc(?date)" assertion.
- get-maintained-resources 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 ?resource ?label (?__space_multi_iri as ?space) ?np ?pubkey ?date where { values ?__space_multi_iri {} graph npa:graph { ?np npx:hasNanopubType gen:MaintainedResource . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?resource . ?np np:hasAssertion ?a . optional { ?np rdfs:label ?label } } graph ?a { ?resource gen:isMaintainedBy ?__space_multi_iri . } } order by desc(?date)" assertion.
- get-classes-of-ontology sparql "prefix owl: <http://www.w3.org/2002/07/owl#> 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 ?class ?label ?np ?date where { values ?_ontology_multi_iri {} graph npa:graph { ?np npx:hasNanopubType owl:Class . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?class . ?np np:hasAssertion ?a . } graph ?a { ?class dct:partOf ?_ontology_multi_iri . optional { ?class rdfs:label ?label . } } } order by desc(?date)" assertion.
- get-properties-of-ontology sparql "prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix owl: <http://www.w3.org/2002/07/owl#> 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 ?property ?label ?domain ?range ?np ?date where { values ?_ontology_multi_iri {} graph npa:graph { ?np npx:hasNanopubType rdf:Property . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?property . ?np np:hasAssertion ?a . } graph ?a { ?property dct:partOf ?_ontology_multi_iri . optional { ?property rdfs:label ?label . } optional { ?property rdfs:domain ?domain . } optional { ?property rdfs:range ?range . } } } order by desc(?date)" assertion.
- get-properties-of-ontology sparql "prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix owl: <http://www.w3.org/2002/07/owl#> 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 skos: <http://www.w3.org/2004/02/skos/core#> select ?property ?label ?domain ?range (?definition as ?description) ?np where { values ?_ontology_multi_iri {} graph npa:graph { ?np npx:hasNanopubType rdf:Property . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?property . ?np np:hasAssertion ?a . } graph ?a { ?property dct:partOf ?_ontology_multi_iri . optional { ?property skos:definition ?definition . } optional { ?property rdfs:label ?label . } optional { ?property rdfs:domain ?domain . } optional { ?property rdfs:range ?range . } } } order by ?label" assertion.
- get-classes-of-ontology sparql "prefix owl: <http://www.w3.org/2002/07/owl#> 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 skos: <http://www.w3.org/2004/02/skos/core#> select ?class ?label (?definition as ?description) ?np where { #values ?_ontology_multi_iri {} graph npa:graph { ?np npx:hasNanopubType owl:Class . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?class . ?np np:hasAssertion ?a . } graph ?a { ?class dct:partOf ?_ontology_multi_iri . optional { ?class rdfs:label ?label . } optional { ?class skos:definition ?definition . } } } order by ?label" assertion.
- get-classes-of-ontology sparql "prefix owl: <http://www.w3.org/2002/07/owl#> 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 skos: <http://www.w3.org/2004/02/skos/core#> select ?class ?label (?definition as ?description) ?np where { values ?_ontology_multi_iri {} graph npa:graph { ?np npx:hasNanopubType owl:Class . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?class . ?np np:hasAssertion ?a . } graph ?a { ?class dct:partOf ?_ontology_multi_iri . optional { ?class rdfs:label ?label . } optional { ?class skos:definition ?definition . } } } order by ?label" assertion.
- get-maintained-resources 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 ?resource ?label (?__space_multi_iri as ?space) ?namespace ?np ?pubkey ?date where { values ?__space_multi_iri {} graph npa:graph { ?np npx:hasNanopubType gen:MaintainedResource . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?resource . ?np np:hasAssertion ?a . optional { ?np rdfs:label ?label } } graph ?a { ?resource gen:isMaintainedBy ?__space_multi_iri . optional { ?resource gen:hasNamespace ?namespace . } } } order by desc(?date)" assertion.
- get-term-definitions 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 ?npLabel ?creator ?date where { values ?__pubkey {} graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?__pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?__pubkey . } ?np dct:created ?date . ?np npx:introduces|npx:describes|npx:embeds ?_term_iri . optional { ?np rdfs:label ?npLabel . } optional { ?np npx:signedBy ?creator . } } } order by desc(?date)" assertion.
- get-term-definitions 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 ?npLabel ?creator ?date where { values ?__pubkey_multi {} graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?__pubkey_multi . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?__pubkey_multi . } ?np dct:created ?date . ?np npx:introduces|npx:describes|npx:embeds ?_term_iri . optional { ?np rdfs:label ?npLabel . } optional { ?np npx:signedBy ?creator . } } } order by desc(?date)" assertion.
- get-intro-relations 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 ?pred ?obj where { bind(?_resourceNp_iri as ?np) graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np np:hasAssertion ?a . ?np npx:introduces ?_resource_iri . } graph ?a { ?_resource_iri ?pred ?obj . } }" assertion.
- get-view-displays 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 ?view ?label ?displayType ?np ?pubkey ?date where { values ?_resource_multi_iri {} graph npa:graph { ?np npx:hasNanopubType gen:ViewDisplay . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:embeds ?display . ?np np:hasAssertion ?a . optional { ?np rdfs:label ?label } } graph ?a { ?display gen:isDisplayOfView ?view . ?display gen:isDisplayFor ?_resource_multi_iri . optional { values ?displayType { gen:PartLevelViewDisplay gen:TopLevelViewDisplay } ?display a ?displayType . } } } order by desc(?date)" 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(strstarts(str(?__type_iri), "https://w3id.org/kpxl/gen/terms/")) 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-concepts-of-skos-scheme sparql "prefix owl: <http://www.w3.org/2002/07/owl#> 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 skos: <http://www.w3.org/2004/02/skos/core#> select ?concept ?label (?definition as ?description) ?np where { values ?_scheme_multi_iri {} graph npa:graph { ?np npx:hasNanopubType skos:Concept . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?concept . ?np np:hasAssertion ?a . } graph ?a { ?concept skos:inScheme ?_scheme_multi_iri . optional { ?concept skos:prefLabel ?label . } optional { ?concept skos:definition ?definition . } } } order by ?label" assertion.
- get-concepts-of-skos-scheme sparql "prefix owl: <http://www.w3.org/2002/07/owl#> 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 skos: <http://www.w3.org/2004/02/skos/core#> select ?concept ?label ?broaderConcept (?definition as ?description) ?np (group_concat(?flagLabel; separator=" ") as ?flags) where { values ?_scheme_multi_iri {} graph npa:graph { ?np npx:hasNanopubType skos:Concept . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?concept . ?np np:hasAssertion ?a . } optional { graph npa:graph { values (?flag ?flagLabel) { ( npx:ExampleNanopub "Example") ( npx:DraftNanopub "Draft") } ?np npx:hasNanopubType ?flag . } } graph ?a { ?concept skos:inScheme ?_scheme_multi_iri . optional { ?concept skos:broader ?broaderConcept . } optional { ?concept skos:prefLabel ?label . } optional { ?concept skos:definition ?definition . } } } group by ?concept ?label ?broaderConcept ?definition ?np order by ?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) (sample(?fairAssessmentLevel) as ?fairAssessmentLevel) (sample(?fairAssessmentLevelNp) as ?fairAssessmentLevelNp) 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 { ?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 . #} } 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 { ?fairAssessmentLevelNp npx:hasNanopubType fip:has-FAIR-assessment . ?fairAssessmentLevelNp npa:hasValidSignatureForPublicKey ?lpubkey . } graph ?latest_curators_assertion { ?lpubkeys npx:hasPublicKey ?lpubkey . } graph npa:graph { filter not exists { ?fairAssessmentLevelNp_x npx:invalidates ?fairAssessmentLevelNp ; npa:hasValidSignatureForPublicKey ?lpubkey . } ?fairAssessmentLevelNp np:hasAssertion ?la . } graph ?la { ?thing fip:has-FAIR-assessment ?fairAssessmentLevel . } } filter(!bound(?levelNp)) # Faster than "filter not exists" for some reason } group by ?thing ?label ?description ?np ?date ?pubkey ?retraction ?newversion ?qualifier ?qualification_np order by desc(?recommender_count) asc(?label)" assertion.
- get-dggs-nanopubs 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 distinct ?np ?pubkey ?date ?label ?title ?text ?supersedes ?supersedes_count where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . # Valid signature and not invalidated filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey_inv . } # This is the LATEST version (nothing supersedes it) filter not exists { ?newer_np npx:supersedes ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey_super . } # Not retracted filter not exists { ?retraction_np npx:retracts ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey_ret . } ?np dct:created ?date . ?np np:hasAssertion ?a . } # Check if this nanopub supersedes others (to show version history) optional { graph npa:graph { ?np npx:supersedes ?supersedes . } } graph ?a { ?s ?p ?o . filter( isLiteral(?o) && regex(str(?o), "DGGS|Discrete Global Grid|discrete global grid", "i") ) } optional { graph ?a { ?s rdfs:label ?label } } optional { graph ?a { ?s dct:title ?title } } bind(?o as ?text) } order by desc(?date)" assertion.
- get-dggs-nanopubs 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 ?pubkey ?date (sample(?label) as ?label) (sample(?title) as ?title) (sample(?text) as ?text) (sample(?supersedes) as ?supersedes) where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey_inv . } filter not exists { ?newer_np npx:supersedes ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey_super . } filter not exists { ?retraction_np npx:retracts ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey_ret . } ?np dct:created ?date . ?np np:hasAssertion ?a . } optional { graph npa:graph { ?np npx:supersedes ?supersedes . } } graph ?a { ?s ?p ?o . filter( isLiteral(?o) && regex(str(?o), "DGGS|Discrete Global Grid|discrete global grid", "i") ) } optional { graph ?a { ?s rdfs:label ?label } } optional { graph ?a { ?s dct:title ?title } } bind(?o as ?text) } group by ?np ?pubkey ?date order by desc(?date)" assertion.
- sparql-construct-query-test 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/> construct { ?np rdfs:label ?label . } where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np rdfs:label ?label . } } limit 10" assertion.
- get-coauthors 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 fabio: <http://purl.org/spar/fabio/> prefix bibo: <http://purl.org/ontology/bibo/> prefix foaf: <http://xmlns.com/foaf/0.1/> select ?coauthor_id ?coauthor_label (count(distinct ?paper) as ?paper_count) where { values ?_author_multi_iri {} graph npa:graph { ?np npx:hasNanopubType fabio:ScholarlyWork . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:introduces ?paper . } graph ?a { ?paper dct:title ?paper_label . ?paper bibo:authorList ?author_list . ?paper dct:date ?publication_date . ?author_list ?rdfseqpred1 ?_author_multi_iri . filter(strstarts(str(?rdfseqpred1), "http://www.w3.org/1999/02/22-rdf-syntax-ns#_")) ?author_list ?rdfseqpred2 ?coauthor . filter(strstarts(str(?rdfseqpred2), "http://www.w3.org/1999/02/22-rdf-syntax-ns#_")) ?coauthor foaf:name ?coauthor_label . bind(if(strstarts(str(?coauthor), "https://orcid.org/"), ?coauthor, ?coauthor_label) as ?coauthor_id) filter(?coauthor != ?_author_multi_iri) optional { ?paper dct:isPartOf ?journal . ?journal dct:title ?journal_label . } } } group by ?coauthor_id ?coauthor_label order by desc(?paper_count)" assertion.
- get-coauthors 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 fabio: <http://purl.org/spar/fabio/> prefix bibo: <http://purl.org/ontology/bibo/> prefix foaf: <http://xmlns.com/foaf/0.1/> select ?coauthor ?coauthor_label (count(distinct ?paper) as ?paper_count) where { values ?_author_multi_iri {} graph npa:graph { ?np npx:hasNanopubType fabio:ScholarlyWork . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:introduces ?paper . } graph ?a { ?paper dct:title ?paper_label . ?paper bibo:authorList ?author_list . ?paper dct:date ?publication_date . ?author_list ?rdfseqpred1 ?_author_multi_iri . filter(strstarts(str(?rdfseqpred1), "http://www.w3.org/1999/02/22-rdf-syntax-ns#_")) ?author_list ?rdfseqpred2 ?coauthor_id . filter(strstarts(str(?rdfseqpred2), "http://www.w3.org/1999/02/22-rdf-syntax-ns#_")) ?coauthor_id foaf:name ?coauthor_label . bind(if(strstarts(str(?coauthor_id), "https://orcid.org/"), ?coauthor_id, ?coauthor_label) as ?coauthor) filter(?coauthor_id != ?_author_multi_iri) optional { ?paper dct:isPartOf ?journal . ?journal dct:title ?journal_label . } } } group by ?coauthor ?coauthor_label order by desc(?paper_count)" assertion.
- get-iadopt-variable-definition 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 iadopt: <https://w3id.org/iadopt/ont/> construct { ?subj ?pred ?obj . } where { graph npa:graph { ?np npx:introduces ?_variable_iri . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . filter not exists { ?np2 npx:introduces ?_variable_iri . ?np2 npa:hasValidSignatureForPublicKeyHash ?pubkey2 . filter not exists { ?np2x npx:invalidates ?np2 ; npa:hasValidSignatureForPublicKeyHash ?pubkey2 . } ?np2 dct:created ?date2 . filter(?date2 > ?date) } } graph npa:graph { ?np np:hasAssertion ?a . } graph ?a { ?subj ?pred ?obj . } } order by ?subj ?pred ?obj" 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) (count(distinct ?community) as ?community_count) 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 order by desc(?community_count)" assertion.
- get-planned-event-attendances 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/> prefix schema: <http://schema.org/> select ?event ?event_label ?date ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType gen:plansToAttend . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np npx:signedBy ?_user_iri . ?np np:hasAssertion ?a . } graph ?a { ?_user_iri gen:plansToAttend ?event . optional { ?event rdfs:label ?event_label } optional { ?event dct:date ?date1 } } optional { bind(iri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(gen:Space)))) as ?space_repo) service ?space_repo { graph npa:graph { ?nps npx:introduces ?event . ?nps npa:hasValidSignatureForPublicKeyHash ?pks . filter not exists { ?npsx npx:invalidates ?nps ; npa:hasValidSignatureForPublicKeyHash ?pks . } ?nps np:hasAssertion ?as . } graph ?as { ?event schema:startDate ?datetime . bind(xsd:date(substr(str(?datetime), 0, 11)) as ?date2) } } } bind(coalesce(?date1, ?date2) as ?date) } order by desc(?date)" assertion.
- get-planned-event-attendances 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/> prefix schema: <http://schema.org/> select distinct ?event ?event_label ?date ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType gen:plansToAttend . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np npx:signedBy ?_user_iri . ?np np:hasAssertion ?a . } graph ?a { ?_user_iri gen:plansToAttend ?event . optional { ?event rdfs:label ?event_label } optional { ?event dct:date ?date1 } } optional { bind(iri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(gen:Space)))) as ?space_repo) service ?space_repo { graph npa:graph { ?nps npx:introduces ?event . ?nps npa:hasValidSignatureForPublicKeyHash ?pks . filter not exists { ?npsx npx:invalidates ?nps ; npa:hasValidSignatureForPublicKeyHash ?pks . } ?nps np:hasAssertion ?as . } graph ?as { ?event schema:startDate ?datetime . bind(xsd:date(substr(str(?datetime), 0, 11)) as ?date2) } } } bind(coalesce(?date1, ?date2) as ?date) } order by desc(?date)" assertion.
- get-search-strategies 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 sl: <https://w3id.org/sciencelive/o/terms/> select ?searchStrategy ?searchStrategy_label ?creator ?date ?np where { graph npa:graph { ?np npx:hasNanopubType sl:SystematicReviewSearchStrategy . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:signedBy ?creator . ?np npx:introduces ?searchStrategy . ?np rdfs:label ?searchStrategy_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) (sample(?fairAssessmentLevel) as ?fairAssessmentLevel) (sample(?fairAssessmentLevelNp) as ?fairAssessmentLevelNp) 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 . } } optional { graph npa:graph { ?fairAssessmentLevelNp npa:hasValidSignatureForPublicKey ?lpubkey . } graph ?latest_curators_assertion { ?lpubkeys npx:hasPublicKey ?lpubkey . } graph npa:graph { filter not exists { ?fairAssessmentLevelNp_x npx:invalidates ?fairAssessmentLevelNp ; npa:hasValidSignatureForPublicKey ?lpubkey . } ?fairAssessmentLevelNp np:hasAssertion ?la . } graph ?la { ?thing fip:has-FAIR-assessment ?fairAssessmentLevel . } } filter(!bound(?levelNp)) # Faster than "filter not exists" for some reason } 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) (sample(?fairAssessmentLevel) as ?fairAssessmentLevel) (sample(?fairAssessmentLevelNp) as ?fairAssessmentLevelNp) 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 . } } optional { graph npa:graph { ?fairAssessmentLevelNp npx:hasNanopubType fip:has-FAIR-assessment . ?fairAssessmentLevelNp npa:hasValidSignatureForPublicKey ?lpubkey . } graph ?latest_curators_assertion { ?lpubkeys npx:hasPublicKey ?lpubkey . } graph npa:graph { filter not exists { ?fairAssessmentLevelNp_x npx:invalidates ?fairAssessmentLevelNp ; npa:hasValidSignatureForPublicKey ?lpubkey . } ?fairAssessmentLevelNp np:hasAssertion ?la . } graph ?la { ?thing fip:has-FAIR-assessment ?fairAssessmentLevel . } } filter(!bound(?levelNp)) # Faster than "filter not exists" for some reason } group by ?thing ?label ?description ?np ?date ?pubkey ?retraction ?newversion ?qualifier ?qualification_np order by desc(?recommender_count) asc(?label)" assertion.
- pico-question-population-query 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 pico: <http://data.cochrane.org/ontologies/pico/> select ?question ?populationDescription ?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 np:hasAssertion ?a . ?np npx:introduces ?question . ?np npx:signedBy ?creator . optional { ?np rdfs:label ?label } } graph ?a { ?question pico:population ?population . ?population dct:description ?populationDescription . } filter(contains(?populationDescription, ?_populationQuery)) }" assertion.
- get-research-questions-for-systematic-review 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 sl: <https://w3id.org/sciencelive/o/terms/> select ?systematicReview ?researchQuestion ?label ?np ?pubkey ?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 npx:signedBy ?creator . ?np np:hasAssertion ?a . optional { ?np rdfs:label ?label } } values ?_systematicReview_multi_iri {} graph ?a { ?_systematicReview_multi_iri sl:targetsResearchQuestion ?researchQuestion . } }" assertion.
- get-research-questions-for-systematic-review 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 sl: <https://w3id.org/sciencelive/o/terms/> select ?researchQuestion ?creator ?np ?date where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:signedBy ?creator . ?np np:hasAssertion ?a . optional { ?np rdfs:label ?label } } values ?_systematicReview_multi_iri {} graph ?a { ?_systematicReview_multi_iri sl:targetsResearchQuestion ?researchQuestion . } }" assertion.
- get-search-strategy-for-systematic-review 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 sl: <https://w3id.org/sciencelive/o/terms/> select ?searchStrategy ?searchStrategy_label ?creator ?date ?np where { graph npa:graph { ?np npx:hasNanopubType sl:SystematicReviewSearchStrategy . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:signedBy ?creator . ?np npx:introduces ?searchStrategy . ?np rdfs:label ?searchStrategy_label . ?np np:hasAssertion ?a . } values ?_systematicReview_multi_iri {} graph ?a { ?searchStrategy dct:isPartOf ?_systematicReview_multi_iri . }" assertion.
- get-search-strategy-for-systematic-review 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 sl: <https://w3id.org/sciencelive/o/terms/> select ?searchStrategy ?searchStrategy_label ?creator ?date ?np where { graph npa:graph { ?np npx:hasNanopubType sl:SystematicReviewSearchStrategy . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:signedBy ?creator . ?np npx:introduces ?searchStrategy . ?np rdfs:label ?searchStrategy_label . ?np np:hasAssertion ?a . } values ?_systematicReview_multi_iri {} graph ?a { ?searchStrategy dct:isPartOf ?_systematicReview_multi_iri . } }" 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.
- get-latest-nanopubs-from-pubkeys 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 ?pubkey ?date where { #==================== MULTI-VALUE PLACEHOLDER =====================#------ config: ------ { select ?pkh { # <- VAR pkh bind(?_pubkeyhashes as ?vs) # <- VAR _pubkeyhashes {select*{optional{?a ?b ?c}}limit 1} # (for some Virtuoso ver.) # 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 up to a maximum of 100 values) # bind(" " as ?sep) # (separator as single regex-compatible char) # <- CONST sep bind(concat("^([^",?sep,"]*",?sep,"){",str(?n),"}") as ?p) # bind(concat(?sep,".*") as ?p0) # filter(if(?n=0,true,regex(?vs,?p))) # (?n=0 check for Viruoso) # bind(replace(if(?n=0,?vs,replace(?vs,?p,"")),?p0,"") as ?pkh) # <- VAR pkh } } # #==================================================================#--------------------- bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/pubkey/", ?pkh)) as ?service) service ?service { graph npa:graph { ?np rdfs:label ?label ; npa:hasValidSignatureForPublicKey ?pubkey ; dct:created ?date . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkeyx . filter(contains(?_pubkeyhashes, sha256(str(?pubkeyx)))) } filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?np npx:hasNanopubType npx:retracts . } } } } order by desc(?date) limit 100" assertion.
- get-latest-nanopubs-from-pubkeys 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 ?pubkey ?date where { #==================== MULTI-VALUE PLACEHOLDER =====================#------ config: ------ { select ?pkh { # <- VAR pkh bind(?_pubkeyhashes as ?vs) # <- VAR _pubkeyhashes {select*{optional{?a ?b ?c}}limit 1} # (for some Virtuoso ver.) # 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 up to a maximum of 100 values) # bind(" " as ?sep) # (separator as single regex-compatible char) # <- CONST sep bind(concat("^([^",?sep,"]*",?sep,"){",str(?n),"}") as ?p) # bind(concat(?sep,".*") as ?p0) # filter(if(?n=0,true,regex(?vs,?p))) # (?n=0 check for Viruoso) # bind(replace(if(?n=0,?vs,replace(?vs,?p,"")),?p0,"") as ?pkh) # <- VAR pkh } } # #==================================================================#--------------------- bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/pubkey/", ?pkh)) as ?service) service ?service { graph npa:graph { ?np rdfs:label ?label ; npa:hasValidSignatureForPublicKey ?pubkey ; dct:created ?date . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkeyx . filter(contains(?_pubkeyhashes, sha256(str(?pubkeyx)))) } filter not exists { ?np npx:hasNanopubType npx:retracts . } } } } order by desc(?date) limit 100" assertion.
- get-latest-nanopubs-from-pubkeys 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 ?pubkey ?date where { #==================== MULTI-VALUE PLACEHOLDER =====================#------ config: ------ { select ?pkh { # <- VAR pkh bind(?_pubkeyhashes as ?vs) # <- VAR _pubkeyhashes {select*{optional{?a ?b ?c}}limit 1} # (for some Virtuoso ver.) # 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 up to a maximum of 100 values) # bind(" " as ?sep) # (separator as single regex-compatible char) # <- CONST sep bind(concat("^([^",?sep,"]*",?sep,"){",str(?n),"}") as ?p) # bind(concat(?sep,".*") as ?p0) # filter(if(?n=0,true,regex(?vs,?p))) # (?n=0 check for Viruoso) # bind(replace(if(?n=0,?vs,replace(?vs,?p,"")),?p0,"") as ?pkh) # <- VAR pkh } } # #==================================================================#--------------------- bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/pubkey/", ?pkh)) as ?service) service ?service { 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 ?pubkeyx . filter(contains(?_pubkeyhashes, sha256(str(?pubkeyx)))) } filter not exists { ?np npx:hasNanopubType npx:retracts . } } } } 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 10" assertion.
- get-latest-accepted 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 ?np ?label ?npType ?mainAuthor ?authorEtAl ?timestamp ?date where { values ?npType { <https://w3id.org/kpxl/pensoft/rio/terms/RIOJournalNanopub> <https://w3id.org/kpxl/pensoft/bdj/terms/BiodiversityDataJournalNanopub> <https://w3id.org/kpxl/ios/ds/terms/DataScienceNanopub> } bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(?npType)))) as ?service) service ?service { 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-accepted 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 ?np ?label ?npType ?mainAuthor ?authorEtAl ?timestamp ?date where { values ?npType { <https://w3id.org/kpxl/pensoft/rio/terms/RIOJournalNanopub> <https://w3id.org/kpxl/pensoft/bdj/terms/BiodiversityDataJournalNanopub> <https://w3id.org/kpxl/ios/ds/terms/DataScienceNanopub> } bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(?npType)))) as ?service) service ?service { 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-top-creators-last30d 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 distinct ?userid (count(distinct ?np) as ?count) where { { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:creator ?userid . } } union { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np np:hasAssertion ?assertion . ?np np:hasProvenance ?prov . } graph ?prov { ?assertion prov:wasAttributedTo ?userid . } } filter(strstarts(str(?userid), "https://orcid.org/")) } group by ?userid order by desc(?count) limit 10" assertion.
- get-top-templates-last30d 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 nt: <https://w3id.org/np/o/ntemplate/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> select distinct ?template (count(distinct ?np) as ?count) where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np np:hasPublicationInfo ?i . } graph ?i { ?np nt:wasCreatedFromTemplate ?template . } } group by ?template order by desc(?count) limit 10" assertion.
- get-accepted-nanopubs-by-author 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 nt: <https://w3id.org/np/o/ntemplate/> prefix bibo: <http://purl.org/ontology/bibo/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> select ?np ?label ?npType ?timestamp where { values ?npType { <https://w3id.org/kpxl/pensoft/rio/terms/RIOJournalNanopub> <https://w3id.org/kpxl/pensoft/bdj/terms/BiodiversityDataJournalNanopub> <https://w3id.org/kpxl/ios/ds/terms/DataScienceNanopub> } bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(?npType)))) as ?service) service ?service { select distinct ?np ?label ?timestamp 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 . } } graph ?i { ?np bibo:authorList ?authorList . ?authorList ?hasElement ?_author_iri . filter(strstarts(str(?hasElement), str(rdf:_))) } } group by ?np ?label ?timestamp } } order by desc(?timestamp)" assertion.