consensus_index

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

10 rows where inventory_id = 485763

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1608117 1608117 485763 485763 49226 7 0.327039830790287
1608118 1608118 485763 485763 137106 3 0.163519915395144
1608119 1608119 485763 485763 150909 1 0.0408799788487859
1608120 1608120 485763 485763 170699 1 0.0545066384650479
1608121 1608121 485763 485763 170703 3 0.0919453587144284
1608122 1608122 485763 485763 192055 1 0.0467199758271839
1608123 1608123 485763 485763 215544 1 0.0817599576975718
1608124 1608124 485763 485763 241143 1 0.0363377589766986
1608125 1608125 485763 485763 242127 1 0.0327039830790287
1608126 1608126 485763 485763 254605 1 0.109013276930096 
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)
);