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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
102190 102190 361842 361842 PubChem (compound) 1 45291 45291 1
440351 440351 361842 361842 PubChem (substance) 2 45291 45291 1
651835 651835 361842 361842 PubChem (substance) 2 204863 204863 3
651841 651841 361842 361842 PubChem (substance) 2 137375 137375 2
651845 651845 361842 361842 PubChem (substance) 2 249870 249870 18
752127 752127 361842 361842 PubChem (substance) 2 227359 227359 5
752130 752130 361842 361842 PubChem (substance) 2 189150 189150 4
752134 752134 361842 361842 PubChem (substance) 2 261964 261964 15
752137 752137 361842 361842 PubChem (substance) 2 266825 266825 16
752139 752139 361842 361842 PubChem (substance) 2 308500 308500 19
770941 770941 361842 361842 PubChem (substance) 2 180086 180086 6
770942 770942 361842 361842 PubChem (substance) 2 206746 206746 7
770945 770945 361842 361842 PubChem (substance) 2 206747 206747 8
770946 770946 361842 361842 PubChem (substance) 2 206748 206748 9
770949 770949 361842 361842 PubChem (substance) 2 206749 206749 10
770951 770951 361842 361842 PubChem (substance) 2 207524 207524 11
770952 770952 361842 361842 PubChem (substance) 2 176256 176256 12
770955 770955 361842 361842 PubChem (substance) 2 200194 200194 13
770956 770956 361842 361842 PubChem (substance) 2 284042 284042 14
770959 770959 361842 361842 PubChem (substance) 2 213756 213756 17
770961 770961 361842 361842 PubChem (substance) 2 291651 291651 20
770963 770963 361842 361842 PubChem (substance) 2 140858 140858 21
1013406 1013406 361842 361842 CAS Common Chemistry 3 45291 45291 1
1215530 1215530 361842 361842 Computational Toxicology and Exposure Data 4 45291 45291 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 1156.064ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website