consensus_index

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

8 rows where inventory_id = 285000

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
820867 820867 285000 285000 670 1 0.0474877083728428
820868 820868 285000 285000 55405 1 0.0664827917219799
820869 820869 285000 285000 57513 2 0.235052164294124
820870 820870 285000 285000 111793 3 0.332413958609899
820871 820871 285000 285000 117376 1 0.0831034896524749
820872 820872 285000 285000 146691 1 0.0554023264349832
820873 820873 285000 285000 248147 1 0.110804652869966
820874 820874 285000 285000 296588 1 0.0415517448262374 
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)
);