consensus_index

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

26 rows where inchi_id = 24685

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
19530 19530 5747 5747 24685 1 0.00340350069919872
55894 55894 17525 17525 24685 8 0.625
101275 101275 35760 35760 24685 1 0.00340350069919872
129940 129940 46301 46301 24685 1 0.00294809450496318
169423 169423 60414 60414 24685 8 0.625
332211 332211 111971 111971 24685 7 0.620689655172414
474844 474844 172719 172719 24685 7 0.620689655172414
735135 735135 259323 259323 24685 1 0.00294788119675928
856753 856753 296368 296368 24685 1 0.00340350069919872
1173852 1173852 394085 394085 24685 1 0.00340350069919872
1173915 1173915 394086 394086 24685 1 0.00340350069919872
1173978 1173978 394087 394087 24685 1 0.00340350069919872
1174041 1174041 394088 394088 24685 1 0.00340350069919872
1174104 1174104 394089 394089 24685 1 0.00340350069919872
1174167 1174167 394090 394090 24685 1 0.00340350069919872
1429374 1429374 445716 445716 24685 1 0.00340350069919872
1429437 1429437 445717 445717 24685 1 0.00340350069919872
1429500 1429500 445718 445718 24685 1 0.00340350069919872
1429563 1429563 445719 445719 24685 1 0.00340350069919872
1586619 1586619 479015 479015 24685 1 0.00340350069919872
1586682 1586682 479016 479016 24685 1 0.00340350069919872
1586745 1586745 479017 479017 24685 1 0.00340350069919872
1586808 1586808 479018 479018 24685 1 0.00340350069919872
1606975 1606975 485501 485501 24685 1 0.00340350069919872
1613197 1613197 487045 487045 24685 1 0.00340350069919872
1670237 1670237 506689 506689 24685 8 0.625 
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)
);