home / zeropm-v0-0-4

api_results

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

19 rows where query_id = 392671

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
279592 279592 392671 392671 PubChem (compound) 1 202589 202589 1
298366 298366 392671 392671 PubChem (substance) 2 44 44 18
315383 315383 392671 392671 PubChem (substance) 2 40 40 17
671807 671807 392671 392671 PubChem (substance) 2 202589 202589 1
700041 700041 392671 392671 PubChem (substance) 2 219399 219399 12
929048 929048 392671 392671 PubChem (substance) 2 152840 152840 2
929049 929049 392671 392671 PubChem (substance) 2 269428 269428 3
929050 929050 392671 392671 PubChem (substance) 2 200675 200675 4
929051 929051 392671 392671 PubChem (substance) 2 242973 242973 5
929052 929052 392671 392671 PubChem (substance) 2 214302 214302 6
929053 929053 392671 392671 PubChem (substance) 2 276615 276615 7
929054 929054 392671 392671 PubChem (substance) 2 276616 276616 8
929055 929055 392671 392671 PubChem (substance) 2 254230 254230 9
929056 929056 392671 392671 PubChem (substance) 2 202921 202921 10
929057 929057 392671 392671 PubChem (substance) 2 242974 242974 11
929058 929058 392671 392671 PubChem (substance) 2 200763 200763 13
929059 929059 392671 392671 PubChem (substance) 2 276621 276621 14
929060 929060 392671 392671 PubChem (substance) 2 200694 200694 15
929061 929061 392671 392671 PubChem (substance) 2 205495 205495 16
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 433.2ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website