home / zeropm-v0-0-4

api_results

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

27 rows where query_id = 113734

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
37781 37781 113734 113734 PubChem (compound) 1 47116 47116 1
349742 349742 113734 113734 PubChem (substance) 2 47116 47116 1
349747 349747 113734 113734 PubChem (substance) 2 137077 137077 2
482966 482966 113734 113734 PubChem (substance) 2 47117 47117 18
716061 716061 113734 113734 PubChem (substance) 2 217157 217157 5
716064 716064 113734 113734 PubChem (substance) 2 138059 138059 7
716066 716066 113734 113734 PubChem (substance) 2 277342 277342 9
716067 716067 113734 113734 PubChem (substance) 2 192033 192033 4
716070 716070 113734 113734 PubChem (substance) 2 239241 239241 19
716072 716072 113734 113734 PubChem (substance) 2 189078 189078 3
716074 716074 113734 113734 PubChem (substance) 2 289482 289482 23
780244 780244 113734 113734 PubChem (substance) 2 208743 208743 6
780245 780245 113734 113734 PubChem (substance) 2 246035 246035 8
780246 780246 113734 113734 PubChem (substance) 2 186323 186323 10
780247 780247 113734 113734 PubChem (substance) 2 198553 198553 11
780248 780248 113734 113734 PubChem (substance) 2 198554 198554 12
780249 780249 113734 113734 PubChem (substance) 2 198555 198555 13
780250 780250 113734 113734 PubChem (substance) 2 198556 198556 14
780251 780251 113734 113734 PubChem (substance) 2 195398 195398 15
780252 780252 113734 113734 PubChem (substance) 2 195517 195517 16
780253 780253 113734 113734 PubChem (substance) 2 235261 235261 17
780254 780254 113734 113734 PubChem (substance) 2 270449 270449 20
780255 780255 113734 113734 PubChem (substance) 2 270462 270462 21
780256 780256 113734 113734 PubChem (substance) 2 240049 240049 22
780257 780257 113734 113734 PubChem (substance) 2 291649 291649 24
965676 965676 113734 113734 CAS Common Chemistry 3 47116 47116 1
1167480 1167480 113734 113734 Computational Toxicology and Exposure Data 4 47116 47116 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 831.147ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website