home / zeropm-v0-0-4

consensus_index

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

15 rows where inchi_id = 242185

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
34944 34944 10350 10350 242185 1 0.113989637305699
87244 87244 31235 31235 242185 1 0.113989637305699
169047 169047 60284 60284 242185 1 0.113989637305699
258955 258955 87684 87684 242185 1 0.0970873786407767
575983 575983 225680 225680 242185 1 0.0970873786407767
687448 687448 245156 245156 242185 1 0.113989637305699
771715 771715 270016 270016 242185 1 0.113989637305699
771719 771719 270017 270017 242185 1 0.112
901480 901480 317352 317352 242185 1 0.112
1036675 1036675 367368 367368 242185 1 0.113989637305699
1256086 1256086 413778 413778 242185 1 0.113989637305699
1482006 1482006 458514 458514 242185 1 0.113989637305699
1595477 1595477 481592 481592 242185 1 0.113989637305699
1635767 1635767 494528 494528 242185 1 0.113989637305699
1731363 1731363 530174 530174 242185 1 0.113989637305699
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 863.139ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website