api_results

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

8 rows where query_id = 172151

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
472295 472295 172151 172151 PubChem (substance) 2 58689 58689 3
559022 559022 172151 172151 PubChem (substance) 2 228652 228652 1
559024 559024 172151 172151 PubChem (substance) 2 35492 35492 5
559026 559026 172151 172151 PubChem (substance) 2 228652 228652 7
818960 818960 172151 172151 PubChem (substance) 2 289233 289233 2
818962 818962 172151 172151 PubChem (substance) 2 274645 274645 6
818965 818965 172151 172151 PubChem (substance) 2 259997 259997 4
818966 818966 172151 172151 PubChem (substance) 2 285349 285349 8 
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)
);