consensus_index

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

12 rows where inchi_id = 36714

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
92701 92701 33006 33006 36714 1 0.077319587628866
136134 136134 48262 48262 36714 1 0.113207547169811
230457 230457 78958 78958 36714 2 0.0928555210528975
273951 273951 92906 92906 36714 7 0.888888888888889
435629 435629 156352 156352 36714 2 0.0928555210528975
565854 565854 222195 222195 36714 1 0.115384615384615
697394 697394 248640 248640 36714 2 0.0643949625932914
789819 789819 275843 275843 36714 1 0.077319587628866
789826 789826 275844 275844 36714 2 0.0928555210528975
878857 878857 305021 305021 36714 4 0.833333333333333
937143 937143 334693 334693 36714 1 0.113207547169811
1723764 1723764 527892 527892 36714 1 0.114982578397213 
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)
);