RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA884104", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 12 ✖

tax_phylum 1

  • Nitrososphaerota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA884104 · 12 ✖

analysis 1

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
26683375 26683375 PRJNA884104_S_NODE_39001_length_331_cov_1.000000_g38258_i0 PRJNA884104 39001 331 1 3.31 root 1 Root_unresolved Root_unresolved 105 9.449999999999999e-25   NR HXW37693.1 2268197 g38258 i0 57 2.72809667673716 100 41 88.8 1 35 328 67 166 HXW37693.1 ornithine cyclodeaminase family protein [Nitrososphaerales archaeon] diamond 903 105 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales     Nitrososphaerales archaeon
26960339 26960339 PRJNA884104_S_NODE_80902_length_244_cov_0.900585_g80159_i0 PRJNA884104 80902 244 0.900585 2.1974274 Candidatus Nitrosotenuis sp. 2507556 Archaea Archaea 67.4 5.43e-11   NR HSA98962.1 2507556 g80159 i0 46.6 0.897540983606557 73 39 89.8 0 12 230 74 146 HSA98962.1 hypothetical protein [Candidatus Nitrosotenuis sp.] diamond 219 67.4 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis sp.
27087136 27087136 PRJNA884104_S_NODE_70762_length_250_cov_0.870056_g70019_i0 PRJNA884104 70762 250 0.870056 2.17514 Candidatus Nitrosocaldaceae archaeon 2838776 Archaea Archaea 66.6 1.51e-10   NR GIU70885.1 2838776 g70019 i0 63.8 0.564 47 17 56.4 0 3 143 194 240 GIU70885.1 MAG: hypothetical protein KatS3mg003_0364 [Candidatus Nitrosocaldaceae archaeon] diamond 141 66.6 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Candidatus Nitrosocaldales Candidatus Nitrosocaldaceae   Candidatus Nitrosocaldaceae archaeon
29171336 29171336 PRJNA884104_S_NODE_16109_length_501_cov_1.331776_g15371_i0 PRJNA884104 16109 501 1.331776 6.67219776 Nitrosopumilus sp. 2024843 Archaea Archaea 72.8 1.95e-11   NR MDH3277049.1 2024843 g15371 i0 47.7 0.514970059880239 86 45 51.5 0 244 501 394 479 MDH3277049.1 hypothetical protein [Nitrosopumilus sp.] diamond 258 72.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
29360750 29360750 PRJNA884104_S_NODE_68489_length_251_cov_0.865169_g67746_i0 PRJNA884104 68489 251 0.865169 2.17157419 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 52.8 8.26e-7   NR MDF2737902.1 2169593 g67746 i0 49 0.609561752988048 51 26 61 0 207 55 5 55 MDF2737902.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 153 52.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
29423617 29423617 PRJNA884104_S_NODE_60809_length_268_cov_1.184615_g60066_i0 PRJNA884104 60809 268 1.184615 3.1747682 Candidatus Nitrosocaldaceae archaeon 2838776 Archaea Archaea 60.5 2.6e-8   NR MEM4322925.1 2838776 g60066 i0 60.5 0.962686567164179 43 17 48.1 0 266 138 324 366 MEM4322925.1 hypothetical protein [Candidatus Nitrosocaldaceae archaeon] diamond 258 60.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Candidatus Nitrosocaldales Candidatus Nitrosocaldaceae   Candidatus Nitrosocaldaceae archaeon
29549926 29549926 PRJNA884104_S_NODE_26430_length_395_cov_1.586957_g25687_i0 PRJNA884104 26430 395 1.586957 6.26848015 Candidatus Geocrenenecus arthurdayi 2978060 Archaea Archaea 67 2.56e-10   NR MCL7388697.1 2978060 g25687 i0 37.3 0.774683544303797 102 60 77.5 3 66 371 25 122 MCL7388697.1 hypothetical protein [Candidatus Geocrenenecus arthurdayi] diamond 306 67 1 Archaea   Thermoproteati Nitrososphaerota     Candidatus Wolframiiraptoraceae Candidatus Geocrenenecus Candidatus Geocrenenecus arthurdayi
31604113 31604113 PRJNA884104_S_NODE_82536_length_243_cov_0.905882_g81793_i0 PRJNA884104 82536 243 0.905882 2.20129326 Nitrososphaerales archaeon 2268197 Archaea Archaea 65.5 3.3e-10   NR MFI5423023.1 2268197 g81793 i0 35.9 0.962962962962963 78 50 96.3 0 2 235 215 292 MFI5423023.1 hypothetical protein [Nitrososphaerales archaeon] diamond 234 65.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales     Nitrososphaerales archaeon
31667190 31667190 PRJNA884104_S_NODE_38317_length_333_cov_1.715385_g37574_i0 PRJNA884104 38317 333 1.715385 5.71223205 Nitrososphaerota archaeon 2026795 Archaea Archaea 50.8 1.44e-4   NR MDE1852183.1 2026795 g37574 i0 46.9 0.441441441441441 49 26 44.1 0 68 214 93 141 MDE1852183.1 aromatic amino acid lyase [Nitrososphaerota archaeon] diamond 147 50.8 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
31793614 31793614 PRJNA884104_S_NODE_66137_length_256_cov_1.092896_g65394_i0 PRJNA884104 66137 256 1.092896 2.79781376 Candidatus Nitrosocaldaceae archaeon 2838776 Archaea Archaea 61.2 1.29e-8   NR GIU70885.1 2838776 g65394 i0 52.6 1.32421875 57 26 66.8 1 254 84 181 236 GIU70885.1 MAG: hypothetical protein KatS3mg003_0364 [Candidatus Nitrosocaldaceae archaeon] diamond 339 61.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Candidatus Nitrosocaldales Candidatus Nitrosocaldaceae   Candidatus Nitrosocaldaceae archaeon
31856963 31856963 PRJNA884104_S_NODE_23517_length_418_cov_0.936232_g22774_i0 PRJNA884104 23517 418 0.936232 3.9134497600000002 Nitrososphaerota archaeon 2026795 Archaea Archaea 129 1.19e-32   NR MBI1828022.1 2026795 g22774 i0 50.4 2.69138755980861 125 51 89.7 1 30 404 127 240 MBI1828022.1 multicopper oxidase domain-containing protein [Nitrososphaerota archaeon] diamond 1125 129 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
32899443 32899443 PRJNA884104_S_NODE_62340_length_264_cov_1.612565_g61597_i0 PRJNA884104 62340 264 1.612565 4.2571716 Nitrososphaerota archaeon 2026795 Archaea Archaea 78.2 1.61e-14   NR RLG04369.1 2026795 g61597 i0 50.7 1.71590909090909 73 36 83 0 234 16 430 502 RLG04369.1 MAG: hypothetical protein DRN68_09895, partial [Nitrososphaerota archaeon] diamond 453 78.2 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon

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