RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA385073", 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

  • PRJNA385073 · 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
1680949 1680949 PRJNA385073_P_NODE_42622_length_250_cov_2.610169_g42460_i0 PRJNA385073 42622 250 2.610169 6.5254225 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 351 1.99e-92   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g42460 i0 92 1 250 20 100 0 1 250 1533343 1533592 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 250 351 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
8059528 8059528 PRJNA385073_P_NODE_50287_length_246_cov_0.890173_g50125_i0 PRJNA385073 50287 246 0.890173 2.18982558 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 449 6.74e-122   NTclustered gi|808354332|gb|CP011097.2| 1603555 g50125 i0 100 78.780487804878 243 0 99 0 1 243 738951 739193 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 19380 449 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
9334435 9334435 PRJNA385073_P_NODE_53848_length_244_cov_0.900585_g53686_i0 PRJNA385073 53848 244 0.900585 2.1974274 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 429 8.699999999999998e-116   NTclustered gi|808354332|gb|CP011097.2| 1603555 g53686 i0 98.361 1 244 4 100 0 1 244 1562208 1561965 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 244 429 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
9334464 9334464 PRJNA385073_P_NODE_55048_length_243_cov_0.905882_g54886_i0 PRJNA385073 55048 243 0.905882 2.20129326 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 351 1.93e-92   NTclustered gi|808354332|gb|CP011097.2| 1603555 g54886 i0 93.724 0.983539094650206 239 8 98 2 1 239 889011 889242 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 239 351 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
13160083 13160083 PRJNA385073_P_NODE_54051_length_244_cov_0.900585_g53889_i0 PRJNA385073 54051 244 0.900585 2.1974274 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 350 6.969999999999998e-92   NTclustered gi|808354332|gb|CP011097.2| 1603555 g53889 i0 92.623 1.99590163934426 244 17 100 1 1 244 493002 492760 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 487 350 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
30534363 30534363 PRJNA385073_P_NODE_37913_length_258_cov_4.740541_g37751_i0 PRJNA385073 37913 258 4.740541 12.23059578 root 1 Root_unresolved Root_unresolved 87.4 8.63e-18   NR MEM2159666.1 2507556 g37751 i0 48.8 3.01162790697674 86 44 100 0 1 258 416 501 MEM2159666.1 hypothetical protein [Candidatus Nitrosotenuis sp.] diamond 777 87.8 0.995444191343964 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis sp.
32305388 32305388 PRJNA385073_P_NODE_26859_length_288_cov_1.413953_g26697_i0 PRJNA385073 26859 288 1.413953 4.07218464 Nitrososphaeria 1643678 Archaea Archaea 186 1.14e-57   NR RPJ30690.1 2026768 g26697 i0 97.9 4 96 2 100 0 1 288 88 183 RPJ30690.1 MAG: DNA-directed RNA polymerase [Nitrosopumilales archaeon] diamond 1152 186 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);;