RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA971676 · 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
28042984 28042984 PRJNA971676_P_NODE_17685_length_247_cov_0.885057_g17596_i0 PRJNA971676 17685 247 0.885057 2.18609079 Bacteria 2 Bacteria Bacteria 45.1 0.00595   NR MBS0604814.1 2026799 g17596 i0 32.9 2.5748987854251 79 46 88.7 2 23 241 312 389 MBS0604814.1 O-antigen ligase family protein [Verrucomicrobiota bacterium] diamond 636 45.4 0.993392070484582 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29583511 29583511 PRJNA971676_P_NODE_12090_length_267_cov_0.912371_g12001_i0 PRJNA971676 12090 267 0.912371 2.43603057 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 43.9 0.0186   NR MDR3456640.1 2499141 g12001 i0 72.4 0.325842696629214 29 8 32.6 0 88 2 24 52 MDR3456640.1 glycoside hydrolase family 28 protein [Verrucomicrobiia bacterium] diamond 87 43.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
29874355 29874355 PRJNA971676_P_NODE_9311_length_294_cov_1.393665_g9222_i0 PRJNA971676 9311 294 1.393665 4.0973751 Bacteria 2 Bacteria Bacteria 54.3 6.26e-6   NR TAK98470.1 2026799 g9222 i0 43.2 7.1530612244898 88 48 89.8 2 288 25 89 174 TAK98470.1 MAG: hypothetical protein EPO07_12005, partial [Verrucomicrobiota bacterium] diamond 2103 54.3 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31321425 31321425 PRJNA971676_P_NODE_18295_length_246_cov_1.127168_g18206_i0 PRJNA971676 18295 246 1.127168 2.77283328 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 42.4 0.049   NR MFM1748863.1 2026799 g18206 i0 37.9 0.707317073170732 58 31 70.7 1 15 188 7 59 MFM1748863.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 174 42.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
32144005 32144005 PRJNA971676_P_NODE_9258_length_295_cov_1.040541_g9169_i0 PRJNA971676 9258 295 1.040541 3.06959595 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 81.6 1.49e-15   NR MCX6968401.1 2026799 g9169 i0 50.7 1.86101694915254 75 37 76.3 0 226 2 544 618 MCX6968401.1 PAS domain S-box protein [Verrucomicrobiota bacterium] diamond 549 81.6 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
32775705 32775705 PRJNA971676_P_NODE_17060_length_248_cov_0.880000_g16971_i0 PRJNA971676 17060 248 0.88 2.1824 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 49.7 1.51e-5   NR RYD84282.1 2026800 g16971 i0 47.9 0.858870967741935 71 31 85.9 2 2 214 4 68 RYD84282.1 MAG: hypothetical protein EOP84_05925, partial [Verrucomicrobiaceae bacterium] diamond 213 49.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);;