consensus_index

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

22 rows where inchi_id = 3164

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
22844 22844 6706 6706 3164 6 0.384615384615385
33849 33849 10021 10021 3164 1 0.179663678094829
111875 111875 39144 39144 3164 6 0.384615384615385
111929 111929 39168 39168 3164 1 0.179663678094829
152094 152094 54701 54701 3164 6 0.384615384615385
152144 152144 54722 54722 3164 1 0.179663678094829
222039 222039 76787 76787 3164 5 0.384615384615385
255994 255994 86866 86866 3164 1 0.165556140046166
430640 430640 155045 155045 3164 5 0.384615384615385
445131 445131 159528 159528 3164 1 0.165556140046166
583468 583468 228041 228041 3164 1 0.165556140046166
592670 592670 231055 231055 3164 5 0.380952380952381
673242 673242 240785 240785 3164 6 0.384615384615385
681017 681017 243278 243278 3164 1 0.179663678094829
760423 760423 266844 266844 3164 1 0.179663678094829
933717 933717 332702 332702 3164 3 0.375
987285 987285 354974 354974 3164 6 0.382978723404255
1196598 1196598 399001 399001 3164 6 0.382978723404255
1445221 1445221 449397 449397 3164 6 0.382978723404255
1590830 1590830 480195 480195 3164 6 0.382978723404255
1617338 1617338 488355 488355 3164 6 0.382978723404255
1720254 1720254 526857 526857 3164 3 0.375 
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)
);