home / zeropm-v0-0-4

api_results

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

18 rows where query_id = 147042

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
22917 22917 147042 147042 PubChem (compound) 1 74747 74747 2
166515 166515 147042 147042 PubChem (compound) 1 1429 1429 1
166517 166517 147042 147042 PubChem (compound) 1 237647 237647 3
166518 166518 147042 147042 PubChem (compound) 1 185929 185929 4
166519 166519 147042 147042 PubChem (compound) 1 157874 157874 5
166520 166520 147042 147042 PubChem (compound) 1 203960 203960 6
166522 166522 147042 147042 PubChem (compound) 1 209027 209027 7
328586 328586 147042 147042 PubChem (substance) 2 74747 74747 2
526925 526925 147042 147042 PubChem (substance) 2 1429 1429 1
526927 526927 147042 147042 PubChem (substance) 2 237647 237647 3
526928 526928 147042 147042 PubChem (substance) 2 185929 185929 4
526931 526931 147042 147042 PubChem (substance) 2 157874 157874 6
526934 526934 147042 147042 PubChem (substance) 2 203960 203960 5
526938 526938 147042 147042 PubChem (substance) 2 209027 209027 9
773341 773341 147042 147042 PubChem (substance) 2 176152 176152 7
802954 802954 147042 147042 PubChem (substance) 2 289532 289532 8
1060081 1060081 147042 147042 CAS Common Chemistry 3 1429 1429 1
1262540 1262540 147042 147042 Computational Toxicology and Exposure Data 4 1429 1429 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 2249.17ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website