api_results

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

12 rows where query_id = 121501

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
493904 493904 121501 121501 PubChem (substance) 2 44577 44577 3
697711 697711 121501 121501 PubChem (substance) 2 168866 168866 4
786004 786004 121501 121501 PubChem (substance) 2 3864 3864 1
786008 786008 121501 121501 PubChem (substance) 2 216952 216952 2
786010 786010 121501 121501 PubChem (substance) 2 184424 184424 5
786011 786011 121501 121501 PubChem (substance) 2 240614 240614 6
786013 786013 121501 121501 PubChem (substance) 2 291132 291132 7
786016 786016 121501 121501 PubChem (substance) 2 199578 199578 8
786017 786017 121501 121501 PubChem (substance) 2 307716 307716 9
786019 786019 121501 121501 PubChem (substance) 2 323771 323771 10
1041288 1041288 121501 121501 CAS Common Chemistry 3 3864 3864 1
1244247 1244247 121501 121501 Computational Toxicology and Exposure Data 4 44577 44577 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)
);