home / zeropm-v0-0-4

api_results

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

15 rows where query_id = 99297

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
28126 28126 99297 99297 PubChem (compound) 1 91293 91293 1
327058 327058 99297 99297 PubChem (substance) 2 54029 54029 2
335730 335730 99297 99297 PubChem (substance) 2 91293 91293 1
550339 550339 99297 99297 PubChem (substance) 2 27116 27116 12
695879 695879 99297 99297 PubChem (substance) 2 315679 315679 3
709561 709561 99297 99297 PubChem (substance) 2 315681 315681 4
709576 709576 99297 99297 PubChem (substance) 2 315682 315682 5
768759 768759 99297 99297 PubChem (substance) 2 232151 232151 6
768763 768763 99297 99297 PubChem (substance) 2 205335 205335 7
768767 768767 99297 99297 PubChem (substance) 2 169824 169824 8
768770 768770 99297 99297 PubChem (substance) 2 169850 169850 9
768771 768771 99297 99297 PubChem (substance) 2 204553 204553 10
768773 768773 99297 99297 PubChem (substance) 2 173747 173747 11
958807 958807 99297 99297 CAS Common Chemistry 3 91293 91293 1
1159204 1159204 99297 99297 Computational Toxicology and Exposure Data 4 91293 91293 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 1207.85ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website