RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA382558" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA382558 · 14 ✖

analysis 1

  • diamond · 14 ✖
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
27137905 27137905 PRJNA382558_S_NODE_342_length_406_cov_11.173442_g338_i0 PRJNA382558 342 406 11.173442 45.36417452 Planctomycetota bacterium 2026780 Bacteria Bacteria 62.4 8.47e-9   NR MCE9553603.1 2026780 g338 i0 40.7 0.598522167487685 81 46 58.4 1 379 143 61 141 MCE9553603.1 DUF2628 domain-containing protein [Planctomycetota bacterium] diamond 243 62.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28338504 28338504 PRJNA382558_S_NODE_8986_length_178_cov_7.113475_g8982_i0 PRJNA382558 8986 178 7.113475 12.6619855 Phycisphaerae bacterium 2026778 Bacteria Bacteria 41.2 0.0163   NR MBL9119030.1 2026778 g8982 i0 55.9 0.573033707865168 34 15 57.3 0 170 69 48 81 MBL9119030.1 hypothetical protein [Phycisphaerae bacterium] diamond 102 41.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
28369959 28369959 PRJNA382558_S_NODE_2406_length_257_cov_5.322727_g2402_i0 PRJNA382558 2406 257 5.322727 13.67940839 Planctomycetota bacterium 2026780 Bacteria Bacteria 44.7 0.0082   NR MBM4009447.1 2026780 g2402 i0 41.8 0.922178988326848 79 43 88.7 1 14 241 181 259 MBM4009447.1 hypothetical protein [Planctomycetota bacterium] diamond 237 44.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28748894 28748894 PRJNA382558_S_NODE_15787_length_151_cov_2.719298_g15783_i0 PRJNA382558 15787 151 2.719298 4.10613998 Gemmataceae bacterium 2052164 Bacteria Bacteria 42.4 0.0126   NR MCI0640648.1 2052164 g15783 i0 46 0.993377483443709 50 27 99.3 0 150 1 94 143 MCI0640648.1 YfbM family protein [Gemmataceae bacterium] diamond 150 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
29113215 29113215 PRJNA382558_S_NODE_8628_length_180_cov_11.139860_g8624_i0 PRJNA382558 8628 180 11.13986 20.051748 PVC group 1783257 Bacteria Bacteria 53.9 1.79e-6   NR HJT32791.1 2715253 g8624 i0 59 4.03333333333333 39 16 65 0 62 178 251 289 HJT32791.1 S53 family peptidase [Pirellulales bacterium] diamond 726 53.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
29285532 29285532 PRJNA382558_S_NODE_7309_length_189_cov_10.750000_g7305_i0 PRJNA382558 7309 189 10.75 20.3175 Phycisphaerae bacterium 2026778 Bacteria Bacteria 67 1.15e-12   NR GMU20578.1 2026778 g7305 i0 60.8 1.65079365079365 51 20 81 0 189 37 24 74 GMU20578.1 MAG: hypothetical protein AMXMBFR13_06750 [Phycisphaerae bacterium] diamond 312 67 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
29569748 29569748 PRJNA382558_S_NODE_13850_length_156_cov_9.781513_g13846_i0 PRJNA382558 13850 156 9.781513 15.25916028 Pirellula sp. 117 Bacteria Bacteria 69.3 4.69e-12   NR MEI7461366.1 117 g13846 i0 64.6 0.923076923076923 48 17 92.3 0 5 148 140 187 MEI7461366.1 hypothetical protein [Pirellula sp.] diamond 144 69.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp.
30675318 30675318 PRJNA382558_S_NODE_3813_length_227_cov_8.000000_g3809_i0 PRJNA382558 3813 227 8 18.16 Gemmataceae bacterium 2052164 Bacteria Bacteria 95.9 9.81e-23   NR MBX9582031.1 2052164 g3809 i0 60.8 0.977973568281938 74 29 97.8 0 2 223 88 161 MBX9582031.1 PEP-CTERM sorting domain-containing protein [Gemmataceae bacterium] diamond 222 95.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
30801774 30801774 PRJNA382558_S_NODE_4374_length_219_cov_8.741758_g4370_i0 PRJNA382558 4374 219 8.741758 19.14445002 Phycisphaerales bacterium 2052180 Bacteria Bacteria 56.2 3.03e-8   NR MBU3728939.1 2052180 g4370 i0 49.1 0.753424657534247 55 28 75.3 0 212 48 2 56 MBU3728939.1 hypothetical protein [Phycisphaerales bacterium] diamond 165 56.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
31497418 31497418 PRJNA382558_S_NODE_1856_length_275_cov_6.546218_g1852_i0 PRJNA382558 1856 275 6.546218 18.0020995 Pirellula sp. 117 Bacteria Bacteria 47.8 9.69e-4   NR MEI7461365.1 117 g1852 i0 39 0.894545454545455 82 48 89.5 1 267 22 840 919 MEI7461365.1 hypothetical protein [Pirellula sp.] diamond 246 47.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp.
32130142 32130142 PRJNA382558_S_NODE_5418_length_207_cov_4.494118_g5414_i0 PRJNA382558 5418 207 4.494118 9.30282426 Gemmataceae bacterium 2052164 Bacteria Bacteria 82.8 2.34e-18   NR HEV3259881.1 2052164 g5414 i0 56.3 0.927536231884058 64 28 92.8 0 195 4 3 66 HEV3259881.1 hypothetical protein [Gemmataceae bacterium] diamond 192 82.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
32446590 32446590 PRJNA382558_S_NODE_12859_length_160_cov_6.097561_g12855_i0 PRJNA382558 12859 160 6.097561 9.7560976 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 47.8 1.97e-4   NR MDX1970649.1 2026779 g12855 i0 42.9 0.91875 49 28 91.9 0 6 152 220 268 MDX1970649.1 reverse transcriptase family protein [Planctomycetaceae bacterium] diamond 147 47.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
32667242 32667242 PRJNA382558_S_NODE_4460_length_218_cov_7.861878_g4456_i0 PRJNA382558 4460 218 7.861878 17.13889404 Pirellulales bacterium 2715253 Bacteria Bacteria 89.7 1.4e-19   NR HEX4129014.1 2715253 g4456 i0 57.1 0.963302752293578 70 30 96.3 0 9 218 97 166 HEX4129014.1 hypothetical protein [Pirellulales bacterium] diamond 210 89.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
32824819 32824819 PRJNA382558_S_NODE_2340_length_258_cov_9.601810_g2336_i0 PRJNA382558 2340 258 9.60181 24.7726698 Pirellula sp. 117 Bacteria Bacteria 68.2 5e-11   NR MEI7461366.1 117 g2336 i0 43.5 0.988372093023256 85 48 98.8 0 3 257 391 475 MEI7461366.1 hypothetical protein [Pirellula sp.] diamond 255 68.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp.

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);;