consensus_index

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

27 rows where inchi_id = 97062

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
189 189 39 39 97062 18 0.335976209720625
197 197 40 40 97062 4 0.129717707664173
29149 29149 8447 8447 97062 6 0.406590720390587
34551 34551 10220 10220 97062 2 0.147664963774193
94747 94747 33630 33630 97062 6 0.406590720390587
144206 144206 51414 51414 97062 4 0.129717707664173
193717 193717 68843 68843 97062 9 0.379215649767892
238709 238709 81229 81229 97062 6 0.404902212878566
438060 438060 157031 157031 97062 6 0.404902212878566
521495 521495 208112 208112 97062 6 0.404902212878566
521500 521500 208113 208113 97062 6 0.380803119047161
521506 521506 208114 208114 97062 6 0.380803119047161
552741 552741 218248 218248 97062 2 0.125863882103375
555162 555162 218859 218859 97062 6 0.380803119047161
668216 668216 239449 239449 97062 3 0.123469324951953
710357 710357 252017 252017 97062 9 0.379215649767892
809639 809639 281870 281870 97062 4 0.40262217637273
809644 809644 281871 281871 97062 6 0.406590720390587
809649 809649 281872 281872 97062 6 0.380803119047161
814190 814190 282999 282999 97062 1 0.134251915403857
814194 814194 283000 283000 97062 2 0.147664963774193
814199 814199 283001 283001 97062 2 0.176898617479306
814203 814203 283002 283002 97062 1 0.134251915403857
928070 928070 330117 330117 97062 3 0.401153872326036
1625462 1625462 490861 490861 97062 6 0.392029052386769
1725834 1725834 528439 528439 97062 6 0.406590720390587
1736907 1736907 532087 532087 97062 2 0.147664963774193 
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)
);