home / zeropm-v0-0-4

api_results

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

18 rows where inchi_id = 140163

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
48147 48147 409812 409812 PubChem (compound) 1 140163 140163 1
48148 48148 55687 55687 PubChem (compound) 1 140163 140163 1
48149 48149 21709 21709 PubChem (compound) 1 140163 140163 1
48150 48150 92004 92004 PubChem (compound) 1 140163 140163 1
266946 266946 356049 356049 PubChem (compound) 1 140163 140163 1
364281 364281 21709 21709 PubChem (substance) 2 140163 140163 1
364282 364282 55687 55687 PubChem (substance) 2 140163 140163 1
364283 364283 409812 409812 PubChem (substance) 2 140163 140163 1
364284 364284 356049 356049 PubChem (substance) 2 140163 140163 1
364285 364285 127479 127479 PubChem (substance) 2 140163 140163 1
364286 364286 301820 301820 PubChem (substance) 2 140163 140163 1
364287 364287 21710 21710 PubChem (substance) 2 140163 140163 1
364288 364288 92004 92004 PubChem (substance) 2 140163 140163 1
655702 655702 21709 21709 PubChem (substance) 2 140163 140163 2
655703 655703 92004 92004 PubChem (substance) 2 140163 140163 2
655704 655704 301820 301820 PubChem (substance) 2 140163 140163 2
655705 655705 356049 356049 PubChem (substance) 2 140163 140163 2
655706 655706 127479 127479 PubChem (substance) 2 140163 140163 3
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 761.237ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website