home / zeropm-v0-0-4

api_results

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

25 rows where query_id = 17200

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
37677 37677 17200 17200 PubChem (compound) 1 111687 111687 1
349583 349583 17200 17200 PubChem (substance) 2 111687 111687 1
702107 702107 17200 17200 PubChem (substance) 2 230632 230632 8
715895 715895 17200 17200 PubChem (substance) 2 225574 225574 2
715902 715902 17200 17200 PubChem (substance) 2 230958 230958 3
715904 715904 17200 17200 PubChem (substance) 2 230971 230971 4
715908 715908 17200 17200 PubChem (substance) 2 230975 230975 5
715914 715914 17200 17200 PubChem (substance) 2 230990 230990 6
715918 715918 17200 17200 PubChem (substance) 2 231006 231006 7
715924 715924 17200 17200 PubChem (substance) 2 314190 314190 9
715930 715930 17200 17200 PubChem (substance) 2 231011 231011 10
715933 715933 17200 17200 PubChem (substance) 2 231050 231050 11
715937 715937 17200 17200 PubChem (substance) 2 248141 248141 12
715940 715940 17200 17200 PubChem (substance) 2 248322 248322 13
715944 715944 17200 17200 PubChem (substance) 2 248429 248429 14
715947 715947 17200 17200 PubChem (substance) 2 248181 248181 15
715950 715950 17200 17200 PubChem (substance) 2 225451 225451 16
715953 715953 17200 17200 PubChem (substance) 2 248098 248098 17
715957 715957 17200 17200 PubChem (substance) 2 248161 248161 18
715960 715960 17200 17200 PubChem (substance) 2 248170 248170 19
715963 715963 17200 17200 PubChem (substance) 2 225157 225157 20
715965 715965 17200 17200 PubChem (substance) 2 224391 224391 21
715969 715969 17200 17200 PubChem (substance) 2 219343 219343 22
965623 965623 17200 17200 CAS Common Chemistry 3 46626 46626 1
1167411 1167411 17200 17200 Computational Toxicology and Exposure Data 4 111687 111687 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 2102.547ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website