api_results

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

17 rows where query_id = 113736

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
133082 133082 113736 113736 PubChem (compound) 1 47117 47117 1
482968 482968 113736 113736 PubChem (substance) 2 47117 47117 1
643898 643898 113736 113736 PubChem (substance) 2 243290 243290 9
780258 780258 113736 113736 PubChem (substance) 2 186853 186853 2
780261 780261 113736 113736 PubChem (substance) 2 239076 239076 5
780263 780263 113736 113736 PubChem (substance) 2 289270 289270 4
780266 780266 113736 113736 PubChem (substance) 2 189195 189195 3
780268 780268 113736 113736 PubChem (substance) 2 147180 147180 11
780270 780270 113736 113736 PubChem (substance) 2 200243 200243 8
780272 780272 113736 113736 PubChem (substance) 2 309954 309954 13
780274 780274 113736 113736 PubChem (substance) 2 200111 200111 6
780275 780275 113736 113736 PubChem (substance) 2 198196 198196 7
780276 780276 113736 113736 PubChem (substance) 2 278067 278067 10
780277 780277 113736 113736 PubChem (substance) 2 231251 231251 12
780278 780278 113736 113736 PubChem (substance) 2 291650 291650 14
1034805 1034805 113736 113736 CAS Common Chemistry 3 47117 47117 1
1237776 1237776 113736 113736 Computational Toxicology and Exposure Data 4 47117 47117 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)
);