home / zeropm-v0-0-4

api_results

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

22 rows where query_id = 160256

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
179521 179521 160256 160256 PubChem (compound) 1 142604 142604 1
179522 179522 160256 160256 PubChem (compound) 1 190141 190141 2
472297 472297 160256 160256 PubChem (substance) 2 58690 58690 12
543586 543586 160256 160256 PubChem (substance) 2 20208 20208 7
544182 544182 160256 160256 PubChem (substance) 2 142604 142604 1
544184 544184 160256 160256 PubChem (substance) 2 190141 190141 2
667930 667930 160256 160256 PubChem (substance) 2 216743 216743 8
772343 772343 160256 160256 PubChem (substance) 2 169402 169402 15
772569 772569 160256 160256 PubChem (substance) 2 136494 136494 6
772576 772576 160256 160256 PubChem (substance) 2 197857 197857 4
812092 812092 160256 160256 PubChem (substance) 2 238462 238462 3
812093 812093 160256 160256 PubChem (substance) 2 20768 20768 5
812094 812094 160256 160256 PubChem (substance) 2 199982 199982 9
812097 812097 160256 160256 PubChem (substance) 2 289480 289480 10
812098 812098 160256 160256 PubChem (substance) 2 267464 267464 11
812099 812099 160256 160256 PubChem (substance) 2 245412 245412 13
812101 812101 160256 160256 PubChem (substance) 2 233489 233489 14
812102 812102 160256 160256 PubChem (substance) 2 294496 294496 16
812103 812103 160256 160256 PubChem (substance) 2 275213 275213 17
812104 812104 160256 160256 PubChem (substance) 2 142313 142313 18
812105 812105 160256 160256 PubChem (substance) 2 333583 333583 19
1069997 1069997 160256 160256 CAS Common Chemistry 3 20768 20768 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 446.759ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website