RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA641707" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA641707 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
4984870 4984870 PRJNA641707_P_NODE_181584_length_200_cov_3.503311_g178921_i0 PRJNA641707 181584 200 3.503311 7.006622 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 148 1.22e-41   NR HET6716796.1 2169593 g178921 i0 100 0.975 65 0 97.5 0 197 3 75 139 HET6716796.1 NAD(P)-dependent alcohol dehydrogenase [Nitrososphaeraceae archaeon] diamond 195 148 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
22292382 22292382 PRJNA641707_P_NODE_297378_length_165_cov_2.862069_g294715_i0 PRJNA641707 297378 165 2.862069 4.72241385 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 101 3.09e-23   NR HEX6294118.1 2169593 g294715 i0 100 3.85454545454545 53 0 96.4 0 164 6 564 616 HEX6294118.1 HAD-IC family P-type ATPase [Nitrososphaeraceae archaeon] diamond 636 101 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
26701214 26701214 PRJNA641707_P_NODE_92721_length_246_cov_5.284264_g90058_i0 PRJNA641707 92721 246 5.284264 12.99928944 Nitrososphaera sp. 1971748 Archaea Archaea 44.7 0.00163   NR MFL6496348.1 1971748 g90058 i0 62.1 0.707317073170732 29 11 35.4 0 93 7 55 83 MFL6496348.1 hypothetical protein [Nitrososphaera sp.] diamond 174 44.7 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
27081064 27081064 PRJNA641707_P_NODE_192222_length_198_cov_10.959732_g189559_i0 PRJNA641707 192222 198 10.959732 21.70026936 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 92 6.53e-21   NR HEY6883282.1 2169593 g189559 i0 56.2 5.16666666666667 89 14 97 1 192 1 13 101 HEY6883282.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 1023 92 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
27902269 27902269 PRJNA641707_P_NODE_70985_length_248_cov_9.140704_g68322_i0 PRJNA641707 70985 248 9.140704 22.66894592 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 60.5 5.85e-10   NR MPZ08107.1 2169593 g68322 i0 93.8 0.387096774193548 32 2 38.7 0 153 248 33 64 MPZ08107.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 96 60.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
28060240 28060240 PRJNA641707_P_NODE_299285_length_164_cov_7.669565_g296622_i0 PRJNA641707 299285 164 7.669565 12.5780866 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 94.7 1.75e-22   NR MDW3604690.1 2169593 g296622 i0 94.2 0.951219512195122 52 3 95.1 0 158 3 136 187 MDW3604690.1 30S ribosomal protein S3ae [Nitrososphaeraceae archaeon] diamond 156 94.7 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
28786217 28786217 PRJNA641707_P_NODE_149247_length_238_cov_4.529101_g146584_i0 PRJNA641707 149247 238 4.529101 10.77926038 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 92 1.05e-20   NR HET7643244.1 2169593 g146584 i0 69.6 0.995798319327731 79 16 99.6 1 238 2 104 174 HET7643244.1 PspA/IM30 family protein [Nitrososphaeraceae archaeon] diamond 237 92 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
28912498 28912498 PRJNA641707_P_NODE_249868_length_182_cov_5.992481_g247205_i0 PRJNA641707 249868 182 5.992481 10.90631542 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 112 2.94e-29   NR HTH22373.1 2169593 g247205 i0 94.8 0.956043956043956 58 3 95.6 0 177 4 57 114 HTH22373.1 archaeal proteasome endopeptidase complex subunit beta [Nitrososphaeraceae archaeon] diamond 174 112 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
29480699 29480699 PRJNA641707_P_NODE_156490_length_223_cov_10.126437_g153827_i0 PRJNA641707 156490 223 10.126437 22.58195451 Nitrosarchaeum sp. 2026886 Archaea Archaea 84.7 4.63e-19   NR MCA9813148.1 2026886 g153827 i0 62.7 0.901345291479821 67 25 90.1 0 2 202 54 120 MCA9813148.1 transposase [Nitrosarchaeum sp.] diamond 201 84.7 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp.
29765027 29765027 PRJNA641707_P_NODE_133051_length_243_cov_9.840206_g130388_i0 PRJNA641707 133051 243 9.840206 23.91170058 Candidatus Nitrosocosmicus arcticus 2035267 Archaea Archaea 111 1.8700000000000003e-27   NR WP_261377813.1 2035267 g130388 i0 72.5 0.987654320987654 80 20 96.3 1 241 8 26 105 WP_261377813.1 transcription initiation factor IIB [Candidatus Nitrosocosmicus arcticus] diamond 240 111 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus arcticus
30681227 30681227 PRJNA641707_P_NODE_268393_length_175_cov_2.396825_g265730_i0 PRJNA641707 268393 175 2.396825 4.19444375 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 98.6 3.84e-25   NR HZL23330.1 2169593 g265730 i0 90.9 0.942857142857143 55 5 94.3 0 166 2 1 55 HZL23330.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 165 98.6 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
30871027 30871027 PRJNA641707_P_NODE_280494_length_170_cov_4.380165_g277831_i0 PRJNA641707 280494 170 4.380165 7.4462805 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 108 7.310000000000001e-27   NR MCJ7636558.1 2169593 g277831 i0 98.2 0.970588235294118 55 1 97.1 0 165 1 214 268 MCJ7636558.1 Lrp/AsnC family transcriptional regulator [Nitrososphaeraceae archaeon] diamond 165 108 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31092267 31092267 PRJNA641707_P_NODE_83275_length_246_cov_7.187817_g80612_i0 PRJNA641707 83275 246 7.187817 17.68202982 Nitrosopumilales archaeon 2026768 Archaea Archaea 50.1 3.16e-5   NR RPJ24844.1 2026768 g80612 i0 91.3 0.280487804878049 23 2 28 0 30 98 121 143 RPJ24844.1 MAG: 30S ribosomal protein S15 [Nitrosopumilales archaeon] diamond 69 50.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales     Nitrosopumilales archaeon
31123436 31123436 PRJNA641707_P_NODE_293575_length_166_cov_2.974359_g290912_i0 PRJNA641707 293575 166 2.974359 4.93743594 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 104 6.14e-26   NR HEY7109884.1 2169593 g290912 i0 94.3 0.957831325301205 53 3 95.8 0 160 2 100 152 HEY7109884.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 159 104 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31186793 31186793 PRJNA641707_P_NODE_79455_length_246_cov_8.639594_g76792_i0 PRJNA641707 79455 246 8.639594 21.25340124 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 75.5 6.26e-14   NR MDW0249986.1 2169593 g76792 i0 73.7 1.39024390243902 57 8 69.5 1 244 74 269 318 MDW0249986.1 aminotransferase class V-fold PLP-dependent enzyme [Nitrososphaeraceae archaeon] diamond 342 75.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31218103 31218103 PRJNA641707_P_NODE_120875_length_245_cov_7.015306_g118212_i0 PRJNA641707 120875 245 7.015306 17.1874997 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 61.2 3.67e-9   NR MDW0282378.1 2169593 g118212 i0 96.8 0.759183673469388 31 1 38 0 7 99 119 149 MDW0282378.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 186 61.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31250238 31250238 PRJNA641707_P_NODE_75315_length_246_cov_13.654822_g72652_i0 PRJNA641707 75315 246 13.654822 33.59086212 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 72.4 2.42e-13   NR HEX6672839.1 2169593 g72652 i0 100 0.390243902439024 32 0 39 0 99 4 87 118 HEX6672839.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 96 72.4 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31345083 31345083 PRJNA641707_P_NODE_112136_length_246_cov_2.573604_g109473_i0 PRJNA641707 112136 246 2.573604 6.33106584 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 60.8 1.06e-8   NR HEX7141604.1 2169593 g109473 i0 87.9 0.804878048780488 33 3 39 1 242 147 75 107 HEX7141604.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 198 60.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31787739 31787739 PRJNA641707_P_NODE_266877_length_175_cov_7.206349_g264214_i0 PRJNA641707 266877 175 7.206349 12.61111075 Nitrososphaera sp. 1971748 Archaea Archaea 55.8 3.52e-7   NR HJS83571.1 1971748 g264214 i0 52.1 0.822857142857143 48 23 82.3 0 5 148 337 384 HJS83571.1 hypothetical protein [Nitrososphaera sp.] diamond 144 55.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
31882669 31882669 PRJNA641707_P_NODE_203397_length_197_cov_2.540541_g200734_i0 PRJNA641707 203397 197 2.540541 5.00486577 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 132 1.4e-35   NR MFL6316387.1 2169593 g200734 i0 95.3 2.9238578680203 64 3 97.5 0 192 1 256 319 MFL6316387.1 SMP-30/gluconolactonase/LRE family protein [Nitrososphaeraceae archaeon] diamond 576 132 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32199331 32199331 PRJNA641707_P_NODE_308118_length_162_cov_3.238938_g305455_i0 PRJNA641707 308118 162 3.238938 5.24707956 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 90.1 6.110000000000001e-21   NR MDW0149034.1 2169593 g305455 i0 90.4 2.87037037037037 52 5 96.3 0 7 162 117 168 MDW0149034.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 465 90.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32326147 32326147 PRJNA641707_P_NODE_241559_length_186_cov_1.065693_g238896_i0 PRJNA641707 241559 186 1.065693 1.98218898 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 108 3.48e-26   NR MCJ7635897.1 2169593 g238896 i0 88.1 3.80645161290323 59 7 95.2 0 183 7 321 379 MCJ7635897.1 orc1/cdc6 family replication initiation protein [Nitrososphaeraceae archaeon] diamond 708 108 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32704559 32704559 PRJNA641707_P_NODE_104600_length_246_cov_3.614213_g101937_i0 PRJNA641707 104600 246 3.614213 8.89096398 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 62.8 1.3e-9   NR MCJ7637660.1 2169593 g101937 i0 93.9 0.402439024390244 33 2 40.2 0 147 245 114 146 MCJ7637660.1 V-type ATP synthase subunit D [Nitrososphaeraceae archaeon] diamond 99 62.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon

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