home / zeropm-v0-0-4

api_results

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

15 rows where query_id = 19729

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
44056 44056 19729 19729 PubChem (compound) 1 229231 229231 1
44059 44059 19729 19729 PubChem (compound) 1 5067 5067 2
44060 44060 19729 19729 PubChem (compound) 1 229231 229231 3
358284 358284 19729 19729 PubChem (substance) 2 229231 229231 1
358287 358287 19729 19729 PubChem (substance) 2 5067 5067 4
358288 358288 19729 19729 PubChem (substance) 2 229231 229231 8
718726 718726 19729 19729 PubChem (substance) 2 183460 183460 2
718729 718729 19729 19729 PubChem (substance) 2 229824 229824 3
718732 718732 19729 19729 PubChem (substance) 2 275200 275200 5
718734 718734 19729 19729 PubChem (substance) 2 320372 320372 6
718735 718735 19729 19729 PubChem (substance) 2 249876 249876 7
718736 718736 19729 19729 PubChem (substance) 2 307701 307701 9
718737 718737 19729 19729 PubChem (substance) 2 321618 321618 10
970408 970408 19729 19729 CAS Common Chemistry 3 5067 5067 1
1172699 1172699 19729 19729 Computational Toxicology and Exposure Data 4 95457 95457 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 445.58ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website