home / zeropm-v0-0-4

api_results

Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website

15 rows where query_id = 174309

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
192898 192898 174309 174309 PubChem (compound) 1 38328 38328 1
561742 561742 174309 174309 PubChem (substance) 2 38328 38328 1
563598 563598 174309 174309 PubChem (substance) 2 118805 118805 8
670824 670824 174309 174309 PubChem (substance) 2 40083 40083 6
820254 820254 174309 174309 PubChem (substance) 2 136647 136647 2
820256 820256 174309 174309 PubChem (substance) 2 238982 238982 3
820258 820258 174309 174309 PubChem (substance) 2 216774 216774 4
820260 820260 174309 174309 PubChem (substance) 2 190824 190824 5
820263 820263 174309 174309 PubChem (substance) 2 288950 288950 9
820265 820265 174309 174309 PubChem (substance) 2 237284 237284 10
820266 820266 174309 174309 PubChem (substance) 2 309839 309839 11
820269 820269 174309 174309 PubChem (substance) 2 287619 287619 12
820270 820270 174309 174309 PubChem (substance) 2 273993 273993 7
1078947 1078947 174309 174309 CAS Common Chemistry 3 38328 38328 1
1280400 1280400 174309 174309 Computational Toxicology and Exposure Data 4 38328 38328 1
CREATE TABLE [api_results] (
        [query_id] integer,
        [api_id] integer,
        [inchi_id] integer,
        [rank] integer,
        FOREIGN KEY (query_id) REFERENCES api_ready_query(query_id),
        FOREIGN KEY (api_id) REFERENCES api_services(api_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);
Powered by Datasette · Queries took 1845.825ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website