home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 136123

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
156249 156249 136123 136123 PubChem (compound) 1 43999 43999 1
430198 430198 136123 136123 PubChem (substance) 2 58037 58037 17
513381 513381 136123 136123 PubChem (substance) 2 43999 43999 1
622158 622158 136123 136123 PubChem (substance) 2 120186 120186 14
746539 746539 136123 136123 PubChem (substance) 2 136753 136753 16
795947 795947 136123 136123 PubChem (substance) 2 136757 136757 4
795948 795948 136123 136123 PubChem (substance) 2 186708 186708 2
795951 795951 136123 136123 PubChem (substance) 2 224309 224309 3
795952 795952 136123 136123 PubChem (substance) 2 210277 210277 5
795954 795954 136123 136123 PubChem (substance) 2 218873 218873 6
795956 795956 136123 136123 PubChem (substance) 2 195200 195200 7
795957 795957 136123 136123 PubChem (substance) 2 197893 197893 8
795958 795958 136123 136123 PubChem (substance) 2 197894 197894 9
795959 795959 136123 136123 PubChem (substance) 2 176835 176835 10
795960 795960 136123 136123 PubChem (substance) 2 176836 176836 11
795961 795961 136123 136123 PubChem (substance) 2 191067 191067 12
795963 795963 136123 136123 PubChem (substance) 2 210288 210288 13
795964 795964 136123 136123 PubChem (substance) 2 258414 258414 15
1052437 1052437 136123 136123 CAS Common Chemistry 3 43999 43999 1
1255155 1255155 136123 136123 Computational Toxicology and Exposure Data 4 43999 43999 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 435.658ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website