RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA966993", tax_clade = "delta/epsilon subdivisions" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 7 ✖

tax_clade 1

  • delta/epsilon subdivisions · 7 ✖

bioproject 1

  • PRJNA966993 · 7 ✖

analysis 1

tax_phylum 0

tax_kingdom 0

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag analysis_used target taxid gene allele pident sumperc_cov alnlen mismatch qcov gapopen qstart qend tstart tend target_title analysis sumalnlen maxbits bits_percmax tax_superkingdom tax_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
7320504 7320504 PRJNA966993_P_NODE_70886_length_269_cov_1.285714_g70434_i0 PRJNA966993 70886 269 1.285714 3.45857066 Deltaproteobacteria bacterium RIFCSPHIGHO2_ 2026735 Bacteria Bacteria 152 2.8199999999999994e-42   NR OGQ26952.1 1797864 g70434 i0 82.8 8.83271375464684 87 15 97 0 262 2 70 156 OGQ26952.1 MAG: adenosylhomocysteinase [Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_50_15] diamond 2376 152 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_50_15
25168340 25168340 PRJNA966993_P_NODE_45780_length_319_cov_1.796748_g45328_i0 PRJNA966993 45780 319 1.796748 5.73162612 Persicimonas sp. 2766932 Bacteria Bacteria 140 3.32e-37   NR MFP4597891.1 2766932 g45328 i0 62.3 0.996865203761755 106 40 99.7 0 2 319 308 413 MFP4597891.1 FAD-dependent oxidoreductase [Persicimonas sp.] diamond 318 140 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria Bradymonadales Bradymonadaceae Persicimonas Persicimonas sp.
29520594 29520594 PRJNA966993_P_NODE_9410_length_683_cov_2.008197_g8993_i0 PRJNA966993 9410 683 2.008197 13.71598551 SAR324 cluster bacterium 2024889 Bacteria Bacteria 162 2.05e-45   NR MEC9361237.1 2024889 g8993 i0 39.7 2.16983894582723 229 102 87 3 682 89 39 262 MEC9361237.1 hypothetical protein [SAR324 cluster bacterium] diamond 1482 162 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       SAR324 cluster bacterium
29551966 29551966 PRJNA966993_P_NODE_35810_length_358_cov_1.407018_g35358_i0 PRJNA966993 35810 358 1.407018 5.03712444 Deltaproteobacteria bacterium CG2_3 2026735 Bacteria Bacteria 51.6 8.31e-5   NR OIP36066.1 1805126 g35358 i0 34.5 6.30167597765363 116 55 95.5 5 3 344 85 181 OIP36066.1 MAG: hypothetical protein AUK47_15720 [Deltaproteobacteria bacterium CG2_30_63_29] diamond 2256 51.6 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium CG2_30_63_29
29583407 29583407 PRJNA966993_P_NODE_12450_length_595_cov_3.277778_g12018_i0 PRJNA966993 12450 595 3.277778 19.5027791 Deltaproteobacteria bacterium IMCC39524 3039107 Bacteria Bacteria 98.2 7.81e-20   NR MDG5469299.1 3039107 g12018 i0 35.5 1.00840336134454 200 116 97.8 4 3 584 427 619 MDG5469299.1 Ig-like domain-containing protein [Deltaproteobacteria bacterium IMCC39524] diamond 600 98.2 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium IMCC39524
31359543 31359543 PRJNA966993_P_NODE_656_length_2076_cov_5.265602_g582_i0 PRJNA966993 656 2076 5.265602 109.31389752 Abditibacteriota 2109258 Bacteria Bacteria 53.1 0.00549   NR AWV88593.1 1548548 g582 i0 25.9 0.920520231213873 313 190 40.6 13 1663 821 687 989 AWV88593.1 hypothetical protein DN745_04270 [Bradymonas sediminis] diamond 1911 53.1 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria Bradymonadales Bradymonadaceae Bradymonas Bradymonas sediminis
32435331 32435331 PRJNA966993_P_NODE_97159_length_242_cov_0.911243_g96707_i0 PRJNA966993 97159 242 0.911243 2.20520806 Myxococcota 2818505 Bacteria Bacteria 45.1 0.00555   NR PKN54365.1 2013741 g96707 i0 47.5 0.991735537190083 40 21 49.6 0 123 4 343 382 PKN54365.1 MAG: hypothetical protein CVU56_26920 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14] diamond 240 45.1 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;