api_results

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

6 rows where query_id = 125255

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
145274 145274 125255 125255 PubChem (compound) 1 18349 18349 1
342849 342849 125255 125255 PubChem (substance) 2 6808 6808 2
481019 481019 125255 125255 PubChem (substance) 2 43614 43614 3
499138 499138 125255 125255 PubChem (substance) 2 18349 18349 1
1044077 1044077 125255 125255 CAS Common Chemistry 3 18349 18349 1
1246974 1246974 125255 125255 Computational Toxicology and Exposure Data 4 18349 18349 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)
);