RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA832865 · 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
27022931 27022931 PRJNA832865_S_NODE_14642_length_1070_cov_30.954865_g8286_i2 PRJNA832865 14642 1070 30.954865 331.2170555 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 81.3 5.93e-14   NR MFH0952965.1 2026799 g8286 i2 42.4 0.698130841121495 85 48 23.8 1 708 454 118 201 MFH0952965.1 ATP-dependent Clp endopeptidase proteolytic subunit ClpP [Verrucomicrobiota bacterium] diamond 747 81.3 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
27180792 27180792 PRJNA832865_S_NODE_49482_length_361_cov_1.829861_g44396_i0 PRJNA832865 49482 361 1.829861 6.60579821 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 48.5 0.00133   NR HEU5068864.1 2499141 g44396 i0 37.7 0.506925207756233 61 29 44 3 229 71 517 576 HEU5068864.1 MFS transporter [Verrucomicrobiia bacterium] diamond 183 48.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
27180810 27180810 PRJNA832865_S_NODE_87762_length_261_cov_0.819149_g82676_i0 PRJNA832865 87762 261 0.819149 2.13797889 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 68.9 4.24e-12   NR MBT3191068.1 2026799 g82676 i0 38.4 8.45977011494253 86 52 98.9 1 259 2 101 185 MBT3191068.1 ATP-dependent Clp protease proteolytic subunit [Verrucomicrobiota bacterium] diamond 2208 68.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
27718383 27718383 PRJNA832865_S_NODE_11364_length_1334_cov_34.475813_g8286_i0 PRJNA832865 11364 1334 34.475813 459.90734542 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 99.4 4.32e-20   NR MFH0952965.1 2026799 g8286 i0 44.4 0.22263868065967 99 54 22.3 1 585 881 104 201 MFH0952965.1 ATP-dependent Clp endopeptidase proteolytic subunit ClpP [Verrucomicrobiota bacterium] diamond 297 99.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
30117657 30117657 PRJNA832865_S_NODE_47472_length_371_cov_1.419463_g42386_i0 PRJNA832865 47472 371 1.419463 5.26620773 Opitutales bacterium 2026772 Bacteria Bacteria 44.3 0.0403   NR MEL0005672.1 2026772 g42386 i0 44.1 0.549865229110512 68 32 51.8 4 300 109 111 176 MEL0005672.1 substrate-binding domain-containing protein [Opitutales bacterium] diamond 204 44.3 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales     Opitutales bacterium
32109382 32109382 PRJNA832865_S_NODE_74198_length_286_cov_1.112676_g69112_i0 PRJNA832865 74198 286 1.112676 3.18225336 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 42.7 0.0257   NR MEI6535485.1 2026800 g69112 i0 38.2 0.576923076923077 55 32 57.7 1 237 73 21 73 MEI6535485.1 hypothetical protein [Verrucomicrobiaceae bacterium] diamond 165 42.7 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);;