api_results

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

12 rows where query_id = 61613

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
101758 101758 61613 61613 PubChem (compound) 1 230302 230302 1
328688 328688 61613 61613 PubChem (substance) 2 74769 74769 5
439758 439758 61613 61613 PubChem (substance) 2 230302 230302 1
578291 578291 61613 61613 PubChem (substance) 2 295299 295299 6
751798 751798 61613 61613 PubChem (substance) 2 58164 58164 2
751800 751800 61613 61613 PubChem (substance) 2 182739 182739 3
751802 751802 61613 61613 PubChem (substance) 2 255589 255589 4
751804 751804 61613 61613 PubChem (substance) 2 307774 307774 7
751805 751805 61613 61613 PubChem (substance) 2 189653 189653 8
751808 751808 61613 61613 PubChem (substance) 2 308646 308646 9
1013108 1013108 61613 61613 CAS Common Chemistry 3 58164 58164 1
1215242 1215242 61613 61613 Computational Toxicology and Exposure Data 4 135281 135281 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)
);