Matches in Nanopublications for { ?s <https://w3id.org/kpxl/grlc/sparql> ?o ?g. }
- get-ai-in-edu-approaches 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 ?approach ?approach_label ?class ?reference ?reference_label ?creator ?date ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType <https://w3id.org/spaces/AI-in-education/r/terms/AI-in-Education-approach> . ?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 . ?np npx:introduces ?approach . } graph ?a { ?approach a <https://w3id.org/spaces/AI-in-education/r/terms/AI-in-Education-approach> . optional { ?approach a ?class . filter(?class != <https://w3id.org/spaces/AI-in-education/r/terms/AI-in-Education-approach>) } ?approach rdfs:label ?approach_label . ?approach dct:source ?reference . ?reference rdfs:label ?reference_label . } }" assertion.
- get-urban-organism-associations 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 biolink: <https://w3id.org/biolink/vocab/> prefix biodiv: <https://w3id.org/kpxl/biodiv/terms/> prefix nt: <https://w3id.org/np/o/ntemplate/> select ?relation ?relation_label ?taxon_name ?taxon_name_label ?creator ?date ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType biodiv:OrganismToEnvironmentAssociation . ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . ?np dct:creator ?creator . ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?i . optional { ?np rdfs:label ?label } } graph ?a { ?association a biodiv:OrganismToEnvironmentAssociation . ?association biolink:subject ?organism . ?organism a ?taxonConcept . ?taxonConcept biodiv:hasTaxonName ?taxon_name . ?association biolink:predicate ?relation . ?association biolink:object <http://purl.obolibrary.org/obo/ENVO_00000856> . } optional { graph ?i { ?taxon_name nt:hasLabelFromApi ?taxon_name_label . } } optional { graph ?i { ?relation nt:hasLabelFromApi ?relation_label . } } optional { graph ?i { values (?relation ?relation_label) { ( <http://purl.obolibrary.org/obo/RO_0002303> "has habitat" ) } } } } order by desc(?date)" assertion.
- get-spaces-and-roles-for-agent sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix owl: <http://www.w3.org/2002/07/owl#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> prefix schema: <http://schema.org/> select distinct ?space (group_concat(?role; separator=" ") as ?roles) where { values ?_agent_multi_iri {} { { 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_multi_iri ?reg ?space . } bind(?reg as ?property) bind(false as ?inverse) } union { graph ?role_a { ?role gen:hasInverseProperty ?inv . } graph ?link_a { ?space ?inv ?_agent_multi_iri . } bind(?inv as ?property) bind(true as ?inverse) } } 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 . } ?link_np dct:created ?link_date . } } group by ?space order by ?space" assertion.
- get-spaces-for-agent sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix owl: <http://www.w3.org/2002/07/owl#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> prefix schema: <http://schema.org/> select distinct ?space where { values ?_agent_multi_iri {} { { 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_multi_iri ?reg ?space . } bind(?reg as ?property) bind(false as ?inverse) } union { graph ?role_a { ?role gen:hasInverseProperty ?inv . } graph ?link_a { ?space ?inv ?_agent_multi_iri . } bind(?inv as ?property) bind(true as ?inverse) } } 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 . } ?link_np dct:created ?link_date . } } order by desc(?link_date)" assertion.
- get-classes-of-ontology-ns 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 distinct ?class ?class_label (?definition as ?description) ?np ("^" as ?np_label) 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 a owl:Class . filter(strstarts(str(?class), ?__ontologyNamespace)) } union { ?class a owl:Class . ?class dct:partOf ?_ontology_multi_iri . }} optional { ?class rdfs:subClassOf ?superclass . } optional { ?class rdfs:label ?class_label . } optional { ?class skos:definition ?definition . } } } order by ?class_label" assertion.
- get-filtered-nanopub-list sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select ?np ?label ?date (group_concat(distinct ?t; separator=' ') as ?types) (?__np_pubkeys_multi as ?pubkey) where { graph npa:graph { values ?__np_pubkeys_multi {} ?np npa:hasValidSignatureForPublicKeyHash ?__np_pubkeys_multi . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?__np_pubkeys_multi . } values ?__types_multi_iri {} ?np npx:hasNanopubType ?__types_multi_iri . ?np npx:hasNanopubType ?t . ?np dct:created ?date . bind(coalesce(?__np_endtime, "9999") as ?endtime) filter(?endtime > str(?date)) bind(coalesce(?__np_starttime, "0000") as ?starttime) filter(?starttime < str(?date)) optional { ?np rdfs:label ?label } } } group by ?np ?label ?date ?__np_pubkeys_multi order by desc(?date) limit 100" assertion.
- get-weekly-active-user-count sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix prov: <http://www.w3.org/ns/prov#> prefix foaf: <http://xmlns.com/foaf/0.1/> select ?approxweek (substr(str(min(?date)), 0, 11) as ?firstday) (count(distinct ?userid) as ?usercount) where { { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:creator ?userid . ?np dct:created ?date . } } union { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np np:hasAssertion ?assertion . ?np np:hasProvenance ?prov . ?np dct:created ?date . ?np dct:creator ?tool . values ?tool { <https://fip-wizard.ds-wizard.org/wizard> } } graph ?prov { ?assertion prov:wasAttributedTo ?userid . } } filter not exists { graph npa:graph { ?np npa:hasSubIri ?userid . } } bind(xsd:integer((year(?date)*365 + month(?date)*365/12 + day(?date)) / 7) as ?approxweek) } group by ?approxweek order by desc(?approxweek)" assertion.
- get-relevant-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 ?resource_label ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType gen:isRelevantFor . ?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 } } values ?_entity_multi_iri {} graph ?a { ?resource gen:isRelevantFor ?_entity_multi_iri . optional { ?resource rdfs:label ?resource_label . } } }" assertion.
- get-environments-for-taxon 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 biolink: <https://w3id.org/biolink/vocab/> prefix biodiv: <https://w3id.org/kpxl/biodiv/terms/> prefix nt: <https://w3id.org/np/o/ntemplate/> select distinct ?relation ?relation_label ?environment ?environment_label ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType biolink:OrganismTaxonToEnvironmentAssociation . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?association . ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?i . } graph ?a { ?association a biolink:OrganismTaxonToEnvironmentAssociation . ?association biolink:subject ?taxonConcept . ?taxonConcept biodiv:hasTaxonName ?_taxonname_iri . ?association biolink:predicate ?relation . ?association biolink:object ?environment . } optional { graph ?i { ?relation nt:hasLabelFromApi ?relation_label } } optional { graph ?i { ?environment nt:hasLabelFromApi ?environment_label } } }" assertion.
- get-environments-for-taxon 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 biolink: <https://w3id.org/biolink/vocab/> prefix biodiv: <https://w3id.org/kpxl/biodiv/terms/> prefix nt: <https://w3id.org/np/o/ntemplate/> select distinct ?relation ?relation_label ?environment ?environment_label ?creator ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType biolink:OrganismTaxonToEnvironmentAssociation . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?association . ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?i . ?np npx:signedBy ?creator . } graph ?a { ?association a biolink:OrganismTaxonToEnvironmentAssociation . ?association biolink:subject ?taxonConcept . ?taxonConcept biodiv:hasTaxonName ?_taxonname_iri . ?association biolink:predicate ?relation . ?association biolink:object ?environment . } optional { graph ?i { ?relation nt:hasLabelFromApi ?relation_label } } optional { graph ?i { ?environment nt:hasLabelFromApi ?environment_label } } }" assertion.
- get-environments-for-taxon 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 biolink: <https://w3id.org/biolink/vocab/> prefix biodiv: <https://w3id.org/kpxl/biodiv/terms/> prefix nt: <https://w3id.org/np/o/ntemplate/> select distinct ?relation ?relation_label ?environment ?environment_label ?source ?creator ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType biolink:OrganismTaxonToEnvironmentAssociation . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?association . ?np np:hasAssertion ?a . ?np np:hasProvenance ?p . ?np np:hasPublicationInfo ?i . ?np npx:signedBy ?creator . } graph ?a { ?association a biolink:OrganismTaxonToEnvironmentAssociation . ?association biolink:subject ?taxonConcept . ?taxonConcept biodiv:hasTaxonName ?_taxonname_iri . ?association biolink:predicate ?relation . ?association biolink:object ?environment . } optional { graph ?p { ?a dct:source ?source } } optional { graph ?i { ?relation nt:hasLabelFromApi ?relation_label } } optional { graph ?i { ?environment nt:hasLabelFromApi ?environment_label } } }" assertion.
- get-uncertainty-estimates 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 mac: <https://w3id.org/spaces/mac/r/ontology/> select ?dataset ?mz_estimate ?rt_estimate ?i_estimate ?uncertainty_model ?creator ?date ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType mac:uncertainty_model . ?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 . } graph ?a { ?dataset mac:has_mz_uncertainty_estimate ?mz_estimate . ?dataset mac:has_RT_uncertainty_estimate ?rt_estimate . ?dataset mac:has_I_uncertainty_estimate ?i_estimate . ?a dct:conformsTo ?uncertainty_model . } } order by desc(?date)" assertion.