consensus_index

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

11 rows where inventory_id = 70003

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
197173 197173 70003 70003 43801 2 0.0417822938503244
197174 197174 70003 70003 43802 3 0.123593691969716
197175 197175 70003 70003 74743 12 0.247187383939432
197176 197176 70003 70003 115267 4 0.247187383939432
197177 197177 70003 70003 137984 1 0.0411978973232386
197178 197178 70003 70003 159133 2 0.0823957946464773
197179 197179 70003 70003 173839 1 0.0617968459848579
197180 197180 70003 70003 185927 1 0.0274652648821591
197181 197181 70003 70003 195871 1 0.030898422992429
197182 197182 70003 70003 198566 2 0.0390837571053565
197183 197183 70003 70003 228312 1 0.0494374767878864 
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)
);