consensus_index

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

9 rows where inventory_id = 155842

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
433637 433637 155842 155842 7610 6 0.236755122601657
433638 433638 155842 155842 28920 1 0.118377561300828
433639 433639 155842 155842 36890 2 0.118377561300828
433640 433640 155842 155842 98845 2 0.236755122601657
433641 433641 155842 155842 176507 1 0.0473510245203313
433642 433642 155842 155842 177663 1 0.0591887806504142
433643 433643 155842 155842 196755 1 0.0394591871002761
433644 433644 155842 155842 202366 1 0.0789183742005522
433645 433645 155842 155842 229027 2 0.0516642033566972 
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)
);