consensus_index

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

14 rows where inventory_id = 159563

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
445233 445233 159563 159563 10573 1 0.0805932486797592
445234 445234 159563 159563 102086 1 0.0805932486797592
445235 445235 159563 159563 119793 1 0.0345399637198968
445236 445236 159563 159563 150125 3 0.191900711603677
445237 445237 159563 159563 150528 1 0.0604449365098194
445238 445238 159563 159563 170726 1 0.0241779746039278
445239 445239 159563 159563 184046 1 0.0201483121699398
445240 445240 159563 159563 192351 2 0.0360423965150974
445241 445241 159563 159563 201303 1 0.0402966243398796
445242 445242 159563 159563 207120 2 0.0646183551957279
445243 445243 159563 159563 216017 1 0.241779746039278
445244 445244 159563 159563 229735 1 0.0185984420030214
445245 445245 159563 159563 231927 1 0.0302224682549097
445246 445246 159563 159563 261621 1 0.0219799769126616 
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)
);