consensus_index

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

10 rows where inventory_id = 73917

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
210087 210087 73917 73917 52194 8 0.301130930408319
210088 210088 73917 73917 137242 2 0.0804806264391711
210089 210089 73917 73917 159184 1 0.100376976802773
210090 210090 73917 73917 168490 1 0.0501884884013865
210091 210091 73917 73917 188655 1 0.0501884884013865
210092 210092 73917 73917 199420 1 0.100376976802773
210093 210093 73917 73917 207326 1 0.0752827326020797
210094 210094 73917 73917 228198 2 0.106465861458368
210095 210095 73917 73917 231015 1 0.0602261860816638
210096 210096 73917 73917 291133 1 0.0602261860816638 
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)
);