consensus_index

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

9 rows where inventory_id = 153083

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
422135 422135 153083 153083 50392 3 0.241967776416215
422136 422136 153083 153083 67270 3 0.0778724398488281
422137 422137 153083 153083 129205 8 0.210996109911272
422138 422138 153083 153083 217847 2 0.174488960782263
422139 422139 153083 153083 228787 2 0.063714359904053
422140 422140 153083 153083 230115 1 0.0498539887949322
422141 422141 153083 153083 245410 1 0.0387753246182806
422142 422142 153083 153083 259773 2 0.0872444803911313
422143 422143 153083 153083 264784 2 0.0411274424704438 
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)
);