home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 377131

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
270532 270532 377131 377131 PubChem (compound) 1 39770 39770 1
270533 270533 377131 377131 PubChem (compound) 1 90546 90546 2
270535 270535 377131 377131 PubChem (compound) 1 181841 181841 3
270536 270536 377131 377131 PubChem (compound) 1 231369 231369 4
270537 270537 377131 377131 PubChem (compound) 1 259472 259472 5
270538 270538 377131 377131 PubChem (compound) 1 320814 320814 6
270539 270539 377131 377131 PubChem (compound) 1 297830 297830 7
270540 270540 377131 377131 PubChem (compound) 1 320609 320609 8
660455 660455 377131 377131 PubChem (substance) 2 39770 39770 1
660459 660459 377131 377131 PubChem (substance) 2 90546 90546 2
660461 660461 377131 377131 PubChem (substance) 2 181841 181841 4
660462 660462 377131 377131 PubChem (substance) 2 231369 231369 5
660463 660463 377131 377131 PubChem (substance) 2 259472 259472 3
660464 660464 377131 377131 PubChem (substance) 2 320814 320814 8
660465 660465 377131 377131 PubChem (substance) 2 297830 297830 7
660466 660466 377131 377131 PubChem (substance) 2 320609 320609 10
920771 920771 377131 377131 PubChem (substance) 2 291190 291190 6
920772 920772 377131 377131 PubChem (substance) 2 288243 288243 9
1118316 1118316 377131 377131 CAS Common Chemistry 3 39770 39770 1
1330121 1330121 377131 377131 Computational Toxicology and Exposure Data 4 39770 39770 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 939.751ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website