consensus_index

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

8 rows where inventory_id = 285001

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
820875 820875 285001 285001 670 1 0.0474877083728428
820876 820876 285001 285001 55405 1 0.0664827917219799
820877 820877 285001 285001 57513 2 0.235052164294124
820878 820878 285001 285001 111793 3 0.332413958609899
820879 820879 285001 285001 117376 1 0.0831034896524749
820880 820880 285001 285001 146691 1 0.0554023264349832
820881 820881 285001 285001 248147 1 0.110804652869966
820882 820882 285001 285001 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)
);