consensus_index

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

14 rows where inchi_id = 137696

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
17912 17912 5240 5240 137696 4 0.473684210526316
135840 135840 48129 48129 137696 1 0.263157894736842
135845 135845 48133 48133 137696 1 0.3
135932 135932 48172 48172 137696 4 0.473684210526316
215427 215427 74823 74823 137696 4 0.470588235294118
226467 226467 77960 77960 137696 1 0.259842519685039
433690 433690 155862 155862 137696 1 0.259842519685039
503177 503177 201404 201404 137696 1 0.3
519792 519792 207689 207689 137696 1 0.259842519685039
536593 536593 212954 212954 137696 4 0.470588235294118
556100 556100 219142 219142 137696 1 0.3125
849187 849187 293773 293773 137696 4 0.473684210526316
849189 849189 293774 293774 137696 4 0.470588235294118
1611504 1611504 486447 486447 137696 4 0.473684210526316 
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)
);