home / zeropm-v0-0-4

api_results

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

24 rows where query_id = 331854

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
129334 129334 331854 331854 PubChem (compound) 1 229302 229302 1
129337 129337 331854 331854 PubChem (compound) 1 229499 229499 3
129339 129339 331854 331854 PubChem (compound) 1 137462 137462 2
262763 262763 331854 331854 PubChem (compound) 1 207141 207141 4
262765 262765 331854 331854 PubChem (compound) 1 230544 230544 5
305290 305290 331854 331854 PubChem (substance) 2 92123 92123 16
329668 329668 331854 331854 PubChem (substance) 2 77511 77511 5
477928 477928 331854 331854 PubChem (substance) 2 229302 229302 1
477933 477933 331854 331854 PubChem (substance) 2 229499 229499 3
477938 477938 331854 331854 PubChem (substance) 2 137462 137462 2
648749 648749 331854 331854 PubChem (substance) 2 207141 207141 6
648753 648753 331854 331854 PubChem (substance) 2 230544 230544 4
776815 776815 331854 331854 PubChem (substance) 2 251400 251400 13
776818 776818 331854 331854 PubChem (substance) 2 12218 12218 15
776828 776828 331854 331854 PubChem (substance) 2 288685 288685 12
776832 776832 331854 331854 PubChem (substance) 2 288882 288882 14
776837 776837 331854 331854 PubChem (substance) 2 128498 128498 17
776841 776841 331854 331854 PubChem (substance) 2 179810 179810 7
909666 909666 331854 331854 PubChem (substance) 2 233069 233069 8
909668 909668 331854 331854 PubChem (substance) 2 241852 241852 9
909670 909670 331854 331854 PubChem (substance) 2 195336 195336 10
909673 909673 331854 331854 PubChem (substance) 2 229486 229486 11
1031897 1031897 331854 331854 CAS Common Chemistry 3 12218 12218 1
1234795 1234795 331854 331854 Computational Toxicology and Exposure Data 4 128498 128498 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 424.179ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website