home / zeropm-v0-0-4

api_results

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

23 rows where query_id = 111861

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
102229 102229 111861 111861 PubChem (compound) 1 38590 38590 1
401547 401547 111861 111861 PubChem (substance) 2 37415 37415 7
440333 440333 111861 111861 PubChem (substance) 2 149562 149562 4
440409 440409 111861 111861 PubChem (substance) 2 38590 38590 1
516663 516663 111861 111861 PubChem (substance) 2 50698 50698 9
658052 658052 111861 111861 PubChem (substance) 2 136872 136872 2
752315 752315 111861 111861 PubChem (substance) 2 195631 195631 3
752318 752318 111861 111861 PubChem (substance) 2 189083 189083 5
752320 752320 111861 111861 PubChem (substance) 2 210824 210824 15
752322 752322 111861 111861 PubChem (substance) 2 289280 289280 12
752325 752325 111861 111861 PubChem (substance) 2 234170 234170 8
752326 752326 111861 111861 PubChem (substance) 2 258895 258895 10
752329 752329 111861 111861 PubChem (substance) 2 223248 223248 11
752331 752331 111861 111861 PubChem (substance) 2 203783 203783 13
752335 752335 111861 111861 PubChem (substance) 2 308429 308429 14
752348 752348 111861 111861 PubChem (substance) 2 323953 323953 17
752352 752352 111861 111861 PubChem (substance) 2 334575 334575 20
778317 778317 111861 111861 PubChem (substance) 2 148732 148732 6
778318 778318 111861 111861 PubChem (substance) 2 234136 234136 16
778319 778319 111861 111861 PubChem (substance) 2 258750 258750 18
778320 778320 111861 111861 PubChem (substance) 2 178062 178062 19
1013431 1013431 111861 111861 CAS Common Chemistry 3 38590 38590 1
1215571 1215571 111861 111861 Computational Toxicology and Exposure Data 4 38590 38590 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 517.644ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website