api_results

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

16 rows where query_id = 58160

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
97853 97853 58160 58160 PubChem (compound) 1 132836 132836 1
97857 97857 58160 58160 PubChem (compound) 1 132836 132836 2
97858 97858 58160 58160 PubChem (compound) 1 219177 219177 3
97859 97859 58160 58160 PubChem (compound) 1 132836 132836 4
434012 434012 58160 58160 PubChem (substance) 2 132836 132836 1
434018 434018 58160 58160 PubChem (substance) 2 132836 132836 5
434021 434021 58160 58160 PubChem (substance) 2 219177 219177 6
434022 434022 58160 58160 PubChem (substance) 2 132836 132836 7
748540 748540 58160 58160 PubChem (substance) 2 235087 235087 2
748541 748541 58160 58160 PubChem (substance) 2 216076 216076 3
748542 748542 58160 58160 PubChem (substance) 2 256282 256282 4
748543 748543 58160 58160 PubChem (substance) 2 286102 286102 8
748544 748544 58160 58160 PubChem (substance) 2 276601 276601 9
748545 748545 58160 58160 PubChem (substance) 2 69420 69420 10
1010499 1010499 58160 58160 CAS Common Chemistry 3 69420 69420 1
1212604 1212604 58160 58160 Computational Toxicology and Exposure Data 4 132836 132836 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)
);