consensus_index

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

23 rows where inchi_id = 2622

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1496 1496 342 342 2622 12 0.417391304347826
22380 22380 6581 6581 2622 8 0.364485981308411
85200 85200 30654 30654 2622 8 0.364485981308411
135083 135083 47874 47874 2622 12 0.392597622187788
202508 202508 71778 71778 2622 12 0.417391304347826
221398 221398 76611 76611 2622 8 0.413793103448276
246479 246479 83891 83891 2622 1 0.3125
430137 430137 154906 154906 2622 8 0.413793103448276
516970 516970 207019 207019 2622 8 0.413793103448276
516974 516974 207020 207020 2622 12 0.417391304347826
593431 593431 231278 231278 2622 8 0.390166220119898
597639 597639 235460 235460 2622 11 0.525
597642 597642 235461 235461 2622 8 0.413793103448276
672406 672406 240568 240568 2622 12 0.296303762525096
692521 692521 247027 247027 2622 1 0.269752143389818
744206 744206 261927 261927 2622 8 0.364485981308411
744211 744211 261928 261928 2622 7 0.517241379310345
744214 744214 261929 261929 2622 5 0.51063829787234
744217 744217 261930 261930 2622 8 0.519685039370079
962810 962810 346606 346606 2622 4 0.506024096385542
1616809 1616809 488203 488203 2622 8 0.364485981308411
1630009 1630009 492549 492549 2622 1 0.3125
1719847 1719847 526727 526727 2622 4 0.506024096385542 
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)
);