consensus_index

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

21 rows where inventory_id = 244696

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
686151 686151 244696 244696 13496 3 0.121138881442481
686152 686152 244696 244696 38590 1 0.0440247912123566
686153 686153 244696 244696 107003 1 0.0314462794373976
686154 686154 244696 244696 129186 8 0.220123956061783
686155 686155 244696 244696 136704 1 0.0440247912123566
686156 686156 244696 244696 136872 1 0.0183436630051486
686157 686157 244696 244696 145418 1 0.0550309890154458
686158 686158 244696 244696 170777 3 0.0666652955892572
686159 686159 244696 244696 189098 1 0.0220123956061783
686160 686160 244696 244696 192329 1 0.0275154945077229
686161 686161 244696 244696 199630 1 0.0733746520205943
686162 686162 244696 244696 199978 1 0.0200112687328894
686163 686163 244696 244696 219036 2 0.0635443126436779
686164 686164 244696 244696 228999 1 0.0314462794373976
686165 686165 244696 244696 232048 1 0.0366873260102972
686166 686166 244696 244696 240071 1 0.0183436630051486
686167 686167 244696 244696 255537 2 0.0215849297570822
686168 686168 244696 244696 275081 2 0.019610200623916
686169 686169 244696 244696 308328 1 0.0220123956061783
686170 686170 244696 244696 309439 1 0.0200112687328894
686171 686171 244696 244696 326278 1 0.0169326120047525 
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)
);