consensus_index

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

10 rows where inventory_id = 37957

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
108216 108216 37957 37957 8748 4 0.298719216233585
108217 108217 37957 37957 59839 1 0.0298719216233585
108218 108218 37957 37957 67519 4 0.1908645833183
108219 108219 37957 37957 101554 2 0.0667956473683754
108220 108220 37957 37957 136302 2 0.0862328099522871
108221 108221 37957 37957 167483 1 0.0497865360389308
108222 108222 37957 37957 168939 4 0.134961641152715
108223 108223 37957 37957 208534 2 0.044530431578917
108224 108224 37957 37957 231215 2 0.0431164049761436
108225 108225 37957 37957 294505 1 0.042674173747655 
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)
);