RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJNA283169", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 22 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 22 ✖

bioproject 1

  • PRJNA283169 · 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
371804 371804 PRJNA283169_P_NODE_6441_length_169_cov_1.016667_g6378_i0 PRJNA283169 6441 169 1.016667 1.71816723 uncultured Planctomycetota bacterium 120965 Bacteria Bacteria 158 2.91e-34   NTclustered gi|2874254043|emb|OY970367.1| 120965 g6378 i0 90.678 215.201183431953 118 11 70 0 6 123 3454591 3454708 MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1 blastn 36369 158 1 Bacteria PVC group Pseudomonadati Planctomycetota         uncultured Planctomycetota bacterium
5475228 5475228 PRJNA283169_P_NODE_885_length_412_cov_1.878788_g823_i0 PRJNA283169 885 412 1.878788 7.74060656 Gemmataceae bacterium 2052164 Bacteria Bacteria 588 2.4399999999999994e-163   NTclustered gi|2063814025|emb|LR586051.1| 2052164 g823 i0 98.788 101.507281553398 330 4 100 0 1 330 319633 319962 Gemmata bacterium CJuql4 whole genome assembly and annotation blastn 41821 588 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
10575720 10575720 PRJNA283169_P_NODE_3689_length_216_cov_1.730539_g3626_i0 PRJNA283169 3689 216 1.730539 3.73796424 Caulifigura coniformis 2527983 Bacteria Bacteria 267 6.25e-67   NTclustered gi|1712508784|gb|CP036271.1| 2527983 g3626 i0 88.889 15.8935185185185 216 24 100 0 1 216 2926057 2926272 Caulifigura coniformis strain Pan44 chromosome blastn 3433 267 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Caulifigura Caulifigura coniformis
15674480 15674480 PRJNA283169_P_NODE_3733_length_215_cov_1.548193_g3670_i0 PRJNA283169 3733 215 1.548193 3.32861495 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 296 7.93e-76   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g3670 i0 93.171 111.125581395349 205 9 93 4 1 201 7051628 7051425 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 23892 296 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
16949152 16949152 PRJNA283169_P_NODE_3954_length_211_cov_0.950617_g3891_i0 PRJNA283169 3954 211 0.950617 2.00580187 Caulifigura coniformis 2527983 Bacteria Bacteria 346 7.59e-91   NTclustered gi|1712508784|gb|CP036271.1| 2527983 g3891 i0 96.226 127.293838862559 212 6 100 2 1 211 2926655 2926865 Caulifigura coniformis strain Pan44 chromosome blastn 26859 346 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Caulifigura Caulifigura coniformis
19497694 19497694 PRJNA283169_P_NODE_2456_length_263_cov_1.836449_g2394_i0 PRJNA283169 2456 263 1.836449 4.82986087 Humisphaera borealis 2807512 Bacteria Bacteria 372 1.62e-98   NTclustered gi|1927742986|gb|CP063458.1| 2807512 g2394 i0 92.636 17.6235741444867 258 19 98 0 1 258 5062908 5063165 Humisphaera borealis strain M1803 chromosome, complete genome blastn 4635 372 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae Humisphaera Humisphaera borealis
20773289 20773289 PRJNA283169_P_NODE_6257_length_171_cov_1.557377_g6194_i0 PRJNA283169 6257 171 1.557377 2.66311467 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 217 4.8e-52   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g6194 i0 89.595 134.631578947368 173 14 99 4 2 171 7051977 7051806 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 23022 217 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
23323804 23323804 PRJNA283169_P_NODE_2859_length_245_cov_2.081633_g2796_i0 PRJNA283169 2859 245 2.081633 5.10000085 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 342 1.17e-89   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g2796 i0 91.903 151.391836734694 247 17 100 2 1 245 7051862 7052107 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 37091 342 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
24597889 24597889 PRJNA283169_P_NODE_4680_length_196_cov_1.061224_g4617_i0 PRJNA283169 4680 196 1.061224 2.07999904 Gimesia panareensis 2527978 Bacteria Bacteria 82.4 2.16e-11   NTclustered gi|1712615819|gb|CP036277.1| 2527978 g4617 i0 92.857 2.20918367346939 56 4 29 0 28 83 2381233 2381178 Gimesia panareensis strain Pan110 chromosome, complete genome blastn 433 82.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Gimesia Gimesia panareensis
26838862 26838862 PRJNA283169_S_NODE_1441_length_227_cov_0.123596_g1427_i0 PRJNA283169 1441 227 0.123596 0.28056292 Pirellula 123 Bacteria Bacteria 118 6.23e-29   NR HUP77528.1 117 g1427 i0 73 1.95594713656388 74 20 97.8 0 2 223 283 356 HUP77528.1 isoleucine--tRNA ligase [Pirellula sp.] diamond 444 118 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp.
27042527 27042527 PRJNA283169_P_NODE_462_length_569_cov_1.648077_g405_i0 PRJNA283169 462 569 1.648077 9.37755813 Candidatus Scalindua sp. 2268189 Bacteria Bacteria 87.4 4.45e-17   NR MDR4496880.1 2268189 g405 i0 52.8 0.764499121265378 72 34 38 0 555 340 142 213 MDR4496880.1 FRG domain-containing protein [Candidatus Scalindua sp.] diamond 435 87.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Scalinduaceae Candidatus Scalindua Candidatus Scalindua sp.
27168728 27168728 PRJNA283169_P_NODE_3742_length_215_cov_1.240964_g3679_i0 PRJNA283169 3742 215 1.240964 2.6680726 Humisphaera borealis 2807512 Bacteria Bacteria 103 8.690000000000001e-27   NR WP_206294221.1 2807512 g3679 i0 77.8 0.87906976744186 63 14 87.9 0 16 204 1 63 WP_206294221.1 PilZ domain-containing protein [Humisphaera borealis] diamond 189 103 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae Humisphaera Humisphaera borealis
28558598 28558598 PRJNA283169_P_NODE_907_length_408_cov_0.991643_g845_i0 PRJNA283169 907 408 0.991643 4.04590344 Gimesia chilikensis 2605989 Bacteria Bacteria 86.3 1.01e-16   NR WP_149339017.1 2605989 g845 i0 51.9 1.16176470588235 79 38 58.1 0 171 407 281 359 WP_149339017.1 CynX/NimT family MFS transporter [Gimesia chilikensis] diamond 474 86.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Gimesia Gimesia chilikensis
28874107 28874107 PRJNA283169_P_NODE_4068_length_208_cov_0.899371_g4005_i0 PRJNA283169 4068 208 0.899371 1.87069168 Planctomycetales bacterium 2053591 Bacteria Bacteria 54.7 1.43e-6   NR MCA9184911.1 2053591 g4005 i0 44.4 2.01923076923077 72 31 92.3 4 3 194 5187 5257 MCA9184911.1 M10 family metallopeptidase C-terminal domain-containing protein [Planctomycetales bacterium] diamond 420 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium
30136930 30136930 PRJNA283169_P_NODE_7812_length_163_cov_0.912281_g7749_i0 PRJNA283169 7812 163 0.912281 1.48701803 Candidatus Scalindua sp. 2268189 Bacteria Bacteria 82.8 5.95e-17   NR MCR4343334.1 2268189 g7749 i0 72.2 0.993865030674847 54 15 99.4 0 162 1 41 94 MCR4343334.1 phage major capsid protein [Candidatus Scalindua sp.] diamond 162 82.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Scalinduaceae Candidatus Scalindua Candidatus Scalindua sp.
30579395 30579395 PRJNA283169_P_NODE_5373_length_184_cov_1.896296_g5310_i0 PRJNA283169 5373 184 1.896296 3.48918464 Aureliella helgolandensis 2527968 Bacteria Bacteria 46.2 9.99e-4   NR WP_145078911.1 2527968 g5310 i0 39.7 1.89130434782609 58 35 94.6 0 182 9 1322 1379 WP_145078911.1 hypothetical protein [Aureliella helgolandensis] diamond 348 46.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Aureliella Aureliella helgolandensis
30850030 30850030 PRJNA283169_P_NODE_7894_length_163_cov_0.894737_g7831_i0 PRJNA283169 7894 163 0.894737 1.45842131 Bacteria 2 Bacteria Bacteria 78.6 1.58e-15   NR QKK07071.1 2026780 g7831 i0 64.8 1.98773006134969 54 19 99.4 0 1 162 197 250 QKK07071.1 MAG: S8 family serine peptidase [Planctomycetota bacterium] diamond 324 78.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30990540 30990540 PRJNA283169_S_NODE_1874_length_205_cov_0.064103_g1860_i0 PRJNA283169 1874 205 0.064103 0.13141115 Gemmataceae bacterium 2052164 Bacteria Bacteria 50.8 1.64e-5   NR MBX9682125.1 2052164 g1860 i0 44 0.731707317073171 50 28 73.2 0 152 3 1 50 MBX9682125.1 hypothetical protein [Gemmataceae bacterium] diamond 150 50.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
31432923 31432923 PRJNA283169_S_NODE_2036_length_198_cov_0.120805_g2022_i0 PRJNA283169 2036 198 0.120805 0.2391939 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.5 0.0109   NR HEY3320097.1 2026780 g2022 i0 44.7 1.10606060606061 38 21 57.6 0 50 163 323 360 HEY3320097.1 glycosyl hydrolase family 28-related protein [Planctomycetota bacterium] diamond 219 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31780745 31780745 PRJNA283169_P_NODE_3237_length_231_cov_0.857143_g3174_i0 PRJNA283169 3237 231 0.857143 1.98000033 Planctomycetota bacterium 2026780 Bacteria Bacteria 42.4 0.0443   NR MBN9118449.1 2026780 g3174 i0 33.3 0.935064935064935 72 44 88.3 1 210 7 116 187 MBN9118449.1 protein kinase [Planctomycetota bacterium] diamond 216 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31780754 31780754 PRJNA283169_S_NODE_2037_length_198_cov_0.107383_g2023_i0 PRJNA283169 2037 198 0.107383 0.21261834 Planctomycetota bacterium 2026780 Bacteria Bacteria 120 7.659999999999999e-31   NR MCY2982620.1 2026780 g2023 i0 83.1 2.95454545454545 65 11 98.5 0 2 196 251 315 MCY2982620.1 hypothetical protein [Planctomycetota bacterium] diamond 585 120 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32477139 32477139 PRJNA283169_S_NODE_2219_length_191_cov_0.176056_g2205_i0 PRJNA283169 2219 191 0.176056 0.33626696 Phycisphaerae bacterium 2026778 Bacteria Bacteria 49.3 7.87e-5   NR MBL9150778.1 2026778 g2205 i0 55.8 1.30366492146597 43 18 66 1 131 6 5 47 MBL9150778.1 ATP-binding protein [Phycisphaerae bacterium] diamond 249 49.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae 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);;