consensus_index

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

18 rows where inventory_id = 38147

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
108802 108802 38147 38147 3862 1 0.0211139578603032
108803 108803 38147 38147 45327 7 0.232253536463335
108804 108804 38147 38147 96433 1 0.116126768231668
108805 108805 38147 38147 136425 2 0.0670458208986746
108806 108806 38147 38147 136458 2 0.0734450169853107
108807 108807 38147 38147 137590 2 0.0670458208986746
108808 108808 38147 38147 137716 1 0.0232253536463335
108809 108809 38147 38147 168990 1 0.0387089227438892
108810 108810 38147 38147 169217 1 0.0258059484959261
108811 108811 38147 38147 197774 1 0.0178656566510258
108812 108812 38147 38147 200609 1 0.0290316920579169
108813 108813 38147 38147 203086 1 0.0387089227438892
108814 108814 38147 38147 203565 3 0.10780254214153
108815 108815 38147 38147 219058 1 0.0165895383188097
108816 108816 38147 38147 222743 1 0.0331790766376193
108817 108817 38147 38147 231788 1 0.0290316920579169
108818 108818 38147 38147 240687 2 0.0223486069662249
108819 108819 38147 38147 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)
);