api_results

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

6 rows where query_id = 31793

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
329211 329211 31793 31793 PubChem (substance) 2 76677 76677 3
390324 390324 31793 31793 PubChem (substance) 2 15402 15402 2
732095 732095 31793 31793 PubChem (substance) 2 225897 225897 1
732098 732098 31793 31793 PubChem (substance) 2 166456 166456 4
987046 987046 31793 31793 CAS Common Chemistry 3 15402 15402 1
1189956 1189956 31793 31793 Computational Toxicology and Exposure Data 4 15402 15402 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)
);