api_results

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

13 rows where inchi_id = 3946

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
43691 43691 19583 19583 PubChem (compound) 1 3946 3946 1
43692 43692 19584 19584 PubChem (compound) 1 3946 3946 1
43693 43693 121555 121555 PubChem (compound) 1 3946 3946 1
357746 357746 19584 19584 PubChem (substance) 2 3946 3946 1
357747 357747 19583 19583 PubChem (substance) 2 3946 3946 1
357748 357748 121769 121769 PubChem (substance) 2 3946 3946 2
357749 357749 121555 121555 PubChem (substance) 2 3946 3946 1
357750 357750 348766 348766 PubChem (substance) 2 3946 3946 1
970140 970140 19584 19584 CAS Common Chemistry 3 3946 3946 1
970141 970141 19583 19583 CAS Common Chemistry 3 3946 3946 1
970142 970142 121555 121555 CAS Common Chemistry 3 3946 3946 1
1172392 1172392 19583 19583 Computational Toxicology and Exposure Data 4 3946 3946 1
1172393 1172393 19584 19584 Computational Toxicology and Exposure Data 4 3946 3946 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)
);