consensus_index

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

17 rows where inventory_id = 540982

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1761782 1761782 540982 540982 77326 8 0.279589668883013
1761783 1761783 540982 540982 137018 2 0.0721897420903704
1761784 1761784 540982 540982 140038 2 0.139794834441507
1761785 1761785 540982 540982 199479 2 0.0625181505429075
1761786 1761786 540982 540982 199500 2 0.080710585296123
1761787 1761787 540982 540982 200267 1 0.0279589668883013
1761788 1761788 540982 540982 238099 2 0.0465982781471689
1761789 1761789 540982 540982 240582 2 0.0243351570942923
1761790 1761790 540982 540982 241472 2 0.0223850887506063
1761791 1761791 540982 540982 255607 2 0.0264187404645481
1761792 1761792 540982 540982 258842 2 0.03294995846948
1761793 1761793 540982 540982 271857 2 0.0186808705328894
1761794 1761794 540982 540982 275451 3 0.0606427789414662
1761795 1761795 540982 540982 284024 1 0.0310655187647793
1761796 1761796 540982 540982 291652 1 0.0186393112588676
1761797 1761797 540982 540982 320803 1 0.0215068976063856
1761798 1761798 540982 540982 320994 2 0.0266578289619516 
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)
);