consensus_index

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

10 rows where inventory_id = 157293

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
438891 438891 157293 157293 30288 1 0.0808934720858596
438892 438892 157293 157293 40240 1 0.0606701040643947
438893 438893 157293 157293 53420 4 0.204069092083277
438894 438894 157293 157293 92418 4 0.204069092083277
438895 438895 157293 157293 119803 1 0.0346686308939398
438896 438896 157293 157293 128763 2 0.171600967996908
438897 438897 157293 157293 215275 1 0.0485360832515158
438898 438898 157293 157293 253130 1 0.0808934720858596
438899 438899 157293 157293 265152 1 0.0606701040643947
438900 438900 157293 157293 327223 1 0.0404467360429298 
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)
);