home / zeropm-v0-0-4

api_results

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

22 rows where query_id = 230043

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21315 21315 230043 230043 PubChem (compound) 1 45277 45277 1
325905 325905 230043 230043 PubChem (substance) 2 45277 45277 1
325946 325946 230043 230043 PubChem (substance) 2 45290 45290 18
706758 706758 230043 230043 PubChem (substance) 2 137093 137093 3
706760 706760 230043 230043 PubChem (substance) 2 232462 232462 4
706763 706763 230043 230043 PubChem (substance) 2 93562 93562 2
706765 706765 230043 230043 PubChem (substance) 2 144678 144678 7
706767 706767 230043 230043 PubChem (substance) 2 145087 145087 5
706769 706769 230043 230043 PubChem (substance) 2 210639 210639 19
707368 707368 230043 230043 PubChem (substance) 2 232135 232135 13
748042 748042 230043 230043 PubChem (substance) 2 232170 232170 14
771822 771822 230043 230043 PubChem (substance) 2 232081 232081 8
771825 771825 230043 230043 PubChem (substance) 2 232174 232174 15
789758 789758 230043 230043 PubChem (substance) 2 249110 249110 11
840295 840295 230043 230043 PubChem (substance) 2 231999 231999 6
840296 840296 230043 230043 PubChem (substance) 2 232096 232096 9
840299 840299 230043 230043 PubChem (substance) 2 232133 232133 10
840301 840301 230043 230043 PubChem (substance) 2 232134 232134 12
840302 840302 230043 230043 PubChem (substance) 2 232192 232192 16
840304 840304 230043 230043 PubChem (substance) 2 152472 152472 17
953912 953912 230043 230043 CAS Common Chemistry 3 45277 45277 1
1153365 1153365 230043 230043 Computational Toxicology and Exposure Data 4 93562 93562 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 518.392ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website