RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJEB20058" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJEB20058 · 12 ✖

analysis 1

  • blastn · 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
25514238 25514238 PRJEB20058_P_NODE_13353_length_1134_cov_65.053122_g11658_i0 PRJEB20058 13353 1134 65.053122 737.70240348 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 1018 0   NTclustered gi|937513727|gb|CP012850.1| 1353260 g11658 i0 83.228 0.977954144620811 1109 186 98 0 24 1132 2028736 2029844 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 1109 1018 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
25518031 25518031 PRJEB20058_P_NODE_221657_length_241_cov_6.188889_g218832_i0 PRJEB20058 221657 241 6.188889 14.91522249 Nitrosarchaeum sp. AC2 2259673 Archaea Archaea 263 9.21e-66   NTclustered gi|1869229208|gb|CP030847.1| 2259673 g218832 i0 89.806 1.72614107883817 206 20 85 1 12 216 432705 432910 Nitrosarchaeum sp. AC2 chromosome, complete genome blastn 416 263 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp. AC2
25748388 25748388 PRJEB20058_P_NODE_117418_length_369_cov_11.782468_g114603_i0 PRJEB20058 117418 369 11.782468 43.47730692 Candidatus Nitrosotenuis 1825023 Archaea Archaea 446 1.38e-120   NTclustered gi|2551106379|gb|CP130341.1| 1353246 g114603 i0 89.714 1.84823848238482 350 34 95 2 1 349 1544970 1545318 Candidatus Nitrosotenuis chungbukensis strain MY2 chromosome, complete genome blastn 682 446 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis chungbukensis
25926951 25926951 PRJEB20058_P_NODE_244940_length_205_cov_4.618056_g242115_i0 PRJEB20058 244940 205 4.618056 9.4670148 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 337 4.41e-88   NTclustered gi|937513727|gb|CP012850.1| 1353260 g242115 i0 99.459 17.0682926829268 185 1 90 0 1 185 848226 848042 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 3499 337 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
25927482 25927482 PRJEB20058_P_NODE_31236_length_750_cov_44.313498_g3170_i3 PRJEB20058 31236 750 44.313498 332.351235 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 1175 0   NTclustered gi|937513727|gb|CP012850.1| 1353260 g3170 i3 99.689 83.8666666666667 643 1 86 1 109 750 850703 850061 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 62900 1175 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
25929183 25929183 PRJEB20058_P_NODE_6204_length_1733_cov_11.521531_g5161_i0 PRJEB20058 6204 1733 11.521531 199.66813223 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 2268 0   NTclustered gi|937513727|gb|CP012850.1| 1353260 g5161 i0 90.824 2.86035776110791 1700 148 98 7 18 1711 825708 827405 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 4957 2268 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
26294623 26294623 PRJEB20058_P_NODE_3886_length_2342_cov_32.939939_g3170_i0 PRJEB20058 3886 2342 32.939939 771.45337138 Candidatus Nitrosocosmicus 1826864 Archaea Archaea 4037 0   NTclustered gi|937513727|gb|CP012850.1| 1353260 g3170 i0 98.103 98.4910333048676 2320 41 99 3 1 2319 850565 848248 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 230666 4037 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
26330726 26330726 PRJEB20058_P_NODE_137071_length_333_cov_37.091912_g134250_i0 PRJEB20058 137071 333 37.091912 123.51606696 Candidatus Nitrosocosmicus franklandus 1826864 Archaea Archaea 228 4.8599999999999986e-55   NTclustered gi|1599533355|emb|LR216287.1| 1798806 g134250 i0 84.783 1.87987987987988 230 31 68 4 98 325 1948275 1948502 Candidatus Nitrosocosmicus franklandus isolate NFRAN1 genome assembly, chromosome: NFRAN blastn 626 228 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus franklandianus
26337186 26337186 PRJEB20058_P_NODE_58871_length_546_cov_6.400000_g56116_i0 PRJEB20058 58871 546 6.4 34.944 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 758 0   NTclustered gi|937513727|gb|CP012850.1| 1353260 g56116 i0 93.529 0.934065934065934 510 31 93 2 23 532 835971 835464 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 510 758 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
26338996 26338996 PRJEB20058_P_NODE_95415_length_418_cov_55.927171_g92613_i0 PRJEB20058 95415 418 55.927171 233.77557478 Candidatus Nitrosocosmicus franklandus 1826864 Archaea Archaea 422 2.66e-113   NTclustered gi|1599533355|emb|LR216287.1| 1798806 g92613 i0 86.005 25.9760765550239 393 55 94 0 24 416 454887 454495 Candidatus Nitrosocosmicus franklandus isolate NFRAN1 genome assembly, chromosome: NFRAN blastn 10858 422 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus franklandianus
26466879 26466879 PRJEB20058_P_NODE_13480_length_1129_cov_50.129213_g11781_i0 PRJEB20058 13480 1129 50.129213 565.95881477 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 1168 0   NTclustered gi|937513727|gb|CP012850.1| 1353260 g11781 i0 86.606 1.27635075287865 1090 106 96 18 24 1107 345517 344462 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 1441 1168 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
26566642 26566642 PRJEB20058_P_NODE_3888_length_2341_cov_34.270175_g3170_i1 PRJEB20058 3888 2341 34.270175 802.26479675 Candidatus Nitrosocosmicus 1826864 Archaea Archaea 4148 0   NTclustered gi|937513727|gb|CP012850.1| 1353260 g3170 i1 98.965 98.7970952584366 2319 22 99 2 24 2341 848248 850565 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 231284 4148 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);;