consensus_index

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

12 rows where inchi_id = 18147

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
22165 22165 6516 6516 18147 1 0.137931034482759
35348 35348 10500 10500 18147 8 0.519685039370079
103372 103372 36371 36371 18147 8 0.519685039370079
134232 134232 47647 47647 18147 1 0.138888888888889
260632 260632 88283 88283 18147 8 0.519685039370079
447000 447000 160168 160168 18147 8 0.519685039370079
593788 593788 231395 231395 18147 1 0.139130434782609
671997 671997 240459 240459 18147 1 0.137931034482759
743423 743423 261714 261714 18147 1 0.137931034482759
774321 774321 270857 270857 18147 8 0.519685039370079
774324 774324 270858 270858 18147 8 0.519685039370079
1616579 1616579 488132 488132 18147 1 0.137931034482759 
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)
);