RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA615175", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Archaea · 5 ✖

tax_phylum 1

  • Nitrososphaerota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA615175 · 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
25376118 25376118 PRJNA615175_P_NODE_10280_length_457_cov_2.497396_g10112_i0 PRJNA615175 10280 457 2.497396 11.41309972 Candidatus Nitrosocosmicus 1826864 Archaea Archaea 822 0   NTclustered gi|937513727|gb|CP012850.1| 1353260 g10112 i0 99.125 99.0065645514223 457 4 100 0 1 457 850189 850645 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 45246 828 0.992753623188406 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
26763774 26763774 PRJNA615175_P_NODE_2821_length_923_cov_11.580000_g2688_i0 PRJNA615175 2821 923 11.58 106.8834 Nitrosopumilus sp. 2024843 Archaea Archaea 105 2.5e-24   NR MBA3285058.1 2024843 g2688 i0 76.5 0.221018418201517 68 16 22.1 0 64 267 27 94 MBA3285058.1 hypothetical protein [Nitrosopumilus sp.] diamond 204 105 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
26763776 26763776 PRJNA615175_P_NODE_35821_length_237_cov_3.518293_g35653_i0 PRJNA615175 35821 237 3.518293 8.33835441 Candidatus Nitrosocosmicus sp. 2109671 Archaea Archaea 143 4.069999999999999e-41   NR HYP43440.1 2109671 g35653 i0 100 4.48101265822785 71 0 89.9 0 235 23 63 133 HYP43440.1 deoxyhypusine synthase family protein [Candidatus Nitrosocosmicus sp.] diamond 1062 143 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus sp.
27535751 27535751 PRJNA615175_P_NODE_26563_length_259_cov_2.935484_g26395_i0 PRJNA615175 26563 259 2.935484 7.60290356 root 1 Root_unresolved Root_unresolved 105 1.06e-24   NR HEU0143677.1 1971748 g26395 i0 56.6 1.92277992277992 83 36 96.1 0 250 2 19 101 HEU0143677.1 IS4 family transposase [Nitrososphaera sp.] diamond 498 106 0.990566037735849 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
30143136 30143136 PRJNA615175_P_NODE_2892_length_914_cov_18.868014_g2688_i1 PRJNA615175 2892 914 18.868014 172.45364796 Nitrosopumilus sp. 2024843 Archaea Archaea 105 2.35e-24   NR MBA3285058.1 2024843 g2688 i1 76.5 0.223194748358862 68 16 22.3 0 851 648 27 94 MBA3285058.1 hypothetical protein [Nitrosopumilus sp.] diamond 204 105 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.

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