RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1262902 · 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
1638353 1638353 PRJNA1262902_P_NODE_5202_length_276_cov_1.192118_g5160_i0 PRJNA1262902 5202 276 1.192118 3.29024568 uncultured Ruficoccus sp. 2175960 Bacteria Bacteria 52.8 0.025   NTclustered gi|2907625931|emb|OZ223491.1| 2175960 g5160 i0 91.892 0.134057971014493 37 3 13 0 213 249 76589 76553 MAG: uncultured Ruficoccus sp. isolate b2a3d85c-2e17-47e2-9e32-7ac6437316b9 genome assembly, chromosome: 20 blastn 37 52.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Puniceicoccales Cerasicoccaceae Ruficoccus uncultured Ruficoccus sp.
27105316 27105316 PRJNA1262902_P_NODE_7642_length_251_cov_0.865169_g7600_i0 PRJNA1262902 7642 251 0.865169 2.17157419 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 115 2.78e-29   NR HUB93397.1 2499141 g7600 i0 66.3 2.97609561752988 83 28 99.2 0 1 249 185 267 HUB93397.1 ABC transporter permease [Verrucomicrobiia bacterium] diamond 747 115 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
29126794 29126794 PRJNA1262902_P_NODE_9189_length_247_cov_0.885057_g9147_i0 PRJNA1262902 9189 247 0.885057 2.18609079 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 47.8 6.55e-4   NR MCX6902751.1 2026799 g9147 i0 35.1 0.692307692307692 57 30 69.2 1 47 217 240 289 MCX6902751.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 171 47.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29333823 29333823 PRJNA1262902_P_NODE_9549_length_246_cov_1.774566_g9507_i0 PRJNA1262902 9549 246 1.774566 4.36543236 PVC group 1783257 Bacteria Bacteria 116 2.0099999999999999e-28   NR HXI82039.1 2499141 g9507 i0 62.9 2.10975609756098 89 26 100 2 1 246 283 371 HXI82039.1 pilus assembly protein TadG-related protein [Verrucomicrobiia bacterium] diamond 519 117 0.991452991452991 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
30863705 30863705 PRJNA1262902_P_NODE_11714_length_242_cov_0.911243_g11672_i0 PRJNA1262902 11714 242 0.911243 2.20520806 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 125 7.01e-33   NR MDP9292101.1 2026799 g11672 i0 74.7 1.97107438016529 79 20 97.9 0 4 240 77 155 MDP9292101.1 glycosyltransferase family 2 protein [Verrucomicrobiota bacterium] diamond 477 125 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31622440 31622440 PRJNA1262902_P_NODE_9816_length_246_cov_0.890173_g9774_i0 PRJNA1262902 9816 246 0.890173 2.18982558 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 100 1.01e-22   NR MBV9126863.1 2026799 g9774 i0 67.1 1 82 27 100 0 246 1 361 442 MBV9126863.1 TolC family protein [Verrucomicrobiota bacterium] diamond 246 100 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota 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);;