consensus_index

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

18 rows where inventory_id = 57195

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
158882 158882 57195 57195 3609 6 0.0481307707827628
158883 158883 57195 57195 30166 30 0.084825330989384
158884 158884 57195 57195 40954 1 0.12976115048135
158885 158885 57195 57195 47694 1 0.0432537168271167
158886 158886 57195 57195 114565 2 0.0917549894399307
158887 158887 57195 57195 120062 3 0.12976115048135
158888 158888 57195 57195 172470 1 0.0432537168271167
158889 158889 57195 57195 199698 1 0.064880575240675
158890 158890 57195 57195 217547 1 0.02595223009627
158891 158891 57195 57195 229299 1 0.0324402876203375
158892 158892 57195 57195 230718 4 0.0509720810267805
158893 158893 57195 57195 231149 1 0.02595223009627
158894 158894 57195 57195 259380 1 0.0324402876203375
158895 158895 57195 57195 263376 17 0.107635564002925
158896 158896 57195 57195 263823 3 0.0296290862847266
158897 158897 57195 57195 292279 1 0.0216268584135583
158898 158898 57195 57195 317915 1 0.0216268584135583
158899 158899 57195 57195 320696 1 0.0144179056090389 
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)
);