RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA429937", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Archaea · 12 ✖

tax_phylum 1

  • Nitrososphaerota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA429937 · 12 ✖

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
5530179 5530179 PRJNA429937_P_NODE_31305_length_650_cov_2.834138_g19109_i0 PRJNA429937 31305 650 2.834138 18.421897 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 1053 0   NTclustered gi|937513727|gb|CP012850.1| 1353260 g19109 i0 99.314 0.987692307692308 583 2 98 2 1 581 2820740 2820158 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 642 1053 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
9354629 9354629 PRJNA429937_P_NODE_31308_length_650_cov_2.732689_g19109_i1 PRJNA429937 31308 650 2.732689 17.7624785 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 1053 0   NTclustered gi|937513727|gb|CP012850.1| 1353260 g19109 i1 99.314 0.987692307692308 583 2 98 2 1 581 2820740 2820158 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 642 1053 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
27549569 27549569 PRJNA429937_P_NODE_63284_length_432_cov_1.828784_g42943_i0 PRJNA429937 63284 432 1.828784 7.90034688 Candidatus Caldarchaeum sp. 2972665 Archaea Archaea 51.2 2.54e-4   NR MEM4168313.1 2972665 g42943 i0 62.9 0.548611111111111 35 13 24.3 0 202 98 95 129 MEM4168313.1 hypothetical protein [Candidatus Caldarchaeum sp.] diamond 237 51.2 1 Archaea   Thermoproteati Nitrososphaerota   Candidatus Caldarchaeales Candidatus Caldarchaeaceae Candidatus Caldarchaeum Candidatus Caldarchaeum sp.
27928543 27928543 PRJNA429937_P_NODE_110945_length_272_cov_1.995885_g88323_i0 PRJNA429937 110945 272 1.995885 5.4288072 Nitrososphaera sp. 1971748 Archaea Archaea 65.5 1.21e-11   NR NOJ27510.1 1971748 g88323 i0 58.1 0.683823529411765 62 22 68.4 1 2 187 30 87 NOJ27510.1 hypothetical protein [Nitrososphaera sp.] diamond 186 65.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
28686557 28686557 PRJNA429937_P_NODE_106767_length_283_cov_2.539370_g84147_i0 PRJNA429937 106767 283 2.53937 7.1864171 Nitrososphaera sp. 1971748 Archaea Archaea 103 5.93e-26   NR NOJ27511.1 1971748 g84147 i0 50.4 1.21908127208481 115 32 95.4 1 282 13 7 121 NOJ27511.1 heavy metal-responsive transcriptional regulator [Nitrososphaera sp.] diamond 345 103 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
28734480 28734480 PRJNA429937_P_NODE_67227_length_414_cov_4.114286_g46129_i0 PRJNA429937 67227 414 4.114286 17.03314404 root 1 Root_unresolved Root_unresolved 89.7 1.71e-19   NR RPI82472.1 2026768 g46129 i0 42.2 4.72463768115942 102 59 73.9 0 76 381 47 148 RPI82472.1 MAG: hypothetical protein EHM34_06880 [Nitrosopumilales archaeon] diamond 1956 89.7 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales     Nitrosopumilales archaeon
29980955 29980955 PRJNA429937_P_NODE_140071_length_205_cov_3.284091_g117444_i0 PRJNA429937 140071 205 3.284091 6.73238655 Nitrososphaera sp. 1971748 Archaea Archaea 115 5.839999999999999e-31   NR NOJ27511.1 1971748 g117444 i0 77.9 0.995121951219512 68 15 99.5 0 204 1 7 74 NOJ27511.1 heavy metal-responsive transcriptional regulator [Nitrososphaera sp.] diamond 204 115 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
30486519 30486519 PRJNA429937_P_NODE_138993_length_207_cov_2.353933_g116366_i0 PRJNA429937 138993 207 2.353933 4.87264131 Candidatus Nitrosarchaeum limnium 1007084 Archaea Archaea 84.7 1.8e-17   NR WP_048096998.1 1007084 g116366 i0 90.9 3.18840579710145 44 4 63.8 0 76 207 1 44 WP_048096998.1 AAA family ATPase, partial [Candidatus Nitrosarchaeum limnium] diamond 660 84.7 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Candidatus Nitrosarchaeum limnium
31466385 31466385 PRJNA429937_P_NODE_63876_length_429_cov_2.625000_g43410_i0 PRJNA429937 63876 429 2.625 11.26125 Nitrososphaera sp. 1971748 Archaea Archaea 48.1 0.00302   NR MCI0557423.1 1971748 g43410 i0 42 0.34965034965035 50 29 35 0 284 135 1 50 MCI0557423.1 hypothetical protein [Nitrososphaera sp.] diamond 150 48.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
31624270 31624270 PRJNA429937_P_NODE_148176_length_189_cov_3.531250_g125549_i0 PRJNA429937 148176 189 3.53125 6.6740625 Nitrososphaera sp. 1971748 Archaea Archaea 89 1.29e-20   NR NOJ27511.1 1971748 g125549 i0 70.9 0.873015873015873 55 16 87.3 0 15 179 1 55 NOJ27511.1 heavy metal-responsive transcriptional regulator [Nitrososphaera sp.] diamond 165 89 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
31972249 31972249 PRJNA429937_P_NODE_127678_length_230_cov_2.850746_g105051_i0 PRJNA429937 127678 230 2.850746 6.5567158 Nitrososphaera sp. 1971748 Archaea Archaea 82.4 8.4e-18   NR NOJ27511.1 1971748 g105051 i0 73.5 0.639130434782609 49 13 63.9 0 229 83 7 55 NOJ27511.1 heavy metal-responsive transcriptional regulator [Nitrososphaera sp.] diamond 147 82.4 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
32478774 32478774 PRJNA429937_P_NODE_125999_length_234_cov_1.800000_g103372_i0 PRJNA429937 125999 234 1.8 4.212 Candidatus Nitrosopolaris wilkensis 2959594 Archaea Archaea 92.4 8.4e-20   NR PWU81597.1 2959594 g103372 i0 93.6 0.602564102564103 47 3 60.3 0 232 92 156 202 PWU81597.1 MAG: succinate-semialdehyde dehydrogenase [Candidatus Nitrosopolaris wilkensis] diamond 141 92.4 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosopolaris Candidatus Nitrosopolaris wilkensis

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