consensus_index

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

14 rows where inchi_id = 30838

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
58570 58570 18486 18486 30838 1 0.191489361702128
79862 79862 28829 28829 30838 1 0.191489361702128
143429 143429 51130 51130 30838 1 0.1875
341353 341353 115182 115182 30838 7 0.620689655172414
342546 342546 115617 115617 30838 1 0.19047619047619
479255 479255 175161 175161 30838 1 0.19047619047619
565699 565699 222155 222155 30838 1 0.19047619047619
697474 697474 248660 248660 30838 1 0.191489361702128
789926 789926 275875 275875 30838 1 0.1875
789929 789929 275876 275876 30838 1 0.1875
789932 789932 275877 275877 30838 1 0.1875
909089 909089 321031 321031 30838 1 0.1875
1675342 1675342 508563 508563 30838 1 0.192307692307692
1752738 1752738 536965 536965 30838 1 0.191489361702128 
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)
);