RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA942359" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA942359 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
4751198 4751198 PRJNA942359_P_NODE_10324_length_277_cov_2.823529_g10209_i0 PRJNA942359 10324 277 2.823529 7.82117533 Candidatus Nitrosarchaeum limnium 1007084 Archaea Archaea 98.2 1.86e-21   NR WP_048097151.1 1007084 g10209 i0 60.8 2.11191335740072 102 30 99.6 3 276 1 503 604 WP_048097151.1 beta strand repeat-containing protein, partial [Candidatus Nitrosarchaeum limnium] diamond 585 98.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Candidatus Nitrosarchaeum limnium
5087170 5087170 PRJNA942359_P_NODE_6284_length_336_cov_1.969582_g6169_i0 PRJNA942359 6284 336 1.969582 6.61779552 Nitrosarchaeum sp. 2026886 Archaea Archaea 224 6.82e-70   NR MBS3926316.1 2026886 g6169 i0 96.4 2 112 4 100 0 336 1 203 314 MBS3926316.1 hypothetical protein [Nitrosarchaeum sp.] diamond 672 224 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp.
7301109 7301109 PRJNA942359_P_NODE_19866_length_242_cov_0.923077_g19751_i0 PRJNA942359 19866 242 0.923077 2.23384634 Nitrosarchaeum 1007082 Archaea Archaea 128 3.4599999999999995e-35   NR WP_010195597.1 1007084 g19751 i0 79 1.99586776859504 81 16 99.2 1 240 1 8 88 WP_010195597.1 hypothetical protein, partial [Candidatus Nitrosarchaeum limnium] diamond 483 128 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Candidatus Nitrosarchaeum limnium
14950989 14950989 PRJNA942359_P_NODE_212_length_1467_cov_13.237446_g177_i0 PRJNA942359 212 1467 13.237446 194.19333282 Candidatus Nitrosarchaeum limnium 1007084 Archaea Archaea 669 9.959999999999999e-228   NR WP_048097151.1 1007084 g177 i0 72.3 2.03680981595092 499 123 99.8 5 1465 2 3 497 WP_048097151.1 beta strand repeat-containing protein, partial [Candidatus Nitrosarchaeum limnium] diamond 2988 669 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Candidatus Nitrosarchaeum limnium
26676736 26676736 PRJNA942359_P_NODE_4721_length_378_cov_1.340984_g4606_i0 PRJNA942359 4721 378 1.340984 5.06891952 Nitrosopumilus sp. 2024843 Archaea Archaea 75.9 8.56e-14   NR MDH3833836.1 2024843 g4606 i0 51.5 1.07936507936508 68 33 54 0 376 173 169 236 MDH3833836.1 hypothetical protein [Nitrosopumilus sp.] diamond 408 75.9 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
27625691 27625691 PRJNA942359_P_NODE_4744_length_377_cov_1.940789_g4629_i0 PRJNA942359 4744 377 1.940789 7.31677453 Nitrosopumilus sp. 2024843 Archaea Archaea 88.2 1.44e-17   NR WP_368059013.1 2024843 g4629 i0 44.6 1.03448275862069 130 58 98.7 3 373 2 194 315 WP_368059013.1 hypothetical protein [Nitrosopumilus sp.] diamond 390 88.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
27783574 27783574 PRJNA942359_P_NODE_10004_length_280_cov_2.927536_g9889_i0 PRJNA942359 10004 280 2.927536 8.1971008 Candidatus Nitrosotenuis uzonensis 1407055 Archaea Archaea 133 4.51e-35   NR WP_205097554.1 1407055 g9889 i0 77.4 0.996428571428571 93 21 99.6 0 279 1 20 112 WP_205097554.1 trypsin-like serine protease [Candidatus Nitrosotenuis uzonensis] diamond 279 133 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis uzonensis
29204410 29204410 PRJNA942359_P_NODE_10709_length_273_cov_3.480000_g10594_i0 PRJNA942359 10709 273 3.48 9.5004 Nitrosopumilaceae archaeon 2202732 Archaea Archaea 111 3.56e-28   NR MEX1150830.1 2202732 g10594 i0 64.8 0.967032967032967 88 31 96.7 0 10 273 49 136 MEX1150830.1 hypothetical protein [Nitrosopumilaceae archaeon] diamond 264 111 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae   Nitrosopumilaceae archaeon
29519914 29519914 PRJNA942359_P_NODE_20790_length_203_cov_4.161538_g20675_i0 PRJNA942359 20790 203 4.161538 8.44792214 Candidatus Nitrosarchaeum limnium 1007084 Archaea Archaea 109 5.230000000000001e-29   NR WP_193353005.1 1007084 g20675 i0 83.6 1.98029556650246 67 11 99 0 2 202 33 99 WP_193353005.1 hypothetical protein, partial [Candidatus Nitrosarchaeum limnium] diamond 402 109 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Candidatus Nitrosarchaeum limnium
31225768 31225768 PRJNA942359_P_NODE_1515_length_629_cov_1.785971_g1405_i0 PRJNA942359 1515 629 1.785971 11.23375759 Nitrosopumilaceae archaeon 2202732 Archaea Archaea 280 2.08e-92   NR MEX1150829.1 2202732 g1405 i0 66.7 0.972972972972973 204 59 95.9 2 628 26 39 236 MEX1150829.1 hypothetical protein [Nitrosopumilaceae archaeon] diamond 612 280 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae   Nitrosopumilaceae archaeon
31921780 31921780 PRJNA942359_P_NODE_4317_length_391_cov_1.962264_g4202_i0 PRJNA942359 4317 391 1.962264 7.67245224 Nitrosopumilus sp. 2024843 Archaea Archaea 141 4.75e-39   NR MDH3833836.1 2024843 g4202 i0 54.7 0.982097186700767 128 57 97.4 1 386 6 3 130 MDH3833836.1 hypothetical protein [Nitrosopumilus sp.] diamond 384 141 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
32111674 32111674 PRJNA942359_P_NODE_13778_length_252_cov_0.871508_g13663_i0 PRJNA942359 13778 252 0.871508 2.19620016 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 108 2.11e-25   NR MDW0176719.1 2169593 g13663 i0 68 0.892857142857143 75 24 89.3 0 2 226 65 139 MDW0176719.1 reverse transcriptase family protein [Nitrososphaeraceae archaeon] diamond 225 108 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32900890 32900890 PRJNA942359_P_NODE_7460_length_314_cov_1.236515_g7345_i0 PRJNA942359 7460 314 1.236515 3.8826571 Candidatus Nitrosarchaeum limnium 1007084 Archaea Archaea 198 2.22e-62   NR WP_010195597.1 1007084 g7345 i0 91.3 1.98726114649682 104 9 99.4 0 2 313 75 178 WP_010195597.1 hypothetical protein, partial [Candidatus Nitrosarchaeum limnium] diamond 624 198 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Candidatus Nitrosarchaeum limnium

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