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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
992604 992604 356142 356142 3515 8 0.250709456076058
992605 992605 356142 356142 17497 1 0.125354728038029
992606 992606 356142 356142 33583 1 0.0313386820095073
992607 992607 356142 356142 35243 1 0.035815636582294
992608 992608 356142 356142 51185 1 0.0167139637384039
992609 992609 356142 356142 55862 1 0.0835698186920194
992610 992610 356142 356142 63839 1 0.0125354728038029
992611 992611 356142 356142 68015 1 0.0119385455274313
992612 992612 356142 356142 81686 1 0.0104462273365024
992613 992613 356142 356142 89238 1 0.00928553541022437
992614 992614 356142 356142 123672 1 0.0626773640190145
992615 992615 356142 356142 138713 1 0.0278566062306731
992616 992616 356142 356142 139788 1 0.0227917687341871
992617 992617 356142 356142 139807 1 0.017907818291147
992618 992618 356142 356142 149107 1 0.0250709456076058
992619 992619 356142 356142 167393 1 0.0192853427750814
992620 992620 356142 356142 167437 1 0.0208924546730048
992621 992621 356142 356142 167549 1 0.0113958843670936
992622 992622 356142 356142 171165 1 0.0131952345303188
992623 992623 356142 356142 171594 1 0.0109004111337417
992624 992624 356142 356142 171796 1 0.0147476150632975
992625 992625 356142 356142 171797 1 0.0156693410047536
992626 992626 356142 356142 171936 1 0.0139283031153366
992627 992627 356142 356142 172056 1 0.0501418912152116
992628 992628 356142 356142 178265 1 0.0417849093460097
992629 992629 356142 356142 191532 1 0.0096426713875407
992630 992630 356142 356142 231459 1 0.0100283782430423
992631 992631 356142 356142 340654 1 0.0089539091455735
992632 992632 356142 356142 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 1917.358ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website