home / zeropm-v0-0-4

consensus_index

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

34 rows where inchi_id = 63028

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
15731 15731 4782 4782 63028 1 0.114503816793893
16269 16269 4861 4861 63028 7 0.350912054646185
122783 122783 42684 42684 63028 1 0.113924050632911
122787 122787 42685 42685 63028 7 0.350912054646185
132273 132273 46978 46978 63028 1 0.317073170731707
164282 164282 58864 58864 63028 9 0.227454749383553
184925 184925 65997 65997 63028 1 0.113207547169811
211097 211097 74008 74008 63028 2 0.0845723654048254
212333 212333 74193 74193 63028 11 0.267886312491778
295134 295134 99913 99913 63028 1 0.3125
423234 423234 153177 153177 63028 2 0.0845723654048254
505647 505647 202243 202243 63028 1 0.3125
541638 541638 214444 214444 63028 1 0.304347826086957
546368 546368 216123 216123 63028 5 0.328170523653831
551543 551543 217933 217933 63028 6 0.0943715479950435
715038 715038 253068 253068 63028 2 0.0843185175750276
720922 720922 254849 254849 63028 13 0.282336313172616
720966 720966 254864 254864 63028 1 0.0440351091953358
826860 826860 286999 286999 63028 11 0.267886312491778
826867 826867 287000 287000 63028 5 0.328170523653831
826873 826873 287001 287001 63028 5 0.328170523653831
897639 897639 315468 315468 63028 1 0.3
956186 956186 343479 343479 63028 1 0.113207547169811
956222 956222 343505 343505 63028 5 0.328170523653831
962914 962914 346704 346704 63028 1 0.3
1090061 1090061 380840 380840 63028 7 0.350912054646185
1318871 1318871 429395 429395 63028 7 0.350912054646185
1521031 1521031 468658 468658 63028 7 0.350912054646185
1602766 1602766 484178 484178 63028 7 0.350912054646185
1608958 1608958 485884 485884 63028 1 0.114503816793893
1609604 1609604 485985 485985 63028 7 0.350912054646185
1651523 1651523 500217 500217 63028 1 0.3125
1715508 1715508 525511 525511 63028 1 0.113207547169811
1715982 1715982 525599 525599 63028 7 0.3363465648619
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 1306.044ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website