RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA1240804", 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

  • PRJNA1240804 · 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
8001569 8001569 PRJNA1240804_P_NODE_41967_length_233_cov_2.467391_g41601_i0 PRJNA1240804 41967 233 2.467391 5.74902103 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 405 1.39e-108   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g41601 i0 100 26.3991416309013 219 0 94 0 1 219 1790464 1790246 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 6151 405 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
10552623 10552623 PRJNA1240804_P_NODE_58149_length_207_cov_2.063291_g57783_i0 PRJNA1240804 58149 207 2.063291 4.27101237 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 344 2.67e-90   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g57783 i0 98.958 13.9710144927536 192 2 93 0 15 206 1792025 1792216 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 2892 344 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
14378211 14378211 PRJNA1240804_P_NODE_87932_length_181_cov_1.454545_g87566_i0 PRJNA1240804 87932 181 1.454545 2.63272645 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 305 1.07e-78   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g87566 i0 100 8.1491712707182309 165 0 91 0 15 179 1790848 1791012 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 1475 305 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
16352442 16352442 PRJNA1240804_P_NODE_137933_length_164_cov_0.904348_g137567_i0 PRJNA1240804 137933 164 0.904348 1.48313072 Nitrososphaera 497726 Archaea Archaea 252 1.26e-62   NTclustered gi|300521484|gb|GU797787.1| 497727 g137567 i0 95 41.609756097561 160 8 98 0 5 164 1693 1852 Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence blastn 6824 252 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Candidatus Nitrososphaera gargensis
18901961 18901961 PRJNA1240804_P_NODE_92755_length_178_cov_1.294574_g92389_i0 PRJNA1240804 92755 178 1.294574 2.30434172 Candidatus Nitrosocosmicus 1826864 Archaea Archaea 292 8.15e-75   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g92389 i0 98.78 17.4101123595506 164 2 92 0 15 178 1789689 1789852 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 3099 292 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
26788775 26788775 PRJNA1240804_P_NODE_137761_length_164_cov_0.904348_g137395_i0 PRJNA1240804 137761 164 0.904348 1.48313072 Nitrososphaerota archaeon 2026795 Archaea Archaea 45.1 0.00196   NR MDE1830385.1 2026795 g137395 i0 53.7 0.75 41 18 75 1 127 5 446 485 MDE1830385.1 hypothetical protein [Nitrososphaerota archaeon] diamond 123 45.1 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
29852380 29852380 PRJNA1240804_P_NODE_103971_length_171_cov_1.098361_g103605_i0 PRJNA1240804 103971 171 1.098361 1.87819731 Nitrososphaerales archaeon 2268197 Archaea Archaea 44.7 0.00307   NR HEY6282824.1 2268197 g103605 i0 42.3 0.912280701754386 52 30 91.2 0 7 162 732 783 HEY6282824.1 reverse transcriptase domain-containing protein [Nitrososphaerales archaeon] diamond 156 44.7 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales     Nitrososphaerales archaeon
30295090 30295090 PRJNA1240804_P_NODE_31992_length_259_cov_1.733333_g31626_i0 PRJNA1240804 31992 259 1.733333 4.48933247 Nitrososphaerales archaeon 2268197 Archaea Archaea 143 1.73e-39   NR MFI5423128.1 2268197 g31626 i0 84.6 0.903474903474903 78 12 90.3 0 14 247 25 102 MFI5423128.1 hypothetical protein [Nitrososphaerales archaeon] diamond 234 143 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales     Nitrososphaerales archaeon
31545563 31545563 PRJNA1240804_P_NODE_42416_length_232_cov_3.196721_g42050_i0 PRJNA1240804 42416 232 3.196721 7.41639272 root 1 Root_unresolved Root_unresolved 119 2.07e-31   NR MCI0564163.1 1971748 g42050 i0 72.6 6.55603448275862 73 20 94.4 0 231 13 67 139 MCI0564163.1 nucleoside 2-deoxyribosyltransferase [Nitrososphaera sp.] diamond 1521 119 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
32223256 32223256 PRJNA1240804_P_NODE_147618_length_162_cov_0.920354_g147252_i0 PRJNA1240804 147618 162 0.920354 1.49097348 Nitrososphaeria archaeon 2268198 Archaea Archaea 92.4 6.560000000000001e-21   NR NDF30488.1 2268198 g147252 i0 90.4 0.962962962962963 52 5 96.3 0 157 2 21 72 NDF30488.1 hypothetical protein [Nitrososphaeria archaeon] diamond 156 92.4 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria       Nitrososphaeria archaeon
32349989 32349989 PRJNA1240804_P_NODE_53399_length_214_cov_1.169697_g53033_i0 PRJNA1240804 53399 214 1.169697 2.50315158 Nitrososphaeria archaeon 2268198 Archaea Archaea 64.3 5.2e-10   NR NIM44033.1 2268198 g53033 i0 48.2 0.785046728971963 56 29 78.5 0 172 5 243 298 NIM44033.1 hypothetical protein [Nitrososphaeria archaeon] diamond 168 64.3 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria       Nitrososphaeria archaeon
32381483 32381483 PRJNA1240804_P_NODE_138779_length_164_cov_0.904348_g138413_i0 PRJNA1240804 138779 164 0.904348 1.48313072 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 93.2 1.37e-20   NR WP_148686069.1 1826872 g138413 i0 97.8 2.46951219512195 45 1 82.3 0 137 3 69 113 WP_148686069.1 metallophosphoesterase family protein [Candidatus Nitrosocosmicus hydrocola] diamond 405 93.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola

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