consensus_index

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

9 rows where inventory_id = 9757

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
33046 33046 9757 9757 7370 6 0.319798799071047
33047 33047 9757 9757 138329 2 0.106599599690349
33048 33048 9757 9757 138373 2 0.113065949719226
33049 33049 9757 9757 192133 2 0.159899399535524
33050 33050 9757 9757 195510 1 0.0456855427244353
33051 33051 9757 9757 199481 1 0.0532997998451746
33052 33052 9757 9757 237674 1 0.0799496997677619
33053 33053 9757 9757 260096 1 0.0639597598142095
33054 33054 9757 9757 334461 1 0.0399748498838809 
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)
);