home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 3056

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
5782 5782 3056 3056 PubChem (compound) 1 69419 69419 1
303557 303557 3056 3056 PubChem (substance) 2 69419 69419 1
696740 696740 3056 3056 PubChem (substance) 2 136885 136885 2
696744 696744 3056 3056 PubChem (substance) 2 239236 239236 4
696747 696747 3056 3056 PubChem (substance) 2 189101 189101 3
696752 696752 3056 3056 PubChem (substance) 2 240680 240680 12
696758 696758 3056 3056 PubChem (substance) 2 276442 276442 13
696763 696763 3056 3056 PubChem (substance) 2 309147 309147 14
696765 696765 3056 3056 PubChem (substance) 2 326603 326603 16
696768 696768 3056 3056 PubChem (substance) 2 322065 322065 18
696774 696774 3056 3056 PubChem (substance) 2 186658 186658 5
696775 696775 3056 3056 PubChem (substance) 2 192465 192465 6
696780 696780 3056 3056 PubChem (substance) 2 137667 137667 7
696782 696782 3056 3056 PubChem (substance) 2 204870 204870 8
696785 696785 3056 3056 PubChem (substance) 2 207294 207294 9
696788 696788 3056 3056 PubChem (substance) 2 200846 200846 10
696791 696791 3056 3056 PubChem (substance) 2 324657 324657 11
696794 696794 3056 3056 PubChem (substance) 2 310653 310653 15
696797 696797 3056 3056 PubChem (substance) 2 330195 330195 17
942380 942380 3056 3056 CAS Common Chemistry 3 69419 69419 1
1139859 1139859 3056 3056 Computational Toxicology and Exposure Data 4 69419 69419 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 411.223ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website