consensus_index

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

13 rows where inchi_id = 39689

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
27618 27618 8015 8015 39689 8 0.519685039370079
327264 327264 110295 110295 39689 1 0.0744021257750222
561336 561336 220749 220749 39689 6 0.514285714285714
906869 906869 320075 320075 39689 4 0.506024096385542
1054780 1054780 372893 372893 39689 8 0.519685039370079
1054783 1054783 372894 372894 39689 8 0.519685039370079
1277725 1277725 420321 420321 39689 8 0.519685039370079
1277728 1277728 420322 420322 39689 8 0.519685039370079
1495325 1495325 462659 462659 39689 8 0.519685039370079
1495328 1495328 462660 462660 39689 8 0.519685039370079
1599332 1599332 483096 483096 39689 8 0.519685039370079
1623045 1623045 490105 490105 39689 8 0.519685039370079
1668623 1668623 506087 506087 39689 1 0.084736556219446 
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)
);