consensus_index

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

20 rows where inventory_id = 313188

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
892700 892700 313188 313188 39386 3 0.117388871006365
892701 892701 313188 313188 113588 2 0.0996855334079592
892702 892702 313188 313188 216909 2 0.122089345793333
892703 892703 313188 313188 239129 2 0.244178691586666
892704 892704 313188 313188 240104 1 0.0203482242988888
892705 892705 313188 313188 243343 1 0.0271309657318518
892706 892706 313188 313188 243544 2 0.0610446728966665
892707 892707 313188 313188 250506 1 0.0488357383173332
892708 892708 313188 313188 259337 1 0.0244178691586666
892709 892709 313188 313188 259399 2 0.0228694298030654
892710 892710 313188 313188 259430 1 0.0348826702266665
892711 892711 313188 313188 264823 1 0.0122089345793333
892712 892712 313188 313188 270667 1 0.0187829762758974
892713 892713 313188 313188 274660 1 0.0162785794391111
892714 892714 313188 313188 275843 1 0.0221980628715151
892715 892715 313188 313188 287437 1 0.0174413351133333
892716 892716 313188 313188 289594 1 0.0152611682241666
892717 892717 313188 313188 309094 1 0.0143634524462745
892718 892718 313188 313188 321382 1 0.0135654828659259
892719 892719 313188 313188 333468 2 0.0386080410746829 
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)
);