consensus_index

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

11 rows where inventory_id = 490303

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1623667 1623667 490303 490303 44373 8 0.264158066434462
1623668 1623668 490303 490303 185065 3 0.133576521061255
1623669 1623669 490303 490303 185632 1 0.0285515797569375
1623670 1623670 490303 490303 192592 4 0.148316510131295
1623671 1623671 490303 490303 234413 4 0.0567463330682094
1623672 1623672 490303 490303 241008 3 0.0565204335525544
1623673 1623673 490303 490303 259965 1 0.0507583640123333
1623674 1623674 490303 490303 289169 1 0.0652607537301428
1623675 1623675 490303 490303 310196 1 0.03806877300925
1623676 1623676 490303 490303 330200 1 0.0351404058546923
1623677 1623677 490303 490303 343947 2 0.107674750185168 
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)
);