home / zeropm-v0-0-4

api_results

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

19 rows where query_id = 58182

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
79793 79793 58182 58182 PubChem (compound) 1 229888 229888 5
97882 97882 58182 58182 PubChem (compound) 1 128895 128895 1
97883 97883 58182 58182 PubChem (compound) 1 229888 229888 2
97885 97885 58182 58182 PubChem (compound) 1 128895 128895 3
97887 97887 58182 58182 PubChem (compound) 1 130586 130586 4
97892 97892 58182 58182 PubChem (compound) 1 128895 128895 6
408800 408800 58182 58182 PubChem (substance) 2 229888 229888 9
434051 434051 58182 58182 PubChem (substance) 2 34117 34117 11
434053 434053 58182 58182 PubChem (substance) 2 128895 128895 1
434060 434060 58182 58182 PubChem (substance) 2 229888 229888 3
434061 434061 58182 58182 PubChem (substance) 2 128895 128895 4
434067 434067 58182 58182 PubChem (substance) 2 130586 130586 5
434074 434074 58182 58182 PubChem (substance) 2 128895 128895 10
748560 748560 58182 58182 PubChem (substance) 2 287393 287393 2
748562 748562 58182 58182 PubChem (substance) 2 158716 158716 6
748565 748565 58182 58182 PubChem (substance) 2 191919 191919 7
748567 748567 58182 58182 PubChem (substance) 2 68281 68281 8
1010519 1010519 58182 58182 CAS Common Chemistry 3 68281 68281 1
1212630 1212630 58182 58182 Computational Toxicology and Exposure Data 4 128895 128895 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 470.722ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website