home / zeropm-v0-0-4

api_results

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

34 rows where query_id = 9881

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
18733 18733 9881 9881 PubChem (compound) 1 50326 50326 8
18755 18755 9881 9881 PubChem (compound) 1 256950 256950 7
18758 18758 9881 9881 PubChem (compound) 1 216127 216127 1
18763 18763 9881 9881 PubChem (compound) 1 284268 284268 2
18764 18764 9881 9881 PubChem (compound) 1 140172 140172 3
18767 18767 9881 9881 PubChem (compound) 1 225333 225333 4
18769 18769 9881 9881 PubChem (compound) 1 173831 173831 5
18771 18771 9881 9881 PubChem (compound) 1 228468 228468 6
18773 18773 9881 9881 PubChem (compound) 1 234775 234775 9
18775 18775 9881 9881 PubChem (compound) 1 57871 57871 10
18777 18777 9881 9881 PubChem (compound) 1 56291 56291 11
18778 18778 9881 9881 PubChem (compound) 1 216127 216127 12
18779 18779 9881 9881 PubChem (compound) 1 264648 264648 13
18780 18780 9881 9881 PubChem (compound) 1 330618 330618 14
18781 18781 9881 9881 PubChem (compound) 1 334232 334232 15
322146 322146 9881 9881 PubChem (substance) 2 50326 50326 9
322171 322171 9881 9881 PubChem (substance) 2 256950 256950 6
322181 322181 9881 9881 PubChem (substance) 2 216127 216127 1
322189 322189 9881 9881 PubChem (substance) 2 284268 284268 2
322190 322190 9881 9881 PubChem (substance) 2 140172 140172 3
322196 322196 9881 9881 PubChem (substance) 2 225333 225333 4
322203 322203 9881 9881 PubChem (substance) 2 173831 173831 5
322212 322212 9881 9881 PubChem (substance) 2 228468 228468 7
322217 322217 9881 9881 PubChem (substance) 2 234775 234775 11
322220 322220 9881 9881 PubChem (substance) 2 57871 57871 14
322224 322224 9881 9881 PubChem (substance) 2 56291 56291 12
322225 322225 9881 9881 PubChem (substance) 2 216127 216127 13
322226 322226 9881 9881 PubChem (substance) 2 264648 264648 16
322228 322228 9881 9881 PubChem (substance) 2 330618 330618 17
322229 322229 9881 9881 PubChem (substance) 2 334232 334232 18
705320 705320 9881 9881 PubChem (substance) 2 264581 264581 8
705324 705324 9881 9881 PubChem (substance) 2 256622 256622 10
705325 705325 9881 9881 PubChem (substance) 2 320444 320444 15
952157 952157 9881 9881 CAS Common Chemistry 3 56291 56291 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 527.99ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website