consensus_index

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

28 rows where inchi_id = 46326

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
28510 28510 8265 8265 46326 6 0.521262687811587
35015 35015 10377 10377 46326 1 0.0648548486720198
101584 101584 35859 35859 46326 1 0.0648548486720198
101590 101590 35860 35860 46326 6 0.521262687811587
166688 166688 59642 59642 46326 6 0.521262687811587
174222 174222 62231 62231 46326 1 0.0648548486720198
236537 236537 80616 80616 46326 5 0.511289347863841
557634 557634 219592 219592 46326 5 0.511289347863841
687642 687642 245232 245232 46326 1 0.0648548486720198
707521 707521 251300 251300 46326 9 0.385733606326156
768012 768012 268824 268824 46326 2 0.130965813245991
768017 768017 268825 268825 46326 2 0.157894736842105
772101 772101 270142 270142 46326 1 0.0648548486720198
805116 805116 280552 280552 46326 7 0.410993971529009
805119 805119 280553 280553 46326 5 0.608695652173913
874938 874938 302463 302463 46326 1 0.0736497545008183
1036949 1036949 367454 367454 46326 1 0.0648548486720198
1036956 1036956 367455 367455 46326 1 0.0648548486720198
1036963 1036963 367456 367456 46326 1 0.0648548486720198
1256353 1256353 413865 413865 46326 1 0.0648548486720198
1256360 1256360 413866 413866 46326 1 0.0648548486720198
1482238 1482238 458587 458587 46326 1 0.0648548486720198
1482245 1482245 458588 458588 46326 1 0.0648548486720198
1595543 1595543 481615 481615 46326 1 0.0648548486720198
1624403 1624403 490532 490532 46326 7 0.410993971529009
1635875 1635875 494574 494574 46326 1 0.0648548486720198
1725248 1725248 528274 528274 46326 7 0.528787695635403
1731397 1731397 530192 530192 46326 1 0.0740907049842838 
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)
);