consensus_index

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

8 rows where inventory_id = 4917

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
16742 16742 4917 4917 13861 2 0.125669373824518
16743 16743 4917 4917 49214 3 0.172761412659621
16744 16744 4917 4917 63227 1 0.0544164351048578
16745 16745 4917 4917 72371 10 0.332055706565732
16746 16746 4917 4917 146797 1 0.072555246806477
16747 16747 4917 4917 147191 1 0.0621902115484089
16748 16748 4917 4917 179537 1 0.072555246806477
16749 16749 4917 4917 208175 1 0.0870662961677725 
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)
);