RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA399711" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 22 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA399711 · 22 ✖

analysis 1

  • diamond · 22 ✖
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
26695457 26695457 PRJNA399711_P_NODE_20301_length_160_cov_2.796748_g20235_i0 PRJNA399711 20301 160 2.796748 4.4747968 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 55.8 2.85e-7   NR MCW5774847.1 2026777 g20235 i0 57.1 1.5375 42 18 78.8 0 144 19 271 312 MCW5774847.1 Fic family protein [Phycisphaeraceae bacterium] diamond 246 55.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
26839216 26839216 PRJNA399711_P_NODE_11881_length_187_cov_2.240000_g11815_i0 PRJNA399711 11881 187 2.24 4.1888 Urbifossiella 2807415 Bacteria Bacteria 106 5.3999999999999985e-25   NR MFO0847791.1 2052164 g11815 i0 77 5.8716577540107 61 14 97.9 0 185 3 947 1007 MFO0847791.1 glutamate synthase-related protein [Gemmataceae bacterium] diamond 1098 106 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
27486231 27486231 PRJNA399711_P_NODE_6243_length_226_cov_1.878307_g6177_i0 PRJNA399711 6243 226 1.878307 4.24497382 Gemmataceae bacterium 2052164 Bacteria Bacteria 95.5 7.669999999999999e-23   NR HXG08538.1 2052164 g6177 i0 66.2 0.902654867256637 68 22 88.9 1 202 2 45 112 HXG08538.1 hypothetical protein [Gemmataceae bacterium] diamond 204 95.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
28086017 28086017 PRJNA399711_P_NODE_5325_length_236_cov_2.613065_g5259_i0 PRJNA399711 5325 236 2.613065 6.1668334 Candidatus Laterigemmans baculatus 2770505 Bacteria Bacteria 87 6.27e-18   NR WP_164101238.1 2770505 g5259 i0 82 3.38135593220339 50 9 63.6 0 85 234 205 254 WP_164101238.1 tagaturonate epimerase family protein [Candidatus Laterigemmans baculatus] diamond 798 87 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Candidatus Laterigemmans Candidatus Laterigemmans baculatus
30233387 30233387 PRJNA399711_P_NODE_21152_length_157_cov_2.900000_g21086_i0 PRJNA399711 21152 157 2.9 4.553 Aureliella helgolandensis 2527968 Bacteria Bacteria 68.2 8.47e-12   NR WP_145074375.1 2527968 g21086 i0 59.6 1.79617834394904 47 19 89.8 0 13 153 252 298 WP_145074375.1 metallophosphoesterase family protein [Aureliella helgolandensis] diamond 282 68.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Aureliella Aureliella helgolandensis
30928590 30928590 PRJNA399711_P_NODE_22674_length_153_cov_1.120690_g22608_i0 PRJNA399711 22674 153 1.12069 1.7146557 Gemmataceae bacterium 2052164 Bacteria Bacteria 50.1 2.78e-5   NR MBX3399266.1 2052164 g22608 i0 46.9 0.96078431372549 49 25 94.1 1 5 148 9 57 MBX3399266.1 hypothetical protein [Gemmataceae bacterium] diamond 147 50.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
32917914 32917914 PRJNA399711_S_NODE_88489_length_162_cov_1.808000_g88347_i0 PRJNA399711 88489 162 1.808 2.92896 Pirellulaceae bacterium 2699754 Bacteria Bacteria 40 0.0492   NR MCU0981790.1 2699754 g88347 i0 37.5 0.740740740740741 40 25 74.1 0 42 161 25 64 MCU0981790.1 hypothetical protein [Pirellulaceae bacterium] diamond 120 40 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
32952012 32952012 PRJNA399711_S_NODE_42250_length_211_cov_9.471264_g42108_i0 PRJNA399711 42250 211 9.471264 19.98436704 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 42 0.0446   NR MCA9023924.1 2026779 g42108 i0 38.5 0.554502369668246 39 24 55.5 0 146 30 251 289 MCA9023924.1 glycogen synthase GlgA [Planctomycetaceae bacterium] diamond 117 42 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
32958453 32958453 PRJNA399711_S_NODE_44610_length_207_cov_7.205882_g44468_i0 PRJNA399711 44610 207 7.205882 14.91617574 Bacteria 2 Bacteria Bacteria 90.5 3.01e-19   NR MCC8180781.1 2026780 g44468 i0 80.4 30.6376811594203 46 9 66.7 0 3 140 441 486 MCC8180781.1 decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Planctomycetota bacterium] diamond 6342 91.3 0.991237677984666 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32975545 32975545 PRJNA399711_S_NODE_16122_length_296_cov_9.374517_g15980_i0 PRJNA399711 16122 296 9.374517 27.74857032 Pseudomonadati 3379134 Bacteria Bacteria 90.5 4.2e-19   NR MFQ5655497.1 2026780 g15980 i0 47.8 7.24662162162162 90 47 91.2 0 15 284 2 91 MFQ5655497.1 DEAD/DEAH box helicase [Planctomycetota bacterium] diamond 2145 90.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32986248 32986248 PRJNA399711_S_NODE_48763_length_201_cov_2.012195_g48621_i0 PRJNA399711 48763 201 2.012195 4.04451195 Phycisphaerales bacterium 2052180 Bacteria Bacteria 91.3 1.79e-19   NR MBC7772492.1 2052180 g48621 i0 65.2 3.94029850746269 66 23 98.5 0 198 1 1029 1094 MBC7772492.1 PAS domain S-box protein [Phycisphaerales bacterium] diamond 792 91.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
32986340 32986340 PRJNA399711_S_NODE_62611_length_183_cov_7.547945_g62469_i0 PRJNA399711 62611 183 7.547945 13.81273935 Planctomycetota bacterium 2026780 Bacteria Bacteria 56.6 2.08e-7   NR MFK5955477.1 2026780 g62469 i0 71 2.68852459016393 31 9 50.8 0 50 142 545 575 MFK5955477.1 HAMP domain-containing sensor histidine kinase [Planctomycetota bacterium] diamond 492 56.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
33003209 33003209 PRJNA399711_S_NODE_50803_length_198_cov_2.403727_g50661_i0 PRJNA399711 50803 198 2.403727 4.75937946 Planctomycetota bacterium 2026780 Bacteria Bacteria 65.5 1.09e-10   NR MCI0333487.1 2026780 g50661 i0 58.1 0.939393939393939 62 23 93.9 2 13 198 203 261 MCI0333487.1 PEP-CTERM sorting domain-containing protein [Planctomycetota bacterium] diamond 186 65.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
33020108 33020108 PRJNA399711_S_NODE_3228_length_487_cov_3.831111_g3102_i0 PRJNA399711 3228 487 3.831111 18.65751057 Rhodopirellula sp. 2024855 Bacteria Bacteria 164 1.32e-46   NR MAQ88887.1 2024855 g3102 i0 56.4 7.36139630390144 149 60 89.3 2 44 478 1 148 MAQ88887.1 single-stranded DNA-binding protein [Rhodopirellula sp.] diamond 3585 164 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Rhodopirellula Rhodopirellula sp.
33020464 33020464 PRJNA399711_S_NODE_89484_length_161_cov_3.395161_g89342_i0 PRJNA399711 89484 161 3.395161 5.46620921 Symmachiella dynata 2527995 Bacteria Bacteria 90.9 1.32e-19   NR WP_145424057.1 2527995 g89342 i0 80.8 1.93788819875776 52 10 96.9 0 3 158 227 278 WP_145424057.1 AAA family ATPase [Symmachiella dynata] diamond 312 90.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Symmachiella Symmachiella dynata
33071098 33071098 PRJNA399711_S_NODE_18141_length_285_cov_4.153226_g17999_i0 PRJNA399711 18141 285 4.153226 11.8366941 Planctomycetota bacterium 2026780 Bacteria Bacteria 54.7 2.49e-6   NR RMF81201.1 2026780 g17999 i0 40.6 0.726315789473684 69 41 72.6 0 208 2 67 135 RMF81201.1 MAG: PEP-CTERM sorting domain-containing protein [Planctomycetota bacterium] diamond 207 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
33077855 33077855 PRJNA399711_S_NODE_91389_length_160_cov_2.235772_g91247_i0 PRJNA399711 91389 160 2.235772 3.5772352 Planctomycetia 203683 Bacteria Bacteria 102 3.669999999999999e-24   NR MCB9941545.1 2026779 g91247 i0 92.3 1.95 52 4 97.5 0 158 3 158 209 MCB9941545.1 putative zinc-binding metallopeptidase [Planctomycetaceae bacterium] diamond 312 102 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
33088448 33088448 PRJNA399711_S_NODE_43166_length_210_cov_3.132948_g43024_i0 PRJNA399711 43166 210 3.132948 6.5791908 Planctomycetota bacterium 2026780 Bacteria Bacteria 52 4.47e-6   NR REJ65432.1 2026780 g43024 i0 67.7 0.442857142857143 31 10 44.3 0 2 94 75 105 REJ65432.1 MAG: hypothetical protein DWQ31_18235 [Planctomycetota bacterium] diamond 93 52 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
33088764 33088764 PRJNA399711_S_NODE_88390_length_162_cov_2.072000_g88248_i0 PRJNA399711 88390 162 2.072 3.35664 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 43.5 0.00662   NR MFO1044496.1 2026779 g88248 i0 73.1 0.481481481481481 26 7 48.1 0 80 3 7 32 MFO1044496.1 AAA family ATPase [Planctomycetaceae bacterium] diamond 78 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
33105332 33105332 PRJNA399711_S_NODE_15198_length_302_cov_6.184906_g15056_i0 PRJNA399711 15198 302 6.184906 18.67841612 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 67 6.53e-11   NR MCA9111532.1 2026779 g15056 i0 45.2 1.46026490066225 73 33 65.6 1 105 302 81 153 MCA9111532.1 restriction endonuclease subunit S [Planctomycetaceae bacterium] diamond 441 67 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
33139563 33139563 PRJNA399711_S_NODE_34775_length_226_cov_11.010582_g34633_i0 PRJNA399711 34775 226 11.010582 24.88391532 Planctomycetia bacterium 2052181 Bacteria Bacteria 75.1 9.69e-14   NR QOJ14017.1 2052181 g34633 i0 50.7 0.915929203539823 69 27 91.6 1 213 7 210 271 QOJ14017.1 MAG: hypothetical protein HRU75_04920 [Planctomycetia bacterium] diamond 207 75.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
33180208 33180208 PRJNA399711_S_NODE_11160_length_334_cov_2.414141_g11018_i0 PRJNA399711 11160 334 2.414141 8.06323094 Bacteria 2 Bacteria Bacteria 169 4.119999999999999e-47   NR HVK08270.1 2052164 g11018 i0 76.7 4.57185628742515 103 24 92.5 0 331 23 137 239 HVK08270.1 Gfo/Idh/MocA family oxidoreductase [Gemmataceae bacterium] diamond 1527 170 0.994117647058824 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae 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);;