api_results

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

9 rows where query_id = 8966

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
16772 16772 8966 8966 PubChem (compound) 1 107679 107679 1
301610 301610 8966 8966 PubChem (substance) 2 134084 134084 3
305664 305664 8966 8966 PubChem (substance) 2 1161 1161 4
319308 319308 8966 8966 PubChem (substance) 2 107679 107679 1
704162 704162 8966 8966 PubChem (substance) 2 332423 332423 2
704163 704163 8966 8966 PubChem (substance) 2 225421 225421 5
704164 704164 8966 8966 PubChem (substance) 2 296291 296291 6
950662 950662 8966 8966 CAS Common Chemistry 3 260 260 1
1149600 1149600 8966 8966 Computational Toxicology and Exposure Data 4 107679 107679 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)
);