home / zeropm-v0-0-4

consensus_index

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

29 rows where inchi_id = 28085

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
37004 37004 11085 11085 28085 1 0.0416510796718302
67310 67310 22303 22303 28085 1 0.3125
89020 89020 31806 31806 28085 1 0.0416510796718302
184231 184231 65789 65789 28085 1 0.0425179542596405
245618 245618 83576 83576 28085 1 0.167023554603854
267540 267540 90681 90681 28085 1 0.0425179542596405
267571 267571 90689 90689 28085 6 0.514285714285714
381606 381606 130590 130590 28085 1 0.307692307692308
441094 441094 158128 158128 28085 2 0.200956937799043
449565 449565 161225 161225 28085 1 0.0425179542596405
449587 449587 161230 161230 28085 6 0.514285714285714
568185 568185 222933 222933 28085 12 0.417391304347826
568207 568207 222940 222940 28085 1 0.0425179542596405
667728 667728 239286 239286 28085 1 0.0416510796718302
667741 667741 239288 239288 28085 8 0.519685039370079
784454 784454 274206 274206 28085 1 0.0425179542596405
784463 784463 274207 274207 28085 1 0.027518593656057
784530 784530 274221 274221 28085 8 0.519685039370079
895156 895156 314255 314255 28085 1 0.226415094339623
908888 908888 320939 320939 28085 4 0.506024096385542
1045838 1045838 370194 370194 28085 1 0.0416510796718302
1266754 1266754 417043 417043 28085 1 0.0416510796718302
1488584 1488584 460631 460631 28085 1 0.0416510796718302
1597356 1597356 482390 482390 28085 1 0.0416510796718302
1639710 1639710 496018 496018 28085 1 0.0416510796718302
1639736 1639736 496024 496024 28085 8 0.519685039370079
1696627 1696627 517185 517185 28085 1 0.307692307692308
1733268 1733268 530890 530890 28085 1 0.0406393423824554
1733292 1733292 530894 530894 28085 8 0.519685039370079
CREATE TABLE [consensus_index] (
        [inventory_id] integer,
        [inchi_id] text,
        [consensus_score] text,
        [consensus_count] integer,
        FOREIGN KEY (inventory_id) REFERENCES inventories(inventory_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);
Powered by Datasette · Queries took 1216.04ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website