api_results

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

14 rows where query_id = 7470

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
14034 14034 7470 7470 PubChem (compound) 1 75493 75493 1
308071 308071 7470 7470 PubChem (substance) 2 75990 75990 1
315437 315437 7470 7470 PubChem (substance) 2 75493 75493 2
320693 320693 7470 7470 PubChem (substance) 2 16458 16458 11
645393 645393 7470 7470 PubChem (substance) 2 140554 140554 3
649518 649518 7470 7470 PubChem (substance) 2 19157 19157 10
695090 695090 7470 7470 PubChem (substance) 2 188298 188298 6
702497 702497 7470 7470 PubChem (substance) 2 149199 149199 5
702500 702500 7470 7470 PubChem (substance) 2 149226 149226 4
702504 702504 7470 7470 PubChem (substance) 2 149200 149200 7
702506 702506 7470 7470 PubChem (substance) 2 149289 149289 8
702509 702509 7470 7470 PubChem (substance) 2 149321 149321 9
948619 948619 7470 7470 CAS Common Chemistry 3 75493 75493 1
1147166 1147166 7470 7470 Computational Toxicology and Exposure Data 4 75493 75493 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)
);