consensus_index

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

8 rows where inventory_id = 12000

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
39686 39686 12000 12000 43574 2 0.143620021408654
39687 39687 12000 12000 128140 5 0.351795769298799
39688 39688 12000 12000 211349 1 0.175897884649399
39689 39689 12000 12000 215356 1 0.0439744711623499
39690 39690 12000 12000 228888 1 0.0703591538597598
39691 39691 12000 12000 239197 2 0.101554691052217
39692 39692 12000 12000 276564 1 0.050256538471257
39693 39693 12000 12000 289553 1 0.0390884188109777 
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)
);