consensus_index

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

20 rows where inchi_id = 101991

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
190 190 39 39 101991 1 0.0839940524301563
198 198 40 40 101991 10 0.317742194380737
34552 34552 10220 10220 101991 4 0.361703814133334
140774 140774 50162 50162 101991 1 0.170212765957447
144207 144207 51414 51414 101991 10 0.317742194380737
193718 193718 68843 68843 101991 1 0.094803912441973
521501 521501 208113 208113 101991 1 0.0952007797617901
521507 521507 208114 208114 101991 1 0.0952007797617901
550033 550033 217468 217468 101991 1 0.170212765957447
552742 552742 218248 218248 101991 5 0.377591646310126
555163 555163 218859 218859 101991 1 0.0952007797617901
668217 668217 239449 239449 101991 7 0.323581170816614
710358 710358 252017 252017 101991 1 0.094803912441973
809650 809650 281872 281872 101991 1 0.0952007797617901
814191 814191 282999 282999 101991 2 0.402755746211571
814195 814195 283000 283000 101991 4 0.361703814133334
814200 814200 283001 283001 101991 5 0.433311349028085
814204 814204 283002 283002 101991 2 0.402755746211571
873443 873443 301671 301671 101991 1 0.168674698795181
1736908 1736908 532087 532087 101991 4 0.361703814133334 
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)
);