consensus_index

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

18 rows where inchi_id = 78138

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
181221 181221 64742 64742 78138 8 0.396600566572238
248083 248083 84421 84421 78138 8 0.378978066261104
346886 346886 117138 117138 78138 1 0.310344827586207
442117 442117 158494 158494 78138 7 0.395738203957382
522367 522367 208414 208414 78138 7 0.395738203957382
536165 536165 212786 212786 78138 8 0.378978066261104
731410 731410 257955 257955 78138 12 0.381004626211676
849716 849716 293975 293975 78138 8 0.378978066261104
849722 849722 293976 293976 78138 8 0.396600566572238
849728 849728 293977 293977 78138 4 0.392156862745098
849734 849734 293978 293978 78138 4 0.392156862745098
883228 883228 307217 307217 78138 1 0.3
1169855 1169855 392901 392901 78138 8 0.396600566572238
1425465 1425465 444494 444494 78138 8 0.396600566572238
1583997 1583997 478204 478204 78138 8 0.396600566572238
1606192 1606192 485243 485243 78138 8 0.396600566572238
1630765 1630765 492828 492828 78138 8 0.396600566572238
1677044 1677044 509211 509211 78138 1 0.3125 
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)
);