RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA685060", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 6 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 6 ✖

bioproject 1

  • PRJNA685060 · 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
12145467 12145467 PRJNA685060_P_NODE_12970_length_255_cov_2.274725_g12880_i0 PRJNA685060 12970 255 2.274725 5.80054875 Phycisphaeraceae bacterium D3-23 3004190 Bacteria Bacteria 145 3.7199999999999995e-30   NTclustered gi|2727577647|gb|CP114179.1| 3004190 g12880 i0 78.205 2.0078431372549 234 45 91 5 1 231 4074611 4074841 Phycisphaeraceae bacterium D3-23 chromosome, complete genome blastn 512 145 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium D3-23
24892282 24892282 PRJNA685060_P_NODE_17020_length_242_cov_0.911243_g16930_i0 PRJNA685060 17020 242 0.911243 2.20520806 Phycisphaerales bacterium 2052180 Bacteria Bacteria 99 1.4699999999999999e-24   NR MCK4873632.1 2052180 g16930 i0 61.3 2.97520661157025 80 31 99.2 0 240 1 30 109 MCK4873632.1 hypothetical protein [Phycisphaerales bacterium] diamond 720 99 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
28535123 28535123 PRJNA685060_P_NODE_10047_length_298_cov_0.862222_g9957_i0 PRJNA685060 10047 298 0.862222 2.56942156 Planctomycetota bacterium 2026780 Bacteria Bacteria 45.4 0.00808   NR MCY2932085.1 2026780 g9957 i0 41.5 0.654362416107383 65 38 65.4 0 38 232 55 119 MCY2932085.1 sigma-70 family RNA polymerase sigma factor [Planctomycetota bacterium] diamond 195 45.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28535137 28535137 PRJNA685060_P_NODE_4467_length_459_cov_2.507772_g4377_i0 PRJNA685060 4467 459 2.507772 11.51067348 Planctomycetota bacterium 2026780 Bacteria Bacteria 94.7 2.98e-19   NR MEE2886150.1 2026780 g4377 i0 41.5 4.88235294117647 147 74 95.4 5 17 454 1962 2097 MEE2886150.1 hypothetical protein [Planctomycetota bacterium] diamond 2241 94.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30777374 30777374 PRJNA685060_P_NODE_16034_length_245_cov_0.895349_g15944_i0 PRJNA685060 16034 245 0.895349 2.19360505 Phycisphaerales bacterium 2052180 Bacteria Bacteria 55.1 1.39e-6   NR HVZ93246.1 2052180 g15944 i0 42.7 0.918367346938776 75 38 85.7 1 1 210 92 166 HVZ93246.1 hypothetical protein [Phycisphaerales bacterium] diamond 225 55.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
32548587 32548587 PRJNA685060_P_NODE_13999_length_250_cov_0.870056_g13909_i0 PRJNA685060 13999 250 0.870056 2.17514 Aeoliella straminimaris 2954799 Bacteria Bacteria 107 6.71e-25   NR WP_252854990.1 2954799 g13909 i0 85 0.72 60 9 72 0 70 249 434 493 WP_252854990.1 ABC transporter permease subunit [Aeoliella straminimaris] diamond 180 107 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Aeoliella Aeoliella straminimaris

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