consensus_index

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

9 rows where inventory_id = 106856

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
317021 317021 106856 106856 14000 6 0.311513305689748
317022 317022 106856 106856 185153 5 0.0752935054564441
317023 317023 106856 106856 235238 4 0.247248274576998
317024 317024 106856 106856 240151 3 0.0811493299838584
317025 317025 106856 106856 274612 2 0.046725531901468
317026 317026 106856 106856 274641 3 0.0753323647816472
317027 317027 106856 106856 276563 2 0.053953996842682
317028 317028 106856 106856 294933 2 0.0388513181311265
317029 317029 106856 106856 332550 2 0.0582769771966897 
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)
);