api_results

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

12 rows where query_id = 331091

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
262512 262512 331091 331091 PubChem (compound) 1 9897 9897 1
325952 325952 331091 331091 PubChem (substance) 2 45290 45290 5
648336 648336 331091 331091 PubChem (substance) 2 9897 9897 1
648339 648339 331091 331091 PubChem (substance) 2 137094 137094 4
648342 648342 331091 331091 PubChem (substance) 2 227376 227376 8
648345 648345 331091 331091 PubChem (substance) 2 189201 189201 2
648347 648347 331091 331091 PubChem (substance) 2 234159 234159 9
909402 909402 331091 331091 PubChem (substance) 2 201688 201688 6
909404 909404 331091 331091 PubChem (substance) 2 227361 227361 3
909407 909407 331091 331091 PubChem (substance) 2 287886 287886 7
1114605 1114605 331091 331091 CAS Common Chemistry 3 9897 9897 1
1325911 1325911 331091 331091 Computational Toxicology and Exposure Data 4 9897 9897 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)
);