consensus_index

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

12 rows where inventory_id = 27996

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
77734 77734 27996 27996 26599 8 0.121704259544286
77735 77735 27996 27996 32134 2 0.0632510275479483
77736 77736 27996 27996 45934 10 0.263299229282543
77737 77737 27996 27996 136234 2 0.038493349525991
77738 77738 27996 27996 169043 2 0.0597666032361309
77739 77739 27996 27996 210285 3 0.155053714062256
77740 77740 27996 27996 219581 1 0.0344040234585933
77741 77741 27996 27996 275077 3 0.0677259477947975
77742 77742 27996 27996 277583 1 0.0372710254134761
77743 77743 27996 27996 287282 1 0.0496947005513015
77744 77744 27996 27996 288641 2 0.0377997188475528
77745 77745 27996 27996 289245 2 0.0597666032361309 
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)
);