consensus_index

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

15 rows where inventory_id = 33002

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
92673 92673 33002 33002 50858 3 0.177965063505774
92674 92674 33002 33002 133510 10 0.157638070673685
92675 92675 33002 33002 238389 2 0.0196805223903874
92676 92676 33002 33002 238390 1 0.0202114988563138
92677 92677 33002 33002 266812 1 0.0359315535223357
92678 92678 33002 33002 274897 1 0.0323383981701021
92679 92679 33002 33002 314012 2 0.0864280045639996
92680 92680 33002 33002 314266 2 0.0834973850372199
92681 92681 33002 33002 315114 1 0.16169199085051
92682 92682 33002 33002 315569 1 0.0404229977126276
92683 92683 33002 33002 318079 1 0.0269486651417517
92684 92684 33002 33002 318108 1 0.0248756909000785
92685 92685 33002 33002 318123 1 0.0230988558357872
92686 92686 33002 33002 326533 2 0.0179935660689775
92687 92687 33002 33002 332371 1 0.0808459954252552 
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)
);