RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA1102048", 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 · 6 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 6 ✖

bioproject 1

  • PRJNA1102048 · 6 ✖
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
21888508 21888508 PRJNA1102048_P_NODE_12518_length_252_cov_1.039106_g12414_i0 PRJNA1102048 12518 252 1.039106 2.61854712 Parachlamydiales bacterium 2052178 Bacteria Bacteria 246 9.77e-61   NTclustered gi|2874253890|emb|OY970065.1| 2052178 g12414 i0 85.366 141.007936507937 246 27 96 7 2 242 627242 627001 MAG: Parachlamydiales bacterium isolate MFD09286.bin.c.6 genome assembly, chromosome: 1 blastn 35534 246 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales     Parachlamydiales bacterium
27762905 27762905 PRJNA1102048_P_NODE_12644_length_251_cov_0.865169_g12540_i0 PRJNA1102048 12644 251 0.865169 2.17157419 Simkaniaceae bacterium 2698248 Bacteria Bacteria 54.7 2.34e-6   NR MCI5052526.1 2698248 g12540 i0 39.7 0.932270916334661 78 37 93.2 2 17 250 42 109 MCI5052526.1 glycosyltransferase family 10 [Simkaniaceae bacterium] diamond 234 54.7 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae   Simkaniaceae bacterium
29751545 29751545 PRJNA1102048_P_NODE_8431_length_299_cov_1.362832_g8327_i0 PRJNA1102048 8431 299 1.362832 4.07486768 Chlamydiota bacterium 2081524 Bacteria Bacteria 61.6 1.54e-8   NR NBO24982.1 2081524 g8327 i0 56.5 0.903010033444816 46 20 46.2 0 299 162 335 380 NBO24982.1 type III PLP-dependent enzyme [Chlamydiota bacterium] diamond 270 61.6 1 Bacteria PVC group Pseudomonadati Chlamydiota         Chlamydiota bacterium
29941464 29941464 PRJNA1102048_P_NODE_15491_length_245_cov_1.343023_g15387_i0 PRJNA1102048 15491 245 1.343023 3.29040635 Simkania sp. 34094 Bacteria Bacteria 58.5 3.48e-9   NR MCB1084365.1 34094 g15387 i0 45.2 0.759183673469388 62 34 75.9 0 203 18 2 63 MCB1084365.1 hypothetical protein [Simkania sp.] diamond 186 58.5 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae Simkania Simkania sp.
32659641 32659641 PRJNA1102048_P_NODE_4980_length_384_cov_1.485531_g4876_i0 PRJNA1102048 4980 384 1.485531 5.70443904 Chlamydiia bacterium 2052156 Bacteria Bacteria 53.9 4.91e-7   NR MCB1114138.1 2052156 g4876 i0 78.8 1.03125 33 7 25.8 0 101 3 1 33 MCB1114138.1 50S ribosomal protein L34 [Chlamydiia bacterium] diamond 396 53.9 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia       Chlamydiia bacterium
32848770 32848770 PRJNA1102048_P_NODE_16120_length_244_cov_0.900585_g16016_i0 PRJNA1102048 16120 244 0.900585 2.1974274 Parachlamydiaceae bacterium 2052176 Bacteria Bacteria 47.4 1.36e-4   NR MFI0435630.1 2052176 g16016 i0 45 1.47540983606557 60 31 72.5 2 242 66 40 98 MFI0435630.1 nucleotidyltransferase family protein [Parachlamydiaceae bacterium] diamond 360 47.4 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae   Parachlamydiaceae 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);;