api_results

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

10 rows where query_id = 119541

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
131692 131692 119541 119541 PubChem (compound) 1 43720 43720 1
139304 139304 119541 119541 PubChem (compound) 1 318697 318697 2
481077 481077 119541 119541 PubChem (substance) 2 43720 43720 1
487692 487692 119541 119541 PubChem (substance) 2 58109 58109 3
491221 491221 119541 119541 PubChem (substance) 2 318697 318697 6
778986 778986 119541 119541 PubChem (substance) 2 208881 208881 4
782739 782739 119541 119541 PubChem (substance) 2 232589 232589 2
784420 784420 119541 119541 PubChem (substance) 2 148614 148614 5
1039626 1039626 119541 119541 CAS Common Chemistry 3 83514 83514 1
1242616 1242616 119541 119541 Computational Toxicology and Exposure Data 4 83514 83514 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)
);