consensus_index

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

17 rows where inchi_id = 5689

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
13280 13280 4073 4073 5689 1 0.384615384615385
105973 105973 37272 37272 5689 4 0.172824310115419
105978 105978 37273 37273 5689 2 0.470588235294118
256101 256101 86891 86891 5689 1 0.380952380952381
304150 304150 102858 102858 5689 1 0.466666666666667
363444 363444 123499 123499 5689 4 0.172824310115419
445205 445205 159552 159552 5689 1 0.466666666666667
583339 583339 228004 228004 5689 1 0.466666666666667
589191 589191 230022 230022 5689 1 0.466666666666667
681136 681136 243307 243307 5689 2 0.384615384615385
1021279 1021279 363446 363446 5689 2 0.384615384615385
1236873 1236873 409085 409085 5689 2 0.384615384615385
1470424 1470424 455619 455619 5689 2 0.384615384615385
1593800 1593800 481080 481080 5689 2 0.384615384615385
1634585 1634585 494142 494142 5689 2 0.384615384615385
1656863 1656863 502057 502057 5689 2 0.470588235294118
1730417 1730417 529940 529940 5689 1 0.454545454545455 
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)
);