consensus_index

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

21 rows where inventory_id = 283743

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
817078 817078 283743 283743 54009 8 0.238795264194772
817079 817079 283743 283743 101864 1 0.0596988160486931
817080 817080 283743 283743 176673 1 0.0265328071327525
817081 817081 283743 283743 232270 3 0.0506169465826078
817082 817082 283743 283743 261595 1 0.0397992106991287
817083 817083 283743 283743 262660 2 0.0422134376568392
817084 817084 283743 283743 313832 1 0.0198996053495644
817085 817085 283743 283743 313959 1 0.0397992106991287
817086 817086 283743 283743 314248 2 0.119397632097386
817087 817087 283743 283743 314509 1 0.0183688664765209
817088 817088 283743 283743 315327 1 0.0217086603813429
817089 817089 283743 283743 315368 1 0.0795984213982574
817090 817090 283743 283743 315467 1 0.0477590528389545
817091 817091 283743 283743 315480 1 0.0238795264194772
817092 817092 283743 283743 315679 1 0.0341136091706818
817093 817093 283743 283743 315681 1 0.0298494080243465
817094 817094 283743 283743 315682 1 0.0265328071327525
817095 817095 283743 283743 317246 2 0.0201818833543232
817096 817096 283743 283743 317270 1 0.0217086603813429
817097 817097 283743 283743 320650 2 0.0177987481148177
817098 817098 283743 283743 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)
);