consensus_index

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

30 rows where inchi_id = 83821

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
4514 4514 1368 1368 83821 6 0.384615384615385
19004 19004 5583 5583 83821 6 0.384615384615385
116808 116808 40743 40743 83821 6 0.384615384615385
153684 153684 55239 55239 83821 9 0.388888888888889
204848 204848 72593 72593 83821 6 0.384615384615385
216816 216816 75257 75257 83821 6 0.292682926829268
257166 257166 87076 87076 83821 1 0.259842519685039
426896 426896 153956 153956 83821 6 0.323529411764706
437677 437677 156900 156900 83821 1 0.171428571428571
501164 501164 199349 199349 83821 2 0.630993034743972
514688 514688 206472 206472 83821 6 0.384615384615385
514691 514691 206473 206473 83821 3 0.375
534411 534411 212083 212083 83821 6 0.292682926829268
579268 579268 226837 226837 83821 1 0.259842519685039
666877 666877 238800 238800 83821 6 0.384615384615385
733590 733590 258707 258707 83821 6 0.384615384615385
896854 896854 315092 315092 83821 1 0.0809903519707037
1171905 1171905 393560 393560 83821 6 0.384615384615385
1171908 1171908 393561 393561 83821 6 0.384615384615385
1171911 1171911 393562 393562 83821 6 0.384615384615385
1427425 1427425 445195 445195 83821 6 0.384615384615385
1427428 1427428 445196 445196 83821 6 0.384615384615385
1427431 1427431 445197 445197 83821 6 0.384615384615385
1427434 1427434 445198 445198 83821 6 0.384615384615385
1585318 1585318 478669 478669 83821 6 0.384615384615385
1585321 1585321 478670 478670 83821 6 0.384615384615385
1585324 1585324 478671 478671 83821 6 0.384615384615385
1606558 1606558 485373 485373 83821 6 0.384615384615385
1612356 1612356 486755 486755 83821 6 0.384615384615385
1717814 1717814 526100 526100 83821 3 0.375 
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)
);