api_results

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

10 rows where inchi_id = 9897

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
262510 262510 331089 331089 PubChem (compound) 1 9897 9897 1
262511 262511 331090 331090 PubChem (compound) 1 9897 9897 1
262512 262512 331091 331091 PubChem (compound) 1 9897 9897 1
648336 648336 331091 331091 PubChem (substance) 2 9897 9897 1
648337 648337 331090 331090 PubChem (substance) 2 9897 9897 1
648338 648338 331089 331089 PubChem (substance) 2 9897 9897 1
1114604 1114604 331089 331089 CAS Common Chemistry 3 9897 9897 1
1114605 1114605 331091 331091 CAS Common Chemistry 3 9897 9897 1
1325910 1325910 331089 331089 Computational Toxicology and Exposure Data 4 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)
);