RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

tax_clade 1

  • PVC group · 4 ✖

bioproject 1

  • PRJDB4470 · 4 ✖
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
19135181 19135181 PRJDB4470_P_NODE_57696_length_258_cov_1.679426_g56541_i0 PRJDB4470 57696 258 1.679426 4.33291908 uncultured Chlamydiae bacterium 305355 Bacteria Bacteria 54.7 0.007   NTclustered gi|2874253676|emb|OY969110.1| 305355 g56541 i0 94.286 0.255813953488372 35 2 14 0 90 124 99609 99643 MAG: uncultured Chlamydiae bacterium isolate MFD00082.bin.c.5 genome assembly, chromosome: 1 blastn 66 54.7 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia       uncultured Chlamydiae bacterium
28643295 28643295 PRJDB4470_P_NODE_44087_length_320_cov_1.512915_g42934_i0 PRJDB4470 44087 320 1.512915 4.841328 Chlamydiales bacterium 2047757 Bacteria Bacteria 79.7 8.3e-15   NR MDP1835282.1 2047757 g42934 i0 45.1 0.853125 91 50 85.3 0 309 37 130 220 MDP1835282.1 IS4 family transposase [Chlamydiales bacterium] diamond 273 79.7 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales bacterium
32024020 32024020 PRJDB4470_P_NODE_76058_length_207_cov_1.088608_g74903_i0 PRJDB4470 76058 207 1.088608 2.25341856 Chlamydia psittaci 83554 Bacteria Bacteria 50.8 9.7e-7   NR EPJ33691.1 1112244 g74903 i0 100 0.304347826086957 21 0 30.4 0 207 145 5 25 EPJ33691.1 hypothetical protein CP061683_2398, partial [Chlamydia psittaci 06-1683] diamond 63 50.8 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia psittaci
32687677 32687677 PRJDB4470_P_NODE_70600_length_219_cov_1.735294_g69445_i0 PRJDB4470 70600 219 1.735294 3.80029386 Chlamydia psittaci 84-8471/1 1112230 Bacteria Bacteria 65.1 6.91e-12   NR EPP35918.1 1112230 g69445 i0 77.8 0.616438356164384 45 10 61.6 0 144 10 1 45 EPP35918.1 hypothetical protein CP8484711_2945, partial [Chlamydia psittaci 84-8471/1] diamond 135 65.1 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia psittaci

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