RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA734348", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Archaea · 21 ✖

tax_phylum 1

  • Nitrososphaerota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA734348 · 21 ✖

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
2472700 2472700 PRJNA734348_P_NODE_51122_length_289_cov_1.185185_g50425_i0 PRJNA734348 51122 289 1.185185 3.42518465 Candidatus Nitrosocosmicus 1826864 Archaea Archaea 440 4.889999999999998e-119   NTclustered gi|937513727|gb|CP012850.1| 1353260 g50425 i0 94.118 31.0795847750865 289 17 100 0 1 289 848531 848819 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 8982 440 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
4545864 4545864 PRJNA734348_P_NODE_138024_length_235_cov_2.771605_g137326_i0 PRJNA734348 138024 235 2.771605 6.51327175 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 300 6.81e-77   NTclustered gi|808354332|gb|CP011097.2| 1603555 g137326 i0 89.744 1.66808510638298 234 24 99 0 2 235 1357402 1357169 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 392 300 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
12198544 12198544 PRJNA734348_P_NODE_92290_length_251_cov_0.865169_g91592_i0 PRJNA734348 92290 251 0.865169 2.17157419 Candidatus Nitrosocosmicus arcticus 2035267 Archaea Archaea 431 2.4999999999999996e-116   NTclustered gi|1241355791|gb|KX863713.1| 2035267 g91592 i0 97.61 52.7490039840637 251 6 100 0 1 251 350 600 Candidatus Nitrosocosmicus arcticus 23S ribosomal RNA gene, partial sequence blastn 13240 431 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus arcticus
16021161 16021161 PRJNA734348_P_NODE_58773_length_281_cov_1.230769_g58076_i0 PRJNA734348 58773 281 1.230769 3.45846089 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 459 1.31e-124   NTclustered gi|808354332|gb|CP011097.2| 1603555 g58076 i0 96.085 1 281 11 100 0 1 281 1346678 1346958 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 281 459 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
17295695 17295695 PRJNA734348_P_NODE_150854_length_196_cov_4.081301_g150156_i0 PRJNA734348 150854 196 4.081301 7.99934996 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 357 3.2099999999999996e-94   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g150156 i0 99.49 28.6785714285714 196 1 100 0 1 196 1790472 1790277 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 5621 357 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
21599650 21599650 PRJNA734348_P_NODE_71377_length_268_cov_2.261538_g70679_i0 PRJNA734348 71377 268 2.261538 6.06092184 Nitrosopumilus sp. 2024843 Archaea Archaea 141 3.71e-39   NR MEK0370956.1 2024843 g70679 i0 80.7 0.985074626865672 88 17 98.5 0 3 266 82 169 MEK0370956.1 DNA adenine methylase [Nitrosopumilus sp.] diamond 264 141 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
22394424 22394424 PRJNA734348_P_NODE_110038_length_246_cov_2.751445_g109340_i0 PRJNA734348 110038 246 2.751445 6.7685547 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 455 1.4500000000000002e-123   NTclustered gi|808354332|gb|CP011097.2| 1603555 g109340 i0 100 1 246 0 100 0 1 246 15375 15620 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 246 455 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
27115428 27115428 PRJNA734348_P_NODE_131302_length_241_cov_1.630952_g130604_i0 PRJNA734348 131302 241 1.630952 3.93059432 Nitrososphaerales archaeon 2268197 Archaea Archaea 85.5 9.96e-18   NR MFI5405157.1 2268197 g130604 i0 41.3 0.995850622406639 80 47 99.6 0 241 2 70 149 MFI5405157.1 NAD-dependent epimerase/dehydratase family protein [Nitrososphaerales archaeon] diamond 240 85.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales     Nitrososphaerales archaeon
27410558 27410558 PRJNA734348_P_NODE_126003_length_243_cov_0.864706_g125305_i0 PRJNA734348 126003 243 0.864706 2.10123558 Nitrososphaeria 1643678 Archaea Archaea 156 1.17e-44   NR RPJ30080.1 2026768 g125305 i0 97.5 3 81 2 100 0 1 243 209 289 RPJ30080.1 MAG: aldo/keto reductase [Nitrosopumilales archaeon] diamond 729 156 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales     Nitrosopumilales archaeon
27779149 27779149 PRJNA734348_P_NODE_88884_length_253_cov_1.705556_g88186_i0 PRJNA734348 88884 253 1.705556 4.31505668 Candidatus Nitrososphaera gargensis 497727 Archaea Archaea 50.8 2.36e-6   NR WP_187147597.1 497727 g88186 i0 53.8 1.8498023715415 39 16 43.9 1 251 141 14 52 WP_187147597.1 hypothetical protein [Candidatus Nitrososphaera gargensis] diamond 468 50.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Candidatus Nitrososphaera gargensis
28104782 28104782 PRJNA734348_P_NODE_79465_length_261_cov_1.585106_g78767_i0 PRJNA734348 79465 261 1.585106 4.13712666 root 1 Root_unresolved Root_unresolved 158 1.55e-47   NR MDN5868263.1 2109671 g78767 i0 89.5 2.96551724137931 86 9 98.9 0 3 260 45 130 MDN5868263.1 carbonic anhydrase [Candidatus Nitrosocosmicus sp.] diamond 774 158 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus sp.
28473692 28473692 PRJNA734348_P_NODE_137766_length_235_cov_3.895062_g137068_i0 PRJNA734348 137766 235 3.895062 9.1533957 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 67.4 6.68e-11   NR HSA73287.1 2169593 g137068 i0 52.4 2.0936170212766 82 32 97 3 233 6 39 119 HSA73287.1 S8 family serine peptidase [Nitrososphaeraceae archaeon] diamond 492 67.4 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
29231586 29231586 PRJNA734348_P_NODE_98009_length_250_cov_0.870056_g97311_i0 PRJNA734348 98009 250 0.870056 2.17514 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 135 5.939999999999998e-35   NR HZL23565.1 2169593 g97311 i0 100 0.78 65 0 78 0 248 54 347 411 HZL23565.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 195 135 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
29989301 29989301 PRJNA734348_P_NODE_69571_length_270_cov_1.563452_g68873_i0 PRJNA734348 69571 270 1.563452 4.2213204 Nitrososphaera sp. 1971748 Archaea Archaea 97.1 1.81e-22   NR HEU0050312.1 1971748 g68873 i0 68.5 1.8 54 17 60 0 264 103 180 233 HEU0050312.1 hypothetical protein [Nitrososphaera sp.] diamond 486 97.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
30115516 30115516 PRJNA734348_P_NODE_128952_length_242_cov_0.911243_g128254_i0 PRJNA734348 128952 242 0.911243 2.20520806 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 43.1 0.0152   NR MDW0290255.1 2169593 g128254 i0 79.2 0.297520661157025 24 5 29.8 0 175 104 139 162 MDW0290255.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 72 43.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
30494902 30494902 PRJNA734348_P_NODE_41933_length_310_cov_2.299578_g41237_i0 PRJNA734348 41933 310 2.299578 7.1286918 Nitrosopumilales archaeon 2026768 Archaea Archaea 82 1.46e-16   NR RPI82001.1 2026768 g41237 i0 77.6 0.474193548387097 49 11 47.4 0 309 163 117 165 RPI82001.1 MAG: SDR family oxidoreductase [Nitrosopumilales archaeon] diamond 147 82 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales     Nitrosopumilales archaeon
30779146 30779146 PRJNA734348_P_NODE_145974_length_217_cov_5.673611_g145276_i0 PRJNA734348 145974 217 5.673611 12.31173587 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 134 7.37e-39   NR HEY9485929.1 2169593 g145276 i0 98.5 0.940092165898618 68 1 94 0 205 2 1 68 HEY9485929.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 204 134 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31358313 31358313 PRJNA734348_P_NODE_75696_length_264_cov_2.141361_g74998_i0 PRJNA734348 75696 264 2.141361 5.65319304 root 1 Root_unresolved Root_unresolved 80.1 2.54e-15   NR HEX5186680.1 2169593 g74998 i0 47.2 5.98863636363636 89 45 98.9 2 3 263 100 188 HEX5186680.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 1581 80.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31548208 31548208 PRJNA734348_P_NODE_96036_length_250_cov_0.870056_g95338_i0 PRJNA734348 96036 250 0.870056 2.17514 root 1 Root_unresolved Root_unresolved 55.8 8.52e-7   NR MCI0560543.1 1971748 g95338 i0 42.5 4.716 73 41 86.4 1 35 250 217 289 MCI0560543.1 YqaJ viral recombinase family protein [Nitrososphaera sp.] diamond 1179 55.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
31822308 31822308 PRJNA734348_P_NODE_77297_length_263_cov_1.452632_g76599_i0 PRJNA734348 77297 263 1.452632 3.82042216 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 161 1.01e-48   NR HEX7258238.1 2169593 g76599 i0 96.4 1.893536121673 83 3 94.7 0 14 262 57 139 HEX7258238.1 helix-turn-helix domain-containing protein [Nitrososphaeraceae archaeon] diamond 498 161 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32739327 32739327 PRJNA734348_P_NODE_111600_length_246_cov_0.890173_g110902_i0 PRJNA734348 111600 246 0.890173 2.18982558 Nitrosopumilus sp. 2024843 Archaea Archaea 146 1.87e-43   NR MBA3285679.1 2024843 g110902 i0 86.4 0.98780487804878 81 11 98.8 0 244 2 5 85 MBA3285679.1 hypothetical protein [Nitrosopumilus sp.] diamond 243 146 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.

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