consensus_index

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

15 rows where inventory_id = 275185

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
788015 788015 275185 275185 27753 1 0.0322907729362791
788016 788016 275185 275185 30147 2 0.0645815458725581
788017 788017 275185 275185 107374 4 0.119111907905182
788018 788018 275185 275185 123636 3 0.193744637617674
788019 788019 275185 275185 124583 1 0.0645815458725581
788020 788020 275185 275185 129530 1 0.0968723188088372
788021 788021 275185 275185 135641 1 0.0276778053739535
788022 788022 275185 275185 190143 1 0.0484361594044186
788023 788023 275185 275185 198939 1 0.0645815458725581
788024 788024 275185 275185 199486 1 0.0242180797022093
788025 788025 275185 275185 205745 1 0.0322907729362791
788026 788026 275185 275185 221537 1 0.0387489275235349
788027 788027 275185 275185 264261 1 0.0484361594044186
788028 788028 275185 275185 314648 1 0.0387489275235349
788029 788029 275185 275185 332367 1 0.0968723188088372 
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)
);