api_results

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

12 rows where inchi_id = 3097

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
141263 141263 121344 121344 PubChem (compound) 1 3097 3097 1
141264 141264 121343 121343 PubChem (compound) 1 3097 3097 1
493697 493697 166457 166457 PubChem (substance) 2 3097 3097 1
493698 493698 111589 111589 PubChem (substance) 2 3097 3097 2
493699 493699 121344 121344 PubChem (substance) 2 3097 3097 1
493700 493700 166458 166458 PubChem (substance) 2 3097 3097 1
493701 493701 121343 121343 PubChem (substance) 2 3097 3097 1
1041154 1041154 166458 166458 CAS Common Chemistry 3 3097 3097 1
1041155 1041155 121343 121343 CAS Common Chemistry 3 3097 3097 1
1041156 1041156 121344 121344 CAS Common Chemistry 3 3097 3097 1
1244114 1244114 121344 121344 Computational Toxicology and Exposure Data 4 3097 3097 1
1244115 1244115 121343 121343 Computational Toxicology and Exposure Data 4 3097 3097 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)
);