consensus_index

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

18 rows where inventory_id = 242766

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
679117 679117 242766 242766 7487 12 0.26474641035451
679118 679118 242766 242766 35450 1 0.0240678554867737
679119 679119 242766 242766 64739 1 0.0220622008628759
679120 679120 242766 242766 137419 2 0.108082269433673
679121 679121 242766 242766 145099 1 0.0661866025886276
679122 679122 242766 242766 186908 2 0.0540411347168366
679123 679123 242766 242766 188008 2 0.0529492820709021
679124 679124 242766 242766 201385 3 0.0833898938224384
679125 679125 242766 242766 202284 1 0.0330933012943138
679126 679126 242766 242766 202439 1 0.0264746410354511
679127 679127 242766 242766 202873 1 0.0441244017257517
679128 679128 242766 242766 204261 1 0.0378209157649301
679129 679129 242766 242766 204393 1 0.0294162678171678
679130 679130 242766 242766 209431 1 0.0378209157649301
679131 679131 242766 242766 215278 1 0.018910457882465
679132 679132 242766 242766 232736 1 0.0176497606903007
679133 679133 242766 242766 247145 1 0.0294162678171678
679134 679134 242766 242766 259436 2 0.0423933539165918 
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)
);