consensus_index

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

15 rows where inchi_id = 31915

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
120763 120763 42022 42022 31915 8 0.27571711719394
120781 120781 42023 42023 31915 1 0.0613470815975913
178740 178740 63717 63717 31915 8 0.27571711719394
230790 230790 79014 79014 31915 8 0.329436195577638
280620 280620 95166 95166 31915 2 0.0608012331690931
559138 559138 220009 220009 31915 2 0.0497768415451947
565483 565483 222093 222093 31915 5 0.373665480427046
668100 668100 239423 239423 31915 3 0.194508174024522
697820 697820 248773 248773 31915 12 0.247896815913315
704819 704819 250885 250885 31915 2 0.0587715581627187
790527 790527 276038 276038 31915 8 0.27571711719394
952621 952621 341788 341788 31915 4 0.37261069441084
1622142 1622142 489792 489792 31915 8 0.27571711719394
1645715 1645715 498238 498238 31915 1 0.0613470815975913
1723900 1723900 527917 527917 31915 8 0.27571711719394 
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)
);