consensus_index

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

13 rows where inventory_id = 59995

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
168043 168043 59995 59995 4332 1 0.0524158111362886
168044 168044 59995 59995 11313 6 0.176504276195507
168045 168045 59995 59995 30243 5 0.157247433408866
168046 168046 59995 59995 145297 1 0.0262079055681443
168047 168047 59995 59995 157648 1 0.0449278381168188
168048 168048 59995 59995 167578 4 0.157247433408866
168049 168049 59995 59995 180080 1 0.0628989733635463
168050 168050 59995 59995 199953 4 0.104831622272577
168051 168051 59995 59995 208604 4 0.0600963707372547
168052 168052 59995 59995 231266 2 0.0453934240039932
168053 168053 59995 59995 231508 1 0.0285904424379756
168054 168054 59995 59995 290524 2 0.0375893262309362
168055 168055 59995 59995 292147 2 0.037063575495863 
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)
);