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 = 1701

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
3279 3279 1701 1701 PubChem (compound) 1 422 422 1
300094 300094 1701 1701 PubChem (substance) 2 422 422 1
382593 382593 1701 1701 PubChem (substance) 2 365 365 3
659570 659570 1701 1701 PubChem (substance) 2 124382 124382 6
694744 694744 1701 1701 PubChem (substance) 2 422 422 2
694749 694749 1701 1701 PubChem (substance) 2 223504 223504 5
694756 694756 1701 1701 PubChem (substance) 2 365 365 4
694768 694768 1701 1701 PubChem (substance) 2 232060 232060 7
694783 694783 1701 1701 PubChem (substance) 2 232061 232061 8
694801 694801 1701 1701 PubChem (substance) 2 232062 232062 9
694816 694816 1701 1701 PubChem (substance) 2 232063 232063 10
694821 694821 1701 1701 PubChem (substance) 2 232064 232064 11
694842 694842 1701 1701 PubChem (substance) 2 232065 232065 12
694848 694848 1701 1701 PubChem (substance) 2 232066 232066 13
694858 694858 1701 1701 PubChem (substance) 2 232067 232067 14
694871 694871 1701 1701 PubChem (substance) 2 232068 232068 15
694881 694881 1701 1701 PubChem (substance) 2 232069 232069 16
694893 694893 1701 1701 PubChem (substance) 2 232070 232070 17
694899 694899 1701 1701 PubChem (substance) 2 232071 232071 18
694912 694912 1701 1701 PubChem (substance) 2 232072 232072 19
694927 694927 1701 1701 PubChem (substance) 2 232073 232073 20
694939 694939 1701 1701 PubChem (substance) 2 232074 232074 21
694950 694950 1701 1701 PubChem (substance) 2 232075 232075 22
694957 694957 1701 1701 PubChem (substance) 2 232076 232076 23
694970 694970 1701 1701 PubChem (substance) 2 232077 232077 24
694978 694978 1701 1701 PubChem (substance) 2 232078 232078 25
940494 940494 1701 1701 CAS Common Chemistry 3 422 422 1
1137669 1137669 1701 1701 Computational Toxicology and Exposure Data 4 422 422 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 1164.188ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website