consensus_index

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

9 rows where inventory_id = 3282

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
10749 10749 3282 3282 7712 1 0.251930960355786
10750 10750 3282 3282 78141 3 0.110040982714535
10751 10751 3282 3282 120350 5 0.251930960355786
10752 10752 3282 3282 125837 2 0.0398337823918933
10753 10753 3282 3282 141548 2 0.0563334752992342
10754 10754 3282 3282 153773 1 0.0359901371936837
10755 10755 3282 3282 200499 2 0.0727262038893069
10756 10756 3282 3282 251128 1 0.125965480177893
10757 10757 3282 3282 290993 1 0.041988493392631 
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)
);