consensus_index

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

28 rows where inchi_id = 3053

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
18758 18758 5507 5507 3053 8 0.502113490128201
80954 80954 29191 29191 3053 8 0.502113490128201
146475 146475 52357 52357 3053 4 0.470588235294118
150430 150430 53926 53926 3053 8 0.502113490128201
243225 243225 82728 82728 3053 4 0.384615384615385
252302 252302 85723 85723 3053 7 0.620689655172414
421074 421074 152412 152412 3053 1 0.0758533501896334
440075 440075 157762 157762 3053 4 0.470588235294118
440077 440077 157763 157763 3053 4 0.470588235294118
443623 443623 159029 159029 3053 7 0.620689655172414
592811 592811 231097 231097 3053 8 0.502113490128201
672931 672931 240706 240706 3053 8 0.502113490128201
717288 717288 253713 253713 3053 4 0.473684210526316
745262 745262 262218 262218 3053 8 0.502113490128201
745265 745265 262219 262219 3053 7 0.620689655172414
820743 820743 284952 284952 3053 4 0.473684210526316
820745 820745 284953 284953 3053 2 0.454545454545455
935234 935234 333766 333766 3053 2 0.454545454545455
952651 952651 341806 341806 3053 2 0.454545454545455
958638 958638 344874 344874 3053 4 0.6
985691 985691 354563 354563 3053 8 0.502113490128201
985694 985694 354564 354564 3053 8 0.502113490128201
1194986 1194986 398551 398551 3053 8 0.502113490128201
1444242 1444242 449120 449120 3053 8 0.502113490128201
1590711 1590711 480155 480155 3053 8 0.502113490128201
1632416 1632416 493398 493398 3053 8 0.502113490128201
1632419 1632419 493399 493399 3053 1 0.3125
1729038 1729038 529506 529506 3053 8 0.502113490128201 
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)
);