consensus_index

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

24 rows where inventory_id = 69501

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
195916 195916 69501 69501 55710 2 0.0206369958113701
195917 195917 69501 69501 62852 19 0.202200438247241
195918 195918 69501 69501 136924 2 0.0312002049853524
195919 195919 69501 69501 137023 3 0.0883191764069542
195920 195920 69501 69501 147900 1 0.0183818580224765
195921 195921 69501 69501 151010 1 0.0337000730412069
195922 195922 69501 69501 167828 3 0.0403328190086253
195923 195923 69501 69501 169359 1 0.0505501095618104
195924 195924 69501 69501 169750 1 0.0404400876494483
195925 195925 69501 69501 169971 1 0.0404400876494483
195926 195926 69501 69501 170576 3 0.0303060923828505
195927 195927 69501 69501 189207 2 0.0825479832454802
195928 195928 69501 69501 195305 1 0.0337000730412069
195929 195929 69501 69501 195533 1 0.0288857768924631
195930 195930 69501 69501 195568 2 0.019827384236148
195931 195931 69501 69501 199778 1 0.0202200438247241
195932 195932 69501 69501 211344 2 0.0238295501739194
195933 195933 69501 69501 234624 1 0.0144428884462315
195934 195934 69501 69501 240731 2 0.045213392500108
195935 195935 69501 69501 264387 2 0.0583702387261526
195936 195936 69501 69501 290480 1 0.0202200438247241
195937 195937 69501 69501 291630 1 0.0168500365206034
195938 195938 69501 69501 308320 1 0.0155538798651724
195939 195939 69501 69501 320841 1 0.0202200438247241 
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)
);