RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA432257", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Archaea · 17 ✖

tax_phylum 1

  • Nitrososphaerota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA432257 · 17 ✖

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
4256811 4256811 PRJNA432257_S_NODE_54844_length_223_cov_6.956989_g54463_i0 PRJNA432257 54844 223 6.956989 15.51408547 Nitrosopumilus ureiphilus 1470067 Archaea Archaea 195 3.11e-45   NTclustered gi|1869224726|gb|CP026995.1| 1470067 g54463 i0 85.561 0.838565022421525 187 26 83 1 5 190 1856893 1856707 Nitrosopumilus ureiphilus strain PS0 chromosome, complete genome blastn 187 195 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus ureiphilus
10634128 10634128 PRJNA432257_S_NODE_85549_length_188_cov_1.509934_g85168_i0 PRJNA432257 85549 188 1.509934 2.83867592 Nitrosarchaeum sp. AC2 2259673 Archaea Archaea 265 1.9000000000000001e-66   NTclustered gi|1869229208|gb|CP030847.1| 2259673 g85168 i0 92.021 3.02127659574468 188 15 100 0 1 188 425081 425268 Nitrosarchaeum sp. AC2 chromosome, complete genome blastn 568 265 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp. AC2
17006336 17006336 PRJNA432257_S_NODE_109434_length_167_cov_1.576923_g109053_i0 PRJNA432257 109434 167 1.576923 2.63346141 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 171 3.7099999999999997e-38   NTclustered gi|937513727|gb|CP012850.1| 1353260 g109053 i0 86.047 6.73652694610778 172 8 94 8 5 161 2062864 2062694 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 1125 171 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
19556042 19556042 PRJNA432257_S_NODE_76996_length_196_cov_1.937107_g76615_i0 PRJNA432257 76996 196 1.937107 3.79672972 Candidatus Nitrosotenuis chungbukensis 1353246 Archaea Archaea 185 1.6e-42   NTclustered gi|2551106379|gb|CP130341.1| 1353246 g76615 i0 84.021 1.98979591836735 194 30 99 1 3 196 513135 513327 Candidatus Nitrosotenuis chungbukensis strain MY2 chromosome, complete genome blastn 390 185 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis chungbukensis
22106851 22106851 PRJNA432257_S_NODE_86878_length_186_cov_412.953020_g86497_i0 PRJNA432257 86878 186 412.95302 768.0926172 Candidatus Nitrosotenuis sp. DW1 2259672 Archaea Archaea 211 2.48e-50   NTclustered gi|1869227213|gb|CP030846.1| 2259672 g86497 i0 92.568 0.795698924731183 148 10 80 1 3 150 1791747 1791601 Candidatus Nitrosotenuis sp. DW1 chromosome, complete genome blastn 148 211 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis sp. DW1
26759204 26759204 PRJNA432257_S_NODE_91921_length_182_cov_154.048276_g91540_i0 PRJNA432257 91921 182 154.048276 280.36786232 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 94.4 1.74e-22   NR MDW3604804.1 2169593 g91540 i0 100 0.791208791208791 48 0 79.1 0 38 181 35 82 MDW3604804.1 adenine phosphoribosyltransferase [Nitrososphaeraceae archaeon] diamond 144 94.4 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
27644679 27644679 PRJNA432257_S_NODE_11484_length_389_cov_4.616477_g11115_i0 PRJNA432257 11484 389 4.616477 17.95809553 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 42.4 0.029   NR HXW11405.1 2169593 g11115 i0 48.8 0.316195372750643 41 21 31.6 0 95 217 35 75 HXW11405.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 123 42.4 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
28244181 28244181 PRJNA432257_S_NODE_111926_length_164_cov_2.456693_g111545_i0 PRJNA432257 111926 164 2.456693 4.02897652 Nitrososphaerota archaeon 2026795 Archaea Archaea 59.7 2.3e-9   NR MDG6913545.1 2026795 g111545 i0 67.6 0.621951219512195 34 11 62.2 0 118 17 5 38 MDG6913545.1 nucleotidyltransferase domain-containing protein [Nitrososphaerota archaeon] diamond 102 59.7 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
28402255 28402255 PRJNA432257_S_NODE_63466_length_211_cov_22.701149_g63085_i0 PRJNA432257 63466 211 22.701149 47.89942439 Candidatus Nitrosotenuis sp. 2507556 Archaea Archaea 92.4 5.31e-20   NR HEY8111103.1 2507556 g63085 i0 79.7 3.32701421800948 59 12 83.9 0 177 1 333 391 HEY8111103.1 hypothetical protein [Candidatus Nitrosotenuis sp.] diamond 702 92.4 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis sp.
28481878 28481878 PRJNA432257_S_NODE_64866_length_209_cov_162.069767_g64485_i0 PRJNA432257 64866 209 162.069767 338.72581303 Candidatus Nitrosotenuis 1825023 Archaea Archaea 91.3 6.85e-21   NR MBI5377440.1 2026795 g64485 i0 82.5 3.27272727272727 57 10 81.8 0 173 3 122 178 MBI5377440.1 hypothetical protein [Nitrososphaerota archaeon] diamond 684 92 0.992391304347826 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
28797363 28797363 PRJNA432257_S_NODE_116007_length_160_cov_2.219512_g115626_i0 PRJNA432257 116007 160 2.219512 3.5512192 Nitrosarchaeum 1007082 Archaea Archaea 101 2.31e-25   NR MCA9813037.1 2026886 g115626 i0 84.9 6.95625 53 8 99.4 0 2 160 44 96 MCA9813037.1 proteasome subunit beta [Nitrosarchaeum sp.] diamond 1113 102 0.990196078431373 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp.
30265678 30265678 PRJNA432257_S_NODE_69412_length_204_cov_3.359281_g69031_i0 PRJNA432257 69412 204 3.359281 6.85293324 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 124 3.4299999999999996e-31   NR HEY6587379.1 2169593 g69031 i0 95.6 1 68 3 100 0 204 1 277 344 HEY6587379.1 ATP-binding protein [Nitrososphaeraceae archaeon] diamond 204 124 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
30518145 30518145 PRJNA432257_S_NODE_76473_length_196_cov_73.578616_g76092_i0 PRJNA432257 76473 196 73.578616 144.21408736 Candidatus Nitrosotenuis uzonensis 1407055 Archaea Archaea 89.4 2.3e-19   NR WP_048195019.1 1407055 g76092 i0 87.5 0.73469387755102 48 6 73.5 0 37 180 55 102 WP_048195019.1 Fic family protein [Candidatus Nitrosotenuis uzonensis] diamond 144 89.4 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis uzonensis
30549657 30549657 PRJNA432257_S_NODE_5773_length_497_cov_78.765217_g5502_i0 PRJNA432257 5773 497 78.765217 391.46312849 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 215 1.22e-61   NR MDW0205850.1 2169593 g5502 i0 79.7 6.46478873239437 153 31 92.4 0 461 3 185 337 MDW0205850.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 3213 215 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
30739252 30739252 PRJNA432257_S_NODE_50654_length_230_cov_2.580311_g50273_i0 PRJNA432257 50654 230 2.580311 5.9347153 Nitrososphaerota archaeon 2026795 Archaea Archaea 56.6 1.11e-8   NR MDE1816776.1 2026795 g50273 i0 57.5 0.521739130434783 40 17 52.2 0 178 59 2 41 MDE1816776.1 hypothetical protein [Nitrososphaerota archaeon] diamond 120 56.6 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
31940614 31940614 PRJNA432257_S_NODE_90797_length_183_cov_85.383562_g90416_i0 PRJNA432257 90797 183 85.383562 156.25191846 Candidatus Nitrosotenuis sp. 2507556 Archaea Archaea 42.7 0.0162   NR MBM2852262.1 2507556 g90416 i0 50 0.852459016393443 52 26 85.2 0 171 16 150 201 MBM2852262.1 hypothetical protein [Candidatus Nitrosotenuis sp.] diamond 156 42.7 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis sp.
32573808 32573808 PRJNA432257_S_NODE_48899_length_233_cov_2.566327_g48518_i0 PRJNA432257 48899 233 2.566327 5.97954191 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 111 1.54e-28   NR MDW0164215.1 2169593 g48518 i0 91.5 0.759656652360515 59 5 76 0 214 38 137 195 MDW0164215.1 50S ribosomal protein L18 [Nitrososphaeraceae archaeon] diamond 177 111 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);;