consensus_index

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

23 rows where inchi_id = 58101

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
30861 30861 9026 9026 58101 8 0.375903614457831
31534 31534 9257 9257 58101 1 0.137931034482759
150308 150308 53885 53885 58101 1 0.137931034482759
187758 187758 66838 66838 58101 12 0.364638485732806
243998 243998 83025 83025 58101 8 0.441733223181853
247046 247046 84066 84066 58101 2 0.0887830920565439
539609 539609 213876 213876 58101 2 0.0892948339590312
718005 718005 253932 253932 58101 12 0.364638485732806
727684 727684 256914 256914 58101 2 0.0892948339590312
841440 841440 291722 291722 58101 1 0.137931034482759
841445 841445 291723 291723 58101 2 0.0887830920565439
899686 899686 316387 316387 58101 4 0.452830188679245
959115 959115 345080 345080 58101 1 0.168674698795181
1075356 1075356 377488 377488 58101 8 0.375903614457831
1075361 1075361 377489 377489 58101 8 0.375903614457831
1301870 1301870 425505 425505 58101 8 0.375903614457831
1301875 1301875 425506 425506 58101 8 0.375903614457831
1510287 1510287 466009 466009 58101 8 0.375903614457831
1510292 1510292 466010 466010 58101 8 0.375903614457831
1602086 1602086 483941 483941 58101 8 0.375903614457831
1628185 1628185 491868 491868 58101 8 0.375903614457831
1630255 1630255 492641 492641 58101 1 0.137931034482759
1727171 1727171 528905 528905 58101 8 0.375903614457831 
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)
);