home / zeropm-v0-0-4

consensus_index

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

84 rows where inventory_id = 47269

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
133080 133080 47269 47269 8601 1 0.017430238276486
133081 133081 47269 47269 11493 1 0.00304337493716422
133082 133082 47269 47269 17861 1 0.0024581105261711
133083 133083 47269 47269 37046 1 0.00445889816375224
133084 133084 47269 47269 52225 11 0.191732621041346
133085 133085 47269 47269 77186 1 0.00407941746896481
133086 133086 47269 47269 136305 2 0.0958663105206731
133087 133087 47269 47269 149690 1 0.002490034039498
133088 133088 47269 47269 151896 1 0.00618492325939826
133089 133089 47269 47269 154241 2 0.0175027135923225
133090 133090 47269 47269 168153 2 0.0204387660773769
133091 133091 47269 47269 168166 1 0.0159777184201122
133092 133092 47269 47269 173404 1 0.00563919473651018
133093 133093 47269 47269 176864 1 0.0106518122800748
133094 133094 47269 47269 177033 1 0.0066114696910809
133095 133095 47269 47269 177065 1 0.00639108736804487
133096 133096 47269 47269 185868 1 0.00766930484165384
133097 133097 47269 47269 185968 1 0.00737433157851331
133098 133098 47269 47269 186229 1 0.0239665776301683
133099 133099 47269 47269 186267 2 0.0217094443501465
133100 133100 47269 47269 191984 1 0.00581007942549534
133101 133101 47269 47269 192447 2 0.035005427184645
133102 133102 47269 47269 194419 1 0.00314315772198928
133103 133103 47269 47269 195649 2 0.0428727174152656
133104 133104 47269 47269 197781 1 0.0026629530700187
133105 133105 47269 47269 197911 1 0.027390374434478
133106 133106 47269 47269 198074 1 0.0112783894730204
133107 133107 47269 47269 198162 1 0.00416810045742057
133108 133108 47269 47269 200206 1 0.00518196273084719
133109 133109 47269 47269 200769 1 0.00491622105234221
133110 133110 47269 47269 200770 1 0.00479331552603365
133111 133111 47269 47269 200833 1 0.0119832888150841
133112 133112 47269 47269 201046 1 0.00532590614003739
133113 133113 47269 47269 201498 1 0.00710120818671652
133114 133114 47269 47269 201749 1 0.013695187217239
133115 133115 47269 47269 202932 1 0.0127821747360897
133116 133116 47269 47269 203714 1 0.00599164440754207
133117 133117 47269 47269 203838 1 0.00299582220377103
133118 133118 47269 47269 203846 2 0.0639108736804487
133119 133119 47269 47269 204026 1 0.0147486631570266
133120 133120 47269 47269 204543 2 0.0121750336111652
133121 133121 47269 47269 205604 1 0.00504559529056174
133122 133122 47269 47269 206495 1 0.0054780748868956
133123 133123 47269 47269 206643 1 0.0068475936086195
133124 133124 47269 47269 206776 1 0.0100911905811235
133125 133125 47269 47269 206777 1 0.00958663105206731
133126 133126 47269 47269 206800 1 0.00913012481149267
133127 133127 47269 47269 206801 1 0.008715119138243
133128 133128 47269 47269 206802 1 0.00833620091484114
133129 133129 47269 47269 206803 1 0.00798885921005609
133130 133130 47269 47269 206988 1 0.00467640539125234
133131 133131 47269 47269 206989 1 0.00456506240574634
133132 133132 47269 47269 212362 1 0.00233820269562617
133133 133133 47269 47269 215432 1 0.0213036245601496
133134 133134 47269 47269 223278 1 0.00252279764528087
133135 133135 47269 47269 237557 1 0.0043575595691215
133136 133136 47269 47269 240853 1 0.00426072491202991
133137 133137 47269 47269 241035 1 0.0213036245601496
133138 133138 47269 47269 247035 1 0.00383465242082692
133139 133139 47269 47269 254569 1 0.00355060409335826
133140 133140 47269 47269 258213 1 0.00281959736825509
133141 133141 47269 47269 258668 1 0.00399442960502804
133142 133142 47269 47269 258672 2 0.00977159918206966
133143 133143 47269 47269 261413 1 0.00391291063349686
133144 133144 47269 47269 263195 1 0.00375946315767345
133145 133145 47269 47269 263196 1 0.00368716578925666
133146 133146 47269 47269 263245 1 0.00361759662342162
133147 133147 47269 47269 274286 2 0.00782745147662852
133148 133148 47269 47269 283515 1 0.00342379680430975
133149 133149 47269 47269 283516 1 0.00336373019370783
133150 133150 47269 47269 287410 1 0.00330573484554045
133151 133151 47269 47269 287411 1 0.00324970544137875
133152 133152 47269 47269 324613 1 0.00294973263140532
133153 133153 47269 47269 324614 1 0.00290503971274767
133154 133154 47269 47269 324615 1 0.00286168091106487
133155 133155 47269 47269 326787 1 0.00277873363828038
133156 133156 47269 47269 326788 1 0.0027390374434478
133157 133157 47269 47269 330443 1 0.00270045945128657
133158 133158 47269 47269 331056 1 0.00262647426084036
133159 133159 47269 47269 333567 1 0.0025909813654236
133160 133160 47269 47269 333619 1 0.00255643494721795
133161 133161 47269 47269 340351 1 0.00242699520305501
133162 133162 47269 47269 340512 1 0.00239665776301683
133163 133163 47269 47269 340513 1 0.00236706939557217
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)
);
Powered by Datasette · Queries took 867.355ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website