consensus_index

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

23 rows where inventory_id = 218309

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
553052 553052 218309 218309 31939 1 0.187772873576267
553053 553053 218309 218309 51218 1 0.0187772873576267
553054 553054 218309 218309 52206 10 0.175198285962327
553055 553055 218309 218309 75159 2 0.0542053595528838
553056 553056 218309 218309 83488 1 0.0234716091970334
553057 553057 218309 218309 107005 1 0.0208636526195853
553058 553058 218309 218309 136474 3 0.0445258717858856
553059 553059 218309 218309 137028 3 0.0266446592822735
553060 553060 218309 218309 168930 3 0.0325486097278303
553061 553061 218309 218309 169002 1 0.0312954789293779
553062 553062 218309 218309 169031 3 0.0745177142615146
553063 553063 218309 218309 169090 3 0.0183017071030736
553064 553064 218309 218309 177695 4 0.10088754197858
553065 553065 218309 218309 188233 1 0.0170702612342061
553066 553066 218309 218309 192471 1 0.0234716091970334
553067 553067 218309 218309 206321 1 0.0170702612342061
553068 553068 218309 218309 207704 1 0.0208636526195853
553069 553069 218309 218309 214832 1 0.0134123481125905
553070 553070 218309 218309 214833 1 0.0187772873576267
553071 553071 218309 218309 234534 1 0.0110454631515451
553072 553072 218309 218309 238191 3 0.022973930608337
553073 553073 218309 218309 250674 1 0.0156477394646889
553074 553074 218309 218309 271865 1 0.026824696225181 
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)
);