api_results

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

11 rows where query_id = 340486

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
265033 265033 340486 340486 PubChem (compound) 1 53766 53766 1
490193 490193 340486 340486 PubChem (substance) 2 75744 75744 8
516928 516928 340486 340486 PubChem (substance) 2 51502 51502 2
517140 517140 340486 340486 PubChem (substance) 2 52004 52004 5
652470 652470 340486 340486 PubChem (substance) 2 53766 53766 1
912662 912662 340486 340486 PubChem (substance) 2 53766 53766 7
912751 912751 340486 340486 PubChem (substance) 2 185368 185368 3
912752 912752 340486 340486 PubChem (substance) 2 186576 186576 4
912753 912753 340486 340486 PubChem (substance) 2 177857 177857 6
1115545 1115545 340486 340486 CAS Common Chemistry 3 53766 53766 1
1327365 1327365 340486 340486 Computational Toxicology and Exposure Data 4 53766 53766 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)
);