api_results

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

14 rows where query_id = 109277

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
128432 128432 109277 109277 PubChem (compound) 1 7045 7045 1
476713 476713 109277 109277 PubChem (substance) 2 7045 7045 1
766649 766649 109277 109277 PubChem (substance) 2 287852 287852 9
775825 775825 109277 109277 PubChem (substance) 2 137534 137534 2
775826 775826 109277 109277 PubChem (substance) 2 189160 189160 3
775828 775828 109277 109277 PubChem (substance) 2 227600 227600 4
775830 775830 109277 109277 PubChem (substance) 2 291053 291053 5
775832 775832 109277 109277 PubChem (substance) 2 248828 248828 6
775833 775833 109277 109277 PubChem (substance) 2 178721 178721 7
775834 775834 109277 109277 PubChem (substance) 2 220990 220990 8
775835 775835 109277 109277 PubChem (substance) 2 234288 234288 10
775836 775836 109277 109277 PubChem (substance) 2 326210 326210 11
1031263 1031263 109277 109277 CAS Common Chemistry 3 7045 7045 1
1234156 1234156 109277 109277 Computational Toxicology and Exposure Data 4 7045 7045 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)
);