consensus_index

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

14 rows where inventory_id = 78

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
485 485 78 78 2920 1 0.0400464764680311
486 486 78 78 22426 1 0.0266976509786874
487 487 78 78 28829 3 0.051766510869763
488 488 78 78 73277 1 0.0600697147020467
489 489 78 78 73278 12 0.240278858808187
490 490 78 78 106872 1 0.0300348573510233
491 491 78 78 136635 1 0.0400464764680311
492 492 78 78 149039 2 0.0524331456374344
493 493 78 78 169910 1 0.120139429404093
494 494 78 78 178067 1 0.120139429404093
495 495 78 78 188294 1 0.0800929529360622
496 496 78 78 195866 1 0.0600697147020467
497 497 78 78 203612 1 0.0480557717616373
498 498 78 78 226387 1 0.0218435326189261 
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)
);