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 = 87490

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
19628 19628 5756 5756 87490 1 0.0349817799931512
101009 101009 35698 35698 87490 8 0.461538461538462
101173 101173 35749 35749 87490 2 0.25
101232 101232 35757 35757 87490 1 0.0349817799931512
130074 130074 46319 46319 87490 1 0.0294172219118617
135005 135005 47852 47852 87490 2 0.0419653813808296
135020 135020 47854 47854 87490 8 0.461538461538462
218156 218156 75647 75647 87490 8 0.341394025604552
229465 229465 78690 78690 87490 1 0.0596334560128533
427755 427755 154209 154209 87490 8 0.341394025604552
435354 435354 156285 156285 87490 1 0.0596334560128533
515139 515139 206563 206563 87490 8 0.461538461538462
515143 515143 206564 206564 87490 8 0.461538461538462
532752 532752 211314 211314 87490 8 0.461538461538462
577777 577777 226358 226358 87490 1 0.0596334560128533
685882 685882 244606 244606 87490 1 0.0597966542348226
735313 735313 259368 259368 87490 1 0.0294172219118617
735511 735511 259431 259431 87490 12 0.342857142857143
857070 857070 296438 296438 87490 1 0.0349817799931512
857343 857343 296532 296532 87490 5 0.455696202531646
857347 857347 296533 296533 87490 8 0.461538461538462
905051 905051 319266 319266 87490 4 0.452830188679245
954828 954828 342817 342817 87490 2 0.630993034743972
1174316 1174316 394119 394119 87490 1 0.0349817799931512
1174434 1174434 394151 394151 87490 8 0.461538461538462
1174438 1174438 394152 394152 87490 8 0.461538461538462
1429700 1429700 445744 445744 87490 1 0.0349817799931512
1429791 1429791 445767 445767 87490 8 0.461538461538462
1429795 1429795 445768 445768 87490 8 0.461538461538462
1586941 1586941 479041 479041 87490 1 0.0349817799931512
1587011 1587011 479057 479057 87490 8 0.461538461538462
1587015 1587015 479058 479058 87490 8 0.461538461538462
1607068 1607068 485510 485510 87490 1 0.0349817799931512
1607105 1607105 485515 485515 87490 8 0.461538461538462
1613320 1613320 487061 487061 87490 1 0.0349817799931512
1613381 1613381 487073 487073 87490 8 0.461538461538462
1718246 1718246 526233 526233 87490 4 0.452830188679245
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 767.032ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website