consensus_index

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

25 rows where inchi_id = 28012

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
16611 16611 4902 4902 28012 10 0.339021229460825
40162 40162 12158 12158 28012 1 0.145788875658103
44081 44081 13450 13450 28012 1 0.0843466179368702
88009 88009 31476 31476 28012 5 0.47846556350313
107557 107557 37821 37821 28012 1 0.177245455523584
191307 191307 68061 68061 28012 1 0.132174992455256
198255 198255 70490 70490 28012 10 0.339021229460825
213035 213035 74278 74278 28012 10 0.168195932156553
281476 281476 95467 95467 28012 1 0.145788875658103
287466 287466 97373 97373 28012 1 0.177686683479794
291029 291029 98571 98571 28012 1 0.0726635831059474
424320 424320 153313 153313 28012 10 0.339021229460825
543142 543142 214867 214867 28012 15 0.150311568638873
547324 547324 216477 216477 28012 1 0.108193138953124
724323 724323 255960 255960 28012 10 0.339021229460825
834921 834921 289679 289679 28012 10 0.168195932156553
834936 834936 289680 289680 28012 9 0.322147189810323
834944 834944 289681 289681 28012 10 0.339021229460825
915295 915295 324248 324248 28012 1 0.177245455523584
917251 917251 325118 325118 28012 5 0.47846556350313
955967 955967 343289 343289 28012 2 0.334273328701672
1609979 1609979 486037 486037 28012 10 0.339021229460825
1646056 1646056 498370 498370 28012 6 0.135749361378221
1650017 1650017 499693 499693 28012 1 0.0822353517346406
1716369 1716369 525643 525643 28012 10 0.339021229460825 
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)
);