consensus_index

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

16 rows where inchi_id = 42843

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
13203 13203 4050 4050 42843 1 0.0520043336944745
39391 39391 11892 11892 42843 1 0.0520043336944745
87619 87619 31351 31351 42843 8 0.519685039370079
159906 159906 57501 57501 42843 1 0.0566037735849057
233556 233556 79824 79824 42843 8 0.372427135874776
278621 278621 94462 94462 42843 1 0.0567066521264995
436395 436395 156568 156568 42843 8 0.413793103448276
453572 453572 162882 162882 42843 1 0.0563380281690141
559992 559992 220275 220275 42843 12 0.37416901957846
703823 703823 250617 250617 42843 12 0.37416901957846
800727 800727 279327 279327 42843 1 0.0520043336944745
800735 800735 279328 279328 42843 1 0.0563380281690141
931185 931185 331562 331562 42843 4 0.506024096385542
956654 956654 343897 343897 42843 1 0.0563380281690141
1615591 1615591 487801 487801 42843 8 0.519685039370079
1724446 1724446 528063 528063 42843 4 0.506024096385542 
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)
);