RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "blastn", bioproject = "PRJNA781427" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • PVC group · 22 ✖

bioproject 1

  • PRJNA781427 · 22 ✖

analysis 1

  • blastn · 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
3312833 3312833 PRJNA781427_P_NODE_78083_length_249_cov_1.750000_g77199_i0 PRJNA781427 78083 249 1.75 4.3575 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 333 7.189999999999999e-87   NTclustered gi|2874254106|emb|OY970189.1| 100233 g77199 i0 90.8 40.2329317269076 250 22 100 1 1 249 4318083 4317834 MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1 blastn 10018 333 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
4590263 4590263 PRJNA781427_P_NODE_94264_length_242_cov_0.911243_g93380_i0 PRJNA781427 94264 242 0.911243 2.20520806 Gimesia maris 122 Bacteria Bacteria 340 4.15e-89   NTclustered gi|1712536321|gb|CP036341.1| 122 g93380 i0 92.116 2.95454545454545 241 19 99 0 1 241 5530969 5531209 Gimesia maris strain Mal35 chromosome blastn 715 340 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Gimesia Gimesia maris
7140409 7140409 PRJNA781427_P_NODE_89206_length_244_cov_0.900585_g88322_i0 PRJNA781427 89206 244 0.900585 2.1974274 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 207 4.44e-49   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g88322 i0 83.043 0.942622950819672 230 37 94 2 3 231 133176 133404 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 230 207 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
8414464 8414464 PRJNA781427_P_NODE_69187_length_263_cov_1.584211_g68303_i0 PRJNA781427 69187 263 1.584211 4.16647493 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 154 6.4e-33   NTclustered gi|2921913114|gb|CP182803.1| 2026777 g68303 i0 77.734 0.973384030418251 256 53 97 2 4 259 427566 427817 MAG: Phycisphaeraceae bacterium isolate amkv24 chromosome, complete genome blastn 256 154 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
8414900 8414900 PRJNA781427_P_NODE_87647_length_245_cov_0.895349_g86763_i0 PRJNA781427 87647 245 0.895349 2.19360505 Gimesia aquarii 2527964 Bacteria Bacteria 176 1.26e-39   NTclustered gi|1712569666|gb|CP037422.1| 2527964 g86763 i0 79.839 2.02448979591837 248 44 100 5 1 245 1966292 1966536 Gimesia aquarii strain V202 chromosome blastn 496 176 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Gimesia Gimesia aquarii
10965860 10965860 PRJNA781427_P_NODE_84029_length_247_cov_0.885057_g83145_i0 PRJNA781427 84029 247 0.885057 2.18609079 Gimesia aquarii 2527964 Bacteria Bacteria 209 1.25e-49   NTclustered gi|1712569666|gb|CP037422.1| 2527964 g83145 i0 82.041 1.98380566801619 245 44 99 0 3 247 1038641 1038885 Gimesia aquarii strain V202 chromosome blastn 490 209 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Gimesia Gimesia aquarii
10966045 10966045 PRJNA781427_P_NODE_91449_length_243_cov_0.905882_g90565_i0 PRJNA781427 91449 243 0.905882 2.20129326 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 211 3.41e-50   NTclustered gi|2921913114|gb|CP182803.1| 2026777 g90565 i0 82.305 18.7860082304527 243 43 100 0 1 243 549096 548854 MAG: Phycisphaeraceae bacterium isolate amkv24 chromosome, complete genome blastn 4565 211 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
10966173 10966173 PRJNA781427_P_NODE_96809_length_241_cov_0.916667_g95925_i0 PRJNA781427 96809 241 0.916667 2.20916747 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 248 2.58e-61   NTclustered gi|2921913114|gb|CP182803.1| 2026777 g95925 i0 85.356 0.991701244813278 239 35 99 0 3 241 1989998 1989760 MAG: Phycisphaeraceae bacterium isolate amkv24 chromosome, complete genome blastn 239 248 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
12241308 12241308 PRJNA781427_P_NODE_81370_length_248_cov_0.880000_g80486_i0 PRJNA781427 81370 248 0.88 2.1824 Gimesia aquarii 2527964 Bacteria Bacteria 254 5.73e-63   NTclustered gi|1712555625|gb|CP037920.1| 2527964 g80486 i0 85.306 0.987903225806452 245 36 99 0 4 248 4684695 4684451 Gimesia aquarii strain V144 chromosome blastn 245 254 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Gimesia Gimesia aquarii
12241516 12241516 PRJNA781427_P_NODE_90030_length_244_cov_0.900585_g89146_i0 PRJNA781427 90030 244 0.900585 2.1974274 Phycisphaera sp. 2030824 Bacteria Bacteria 171 5.82e-38   NTclustered gi|2323351239|gb|CP098402.1| 2030824 g89146 i0 84.091 0.721311475409836 176 28 72 0 2 177 2290922 2290747 MAG: Phycisphaera sp. isolate MAG12 chromosome blastn 176 171 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae Phycisphaera Phycisphaera sp.
12241559 12241559 PRJNA781427_P_NODE_92010_length_243_cov_0.905882_g91126_i0 PRJNA781427 92010 243 0.905882 2.20129326 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 187 5.7499999999999985e-43   NTclustered gi|2921913114|gb|CP182803.1| 2026777 g91126 i0 82.547 0.872427983539095 212 37 87 0 31 242 2694219 2694008 MAG: Phycisphaeraceae bacterium isolate amkv24 chromosome, complete genome blastn 212 187 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
13515623 13515623 PRJNA781427_P_NODE_87251_length_245_cov_0.895349_g86367_i0 PRJNA781427 87251 245 0.895349 2.19360505 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 150 7.62e-32   NTclustered gi|2921913114|gb|CP182803.1| 2026777 g86367 i0 91.15 5.58775510204082 113 7 46 3 134 245 267425 267315 MAG: Phycisphaeraceae bacterium isolate amkv24 chromosome, complete genome blastn 1369 150 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
13515733 13515733 PRJNA781427_P_NODE_91951_length_243_cov_0.905882_g91067_i0 PRJNA781427 91951 243 0.905882 2.20129326 Gimesia chilikensis 2605989 Bacteria Bacteria 209 1.23e-49   NTclustered gi|1712472787|gb|CP036266.1| 2605989 g91067 i0 82.305 3.0082304526749 243 41 99 2 1 242 4059015 4059256 Gimesia chilikensis strain HG66A1 chromosome blastn 731 209 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Gimesia Gimesia chilikensis
14790358 14790358 PRJNA781427_P_NODE_86212_length_246_cov_0.890173_g85328_i0 PRJNA781427 86212 246 0.890173 2.18982558 Gimesia algae 2527971 Bacteria Bacteria 265 2.62e-66   NTclustered gi|1712549334|gb|CP036343.1| 2527971 g85328 i0 86.42 0.98780487804878 243 32 99 1 4 246 2712586 2712345 Gimesia algae strain Pan161 chromosome blastn 243 265 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Gimesia Gimesia algae
16064238 16064238 PRJNA781427_P_NODE_84593_length_246_cov_1.445087_g83709_i0 PRJNA781427 84593 246 1.445087 3.55491402 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 320 5.52e-83   NTclustered gi|2874254106|emb|OY970189.1| 100233 g83709 i0 90.119 208.178861788618 253 16 99 5 1 245 5936621 5936370 MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1 blastn 51212 320 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
16064457 16064457 PRJNA781427_P_NODE_94193_length_242_cov_0.911243_g93309_i0 PRJNA781427 94193 242 0.911243 2.20520806 Phycisphaerales bacterium 2052180 Bacteria Bacteria 167 7.46e-37   NTclustered gi|2108078657|gb|CP070747.1| 2052180 g93309 i0 81.159 2.46694214876033 207 39 86 0 1 207 5216287 5216493 MAG: Phycisphaerales bacterium isolate bin358 chromosome blastn 597 167 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
18613118 18613118 PRJNA781427_P_NODE_74455_length_251_cov_0.865169_g73571_i0 PRJNA781427 74455 251 0.865169 2.17157419 Singulisphaera sp. Ch08 3120278 Bacteria Bacteria 215 2.74e-51   NTclustered gi|2732846650|gb|CP155447.1| 3120278 g73571 i0 82.143 1.00398406374502 252 43 100 2 1 251 9377783 9378033 Singulisphaera sp. Ch08 chromosome, complete genome blastn 252 215 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Singulisphaera Singulisphaera sp. Ch08
19887800 19887800 PRJNA781427_P_NODE_52996_length_308_cov_2.327660_g52113_i0 PRJNA781427 52996 308 2.32766 7.1691928 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 265 3.39e-66   NTclustered gi|2921913114|gb|CP182803.1| 2026777 g52113 i0 82.201 15.8181818181818 309 53 100 2 1 308 2966202 2965895 MAG: Phycisphaeraceae bacterium isolate amkv24 chromosome, complete genome blastn 4872 265 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
22438458 22438458 PRJNA781427_P_NODE_60738_length_285_cov_1.330189_g59854_i0 PRJNA781427 60738 285 1.330189 3.79103865 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 329 1.09e-85   NTclustered gi|2921913114|gb|CP182803.1| 2026777 g59854 i0 87.857 76.7754385964912 280 34 98 0 1 280 1795981 1796260 MAG: Phycisphaeraceae bacterium isolate amkv24 chromosome, complete genome blastn 21881 329 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
22438833 22438833 PRJNA781427_P_NODE_74398_length_251_cov_0.865169_g73514_i0 PRJNA781427 74398 251 0.865169 2.17157419 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 193 1.28e-44   NTclustered gi|1927958621|gb|CP054186.1| 2026777 g73514 i0 81.172 1.13147410358566 239 45 95 0 13 251 2686445 2686207 MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome blastn 284 193 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
22439386 22439386 PRJNA781427_P_NODE_96798_length_241_cov_0.916667_g95914_i0 PRJNA781427 96798 241 0.916667 2.20916747 Phycisphaera sp. 2030824 Bacteria Bacteria 124 4.53e-24   NTclustered gi|2323351239|gb|CP098402.1| 2030824 g95914 i0 87.156 0.452282157676349 109 14 45 0 9 117 1121380 1121272 MAG: Phycisphaera sp. isolate MAG12 chromosome blastn 109 124 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae Phycisphaera Phycisphaera sp.
23714749 23714749 PRJNA781427_P_NODE_93759_length_242_cov_0.911243_g92875_i0 PRJNA781427 93759 242 0.911243 2.20520806 Phycisphaera sp. 2030824 Bacteria Bacteria 414 2.41e-111   NTclustered gi|2323351239|gb|CP098402.1| 2030824 g92875 i0 97.521 1 242 6 100 0 1 242 809682 809441 MAG: Phycisphaera sp. isolate MAG12 chromosome blastn 242 414 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae Phycisphaera Phycisphaera sp.

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);;