consensus_index

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

28 rows where inchi_id = 78315

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
5976 5976 1831 1831 78315 11 0.28759043171318
18028 18028 5275 5275 78315 2 0.136465703364522
78413 78413 28348 28348 78315 6 0.421186981493299
81027 81027 29217 29217 78315 2 0.136465703364522
169857 169857 60571 60571 78315 2 0.136465703364522
196968 196968 69936 69936 78315 8 0.287140002346433
207785 207785 73622 73622 78315 4 0.417633410672854
215720 215720 74933 74933 78315 1 0.0835820895522388
215742 215742 74937 74937 78315 7 0.422535211267606
218385 218385 75714 75714 78315 1 0.185636416479747
308380 308380 104201 104201 78315 1 0.00903223093042163
426251 426251 153757 153757 78315 1 0.0835820895522388
427887 427887 154251 154251 78315 1 0.185636416479747
466012 466012 168319 168319 78315 1 0.00903223093042163
514401 514401 206395 206395 78315 8 0.287140002346433
536039 536039 212741 212741 78315 8 0.287140002346433
583959 583959 228206 228206 78315 1 0.3125
666729 666729 238657 238657 78315 5 0.41958041958042
731819 731819 258076 258076 78315 2 0.136465703364522
731842 731842 258086 258086 78315 12 0.287717731507973
748095 748095 263038 263038 78315 1 0.0264178687150378
760047 760047 266784 266784 78315 1 0.00903223093042163
822615 822615 285648 285648 78315 1 0.0182970636094408
850411 850411 294228 294228 78315 8 0.287140002346433
850423 850423 294229 294229 78315 4 0.417633410672854
1611694 1611694 486529 486529 78315 2 0.136465703364522
1717470 1717470 525993 525993 78315 2 0.136465703364522
1717476 1717476 525995 525995 78315 8 0.423405575506409 
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)
);