consensus_index

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

16 rows where inventory_id = 59992

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
168022 168022 59992 59992 62335 5 0.274645874267141
168023 168023 59992 59992 110552 1 0.0249678067515583
168024 168024 59992 59992 115474 3 0.217986574865193
168025 168025 59992 59992 119591 1 0.0228871561889284
168026 168026 59992 59992 136398 1 0.0392351248953059
168027 168027 59992 59992 144757 1 0.016155639662773
168028 168028 59992 59992 169496 1 0.0196175624476529
168029 168029 59992 59992 179868 2 0.079283434719977
168030 168030 59992 59992 186646 2 0.0560618543262567
168031 168031 59992 59992 199883 1 0.0549291748534282
168032 168032 59992 59992 205669 1 0.0686614685667853
168033 168033 59992 59992 240046 1 0.0183097249511427
168034 168034 59992 59992 240255 1 0.0305162082519046
168035 168035 59992 59992 258879 1 0.0274645874267141
168036 168036 59992 59992 260204 1 0.021126605712857
168037 168037 59992 59992 320910 1 0.0171653671416963 
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)
);