consensus_index

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

25 rows where inchi_id = 78289

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
83223 83223 29977 29977 78289 1 0.0899546825729765
169335 169335 60377 60377 78289 1 0.0899546825729765
186523 186523 66488 66488 78289 8 0.625
215661 215661 74919 74919 78289 8 0.625
249232 249232 84772 84772 78289 1 0.0749233541613561
335003 335003 112918 112918 78289 4 0.5
426169 426169 153744 153744 78289 8 0.625
442537 442537 158628 158628 78289 1 0.0749233541613561
475820 475820 173281 173281 78289 4 0.5
534346 534346 212036 212036 78289 1 0.0749233541613561
536064 536064 212746 212746 78289 8 0.625
782721 782721 273653 273653 78289 4 0.656703184093677
782722 782722 273654 273654 78289 3 0.346034940914341
782724 782724 273655 273655 78289 2 0.630993034743972
853272 853272 295212 295212 78289 1 0.063103533237408
853278 853278 295213 295213 78289 1 0.0931394047339292
894939 894939 314165 314165 78289 1 0.0931394047339292
1169984 1169984 392957 392957 78289 8 0.625
1425606 1425606 444560 444560 78289 8 0.625
1584086 1584086 478238 478238 78289 8 0.625
1606239 1606239 485259 485259 78289 8 0.625
1611643 1611643 486517 486517 78289 8 0.625
1631125 1631125 492946 492946 78289 1 0.0899546825729765
1717406 1717406 525982 525982 78289 8 0.625
1750620 1750620 536253 536253 78289 4 0.656703184093677 
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)
);