consensus_index

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

26 rows where inchi_id = 74423

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
47821 47821 14717 14717 74423 2 0.284685614968209
103755 103755 36596 36596 74423 2 0.630993034743972
113595 113595 39664 39664 74423 2 0.284685614968209
113598 113598 39665 39665 74423 8 0.569812970004355
164414 164414 58897 58897 74423 6 0.189052068860788
164820 164820 58967 58967 74423 10 0.353571932533893
296741 296741 100383 100383 74423 8 0.274567245249577
460018 460018 165381 165381 74423 8 0.274567245249577
485042 485042 179340 179340 74423 5 0.258572054793065
540146 540146 214044 214044 74423 8 0.274567245249577
669846 669846 239894 239894 74423 5 0.434192328845085
739172 739172 260494 260494 74423 2 0.165294265516008
739175 739175 260495 260495 74423 2 0.284685614968209
840095 840095 291299 291299 74423 8 0.393686682528472
840099 840099 291300 291300 74423 8 0.274567245249577
840102 840102 291301 291301 74423 7 0.640552778458951
840104 840104 291302 291302 74423 8 0.569812970004355
949752 949752 340663 340663 74423 2 0.314135911075843
971681 971681 352215 352215 74423 2 0.284685614968209
1181760 1181760 396249 396249 74423 2 0.284685614968209
1436145 1436145 447587 447587 74423 2 0.284685614968209
1589592 1589592 479839 479839 74423 2 0.284685614968209
1652439 1652439 500482 500482 74423 8 0.569812970004355
1654954 1654954 501442 501442 74423 2 0.284685614968209
1739654 1739654 532824 532824 74423 4 0.202684291600531
1742369 1742369 533670 533670 74423 6 0.189052068860788 
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)
);