consensus_index

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

13 rows where inchi_id = 59776

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
31123 31123 9113 9113 59776 8 0.9
174635 174635 62374 62374 59776 12 0.636363636363636
244756 244756 83292 83292 59776 8 0.625
247432 247432 84211 84211 59776 1 0.239130434782609
440825 440825 158039 158039 59776 8 0.625
548047 548047 216695 216695 59776 8 0.9
599998 599998 236289 236289 59776 1 1.52803657068913e-06
718938 718938 254205 254205 59776 12 0.636363636363636
823405 823405 285826 285826 59776 7 0.888888888888889
823406 823406 285827 285827 59776 8 0.9
883955 883955 307582 307582 59776 4 0.833333333333333
1629218 1629218 492238 492238 59776 8 0.9
1727377 1727377 528972 528972 59776 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)
);