RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJDB4941", tax_clade = "Nitrospinota/Tectimicrobiota group" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 4 ✖

tax_kingdom 1

tax_clade 1

  • Nitrospinota/Tectimicrobiota group · 4 ✖

bioproject 1

  • PRJDB4941 · 4 ✖

analysis 1

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
27885329 27885329 PRJDB4941_P_NODE_11505_length_327_cov_1.647482_g10737_i0 PRJDB4941 11505 327 1.647482 5.38726614 Candidatus Tectimicrobiota bacterium 2528274 Bacteria Bacteria 153 1.95e-45   NR MBI2876617.1 2528274 g10737 i0 72.5 0.834862385321101 91 25 83.5 0 327 55 50 140 MBI2876617.1 HNH endonuclease [Candidatus Tectimicrobiota bacterium] diamond 273 153 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Candidatus Tectimicrobiota         Candidatus Tectimicrobiota bacterium
29116936 29116936 PRJDB4941_P_NODE_36909_length_166_cov_0.888889_g36141_i0 PRJDB4941 36909 166 0.888889 1.47555574 Nitrospina sp. 2024844 Bacteria Bacteria 44.7 4.16e-4   NR MBT5470741.1 2024844 g36141 i0 47.1 1.86144578313253 51 27 92.2 0 159 7 7 57 MBT5470741.1 hypothetical protein [Nitrospina sp.] diamond 309 44.7 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota Nitrospinia Nitrospinales Nitrospinaceae Nitrospina Nitrospina sp.
29615663 29615663 PRJDB4941_P_NODE_36910_length_166_cov_0.888889_g36142_i0 PRJDB4941 36910 166 0.888889 1.47555574 root 1 Root_unresolved Root_unresolved 49.7 4.69e-5   NR HIL27340.1 2358456 g36142 i0 51.9 1.96987951807229 54 25 97.6 1 163 2 326 378 HIL27340.1 hypothetical protein [Nitrospinaceae bacterium] diamond 327 50.1 0.992015968063872 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota Nitrospinia Nitrospinales Nitrospinaceae   Nitrospinaceae bacterium
32309046 32309046 PRJDB4941_P_NODE_25159_length_200_cov_3.165563_g24391_i0 PRJDB4941 25159 200 3.165563 6.331126 Candidatus Tectimicrobiota bacterium 2528274 Bacteria Bacteria 69.7 4.49e-12   NR HEX9870998.1 2528274 g24391 i0 60 1.935 65 24 96 2 7 198 13 76 HEX9870998.1 Hsp70 family protein [Candidatus Tectimicrobiota bacterium] diamond 387 69.7 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Candidatus Tectimicrobiota         Candidatus Tectimicrobiota bacterium

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