RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA572587" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA572587 · 15 ✖

analysis 1

  • diamond · 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
558664 558664 PRJNA572587_P_NODE_12261_length_333_cov_43.031690_g11933_i0 PRJNA572587 12261 333 43.03169 143.2955277 Planctomycetota bacterium 2026780 Bacteria Bacteria 107 3.13e-25   NR RLT03977.1 2026780 g11933 i0 78.8 0.594594594594595 66 14 59.5 0 20 217 28 93 RLT03977.1 MAG: serine/threonine protein kinase, partial [Planctomycetota bacterium] diamond 198 107 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
10763522 10763522 PRJNA572587_P_NODE_8549_length_413_cov_6.123626_g8223_i0 PRJNA572587 8549 413 6.123626 25.29057538 Fimbriiglobus sp. 1914235 Bacteria Bacteria 202 8.73e-58   NR MCU0702671.1 1914235 g8223 i0 79.5 0.958837772397094 132 27 95.9 0 18 413 305 436 MCU0702671.1 ComEC/Rec2 family competence protein [Fimbriiglobus sp.] diamond 396 202 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Fimbriiglobus Fimbriiglobus sp.
12038067 12038067 PRJNA572587_P_NODE_33410_length_191_cov_12.119718_g33082_i0 PRJNA572587 33410 191 12.119718 23.14866138 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 98.6 1.1e-22   NR MFN0195270.1 2026779 g33082 i0 94.1 0.801047120418848 51 3 80.1 0 37 189 101 151 MFN0195270.1 flotillin-like protein FloA [Planctomycetaceae bacterium] diamond 153 98.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
20960873 20960873 PRJNA572587_P_NODE_1617_length_999_cov_32.985263_g1464_i0 PRJNA572587 1617 999 32.985263 329.52277736999997 Gemmatales bacterium 2838789 Bacteria Bacteria 518 4.61e-179   NR GIW78573.1 2838789 g1464 i0 82.9 1.8978978978979 316 54 94.9 0 24 971 226 541 GIW78573.1 MAG: ATPase [Gemmatales bacterium] diamond 1896 518 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales     Gemmatales bacterium
26984522 26984522 PRJNA572587_P_NODE_2202_length_874_cov_4.721212_g2008_i0 PRJNA572587 2202 874 4.721212 41.26339288 Pirellula staleyi DSM 6 125 Bacteria Bacteria 104 4.52e-22   NR ADB17639.1 530564 g2008 i0 64.6 1.15675057208238 79 28 27.1 0 5 241 162 240 ADB17639.1 Alpha/beta hydrolase fold-3 domain protein [Pirellula staleyi DSM 6068] diamond 1011 104 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula staleyi
27680068 27680068 PRJNA572587_P_NODE_11704_length_342_cov_75.675768_g11376_i0 PRJNA572587 11704 342 75.675768 258.81112656 Planctomycetota bacterium 2026780 Bacteria Bacteria 74.7 1.49e-14   NR MEK7992869.1 2026780 g11376 i0 53.2 0.675438596491228 77 36 67.5 0 319 89 27 103 MEK7992869.1 hypothetical protein [Planctomycetota bacterium] diamond 231 74.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28595582 28595582 PRJNA572587_P_NODE_9407_length_390_cov_8.645161_g9080_i0 PRJNA572587 9407 390 8.645161 33.7161279 Phycisphaerales bacterium 2052180 Bacteria Bacteria 64.3 4.88e-9   NR MDB5324827.1 2052180 g9080 i0 42.2 0.638461538461538 83 44 60.8 1 136 372 90 172 MDB5324827.1 hypothetical protein [Phycisphaerales bacterium] diamond 249 64.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
29006276 29006276 PRJNA572587_P_NODE_31148_length_199_cov_2.946667_g30820_i0 PRJNA572587 31148 199 2.946667 5.86386733 Planctomycetota bacterium 2026780 Bacteria Bacteria 47.8 2.77e-4   NR MFM1872725.1 2026780 g30820 i0 88 1.76381909547739 25 3 37.7 0 116 42 204 228 MFM1872725.1 transporter ATP-binding protein YtrE [Planctomycetota bacterium] diamond 351 47.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29447690 29447690 PRJNA572587_P_NODE_8090_length_426_cov_15.366048_g7765_i0 PRJNA572587 8090 426 15.366048 65.45936448 Paludisphaera sp. 2017432 Bacteria Bacteria 107 1.29e-25   NR WP_337174015.1 2017432 g7765 i0 64.8 0.619718309859155 88 29 61.3 2 54 314 167 253 WP_337174015.1 amidohydrolase family protein [Paludisphaera sp.] diamond 264 107 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Paludisphaera Paludisphaera sp.
29731831 29731831 PRJNA572587_P_NODE_31890_length_196_cov_14.619048_g31562_i0 PRJNA572587 31890 196 14.619048 28.65333408 Pirellulales bacterium 2715253 Bacteria Bacteria 70.9 1.81e-12   NR HUS39610.1 2715253 g31562 i0 73.3 1.36224489795918 45 12 68.9 0 12 146 292 336 HUS39610.1 hypothetical protein [Pirellulales bacterium] diamond 267 70.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
30521814 30521814 PRJNA572587_P_NODE_26273_length_218_cov_14.289941_g25945_i0 PRJNA572587 26273 218 14.289941 31.15207138 Gemmataceae bacterium 2052164 Bacteria Bacteria 111 3.7400000000000006e-27   NR MFL5327886.1 2052164 g25945 i0 75.4 0.894495412844037 65 16 89.4 0 14 208 22 86 MFL5327886.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Gemmataceae bacterium] diamond 195 111 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
31059292 31059292 PRJNA572587_P_NODE_3295_length_722_cov_12.817236_g3027_i0 PRJNA572587 3295 722 12.817236 92.54044392 Planctomycetia bacterium 2052181 Bacteria Bacteria 69.7 1.5e-9   NR MCX7424011.1 2052181 g3027 i0 52.9 0.282548476454294 68 30 27.4 1 702 505 746 813 MCX7424011.1 cadherin domain-containing protein [Planctomycetia bacterium] diamond 204 69.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
31090556 31090556 PRJNA572587_P_NODE_19975_length_253_cov_72.196078_g19647_i0 PRJNA572587 19975 253 72.196078 182.65607734 Planctomycetes bacterium RIFOXYC2_FULL_41_27 1801986 Bacteria Bacteria 81.3 3.42e-16   NR OHC06474.1 1801986 g19647 i0 84 1.25691699604743 50 8 59.3 0 97 246 2 51 OHC06474.1 MAG: hypothetical protein A3J92_04500 [Planctomycetes bacterium RIFOXYC2_FULL_41_27] diamond 318 81.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetes bacterium RIFOXYC2_FULL_41_27
31185074 31185074 PRJNA572587_P_NODE_36595_length_182_cov_2.330827_g36267_i0 PRJNA572587 36595 182 2.330827 4.24210514 Gemmataceae bacterium 2052164 Bacteria Bacteria 62 2.23e-9   NR MFL5244936.1 2052164 g36267 i0 65.1 2.42307692307692 43 15 70.9 0 45 173 27 69 MFL5244936.1 hypothetical protein [Gemmataceae bacterium] diamond 441 62 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
32559517 32559517 PRJNA572587_P_NODE_12939_length_323_cov_26.175182_g12611_i0 PRJNA572587 12939 323 26.175182 84.54583786 root 1 Root_unresolved Root_unresolved 81.3 2.81e-15   NR NHZ86096.1 2052181 g12611 i0 55.1 1.42105263157895 69 31 64.1 0 82 288 285 353 NHZ86096.1 hypothetical protein [Planctomycetia bacterium] diamond 459 81.6 0.996323529411765 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia 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);;