consensus_index

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

25 rows where inchi_id = 28243

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
37032 37032 11093 11093 28243 1 0.0798494104743666
57087 57087 17936 17936 28243 8 0.519685039370079
106830 106830 37625 37625 28243 8 0.519685039370079
107030 107030 37679 37679 28243 1 0.0779915444187703
193818 193818 68877 68877 28243 1 0.0779915444187703
193826 193826 68879 68879 28243 8 0.519685039370079
267660 267660 90723 90723 28243 1 0.0792042391051434
337122 337122 113632 113632 28243 5 0.484661937991346
449622 449622 161247 161247 28243 1 0.0779915444187703
476717 476717 173737 173737 28243 4 0.506024096385542
551587 551587 217938 217938 28243 1 0.212341241774573
568106 568106 222914 222914 28243 1 0.0792042391051434
695207 695207 247907 247907 28243 1 0.0786577639544007
784619 784619 274257 274257 28243 1 0.0779915444187703
784625 784625 274258 274258 28243 1 0.0779915444187703
784631 784631 274259 274259 28243 1 0.0779915444187703
784637 784637 274260 274260 28243 1 0.0786577639544007
784668 784668 274268 274268 28243 4 0.506024096385542
784671 784671 274269 274269 28243 8 0.519685039370079
917882 917882 325349 325349 28243 1 0.0779915444187703
956989 956989 344059 344059 28243 4 0.506024096385542
1639773 1639773 496040 496040 28243 1 0.0784326804196477
1672849 1672849 507640 507640 28243 8 0.519685039370079
1733346 1733346 530903 530903 28243 1 0.0779915444187703
1751248 1751248 536446 536446 28243 5 0.51063829787234 
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)
);