home / zeropm-v0-0-4

api_results

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

23 rows where inchi_id = 58697

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
22099 22099 105145 105145 PubChem (compound) 1 58697 58697 1
22100 22100 230162 230162 PubChem (compound) 1 58697 58697 1
22101 22101 88673 88673 PubChem (compound) 1 58697 58697 2
22102 22102 11503 11503 PubChem (compound) 1 58697 58697 1
22103 22103 11504 11504 PubChem (compound) 1 58697 58697 1
327349 327349 88667 88667 PubChem (substance) 2 58697 58697 2
327350 327350 131647 131647 PubChem (substance) 2 58697 58697 3
327351 327351 230162 230162 PubChem (substance) 2 58697 58697 2
327352 327352 340703 340703 PubChem (substance) 2 58697 58697 2
327353 327353 378227 378227 PubChem (substance) 2 58697 58697 8
327354 327354 88672 88672 PubChem (substance) 2 58697 58697 2
327355 327355 88673 88673 PubChem (substance) 2 58697 58697 2
327356 327356 88671 88671 PubChem (substance) 2 58697 58697 2
327357 327357 105145 105145 PubChem (substance) 2 58697 58697 1
327358 327358 11503 11503 PubChem (substance) 2 58697 58697 1
327359 327359 11504 11504 PubChem (substance) 2 58697 58697 1
327360 327360 139266 139266 PubChem (substance) 2 58697 58697 3
327361 327361 105016 105016 PubChem (substance) 2 58697 58697 2
327362 327362 139265 139265 PubChem (substance) 2 58697 58697 4
954515 954515 11503 11503 CAS Common Chemistry 3 58697 58697 1
954516 954516 105145 105145 CAS Common Chemistry 3 58697 58697 1
954517 954517 230162 230162 CAS Common Chemistry 3 58697 58697 1
954518 954518 11504 11504 CAS Common Chemistry 3 58697 58697 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 418.812ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website