api_results

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

9 rows where query_id = 397014

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
281152 281152 397014 397014 PubChem (compound) 1 111621 111621 1
281153 281153 397014 397014 PubChem (compound) 1 284834 284834 2
299213 299213 397014 397014 PubChem (substance) 2 36775 36775 6
673743 673743 397014 397014 PubChem (substance) 2 111621 111621 1
673744 673744 397014 397014 PubChem (substance) 2 284834 284834 2
762553 762553 397014 397014 PubChem (substance) 2 258937 258937 5
915952 915952 397014 397014 PubChem (substance) 2 264552 264552 3
930757 930757 397014 397014 PubChem (substance) 2 308218 308218 4
1337828 1337828 397014 397014 Computational Toxicology and Exposure Data 4 111621 111621 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)
);