RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA345071" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA345071 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
11273584 11273584 PRJNA345071_P_NODE_2129_length_390_cov_1.684543_g2089_i0 PRJNA345071 2129 390 1.684543 6.5697177 Planctomycetia 203683 Bacteria Bacteria 160 4.54e-44   NR WP_075092413.1 1632864 g2089 i0 58.1 13.9 129 53 99.2 1 3 389 230 357 WP_075092413.1 aldehyde dehydrogenase family protein [Planctomyces sp. SH-PL14] diamond 5421 161 0.993788819875776 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL14
18245033 18245033 PRJNA345071_P_NODE_8955_length_248_cov_0.891429_g8915_i0 PRJNA345071 8955 248 0.891429 2.21074392 Bacteria 2 Bacteria Bacteria 161 1.05e-46   NR TMQ35404.1 2026780 g8915 i0 91.5 6.93145161290323 82 7 99.2 0 247 2 34 115 TMQ35404.1 MAG: mandelate racemase/muconate lactonizing enzyme family protein [Planctomycetota bacterium] diamond 1719 161 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27106206 27106206 PRJNA345071_P_NODE_9262_length_247_cov_0.896552_g9222_i0 PRJNA345071 9262 247 0.896552 2.21448344 Planctomycetota bacterium 2026780 Bacteria Bacteria 87 7.76e-18   NR MBA3699814.1 2026780 g9222 i0 56 1.02024291497976 84 33 97.2 2 245 6 343 426 MBA3699814.1 metallophosphoesterase family protein [Planctomycetota bacterium] diamond 252 87 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29064395 29064395 PRJNA345071_P_NODE_6548_length_266_cov_1.492228_g6508_i0 PRJNA345071 6548 266 1.492228 3.96932648 Planctomycetota bacterium 2026780 Bacteria Bacteria 86.3 3.69e-18   NR MEO0652808.1 2026780 g6508 i0 71.7 1.19548872180451 53 15 59.8 0 2 160 206 258 MEO0652808.1 3-hydroxyacyl-CoA dehydrogenase NAD-binding domain-containing protein [Planctomycetota bacterium] diamond 318 86.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30218267 30218267 PRJNA345071_P_NODE_10412_length_243_cov_0.917647_g10372_i0 PRJNA345071 10412 243 0.917647 2.22988221 Pseudomonadati 3379134 Bacteria Bacteria 113 6.080000000000001e-27   NR MBL4848360.1 2026780 g10372 i0 73.1 8.64197530864197 78 21 96.3 0 238 5 468 545 MBL4848360.1 hypothetical protein [Planctomycetota bacterium] diamond 2100 114 0.991228070175439 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30611736 30611736 PRJNA345071_P_NODE_8693_length_249_cov_0.886364_g8653_i0 PRJNA345071 8693 249 0.886364 2.20704636 Schlesneria paludicola 360056 Bacteria Bacteria 46.2 0.00251   NR WP_010586447.1 360056 g8653 i0 44.2 0.518072289156627 43 23 50.6 1 4 129 85 127 WP_010586447.1 YCF48-related protein [Schlesneria paludicola] diamond 129 46.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Schlesneria Schlesneria paludicola
32792638 32792638 PRJNA345071_P_NODE_1860_length_411_cov_3.142012_g1820_i0 PRJNA345071 1860 411 3.142012 12.91366932 Planctomycetota bacterium 2026780 Bacteria Bacteria 167 2.52e-48   NR NOT29227.1 2026780 g1820 i0 59.7 3.90510948905109 134 54 97.8 0 407 6 89 222 NOT29227.1 3-hydroxybutyryl-CoA dehydrogenase [Planctomycetota bacterium] diamond 1605 167 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota 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);;