consensus_index

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

8 rows where inventory_id = 42759

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
123044 123044 42759 42759 3781 1 0.103293788330029
123045 123045 42759 42759 73628 8 0.309881364990089
123046 123046 42759 42759 138959 2 0.0676216576915866
123047 123047 42759 42759 150131 1 0.0774703412475221
123048 123048 42759 42759 169645 1 0.154940682495044
123049 123049 42759 42759 182603 1 0.0619762729980177
123050 123050 42759 42759 183585 1 0.0516468941650147
123051 123051 42759 42759 281707 1 0.154940682495044 
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)
);