consensus_index

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

27 rows where inchi_id = 3977

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
32606 32606 9609 9609 3977 9 0.3418573664567
86550 86550 31044 31044 3977 5 0.30543376308719
113060 113060 39494 39494 3977 6 0.331664351809439
158600 158600 57136 57136 3977 1 0.0118038998607756
158621 158621 57137 57137 3977 12 0.324854664130934
213479 213479 74336 74336 3977 1 0.0118038998607756
252836 252836 85896 85896 3977 7 0.331536959248562
317731 317731 107080 107080 3977 8 0.26089747925788
344649 344649 116418 116418 3977 1 0.0849179946904083
424577 424577 153344 153344 3977 1 0.0118038998607756
591122 591122 230632 230632 3977 10 0.296012184757719
674756 674756 241175 241175 3977 9 0.3418573664567
686818 686818 244866 244866 3977 11 0.24788832638698
724838 724838 256130 256130 3977 1 0.0118694675244533
748895 748895 263302 263302 3977 6 0.320437409894476
748901 748901 263303 263303 3977 9 0.3418573664567
838950 838950 291005 291005 3977 1 0.0118038998607756
916770 916770 324951 324951 3977 5 0.30543376308719
916808 916808 324967 324967 3977 2 0.160353109088243
995670 995670 356779 356779 3977 9 0.346892414763999
1206403 1206403 401023 401023 3977 9 0.346892414763999
1451531 1451531 450681 450681 3977 9 0.346892414763999
1591590 1591590 480394 480394 3977 9 0.346892414763999
1632668 1632668 493493 493493 3977 9 0.346892414763999
1651225 1651225 500117 500117 3977 1 0.0118694675244533
1729151 1729151 529548 529548 3977 9 0.3418573664567
1747114 1747114 535117 535117 3977 6 0.331664351809439 
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)
);