RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA642647", tax_clade = "PVC group" and tax_phylum = "Chlamydiota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Chlamydiota · 5 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 5 ✖

bioproject 1

  • PRJNA642647 · 5 ✖
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
1158576 1158576 PRJNA642647_P_NODE_6101_length_155_cov_0.813559_g6051_i0 PRJNA642647 6101 155 0.813559 1.26101645 Candidatus Protochlamydia 282132 Bacteria Bacteria 143 7.349999999999998e-30   NTclustered gi|1691252667|emb|BX908798.2| 264201 g6051 i0 83.893 158.490322580645 149 24 96 0 1 149 1249865 1250013 Candidatus Protochlamydia amoebophila UWE25 complete genome blastn 24566 143 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae Candidatus Protochlamydia Candidatus Protochlamydia amoebophila
4445683 4445683 PRJNA642647_P_NODE_4324_length_174_cov_2.182482_g4274_i0 PRJNA642647 4324 174 2.182482 3.79751868 uncultured Chlamydiales bacterium 174324 Bacteria Bacteria 228 2.2699999999999997e-55   NTclustered gi|880804004|gb|KT258829.1| 174324 g4274 i0 91.071 96.948275862069 168 15 97 0 7 174 81 248 Uncultured Chlamydiales bacterium clone CD47 16S ribosomal RNA gene, partial sequence blastn 16869 228 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     uncultured Chlamydiales bacterium
8811491 8811491 PRJNA642647_P_NODE_5947_length_156_cov_2.302521_g5897_i0 PRJNA642647 5947 156 2.302521 3.59193276 Parachlamydia 83551 Bacteria Bacteria 255 9.12e-64   NTclustered gi|470491594|ref|NR_077046.1| 83552 g5897 i0 96.732 196.532051282051 153 5 98 0 4 156 2308 2460 Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence blastn 30659 255 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae Parachlamydia Parachlamydia acanthamoebae
28565554 28565554 PRJNA642647_P_NODE_6367_length_152_cov_1.000000_g6317_i0 PRJNA642647 6367 152 1 1.52 Chlamydia trachomatis 813 Bacteria Bacteria 79 1.11e-15   NR CPR46792.1 813 g6317 i0 95.8 0.947368421052632 48 2 94.7 0 145 2 87 134 CPR46792.1 Uncharacterised protein [Chlamydia trachomatis] diamond 144 79 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia trachomatis
31123554 31123554 PRJNA642647_P_NODE_3815_length_183_cov_2.458904_g3765_i0 PRJNA642647 3815 183 2.458904 4.49979432 Parachlamydia sp. 2052048 Bacteria Bacteria 47.4 3.83e-4   NR MCE2983404.1 2052048 g3765 i0 63.6 0.540983606557377 33 12 54.1 0 181 83 165 197 MCE2983404.1 hypothetical protein [Parachlamydia sp.] diamond 99 47.4 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae Parachlamydia Parachlamydia 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);;