home / zeropm-v0-0-4

consensus_index

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

31 rows where inchi_id = 42310

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
17780 17780 5209 5209 42310 1 0.310344827586207
61240 61240 19599 19599 42310 5 0.466666666666667
106737 106737 37592 37592 42310 1 0.310344827586207
170092 170092 60668 60668 42310 3 0.454545454545455
215169 215169 74759 74759 42310 2 0.3125
355805 355805 120556 120556 42310 2 0.126968338291271
421035 421035 152371 152371 42310 3 0.454545454545455
425821 425821 153646 153646 42310 2 0.3125
505052 505052 202024 202024 42310 3 0.196078431372549
505059 505059 202025 202025 42310 4 0.173460277929347
506414 506414 202529 202529 42310 3 0.375
507218 507218 202863 202863 42310 5 0.382978723404255
509435 509435 203960 203960 42310 3 0.375
510285 510285 204566 204566 42310 3 0.375
510300 510300 204574 204574 42310 3 0.375
510621 510621 205023 205023 42310 3 0.375
510624 510624 205024 205024 42310 3 0.375
703528 703528 250528 250528 42310 8 0.387096774193548
730671 730671 257757 257757 42310 1 0.310344827586207
781664 781664 273309 273309 42310 1 0.113989637305699
800288 800288 279188 279188 42310 5 0.466666666666667
800290 800290 279189 279189 42310 3 0.461538461538462
800292 800292 279190 279190 42310 3 0.454545454545455
800294 800294 279191 279191 42310 5 0.470588235294118
848667 848667 293585 293585 42310 1 0.3
848669 848669 293586 293586 42310 1 0.310344827586207
894390 894390 313922 313922 42310 3 0.454545454545455
936035 936035 334189 334189 42310 1 0.103896103896104
1611331 1611331 486398 486398 42310 1 0.310344827586207
1717262 1717262 525941 525941 42310 1 0.310344827586207
1755110 1755110 537870 537870 42310 5 0.466666666666667
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 805.425ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website