consensus_index

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

10 rows where inventory_id = 37937

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
108045 108045 37937 37937 30788 3 0.102480014727835
108046 108046 37937 37937 97386 1 0.0422290734875193
108047 108047 37937 37937 109130 3 0.295603514412635
108048 108048 37937 37937 126800 1 0.0985345048042117
108049 108049 37937 37937 145660 1 0.147801757206318
108050 108050 37937 37937 240054 2 0.0853333843097671
108051 108051 37937 37937 270968 2 0.0418046499167499
108052 108052 37937 37937 276590 2 0.0934780389894337
108053 108053 37937 37937 297114 1 0.0369504393015794
108054 108054 37937 37937 307858 2 0.0402265431380227 
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)
);