RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA704949" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 15 ✖

bioproject 1

  • PRJNA704949 · 15 ✖

analysis 1

  • blastn · 15 ✖

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
1962280 1962280 PRJNA704949_P_NODE_1038182_length_254_cov_2.029268_g1022846_i0 PRJNA704949 1038182 254 2.029268 5.15434072 uncultured crenarchaeote 29281 Archaea Archaea 444 3.26e-120   NTclustered gi|42557759|emb|AJ627422.1| 29281 g1022846 i0 98.413 101.846456692913 252 4 99 0 3 254 42271 42522 Uncultured crenarchaeote genomic fragment 54d9 blastn 25869 444 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
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
7066395 7066395 PRJNA704949_P_NODE_1227986_length_229_cov_1.155556_g1212649_i0 PRJNA704949 1227986 229 1.155556 2.64622324 Pyrobaculum aerophilum 13773 Archaea Archaea 383 6.38e-102   NTclustered gi|18308975|gb|AE009441.1| 178306 g1212649 i0 99.061 5.04803493449782 213 2 93 0 17 229 303641 303853 Pyrobaculum aerophilum str. IM2, complete genome blastn 1156 383 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum aerophilum
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
10906434 10906434 PRJNA704949_P_NODE_979089_length_264_cov_0.967442_g963754_i0 PRJNA704949 979089 264 0.967442 2.55404688 uncultured crenarchaeote 29281 Archaea Archaea 311 3.6e-80   NTclustered gi|22797874|emb|AJ496176.1| 29281 g963754 i0 87.97 19.5378787878788 266 28 100 4 1 264 7442 7705 Uncultured crenarchaeote 34 kb genomic fragment blastn 5158 311 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
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
22866835 22866835 PRJNA704949_P_NODE_449918_length_406_cov_1.747899_g434721_i0 PRJNA704949 449918 406 1.747899 7.09646994 Candidatus Bathyarchaeum 3072969 Archaea Archaea 52.8 0.039   NTclustered gi|2591952183|gb|CP060866.1| 2026714 g434721 i0 100 0.137931034482759 28 0 7 0 238 265 1852957 1852984 MAG: Candidatus Bathyarchaeota archaeon isolate SV2 chromosome, complete genome blastn 56 52.8 1 Archaea   Thermoproteati Candidatus Bathyarchaeota         Candidatus Bathyarchaeota archaeon
24921696 24921696 PRJNA704949_P_NODE_2165420_length_162_cov_0.920354_g2150081_i0 PRJNA704949 2165420 162 0.920354 1.49097348 Acidianus sulfidivorans 312539 Archaea Archaea 52.8 0.013   NTclustered gi|1820310478|gb|CP029288.2| 619593 g2150081 i0 96.774 0.191358024691358 31 1 19 0 113 143 1379992 1380022 Acidianus sulfidivorans JP7 chromosome, complete genome blastn 31 52.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Acidianus Acidianus sulfidivorans

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