consensus_index

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

20 rows where inchi_id = 111387

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
52898 52898 16454 16454 111387 2 0.470588235294118
153064 153064 55008 55008 111387 1 0.242424242424242
319488 319488 107663 107663 111387 2 0.384615384615385
469868 469868 170003 170003 111387 2 0.297596337275849
575785 575785 225543 225543 111387 1 0.454545454545455
687595 687595 245210 245210 111387 2 0.470588235294118
737123 737123 259930 259930 111387 2 0.470588235294118
899454 899454 316298 316298 111387 1 0.454545454545455
1036870 1036870 367419 367419 111387 2 0.470588235294118
1036872 1036872 367420 367420 111387 2 0.470588235294118
1036874 1036874 367421 367421 111387 2 0.470588235294118
1036876 1036876 367422 367422 111387 2 0.470588235294118
1036878 1036878 367423 367423 111387 2 0.470588235294118
1256268 1256268 413829 413829 111387 2 0.470588235294118
1256270 1256270 413830 413830 111387 2 0.470588235294118
1482165 1482165 458555 458555 111387 2 0.470588235294118
1482167 1482167 458556 458556 111387 2 0.470588235294118
1595513 1595513 481604 481604 111387 2 0.470588235294118
1665210 1665210 504848 504848 111387 2 0.470588235294118
1747557 1747557 535258 535258 111387 2 0.470588235294118 
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)
);