api_results

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

7 rows where query_id = 139765

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
159956 159956 139765 139765 PubChem (compound) 1 145898 145898 1
438112 438112 139765 139765 PubChem (substance) 2 21585 21585 4
518234 518234 139765 139765 PubChem (substance) 2 145898 145898 1
574126 574126 139765 139765 PubChem (substance) 2 52740 52740 2
798416 798416 139765 139765 PubChem (substance) 2 54459 54459 3
1055206 1055206 139765 139765 CAS Common Chemistry 3 54459 54459 1
1257909 1257909 139765 139765 Computational Toxicology and Exposure Data 4 127109 127109 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)
);