RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA690592", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Archaea · 17 ✖

tax_phylum 1

  • Nitrososphaerota · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA690592 · 17 ✖
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
15974695 15974695 PRJNA690592_S_NODE_73173_length_373_cov_1.530000_g72159_i0 PRJNA690592 73173 373 1.53 5.7069 uncultured marine thaumarchaeote SAT1000_05_G10 1456358 Archaea Archaea 52.8 0.035   NTclustered gi|663531667|gb|KF901195.1| 1456358 g72159 i0 100 0.0750670241286863 28 0 8 0 257 284 9026 8999 Uncultured marine thaumarchaeote SAT1000_05_G10 genomic sequence blastn 28 52.8 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote SAT1000_05_G10
17756774 17756774 PRJNA690592_S_NODE_1054_length_2014_cov_8.033488_g853_i0 PRJNA690592 1054 2014 8.033488 161.79444832 Marine Group I thaumarchaeote 2511932 Archaea Archaea 135 6.79e-29   NR NWJ43849.1 2511932 g853 i0 26.3 0.674776564051639 453 265 66.4 10 1855 518 63 453 NWJ43849.1 aminopeptidase N [Marine Group I thaumarchaeote] diamond 1359 135 1 Archaea Marine Group I Thermoproteati Nitrososphaerota         Marine Group I thaumarchaeote
18522731 18522731 PRJNA690592_S_NODE_106675_length_319_cov_1.630081_g105661_i0 PRJNA690592 106675 319 1.630081 5.19995839 Nitrosopumilus zosterae 718286 Archaea Archaea 52.8 0.03   NTclustered gi|2289589374|dbj|AP026695.1| 718286 g105661 i0 100 0.0877742946708464 28 0 9 0 199 226 1310204 1310231 Nitrosopumilus zosterae NM25 DNA, complete genome blastn 28 52.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus zosterae
27461846 27461846 PRJNA690592_S_NODE_193023_length_249_cov_0.875000_g192009_i0 PRJNA690592 193023 249 0.875 2.17875 Nitrososphaerota archaeon 2026795 Archaea Archaea 60.1 1.55e-8   NR MDW8033726.1 2026795 g192009 i0 39.5 1.83132530120482 76 42 91.6 2 233 6 45 116 MDW8033726.1 class I SAM-dependent methyltransferase [Nitrososphaerota archaeon] diamond 456 60.1 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
28219241 28219241 PRJNA690592_S_NODE_194326_length_248_cov_1.320000_g193312_i0 PRJNA690592 194326 248 1.32 3.2736 Nitrososphaerota archaeon 2026795 Archaea Archaea 76.3 5.76e-14   NR MEM3062175.1 2026795 g193312 i0 39 1.97177419354839 82 48 98 2 248 6 334 414 MEM3062175.1 protein kinase [Nitrososphaerota archaeon] diamond 489 76.3 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
28819040 28819040 PRJNA690592_S_NODE_180188_length_255_cov_1.016484_g179174_i0 PRJNA690592 180188 255 1.016484 2.5920342 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 54.7 1.42e-6   NR MCJ7638082.1 2169593 g179174 i0 42.6 0.8 68 35 75.3 2 59 250 2 69 MCJ7638082.1 alpha-ketoglutarate-dependent dioxygenase AlkB [Nitrososphaeraceae archaeon] diamond 204 54.7 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
28882441 28882441 PRJNA690592_S_NODE_205748_length_244_cov_1.350877_g204734_i0 PRJNA690592 205748 244 1.350877 3.29613988 Nitrososphaerota archaeon 2026795 Archaea Archaea 81.6 6.87e-17   NR MDG6922593.1 2026795 g204734 i0 52.3 2.33606557377049 65 31 79.9 0 2 196 120 184 MDG6922593.1 ABC transporter ATP-binding protein [Nitrososphaerota archaeon] diamond 570 81.6 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
29040558 29040558 PRJNA690592_S_NODE_13448_length_799_cov_7.436639_g12594_i0 PRJNA690592 13448 799 7.4366390000000004 59.41874561 Nitrosopumilus sp. 2024843 Archaea Archaea 57 1.93e-5   NR MCI4432842.1 2024843 g12594 i0 30 1.42678347934919 190 103 68.3 8 52 597 12 179 MCI4432842.1 hypothetical protein [Nitrosopumilus sp.] diamond 1140 57 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
29734670 29734670 PRJNA690592_S_NODE_149370_length_277_cov_2.215686_g148356_i0 PRJNA690592 149370 277 2.215686 6.13745022 Nitrososphaerota archaeon 2026795 Archaea Archaea 95.1 1.61e-22   NR MEM3062173.1 2026795 g148356 i0 57.8 8.46931407942238 64 27 69.3 0 276 85 14 77 MEM3062173.1 protein kinase [Nitrososphaerota archaeon] diamond 2346 95.1 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
30050734 30050734 PRJNA690592_S_NODE_173671_length_259_cov_1.446237_g172657_i0 PRJNA690592 173671 259 1.446237 3.74575383 Candidatus Nitrosotenuis sp. 2507556 Archaea Archaea 49.7 1.64e-4   NR HXE73941.1 2507556 g172657 i0 30.3 3.40540540540541 76 50 85.7 2 222 1 528 602 HXE73941.1 cyclic nucleotide-binding domain-containing protein [Candidatus Nitrosotenuis sp.] diamond 882 49.7 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis sp.
30367339 30367339 PRJNA690592_S_NODE_70632_length_378_cov_3.629508_g69618_i0 PRJNA690592 70632 378 3.629508 13.71954024 Nitrosopumilus sp. 2024843 Archaea Archaea 50.4 2.65e-4   NR MCI4432842.1 2024843 g69618 i0 35.8 0.952380952380952 120 69 94.4 5 370 14 90 202 MCI4432842.1 hypothetical protein [Nitrosopumilus sp.] diamond 360 50.4 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
30556182 30556182 PRJNA690592_S_NODE_154573_length_273_cov_1.755000_g153559_i0 PRJNA690592 154573 273 1.755 4.79115 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 73.6 1.33e-13   NR MCJ7638082.1 2169593 g153559 i0 50 0.945054945054945 86 31 81.3 3 272 51 125 210 MCJ7638082.1 alpha-ketoglutarate-dependent dioxygenase AlkB [Nitrososphaeraceae archaeon] diamond 258 73.6 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31441305 31441305 PRJNA690592_S_NODE_37676_length_498_cov_1.385882_g36665_i0 PRJNA690592 37676 498 1.385882 6.90169236 Nitrososphaerota archaeon 2026795 Archaea Archaea 69.7 1.92e-10   NR NDF25896.1 2026795 g36665 i0 35.3 0.801204819277108 133 73 73.5 5 4 369 307 437 NDF25896.1 hypothetical protein [Nitrososphaerota archaeon] diamond 399 69.7 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
31473158 31473158 PRJNA690592_S_NODE_48816_length_444_cov_1.557951_g47802_i0 PRJNA690592 48816 444 1.557951 6.91730244 Nitrososphaerota archaeon 2026795 Archaea Archaea 82.8 2.84e-15   NR MEM3062175.1 2026795 g47802 i0 45.3 0.581081081081081 86 45 57.4 2 348 94 330 414 MEM3062175.1 protein kinase [Nitrososphaerota archaeon] diamond 258 82.8 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
31725921 31725921 PRJNA690592_S_NODE_209537_length_243_cov_0.905882_g208523_i0 PRJNA690592 209537 243 0.905882 2.20129326 Nitrososphaerota archaeon 2026795 Archaea Archaea 84 9.98e-17   NR MEM3062175.1 2026795 g208523 i0 48.1 1 81 41 98.8 1 243 4 330 410 MEM3062175.1 protein kinase [Nitrososphaerota archaeon] diamond 243 84 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
31978990 31978990 PRJNA690592_S_NODE_191738_length_249_cov_1.119318_g190724_i0 PRJNA690592 191738 249 1.119318 2.78710182 Nitrosarchaeum sp. 2026886 Archaea Archaea 82 2.28e-16   NR HSA76180.1 2026886 g190724 i0 42.7 0.987951807228916 82 45 96.4 1 240 1 34 115 HSA76180.1 serine/threonine-protein kinase [Nitrosarchaeum sp.] diamond 246 82 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp.
32137305 32137305 PRJNA690592_S_NODE_15098_length_758_cov_3.969343_g14205_i0 PRJNA690592 15098 758 3.969343 30.08761994 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 110 1.22e-25   NR MDW3631019.1 2169593 g14205 i0 37.7 2.35883905013193 151 77 58.6 3 261 704 7 143 MDW3631019.1 bifunctional 5,10-methylenetetrahydrofolate dehydrogenase/5,10-methenyltetrahydrofolate cyclohydrolase [Nitrososphaeraceae archaeon] diamond 1788 110 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae 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);;