RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA704949" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA704949 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
692496 692496 PRJNA704949_P_NODE_1822401_length_176_cov_1.228346_g1807062_i0 PRJNA704949 1822401 176 1.228346 2.16188896 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 292 8.04e-75   NTclustered gi|937513727|gb|CP012850.1| 1353260 g1807062 i0 96.591 1 176 6 100 0 1 176 1806081 1806256 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 176 292 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
5799126 5799126 PRJNA704949_P_NODE_2212325_length_151_cov_2.176471_g2196986_i0 PRJNA704949 2212325 151 2.176471 3.28647121 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 220 3.19e-53   NTclustered gi|937513727|gb|CP012850.1| 1353260 g2196986 i0 93.289 7.83443708609272 149 10 99 0 3 151 2984507 2984655 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 1183 220 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
7080973 7080973 PRJNA704949_P_NODE_967606_length_265_cov_4.268519_g952271_i0 PRJNA704949 967606 265 4.268519 11.31157535 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 446 9.51e-121   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g952271 i0 99.59 1.84150943396226 244 1 92 0 22 265 1441998 1441755 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 488 446 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
8840157 8840157 PRJNA704949_P_NODE_1706147_length_184_cov_2.177778_g1690808_i0 PRJNA704949 1706147 184 2.177778 4.00711152 Nitrososphaera 497726 Archaea Archaea 119 1.53e-22   NTclustered gi|647810480|gb|CP007536.1| 926571 g1690808 i0 79.31 3.79891304347826 174 33 93 1 11 181 2320300 2320127 Nitrososphaera viennensis EN76, complete genome blastn 699 119 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera viennensis
8841901 8841901 PRJNA704949_P_NODE_322847_length_475_cov_1.575117_g307954_i0 PRJNA704949 322847 475 1.575117 7.48180575 Nitrososphaera 497726 Archaea Archaea 588 2.849999999999999e-163   NTclustered gi|300521484|gb|GU797787.1| 497727 g307954 i0 89.316 40.0736842105263 468 50 99 0 1 468 940 473 Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence blastn 19035 588 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Candidatus Nitrososphaera gargensis
14717457 14717457 PRJNA704949_P_NODE_1311472_length_219_cov_2.023529_g1296135_i0 PRJNA704949 1311472 219 2.023529 4.43152851 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 377 2.81e-100   NTclustered gi|937513727|gb|CP012850.1| 1353260 g1296135 i0 97.717 1 219 5 100 0 1 219 2122576 2122794 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 219 377 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
14724761 14724761 PRJNA704949_P_NODE_248912_length_533_cov_2.407025_g234368_i0 PRJNA704949 248912 533 2.407025 12.82944325 Candidatus Nitrososphaera evergladensis 1459637 Archaea Archaea 73.1 4.02e-8   NTclustered gi|665992324|gb|CP007174.1| 1459636 g234368 i0 80.645 0.294559099437148 93 18 17 0 404 496 1288175 1288267 Candidatus Nitrososphaera evergladensis SR1, complete genome blastn 157 73.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Candidatus Nitrososphaera evergladensis
17276908 17276908 PRJNA704949_P_NODE_572154_length_359_cov_2.312903_g556841_i0 PRJNA704949 572154 359 2.312903 8.30332177 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 337 8.379999999999997e-88   NTclustered gi|937513727|gb|CP012850.1| 1353260 g556841 i0 83.565 1 359 59 100 0 1 359 3360898 3360540 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 359 337 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
17279487 17279487 PRJNA704949_P_NODE_863754_length_284_cov_4.544681_g848420_i0 PRJNA704949 863754 284 4.544681 12.90689404 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 324 5.03e-84   NTclustered gi|808354332|gb|CP011097.2| 1603555 g848420 i0 90.323 1.75352112676056 248 22 87 2 20 266 96078 96324 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 498 324 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
18548086 18548086 PRJNA704949_P_NODE_301355_length_490_cov_1.734694_g286548_i0 PRJNA704949 301355 490 1.734694 8.5000006 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 712 0   NTclustered gi|937513727|gb|CP012850.1| 1353260 g286548 i0 92.857 97.8 490 35 100 0 1 490 848669 849158 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 47922 712 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);;