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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
99757 99757 114503 114503 PubChem (compound) 1 50172 50172 1
436880 436880 114503 114503 PubChem (substance) 2 45292 45292 4
436891 436891 114503 114503 PubChem (substance) 2 50172 50172 1
651631 651631 114503 114503 PubChem (substance) 2 192425 192425 8
749979 749979 114503 114503 PubChem (substance) 2 136979 136979 2
749987 749987 114503 114503 PubChem (substance) 2 186306 186306 3
749995 749995 114503 114503 PubChem (substance) 2 240053 240053 17
781052 781052 114503 114503 PubChem (substance) 2 174608 174608 5
781053 781053 114503 114503 PubChem (substance) 2 162617 162617 6
781054 781054 114503 114503 PubChem (substance) 2 200601 200601 7
781055 781055 114503 114503 PubChem (substance) 2 195358 195358 9
781056 781056 114503 114503 PubChem (substance) 2 206047 206047 10
781057 781057 114503 114503 PubChem (substance) 2 176181 176181 11
781058 781058 114503 114503 PubChem (substance) 2 176182 176182 12
781059 781059 114503 114503 PubChem (substance) 2 176183 176183 13
781060 781060 114503 114503 PubChem (substance) 2 173915 173915 14
781061 781061 114503 114503 PubChem (substance) 2 176237 176237 15
781062 781062 114503 114503 PubChem (substance) 2 199736 199736 16
1011749 1011749 114503 114503 CAS Common Chemistry 3 50172 50172 1
1213868 1213868 114503 114503 Computational Toxicology and Exposure Data 4 50172 50172 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 419.519ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website