consensus_index

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

12 rows where inchi_id = 31829

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
5444 5444 1631 1631 31829 1 0.133971291866029
191560 191560 68109 68109 31829 1 0.0855499177221741
205215 205215 72762 72762 31829 1 0.133971291866029
213651 213651 74357 74357 31829 1 0.133971291866029
270227 270227 91628 91628 31829 6 0.875
270852 270852 91871 91871 31829 1 0.140845070422535
513143 513143 206101 206101 31829 1 0.133971291866029
665181 665181 238290 238290 31829 1 0.0857437320149259
839526 839526 291150 291150 31829 1 0.133971291866029
900903 900903 317052 317052 31829 1 0.139211136890951
961724 961724 346185 346185 31829 4 0.833333333333333
1641381 1641381 496665 496665 31829 1 0.141227593699077 
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)
);