consensus_index

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

15 rows where inchi_id = 307898

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
27431 27431 7956 7956 307898 1 0.192307692307692
168288 168288 60041 60041 307898 2 0.159126365054602
231532 231532 79219 79219 307898 1 0.192307692307692
435977 435977 156442 156442 307898 1 0.1875
563978 563978 221584 221584 307898 1 0.192307692307692
793778 793778 277044 277044 307898 1 0.189189189189189
793781 793781 277045 277045 307898 1 0.192307692307692
793784 793784 277046 277046 307898 1 0.1875
939662 939662 335891 335891 307898 1 0.1875
1052343 1052343 372112 372112 307898 1 0.192307692307692
1274657 1274657 419328 419328 307898 1 0.192307692307692
1493473 1493473 462058 462058 307898 1 0.192307692307692
1598698 1598698 482874 482874 307898 1 0.192307692307692
1622522 1622522 489900 489900 307898 1 0.192307692307692
1724129 1724129 527968 527968 307898 1 0.192307692307692 
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)
);