consensus_index

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

11 rows where inventory_id = 56970

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
158249 158249 56970 56970 6801 1 0.037915734510997
158250 158250 56970 56970 56065 16 0.303325876087976
158251 158251 56970 56970 71273 1 0.101108625362659
158252 158252 56970 56970 137217 3 0.151662938043988
158253 158253 56970 56970 167192 1 0.075831469021994
158254 158254 56970 56970 204666 1 0.101108625362659
158255 158255 56970 56970 231765 1 0.043332268012568
158256 158256 56970 56970 241833 1 0.0303325876087976
158257 158257 56970 56970 245816 1 0.0606651752175952
158258 158258 56970 56970 294834 1 0.0505543126813294
158259 158259 56970 56970 310061 1 0.0337028751208862 
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)
);