RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA482207", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 6 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 6 ✖

bioproject 1

  • PRJNA482207 · 6 ✖

analysis 1

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
26886639 26886639 PRJNA482207_P_NODE_19581_length_251_cov_0.865169_g19471_i0 PRJNA482207 19581 251 0.865169 2.17157419 Pelagicoccus mobilis 415221 Bacteria Bacteria 171 2.44e-48   NR WP_200357570.1 415221 g19471 i0 96.4 0.99203187250996006 83 3 99.2 0 3 251 402 484 WP_200357570.1 DUF5060 domain-containing protein [Pelagicoccus mobilis] diamond 249 171 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Puniceicoccales Pelagicoccaceae Pelagicoccus Pelagicoccus mobilis
26997297 26997297 PRJNA482207_P_NODE_24742_length_246_cov_0.890173_g24632_i0 PRJNA482207 24742 246 0.890173 2.18982558 Bacteria 2 Bacteria Bacteria 72.4 1.33e-12   NR MEZ5387083.1 1965333 g24632 i0 42.9 3.73170731707317 77 44 93.9 0 14 244 285 361 MEZ5387083.1 hypothetical protein [Prosthecobacter sp.] diamond 918 72.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter sp.
27076266 27076266 PRJNA482207_P_NODE_11442_length_314_cov_1.597510_g11332_i0 PRJNA482207 11442 314 1.59751 5.0161814 Akkermansiaceae bacterium 2562705 Bacteria Bacteria 103 4.76e-23   NR MDF1714278.1 2562705 g11332 i0 62.5 2.96178343949045 80 30 76.4 0 74 313 1 80 MDF1714278.1 thiamine pyrophosphate-binding protein [Akkermansiaceae bacterium] diamond 930 103 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae   Akkermansiaceae bacterium
30076161 30076161 PRJNA482207_P_NODE_23112_length_248_cov_0.880000_g23002_i0 PRJNA482207 23112 248 0.88 2.1824 Pelagicoccus sp. SDUM812 2921790 Bacteria Bacteria 162 1.97e-46   NR WP_309016588.1 3041267 g23002 i0 93.9 0.991935483870968 82 5 99.2 0 2 247 111 192 WP_309016588.1 DNA-binding transcriptional regulator [Pelagicoccus sp. SDUM812003] diamond 246 162 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Puniceicoccales Pelagicoccaceae Pelagicoccus Pelagicoccus sp. SDUM812003
31340226 31340226 PRJNA482207_P_NODE_27036_length_244_cov_0.900585_g26926_i0 PRJNA482207 27036 244 0.900585 2.1974274 Akkermansiaceae bacterium 2562705 Bacteria Bacteria 136 3.76e-36   NR MEJ6718064.1 2562705 g26926 i0 79 0.995901639344262 81 17 99.6 0 243 1 216 296 MEJ6718064.1 sulfatase-like hydrolase/transferase [Akkermansiaceae bacterium] diamond 243 136 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae   Akkermansiaceae bacterium
32574288 32574288 PRJNA482207_P_NODE_24699_length_246_cov_0.890173_g24589_i0 PRJNA482207 24699 246 0.890173 2.18982558 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 46.2 0.00203   NR MBG89543.1 2026801 g24589 i0 80.8 0.317073170731707 26 5 31.7 0 5 82 234 259 MBG89543.1 hypothetical protein [Verrucomicrobiales bacterium] diamond 78 46.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales 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);;