consensus_index

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

14 rows where inchi_id = 28386

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
3331 3331 934 934 28386 6 0.875
9175 9175 2785 2785 28386 1 0.0375626043405676
199099 199099 70805 70805 28386 6 0.875
201680 201680 71546 71546 28386 1 0.0375626043405676
267781 267781 90770 90770 28386 8 0.519685039370079
449680 449680 161273 161273 28386 8 0.519685039370079
512590 512590 206025 206025 28386 1 0.0552486187845304
523975 523975 208858 208858 28386 6 0.875
523976 523976 208859 208859 28386 10 0.523489932885906
664376 664376 238045 238045 28386 1 0.055452865064695
664385 664385 238047 238047 28386 1 0.0552486187845304
827506 827506 287156 287156 28386 1 0.0552486187845304
952701 952701 341837 341837 28386 4 0.833333333333333
1733380 1733380 530916 530916 28386 4 0.833333333333333 
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)
);