consensus_index

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

15 rows where inchi_id = 180017

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
6407 6407 1964 1964 180017 4 0.201303008020063
97782 97782 34690 34690 180017 2 0.230850698521087
134914 134914 47827 47827 180017 1 0.0449415095042302
207018 207018 73325 73325 180017 4 0.201303008020063
208567 208567 73717 73717 180017 4 0.201303008020063
209333 209333 73833 73833 180017 1 0.0634987103676137
223690 223690 77191 77191 180017 3 0.0326375319392855
675642 675642 241519 241519 180017 3 0.0326486242751054
686696 686696 244836 244836 180017 1 0.0148320407514492
707624 707624 251329 251329 180017 5 0.152484276110878
943231 943231 337762 337762 180017 1 0.0449415095042302
964165 964165 347874 347874 180017 2 0.230768739867556
1615339 1615339 487710 487710 180017 1 0.0367156672559678
1714453 1714453 525355 525355 180017 2 0.230768739867556
1721161 1721161 527135 527135 180017 1 0.0455296608365985 
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)
);