RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 6 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 6 ✖

bioproject 1

  • PRJNA835051 · 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
17807120 17807120 PRJNA835051_S_NODE_63514_length_200_cov_3.025478_g63218_i0 PRJNA835051 63514 200 3.025478 6.050956 Bacteria 2 Bacteria Bacteria 191 3.53e-44   NTclustered gi|226525339|gb|FJ872375.1| 156588 g63218 i0 90.476 213.52 147 11 73 3 3 148 27616 27472 Uncultured Verrucomicrobia bacterium clone 286 genomic sequence blastn 42704 191 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         uncultured Verrucomicrobiota bacterium
26833195 26833195 PRJNA835051_S_NODE_5581_length_378_cov_1.850746_g5285_i0 PRJNA835051 5581 378 1.850746 6.99581988 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 62 1.26e-8   NR MBE6414843.1 2026800 g5285 i0 70.8 0.380952380952381 48 13 37.3 1 238 98 184 231 MBE6414843.1 PEP-CTERM sorting domain-containing protein [Verrucomicrobiaceae bacterium] diamond 144 62 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
27686825 27686825 PRJNA835051_S_NODE_118424_length_157_cov_2.500000_g118128_i0 PRJNA835051 118424 157 2.5 3.925 Verrucomicrobium sp. GAS474 1882831 Bacteria Bacteria 41.2 0.04   NR WP_157895220.1 1882831 g118128 i0 50 0.64968152866242 34 17 65 0 113 12 878 911 WP_157895220.1 sugar-binding protein [Verrucomicrobium sp. GAS474] diamond 102 41.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Verrucomicrobium Verrucomicrobium sp. GAS474
27686828 27686828 PRJNA835051_S_NODE_24684_length_263_cov_1.068182_g24388_i0 PRJNA835051 24684 263 1.068182 2.80931866 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 42.7 0.0468   NR MES2707423.1 2026799 g24388 i0 39 0.673003802281369 59 34 67.3 1 247 71 429 485 MES2707423.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 177 42.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29643678 29643678 PRJNA835051_S_NODE_9690_length_328_cov_1.996491_g9394_i0 PRJNA835051 9690 328 1.996491 6.54849048 Opitutales bacterium 2026772 Bacteria Bacteria 43.9 0.0357   NR MBT5816278.1 2026772 g9394 i0 51.1 0.411585365853659 45 15 37.5 3 268 146 83 124 MBT5816278.1 LacI family DNA-binding transcriptional regulator [Opitutales bacterium] diamond 135 43.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales     Opitutales bacterium
31002577 31002577 PRJNA835051_S_NODE_77994_length_186_cov_2.615385_g77698_i0 PRJNA835051 77994 186 2.615385 4.8646161 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 41.6 0.0352   NR MBK8041134.1 2026800 g77698 i0 48.8 0.693548387096774 43 21 69.4 1 129 1 68 109 MBK8041134.1 YaeQ family protein [Verrucomicrobiaceae bacterium] diamond 129 41.6 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae 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);;