RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA692200 · 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
4500950 4500950 PRJNA692200_S_NODE_6084_length_270_cov_1.574661_g6027_i0 PRJNA692200 6084 270 1.574661 4.2515847 root 1 Root_unresolved Root_unresolved 103 2.35e-25   NR MBI5273906.1 2047757 g6027 i0 61.3 4.95555555555556 75 29 83.3 0 267 43 126 200 MBI5273906.1 superoxide dismutase [Chlamydiales bacterium] diamond 1338 104 0.990384615384615 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales bacterium
19030932 19030932 PRJNA692200_S_NODE_14335_length_191_cov_3.323944_g14278_i0 PRJNA692200 14335 191 3.323944 6.34873304 Fuerstiella marisgermanici 1891926 Bacteria Bacteria 78.2 6.46e-16   NR WP_077025744.1 1891926 g14278 i0 72 4.05235602094241 50 14 78.5 0 188 39 151 200 WP_077025744.1 peptidylprolyl isomerase [Fuerstiella marisgermanici] diamond 774 78.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Fuerstiella Fuerstiella marisgermanici
29293041 29293041 PRJNA692200_S_NODE_6489_length_264_cov_5.874419_g6432_i0 PRJNA692200 6489 264 5.874419 15.50846616 Bythopirellula sp. 2964542 Bacteria Bacteria 71.2 3.21e-12   NR MDZ4656855.1 2964542 g6432 i0 61.8 2.71590909090909 55 21 62.5 0 264 100 278 332 MDZ4656855.1 isocitrate/isopropylmalate dehydrogenase family protein [Bythopirellula sp.] diamond 717 71.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Bythopirellula Bythopirellula sp.
29513922 29513922 PRJNA692200_S_NODE_11650_length_209_cov_3.031250_g11593_i0 PRJNA692200 11650 209 3.03125 6.3353125 Phycisphaerales bacterium 2052180 Bacteria Bacteria 42 0.0458   NR MEQ9096010.1 2052180 g11593 i0 42.3 0.746411483253589 52 26 74.6 1 15 170 11 58 MEQ9096010.1 hypothetical protein [Phycisphaerales bacterium] diamond 156 42 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
29956209 29956209 PRJNA692200_S_NODE_14751_length_189_cov_1.607143_g14694_i0 PRJNA692200 14751 189 1.607143 3.03750027 Candidatus Omnitrophica bacterium CG1_ 2035772 Bacteria Bacteria 41.6 0.0477   NR OIO36946.1 1805287 g14694 i0 41.7 0.761904761904762 48 23 68.3 1 43 171 153 200 OIO36946.1 MAG: glucose-1-phosphate adenylyltransferase [Candidatus Omnitrophica bacterium CG1_02_44_16] diamond 144 41.6 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota       Candidatus Phelpsiimicrobium Candidatus Phelpsiimicrobium noxiivivens
30967382 30967382 PRJNA692200_S_NODE_4554_length_298_cov_3.176707_g4497_i0 PRJNA692200 4554 298 3.176707 9.46658686 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 71.2 3.25e-12   NR MDX1565183.1 2026777 g4497 i0 54.1 0.614093959731544 61 28 61.4 0 287 105 223 283 MDX1565183.1 aldolase/citrate lyase family protein [Phycisphaeraceae bacterium] diamond 183 71.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae 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);;