consensus_index

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

12 rows where inchi_id = 102345

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
34301 34301 10133 10133 102345 4 0.241468095114964
101677 101677 35872 35872 102345 4 0.174478732263343
131892 131892 46837 46837 102345 4 0.174478732263343
268498 268498 91007 91007 102345 4 0.241468095114964
449996 449996 161393 161393 102345 3 0.310365416464294
696190 696190 248199 248199 102345 4 0.241890459627781
787165 787165 274933 274933 102345 4 0.241890459627781
787170 787170 274934 274934 102345 3 0.310365416464294
787175 787175 274935 274935 102345 3 0.310365416464294
938499 938499 335347 335347 102345 3 0.310365416464294
1640212 1640212 496194 496194 102345 4 0.311979209083551
1733552 1733552 530981 530981 102345 3 0.310365416464294 
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)
);