api_results

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

15 rows where query_id = 385148

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
274903 274903 385148 385148 PubChem (compound) 1 44762 44762 1
336258 336258 385148 385148 PubChem (substance) 2 64 64 7
480896 480896 385148 385148 PubChem (substance) 2 43491 43491 6
665854 665854 385148 385148 PubChem (substance) 2 44762 44762 1
693636 693636 385148 385148 PubChem (substance) 2 188577 188577 2
723719 723719 385148 385148 PubChem (substance) 2 141144 141144 4
924269 924269 385148 385148 PubChem (substance) 2 239242 239242 3
924270 924270 385148 385148 PubChem (substance) 2 289247 289247 5
924271 924271 385148 385148 PubChem (substance) 2 277791 277791 8
924272 924272 385148 385148 PubChem (substance) 2 292528 292528 9
924273 924273 385148 385148 PubChem (substance) 2 296185 296185 10
924274 924274 385148 385148 PubChem (substance) 2 290746 290746 11
924275 924275 385148 385148 PubChem (substance) 2 279724 279724 12
1120941 1120941 385148 385148 CAS Common Chemistry 3 44762 44762 1
1333431 1333431 385148 385148 Computational Toxicology and Exposure Data 4 44762 44762 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)
);