consensus_index

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

27 rows where inchi_id = 2358

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
32463 32463 9561 9561 2358 7 0.620689655172414
47827 47827 14720 14720 2358 1 0.117485026900282
79806 79806 28804 28804 2358 7 0.620689655172414
79808 79808 28805 28805 2358 1 0.117485026900282
158389 158389 57064 57064 2358 6 0.19930319730676
188639 188639 67168 67168 2358 7 0.620689655172414
251843 251843 85567 85567 2358 7 0.620689655172414
300784 300784 101827 101827 2358 2 0.157642983434974
461460 461460 165823 165823 2358 3 0.352119201842254
595359 595359 231885 231885 2358 1 0.118729109427458
669859 669859 239898 239898 2358 3 0.179996890900792
671745 671745 240423 240423 2358 7 0.620689655172414
848093 848093 293323 293323 2358 3 0.239898523711778
848097 848097 293324 293324 2358 4 0.432136581898648
902800 902800 318102 318102 2358 4 0.6
914861 914861 323904 323904 2358 1 0.120494722585075
975837 975837 353351 353351 2358 4 0.6
975839 975839 353352 353352 2358 4 0.6
1185776 1185776 397356 397356 2358 4 0.6
1185778 1185778 397357 397357 2358 4 0.6
1438782 1438782 448316 448316 2358 4 0.6
1438784 1438784 448317 448317 2358 4 0.6
1590171 1590171 480014 480014 2358 4 0.6
1632172 1632172 493310 493310 2358 4 0.6
1654964 1654964 501446 501446 2358 1 0.110927930587932
1728864 1728864 529457 529457 2358 4 0.6
1742378 1742378 533673 533673 2358 1 0.117485026900282 
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)
);