consensus_index

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

21 rows where inchi_id = 54381

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
61680 61680 19817 19817 54381 3 0.34286741723596
147565 147565 53113 53113 54381 5 0.166672172801207
147614 147614 53137 53137 54381 9 0.909090909090909
241332 241332 82027 82027 54381 8 0.461538461538462
358125 358125 121556 121556 54381 3 0.34286741723596
485036 485036 179338 179338 54381 3 0.34286741723596
510828 510828 205622 205622 54381 8 0.461538461538462
521802 521802 208209 208209 54381 8 0.461538461538462
551143 551143 217808 217808 54381 8 0.461538461538462
557508 557508 219542 219542 54381 3 0.34286741723596
685691 685691 244556 244556 54381 2 0.0433555436197779
714989 714989 253052 253052 54381 12 0.466019417475728
805290 805290 280596 280596 54381 3 0.34286741723596
817201 817201 283766 283766 54381 8 0.9
817202 817202 283767 283767 54381 8 0.42368278109723
1059318 1059318 374265 374265 54381 3 0.34286741723596
1283264 1283264 421962 421962 54381 3 0.34286741723596
1498892 1498892 463724 463724 54381 3 0.34286741723596
1600138 1600138 483383 483383 54381 3 0.34286741723596
1626640 1626640 491241 491241 54381 8 0.9
1681578 1681578 511072 511072 54381 3 0.34286741723596 
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)
);