RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA758087", 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

  • PRJNA758087 · 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
2009999 2009999 PRJNA758087_P_NODE_9462_length_1058_cov_16.345178_g8432_i0 PRJNA758087 9462 1058 16.345178 172.93198324 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 240 3.389999999999999e-68   NR MEI6603943.1 2026799 g8432 i0 44.7 4.21644612476371 293 160 82.8 2 1025 150 250 541 MEI6603943.1 rhamnan synthesis F family protein [Verrucomicrobiota bacterium] diamond 4461 240 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
4562357 4562357 PRJNA758087_P_NODE_8064_length_1166_cov_23.376029_g7110_i0 PRJNA758087 8064 1166 23.376029 272.56449814 Prosthecobacter sp. 1965333 Bacteria Bacteria 590 1.5e-205   NR WP_397380455.1 1965333 g7110 i0 89.1 0.895368782161235 348 32 88 2 1050 25 1 348 WP_397380455.1 putative porin [Prosthecobacter sp.] diamond 1044 590 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter sp.
8855652 8855652 PRJNA758087_P_NODE_10147_length_1009_cov_18.641026_g9085_i0 PRJNA758087 10147 1009 18.641026 188.08795234 Verrucomicrobia bacterium 12-59-8 1970608 Bacteria Bacteria 524 4.6999999999999984e-183   NR OYW70787.1 1970608 g9085 i0 100 0.814667988107037 274 0 81.5 0 164 985 1 274 OYW70787.1 MAG: IS5/IS1182 family transposase [Verrucomicrobia bacterium 12-59-8] diamond 822 524 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobia bacterium 12-59-8
19860053 19860053 PRJNA758087_P_NODE_14676_length_779_cov_54.726629_g13457_i0 PRJNA758087 14676 779 54.726629 426.32043991 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 454 2.8399999999999996e-156   NR MBN8419734.1 2026799 g13457 i0 92 0.958921694480103 249 20 95.9 0 26 772 85 333 MBN8419734.1 response regulator [Verrucomicrobiota bacterium] diamond 747 454 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29768570 29768570 PRJNA758087_P_NODE_15931_length_734_cov_6.919818_g14681_i0 PRJNA758087 15931 734 6.919818 50.79146412 Prosthecobacter sp. 1965333 Bacteria Bacteria 431 1.0599999999999999e-136   NR WP_397382958.1 1965333 g14681 i0 93.4 0.935967302452316 229 15 93.6 0 17 703 980 1208 WP_397382958.1 PAS domain S-box protein [Prosthecobacter sp.] diamond 687 431 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter sp.
31475162 31475162 PRJNA758087_P_NODE_21056_length_588_cov_6.355340_g19745_i0 PRJNA758087 21056 588 6.35534 37.3693992 Opitutaceae bacterium 2006848 Bacteria Bacteria 96.7 2.4e-19   NR HTZ19767.1 2006848 g19745 i0 66.2 3.94387755102041 77 25 39.3 1 132 362 504 579 HTZ19767.1 NHL repeat-containing protein [Opitutaceae bacterium] diamond 2319 96.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae 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);;