home / zeropm-v0-0-4

api_results

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

27 rows where query_id = 161665

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
180931 180931 161665 161665 PubChem (compound) 1 22610 22610 1
180934 180934 161665 161665 PubChem (compound) 1 217086 217086 2
180935 180935 161665 161665 PubChem (compound) 1 137567 137567 3
180937 180937 161665 161665 PubChem (compound) 1 169299 169299 4
180940 180940 161665 161665 PubChem (compound) 1 188210 188210 5
180941 180941 161665 161665 PubChem (compound) 1 186926 186926 6
180944 180944 161665 161665 PubChem (compound) 1 194714 194714 7
180945 180945 161665 161665 PubChem (compound) 1 208736 208736 8
180947 180947 161665 161665 PubChem (compound) 1 241995 241995 9
180949 180949 161665 161665 PubChem (compound) 1 274255 274255 10
180950 180950 161665 161665 PubChem (compound) 1 321423 321423 11
545955 545955 161665 161665 PubChem (substance) 2 22610 22610 1
545957 545957 161665 161665 PubChem (substance) 2 217086 217086 2
545958 545958 161665 161665 PubChem (substance) 2 137567 137567 3
545961 545961 161665 161665 PubChem (substance) 2 169299 169299 5
545963 545963 161665 161665 PubChem (substance) 2 188210 188210 4
545967 545967 161665 161665 PubChem (substance) 2 186926 186926 7
545968 545968 161665 161665 PubChem (substance) 2 194714 194714 8
545971 545971 161665 161665 PubChem (substance) 2 208736 208736 13
545973 545973 161665 161665 PubChem (substance) 2 241995 241995 6
545974 545974 161665 161665 PubChem (substance) 2 274255 274255 12
545976 545976 161665 161665 PubChem (substance) 2 321423 321423 11
812925 812925 161665 161665 PubChem (substance) 2 188169 188169 9
812926 812926 161665 161665 PubChem (substance) 2 240995 240995 10
812928 812928 161665 161665 PubChem (substance) 2 321870 321870 14
1071038 1071038 161665 161665 CAS Common Chemistry 3 22610 22610 1
1272419 1272419 161665 161665 Computational Toxicology and Exposure Data 4 22610 22610 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 451.009ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website