consensus_index

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

11 rows where inventory_id = 74174

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
212215 212215 74174 74174 14240 2 0.147835269271383
212216 212216 74174 74174 33027 1 0.0591341077085533
212217 212217 74174 74174 45992 1 0.0369588173178458
212218 212218 74174 74174 61368 8 0.295670538542767
212219 212219 74174 74174 94018 1 0.0591341077085533
212220 212220 74174 74174 97121 1 0.0492784230904611
212221 212221 74174 74174 148742 1 0.0739176346356917
212222 212222 74174 74174 168950 1 0.0422386483632524
212223 212223 74174 74174 171974 1 0.0739176346356917
212224 212224 74174 74174 176709 2 0.0985568461809222
212225 212225 74174 74174 318196 1 0.0492784230904611 
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)
);