home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 153687

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
172948 172948 153687 153687 PubChem (compound) 1 195348 195348 1
172950 172950 153687 153687 PubChem (compound) 1 216870 216870 2
172951 172951 153687 153687 PubChem (compound) 1 195348 195348 3
172952 172952 153687 153687 PubChem (compound) 1 256367 256367 4
172953 172953 153687 153687 PubChem (compound) 1 230609 230609 5
535725 535725 153687 153687 PubChem (substance) 2 195348 195348 1
535727 535727 153687 153687 PubChem (substance) 2 216870 216870 4
535730 535730 153687 153687 PubChem (substance) 2 195348 195348 5
535732 535732 153687 153687 PubChem (substance) 2 256367 256367 6
535734 535734 153687 153687 PubChem (substance) 2 230609 230609 7
801234 801234 153687 153687 PubChem (substance) 2 111287 111287 3
807758 807758 153687 153687 PubChem (substance) 2 189193 189193 2
807760 807760 153687 153687 PubChem (substance) 2 12576 12576 8
807761 807761 153687 153687 PubChem (substance) 2 270787 270787 9
807762 807762 153687 153687 PubChem (substance) 2 297631 297631 10
807763 807763 153687 153687 PubChem (substance) 2 298014 298014 11
807764 807764 153687 153687 PubChem (substance) 2 297631 297631 12
807765 807765 153687 153687 PubChem (substance) 2 333592 333592 13
1065203 1065203 153687 153687 CAS Common Chemistry 3 12576 12576 1
1267031 1267031 153687 153687 Computational Toxicology and Exposure Data 4 111287 111287 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 417.2ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website