home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 55613

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
94575 94575 55613 55613 PubChem (compound) 1 68309 68309 1
429237 429237 55613 55613 PubChem (substance) 2 68309 68309 1
433436 433436 55613 55613 PubChem (substance) 2 68557 68557 17
746048 746048 55613 55613 PubChem (substance) 2 137034 137034 2
746051 746051 55613 55613 PubChem (substance) 2 161124 161124 3
746052 746052 55613 55613 PubChem (substance) 2 266101 266101 4
746054 746054 55613 55613 PubChem (substance) 2 227340 227340 5
746058 746058 55613 55613 PubChem (substance) 2 180037 180037 6
746059 746059 55613 55613 PubChem (substance) 2 260197 260197 7
746061 746061 55613 55613 PubChem (substance) 2 266947 266947 8
746063 746063 55613 55613 PubChem (substance) 2 257363 257363 9
746065 746065 55613 55613 PubChem (substance) 2 284928 284928 10
746066 746066 55613 55613 PubChem (substance) 2 207530 207530 11
746068 746068 55613 55613 PubChem (substance) 2 291036 291036 12
746071 746071 55613 55613 PubChem (substance) 2 320377 320377 13
746073 746073 55613 55613 PubChem (substance) 2 186865 186865 14
746075 746075 55613 55613 PubChem (substance) 2 240584 240584 15
746076 746076 55613 55613 PubChem (substance) 2 264386 264386 16
1008224 1008224 55613 55613 CAS Common Chemistry 3 68309 68309 1
1210220 1210220 55613 55613 Computational Toxicology and Exposure Data 4 68309 68309 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 462.194ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website