home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 397234

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
281219 281219 397234 397234 PubChem (compound) 1 192058 192058 1
281220 281220 397234 397234 PubChem (compound) 1 186686 186686 2
281221 281221 397234 397234 PubChem (compound) 1 308059 308059 3
281222 281222 397234 397234 PubChem (compound) 1 56160 56160 4
281223 281223 397234 397234 PubChem (compound) 1 237768 237768 5
281224 281224 397234 397234 PubChem (compound) 1 334233 334233 6
474809 474809 397234 397234 PubChem (substance) 2 180024 180024 8
474810 474810 397234 397234 PubChem (substance) 2 90731 90731 10
673852 673852 397234 397234 PubChem (substance) 2 192058 192058 1
673853 673853 397234 397234 PubChem (substance) 2 186686 186686 2
673854 673854 397234 397234 PubChem (substance) 2 308059 308059 3
673855 673855 397234 397234 PubChem (substance) 2 56160 56160 6
673856 673856 397234 397234 PubChem (substance) 2 237768 237768 5
673857 673857 397234 397234 PubChem (substance) 2 334233 334233 13
774590 774590 397234 397234 PubChem (substance) 2 140398 140398 7
930825 930825 397234 397234 PubChem (substance) 2 274663 274663 4
930826 930826 397234 397234 PubChem (substance) 2 182314 182314 9
930827 930827 397234 397234 PubChem (substance) 2 325203 325203 11
930828 930828 397234 397234 PubChem (substance) 2 292260 292260 12
1123952 1123952 397234 397234 CAS Common Chemistry 3 56160 56160 1
1337873 1337873 397234 397234 Computational Toxicology and Exposure Data 4 102462 102462 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 737.166ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website