consensus_index

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

11 rows where inchi_id = 42635

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
4248 4248 1256 1256 42635 12 0.526315789473684
138415 138415 49288 49288 42635 3 0.422848273111451
138417 138417 49289 49289 42635 7 0.413793103448276
162039 162039 58133 58133 42635 1 0.0280713504392122
206112 206112 73053 73053 42635 10 0.523489932885906
356222 356222 120728 120728 42635 6 0.514285714285714
795649 795649 277651 277651 42635 1 0.0194076224473227
808979 808979 281662 281662 42635 1 0.0328845899892596
843452 843452 292248 292248 42635 1 0.032423729451845
853905 853905 295380 295380 42635 1 0.0317900233576736
1755172 1755172 537889 537889 42635 7 0.413793103448276 
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)
);