RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA565584", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Archaea · 16 ✖

tax_phylum 1

  • Nitrososphaerota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA565584 · 16 ✖

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
6933865 6933865 PRJNA565584_P_NODE_182286_length_248_cov_0.880000_g181134_i0 PRJNA565584 182286 248 0.88 2.1824 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 394 3.24e-105   NTclustered gi|937513727|gb|CP012850.1| 1353260 g181134 i0 95.528 0.991935483870968 246 11 99 0 1 246 813503 813748 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 246 394 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
9482845 9482845 PRJNA565584_P_NODE_111808_length_287_cov_1.350467_g110656_i0 PRJNA565584 111808 287 1.350467 3.87584029 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 58.4 5.7e-4   NTclustered gi|937513727|gb|CP012850.1| 1353260 g110656 i0 100 0.205574912891986 31 0 11 0 201 231 128547 128577 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 59 58.4 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
19682264 19682264 PRJNA565584_P_NODE_184236_length_248_cov_0.880000_g183084_i0 PRJNA565584 184236 248 0.88 2.1824 Candidatus Nitrososphaera evergladensis 1459637 Archaea Archaea 52.8 0.022   NTclustered gi|665992324|gb|CP007174.1| 1459636 g183084 i0 100 0.112903225806452 28 0 11 0 44 71 583202 583175 Candidatus Nitrososphaera evergladensis SR1, complete genome blastn 28 52.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Candidatus Nitrososphaera evergladensis
25361496 25361496 PRJNA565584_P_NODE_51560_length_414_cov_1.862170_g50409_i0 PRJNA565584 51560 414 1.86217 7.7093838 Nitrososphaera 497726 Archaea Archaea 52.8 0.04   NTclustered gi|647810480|gb|CP007536.1| 926571 g50409 i0 100 0.202898550724638 28 0 7 0 159 186 2040378 2040351 Nitrososphaera viennensis EN76, complete genome blastn 84 52.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera viennensis
26794534 26794534 PRJNA565584_P_NODE_107221_length_290_cov_1.230415_g106069_i0 PRJNA565584 107221 290 1.230415 3.5682035 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 181 6.529999999999999e-52   NR MDF3032434.1 2169593 g106069 i0 95.8 0.993103448275862 96 4 99.3 0 289 2 268 363 MDF3032434.1 thsA [Nitrososphaeraceae archaeon] diamond 288 181 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
26952594 26952594 PRJNA565584_P_NODE_117982_length_283_cov_1.447619_g116830_i0 PRJNA565584 117982 283 1.447619 4.09676177 Nitrososphaera sp. 1971748 Archaea Archaea 164 5.3299999999999996e-46   NR HEU0144281.1 1971748 g116830 i0 80.9 0.996466431095406 94 18 99.6 0 283 2 66 159 HEU0144281.1 hypothetical protein [Nitrososphaera sp.] diamond 282 164 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
27395630 27395630 PRJNA565584_P_NODE_136963_length_271_cov_1.247475_g135811_i0 PRJNA565584 136963 271 1.247475 3.38065725 Nitrososphaera sp. 1971748 Archaea Archaea 109 1.06e-25   NR HEU0143824.1 1971748 g135811 i0 63.3 0.996309963099631 90 33 99.6 0 270 1 70 159 HEU0143824.1 hypothetical protein [Nitrososphaera sp.] diamond 270 109 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
27395641 27395641 PRJNA565584_P_NODE_153703_length_260_cov_1.235294_g152551_i0 PRJNA565584 153703 260 1.235294 3.2117644 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 99 8.919999999999999e-23   NR HEX6646447.1 2169593 g152551 i0 62.3 2.65384615384615 77 29 88.8 0 25 255 59 135 HEX6646447.1 SDR family oxidoreductase [Nitrososphaeraceae archaeon] diamond 690 99 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
27553050 27553050 PRJNA565584_P_NODE_131824_length_274_cov_1.532338_g130672_i0 PRJNA565584 131824 274 1.532338 4.19860612 Nitrososphaerota archaeon 2026795 Archaea Archaea 66.6 2.13e-10   NR NDF25693.1 2026795 g130672 i0 33.3 1.90510948905109 87 58 95.3 0 6 266 939 1025 NDF25693.1 transposon Pol polyprotein [Nitrososphaerota archaeon] diamond 522 66.6 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
28279406 28279406 PRJNA565584_P_NODE_77566_length_337_cov_2.484848_g76415_i0 PRJNA565584 77566 337 2.484848 8.37393776 Nitrososphaera sp. 1971748 Archaea Archaea 84.3 2.64e-16   NR HEU0144848.1 1971748 g76415 i0 52.2 1.64688427299703 90 35 73 2 92 337 3 92 HEU0144848.1 hypothetical protein [Nitrososphaera sp.] diamond 555 84.3 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
30427384 30427384 PRJNA565584_P_NODE_197293_length_245_cov_0.895349_g196141_i0 PRJNA565584 197293 245 0.895349 2.19360505 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 148 5.699999999999998e-43   NR MCJ7636867.1 2169593 g196141 i0 93.8 0.991836734693878 81 5 99.2 0 2 244 51 131 MCJ7636867.1 exosome complex RNA-binding protein Csl4 [Nitrososphaeraceae archaeon] diamond 243 148 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
30647864 30647864 PRJNA565584_P_NODE_212253_length_241_cov_1.833333_g211101_i0 PRJNA565584 212253 241 1.833333 4.41833253 Nitrososphaerota archaeon 2026795 Archaea Archaea 73.2 6.79e-13   NR MBI3641130.1 2026795 g211101 i0 49.3 1.86721991701245 75 34 93.4 1 238 14 173 243 MBI3641130.1 hypothetical protein [Nitrososphaerota archaeon] diamond 450 73.2 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
31009298 31009298 PRJNA565584_P_NODE_132234_length_274_cov_1.293532_g131082_i0 PRJNA565584 132234 274 1.293532 3.54427768 root 1 Root_unresolved Root_unresolved 157 6.69e-46   NR HEU0144910.1 1971748 g131082 i0 89.2 2.89051094890511 83 9 90.9 0 26 274 1 83 HEU0144910.1 DNA polymerase [Nitrososphaera sp.] diamond 792 157 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
31547001 31547001 PRJNA565584_P_NODE_180576_length_248_cov_1.702857_g179424_i0 PRJNA565584 180576 248 1.702857 4.22308536 Thermoproteati 1783275 Archaea Archaea 42.4 0.0451   NR HEY8140353.1 1971748 g179424 i0 28 7.39112903225806 82 57 99.2 1 246 1 6 85 HEY8140353.1 hypothetical protein [Nitrososphaera sp.] diamond 1833 42.7 0.992974238875878 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
31704994 31704994 PRJNA565584_P_NODE_73337_length_347_cov_1.401460_g72186_i0 PRJNA565584 73337 347 1.40146 4.8630662 root 1 Root_unresolved Root_unresolved 105 4.07e-24   NR MDH3677626.1 2024843 g72186 i0 42.9 9.04322766570605 112 59 94.2 3 11 337 150 259 MDH3677626.1 MBL fold metallo-hydrolase [Nitrosopumilus sp.] diamond 3138 105 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
32765935 32765935 PRJNA565584_P_NODE_168740_length_251_cov_0.865169_g167588_i0 PRJNA565584 168740 251 0.865169 2.17157419 Nitrososphaera sp. 1971748 Archaea Archaea 155 2.73e-45   NR HEU0144910.1 1971748 g167588 i0 87.8 0.9800796812749 82 10 98 0 247 2 146 227 HEU0144910.1 DNA polymerase [Nitrososphaera sp.] diamond 246 155 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.

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