RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA986481" and tax_phylum = "Chlamydiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlamydiota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA986481 · 6 ✖

analysis 1

  • diamond · 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
17551344 17551344 PRJNA986481_P_NODE_27734_length_311_cov_2.923664_g27209_i0 PRJNA986481 27734 311 2.923664 9.09259504 PVC group 1783257 Bacteria Bacteria 116 3.66e-28   NR MEC7840177.1 2081524 g27209 i0 75.3 6.33762057877814 73 17 70.4 1 22 240 371 442 MEC7840177.1 adenosylhomocysteinase [Chlamydiota bacterium] diamond 1971 116 1 Bacteria PVC group Pseudomonadati Chlamydiota         Chlamydiota bacterium
27721867 27721867 PRJNA986481_P_NODE_38024_length_266_cov_1.018433_g37499_i0 PRJNA986481 38024 266 1.018433 2.70903178 Chlamydiota bacterium 2081524 Bacteria Bacteria 91.3 1.08e-19   NR MCX6987222.1 2081524 g37499 i0 67.6 0.800751879699248 71 23 80.1 0 213 1 2 72 MCX6987222.1 transaldolase [Chlamydiota bacterium] diamond 213 91.3 1 Bacteria PVC group Pseudomonadati Chlamydiota         Chlamydiota bacterium
30658299 30658299 PRJNA986481_P_NODE_253_length_1890_cov_6.629006_g193_i0 PRJNA986481 253 1890 6.629006 125.2882134 Chlamydiales bacterium 2047757 Bacteria Bacteria 456 2.0199999999999992e-148   NR MFT5319030.1 2047757 g193 i0 40.4 0.985714285714286 621 263 96.3 14 1821 1 14 541 MFT5319030.1 5-histidylcysteine sulfoxide synthase/putative 4-mercaptohistidine N1-methyltransferase [Chlamydiales bacterium] diamond 1863 456 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales bacterium
30847907 30847907 PRJNA986481_P_NODE_4054_length_768_cov_5.470097_g3658_i0 PRJNA986481 4054 768 5.470097 42.01034496 Chlamydiota bacterium 2081524 Bacteria Bacteria 59.7 2.08e-6   NR NGX39248.1 2081524 g3658 i0 28.5 0.7265625 186 105 68 6 97 618 38 207 NGX39248.1 hypothetical protein [Chlamydiota bacterium] diamond 558 59.7 1 Bacteria PVC group Pseudomonadati Chlamydiota         Chlamydiota bacterium
30974396 30974396 PRJNA986481_P_NODE_42814_length_260_cov_1.781991_g42289_i0 PRJNA986481 42814 260 1.781991 4.6331766 Candidatus Protochlamydia naegleriophila 389348 Bacteria Bacteria 166 4.799999999999999e-46   NR WP_059062019.1 389348 g42289 i0 97.7 0.992307692307692 86 2 99.2 0 3 260 135 220 WP_059062019.1 succinate dehydrogenase flavoprotein subunit [Candidatus Protochlamydia naegleriophila] diamond 258 166 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae Candidatus Protochlamydia Candidatus Protochlamydia naegleriophila
32397691 32397691 PRJNA986481_P_NODE_28219_length_309_cov_1.165385_g27694_i0 PRJNA986481 28219 309 1.165385 3.60103965 Candidatus Rhabdochlamydia porcellionis 225148 Bacteria Bacteria 46.2 0.00482   NR WP_194845061.1 225148 g27694 i0 58.5 0.398058252427184 41 17 39.8 0 2 124 130 170 WP_194845061.1 NEL-type E3 ubiquitin ligase domain-containing protein [Candidatus Rhabdochlamydia porcellionis] diamond 123 46.2 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Candidatus Rhabdochlamydiaceae Candidatus Rhabdochlamydia Candidatus Rhabdochlamydia porcellionis

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