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 = 105333

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
5783 5783 105333 105333 PubChem (compound) 1 69419 69419 1
303559 303559 105333 105333 PubChem (substance) 2 69419 69419 1
696738 696738 105333 105333 PubChem (substance) 2 136885 136885 2
696745 696745 105333 105333 PubChem (substance) 2 239236 239236 4
696748 696748 105333 105333 PubChem (substance) 2 189101 189101 3
696755 696755 105333 105333 PubChem (substance) 2 240680 240680 12
696759 696759 105333 105333 PubChem (substance) 2 276442 276442 13
696762 696762 105333 105333 PubChem (substance) 2 309147 309147 14
696766 696766 105333 105333 PubChem (substance) 2 326603 326603 16
696771 696771 105333 105333 PubChem (substance) 2 322065 322065 18
696773 696773 105333 105333 PubChem (substance) 2 186658 186658 5
696776 696776 105333 105333 PubChem (substance) 2 192465 192465 6
696778 696778 105333 105333 PubChem (substance) 2 137667 137667 7
696783 696783 105333 105333 PubChem (substance) 2 204870 204870 8
696786 696786 105333 105333 PubChem (substance) 2 207294 207294 9
696787 696787 105333 105333 PubChem (substance) 2 200846 200846 10
696792 696792 105333 105333 PubChem (substance) 2 324657 324657 11
696795 696795 105333 105333 PubChem (substance) 2 310653 310653 15
696796 696796 105333 105333 PubChem (substance) 2 330195 330195 17
942381 942381 105333 105333 CAS Common Chemistry 3 69419 69419 1
1139858 1139858 105333 105333 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 941.67ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website