consensus_index

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

11 rows where inventory_id = 535000

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1746749 1746749 535000 535000 13287 1 0.165439217244597
1746750 1746750 535000 535000 101374 1 0.165439217244597
1746751 1746751 535000 535000 117513 3 0.165439217244597
1746752 1746752 535000 535000 218843 1 0.0275732028740996
1746753 1746753 535000 535000 231936 1 0.165439217244597
1746754 1746754 535000 535000 241340 3 0.0767900823404162
1746755 1746755 535000 535000 243037 1 0.0827196086222987
1746756 1746756 535000 535000 251422 1 0.0551464057481991
1746757 1746757 535000 535000 260024 1 0.0413598043111493
1746758 1746758 535000 535000 276524 1 0.0206799021555747
1746759 1746759 535000 535000 321465 1 0.0236341738920853 
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)
);