home / zeropm-v0-0-4

api_results

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

17 rows where query_id = 24761

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
54791 54791 24761 24761 PubChem (compound) 1 109937 109937 1
54797 54797 24761 24761 PubChem (compound) 1 109937 109937 2
54799 54799 24761 24761 PubChem (compound) 1 52592 52592 3
373150 373150 24761 24761 PubChem (substance) 2 109937 109937 1
373154 373154 24761 24761 PubChem (substance) 2 109937 109937 2
373158 373158 24761 24761 PubChem (substance) 2 52592 52592 5
652334 652334 24761 24761 PubChem (substance) 2 107012 107012 6
724189 724189 24761 24761 PubChem (substance) 2 248600 248600 3
724193 724193 24761 24761 PubChem (substance) 2 249078 249078 4
724196 724196 24761 24761 PubChem (substance) 2 185435 185435 7
724197 724197 24761 24761 PubChem (substance) 2 263695 263695 8
724198 724198 24761 24761 PubChem (substance) 2 296561 296561 9
724200 724200 24761 24761 PubChem (substance) 2 308303 308303 10
724201 724201 24761 24761 PubChem (substance) 2 309519 309519 11
724203 724203 24761 24761 PubChem (substance) 2 266751 266751 12
978237 978237 24761 24761 CAS Common Chemistry 3 52592 52592 1
1181131 1181131 24761 24761 Computational Toxicology and Exposure Data 4 109937 109937 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 487.862ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website