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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
115777 115777 252079 252079 PubChem (compound) 1 235105 235105 2
115779 115779 252079 252079 PubChem (compound) 1 119174 119174 1
246251 246251 252079 252079 PubChem (compound) 1 119174 119174 3
246252 246252 252079 252079 PubChem (compound) 1 119174 119174 4
459050 459050 252079 252079 PubChem (substance) 2 235105 235105 3
459053 459053 252079 252079 PubChem (substance) 2 119174 119174 1
551713 551713 252079 252079 PubChem (substance) 2 28464 28464 7
628893 628893 252079 252079 PubChem (substance) 2 119174 119174 13
628895 628895 252079 252079 PubChem (substance) 2 119174 119174 12
645381 645381 252079 252079 PubChem (substance) 2 8745 8745 6
764023 764023 252079 252079 PubChem (substance) 2 262849 262849 9
764026 764026 252079 252079 PubChem (substance) 2 272429 272429 2
816271 816271 252079 252079 PubChem (substance) 2 263065 263065 8
843041 843041 252079 252079 PubChem (substance) 2 332654 332654 4
843042 843042 252079 252079 PubChem (substance) 2 291191 291191 5
843043 843043 252079 252079 PubChem (substance) 2 320455 320455 10
843044 843044 252079 252079 PubChem (substance) 2 29953 29953 11
1110569 1110569 252079 252079 CAS Common Chemistry 3 29953 29953 1
1316358 1316358 252079 252079 Computational Toxicology and Exposure Data 4 119174 119174 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 2054.769ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website