consensus_index

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

18 rows where inventory_id = 111002

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
329300 329300 111002 111002 22610 8 0.277822594047081
329301 329301 111002 111002 137567 4 0.0529830692831949
329302 329302 111002 111002 169299 4 0.0433950548461231
329303 329303 111002 111002 186926 4 0.0630078429662575
329304 329304 111002 111002 188169 1 0.0308691771163424
329305 329305 111002 111002 188210 4 0.0656870967778807
329306 329306 111002 111002 189019 1 0.0308691771163424
329307 329307 111002 111002 194714 4 0.0371256057581772
329308 329308 111002 111002 198570 1 0.0347278242558852
329309 329309 111002 111002 208736 4 0.0371731114289314
329310 329310 111002 111002 217086 4 0.138911297023541
329311 329311 111002 111002 240995 2 0.0264893449871057
329312 329312 111002 111002 241995 4 0.0395699948398712
329313 329313 111002 111002 256407 1 0.0277822594047081
329314 329314 111002 111002 266291 1 0.0185215062698054
329315 329315 111002 111002 274255 2 0.0253616169573645
329316 329316 111002 111002 321423 4 0.02480763602626
329317 329317 111002 111002 321870 1 0.019844471003363 
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)
);