consensus_index

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

17 rows where inventory_id = 213104

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
536941 536941 213104 213104 19319 1 0.0553787477134927
536942 536942 213104 213104 105684 3 0.221514990853971
536943 536943 213104 213104 147618 2 0.110757495426985
536944 536944 213104 213104 147619 1 0.0138446869283732
536945 536945 213104 213104 169623 1 0.0246127767615523
536946 536946 213104 213104 189973 1 0.0184595825711642
536947 536947 213104 213104 190442 1 0.0201377264412701
536948 536948 213104 213104 193072 1 0.0443029981707942
536949 536949 213104 213104 193567 2 0.0391586880418297
536950 536950 213104 213104 195792 2 0.156634752167319
536951 536951 213104 213104 216577 2 0.0738383302846569
536952 536952 213104 213104 231646 1 0.0170396146810747
536953 536953 213104 213104 237718 1 0.0369191651423285
536954 536954 213104 213104 240733 1 0.0158224993467122
536955 536955 213104 213104 243322 1 0.0316449986934244
536956 536956 213104 213104 296001 2 0.0313269504334638
536957 536957 213104 213104 308220 1 0.0147676660569314 
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)
);