home / zeropm-v0-0-4

consensus_index

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

29 rows where inventory_id = 356167

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
993329 993329 356167 356167 3515 8 0.250709456076058
993330 993330 356167 356167 17497 1 0.125354728038029
993331 993331 356167 356167 33583 1 0.0313386820095073
993332 993332 356167 356167 35243 1 0.035815636582294
993333 993333 356167 356167 51185 1 0.0167139637384039
993334 993334 356167 356167 55862 1 0.0835698186920194
993335 993335 356167 356167 63839 1 0.0125354728038029
993336 993336 356167 356167 68015 1 0.0119385455274313
993337 993337 356167 356167 81686 1 0.0104462273365024
993338 993338 356167 356167 89238 1 0.00928553541022437
993339 993339 356167 356167 123672 1 0.0626773640190145
993340 993340 356167 356167 138713 1 0.0278566062306731
993341 993341 356167 356167 139788 1 0.0227917687341871
993342 993342 356167 356167 139807 1 0.017907818291147
993343 993343 356167 356167 149107 1 0.0250709456076058
993344 993344 356167 356167 167393 1 0.0192853427750814
993345 993345 356167 356167 167437 1 0.0208924546730048
993346 993346 356167 356167 167549 1 0.0113958843670936
993347 993347 356167 356167 171165 1 0.0131952345303188
993348 993348 356167 356167 171594 1 0.0109004111337417
993349 993349 356167 356167 171796 1 0.0147476150632975
993350 993350 356167 356167 171797 1 0.0156693410047536
993351 993351 356167 356167 171936 1 0.0139283031153366
993352 993352 356167 356167 172056 1 0.0501418912152116
993353 993353 356167 356167 178265 1 0.0417849093460097
993354 993354 356167 356167 191532 1 0.0096426713875407
993355 993355 356167 356167 231459 1 0.0100283782430423
993356 993356 356167 356167 340654 1 0.0089539091455735
993357 993357 356167 356167 340655 1 0.00864515365779511
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 1898.391ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website