RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA674050" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA674050 · 15 ✖
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
9571937 9571937 PRJNA674050_P_NODE_16308_length_271_cov_1.212121_g16105_i0 PRJNA674050 16308 271 1.212121 3.28484791 Pirellulales bacterium 2715253 Bacteria Bacteria 182 4.21e-54   NR HEY2760985.1 2715253 g16105 i0 84.3 5.90036900369004 89 14 98.5 0 269 3 192 280 HEY2760985.1 methionine--tRNA ligase [Pirellulales bacterium] diamond 1599 182 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
9573014 9573014 PRJNA674050_P_NODE_7788_length_317_cov_1.381148_g7585_i0 PRJNA674050 7788 317 1.381148 4.37823916 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 488 1.91e-133   NTclustered gi|2076441902|gb|CP075368.1| 2026777 g7585 i0 94.888 559.845425867508 313 14 98 2 6 317 2581813 2582124 MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome blastn 177471 488 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
16469212 16469212 PRJNA674050_P_NODE_32853_length_246_cov_0.884393_g32650_i0 PRJNA674050 32853 246 0.884393 2.17560678 Gemmata 113 Bacteria Bacteria 375 1.16e-99   NTclustered gi|1804905141|emb|LR593886.1| 1210884 g32650 i0 94.309 142.00406504065 246 12 100 2 1 246 3634898 3635141 Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1 blastn 34933 375 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata massiliana
18495579 18495579 PRJNA674050_P_NODE_10255_length_298_cov_2.502222_g10052_i0 PRJNA674050 10255 298 2.502222 7.45662156 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 339 1.9e-88   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g10052 i0 87.086 82.1610738255034 302 35 100 4 1 298 7051729 7051428 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 24484 339 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
24869741 24869741 PRJNA674050_P_NODE_20000_length_258_cov_2.302703_g19797_i0 PRJNA674050 20000 258 2.302703 5.94097374 uncultured Planctomycetota bacterium 120965 Bacteria Bacteria 278 3.5600000000000004e-70   NTclustered gi|2874254043|emb|OY970367.1| 120965 g19797 i0 86.434 242.085271317829 258 30 99 4 2 258 3454039 3454292 MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1 blastn 62458 278 1 Bacteria PVC group Pseudomonadati Planctomycetota         uncultured Planctomycetota bacterium
24870066 24870066 PRJNA674050_P_NODE_28820_length_248_cov_0.891429_g28617_i0 PRJNA674050 28820 248 0.891429 2.21074392 Planctomycetota bacterium 2026780 Bacteria Bacteria 62.8 3.39e-9   NR MFN9852343.1 2026780 g28617 i0 46.8 2.89112903225806 79 36 94.4 3 12 245 277 350 MFN9852343.1 gamma-glutamyltransferase [Planctomycetota bacterium] diamond 717 62.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
24870446 24870446 PRJNA674050_P_NODE_3860_length_376_cov_1.029703_g3657_i0 PRJNA674050 3860 376 1.029703 3.87168328 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 468 2.9999999999999997e-127   NTclustered gi|2076441902|gb|CP075368.1| 2026777 g3657 i0 89.333 280.210106382979 375 36 99 3 1 374 2583782 2584153 MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome blastn 105359 468 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
26733218 26733218 PRJNA674050_P_NODE_7401_length_321_cov_1.032258_g7198_i0 PRJNA674050 7401 321 1.032258 3.31354818 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 59.7 4.73e-9   NR MBX3381358.1 2026777 g7198 i0 83.2 0.88785046728972 95 16 88.8 0 307 23 1 95 MBX3381358.1 hypothetical protein [Phycisphaeraceae bacterium] diamond 285 59.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
27524129 27524129 PRJNA674050_P_NODE_343_length_1249_cov_2.418367_g226_i0 PRJNA674050 343 1249 2.418367 30.20540383 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 419 9.56e-139   NR MBB76640.1 2026779 g226 i0 56.7 1.76541232986389 367 158 88.2 1 1181 81 216 581 MBB76640.1 hypothetical protein [Planctomycetaceae bacterium] diamond 2205 419 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
30472955 30472955 PRJNA674050_P_NODE_35293_length_244_cov_0.912281_g35090_i0 PRJNA674050 35293 244 0.912281 2.22596564 Bacteria 2 Bacteria Bacteria 69.7 1.1e-11   NR NQT17611.1 2026780 g35090 i0 55.2 1.61065573770492 67 30 82.4 0 44 244 23 89 NQT17611.1 beta-lactamase family protein [Planctomycetota bacterium] diamond 393 69.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31345811 31345811 PRJNA674050_P_NODE_34676_length_245_cov_0.883721_g34473_i0 PRJNA674050 34676 245 0.883721 2.16511645 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 150 2.2399999999999992e-43   NR MEZ5944940.1 2026779 g34473 i0 90.7 0.918367346938776 75 7 91.8 0 20 244 19 93 MEZ5944940.1 hypothetical protein [Planctomycetaceae bacterium] diamond 225 150 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
31452699 31452699 PRJNA674050_P_NODE_31876_length_246_cov_0.901734_g31673_i0 PRJNA674050 31876 246 0.901734 2.21826564 Planctomycetia 203683 Bacteria Bacteria 108 1.57e-26   NR MBL9124571.1 2026779 g31673 i0 62.8 3.81707317073171 78 29 95.1 0 235 2 21 98 MBL9124571.1 acyl-ACP--UDP-N-acetylglucosamine O-acyltransferase [Planctomycetaceae bacterium] diamond 939 108 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
31820051 31820051 PRJNA674050_P_NODE_25857_length_250_cov_0.881356_g25654_i0 PRJNA674050 25857 250 0.881356 2.20339 Planctomycetales bacterium 2053591 Bacteria Bacteria 82 5.63e-16   NR MFO1021622.1 2053591 g25654 i0 61.7 0.72 60 23 72 0 71 250 1 60 MFO1021622.1 anion transporter [Planctomycetales bacterium] diamond 180 82 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium
32199922 32199922 PRJNA674050_P_NODE_34218_length_245_cov_0.901163_g34015_i0 PRJNA674050 34218 245 0.901163 2.20784935 Isosphaerales bacterium 3107438 Bacteria Bacteria 111 2.22e-26   NR MFI5458141.1 3107438 g34015 i0 66.7 2.95102040816327 81 27 99.2 0 1 243 468 548 MFI5458141.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Isosphaerales bacterium] diamond 723 111 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales     Isosphaerales bacterium
32389688 32389688 PRJNA674050_P_NODE_23419_length_252_cov_0.865922_g23216_i0 PRJNA674050 23419 252 0.865922 2.18212344 Pirellulaceae bacterium 2699754 Bacteria Bacteria 73.2 7.73e-13   NR MDX1926865.1 2699754 g23216 i0 48.1 0.916666666666667 77 40 91.7 0 251 21 130 206 MDX1926865.1 carboxypeptidase-like regulatory domain-containing protein [Pirellulaceae bacterium] diamond 231 73.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae 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);;