home / zeropm-v0-0-4

api_results

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

28 rows where query_id = 319928

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
3284 3284 319928 319928 PubChem (compound) 1 422 422 1
300103 300103 319928 319928 PubChem (substance) 2 422 422 1
382600 382600 319928 319928 PubChem (substance) 2 365 365 3
659574 659574 319928 319928 PubChem (substance) 2 124382 124382 6
694740 694740 319928 319928 PubChem (substance) 2 422 422 2
694753 694753 319928 319928 PubChem (substance) 2 223504 223504 5
694763 694763 319928 319928 PubChem (substance) 2 365 365 4
694773 694773 319928 319928 PubChem (substance) 2 232060 232060 7
694787 694787 319928 319928 PubChem (substance) 2 232061 232061 8
694806 694806 319928 319928 PubChem (substance) 2 232062 232062 9
694819 694819 319928 319928 PubChem (substance) 2 232063 232063 10
694825 694825 319928 319928 PubChem (substance) 2 232064 232064 11
694843 694843 319928 319928 PubChem (substance) 2 232065 232065 12
694854 694854 319928 319928 PubChem (substance) 2 232066 232066 13
694864 694864 319928 319928 PubChem (substance) 2 232067 232067 14
694878 694878 319928 319928 PubChem (substance) 2 232068 232068 15
694886 694886 319928 319928 PubChem (substance) 2 232069 232069 16
694896 694896 319928 319928 PubChem (substance) 2 232070 232070 17
694904 694904 319928 319928 PubChem (substance) 2 232071 232071 18
694916 694916 319928 319928 PubChem (substance) 2 232072 232072 19
694921 694921 319928 319928 PubChem (substance) 2 232073 232073 20
694935 694935 319928 319928 PubChem (substance) 2 232074 232074 21
694952 694952 319928 319928 PubChem (substance) 2 232075 232075 22
694958 694958 319928 319928 PubChem (substance) 2 232076 232076 23
694971 694971 319928 319928 PubChem (substance) 2 232077 232077 24
694979 694979 319928 319928 PubChem (substance) 2 232078 232078 25
940492 940492 319928 319928 CAS Common Chemistry 3 422 422 1
1137667 1137667 319928 319928 Computational Toxicology and Exposure Data 4 422 422 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 1953.45ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website