RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA1120771", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 19 ✖

tax_phylum 1

  • Acidobacteriota · 19 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1120771 · 19 ✖

analysis 1

tax_clade 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
14305367 14305367 PRJNA1120771_S_NODE_10032_length_335_cov_3.568493_g9632_i0 PRJNA1120771 10032 335 3.568493 11.95445155 Acidobacteriota bacterium 1978231 Bacteria Bacteria 54.7 6.86e-6   NR MBX3294082.1 1978231 g9632 i0 36.8 0.680597014925373 76 48 68.1 0 324 97 549 624 MBX3294082.1 hypothetical protein [Acidobacteriota bacterium] diamond 228 54.7 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
14305448 14305448 PRJNA1120771_S_NODE_21812_length_252_cov_7.196172_g21412_i0 PRJNA1120771 21812 252 7.196172 18.13435344 Terracidiphilus sp. 1964191 Bacteria Bacteria 60.8 1.2e-8   NR MDR3738396.1 1964191 g21412 i0 60.4 1.79761904761905 53 19 63.1 1 18 176 213 263 MDR3738396.1 choice-of-anchor A family protein [Terracidiphilus sp.] diamond 453 60.8 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terracidiphilus Terracidiphilus sp.
24502553 24502553 PRJNA1120771_S_NODE_24860_length_240_cov_1.324873_g24460_i0 PRJNA1120771 24860 240 1.324873 3.1796952 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 121 2.63e-30   NR HEX9161812.1 2651171 g24460 i0 70 2 80 24 100 0 240 1 383 462 HEX9161812.1 M20 family metallopeptidase [Thermoanaerobaculia bacterium] diamond 480 121 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
27228032 27228032 PRJNA1120771_S_NODE_8963_length_349_cov_3.977124_g8563_i0 PRJNA1120771 8963 349 3.977124 13.88016276 Acidobacteriota bacterium 1978231 Bacteria Bacteria 64.3 3.36e-9   NR MBX3294083.1 1978231 g8563 i0 92.1 0.326647564469914 38 3 32.7 0 1 114 511 548 MBX3294083.1 hypothetical protein [Acidobacteriota bacterium] diamond 114 64.3 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27323010 27323010 PRJNA1120771_S_NODE_8623_length_354_cov_4.672026_g8223_i0 PRJNA1120771 8623 354 4.672026 16.53897204 Candidatus Angelobacter sp. 2976921 Bacteria Bacteria 44.3 0.0258   NR HET9285510.1 2976921 g8223 i0 42.9 0.822033898305085 49 27 41.5 1 127 273 162 209 HET9285510.1 DUF4197 domain-containing protein [Candidatus Angelobacter sp.] diamond 291 44.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia     Candidatus Angelobacter Candidatus Angelobacter sp.
28144164 28144164 PRJNA1120771_S_NODE_30485_length_220_cov_2.943503_g30085_i0 PRJNA1120771 30485 220 2.943503 6.4757066 Candidatus Acidiferrum sp. 3069120 Bacteria Bacteria 43.5 0.0152   NR HJZ66037.1 3069120 g30085 i0 34.8 4.59545454545455 66 36 90 2 219 22 821 879 HJZ66037.1 hypothetical protein [Candidatus Acidiferrum sp.] diamond 1011 43.5 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales   Candidatus Acidiferrum Candidatus Acidiferrum sp.
28491347 28491347 PRJNA1120771_S_NODE_16147_length_283_cov_3.225000_g15747_i0 PRJNA1120771 16147 283 3.225 9.12675 Acidobacteriota bacterium 1978231 Bacteria Bacteria 75.9 4.15e-15   NR PYV33986.1 1978231 g15747 i0 41.2 1.02826855123675 97 51 96.5 1 10 282 24 120 PYV33986.1 MAG: 30S ribosomal protein S8 [Acidobacteriota bacterium] diamond 291 75.9 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29123022 29123022 PRJNA1120771_S_NODE_13849_length_299_cov_1.359375_g13449_i0 PRJNA1120771 13849 299 1.359375 4.06453125 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 66.6 2.25e-10   NR MDR3737318.1 2052142 g13449 i0 44.8 0.872909698996655 87 47 86.3 1 297 40 226 312 MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium] diamond 261 66.6 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae bacterium
29217658 29217658 PRJNA1120771_S_NODE_11909_length_316_cov_2.827839_g11509_i0 PRJNA1120771 11909 316 2.827839 8.93597124 Bryobacterales bacterium 2026791 Bacteria Bacteria 45.4 0.0094   NR HUG82103.1 2026791 g11509 i0 49.2 1.09177215189873 61 27 56 2 26 202 211 269 HUG82103.1 ankyrin repeat domain-containing protein [Bryobacterales bacterium] diamond 345 45.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
29375324 29375324 PRJNA1120771_S_NODE_38829_length_193_cov_4.353333_g38429_i0 PRJNA1120771 38829 193 4.353333 8.40193269 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 42 0.0353   NR HZQ53779.1 2212468 g38429 i0 40.9 0.683937823834197 44 19 57.5 1 113 3 110 153 HZQ53779.1 hypothetical protein [Bryobacteraceae bacterium] diamond 132 42 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
29438120 29438120 PRJNA1120771_S_NODE_24290_length_242_cov_2.623116_g23890_i0 PRJNA1120771 24290 242 2.623116 6.34794072 Acidobacteriota bacterium 1978231 Bacteria Bacteria 56.2 6.43e-7   NR MBX3294082.1 1978231 g23890 i0 50 0.694214876033058 56 27 69.4 1 220 53 573 627 MBX3294082.1 hypothetical protein [Acidobacteriota bacterium] diamond 168 56.2 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29975318 29975318 PRJNA1120771_S_NODE_26571_length_233_cov_1.831579_g26171_i0 PRJNA1120771 26571 233 1.831579 4.26757907 Acidobacteriota bacterium 1978231 Bacteria Bacteria 47 6.01e-4   NR HSR50986.1 1978231 g26171 i0 85.7 0.270386266094421 21 3 27 0 142 80 157 177 HSR50986.1 hypoxanthine phosphoribosyltransferase [Acidobacteriota bacterium] diamond 63 47 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30153849 30153849 PRJNA1120771_S_NODE_17552_length_274_cov_8.874459_g17152_i0 PRJNA1120771 17552 274 8.874459 24.31601766 Pseudomonadati 3379134 Bacteria Bacteria 71.2 1.12e-12   NR HEY3927432.1 2510641 g17152 i0 34.4 2.97810218978102 90 58 98.5 1 273 4 117 205 HEY3927432.1 MOSC domain-containing protein [Candidatus Korobacter sp.] diamond 816 71.2 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Candidatus Korobacteraceae Candidatus Korobacter Candidatus Korobacter sp.
30323440 30323440 PRJNA1120771_S_NODE_8552_length_355_cov_4.365385_g8152_i0 PRJNA1120771 8552 355 4.365385 15.49711675 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 114 1.8000000000000002e-28   NR HYU33637.1 2651171 g8152 i0 67.1 4.76619718309859 82 27 69.3 0 355 110 163 244 HYU33637.1 SDR family NAD(P)-dependent oxidoreductase [Thermoanaerobaculia bacterium] diamond 1692 114 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
30765207 30765207 PRJNA1120771_S_NODE_18014_length_272_cov_1.519651_g17614_i0 PRJNA1120771 18014 272 1.519651 4.13345072 Acidobacteriota bacterium 1978231 Bacteria Bacteria 68.6 4.22e-11   NR MBX3265733.1 1978231 g17614 i0 42.3 0.783088235294118 71 37 75 3 3 206 162 231 MBX3265733.1 hypothetical protein [Acidobacteriota bacterium] diamond 213 68.6 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31175654 31175654 PRJNA1120771_S_NODE_18695_length_268_cov_1.933333_g18295_i0 PRJNA1120771 18695 268 1.933333 5.18133244 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 42.4 0.0118   NR HEY8134037.1 2651171 g18295 i0 39.6 0.593283582089552 53 29 56 1 155 6 19 71 HEY8134037.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 159 42.4 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
31492356 31492356 PRJNA1120771_S_NODE_13696_length_300_cov_3.003891_g13296_i0 PRJNA1120771 13696 300 3.003891 9.011673 Blastocatellia bacterium 2052146 Bacteria Bacteria 103 1.67e-25   NR HEY3135429.1 2052146 g13296 i0 60.5 0.81 81 32 81 0 1 243 76 156 HEY3135429.1 lysozyme [Blastocatellia bacterium] diamond 243 103 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
32093204 32093204 PRJNA1120771_S_NODE_10678_length_328_cov_10.126316_g10278_i0 PRJNA1120771 10678 328 10.126316 33.21431648 Acidobacteriota bacterium 1978231 Bacteria Bacteria 56.6 1.31e-6   NR MBX3294082.1 1978231 g10278 i0 63.4 0.375 41 15 37.5 0 317 195 583 623 MBX3294082.1 hypothetical protein [Acidobacteriota bacterium] diamond 123 56.6 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32536404 32536404 PRJNA1120771_S_NODE_16199_length_283_cov_1.637500_g15799_i0 PRJNA1120771 16199 283 1.6375 4.634125 Acidobacteriota bacterium 1978231 Bacteria Bacteria 56.2 1.08e-6   NR MDQ7006302.1 1978231 g15799 i0 29.2 0.943462897526502 89 62 93.3 1 2 265 314 402 MDQ7006302.1 hypothetical protein [Acidobacteriota bacterium] diamond 267 56.2 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium

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);;