RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA804229" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 8 ✖

bioproject 1

  • PRJNA804229 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
28042242 28042242 PRJNA804229_S_NODE_89525_length_215_cov_1.651163_g88567_i0 PRJNA804229 89525 215 1.651163 3.55000045 Candidatus Similichlamydia 1348235 Bacteria Bacteria 91.3 4.19e-21   NR KPK32738.1 1704235 g88567 i0 56.3 5.87441860465116 71 31 99.1 0 213 1 13 83 KPK32738.1 MAG: antitermination protein NusG [Chlamydiae bacterium SM23_39] diamond 1263 91.7 0.995637949836423 Bacteria PVC group Pseudomonadati Chlamydiota         Chlamydiae bacterium SM23_39
28222566 28222566 PRJNA804229_S_NODE_141866_length_171_cov_1.875000_g140908_i0 PRJNA804229 141866 171 1.875 3.20625 Lentisphaerota bacterium 1932692 Bacteria Bacteria 43.9 0.00548   NR NLB65222.1 1932692 g140908 i0 38.1 0.736842105263158 42 26 73.7 0 24 149 333 374 NLB65222.1 hypothetical protein [Lentisphaerota bacterium] diamond 126 43.9 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
28412271 28412271 PRJNA804229_S_NODE_189586_length_150_cov_0.897196_g188628_i0 PRJNA804229 189586 150 0.897196 1.345794 Chlamydia psittaci 83554 Bacteria Bacteria 41.6 0.00421   NR EPJ15322.1 1112256 g188628 i0 63.6 1.96 33 12 66 0 106 8 8 40 EPJ15322.1 retrovirus-related Pol polyLINE-1 domain protein, partial [Chlamydia psittaci 02DC18] diamond 294 41.6 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia psittaci
29801328 29801328 PRJNA804229_S_NODE_162231_length_160_cov_1.230769_g161273_i0 PRJNA804229 162231 160 1.230769 1.9692304 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 41.2 0.0423   NR MFM8476281.1 2026779 g161273 i0 43.2 1.44375 37 21 69.4 0 153 43 53 89 MFM8476281.1 sulfite exporter TauE/SafE family protein [Planctomycetaceae bacterium] diamond 231 41.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
30053983 30053983 PRJNA804229_S_NODE_83171_length_223_cov_1.833333_g82213_i0 PRJNA804229 83171 223 1.833333 4.08833259 Phycisphaerae bacterium 2026778 Bacteria Bacteria 43.1 0.0193   NR MBN1513813.1 2026778 g82213 i0 43.8 0.430493273542601 32 18 43 0 194 99 185 216 MBN1513813.1 hypothetical protein [Phycisphaerae bacterium] diamond 96 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
30528024 30528024 PRJNA804229_S_NODE_107333_length_197_cov_0.935065_g106375_i0 PRJNA804229 107333 197 0.935065 1.84207805 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 42.7 0.0204   NR HXR03150.1 2499141 g106375 i0 44.7 0.715736040609137 47 25 71.6 1 183 43 273 318 HXR03150.1 DUF4185 domain-containing protein [Verrucomicrobiia bacterium] diamond 141 42.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
30907439 30907439 PRJNA804229_S_NODE_152734_length_165_cov_1.409836_g151776_i0 PRJNA804229 152734 165 1.409836 2.3262294 Lentisphaerota bacterium 1932692 Bacteria Bacteria 42.4 0.0185   NR NLB65222.1 1932692 g151776 i0 46.3 0.745454545454545 41 22 74.5 0 10 132 352 392 NLB65222.1 hypothetical protein [Lentisphaerota bacterium] diamond 123 42.4 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
32014010 32014010 PRJNA804229_S_NODE_110938_length_193_cov_3.520000_g109980_i0 PRJNA804229 110938 193 3.52 6.7936 Candidatus Similichlamydia laticola 2170265 Bacteria Bacteria 108 3.22e-26   NR WP_114544175.1 2170265 g109980 i0 81.3 0.994818652849741 64 12 99.5 0 2 193 191 254 WP_114544175.1 elongation factor Tu [Candidatus Similichlamydia laticola] diamond 192 108 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Candidatus Parilichlamydiaceae Candidatus Similichlamydia Candidatus Similichlamydia laticola

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