consensus_index

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

24 rows where inventory_id = 73987

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
210840 210840 73987 73987 53075 6 0.233586486922364
210841 210841 73987 73987 123838 4 0.125502507663533
210842 210842 73987 73987 136294 2 0.116793243461182
210843 210843 73987 73987 142095 1 0.0333694981317663
210844 210844 73987 73987 173408 2 0.0301558857916471
210845 210845 73987 73987 186248 2 0.031496795471266
210846 210846 73987 73987 192012 2 0.067430610551843
210847 210847 73987 73987 195204 2 0.0426468626719215
210848 210848 73987 73987 195364 1 0.015572432461491
210849 210849 73987 73987 195512 2 0.0168576526379608
210850 210850 73987 73987 197730 1 0.0333694981317663
210851 210851 73987 73987 197731 1 0.0179681913017203
210852 210852 73987 73987 201913 1 0.0166847490658832
210853 210853 73987 73987 204661 2 0.0187018864523472
210854 210854 73987 73987 206648 1 0.0137403815836685
210855 210855 73987 73987 215298 1 0.0111231660439221
210856 210856 73987 73987 226433 2 0.0189463659327441
210857 210857 73987 73987 228419 1 0.0212351351747604
210858 210858 73987 73987 249567 1 0.0116793243461182
210859 210859 73987 73987 250668 1 0.0129770270512425
210860 210860 73987 73987 255480 1 0.0259540541024849
210861 210861 73987 73987 315679 1 0.0291983108652955
210862 210862 73987 73987 315681 1 0.0259540541024849
210863 210863 73987 73987 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)
);