home / zeropm-v0-0-4

api_results

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

25 rows where query_id = 12169

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
23934 23934 12169 12169 PubChem (compound) 1 78321 78321 1
329994 329994 12169 12169 PubChem (substance) 2 78321 78321 1
346105 346105 12169 12169 PubChem (substance) 2 12441 12441 6
493749 493749 12169 12169 PubChem (substance) 2 3251 3251 16
695870 695870 12169 12169 PubChem (substance) 2 315679 315679 9
709497 709497 12169 12169 PubChem (substance) 2 136469 136469 2
709503 709503 12169 12169 PubChem (substance) 2 137705 137705 3
709506 709506 12169 12169 PubChem (substance) 2 238382 238382 7
709511 709511 12169 12169 PubChem (substance) 2 259776 259776 19
709515 709515 12169 12169 PubChem (substance) 2 239420 239420 4
709521 709521 12169 12169 PubChem (substance) 2 285905 285905 20
709531 709531 12169 12169 PubChem (substance) 2 136391 136391 5
709538 709538 12169 12169 PubChem (substance) 2 169425 169425 8
709548 709548 12169 12169 PubChem (substance) 2 315681 315681 10
709565 709565 12169 12169 PubChem (substance) 2 315682 315682 11
709582 709582 12169 12169 PubChem (substance) 2 137820 137820 12
709586 709586 12169 12169 PubChem (substance) 2 197768 197768 13
709588 709588 12169 12169 PubChem (substance) 2 197770 197770 14
709591 709591 12169 12169 PubChem (substance) 2 189264 189264 15
709593 709593 12169 12169 PubChem (substance) 2 286488 286488 17
709595 709595 12169 12169 PubChem (substance) 2 212760 212760 18
709597 709597 12169 12169 PubChem (substance) 2 333050 333050 21
955779 955779 12169 12169 CAS Common Chemistry 3 78321 78321 1
1155764 1155764 12169 12169 Computational Toxicology and Exposure Data 4 78321 78321 1
1155773 1155773 12169 12169 Computational Toxicology and Exposure Data 4 12441 12441 2
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 469.277ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website