home / zeropm-v0-0-4

api_results

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

27 rows where query_id = 341693

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
120597 120597 341693 341693 PubChem (compound) 1 111382 111382 1
120600 120600 341693 341693 PubChem (compound) 1 229523 229523 2
120602 120602 341693 341693 PubChem (compound) 1 234962 234962 3
120604 120604 341693 341693 PubChem (compound) 1 230470 230470 4
120606 120606 341693 341693 PubChem (compound) 1 229669 229669 6
120608 120608 341693 341693 PubChem (compound) 1 230543 230543 5
431354 431354 341693 341693 PubChem (substance) 2 59611 59611 15
431360 431360 341693 341693 PubChem (substance) 2 188661 188661 9
465753 465753 341693 341693 PubChem (substance) 2 111382 111382 1
465756 465756 341693 341693 PubChem (substance) 2 229523 229523 2
465759 465759 341693 341693 PubChem (substance) 2 234962 234962 3
465763 465763 341693 341693 PubChem (substance) 2 230470 230470 4
465766 465766 341693 341693 PubChem (substance) 2 229669 229669 8
465769 465769 341693 341693 PubChem (substance) 2 230543 230543 5
579403 579403 341693 341693 PubChem (substance) 2 199360 199360 7
767589 767589 341693 341693 PubChem (substance) 2 60973 60973 17
767591 767591 341693 341693 PubChem (substance) 2 215554 215554 11
767594 767594 341693 341693 PubChem (substance) 2 229523 229523 13
767596 767596 341693 341693 PubChem (substance) 2 284929 284929 14
767599 767599 341693 341693 PubChem (substance) 2 229249 229249 16
767602 767602 341693 341693 PubChem (substance) 2 230094 230094 6
767605 767605 341693 341693 PubChem (substance) 2 298040 298040 18
767606 767606 341693 341693 PubChem (substance) 2 328730 328730 19
827599 827599 341693 341693 PubChem (substance) 2 198273 198273 12
913116 913116 341693 341693 PubChem (substance) 2 230554 230554 10
1025964 1025964 341693 341693 CAS Common Chemistry 3 60973 60973 1
1228539 1228539 341693 341693 Computational Toxicology and Exposure Data 4 111382 111382 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 418.984ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website