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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
140566 140566 120661 120661 PubChem (compound) 1 23046 23046 2
492853 492853 19409 19409 PubChem (substance) 2 23046 23046 2
492854 492854 301621 301621 PubChem (substance) 2 23046 23046 3
492855 492855 9455 9455 PubChem (substance) 2 23046 23046 3
492856 492856 120661 120661 PubChem (substance) 2 23046 23046 2
951387 951387 9455 9455 CAS Common Chemistry 3 23046 23046 1
951388 951388 405242 405242 CAS Common Chemistry 3 23046 23046 1
951389 951389 9456 9456 CAS Common Chemistry 3 23046 23046 1
951390 951390 301621 301621 CAS Common Chemistry 3 23046 23046 1
951391 951391 307907 307907 CAS Common Chemistry 3 23046 23046 1
951392 951392 101338 101338 CAS Common Chemistry 3 23046 23046 2
969803 969803 19409 19409 CAS Common Chemistry 3 23046 23046 1
969804 969804 120661 120661 CAS Common Chemistry 3 23046 23046 1
969805 969805 19410 19410 CAS Common Chemistry 3 23046 23046 1
1027525 1027525 101338 101338 CAS Common Chemistry 3 23046 23046 1
1027526 1027526 235145 235145 CAS Common Chemistry 3 23046 23046 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 416.595ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website