consensus_index

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

24 rows where inventory_id = 153162

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
423059 423059 153162 153162 53075 6 0.233586486922364
423060 423060 153162 153162 123838 4 0.125502507663533
423061 423061 153162 153162 136294 2 0.116793243461182
423062 423062 153162 153162 142095 1 0.0333694981317663
423063 423063 153162 153162 173408 2 0.0301558857916471
423064 423064 153162 153162 186248 2 0.031496795471266
423065 423065 153162 153162 192012 2 0.067430610551843
423066 423066 153162 153162 195204 2 0.0426468626719215
423067 423067 153162 153162 195364 1 0.015572432461491
423068 423068 153162 153162 195512 2 0.0168576526379608
423069 423069 153162 153162 197730 1 0.0333694981317663
423070 423070 153162 153162 197731 1 0.0179681913017203
423071 423071 153162 153162 201913 1 0.0166847490658832
423072 423072 153162 153162 204661 2 0.0187018864523472
423073 423073 153162 153162 206648 1 0.0137403815836685
423074 423074 153162 153162 215298 1 0.0111231660439221
423075 423075 153162 153162 226433 2 0.0189463659327441
423076 423076 153162 153162 228419 1 0.0212351351747604
423077 423077 153162 153162 249567 1 0.0116793243461182
423078 423078 153162 153162 250668 1 0.0129770270512425
423079 423079 153162 153162 255480 1 0.0259540541024849
423080 423080 153162 153162 315679 1 0.0291983108652955
423081 423081 153162 153162 315681 1 0.0259540541024849
423082 423082 153162 153162 315682 1 0.0233586486922364 
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)
);