home / zeropm-v0-0-4

api_results

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

17 rows where inchi_id = 24827

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
147862 147862 127726 127726 PubChem (compound) 1 24827 24827 1
147863 147863 235323 235323 PubChem (compound) 1 24827 24827 1
147864 147864 409853 409853 PubChem (compound) 1 24827 24827 1
147865 147865 127727 127727 PubChem (compound) 1 24827 24827 1
502432 502432 22019 22019 PubChem (substance) 2 24827 24827 4
502433 502433 127726 127726 PubChem (substance) 2 24827 24827 1
502434 502434 409853 409853 PubChem (substance) 2 24827 24827 1
502435 502435 127727 127727 PubChem (substance) 2 24827 24827 1
502436 502436 235323 235323 PubChem (substance) 2 24827 24827 1
1046098 1046098 127727 127727 CAS Common Chemistry 3 24827 24827 1
1046099 1046099 409853 409853 CAS Common Chemistry 3 24827 24827 1
1046100 1046100 235323 235323 CAS Common Chemistry 3 24827 24827 1
1046101 1046101 127726 127726 CAS Common Chemistry 3 24827 24827 1
1248955 1248955 235323 235323 Computational Toxicology and Exposure Data 4 24827 24827 1
1248956 1248956 127726 127726 Computational Toxicology and Exposure Data 4 24827 24827 1
1248957 1248957 127727 127727 Computational Toxicology and Exposure Data 4 24827 24827 1
1248958 1248958 409853 409853 Computational Toxicology and Exposure Data 4 24827 24827 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 1993.18ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website