consensus_index

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

27 rows where inchi_id = 123807

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
12724 12724 3917 3917 123807 6 0.392676243814934
25981 25981 7605 7605 123807 6 0.392676243814934
120050 120050 41793 41793 123807 6 0.392676243814934
131883 131883 46833 46833 123807 9 0.357627736912005
227635 227635 78281 78281 123807 6 0.365992794326891
373284 373284 127234 127234 123807 2 0.230411890464873
434238 434238 156030 156030 123807 6 0.365992794326891
490097 490097 183857 183857 123807 2 0.230411890464873
502350 502350 200653 200653 123807 3 0.378550132106064
581383 581383 227430 227430 123807 6 0.365992794326891
682586 682586 243797 243797 123807 9 0.357627736912005
763578 763578 267722 267722 123807 4 0.409090909090909
763582 763582 267723 267723 123807 6 0.392676243814934
936966 936966 334607 334607 123807 3 0.406779661016949
1028623 1028623 365317 365317 123807 6 0.392676243814934
1028627 1028627 365318 365318 123807 6 0.392676243814934
1028631 1028631 365319 365319 123807 6 0.392676243814934
1246941 1246941 411499 411499 123807 6 0.392676243814934
1246945 1246945 411500 411500 123807 6 0.392676243814934
1246949 1246949 411501 411501 123807 6 0.392676243814934
1476003 1476003 456981 456981 123807 6 0.392676243814934
1476007 1476007 456982 456982 123807 6 0.392676243814934
1476011 1476011 456983 456983 123807 6 0.392676243814934
1594294 1594294 481214 481214 123807 6 0.392676243814934
1620575 1620575 489371 489371 123807 6 0.392676243814934
1689373 1689373 514114 514114 123807 3 0.22732799496878
1722802 1722802 527616 527616 123807 6 0.4125 
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)
);