consensus_index

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

5 rows where inventory_id = 27742

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
77226 77226 27742 27742 49313 1 0.0789473684210526
77227 77227 27742 27742 76713 6 0.315789473684211
77228 77228 27742 27742 112107 2 0.315789473684211
77229 77229 27742 27742 137004 1 0.105263157894737
77230 77230 27742 27742 225063 1 0.157894736842105 
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)
);