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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
9203 9203 108579 108579 PubChem (compound) 1 180017 180017 3
106392 106392 108579 108579 PubChem (compound) 1 195269 195269 1
127826 127826 108579 108579 PubChem (compound) 1 220948 220948 2
308339 308339 108579 108579 PubChem (substance) 2 180017 180017 12
308345 308345 108579 108579 PubChem (substance) 2 137447 137447 7
446174 446174 108579 108579 PubChem (substance) 2 195269 195269 1
446179 446179 108579 108579 PubChem (substance) 2 170823 170823 9
446182 446182 108579 108579 PubChem (substance) 2 207190 207190 4
446186 446186 108579 108579 PubChem (substance) 2 227547 227547 3
446192 446192 108579 108579 PubChem (substance) 2 241911 241911 11
446196 446196 108579 108579 PubChem (substance) 2 232231 232231 10
475930 475930 108579 108579 PubChem (substance) 2 220948 220948 2
653062 653062 108579 108579 PubChem (substance) 2 208503 208503 13
775298 775298 108579 108579 PubChem (substance) 2 137756 137756 5
775299 775299 108579 108579 PubChem (substance) 2 242702 242702 6
775300 775300 108579 108579 PubChem (substance) 2 277410 277410 8
1016232 1016232 108579 108579 CAS Common Chemistry 3 4483 4483 1
1142878 1142878 108579 108579 Computational Toxicology and Exposure Data 4 46096 46096 2
1218384 1218384 108579 108579 Computational Toxicology and Exposure Data 4 4483 4483 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 456.669ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website