api_results

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

11 rows where query_id = 331365

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
261274 261274 331365 331365 PubChem (compound) 1 248927 248927 1
646435 646435 331365 331365 PubChem (substance) 2 248927 248927 1
908141 908141 331365 331365 PubChem (substance) 2 249072 249072 2
908145 908145 331365 331365 PubChem (substance) 2 288418 288418 3
908148 908148 331365 331365 PubChem (substance) 2 248927 248927 8
909458 909458 331365 331365 PubChem (substance) 2 248604 248604 4
909459 909459 331365 331365 PubChem (substance) 2 308555 308555 5
909460 909460 331365 331365 PubChem (substance) 2 326243 326243 6
909461 909461 331365 331365 PubChem (substance) 2 248604 248604 7
1114162 1114162 331365 331365 CAS Common Chemistry 3 10452 10452 1
1325939 1325939 331365 331365 Computational Toxicology and Exposure Data 4 100032 100032 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)
);