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 = 375214

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
28122 28122 375214 375214 PubChem (compound) 1 91293 91293 1
327055 327055 375214 375214 PubChem (substance) 2 54029 54029 2
335728 335728 375214 375214 PubChem (substance) 2 91293 91293 1
550341 550341 375214 375214 PubChem (substance) 2 27116 27116 12
695872 695872 375214 375214 PubChem (substance) 2 315679 315679 3
709549 709549 375214 375214 PubChem (substance) 2 315681 315681 4
709564 709564 375214 375214 PubChem (substance) 2 315682 315682 5
768760 768760 375214 375214 PubChem (substance) 2 232151 232151 6
768764 768764 375214 375214 PubChem (substance) 2 205335 205335 7
768766 768766 375214 375214 PubChem (substance) 2 169824 169824 8
768769 768769 375214 375214 PubChem (substance) 2 169850 169850 9
768772 768772 375214 375214 PubChem (substance) 2 204553 204553 10
768775 768775 375214 375214 PubChem (substance) 2 173747 173747 11
958806 958806 375214 375214 CAS Common Chemistry 3 91293 91293 1
1159205 1159205 375214 375214 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 965.046ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website