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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
33952 33952 78577 78577 PubChem (compound) 1 230121 230121 1
111158 111158 78577 78577 PubChem (compound) 1 245401 245401 2
111159 111159 78577 78577 PubChem (compound) 1 273136 273136 3
111160 111160 78577 78577 PubChem (compound) 1 285495 285495 4
111161 111161 78577 78577 PubChem (compound) 1 258966 258966 5
111162 111162 78577 78577 PubChem (compound) 1 320477 320477 6
111163 111163 78577 78577 PubChem (compound) 1 333595 333595 7
344141 344141 78577 78577 PubChem (substance) 2 230121 230121 1
452602 452602 78577 78577 PubChem (substance) 2 245401 245401 2
452611 452611 78577 78577 PubChem (substance) 2 273136 273136 3
452613 452613 78577 78577 PubChem (substance) 2 285495 285495 4
452616 452616 78577 78577 PubChem (substance) 2 258966 258966 6
452617 452617 78577 78577 PubChem (substance) 2 320477 320477 12
452618 452618 78577 78577 PubChem (substance) 2 333595 333595 13
652766 652766 78577 78577 PubChem (substance) 2 326785 326785 7
759737 759737 78577 78577 PubChem (substance) 2 158027 158027 5
759738 759738 78577 78577 PubChem (substance) 2 288110 288110 8
759739 759739 78577 78577 PubChem (substance) 2 197766 197766 9
759741 759741 78577 78577 PubChem (substance) 2 245811 245811 10
759743 759743 78577 78577 PubChem (substance) 2 296586 296586 11
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 1741.983ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website