consensus_index

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

11 rows where inventory_id = 209757

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
527717 527717 209757 209757 771 1 0.219037539578272
527718 527718 209757 209757 9320 2 0.126461382438149
527719 527719 209757 209757 75905 2 0.0774414647851066
527720 527720 209757 209757 75906 1 0.027379692447284
527721 527721 209757 209757 106400 1 0.0365062565963787
527722 527722 209757 209757 125489 1 0.0243375043975858
527723 527723 209757 209757 128617 1 0.0730125131927574
527724 527724 209757 209757 129506 2 0.109518769789136
527725 527725 209757 209757 133351 4 0.219037539578272
527726 527726 209757 209757 138986 1 0.0438075079156545
527727 527727 209757 209757 140205 1 0.0312910770826103 
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)
);