home / zeropm-v0-0-4

api_results

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

20 rows where inchi_id = 45397

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
37213 37213 113308 113308 PubChem (compound) 1 45397 45397 1
37214 37214 66640 66640 PubChem (compound) 1 45397 45397 1
37215 37215 17019 17019 PubChem (compound) 1 45397 45397 1
37216 37216 17020 17020 PubChem (compound) 1 45397 45397 1
348951 348951 13405 13405 PubChem (substance) 2 45397 45397 3
348952 348952 17019 17019 PubChem (substance) 2 45397 45397 1
348953 348953 393538 393538 PubChem (substance) 2 45397 45397 6
348954 348954 117726 117726 PubChem (substance) 2 45397 45397 8
348955 348955 17020 17020 PubChem (substance) 2 45397 45397 1
348956 348956 113308 113308 PubChem (substance) 2 45397 45397 1
348957 348957 66640 66640 PubChem (substance) 2 45397 45397 1
965271 965271 17020 17020 CAS Common Chemistry 3 45397 45397 1
965272 965272 17019 17019 CAS Common Chemistry 3 45397 45397 1
965273 965273 113308 113308 CAS Common Chemistry 3 45397 45397 1
965274 965274 66640 66640 CAS Common Chemistry 3 45397 45397 1
1166978 1166978 17020 17020 Computational Toxicology and Exposure Data 4 45397 45397 1
1166979 1166979 17019 17019 Computational Toxicology and Exposure Data 4 45397 45397 1
1166980 1166980 361822 361822 Computational Toxicology and Exposure Data 4 45397 45397 1
1166981 1166981 66640 66640 Computational Toxicology and Exposure Data 4 45397 45397 1
1166982 1166982 113308 113308 Computational Toxicology and Exposure Data 4 45397 45397 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 1027.23ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website