consensus_index

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

12 rows where inchi_id = 198457

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
18417 18417 5384 5384 198457 1 0.307692307692308
117256 117256 40926 40926 198457 1 0.307692307692308
188203 188203 66994 66994 198457 2 0.11919954088609
223830 223830 77225 77225 198457 2 0.168025755550837
432047 432047 155393 155393 198457 2 0.168025755550837
675765 675765 241560 241560 198457 1 0.310344827586207
750392 750392 263792 263792 198457 1 0.307692307692308
750396 750396 263793 263793 198457 2 0.168025755550837
750399 750399 263794 263794 198457 1 0.310344827586207
953902 953902 342463 342463 198457 1 0.3
1615403 1615403 487729 487729 198457 1 0.310344827586207
1721230 1721230 527154 527154 198457 1 0.307692307692308 
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)
);