api_results

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

9 rows where query_id = 149749

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
168986 168986 149749 149749 PubChem (compound) 1 7972 7972 1
530409 530409 149749 149749 PubChem (substance) 2 7972 7972 1
697164 697164 149749 149749 PubChem (substance) 2 146398 146398 2
717667 717667 149749 149749 PubChem (substance) 2 203014 203014 6
804758 804758 149749 149749 PubChem (substance) 2 333485 333485 3
804759 804759 149749 149749 PubChem (substance) 2 164166 164166 4
804760 804760 149749 149749 PubChem (substance) 2 258293 258293 5
1062189 1062189 149749 149749 CAS Common Chemistry 3 7972 7972 1
1264295 1264295 149749 149749 Computational Toxicology and Exposure Data 4 131054 131054 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)
);