2d:null 2e:["$","title",null,{"children":"Material Compound View | Michael Deagen | Observable"}] 33:[] 31:{"id":"8be511cb32d8945c","slug":"material-compound-view","title":"Material Compound View","thumbnail":"4a6f8b894f20b5c396b59a49ffeb58aed6ab5c31170746b1511711c9b3cae207","access_level":"public","create_time":"$D2021-05-04T13:21:25.841Z","update_time":"$D2021-07-23T15:33:37.313Z","view_time":null,"first_public_time":"$D2021-05-04T16:28:39.437Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"5ca8a3812ea4a326","login":"mdeagen","name":"Michael Deagen","avatar_url":"https://avatars-next.observableusercontent.com/0b8e876e2eac1058faa6c1a2624346f3e72350b8a7e6c9acaec6a9ad920b0476","tier":"starter_2024"},"version":249,"publish_version":249,"role":null,"authored":false,"authors":[{"type":"individual","id":"d3611c0325cb99e9","login":"mdeagen","name":"Michael Deagen","avatar_url":"https://avatars-next.observableusercontent.com/0b8e876e2eac1058faa6c1a2624346f3e72350b8a7e6c9acaec6a9ad920b0476","tier":null}],"members":[{"type":"individual","id":"d3611c0325cb99e9","login":"mdeagen","name":"Michael Deagen","avatar_url":"https://avatars-next.observableusercontent.com/0b8e876e2eac1058faa6c1a2624346f3e72350b8a7e6c9acaec6a9ad920b0476","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"title":"Material Compound View","cells":[{"id":0,"value":"md`# Material Compound View\n\nThis prototype **material view** for materials classes in the MaterialsMine knowledge graph provides an example of a landing page for documentation about the material, as well as links to internal and external sources.\n\nThe URL of this page could be the URI of the material class (e.g., *http://materialsmine.org/compound/ZincOxide*) or the page could be stored as a separate depiction/description of the resource.\n\nTo demonstrate **interoperability**, data are automatically populated from the MaterialsMine knowledge graph and external data resources such as [dbpedia](https://www.dbpedia.org/), [PubChem](https://pubchem.ncbi.nlm.nih.gov/), and [Wikidata](https://www.wikidata.org/wiki/Wikidata:Main_Page).\n\nTo see how it works, **select an material** from the drop-down list below.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":76,"value":"viewof material = Select(result00,{label: \"Select material:\", format: x => x.label, value: result00.find(t => t.label )})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":152,"value":"md`# *${material.label}*`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":159,"value":"md`### Abstract (from DBpedia)\n\n${result02[0].abstract}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":175,"value":"md`### Thumbnail (from DBpedia)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":176,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":54,"value":"md`#### *Wikipedia* link (via *DBpedia* rdfs:label match)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":188,"value":"md`${result01[0].wikipage}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":120,"value":"md`#### *Wikidata* link (via *PubChem* skos:closeMatch)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":192,"value":"md`${wikidataPage}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":155,"value":"md`#### *DBpedia resource link*`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":196,"value":"md`${result01[0].dbp_resource}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":184,"value":"md`## MaterialsMine data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":208,"value":"md`There are currently **${result03[0].SampleCount}** nanocomposite samples in the MaterialsMine knowledge graph which contain *${material.label}* as a constituent material.\n\nThese data have been curated from **${result03[0].DOICount}** research works, listed below.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":232,"value":"Table(result04)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"md`---\n\n## Appendix`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":88,"value":"pubchemRESTquery = `https://pubchem.ncbi.nlm.nih.gov/rest/rdf/query?graph=compound&pred=skos:closeMatch&subject=compound:` + material.PubChem + `&format=json`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":99,"value":"PubChemQuery = (await fetch(pubchemRESTquery)).json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":108,"value":"wikidataPage = PubChemQuery.results.bindings[0].object.value","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"MM_SPARQL_endpoint = \"https://materialsmine.org/wi/sparql\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"dbp_SPARQL_endpoint = \"https://dbpedia.org/sparql\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"md`### Libraries`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"import { querySPARQLendpoint } from '@mdeagen/sparql-select-query-function'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"import { Table, Select } from \"@observablehq/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"md`### Query Results`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"result00 = querySPARQLendpoint(MM_SPARQL_endpoint, query00_MM)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"result01 = querySPARQLendpoint(dbp_SPARQL_endpoint, query01_dbp)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":162,"value":"result02 = querySPARQLendpoint(dbp_SPARQL_endpoint, query02_dbp)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":205,"value":"result03 = querySPARQLendpoint(MM_SPARQL_endpoint, query03_MM)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":230,"value":"result04 = querySPARQLendpoint(MM_SPARQL_endpoint, query04_MM)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":38,"value":"md`### SPARQL Queries`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"query00_MM = `PREFIX rdfs: \nSELECT DISTINCT ?material ?label (MIN(REPLACE(STR(?compound),\"http://rdf.ncbi.nlm.nih.gov/pubchem/compound/\",\"\")) as ?PubChem) WHERE {\n ?material rdfs:subClassOf ?compound ;\n rdfs:label ?label .\n FILTER(REGEX(STR(?compound),\"pubchem\"))\n} GROUP BY ?material ?label`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"query01_dbp = `PREFIX foaf: \nselect distinct * where {\n?wikipage foaf:primaryTopic ?dbp_resource .\n?dbp_resource rdfs:label \"` + material.label + `\"@en\n}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":164,"value":"query02_dbp = `PREFIX foaf: \nPREFIX dbo: \nselect distinct * where {\n<` + result01[0].dbp_resource + `> dbo:abstract ?abstract ;\ndbo:thumbnail ?thumbnail\nFILTER(LANG(?abstract) = 'en')\n} LIMIT 10`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":202,"value":"query03_MM = `PREFIX sio: \nPREFIX nm: \nPREFIX dct: \nSELECT (COUNT(DISTINCT ?sample) AS ?SampleCount) (COUNT(DISTINCT ?doi) AS ?DOICount) WHERE {\n ?doi a dct:BibliographicResource ;\n sio:hasPart ?sample .\n ?sample a nm:PolymerNanocomposite ;\n sio:hasComponentPart [ a <` + material.material + `> ]\n}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":227,"value":"query04_MM = `PREFIX sio: \nPREFIX nm: \nPREFIX dct: \nPREFIX bibo: \nPREFIX rdf: \nPREFIX foaf: \nSELECT DISTINCT (MIN(?AuthorLabel) AS ?Authors) ?Title (REPLACE(STR(?doi),\"http://dx.doi.org/\",\"\") AS ?DOI) ?Journal WHERE {\n ?doi a dct:BibliographicResource ;\n dct:created ?Year ;\n dct:title ?Title ;\n dct:isPartOf [ dct:title ?Journal ] ;\n sio:hasPart ?sample ;\n bibo:authorList/rdf:rest* [ rdf:first [ foaf:name ?firstAuthor ] ; rdf:rest rdf:nil ] .\n ?sample a nm:PolymerNanocomposite ;\n sio:hasComponentPart [ a <` + material.material + `> ]\n BIND(CONCAT(\"(\", STR(?Year), \") \", STR(?firstAuthor), \" et al.\") AS ?AuthorLabel )\n} GROUP BY ?doi ?Title ?Journal`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 32:"$31:body"