api_results

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

11 rows where query_id = 185558

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
203482 203482 185558 185558 PubChem (compound) 1 53987 53987 1
429006 429006 185558 185558 PubChem (substance) 2 4137 4137 5
575230 575230 185558 185558 PubChem (substance) 2 53987 53987 1
825946 825946 185558 185558 PubChem (substance) 2 136959 136959 2
825949 825949 185558 185558 PubChem (substance) 2 111435 111435 3
825950 825950 185558 185558 PubChem (substance) 2 210496 210496 4
825951 825951 185558 185558 PubChem (substance) 2 218717 218717 6
825952 825952 185558 185558 PubChem (substance) 2 284451 284451 7
825953 825953 185558 185558 PubChem (substance) 2 207152 207152 8
1086274 1086274 185558 185558 CAS Common Chemistry 3 53987 53987 1
1287952 1287952 185558 185558 Computational Toxicology and Exposure Data 4 111435 111435 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)
);