consensus_index

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

17 rows where inventory_id = 472172

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1553582 1553582 472172 472172 73654 8 0.235274668141672
1553583 1553583 472172 472172 96137 1 0.0235274668141672
1553584 1553584 472172 472172 106602 1 0.0196062223451394
1553585 1553585 472172 472172 121932 1 0.0261416297935192
1553586 1553586 472172 472172 124382 2 0.117637334070836
1553587 1553587 472172 472172 139110 1 0.0213886061946975
1553588 1553588 472172 472172 172867 1 0.0168053334386909
1553589 1553589 472172 472172 188473 1 0.117637334070836
1553590 1553590 472172 472172 190893 1 0.0588186670354181
1553591 1553591 472172 472172 190912 1 0.0470549336283345
1553592 1553592 472172 472172 191014 1 0.0392124446902787
1553593 1553593 472172 472172 191015 1 0.0336106668773818
1553594 1553594 472172 472172 212272 2 0.0326267261462528
1553595 1553595 472172 472172 227831 1 0.0156849778761115
1553596 1553596 472172 472172 232173 1 0.0784248893805575
1553597 1553597 472172 472172 273578 1 0.029409333517709
1553598 1553598 472172 472172 281900 1 0.0784248893805575 
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)
);