home / zeropm-v0-0-4

consensus_index

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

10 rows where inventory_id = 100106

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
295783 295783 100106 100106 37425 1 0.062260654725139
295784 295784 100106 100106 73584 8 0.311303273625695
295785 295785 100106 100106 127582 3 0.155651636812847
295786 295786 100106 100106 189204 1 0.0518838789376158
295787 295787 100106 100106 191041 1 0.103767757875232
295788 295788 100106 100106 191045 1 0.0778258184064237
295789 295789 100106 100106 201038 1 0.0345892526250772
295790 295790 100106 100106 215575 1 0.0444718962322421
295791 295791 100106 100106 215576 1 0.0389129092032119
295792 295792 100106 100106 281910 1 0.103767757875232
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 1540.083ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website