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 = 189032

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
96060 96060 189032 189032 PubChem (compound) 1 59611 59611 1
120598 120598 189032 189032 PubChem (compound) 1 111382 111382 2
206732 206732 189032 189032 PubChem (compound) 1 199360 199360 3
431350 431350 189032 189032 PubChem (substance) 2 59611 59611 1
431357 431357 189032 189032 PubChem (substance) 2 188661 188661 2
431363 431363 189032 189032 PubChem (substance) 2 136778 136778 4
431365 431365 189032 189032 PubChem (substance) 2 170101 170101 3
431366 431366 189032 189032 PubChem (substance) 2 187244 187244 5
431369 431369 189032 189032 PubChem (substance) 2 210544 210544 18
465752 465752 189032 189032 PubChem (substance) 2 111382 111382 6
465761 465761 189032 189032 PubChem (substance) 2 234962 234962 17
465767 465767 189032 189032 PubChem (substance) 2 230543 230543 9
579402 579402 189032 189032 PubChem (substance) 2 199360 199360 7
747268 747268 189032 189032 PubChem (substance) 2 247272 247272 19
827592 827592 189032 189032 PubChem (substance) 2 195133 195133 8
827593 827593 189032 189032 PubChem (substance) 2 187246 187246 10
827594 827594 189032 189032 PubChem (substance) 2 189812 189812 11
827595 827595 189032 189032 PubChem (substance) 2 195981 195981 12
827596 827596 189032 189032 PubChem (substance) 2 195343 195343 13
827597 827597 189032 189032 PubChem (substance) 2 199963 199963 14
827598 827598 189032 189032 PubChem (substance) 2 198440 198440 15
827600 827600 189032 189032 PubChem (substance) 2 198273 198273 16
827601 827601 189032 189032 PubChem (substance) 2 190441 190441 20
1009317 1009317 189032 189032 CAS Common Chemistry 3 59611 59611 1
1211355 1211355 189032 189032 Computational Toxicology and Exposure Data 4 59611 59611 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 747.453ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website