consensus_index

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

21 rows where inventory_id = 74002

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
211047 211047 74002 74002 54009 8 0.238795264194772
211048 211048 74002 74002 101864 1 0.0596988160486931
211049 211049 74002 74002 176673 1 0.0265328071327525
211050 211050 74002 74002 232270 3 0.0506169465826078
211051 211051 74002 74002 261595 1 0.0397992106991287
211052 211052 74002 74002 262660 2 0.0422134376568392
211053 211053 74002 74002 313832 1 0.0198996053495644
211054 211054 74002 74002 313959 1 0.0397992106991287
211055 211055 74002 74002 314248 2 0.119397632097386
211056 211056 74002 74002 314509 1 0.0183688664765209
211057 211057 74002 74002 315327 1 0.0217086603813429
211058 211058 74002 74002 315368 1 0.0795984213982574
211059 211059 74002 74002 315467 1 0.0477590528389545
211060 211060 74002 74002 315480 1 0.0238795264194772
211061 211061 74002 74002 315679 1 0.0341136091706818
211062 211062 74002 74002 315681 1 0.0298494080243465
211063 211063 74002 74002 315682 1 0.0265328071327525
211064 211064 74002 74002 317246 2 0.0201818833543232
211065 211065 74002 74002 317270 1 0.0217086603813429
211066 211066 74002 74002 320650 2 0.0177987481148177
211067 211067 74002 74002 324642 1 0.0149247040121733 
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)
);