home / zeropm-v0-0-4

api_results

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

23 rows where query_id = 370401

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
226 226 370401 370401 PubChem (compound) 1 74053 74053 1
295792 295792 370401 370401 PubChem (substance) 2 74053 74053 1
411900 411900 370401 370401 PubChem (substance) 2 65005 65005 16
422688 422688 370401 370401 PubChem (substance) 2 88275 88275 20
498038 498038 370401 370401 PubChem (substance) 2 15740 15740 6
517234 517234 370401 370401 PubChem (substance) 2 52262 52262 13
587559 587559 370401 370401 PubChem (substance) 2 66167 66167 17
589279 589279 370401 370401 PubChem (substance) 2 67204 67204 18
600671 600671 370401 370401 PubChem (substance) 2 80608 80608 19
692102 692102 370401 370401 PubChem (substance) 2 203379 203379 2
692107 692107 370401 370401 PubChem (substance) 2 208110 208110 3
692110 692110 370401 370401 PubChem (substance) 2 208033 208033 4
692112 692112 370401 370401 PubChem (substance) 2 149161 149161 5
692116 692116 370401 370401 PubChem (substance) 2 244357 244357 7
692120 692120 370401 370401 PubChem (substance) 2 187958 187958 8
692123 692123 370401 370401 PubChem (substance) 2 215453 215453 9
692126 692126 370401 370401 PubChem (substance) 2 210249 210249 10
692128 692128 370401 370401 PubChem (substance) 2 272877 272877 11
692132 692132 370401 370401 PubChem (substance) 2 187800 187800 12
692135 692135 370401 370401 PubChem (substance) 2 192227 192227 14
692138 692138 370401 370401 PubChem (substance) 2 211245 211245 15
938306 938306 370401 370401 CAS Common Chemistry 3 74053 74053 1
1134939 1134939 370401 370401 Computational Toxicology and Exposure Data 4 74053 74053 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 437.499ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website