consensus_index

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

23 rows where inchi_id = 86831

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
22206 22206 6530 6530 86831 2 0.385964912280702
93019 93019 33080 33080 86831 2 0.385964912280702
139619 139619 49733 49733 86831 2 0.385964912280702
221190 221190 76550 76550 86831 2 0.323529411764706
228148 228148 78429 78429 86831 1 0.250930238077992
409586 409586 144493 144493 86831 1 0.415239576400731
409588 409588 144494 144494 86831 1 0.42052772921983
409591 409591 144496 144496 86831 1 0.350440262760282
429945 429945 154852 154852 86831 2 0.384615384615385
497033 497033 190314 190314 86831 2 0.470588235294118
497035 497035 190315 190315 86831 1 0.408628001184222
497038 497038 190317 190317 86831 1 0.343849596088132
593753 593753 231382 231382 86831 2 0.324324324324324
672063 672063 240478 240478 86831 2 0.385964912280702
743575 743575 261753 261753 86831 2 0.385964912280702
743578 743578 261754 261754 86831 1 0.375
743582 743582 261755 261755 86831 2 0.323529411764706
743585 743585 261756 261756 86831 1 0.375
743588 743588 261757 261757 86831 1 0.375
765966 765966 268236 268236 86831 1 0.250930238077992
939815 939815 335978 335978 86831 1 0.375
1616619 1616619 488146 488146 86831 2 0.384615384615385
1719699 1719699 526685 526685 86831 2 0.385964912280702 
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)
);