home / zeropm-v0-0-4

api_results

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

28 rows where query_id = 60802

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21619 21619 60802 60802 PubChem (compound) 1 51342 51342 1
299707 299707 60802 60802 PubChem (substance) 2 3337 3337 7
326512 326512 60802 60802 PubChem (substance) 2 51342 51342 1
438350 438350 60802 60802 PubChem (substance) 2 68382 68382 2
491804 491804 60802 60802 PubChem (substance) 2 84981 84981 3
521506 521506 60802 60802 PubChem (substance) 2 62347 62347 20
707305 707305 60802 60802 PubChem (substance) 2 173564 173564 5
749596 749596 60802 60802 PubChem (substance) 2 169733 169733 8
751046 751046 60802 60802 PubChem (substance) 2 173564 173564 4
751047 751047 60802 60802 PubChem (substance) 2 169629 169629 6
751048 751048 60802 60802 PubChem (substance) 2 205302 205302 9
751049 751049 60802 60802 PubChem (substance) 2 203564 203564 10
751050 751050 60802 60802 PubChem (substance) 2 148699 148699 11
751051 751051 60802 60802 PubChem (substance) 2 201536 201536 12
751052 751052 60802 60802 PubChem (substance) 2 169855 169855 13
751053 751053 60802 60802 PubChem (substance) 2 169859 169859 14
751054 751054 60802 60802 PubChem (substance) 2 201494 201494 15
751061 751061 60802 60802 PubChem (substance) 2 169448 169448 16
751067 751067 60802 60802 PubChem (substance) 2 255580 255580 17
751068 751068 60802 60802 PubChem (substance) 2 228742 228742 18
751069 751069 60802 60802 PubChem (substance) 2 169016 169016 19
751070 751070 60802 60802 PubChem (substance) 2 188335 188335 21
751071 751071 60802 60802 PubChem (substance) 2 330435 330435 22
751074 751074 60802 60802 PubChem (substance) 2 233068 233068 23
954161 954161 60802 60802 CAS Common Chemistry 3 51342 51342 1
1012473 1012473 60802 60802 CAS Common Chemistry 3 68382 68382 2
1153680 1153680 60802 60802 Computational Toxicology and Exposure Data 4 51342 51342 2
1214599 1214599 60802 60802 Computational Toxicology and Exposure Data 4 134417 134417 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 418.751ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website