consensus_index

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

12 rows where inventory_id = 43091

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
124174 124174 43091 43091 11051 6 0.254830806555943
124175 124175 43091 43091 168510 1 0.0715094772747784
124176 124176 43091 43091 181051 2 0.165144063816811
124177 124177 43091 43091 185080 4 0.0434857669096341
124178 124178 43091 43091 187220 3 0.0941971112153621
124179 124179 43091 43091 203237 2 0.143018954549557
124180 124180 43091 43091 216034 2 0.0341880692309451
124181 124181 43091 43091 237785 2 0.0452265644952701
124182 124182 43091 43091 243336 2 0.0522231383717323
124183 124183 43091 43091 281376 1 0.0317819898999015
124184 124184 43091 43091 323194 2 0.0287478915242286
124185 124185 43091 43091 334465 2 0.0261115691858661 
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)
);