RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA771359" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Archaea · 5 ✖

tax_phylum 1

tax_kingdom 1

bioproject 1

  • PRJNA771359 · 5 ✖

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
747048 747048 PRJNA771359_S_NODE_3441_length_181_cov_1.812500_g3358_i0 PRJNA771359 3441 181 1.8125 3.280625 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 324 2.95e-84   NTclustered gi|808354332|gb|CP011097.2| 1603555 g3358 i0 98.895 39.4917127071823 181 2 100 0 1 181 739940 740120 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 7148 324 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
7125775 7125775 PRJNA771359_S_NODE_3606_length_177_cov_2.771429_g3523_i0 PRJNA771359 3606 177 2.771429 4.90542933 archaeon 1906665 Archaea Archaea 93.2 7.68e-23   NR MDP2434118.1 1906665 g3523 i0 81.8 0.932203389830508 55 9 91.5 1 173 12 58 112 MDP2434118.1 30S ribosomal protein S17 [archaeon] diamond 165 93.2 1 Archaea               archaeon
19873834 19873834 PRJNA771359_S_NODE_4316_length_163_cov_1.500000_g4233_i0 PRJNA771359 4316 163 1.5 2.445 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 230 5.8499999999999985e-56   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g4233 i0 92.025 2.01840490797546 163 13 100 0 1 163 1534277 1534115 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 329 230 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
28884850 28884850 PRJNA771359_S_NODE_3328_length_184_cov_1.442177_g3245_i0 PRJNA771359 3328 184 1.442177 2.65360568 archaeon 1906665 Archaea Archaea 51.6 4.01e-6   NR MDP2436403.1 1906665 g3245 i0 39.1 1.04347826086957 64 34 96.2 1 2 178 1 64 MDP2436403.1 hypothetical protein [archaeon] diamond 192 51.6 1 Archaea               archaeon
29484555 29484555 PRJNA771359_S_NODE_3830_length_172_cov_1.414815_g3747_i0 PRJNA771359 3830 172 1.414815 2.4334818 archaeon 1906665 Archaea Archaea 82.4 8.43e-19   NR MCQ2817563.1 1906665 g3747 i0 63.2 1.97093023255814 57 21 99.4 0 172 2 31 87 MCQ2817563.1 hypothetical protein [archaeon] diamond 339 82.4 1 Archaea               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);;