RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA785164" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 27 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA785164 · 27 ✖

analysis 1

  • diamond · 27 ✖
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
3317917 3317917 PRJNA785164_P_NODE_56763_length_246_cov_0.890173_g56298_i0 PRJNA785164 56763 246 0.890173 2.18982558 Planctomycetota bacterium 2026780 Bacteria Bacteria 164 5.459999999999998e-47   NR TXT16838.1 2026780 g56298 i0 92.7 1 82 6 100 0 246 1 164 245 TXT16838.1 MAG: penicillin-binding protein beta-lactamase class C, partial [Planctomycetota bacterium] diamond 246 164 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
24165205 24165205 PRJNA785164_P_NODE_57459_length_245_cov_0.895349_g56994_i0 PRJNA785164 57459 245 0.895349 2.19360505 Phycisphaerales bacterium 2052180 Bacteria Bacteria 148 3.3e-39   NR HEX8878333.1 2052180 g56994 i0 90.1 5.95102040816327 81 8 99.2 0 244 2 167 247 HEX8878333.1 sensor histidine kinase KdpD [Phycisphaerales bacterium] diamond 1458 148 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
26673457 26673457 PRJNA785164_P_NODE_29021_length_340_cov_1.685393_g28556_i0 PRJNA785164 29021 340 1.685393 5.7303362 Gemmataceae bacterium 2052164 Bacteria Bacteria 121 1.8399999999999998e-31   NR MFO0937836.1 2052164 g28556 i0 59.3 0.952941176470588 108 44 95.3 0 339 16 103 210 MFO0937836.1 phage virion morphogenesis protein [Gemmataceae bacterium] diamond 324 121 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
26967947 26967947 PRJNA785164_P_NODE_62162_length_241_cov_0.916667_g61697_i0 PRJNA785164 62162 241 0.916667 2.20916747 Planctomycetia 203683 Bacteria Bacteria 43.5 0.0198   NR HEX4608606.1 2807431 g61697 i0 31.6 2.00414937759336 76 52 94.6 0 11 238 642 717 HEX4608606.1 protein kinase [Urbifossiella sp.] diamond 483 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella sp.
26990153 26990153 PRJNA785164_P_NODE_53262_length_249_cov_0.875000_g52797_i0 PRJNA785164 53262 249 0.875 2.17875 Planctomycetota bacterium 2026780 Bacteria Bacteria 42 0.0308   NR MCP5006653.1 2026780 g52797 i0 40.4 0.626506024096386 52 30 62.7 1 81 236 12 62 MCP5006653.1 hypothetical protein [Planctomycetota bacterium] diamond 156 42 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27559019 27559019 PRJNA785164_P_NODE_40164_length_284_cov_1.981043_g39699_i0 PRJNA785164 40164 284 1.981043 5.62616212 Planctomycetota bacterium 2026780 Bacteria Bacteria 72.8 1.7e-12   NR MEA3224507.1 2026780 g39699 i0 39.6 0.961267605633803 91 55 96.1 0 274 2 1279 1369 MEA3224507.1 hypothetical protein [Planctomycetota bacterium] diamond 273 72.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27780366 27780366 PRJNA785164_P_NODE_51344_length_251_cov_0.865169_g50879_i0 PRJNA785164 51344 251 0.865169 2.17157419 Phycisphaerales bacterium 2052180 Bacteria Bacteria 72.8 1.06e-12   NR MCC6678708.1 2052180 g50879 i0 61.6 0.872509960159363 73 15 87.3 2 1 219 502 561 MCC6678708.1 polysaccharide biosynthesis protein [Phycisphaerales bacterium] diamond 219 72.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
27906249 27906249 PRJNA785164_P_NODE_22925_length_393_cov_1.031250_g22460_i0 PRJNA785164 22925 393 1.03125 4.0528125 Planctomycetota bacterium 2026780 Bacteria Bacteria 93.6 3.21e-22   NR MEO6710809.1 2026780 g22460 i0 73.9 0.526717557251908 69 16 51.1 1 210 10 1 69 MEO6710809.1 hypothetical protein [Planctomycetota bacterium] diamond 207 93.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27938183 27938183 PRJNA785164_P_NODE_51125_length_251_cov_0.865169_g50660_i0 PRJNA785164 51125 251 0.865169 2.17157419 Anatilimnocola aggregata 2528021 Bacteria Bacteria 86.7 1.27e-17   NR WP_145097861.1 2528021 g50660 i0 57.8 0.99203187250996006 83 35 99.2 0 250 2 82 164 WP_145097861.1 L-seryl-tRNA(Sec) selenium transferase [Anatilimnocola aggregata] diamond 249 86.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Anatilimnocola Anatilimnocola aggregata
27969616 27969616 PRJNA785164_P_NODE_42085_length_278_cov_1.126829_g41620_i0 PRJNA785164 42085 278 1.126829 3.13258462 Pirellulaceae bacterium 2699754 Bacteria Bacteria 69.7 1.4e-11   NR MBL7040628.1 2699754 g41620 i0 35.8 1.02517985611511 95 49 89.6 1 28 276 139 233 MBL7040628.1 hypothetical protein [Pirellulaceae bacterium] diamond 285 69.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
27969621 27969621 PRJNA785164_P_NODE_54345_length_248_cov_0.880000_g53880_i0 PRJNA785164 54345 248 0.88 2.1824 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 42.7 0.038   NR MDB5336606.1 2026779 g53880 i0 30.7 0.907258064516129 75 48 90.7 2 18 242 256 326 MDB5336606.1 integrase [Planctomycetaceae bacterium] diamond 225 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
28032959 28032959 PRJNA785164_P_NODE_25765_length_365_cov_1.421233_g25300_i0 PRJNA785164 25765 365 1.421233 5.18750045 Planctomycetota bacterium 2026780 Bacteria Bacteria 59.7 1.45e-7   NR MBM4092856.1 2026780 g25300 i0 42 0.665753424657534 81 47 66.6 0 98 340 7 87 MBM4092856.1 hypothetical protein [Planctomycetota bacterium] diamond 243 59.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28064331 28064331 PRJNA785164_P_NODE_42925_length_275_cov_1.460396_g42460_i0 PRJNA785164 42925 275 1.460396 4.016089 Gemmataceae bacterium 2052164 Bacteria Bacteria 73.6 6.43e-13   NR HZZ76907.1 2052164 g42460 i0 43.8 0.970909090909091 89 47 97.1 2 269 3 281 366 HZZ76907.1 DEAD/DEAH box helicase [Gemmataceae bacterium] diamond 267 73.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
28095949 28095949 PRJNA785164_P_NODE_46705_length_263_cov_1.621053_g46240_i0 PRJNA785164 46705 263 1.621053 4.26336939 Planctomycetota bacterium 2026780 Bacteria Bacteria 101 1.26e-22   NR MBI4582961.1 2026780 g46240 i0 49.4 0.992395437262357 87 40 99.2 2 263 3 1276 1358 MBI4582961.1 hypothetical protein [Planctomycetota bacterium] diamond 261 101 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28317028 28317028 PRJNA785164_P_NODE_28946_length_341_cov_1.145522_g28481_i0 PRJNA785164 28946 341 1.145522 3.90623002 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 46.6 9.36e-4   NR HEY3967128.1 2026779 g28481 i0 39.1 0.563049853372434 64 37 54.5 1 152 337 8 71 HEY3967128.1 hypothetical protein [Planctomycetaceae bacterium] diamond 192 46.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
28348527 28348527 PRJNA785164_P_NODE_48786_length_257_cov_1.543478_g48321_i0 PRJNA785164 48786 257 1.543478 3.96673846 Planctomycetota bacterium 2026780 Bacteria Bacteria 85.9 1e-17   NR MFM2217373.1 2026780 g48321 i0 48.2 1.96108949416342 85 43 98.1 1 253 2 131 215 MFM2217373.1 hypothetical protein [Planctomycetota bacterium] diamond 504 85.9 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28348529 28348529 PRJNA785164_P_NODE_60626_length_242_cov_0.923077_g60161_i0 PRJNA785164 60626 242 0.923077 2.23384634 Planctomycetota bacterium 2026780 Bacteria Bacteria 177 5.5199999999999996e-52   NR TXT22051.1 2026780 g60161 i0 98.8 1.98347107438017 80 1 99.2 0 242 3 86 165 TXT22051.1 MAG: Pyrrolo-quinoline quinone [Planctomycetota bacterium] diamond 480 177 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28894449 28894449 PRJNA785164_P_NODE_29828_length_335_cov_1.629771_g29363_i0 PRJNA785164 29828 335 1.629771 5.45973285 Pseudomonadati 3379134 Bacteria Bacteria 45.8 0.00727   NR MFN9295556.1 37635 g29363 i0 44.7 0.841791044776119 47 26 42.1 0 330 190 214 260 MFN9295556.1 hypothetical protein [Planctomyces sp.] diamond 282 45.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp.
29705778 29705778 PRJNA785164_P_NODE_56730_length_246_cov_0.890173_g56265_i0 PRJNA785164 56730 246 0.890173 2.18982558 Gemmataceae bacterium 2052164 Bacteria Bacteria 70.1 8.13e-12   NR MBX9626576.1 2052164 g56265 i0 100 0.353658536585366 29 0 35.4 0 88 2 1 29 MBX9626576.1 site-specific integrase [Gemmataceae bacterium] diamond 87 70.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
29927459 29927459 PRJNA785164_P_NODE_54651_length_248_cov_0.880000_g54186_i0 PRJNA785164 54651 248 0.88 2.1824 Planctomycetia bacterium 2052181 Bacteria Bacteria 140 1.47e-36   NR GDY06557.1 2052181 g54186 i0 80.5 0.991935483870968 82 16 99.2 0 247 2 153 234 GDY06557.1 hypothetical protein LBMAG52_00430 [Planctomycetia bacterium] diamond 246 140 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
29990530 29990530 PRJNA785164_P_NODE_46171_length_265_cov_1.177083_g45706_i0 PRJNA785164 46171 265 1.177083 3.11926995 Candidatus Kuenenia sp. 2499824 Bacteria Bacteria 42.4 0.042   NR MCR4293654.1 2499824 g45706 i0 65.2 0.260377358490566 23 8 26 0 195 263 1 23 MCR4293654.1 hypothetical protein [Candidatus Kuenenia sp.] diamond 69 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Brocadiaceae Candidatus Kuenenia Candidatus Kuenenia sp.
30085141 30085141 PRJNA785164_P_NODE_26492_length_359_cov_1.076923_g26027_i0 PRJNA785164 26492 359 1.076923 3.86615357 Planctomycetota bacterium 2026780 Bacteria Bacteria 88.6 1.24e-19   NR MBK6942475.1 2026780 g26027 i0 51.3 0.977715877437326 117 46 93.6 5 346 11 21 131 MBK6942475.1 hypothetical protein [Planctomycetota bacterium] diamond 351 88.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30211454 30211454 PRJNA785164_P_NODE_36332_length_300_cov_1.339207_g35867_i0 PRJNA785164 36332 300 1.339207 4.017621 Planctomycetota bacterium 2026780 Bacteria Bacteria 44.3 0.022   NR MCB9870630.1 2026780 g35867 i0 38.2 0.76 76 34 63 2 231 43 1030 1105 MCB9870630.1 hypothetical protein [Planctomycetota bacterium] diamond 228 44.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30433177 30433177 PRJNA785164_P_NODE_57093_length_245_cov_1.790698_g56628_i0 PRJNA785164 57093 245 1.790698 4.3872101 Planctomycetota bacterium 2026780 Bacteria Bacteria 83.6 1.61e-16   NR MCC6406795.1 2026780 g56628 i0 47.5 0.979591836734694 80 42 98 0 241 2 647 726 MCC6406795.1 chemotaxis protein CheA [Planctomycetota bacterium] diamond 240 83.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30938487 30938487 PRJNA785164_P_NODE_45714_length_266_cov_1.585492_g45249_i0 PRJNA785164 45714 266 1.585492 4.21740872 Planctomycetia bacterium 2052181 Bacteria Bacteria 43.9 0.00128   NR GDY10817.1 2052181 g45249 i0 57.1 0.394736842105263 35 15 39.5 0 136 32 4 38 GDY10817.1 hypothetical protein LBMAG52_43050 [Planctomycetia bacterium] diamond 105 43.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
31254310 31254310 PRJNA785164_P_NODE_59255_length_243_cov_1.811765_g58790_i0 PRJNA785164 59255 243 1.811765 4.40258895 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 57 1.42e-8   NR MEO1997644.1 2026779 g58790 i0 61 6.03703703703704 41 16 50.6 0 2 124 36 76 MEO1997644.1 acyl carrier protein [Planctomycetaceae bacterium] diamond 1467 57 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
31285850 31285850 PRJNA785164_P_NODE_31695_length_324_cov_1.227092_g31230_i0 PRJNA785164 31695 324 1.227092 3.97577808 Gemmataceae bacterium 2052164 Bacteria Bacteria 64.7 1.8e-9   NR MFO0863527.1 2052164 g31230 i0 49.3 0.638888888888889 69 33 63.9 1 24 230 439 505 MFO0863527.1 DEAD/DEAH box helicase family protein [Gemmataceae bacterium] diamond 207 64.7 1 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);;