consensus_index

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

9 rows where inventory_id = 8172

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
28201 28201 8172 8172 15734 4 0.165463026002087
28202 28202 8172 8172 45100 2 0.234000055443443
28203 28203 8172 8172 123808 4 0.0955301226032347
28204 28204 8172 8172 167404 1 0.117000027721721
28205 28205 8172 8172 197472 2 0.0477650613016174
28206 28206 8172 8172 203551 2 0.0468000110886886
28207 28207 8172 8172 203931 3 0.128775193218593
28208 28208 8172 8172 208713 1 0.0585000138608607
28209 28209 8172 8172 208714 2 0.0955301226032347 
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)
);