consensus_index

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

24 rows where inventory_id = 71005

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
199595 199595 71005 71005 365 2 0.0898031068248107
199596 199596 71005 71005 422 10 0.270817039166926
199597 199597 71005 71005 124382 2 0.0635003858074436
199598 199598 71005 71005 179620 1 0.062217417479243
199599 199599 71005 71005 223504 2 0.0803223405803808
199600 199600 71005 71005 232060 1 0.0444410124851736
199601 199601 71005 71005 232061 1 0.0388858859245269
199602 199602 71005 71005 232062 1 0.0345652319329128
199603 199603 71005 71005 232063 1 0.0311087087396215
199604 199604 71005 71005 232064 1 0.0282806443087468
199605 199605 71005 71005 232065 1 0.0259239239496846
199606 199606 71005 71005 232066 1 0.023929775953555
199607 199607 71005 71005 232067 1 0.0222205062425868
199608 199608 71005 71005 232068 1 0.0207391391597477
199609 199609 71005 71005 232069 1 0.0194429429622634
199610 199610 71005 71005 232070 1 0.0182992404350715
199611 199611 71005 71005 232071 1 0.0172826159664564
199612 199612 71005 71005 232072 1 0.0163730045998008
199613 199613 71005 71005 232073 1 0.0155543543698107
199614 199614 71005 71005 232074 1 0.0148136708283912
199615 199615 71005 71005 232075 1 0.0141403221543734
199616 199616 71005 71005 232076 1 0.0135255255389659
199617 199617 71005 71005 232077 1 0.0129619619748423
199618 199618 71005 71005 232078 1 0.0124434834958486 
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)
);