api_results

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

12 rows where query_id = 142000

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
162117 162117 142000 142000 PubChem (compound) 1 61043 61043 1
478663 478663 142000 142000 PubChem (substance) 2 31706 31706 6
521035 521035 142000 142000 PubChem (substance) 2 61043 61043 1
799881 799881 142000 142000 PubChem (substance) 2 136337 136337 2
799882 799882 142000 142000 PubChem (substance) 2 218810 218810 3
799883 799883 142000 142000 PubChem (substance) 2 61043 61043 4
799884 799884 142000 142000 PubChem (substance) 2 176291 176291 5
799885 799885 142000 142000 PubChem (substance) 2 288987 288987 7
799886 799886 142000 142000 PubChem (substance) 2 295328 295328 8
799887 799887 142000 142000 PubChem (substance) 2 245635 245635 9
1056781 1056781 142000 142000 CAS Common Chemistry 3 61043 61043 1
1259383 1259383 142000 142000 Computational Toxicology and Exposure Data 4 61043 61043 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)
);