RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB8827 · 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
25802434 25802434 PRJEB8827h_S_NODE_1939_length_236_cov_298.597015_g1920_i0 PRJEB8827 1939 236 298.597015 704.6889554 Phycisphaerae bacterium 2026778 Bacteria Bacteria 65.1 4.29e-10   NR MAC19092.1 2026778 g1920 i0 71.1 6.27966101694915 45 13 57.2 0 207 73 363 407 MAC19092.1 cystathionine beta-lyase [Phycisphaerae bacterium] diamond 1482 65.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
25802462 25802462 PRJEB8827h_S_NODE_34355_length_172_cov_2.627737_g34336_i0 PRJEB8827 34355 172 2.627737 4.51970764 root 1 Root_unresolved Root_unresolved 75.1 7.75e-15   NR WP_041016398.1 340071 g34336 i0 76.9 18.9244186046512 39 9 68 0 172 56 163 201 WP_041016398.1 Fe-Mn family superoxide dismutase [Criblamydia sequanensis] diamond 3255 75.5 0.994701986754967 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Candidatus Criblamydiaceae Candidatus Criblamydia Candidatus Criblamydia sequanensis
32931169 32931169 PRJEB8827e_S_NODE_9953_length_193_cov_2.063291_g9925_i0 PRJEB8827 9953 193 2.063291 3.98215163 Planctomycetota bacterium 2026780 Bacteria Bacteria 71.2 2.36e-14   NR MBP9893365.1 2026780 g9925 i0 64.8 0.839378238341969 54 19 83.9 0 165 4 3 56 MBP9893365.1 hypothetical protein [Planctomycetota bacterium] diamond 162 71.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32931341 32931341 PRJEB8827h_S_NODE_29201_length_176_cov_4.574468_g29182_i0 PRJEB8827 29201 176 4.574468 8.05106368 Phycisphaerales bacterium 2052180 Bacteria Bacteria 41.2 0.0477   NR MDB5304208.1 2052180 g29182 i0 42.1 0.647727272727273 38 22 64.8 0 142 29 24 61 MDB5304208.1 hypothetical protein [Phycisphaerales bacterium] diamond 114 41.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
32999644 32999644 PRJEB8827g_S_NODE_483_length_376_cov_4.114370_g462_i0 PRJEB8827 483 376 4.11437 15.4700312 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 152 1.24e-41   NR MAT70362.1 2026779 g462 i0 68.5 0.98936170212766 124 39 98.9 0 3 374 61 184 MAT70362.1 hypothetical protein [Planctomycetaceae bacterium] diamond 372 152 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
33094157 33094157 PRJEB8827f_S_NODE_13902_length_173_cov_2.514493_g13882_i0 PRJEB8827 13902 173 2.514493 4.35007289 Pseudomonadati 3379134 Bacteria Bacteria 64.7 8.95e-11   NR MCH8475670.1 2026772 g13882 i0 57.7 8.6878612716763 52 22 90.2 0 159 4 125 176 MCH8475670.1 acetyltransferase [Opitutales bacterium] diamond 1503 64.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales     Opitutales 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);;