RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA700095" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 7 ✖

bioproject 1

  • PRJNA700095 · 7 ✖

analysis 1

  • diamond · 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
26861602 26861602 PRJNA700095_P_NODE_51541_length_251_cov_0.865169_g50277_i0 PRJNA700095 51541 251 0.865169 2.17157419 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 42.7 0.0396   NR HET7283068.1 2169593 g50277 i0 42.9 0.585657370517928 49 24 58.6 1 104 250 113 157 HET7283068.1 alpha/beta hydrolase [Nitrososphaeraceae archaeon] diamond 147 42.7 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
27145520 27145520 PRJNA700095_P_NODE_22362_length_368_cov_3.111864_g21098_i0 PRJNA700095 22362 368 3.111864 11.45165952 Candidatus Bathyarchaeota archaeon 2026714 Archaea Archaea 45.8 0.00637   NR MBC8225059.1 2026714 g21098 i0 28.4 1.40217391304348 95 61 75.8 2 347 69 19 108 MBC8225059.1 hypothetical protein [Candidatus Bathyarchaeota archaeon] diamond 516 45.8 1 Archaea   Thermoproteati Candidatus Bathyarchaeota         Candidatus Bathyarchaeota archaeon
27240722 27240722 PRJNA700095_P_NODE_203_length_3051_cov_3.568167_g107_i0 PRJNA700095 203 3051 3.568167 108.86477517 Nitrososphaerota archaeon 2026795 Archaea Archaea 369 4.35e-108   NR MDG6922547.1 2026795 g107 i0 38.8 0.618485742379548 629 341 58.7 12 3050 1260 291 907 MDG6922547.1 DDE-type integrase/transposase/recombinase [Nitrososphaerota archaeon] diamond 1887 369 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
29734989 29734989 PRJNA700095_P_NODE_32330_length_300_cov_1.894273_g31066_i0 PRJNA700095 32330 300 1.894273 5.682819 Nitrosopumilaceae archaeon 2202732 Archaea Archaea 49.7 2.24e-4   NR HSD04197.1 2202732 g31066 i0 40.7 0.54 54 32 54 0 297 136 118 171 HSD04197.1 exosome complex protein Rrp42 [Nitrosopumilaceae archaeon] diamond 162 49.7 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae   Nitrosopumilaceae archaeon
31505037 31505037 PRJNA700095_P_NODE_5516_length_841_cov_2.682292_g4494_i0 PRJNA700095 5516 841 2.682292 22.55807572 Nitrososphaerota archaeon 2026795 Archaea Archaea 64.3 1.81e-7   NR MDG6922547.1 2026795 g4494 i0 47.7 0.759809750297265 65 34 23.2 0 565 759 97 161 MDG6922547.1 DDE-type integrase/transposase/recombinase [Nitrososphaerota archaeon] diamond 639 64.3 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
31916044 31916044 PRJNA700095_P_NODE_45037_length_264_cov_1.188482_g43773_i0 PRJNA700095 45037 264 1.188482 3.13759248 Nitrosopumilus sp. 2024843 Archaea Archaea 43.5 0.0232   NR MDC6463428.1 2024843 g43773 i0 31.9 0.784090909090909 69 46 77.3 1 11 214 8 76 MDC6463428.1 tetratricopeptide repeat protein [Nitrosopumilus sp.] diamond 207 43.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
32433752 32433752 PRJNA700095_P_NODE_40219_length_275_cov_1.935644_g38955_i0 PRJNA700095 40219 275 1.935644 5.323021 Archaea 2157 Archaea Archaea 43.9 0.0211   NR WP_100183087.1 1846278 g38955 i0 38.7 4.58181818181818 62 36 65.5 1 66 245 250 311 WP_100183087.1 thermosome subunit beta [Candidatus Nitrosotenuis aquarius] diamond 1260 43.9 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius

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);;