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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
5784 5784 435768 435768 PubChem (compound) 1 69419 69419 1
303561 303561 435768 435768 PubChem (substance) 2 69419 69419 1
696741 696741 435768 435768 PubChem (substance) 2 136885 136885 2
696742 696742 435768 435768 PubChem (substance) 2 239236 239236 4
696749 696749 435768 435768 PubChem (substance) 2 189101 189101 3
696754 696754 435768 435768 PubChem (substance) 2 240680 240680 12
696757 696757 435768 435768 PubChem (substance) 2 276442 276442 13
696760 696760 435768 435768 PubChem (substance) 2 309147 309147 14
696767 696767 435768 435768 PubChem (substance) 2 326603 326603 16
696770 696770 435768 435768 PubChem (substance) 2 322065 322065 18
696772 696772 435768 435768 PubChem (substance) 2 186658 186658 5
696777 696777 435768 435768 PubChem (substance) 2 192465 192465 6
696779 696779 435768 435768 PubChem (substance) 2 137667 137667 7
696781 696781 435768 435768 PubChem (substance) 2 204870 204870 8
696784 696784 435768 435768 PubChem (substance) 2 207294 207294 9
696789 696789 435768 435768 PubChem (substance) 2 200846 200846 10
696790 696790 435768 435768 PubChem (substance) 2 324657 324657 11
696793 696793 435768 435768 PubChem (substance) 2 310653 310653 15
696798 696798 435768 435768 PubChem (substance) 2 330195 330195 17
942379 942379 435768 435768 CAS Common Chemistry 3 69419 69419 1
1139861 1139861 435768 435768 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 825.739ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website