consensus_index

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

20 rows where inchi_id = 31147

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
11299 11299 3443 3443 31147 3 0.253104790044596
58347 58347 18406 18406 31147 3 0.299063076399583
81838 81838 29466 29466 31147 3 0.299063076399583
158778 158778 57175 57175 31147 3 0.299063076399583
341780 341780 115344 115344 31147 2 0.274735440206031
478857 478857 174935 174935 31147 3 0.252324627026175
566040 566040 222262 222262 31147 2 0.272967816249867
697161 697161 248547 248547 31147 3 0.299063076399583
789395 789395 275693 275693 31147 2 0.272967816249867
789400 789400 275694 275694 31147 3 0.299063076399583
789405 789405 275695 275695 31147 2 0.272967816249867
1049159 1049159 371227 371227 31147 3 0.299063076399583
1049164 1049164 371228 371228 31147 3 0.299063076399583
1270815 1270815 418219 418219 31147 3 0.299063076399583
1270820 1270820 418220 418220 31147 3 0.299063076399583
1491116 1491116 461397 461397 31147 3 0.299063076399583
1491121 1491121 461398 461398 31147 3 0.299063076399583
1598086 1598086 482668 482668 31147 3 0.299063076399583
1675016 1675016 508431 508431 31147 3 0.299063076399583
1752578 1752578 536914 536914 31147 3 0.299063076399583 
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)
);