RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA977246", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Archaea · 8 ✖

tax_phylum 1

  • Nitrososphaerota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA977246 · 8 ✖

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
3501939 3501939 PRJNA977246_S_NODE_30563_length_223_cov_4.082474_g29571_i0 PRJNA977246 30563 223 4.082474 9.10391702 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 121 5.35e-23   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g29571 i0 89.474 0.426008968609865 95 10 43 0 7 101 58265 58171 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 95 121 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
16254074 16254074 PRJNA977246_S_NODE_26493_length_250_cov_4.895928_g25501_i0 PRJNA977246 26493 250 4.895928 12.23982 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 368 1.98e-97   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g25501 i0 93.2 1 250 17 100 0 1 250 58061 57812 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 250 368 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
25176893 25176893 PRJNA977246_S_NODE_11240_length_451_cov_2191.196682_g10292_i0 PRJNA977246 11240 451 2191.196682 9882.29703582 Candidatus Nitrosocosmicus franklandianus 1798806 Archaea Archaea 379 1.7600000000000002e-100   NTclustered gi|1599533355|emb|LR216287.1| 1798806 g10292 i0 95.397 12.3259423503326 239 9 53 2 42 278 259 21 Candidatus Nitrosocosmicus franklandus isolate NFRAN1 genome assembly, chromosome: NFRAN blastn 5559 379 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus franklandianus
27120661 27120661 PRJNA977246_S_NODE_44222_length_168_cov_3.093525_g43230_i0 PRJNA977246 44222 168 3.093525 5.197122 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 106 5.61e-25   NR WP_100181730.1 1846278 g43230 i0 83.6 4.91071428571429 55 9 98.2 0 3 167 6 60 WP_100181730.1 hypothetical protein [Candidatus Nitrosotenuis aquarius] diamond 825 106 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
27752899 27752899 PRJNA977246_S_NODE_13944_length_396_cov_3.307902_g12960_i0 PRJNA977246 13944 396 3.307902 13.09929192 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 222 1.19e-65   NR WP_148550728.1 1603555 g12960 i0 87.7 1.96969696969697 130 15 97.7 1 396 10 94 223 WP_148550728.1 PEFG-CTERM sorting domain-containing protein [Candidatus Nitrosotenuis cloacae] diamond 780 222 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
30026285 30026285 PRJNA977246_S_NODE_39631_length_183_cov_2.103896_g38639_i0 PRJNA977246 39631 183 2.103896 3.85012968 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 125 1.24e-32   NR MDW0282465.1 2169593 g38639 i0 98.4 1 61 1 100 0 183 1 114 174 MDW0282465.1 phosphoglycerate kinase [Nitrososphaeraceae archaeon] diamond 183 125 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
30689526 30689526 PRJNA977246_S_NODE_45073_length_166_cov_2.087591_g44081_i0 PRJNA977246 45073 166 2.087591 3.46540106 Candidatus Nitrosocosmicus sp. 2109671 Archaea Archaea 116 1.87e-31   NR HYP42999.1 2109671 g44081 i0 100 1.98795180722892 55 0 99.4 0 166 2 27 81 HYP42999.1 30S ribosomal protein S4e [Candidatus Nitrosocosmicus sp.] diamond 330 116 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus sp.
30910976 30910976 PRJNA977246_S_NODE_48974_length_156_cov_2.984252_g47982_i0 PRJNA977246 48974 156 2.984252 4.65543312 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 99.4 4.4e-23   NR MDW0282465.1 2169593 g47982 i0 98 0.980769230769231 51 1 98.1 0 3 155 11 61 MDW0282465.1 phosphoglycerate kinase [Nitrososphaeraceae archaeon] diamond 153 99.4 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);;