consensus_index

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

18 rows where inventory_id = 153020

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
421697 421697 153020 153020 3862 1 0.0211139578603032
421698 421698 153020 153020 45327 7 0.232253536463335
421699 421699 153020 153020 96433 1 0.116126768231668
421700 421700 153020 153020 136425 2 0.0670458208986746
421701 421701 153020 153020 136458 2 0.0734450169853107
421702 421702 153020 153020 137590 2 0.0670458208986746
421703 421703 153020 153020 137716 1 0.0232253536463335
421704 421704 153020 153020 168990 1 0.0387089227438892
421705 421705 153020 153020 169217 1 0.0258059484959261
421706 421706 153020 153020 197774 1 0.0178656566510258
421707 421707 153020 153020 200609 1 0.0290316920579169
421708 421708 153020 153020 203086 1 0.0387089227438892
421709 421709 153020 153020 203565 3 0.10780254214153
421710 421710 153020 153020 219058 1 0.0165895383188097
421711 421711 153020 153020 222743 1 0.0331790766376193
421712 421712 153020 153020 231788 1 0.0290316920579169
421713 421713 153020 153020 240687 2 0.0223486069662249
421714 421714 153020 153020 248042 1 0.0331790766376193 
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)
);