api_results

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

13 rows where query_id = 139

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
336 336 139 139 PubChem (compound) 1 38260 38260 2
344 344 139 139 PubChem (compound) 1 120592 120592 1
351 351 139 139 PubChem (compound) 1 38260 38260 3
354 354 139 139 PubChem (compound) 1 120592 120592 4
355 355 139 139 PubChem (compound) 1 120592 120592 5
296028 296028 139 139 PubChem (substance) 2 38260 38260 2
296035 296035 139 139 PubChem (substance) 2 120592 120592 1
296046 296046 139 139 PubChem (substance) 2 38260 38260 3
296051 296051 139 139 PubChem (substance) 2 120592 120592 6
296054 296054 139 139 PubChem (substance) 2 120592 120592 5
296118 296118 139 139 PubChem (substance) 2 64734 64734 4
938389 938389 139 139 CAS Common Chemistry 3 31531 31531 1
1135043 1135043 139 139 Computational Toxicology and Exposure Data 4 120592 120592 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)
);