RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 21 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB64798 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
16703953 16703953 PRJEB64798_P_NODE_160294_length_183_cov_4.597015_g158528_i0 PRJEB64798 160294 183 4.597015 8.41253745 Nitrososphaerales archaeon 2268197 Archaea Archaea 58.5 1.82e-8   NR HIC84428.1 2268197 g158528 i0 40.4 0.934426229508197 57 32 93.4 1 173 3 102 156 HIC84428.1 hypothetical protein [Nitrososphaerales archaeon] diamond 171 58.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales     Nitrososphaerales archaeon
26685595 26685595 PRJEB64798_P_NODE_93781_length_212_cov_4.773006_g92015_i0 PRJEB64798 93781 212 4.773006 10.11877272 Nitrosopumilaceae archaeon 2202732 Archaea Archaea 98.2 5.300000000000001e-22   NR NDF36076.1 2202732 g92015 i0 76.4 1.0188679245283 72 13 96.2 1 206 3 36 107 NDF36076.1 hypothetical protein [Nitrosopumilaceae archaeon] diamond 216 98.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae   Nitrosopumilaceae archaeon
26780662 26780662 PRJEB64798_P_NODE_179861_length_174_cov_5.960000_g178095_i0 PRJEB64798 179861 174 5.96 10.3704 Nitrososphaera sp. 1971748 Archaea Archaea 41.2 0.0499   NR HEU0047079.1 1971748 g178095 i0 46.5 0.741379310344828 43 23 74.1 0 45 173 166 208 HEU0047079.1 hypothetical protein [Nitrososphaera sp.] diamond 129 41.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
26812227 26812227 PRJEB64798_P_NODE_157881_length_184_cov_7.118519_g156115_i0 PRJEB64798 157881 184 7.118519 13.09807496 Nitrosopumilus sp. 2024843 Archaea Archaea 47.4 3.84e-4   NR MEK0325388.1 2024843 g156115 i0 37.9 1.85869565217391 58 36 94.6 0 179 6 298 355 MEK0325388.1 hypothetical protein [Nitrosopumilus sp.] diamond 342 47.4 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
26907141 26907141 PRJEB64798_P_NODE_145802_length_190_cov_8.553191_g144036_i0 PRJEB64798 145802 190 8.553191 16.2510629 Nitrosopumilaceae archaeon 2202732 Archaea Archaea 73.2 2.76e-15   NR MCE2507654.1 2202732 g144036 i0 71.7 0.726315789473684 46 13 72.6 0 45 182 1 46 MCE2507654.1 hypothetical protein [Nitrosopumilaceae archaeon] diamond 138 73.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae   Nitrosopumilaceae archaeon
27508008 27508008 PRJEB64798_P_NODE_244083_length_154_cov_2.066667_g242317_i0 PRJEB64798 244083 154 2.066667 3.18266718 Nitrososphaerota archaeon 2026795 Archaea Archaea 52.4 3.77e-6   NR MEM4675554.1 2026795 g242317 i0 45.8 0.935064935064935 48 26 93.5 0 10 153 108 155 MEM4675554.1 hypothetical protein [Nitrososphaerota archaeon] diamond 144 52.4 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
27602761 27602761 PRJEB64798_P_NODE_61844_length_247_cov_7.131313_g60079_i0 PRJEB64798 61844 247 7.131313 17.61434311 Nitrososphaerales archaeon 2268197 Archaea Archaea 43.1 0.00963   NR HIM82786.1 2268197 g60079 i0 39.3 0.680161943319838 56 21 52.2 2 14 142 43 98 HIM82786.1 glucose-1-phosphate cytidylyltransferase [Nitrososphaerales archaeon] diamond 168 43.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales     Nitrososphaerales archaeon
28139459 28139459 PRJEB64798_P_NODE_163225_length_182_cov_1.781955_g161459_i0 PRJEB64798 163225 182 1.781955 3.2431581 Nitrososphaerota archaeon 2026795 Archaea Archaea 45.1 0.00123   NR MDG6937788.1 2026795 g161459 i0 50 1.6978021978022 42 19 65.9 1 128 9 94 135 MDG6937788.1 hypothetical protein [Nitrososphaerota archaeon] diamond 309 45.1 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
28707774 28707774 PRJEB64798_P_NODE_47287_length_285_cov_9.559322_g45522_i0 PRJEB64798 47287 285 9.559322 27.2440677 Candidatus Nitrosotenuis sp. 2507556 Archaea Archaea 100 1.89e-25   NR HXF90819.1 2507556 g45522 i0 62.7 0.705263157894737 67 25 70.5 0 219 19 1 67 HXF90819.1 CsbD family protein [Candidatus Nitrosotenuis sp.] diamond 201 100 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis sp.
28865314 28865314 PRJEB64798_P_NODE_146468_length_190_cov_4.113475_g144702_i0 PRJEB64798 146468 190 4.113475 7.8156025 Nitrososphaera sp. 1971748 Archaea Archaea 39.7 0.0311   NR HYY40872.1 1971748 g144702 i0 41.2 0.805263157894737 51 23 72.6 2 159 22 7 55 HYY40872.1 hypothetical protein [Nitrososphaera sp.] diamond 153 39.7 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
29370609 29370609 PRJEB64798_P_NODE_119729_length_206_cov_10.050955_g117963_i0 PRJEB64798 119729 206 10.050955 20.7049673 Nitrosopumilaceae archaeon 2202732 Archaea Archaea 52 3.41e-6   NR HSB49771.1 2202732 g117963 i0 67.7 2.70873786407767 31 10 45.1 0 202 110 111 141 HSB49771.1 GNAT family N-acetyltransferase [Nitrosopumilaceae archaeon] diamond 558 52 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae   Nitrosopumilaceae archaeon
29370838 29370838 PRJEB64798_P_NODE_94129_length_212_cov_4.638037_g92363_i0 PRJEB64798 94129 212 4.638037 9.83263844 Conexivisphaerales archaeon 2910431 Archaea Archaea 52.4 9.72e-6   NR MEM3803632.1 2910431 g92363 i0 59.4 0.905660377358491 32 13 45.3 0 207 112 250 281 MEM3803632.1 aminomethyl-transferring glycine dehydrogenase subunit GcvPB [Conexivisphaerales archaeon] diamond 192 52.4 1 Archaea   Thermoproteati Nitrososphaerota Conexivisphaeria Conexivisphaerales     Conexivisphaerales archaeon
29805655 29805655 PRJEB64798_P_NODE_33231_length_342_cov_3.023891_g31474_i0 PRJEB64798 33231 342 3.023891 10.34170722 Archaea 2157 Archaea Archaea 47 0.00394   NR MEM3136810.1 2507556 g31474 i0 32.7 4.44736842105263 101 59 81.6 4 325 47 2279 2378 MEM3136810.1 hypothetical protein [Candidatus Nitrosotenuis sp.] diamond 1521 47 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis sp.
30065336 30065336 PRJEB64798_P_NODE_70892_length_229_cov_19.738889_g69127_i0 PRJEB64798 70892 229 19.738889 45.20205581 Marine Group I thaumarchaeote 2511932 Archaea Archaea 122 2.55e-30   NR NWJ43438.1 2511932 g69127 i0 72.4 10.9519650655022 76 21 99.6 0 2 229 432 507 NWJ43438.1 hypothetical protein [Marine Group I thaumarchaeote] diamond 2508 122 1 Archaea Marine Group I Thermoproteati Nitrososphaerota         Marine Group I thaumarchaeote
30507729 30507729 PRJEB64798_P_NODE_185753_length_172_cov_2.626016_g183987_i0 PRJEB64798 185753 172 2.626016 4.51674752 Nitrosopumilus sp. 2024843 Archaea Archaea 58.9 1.86e-8   NR HII04758.1 2024843 g183987 i0 54.5 1.36046511627907 44 20 76.7 0 136 5 1 44 HII04758.1 class I SAM-dependent methyltransferase [Nitrosopumilus sp.] diamond 234 58.9 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
30570647 30570647 PRJEB64798_P_NODE_199653_length_167_cov_6.881356_g197887_i0 PRJEB64798 199653 167 6.881356 11.49186452 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 57.4 6.46e-8   NR MDX1370992.1 2169593 g197887 i0 47.3 1.97604790419162 55 29 98.8 0 2 166 177 231 MDX1370992.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 330 57.4 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
30855208 30855208 PRJEB64798_P_NODE_208914_length_165_cov_1.646552_g207148_i0 PRJEB64798 208914 165 1.646552 2.7168108 Candidatus Nitrosotalea sp. TS 2341020 Archaea Archaea 53.5 6.83e-7   NR NHI04185.1 2341020 g207148 i0 53.8 0.709090909090909 39 18 70.9 0 163 47 22 60 NHI04185.1 hypothetical protein [Candidatus Nitrosotalea sp. TS] diamond 117 53.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Candidatus Nitrosotalea sp. TS
31076532 31076532 PRJEB64798_P_NODE_189615_length_170_cov_7.090909_g187849_i0 PRJEB64798 189615 170 7.090909 12.0545453 Nitrosopumilales archaeon 2026768 Archaea Archaea 106 2.34e-25   NR KAG2479306.1 2026768 g187849 i0 90.9 8.73529411764706 55 5 97.1 0 6 170 297 351 KAG2479306.1 MAG: hypothetical protein NPMRd3_650003 [Nitrosopumilales archaeon] diamond 1485 106 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales     Nitrosopumilales archaeon
31171065 31171065 PRJEB64798_P_NODE_71715_length_228_cov_4.782123_g69950_i0 PRJEB64798 71715 228 4.782123 10.90324044 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 101 2.52e-23   NR HEX5186678.1 2169593 g69950 i0 62.2 0.973684210526316 74 28 97.4 0 226 5 81 154 HEX5186678.1 PhoH family protein [Nitrososphaeraceae archaeon] diamond 222 101 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32144943 32144943 PRJEB64798_P_NODE_204778_length_166_cov_2.341880_g203012_i0 PRJEB64798 204778 166 2.34188 3.8875208 Archaea 2157 Archaea Archaea 43.5 0.0072   NR NDB90961.1 2026795 g203012 i0 49.1 7.21084337349398 57 24 97.6 3 162 1 143 197 NDB90961.1 hypothetical protein [Nitrososphaerota archaeon] diamond 1197 43.5 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
32405042 32405042 PRJEB64798_P_NODE_228639_length_159_cov_4.500000_g226873_i0 PRJEB64798 228639 159 4.5 7.155 Nitrosopumilus sp. 2024843 Archaea Archaea 66.6 2.85e-12   NR MEK0326406.1 2024843 g226873 i0 62.8 0.811320754716981 43 16 81.1 0 130 2 8 50 MEK0326406.1 uracil-DNA glycosylase family protein [Nitrosopumilus sp.] diamond 129 66.6 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus 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);;