consensus_index

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

12 rows where inventory_id = 283104

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
814736 814736 283104 283104 406 2 0.0324071522499245
814737 814737 283104 283104 15869 1 0.0591670943726265
814738 814738 283104 283104 25105 1 0.0443753207794699
814739 814739 283104 283104 52807 3 0.140882861773514
814740 814740 283104 283104 124505 1 0.177501283117879
814741 814741 283104 283104 128309 1 0.177501283117879
814742 814742 283104 283104 170768 2 0.0561308342254893
814743 814743 283104 283104 219605 1 0.0443753207794699
814744 814744 283104 283104 220622 1 0.0253573261596971
814745 814745 283104 283104 224700 2 0.0341601378632039
814746 814746 283104 283104 229563 4 0.177501283117879
814747 814747 283104 283104 263410 1 0.0221876603897349 
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)
);