api_results

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

15 rows where query_id = 109278

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
128434 128434 109278 109278 PubChem (compound) 1 7045 7045 1
476715 476715 109278 109278 PubChem (substance) 2 7045 7045 1
617978 617978 109278 109278 PubChem (substance) 2 74746 74746 9
766648 766648 109278 109278 PubChem (substance) 2 287852 287852 7
775823 775823 109278 109278 PubChem (substance) 2 137534 137534 3
775827 775827 109278 109278 PubChem (substance) 2 189160 189160 2
775829 775829 109278 109278 PubChem (substance) 2 227600 227600 4
775831 775831 109278 109278 PubChem (substance) 2 291053 291053 10
775837 775837 109278 109278 PubChem (substance) 2 326210 326210 12
775838 775838 109278 109278 PubChem (substance) 2 192345 192345 5
775839 775839 109278 109278 PubChem (substance) 2 246921 246921 6
775840 775840 109278 109278 PubChem (substance) 2 240659 240659 8
775841 775841 109278 109278 PubChem (substance) 2 291638 291638 11
1031264 1031264 109278 109278 CAS Common Chemistry 3 7045 7045 1
1234157 1234157 109278 109278 Computational Toxicology and Exposure Data 4 7045 7045 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)
);