consensus_index

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

26 rows where inchi_id = 101681

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
19095 19095 5609 5609 101681 2 0.384615384615385
116806 116806 40742 40742 101681 2 0.384615384615385
160274 160274 57629 57629 101681 2 0.384615384615385
217025 217025 75323 75323 101681 2 0.342857142857143
427041 427041 154001 154001 101681 2 0.342857142857143
497712 497712 190835 190835 101681 2 0.254237288135593
514739 514739 206486 206486 101681 2 0.342857142857143
514743 514743 206487 206487 101681 2 0.384615384615385
514746 514746 206488 206488 101681 2 0.384615384615385
534263 534263 212009 212009 101681 3 0.388888888888889
666907 666907 238813 238813 101681 3 0.385964912280702
733725 733725 258750 258750 101681 2 0.384615384615385
853597 853597 295322 295322 101681 1 0.375
853600 853600 295323 295323 101681 1 0.375
853603 853603 295324 295324 101681 1 0.375
853606 853606 295325 295325 101681 2 0.384615384615385
957042 957042 344091 344091 101681 1 0.375
1172310 1172310 393664 393664 101681 2 0.384615384615385
1172313 1172313 393665 393665 101681 2 0.384615384615385
1427810 1427810 445293 445293 101681 2 0.384615384615385
1427813 1427813 445294 445294 101681 2 0.384615384615385
1585602 1585602 478741 478741 101681 2 0.384615384615385
1585605 1585605 478742 478742 101681 2 0.384615384615385
1606620 1606620 485393 485393 101681 2 0.384615384615385
1612505 1612505 486808 486808 101681 2 0.384615384615385
1717884 1717884 526122 526122 101681 2 0.342857142857143 
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)
);