RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJEB75017", tax_clade = "PVC group" and tax_phylum = "Chlamydiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlamydiota · 9 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 9 ✖

bioproject 1

  • PRJEB75017 · 9 ✖

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
8648703 8648703 PRJEB75017_P_NODE_14427_length_252_cov_0.871508_g14298_i0 PRJEB75017 14427 252 0.871508 2.19620016 Chlamydiales bacterium 2047757 Bacteria Bacteria 78.6 1.04e-14   NR HSX26488.1 2047757 g14298 i0 48.8 4.90476190476191 82 41 97.6 1 246 1 433 513 HSX26488.1 adenylate/guanylate cyclase domain-containing protein [Chlamydiales bacterium] diamond 1236 78.6 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales bacterium
24361233 24361233 PRJEB75017_P_NODE_6460_length_349_cov_1.130435_g6331_i0 PRJEB75017 6460 349 1.130435 3.94521815 Candidatus Sacchlamyda saccharinae 3076872 Bacteria Bacteria 139 5.1e-36   NR MDN3505954.1 3076872 g6331 i0 55.7 6.96275071633238 115 49 98.9 1 2 346 475 587 MDN3505954.1 phosphoenolpyruvate carboxykinase (GTP) [Candidatus Sacchlamyda saccharinae] diamond 2430 139 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Candidatus Rhabdochlamydiaceae Candidatus Sacchlamyda Candidatus Sacchlamyda saccharinae
30602758 30602758 PRJEB75017_P_NODE_3373_length_477_cov_1.970297_g3244_i0 PRJEB75017 3373 477 1.970297 9.39831669 Simkania sp. 34094 Bacteria Bacteria 159 1.59e-45   NR MCB1084310.1 34094 g3244 i0 80 0.59748427672956 95 19 59.7 0 285 1 1 95 MCB1084310.1 hypothetical protein [Simkania sp.] diamond 285 159 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae Simkania Simkania sp.
30602761 30602761 PRJEB75017_P_NODE_5933_length_362_cov_1.813149_g5804_i0 PRJEB75017 5933 362 1.813149 6.56359938 Chlamydiales bacterium 2047757 Bacteria Bacteria 131 3.08e-36   NR MCP5470420.1 2047757 g5804 i0 81.1 0.613259668508287 74 14 61.3 0 360 139 6 79 MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium] diamond 222 131 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales bacterium
30760933 30760933 PRJEB75017_P_NODE_12394_length_265_cov_2.166667_g12265_i0 PRJEB75017 12394 265 2.166667 5.74166755 Parachlamydiales bacterium 2052178 Bacteria Bacteria 45.8 0.00392   NR MFA5250150.1 2052178 g12265 i0 30.4 1.04150943396226 92 57 98.5 3 4 264 234 323 MFA5250150.1 hypothetical protein [Parachlamydiales bacterium] diamond 276 45.8 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales     Parachlamydiales bacterium
31298020 31298020 PRJEB75017_P_NODE_13455_length_255_cov_1.714286_g13326_i0 PRJEB75017 13455 255 1.714286 4.3714293 Simkaniaceae bacterium 2698248 Bacteria Bacteria 45.8 4.38e-4   NR MBP9842320.1 2698248 g13326 i0 43.1 0.682352941176471 58 32 67.1 1 252 82 22 79 MBP9842320.1 hypothetical protein [Simkaniaceae bacterium] diamond 174 45.8 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae   Simkaniaceae bacterium
32057230 32057230 PRJEB75017_P_NODE_13478_length_255_cov_1.461538_g13349_i0 PRJEB75017 13478 255 1.461538 3.7269219 Simkania sp. 34094 Bacteria Bacteria 52.4 1.27e-5   NR MCB1084310.1 34094 g13349 i0 55.6 0.529411764705882 45 20 52.9 0 250 116 152 196 MCB1084310.1 hypothetical protein [Simkania sp.] diamond 135 52.4 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae Simkania Simkania sp.
32183924 32183924 PRJEB75017_P_NODE_18898_length_211_cov_4.217391_g18769_i0 PRJEB75017 18898 211 4.217391 8.89869501 Chlamydiota bacterium 2081524 Bacteria Bacteria 142 1.99e-37   NR MBM3193748.1 2081524 g18769 i0 100 0.995260663507109 70 0 99.5 0 2 211 125 194 MBM3193748.1 outer membrane protein assembly factor BamA [Chlamydiota bacterium] diamond 210 142 1 Bacteria PVC group Pseudomonadati Chlamydiota         Chlamydiota bacterium
32310702 32310702 PRJEB75017_P_NODE_12119_length_268_cov_1.502564_g11990_i0 PRJEB75017 12119 268 1.502564 4.02687152 Simkania sp. 34094 Bacteria Bacteria 110 2.54e-29   NR MCB1084315.1 34094 g11990 i0 89.5 0.638059701492537 57 6 63.8 0 172 2 1 57 MCB1084315.1 hypothetical protein [Simkania sp.] diamond 171 110 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae Simkania Simkania 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);;