api_results

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

11 rows where query_id = 138844

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
159018 159018 138844 138844 PubChem (compound) 1 51615 51615 1
516978 516978 138844 138844 PubChem (substance) 2 51615 51615 1
797766 797766 138844 138844 PubChem (substance) 2 137513 137513 2
797768 797768 138844 138844 PubChem (substance) 2 174034 174034 3
797770 797770 138844 138844 PubChem (substance) 2 237570 237570 4
797771 797771 138844 138844 PubChem (substance) 2 235266 235266 5
797773 797773 138844 138844 PubChem (substance) 2 255545 255545 6
797775 797775 138844 138844 PubChem (substance) 2 290647 290647 7
797777 797777 138844 138844 PubChem (substance) 2 258852 258852 8
1054504 1054504 138844 138844 CAS Common Chemistry 3 51615 51615 1
1257237 1257237 138844 138844 Computational Toxicology and Exposure Data 4 51615 51615 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)
);