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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
59701 59701 27477 27477 PubChem (compound) 1 74477 74477 1
59702 59702 27476 27476 PubChem (compound) 1 74477 74477 1
59703 59703 232705 232705 PubChem (compound) 1 74477 74477 1
59704 59704 117039 117039 PubChem (compound) 1 74477 74477 1
59705 59705 413192 413192 PubChem (compound) 1 74477 74477 1
59706 59706 144915 144915 PubChem (compound) 1 74477 74477 1
380172 380172 27476 27476 PubChem (substance) 2 74477 74477 1
380173 380173 413192 413192 PubChem (substance) 2 74477 74477 1
380174 380174 27477 27477 PubChem (substance) 2 74477 74477 1
380175 380175 376013 376013 PubChem (substance) 2 74477 74477 2
380176 380176 144915 144915 PubChem (substance) 2 74477 74477 1
380177 380177 375416 375416 PubChem (substance) 2 74477 74477 2
380178 380178 232705 232705 PubChem (substance) 2 74477 74477 1
380179 380179 117039 117039 PubChem (substance) 2 74477 74477 1
981994 981994 144915 144915 CAS Common Chemistry 3 74477 74477 1
981995 981995 232705 232705 CAS Common Chemistry 3 74477 74477 1
981996 981996 27476 27476 CAS Common Chemistry 3 74477 74477 1
981997 981997 117039 117039 CAS Common Chemistry 3 74477 74477 1
981998 981998 413192 413192 CAS Common Chemistry 3 74477 74477 1
981999 981999 27477 27477 CAS Common Chemistry 3 74477 74477 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 420.137ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website