RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA505329", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Archaea · 4 ✖

tax_phylum 1

  • Nitrososphaerota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA505329 · 4 ✖

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
23435724 23435724 PRJNA505329_P_NODE_23859_length_197_cov_3.925676_g23388_i0 PRJNA505329 23859 197 3.925676 7.73358172 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 180 7.499999999999998e-41   NTclustered gi|937513727|gb|CP012850.1| 1353260 g23388 i0 99 14.2842639593909 100 1 98 0 97 196 849303 849402 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 2814 180 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
24709486 24709486 PRJNA505329_P_NODE_44460_length_167_cov_0.881356_g43989_i0 PRJNA505329 44460 167 0.881356 1.47186452 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 270 3.5499999999999993e-68   NTclustered gi|808354332|gb|CP011097.2| 1603555 g43989 i0 96.341 0.982035928143713 164 6 98 0 1 164 1356880 1357043 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 164 270 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
31435871 31435871 PRJNA505329_P_NODE_39336_length_173_cov_1.653226_g38865_i0 PRJNA505329 39336 173 1.653226 2.86008098 Nitrosopumilales archaeon 2026768 Archaea Archaea 111 1.13e-30   NR MBI3253335.1 2026768 g38865 i0 100 0.815028901734104 47 0 81.5 0 32 172 1 47 MBI3253335.1 hypothetical protein [Nitrosopumilales archaeon] diamond 141 111 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales     Nitrosopumilales archaeon
31847022 31847022 PRJNA505329_P_NODE_51957_length_155_cov_2.415094_g51486_i0 PRJNA505329 51957 155 2.415094 3.7433957 Nitrosopumilales archaeon 2026768 Archaea Archaea 101 1.73e-23   NR MBI2006572.1 2026768 g51486 i0 100 2.96129032258065 51 0 98.7 0 154 2 146 196 MBI2006572.1 hypothetical protein [Nitrosopumilales archaeon] diamond 459 101 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales     Nitrosopumilales 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);;