RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA356682", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Archaea · 7 ✖

tax_phylum 1

  • Nitrososphaerota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA356682 · 7 ✖

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
12551084 12551084 PRJNA356682_P_NODE_5390_length_609_cov_2.509328_g4712_i0 PRJNA356682 5390 609 2.509328 15.28180752 Candidatus Nitrosocosmicus 1826864 Archaea Archaea 1103 0   NTclustered gi|937513727|gb|CP012850.1| 1353260 g4712 i0 99.344 114.715927750411 610 3 100 1 1 609 849261 848652 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 69862 1112 0.991906474820144 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
15099906 15099906 PRJNA356682_P_NODE_14292_length_374_cov_2.378738_g13602_i0 PRJNA356682 14292 374 2.378738 8.89648012 Nitrososphaera 497726 Archaea Archaea 603 7.829999999999997e-168   NTclustered gi|300521484|gb|GU797787.1| 497727 g13602 i0 95.722 29.4224598930481 374 16 100 0 1 374 544 917 Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence blastn 11004 603 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Candidatus Nitrososphaera gargensis
16975244 16975244 PRJNA356682_P_NODE_41114_length_245_cov_0.895349_g40423_i0 PRJNA356682 41114 245 0.895349 2.19360505 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 420 5.26e-113   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g40423 i0 97.551 5.00816326530612 245 6 100 0 1 245 292019 291775 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 1227 420 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
22073909 22073909 PRJNA356682_P_NODE_19458_length_326_cov_4.774704_g18767_i0 PRJNA356682 19458 326 4.774704 15.56553504 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 597 3.139999999999999e-166   NTclustered gi|937513727|gb|CP012850.1| 1353260 g18767 i0 99.693 18.9662576687117 326 1 100 0 1 326 849574 849249 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 6183 597 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
30422776 30422776 PRJNA356682_P_NODE_19773_length_324_cov_2.195219_g19082_i0 PRJNA356682 19773 324 2.195219 7.11250956 Candidatus Caldarchaeum sp. 2972665 Archaea Archaea 65.1 1.29e-9   NR MCS6785098.1 2972665 g19082 i0 42.6 0.87037037037037 94 50 86.1 2 316 38 121 211 MCS6785098.1 hypothetical protein [Candidatus Caldarchaeum sp.] diamond 282 65.1 1 Archaea   Thermoproteati Nitrososphaerota   Candidatus Caldarchaeales Candidatus Caldarchaeaceae Candidatus Caldarchaeum Candidatus Caldarchaeum sp.
31402253 31402253 PRJNA356682_P_NODE_44996_length_241_cov_0.916667_g44305_i0 PRJNA356682 44996 241 0.916667 2.20916747 uncultured Nitrososphaera sp. 759874 Archaea Archaea 53.1 1.09e-6   NR WP_294807835.1 759874 g44305 i0 100 0.572614107883817 46 0 57.3 0 140 3 68 113 WP_294807835.1 hypothetical protein [uncultured Nitrososphaera sp.] diamond 138 53.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera uncultured Nitrososphaera sp.
32319846 32319846 PRJNA356682_P_NODE_43079_length_243_cov_0.905882_g42388_i0 PRJNA356682 43079 243 0.905882 2.20129326 Nitrososphaera sp. 1971748 Archaea Archaea 113 8.82e-30   NR HEX2014916.1 1971748 g42388 i0 64.6 0.975308641975309 79 28 97.5 0 2 238 62 140 HEX2014916.1 PepSY domain-containing protein [Nitrososphaera sp.] diamond 237 113 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);;