RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA784298" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA784298 · 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
29011912 29011912 PRJNA784298_P_NODE_23788_length_251_cov_0.865169_g23587_i0 PRJNA784298 23788 251 0.865169 2.17157419 Planctomycetota bacterium 2026780 Bacteria Bacteria 146 6.319999999999998e-42   NR RIK83425.1 2026780 g23587 i0 81.5 0.968127490039841 81 15 96.8 0 2 244 138 218 RIK83425.1 MAG: lysine decarboxylase [Planctomycetota bacterium] diamond 243 146 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29021195 29021195 PRJNA784298_P_NODE_24088_length_250_cov_0.870056_g23887_i0 PRJNA784298 24088 250 0.870056 2.17514 Bacteria 2 Bacteria Bacteria 156 8.02e-45   NR MBC8117164.1 2026779 g23887 i0 97.6 5.964 83 2 99.6 0 250 2 115 197 MBC8117164.1 3-oxoacyl-ACP synthase III [Planctomycetaceae bacterium] diamond 1491 156 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
29043309 29043309 PRJNA784298_P_NODE_16628_length_304_cov_2.359307_g16427_i0 PRJNA784298 16628 304 2.359307 7.17229328 Fuerstiella sp. 1936112 Bacteria Bacteria 45.8 0.00123   NR MDG1896833.1 1936112 g16427 i0 40.5 1.44078947368421 74 41 70.1 1 281 69 12 85 MDG1896833.1 hypothetical protein [Fuerstiella sp.] diamond 438 45.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Fuerstiella Fuerstiella sp.
29453259 29453259 PRJNA784298_P_NODE_13030_length_346_cov_1.128205_g12829_i0 PRJNA784298 13030 346 1.128205 3.9035893 Planctomycetota bacterium 2026780 Bacteria Bacteria 45.4 0.0139   NR MEY3172301.1 2026780 g12829 i0 54.3 0.303468208092486 35 16 30.3 0 37 141 838 872 MEY3172301.1 hypothetical protein [Planctomycetota bacterium] diamond 105 45.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29579666 29579666 PRJNA784298_P_NODE_3110_length_723_cov_3.227692_g2921_i0 PRJNA784298 3110 723 3.227692 23.33621316 Phycisphaerales bacterium 2052180 Bacteria Bacteria 277 3.73e-88   NR MEN6384997.1 2052180 g2921 i0 58.4 0.908713692946058 219 88 89.6 1 711 64 195 413 MEN6384997.1 DUF2828 family protein [Phycisphaerales bacterium] diamond 657 277 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
31263644 31263644 PRJNA784298_P_NODE_18515_length_287_cov_4.056075_g18314_i0 PRJNA784298 18515 287 4.056075 11.64093525 Bacteria 2 Bacteria Bacteria 71.6 4.43e-12   NR MBN8644055.1 2026780 g18314 i0 46.2 2.91637630662021 78 42 81.5 0 253 20 11 88 MBN8644055.1 DNA topoisomerase (ATP-hydrolyzing) subunit B [Planctomycetota bacterium] diamond 837 71.6 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);;