home / zeropm-v0-0-4

api_results

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

18 rows where query_id = 381426

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
273236 273236 381426 381426 PubChem (compound) 1 230116 230116 1
273237 273237 381426 381426 PubChem (compound) 1 230416 230416 2
273238 273238 381426 381426 PubChem (compound) 1 96423 96423 3
273239 273239 381426 381426 PubChem (compound) 1 334523 334523 4
477931 477931 381426 381426 PubChem (substance) 2 229499 229499 7
477941 477941 381426 381426 PubChem (substance) 2 137462 137462 11
663772 663772 381426 381426 PubChem (substance) 2 230116 230116 1
663774 663774 381426 381426 PubChem (substance) 2 230416 230416 3
663775 663775 381426 381426 PubChem (substance) 2 96423 96423 10
663776 663776 381426 381426 PubChem (substance) 2 334523 334523 12
776816 776816 381426 381426 PubChem (substance) 2 12218 12218 5
922927 922927 381426 381426 PubChem (substance) 2 265583 265583 2
922928 922928 381426 381426 PubChem (substance) 2 231240 231240 4
922929 922929 381426 381426 PubChem (substance) 2 290224 290224 6
922930 922930 381426 381426 PubChem (substance) 2 308208 308208 8
922931 922931 381426 381426 PubChem (substance) 2 326439 326439 9
922932 922932 381426 381426 PubChem (substance) 2 294816 294816 13
1332204 1332204 381426 381426 Computational Toxicology and Exposure Data 4 96423 96423 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 422.691ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website