consensus_index

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

11 rows where inventory_id = 42023

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
120781 120781 42023 42023 31915 1 0.0613470815975913
120782 120782 42023 42023 44265 8 0.306735407987957
120783 120783 42023 42023 137026 1 0.0340817119986618
120784 120784 42023 42023 137531 1 0.153367703993978
120785 120785 42023 42023 169517 1 0.0438193439982795
120786 120786 42023 42023 191999 1 0.0766838519969891
120787 120787 42023 42023 197718 2 0.0685881223367203
120788 120788 42023 42023 208868 1 0.102245135995986
120789 120789 42023 42023 240640 2 0.0722982290061021
120790 120790 42023 42023 266983 1 0.0383419259984946
120791 120791 42023 42023 279901 1 0.0278850370898142 
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)
);