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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
38429 38429 17474 17474 PubChem (compound) 1 49660 49660 1
38430 38430 17475 17475 PubChem (compound) 1 49660 49660 1
38431 38431 114419 114419 PubChem (compound) 1 49660 49660 1
38432 38432 437907 437907 PubChem (compound) 1 49660 49660 1
350599 350599 17475 17475 PubChem (substance) 2 49660 49660 1
350600 350600 17474 17474 PubChem (substance) 2 49660 49660 1
350601 350601 114419 114419 PubChem (substance) 2 49660 49660 1
350602 350602 437907 437907 PubChem (substance) 2 49660 49660 1
350603 350603 252497 252497 PubChem (substance) 2 49660 49660 1
350604 350604 252498 252498 PubChem (substance) 2 49660 49660 1
350605 350605 238922 238922 PubChem (substance) 2 49660 49660 2
350606 350606 238924 238924 PubChem (substance) 2 49660 49660 2
966173 966173 17475 17475 CAS Common Chemistry 3 49660 49660 1
966174 966174 17474 17474 CAS Common Chemistry 3 49660 49660 1
966175 966175 437907 437907 CAS Common Chemistry 3 49660 49660 1
966176 966176 260469 260469 CAS Common Chemistry 3 49660 49660 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 430.917ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website