RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA399133" 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

bioproject 1

  • PRJNA399133 · 6 ✖

analysis 1

  • diamond · 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
27233462 27233462 PRJNA399133_P_NODE_5783_length_219_cov_2.929348_g5695_i0 PRJNA399133 5783 219 2.929348 6.41527212 Akkermansiaceae bacterium 2562705 Bacteria Bacteria 68.9 2.66e-12   NR MDB4418055.1 2562705 g5695 i0 62.5 0.767123287671233 56 21 76.7 0 50 217 44 99 MDB4418055.1 hypothetical protein [Akkermansiaceae bacterium] diamond 168 68.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae   Akkermansiaceae bacterium
27454839 27454839 PRJNA399133_P_NODE_463_length_785_cov_3.044000_g304_i1 PRJNA399133 463 785 3.044 23.8954 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 80.5 4.03e-14   NR NBQ64003.1 2026799 g304 i1 46.1 1.03566878980892 89 43 33.6 3 10 273 119 203 NBQ64003.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 813 80.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
30580724 30580724 PRJNA399133_P_NODE_4413_length_241_cov_2.160194_g4325_i0 PRJNA399133 4413 241 2.160194 5.20606754 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 44.3 0.00985   NR NBV48909.1 2026799 g4325 i0 76.9 0.323651452282158 26 6 32.4 0 83 6 52 77 NBV48909.1 phage major capsid protein [Verrucomicrobiota bacterium] diamond 78 44.3 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31117801 31117801 PRJNA399133_P_NODE_5135_length_229_cov_1.876289_g5047_i0 PRJNA399133 5135 229 1.876289 4.29670181 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 47.8 5.11e-4   NR MCD6049097.1 2026799 g5047 i0 36.8 0.890829694323144 68 30 89.1 1 206 3 1 55 MCD6049097.1 sensor hybrid histidine kinase [Verrucomicrobiota bacterium] diamond 204 47.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31940186 31940186 PRJNA399133_P_NODE_6417_length_207_cov_2.174419_g6329_i0 PRJNA399133 6417 207 2.174419 4.50104733 Akkermansiaceae bacterium 2562705 Bacteria Bacteria 106 2.32e-25   NR MDB4418045.1 2562705 g6329 i0 69.6 1 69 21 100 0 1 207 163 231 MDB4418045.1 hypothetical protein [Akkermansiaceae bacterium] diamond 207 106 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae   Akkermansiaceae bacterium
32793290 32793290 PRJNA399133_P_NODE_8120_length_184_cov_1.610738_g8032_i0 PRJNA399133 8120 184 1.610738 2.96375792 Akkermansiaceae bacterium 2562705 Bacteria Bacteria 66.6 6.46e-11   NR MDB4571673.1 2562705 g8032 i0 50 1.89130434782609 58 29 94.6 0 181 8 470 527 MDB4571673.1 hypothetical protein [Akkermansiaceae bacterium] diamond 348 66.6 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae   Akkermansiaceae 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);;