consensus_index

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

10 rows where inventory_id = 214683

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
542573 542573 214683 214683 63173 1 0.0341100698685567
542574 542574 214683 214683 70938 3 0.120754004676242
542575 542575 214683 214683 110715 8 0.127122517143006
542576 542576 214683 214683 111206 1 0.0416900853949026
542577 542577 214683 214683 137669 2 0.118652063125331
542578 542578 214683 214683 184225 2 0.0709081702019732
542579 542579 214683 214683 187167 1 0.125070256184708
542580 542580 214683 214683 198726 1 0.187605384277062
542581 542581 214683 214683 313995 2 0.0501396479913452
542582 542582 214683 214683 332622 2 0.108314019113785 
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)
);