consensus_index

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

28 rows where inventory_id = 87056

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
257027 257027 87056 87056 140499 1 0.0215091634811849
257028 257028 87056 87056 168997 1 0.0179243029009874
257029 257029 87056 87056 181645 3 0.215091634811849
257030 257030 87056 87056 215564 1 0.0119495352673249
257031 257031 87056 87056 216811 1 0.0358486058019748
257032 257032 87056 87056 224772 1 0.0238990705346498
257033 257033 87056 87056 232166 1 0.0358486058019748
257034 257034 87056 87056 232167 1 0.0307273764016927
257035 257035 87056 87056 232168 1 0.0268864543514811
257036 257036 87056 87056 232169 1 0.0238990705346498
257037 257037 87056 87056 234941 1 0.0268864543514811
257038 257038 87056 87056 253719 2 0.107545817405924
257039 257039 87056 87056 258435 1 0.0195537849828953
257040 257040 87056 87056 263205 1 0.0107545817405924
257041 257041 87056 87056 266061 2 0.0177404590370082
257042 257042 87056 87056 267560 2 0.0716972116039495
257043 257043 87056 87056 270858 2 0.0165946799001456
257044 257044 87056 87056 288207 2 0.0188647843197591
257045 257045 87056 87056 292785 1 0.0195537849828953
257046 257046 87056 87056 295288 2 0.0430183269623697
257047 257047 87056 87056 296206 2 0.0154030318970223
257048 257048 87056 87056 297691 2 0.0143714143611971
257049 257049 87056 87056 297699 2 0.0134695606528396
257050 257050 87056 87056 298071 2 0.0537729087029621
257051 257051 87056 87056 307946 2 0.0126743961293299
257052 257052 87056 87056 308671 2 0.0119680187049263
257053 257053 87056 87056 330464 1 0.0107545817405924
257054 257054 87056 87056 343703 1 0.0113206123585183 
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)
);