consensus_index

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

12 rows where inchi_id = 1887

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
171901 171901 61351 61351 1887 1 0.467520617081764
429628 429628 154762 154762 1887 7 0.620689655172414
784349 784349 274181 274181 1887 5 0.394736842105263
784355 784355 274182 274182 1887 4 0.393559928443649
784361 784361 274183 274183 1887 8 0.398593200468933
784367 784367 274184 274184 1887 6 0.347579263358706
854647 854647 295615 295615 1887 1 0.17024830951992
854660 854660 295618 295618 1887 1 0.273823689317773
854671 854671 295620 295620 1887 1 0.280577064748943
925411 925411 328935 328935 1887 2 0.630993034743972
926139 926139 329312 329312 1887 4 0.833333333333333
935979 935979 334158 334158 1887 2 0.630993034743972 
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)
);