RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA315399" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA315399 · 13 ✖

analysis 1

  • blastn · 13 ✖

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
384570 384570 PRJNA315399_S_NODE_153621_length_160_cov_2.073171_g153420_i0 PRJNA315399 153621 160 2.073171 3.3170736 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 239 9.49e-59   NTclustered gi|937513727|gb|CP012850.1| 1353260 g153420 i0 97.163 0.88125 141 4 88 0 1 141 442352 442212 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 141 239 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
1659589 1659589 PRJNA315399_S_NODE_19602_length_282_cov_2.383673_g19401_i0 PRJNA315399 19602 282 2.383673 6.72195786 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 475 1.2999999999999999e-129   NTclustered gi|937513727|gb|CP012850.1| 1353260 g19401 i0 99.24 0.932624113475177 263 2 93 0 1 263 748967 748705 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 263 475 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
2936214 2936214 PRJNA315399_S_NODE_71863_length_195_cov_1.436709_g71662_i0 PRJNA315399 71863 195 1.436709 2.80158255 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 344 2.48e-90   NTclustered gi|937513727|gb|CP012850.1| 1353260 g71662 i0 99.471 0.969230769230769 189 1 97 0 1 189 2436250 2436062 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 189 344 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
4209263 4209263 PRJNA315399_P_NODE_231024_length_183_cov_2.993151_g230576_i0 PRJNA315399 231024 183 2.993151 5.47746633 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 130 7e-26   NTclustered gi|937513727|gb|CP012850.1| 1353260 g230576 i0 100 0.73224043715847 70 0 73 0 17 86 2585230 2585299 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 134 130 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
4211184 4211184 PRJNA315399_P_NODE_75344_length_214_cov_3.971751_g74896_i0 PRJNA315399 75344 214 3.971751 8.49954714 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 167 6.449999999999999e-37   NTclustered gi|937513727|gb|CP012850.1| 1353260 g74896 i0 97 0.901869158878505 100 2 46 1 108 206 672541 672442 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 193 167 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
5488111 5488111 PRJNA315399_S_NODE_142785_length_163_cov_2.039683_g142584_i0 PRJNA315399 142785 163 2.039683 3.32468329 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 302 1.22e-77   NTclustered gi|937513727|gb|CP012850.1| 1353260 g142584 i0 100 1 163 0 100 0 1 163 748257 748095 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 163 302 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
6763081 6763081 PRJNA315399_S_NODE_55226_length_209_cov_3.308140_g55025_i0 PRJNA315399 55226 209 3.30814 6.9140126 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 309 9.85e-80   NTclustered gi|937513727|gb|CP012850.1| 1353260 g55025 i0 93.301 3.02392344497608 209 14 100 0 1 209 2091967 2091759 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 632 309 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
8036089 8036089 PRJNA315399_P_NODE_380467_length_164_cov_2.708661_g380019_i0 PRJNA315399 380467 164 2.708661 4.44220404 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 115 1.72e-21   NTclustered gi|937513727|gb|CP012850.1| 1353260 g380019 i0 94.667 0.457317073170732 75 3 45 1 4 77 431333 431259 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 75 115 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
9312583 9312583 PRJNA315399_S_NODE_149488_length_161_cov_2.516129_g149287_i0 PRJNA315399 149488 161 2.516129 4.05096769 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 298 1.56e-76   NTclustered gi|937513727|gb|CP012850.1| 1353260 g149287 i0 100 1 161 0 100 0 1 161 813184 813344 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 161 298 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
14414629 14414629 PRJNA315399_S_NODE_75432_length_192_cov_3.974194_g75231_i0 PRJNA315399 75432 192 3.974194 7.63045248 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 161 2.6299999999999997e-35   NTclustered gi|808354332|gb|CP011097.2| 1603555 g75231 i0 81.771 1 192 35 100 0 1 192 386286 386095 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 192 161 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
22058243 22058243 PRJNA315399_P_NODE_190698_length_185_cov_6.959459_g190250_i0 PRJNA315399 190698 185 6.959459 12.87499915 Nitrosopumilus oxyclinae 1959104 Archaea Archaea 122 1.19e-23   NTclustered gi|1869222960|gb|CP026994.1| 1959104 g190250 i0 96 2.0972972972973 75 3 76 0 99 173 13485 13559 Nitrosopumilus oxyclinae strain HCE1 chromosome, complete genome blastn 388 122 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus oxyclinae
23336828 23336828 PRJNA315399_S_NODE_188119_length_152_cov_2.521739_g187918_i0 PRJNA315399 188119 152 2.521739 3.83304328 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 252 1.1399999999999999e-62   NTclustered gi|937513727|gb|CP012850.1| 1353260 g187918 i0 100 1.54605263157895 136 0 89 0 17 152 2153608 2153473 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 235 252 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
24611952 24611952 PRJNA315399_S_NODE_82920_length_187_cov_6.420000_g82719_i0 PRJNA315399 82920 187 6.42 12.0054 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 333 5.1e-87   NTclustered gi|937513727|gb|CP012850.1| 1353260 g82719 i0 100 1.13368983957219 180 0 96 0 1 180 2872179 2872000 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 212 333 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus

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