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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
55673 55673 25237 25237 PubChem (compound) 1 23324 23324 1
55674 55674 25236 25236 PubChem (compound) 1 23324 23324 1
55675 55675 355892 355892 PubChem (compound) 1 23324 23324 1
55676 55676 162191 162191 PubChem (compound) 1 23324 23324 1
55677 55677 313952 313952 PubChem (compound) 1 23324 23324 1
55678 55678 389270 389270 PubChem (compound) 1 23324 23324 1
374401 374401 25236 25236 PubChem (substance) 2 23324 23324 1
374402 374402 25237 25237 PubChem (substance) 2 23324 23324 1
374403 374403 313952 313952 PubChem (substance) 2 23324 23324 1
374404 374404 389270 389270 PubChem (substance) 2 23324 23324 1
374405 374405 94664 94664 PubChem (substance) 2 23324 23324 3
374406 374406 355892 355892 PubChem (substance) 2 23324 23324 1
374407 374407 92337 92337 PubChem (substance) 2 23324 23324 2
374408 374408 162191 162191 PubChem (substance) 2 23324 23324 1
978934 978934 25236 25236 CAS Common Chemistry 3 23324 23324 1
978935 978935 25237 25237 CAS Common Chemistry 3 23324 23324 1
978936 978936 355892 355892 CAS Common Chemistry 3 23324 23324 1
978937 978937 313952 313952 CAS Common Chemistry 3 23324 23324 1
978938 978938 162191 162191 CAS Common Chemistry 3 23324 23324 1
978939 978939 92337 92337 CAS Common Chemistry 3 23324 23324 2
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 476.454ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website