home / zeropm-v0-0-4

api_results

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

19 rows where query_id = 40639

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
79568 79568 40639 40639 PubChem (compound) 1 314433 314433 1
79570 79570 40639 40639 PubChem (compound) 1 282478 282478 2
79571 79571 40639 40639 PubChem (compound) 1 317843 317843 3
301049 301049 40639 40639 PubChem (substance) 2 2619 2619 8
408483 408483 40639 40639 PubChem (substance) 2 314433 314433 1
408489 408489 40639 40639 PubChem (substance) 2 282478 282478 2
408501 408501 40639 40639 PubChem (substance) 2 317843 317843 4
434343 434343 40639 40639 PubChem (substance) 2 140598 140598 13
434349 434349 40639 40639 PubChem (substance) 2 313878 313878 5
434356 434356 40639 40639 PubChem (substance) 2 314434 314434 3
596595 596595 40639 40639 PubChem (substance) 2 318165 318165 10
683517 683517 40639 40639 PubChem (substance) 2 314433 314433 11
694075 694075 40639 40639 PubChem (substance) 2 282478 282478 6
738222 738222 40639 40639 PubChem (substance) 2 317420 317420 7
738223 738223 40639 40639 PubChem (substance) 2 318105 318105 9
738224 738224 40639 40639 PubChem (substance) 2 282478 282478 12
738227 738227 40639 40639 PubChem (substance) 2 333587 333587 14
996400 996400 40639 40639 CAS Common Chemistry 3 58165 58165 1
1199403 1199403 40639 40639 Computational Toxicology and Exposure Data 4 117109 117109 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 412.533ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website