sbd-data-book

allCNTData.rq

Code examples: curl

SPARQL

PREFIX npo: <http://purl.bioontology.org/ontology/npo#>
PREFIX obo: <http://purl.obolibrary.org/obo/>
PREFIX sbd:     <https://www.sbd4nano.eu/rdf/#>
PREFIX sbdbel:  <https://www.sbd4nano.eu/bel/#>
PREFIX foaf:   <http://xmlns.com/foaf/0.1/> 
PREFIX rdfs:   <http://www.w3.org/2000/01/rdf-schema#> 
PREFIX erm:    <https://nanocommons.github.io/identifiers/registry#>
PREFIX enm:    <http://purl.enanomapper.org/onto/>

SELECT ?materialIRI (SAMPLE(?material_) AS ?material) ?dataset ?datasetLabel
WHERE {
  VALUES ?superclass { npo:NPO_606 }
  VALUES ?type { sbd:Dataset sbd:Database }
  ?dataset sbdbel:NP ?materialIRI ; a ?type ; rdfs:label ?datasetLabel .
  ?materialIRI rdfs:subClassOf* ?superclass ; rdfs:label ?material_ .
} GROUP BY ?materialIRI ?dataset ?datasetLabel
  ORDER BY ?dataset

run

Output

materialIRI	material	dataset
npo:NPO_354	MWCNT40nm-COOH	harmless - eNanoMapper database
npo:NPO_354	MWCNT40nm-COOH	nanoinformatix - eNanoMapper database
npo:NPO_606	CNT: Carbon nanotubes	nanoreg - eNanoMapper database
npo:NPO_354	MWCNT40nm-COOH	nanoreg - eNanoMapper database
npo:NPO_943	single-walled carbon nanotube	nanoreg - eNanoMapper database
npo:NPO_354	MWCNT40nm-COOH	nanoreg2 - eNanoMapper database
npo:NPO_354	MWCNT40nm-COOH	riskgone - eNanoMapper database
erm:ERM00000066	ERM00000066	riskgone - eNanoMapper database
erm:ERM00000325	ERM00000325	riskgone - eNanoMapper database
enm:ENM_9000230	NM-403	Transcriptomic study of NR8383 rat macrophages cells following exposure to NM403 carbon nanotubes
npo:NPO_354	MWCNT40nm-COOH	Transcriptomic study of NR8383 rat macrophages cells following exposure to multi-walled carbon nanotubes (NRCWE006)
npo:NPO_606	CNT: Carbon nanotubes	Transcriptomic study of NR8383 rat macrophages cells following exposure to COOH-functionalized carbon nanotubes (NRCWE042)
npo:NPO_606	CNT: Carbon nanotubes	Transcriptomic study of NR8383 rat macrophages cells following exposure to NH2-functionalized carbon nanotubes (NRCWE049)
npo:NPO_943	single-walled carbon nanotube	Transcriptomic study of NR8383 rat macrophages cells following exposure to pristine single-walled carbon nanotubes (NRCWE055)

Code examples

curl

curl -s https://raw.githubusercontent.com/h2020-sbd4nano/sbd-data-book/master/sparql/allCNTData.rq | sed 's+<lang/>+en+' > allCNTData.rq

curl -H "Accept: text/tab-separated-values" -G https://sbd4nanolandscape.rdf.bigcat-bioinformatics.org/sparql --data-urlencode query@allCNTData.rq

This SPARQL query is available under CCZero.