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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
118897 118897 93036 93036 PubChem (compound) 1 21666 21666 1
118898 118898 93035 93035 PubChem (compound) 1 21666 21666 1
118899 118899 118722 118722 PubChem (compound) 1 21666 21666 3
118900 118900 118721 118721 PubChem (compound) 1 21666 21666 3
118901 118901 147171 147171 PubChem (compound) 1 21666 21666 3
118902 118902 408009 408009 PubChem (compound) 1 21666 21666 1
463345 463345 12814 12814 PubChem (substance) 2 21666 21666 6
463346 463346 93035 93035 PubChem (substance) 2 21666 21666 1
463347 463347 147171 147171 PubChem (substance) 2 21666 21666 3
463348 463348 147170 147170 PubChem (substance) 2 21666 21666 3
463349 463349 408296 408296 PubChem (substance) 2 21666 21666 2
463350 463350 118721 118721 PubChem (substance) 2 21666 21666 3
463351 463351 93036 93036 PubChem (substance) 2 21666 21666 1
463352 463352 408009 408009 PubChem (substance) 2 21666 21666 1
463353 463353 374131 374131 PubChem (substance) 2 21666 21666 6
463354 463354 7161 7161 PubChem (substance) 2 21666 21666 6
463355 463355 118722 118722 PubChem (substance) 2 21666 21666 3
1024859 1024859 93035 93035 CAS Common Chemistry 3 21666 21666 1
1024860 1024860 408009 408009 CAS Common Chemistry 3 21666 21666 1
1024861 1024861 93036 93036 CAS Common Chemistry 3 21666 21666 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 741.154ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website