home / zeropm-v0-0-4

consensus_index

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

31 rows where inventory_id = 218161

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
552423 552423 218161 218161 17533 2 0.0175340226067948
552424 552424 218161 218161 53046 11 0.20746535332094
552425 552425 218161 218161 53049 1 0.00797943666619001
552426 552426 218161 218161 137220 2 0.10373267666047
552427 552427 218161 218161 138475 1 0.0230517059245489
552428 552428 218161 218161 177268 1 0.0296379076172772
552429 552429 218161 218161 177269 1 0.0259331691651175
552430 552430 218161 218161 177270 1 0.0230517059245489
552431 552431 218161 218161 177271 1 0.020746535332094
552432 552432 218161 218161 179838 2 0.051866338330235
552433 552433 218161 218161 192261 1 0.0172887794434117
552434 552434 218161 218161 195685 1 0.00987930253909239
552435 552435 218161 218161 197725 1 0.01886048666554
552436 552436 218161 218161 197937 1 0.01595887333238
552437 552437 218161 218161 197938 1 0.0148189538086386
552438 552438 218161 218161 197939 1 0.0138310235547293
552439 552439 218161 218161 197940 1 0.0129665845825588
552440 552440 218161 218161 197945 1 0.0122038443129965
552441 552441 218161 218161 197946 2 0.0172887794434117
552442 552442 218161 218161 206835 1 0.0109192291221547
552443 552443 218161 218161 206836 1 0.010373267666047
552444 552444 218161 218161 206995 1 0.00943024333277001
552445 552445 218161 218161 206996 1 0.00902023275308435
552446 552446 218161 218161 206997 1 0.00864438972170584
552447 552447 218161 218161 206998 1 0.00829861413283761
552448 552448 218161 218161 214857 1 0.041493070664188
552449 552449 218161 218161 220985 2 0.0163000175771666
552450 552450 218161 218161 239118 2 0.0691551177736467
552451 552451 218161 218161 242815 1 0.10373267666047
552452 552452 218161 218161 284027 1 0.0345775588868234
552453 552453 218161 218161 291046 1 0.0296379076172772
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 1061.107ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website