home / zeropm-v0-0-4

api_results

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

19 rows where query_id = 161911

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
97400 97400 161911 161911 PubChem (compound) 1 16848 16848 2
181190 181190 161911 161911 PubChem (compound) 1 22989 22989 1
181196 181196 161911 161911 PubChem (compound) 1 140424 140424 5
181199 181199 161911 161911 PubChem (compound) 1 22989 22989 3
181204 181204 161911 161911 PubChem (compound) 1 23531 23531 4
433366 433366 161911 161911 PubChem (substance) 2 16848 16848 3
546281 546281 161911 161911 PubChem (substance) 2 22989 22989 1
546287 546287 161911 161911 PubChem (substance) 2 140424 140424 6
546294 546294 161911 161911 PubChem (substance) 2 22989 22989 2
546298 546298 161911 161911 PubChem (substance) 2 23531 23531 5
548176 548176 161911 161911 PubChem (substance) 2 24705 24705 9
726678 726678 161911 161911 PubChem (substance) 2 189204 189204 4
788573 788573 161911 161911 PubChem (substance) 2 188171 188171 7
813066 813066 161911 161911 PubChem (substance) 2 259451 259451 11
813075 813075 161911 161911 PubChem (substance) 2 261980 261980 8
813082 813082 161911 161911 PubChem (substance) 2 309786 309786 10
813086 813086 161911 161911 PubChem (substance) 2 224826 224826 12
1071210 1071210 161911 161911 CAS Common Chemistry 3 22989 22989 1
1272582 1272582 161911 161911 Computational Toxicology and Exposure Data 4 22989 22989 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)
);
Powered by Datasette · Queries took 511.655ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website