home / zeropm-v0-0-4

api_results

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

16 rows where inchi_id = 16902

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
107142 107142 70595 70595 PubChem (compound) 1 16902 16902 2
447186 447186 157014 157014 PubChem (substance) 2 16902 16902 6
447187 447187 70601 70601 PubChem (substance) 2 16902 16902 6
447188 447188 70595 70595 PubChem (substance) 2 16902 16902 4
447189 447189 111615 111615 PubChem (substance) 2 16902 16902 11
447190 447190 70605 70605 PubChem (substance) 2 16902 16902 6
447191 447191 70598 70598 PubChem (substance) 2 16902 16902 6
447192 447192 70604 70604 PubChem (substance) 2 16902 16902 6
447193 447193 70599 70599 PubChem (substance) 2 16902 16902 5
447194 447194 70603 70603 PubChem (substance) 2 16902 16902 6
447195 447195 70602 70602 PubChem (substance) 2 16902 16902 6
1016729 1016729 70599 70599 CAS Common Chemistry 3 16902 16902 1
1016730 1016730 70595 70595 CAS Common Chemistry 3 16902 16902 1
1016731 1016731 70604 70604 CAS Common Chemistry 3 16902 16902 1
1016732 1016732 70603 70603 CAS Common Chemistry 3 16902 16902 1
1069706 1069706 159845 159845 CAS Common Chemistry 3 16902 16902 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 904.98ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website