api_results

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

17 rows where query_id = 104977

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
124983 124983 104977 104977 PubChem (compound) 1 53084 53084 1
472081 472081 104977 104977 PubChem (substance) 2 53084 53084 1
553198 553198 104977 104977 PubChem (substance) 2 216742 216742 5
667884 667884 104977 104977 PubChem (substance) 2 136489 136489 4
772335 772335 104977 104977 PubChem (substance) 2 228725 228725 2
772336 772336 104977 104977 PubChem (substance) 2 220980 220980 3
772338 772338 104977 104977 PubChem (substance) 2 175617 175617 6
772339 772339 104977 104977 PubChem (substance) 2 201069 201069 7
772340 772340 104977 104977 PubChem (substance) 2 190153 190153 8
772341 772341 104977 104977 PubChem (substance) 2 228791 228791 9
772342 772342 104977 104977 PubChem (substance) 2 279121 279121 10
772344 772344 104977 104977 PubChem (substance) 2 169402 169402 11
772346 772346 104977 104977 PubChem (substance) 2 207195 207195 12
772347 772347 104977 104977 PubChem (substance) 2 292582 292582 13
772348 772348 104977 104977 PubChem (substance) 2 253849 253849 14
1028693 1028693 104977 104977 CAS Common Chemistry 3 53084 53084 1
1231525 1231525 104977 104977 Computational Toxicology and Exposure Data 4 53084 53084 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)
);