consensus_index

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

15 rows where inventory_id = 281203

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
807589 807589 281203 281203 47902 2 0.178820500536776
807590 807590 281203 281203 91910 2 0.103242064121531
807591 807591 281203 281203 136302 2 0.0730031636440311
807592 807592 281203 281203 138100 2 0.252890377089454
807593 807593 281203 281203 167483 1 0.0505780754178908
807594 807594 281203 281203 191920 1 0.0316112971361817
807595 807595 281203 281203 198142 1 0.0252890377089454
807596 807596 281203 281203 198143 1 0.0229900342808594
807597 807597 281203 281203 206967 1 0.0210741980907878
807598 807598 281203 281203 206968 1 0.019453105929958
807599 807599 281203 281203 207043 1 0.0180635983635324
807600 807600 281203 281203 218160 2 0.0516210320607656
807601 807601 281203 281203 231795 2 0.0292012654576124
807602 807602 281203 281203 253221 1 0.0361271967270648
807603 807603 281203 281203 298020 2 0.0344140213738437 
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)
);