home / zeropm-v0-0-4

consensus_index

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

37 rows where inchi_id = 45197

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
28248 28248 8182 8182 45197 7 0.620689655172414
55502 55502 17385 17385 45197 1 0.3125
63808 63808 20665 20665 45197 3 0.494374522547733
106746 106746 37595 37595 45197 7 0.620689655172414
106829 106829 37624 37624 45197 1 0.3125
143389 143389 51117 51117 45197 3 0.494374522547733
155203 155203 55828 55828 45197 1 0.318181818181818
173682 173682 62045 62045 45197 4 0.6
328963 328963 110885 110885 45197 1 0.310344827586207
367860 367860 125096 125096 45197 3 0.494374522547733
437054 437054 156724 156724 45197 4 0.6
454801 454801 163391 163391 45197 4 0.466666666666667
459380 459380 165145 165145 45197 4 0.382978723404255
473751 473751 172112 172112 45197 1 0.307692307692308
479143 479143 175104 175104 45197 4 0.424889447588833
558628 558628 219862 219862 45197 6 0.615384615384615
571764 571764 224107 224107 45197 1 0.3125
662750 662750 237635 237635 45197 4 0.6
706349 706349 251062 251062 45197 7 0.620689655172414
714546 714546 252922 252922 45197 3 0.494374522547733
778194 778194 272142 272142 45197 1 0.3125
778196 778196 272143 272143 45197 1 0.3
803348 803348 280118 280118 45197 4 0.6
803350 803350 280119 280119 45197 7 0.620689655172414
803352 803352 280120 280120 45197 6 0.615384615384615
879936 879936 305551 305551 45197 1 0.3
881748 881748 306422 306422 45197 4 0.6
930093 930093 331106 331106 45197 1 0.467520617081764
1057823 1057823 373953 373953 45197 7 0.620689655172414
1281460 1281460 421561 421561 45197 7 0.620689655172414
1497670 1497670 463474 463474 45197 7 0.620689655172414
1599940 1599940 483324 483324 45197 7 0.620689655172414
1624065 1624065 490410 490410 45197 7 0.620689655172414
1669184 1669184 506292 506292 45197 1 0.3125
1724994 1724994 528201 528201 45197 7 0.620689655172414
1749465 1749465 535877 535877 45197 1 0.3125
1757014 1757014 538614 538614 45197 3 0.494374522547733
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 1593.84ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website