contig_metadata
24 rows where bioproject = "PRJNA1098727" and tax_phylum = "Planctomycetota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4037795 | 4037795 | PRJNA1098727_P_NODE_11344_length_179_cov_2.292308_g11103_i0 | PRJNA1098727 | 11344 | 179 | 2.292308 | 4.10323132 | Isosphaeraceae bacterium EP7 | 3139350 | Bacteria | Bacteria | 244 | 2.33e-60 | NTclustered | gi|2719878338|gb|CP151667.1| | 3139350 | g11103 | i0 | 91.573 | 33.8156424581006 | 178 | 13 | 99 | 2 | 2 | 178 | 1599406 | 1599582 | Isosphaeraceae bacterium EP7 chromosome, complete genome | blastn | 6053 | 244 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Isosphaeraceae bacterium EP7 | ||
| 4037839 | 4037839 | PRJNA1098727_P_NODE_2584_length_425_cov_1.925532_g2344_i0 | PRJNA1098727 | 2584 | 425 | 1.925532 | 8.183511 | uncultured Gemmataceae bacterium | 1914239 | Bacteria | Bacteria | 632 | 1.1499999999999995e-176 | NTclustered | gi|2874253853|emb|OY969909.1| | 1914239 | g2344 | i0 | 93.632 | 157.352941176471 | 424 | 25 | 99 | 2 | 3 | 425 | 2003049 | 2002627 | MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 | blastn | 66875 | 632 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | uncultured Gemmataceae bacterium | ||
| 4847878 | 4847878 | PRJNA1098727_P_NODE_10104_length_191_cov_1.225352_g9863_i0 | PRJNA1098727 | 10104 | 191 | 1.225352 | 2.34042232 | Candidatus Uabimicrobium | 2897349 | Bacteria | Bacteria | 189 | 1.1999999999999999e-43 | NTclustered | gi|1732437785|dbj|AP019860.1| | 2596890 | g9863 | i0 | 87.654 | 8.6020942408377 | 162 | 20 | 85 | 0 | 4 | 165 | 4988408 | 4988247 | Planctomycetes bacterium SRT547 DNA, complete genome | blastn | 1643 | 189 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Candidatus Uabimicrobiia | Candidatus Uabimicrobiales | Candidatus Uabimicrobiaceae | Candidatus Uabimicrobium | Candidatus Uabimicrobium amorphum | |
| 6589215 | 6589215 | PRJNA1098727_P_NODE_13986_length_166_cov_0.888889_g13745_i0 | PRJNA1098727 | 13986 | 166 | 0.888889 | 1.47555574 | Planctomycetaceae bacterium | 2026779 | Bacteria | Bacteria | 94 | 1.03e-21 | NR | HID22001.1 | 2026779 | g13745 | i0 | 78.2 | 0.993975903614458 | 55 | 12 | 99.4 | 0 | 165 | 1 | 55 | 109 | HID22001.1 3-oxoacyl-[acyl-carrier-protein] reductase [Planctomycetaceae bacterium] | diamond | 165 | 94 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 7863827 | 7863827 | PRJNA1098727_P_NODE_6687_length_241_cov_2.151042_g6446_i0 | PRJNA1098727 | 6687 | 241 | 2.151042 | 5.18401122 | Urbifossiella limnaea | 2528023 | Bacteria | Bacteria | 285 | 1.96e-72 | NTclustered | gi|1712585314|gb|CP036273.1| | 2528023 | g6446 | i0 | 88.285 | 117.091286307054 | 239 | 26 | 99 | 2 | 2 | 240 | 4212319 | 4212555 | Urbifossiella limnaea strain ETA_A1 chromosome, complete genome | blastn | 28219 | 285 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Urbifossiella | Urbifossiella limnaea | |
| 11689818 | 11689818 | PRJNA1098727_P_NODE_13170_length_168_cov_0.873950_g12929_i0 | PRJNA1098727 | 13170 | 168 | 0.87395 | 1.468236 | Planctomycetaceae bacterium | 2026779 | Bacteria | Bacteria | 141 | 2.93e-29 | NTclustered | gi|2021938515|gb|CP051247.1| | 2026779 | g12929 | i0 | 86.923 | 4.91071428571429 | 130 | 11 | 76 | 6 | 2 | 128 | 3417618 | 3417744 | Planctomycetaceae bacterium isolate ih15 chromosome | blastn | 825 | 141 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 15513755 | 15513755 | PRJNA1098727_P_NODE_7333_length_229_cov_1.022222_g7092_i0 | PRJNA1098727 | 7333 | 229 | 1.022222 | 2.34088838 | uncultured Planctomycetaceae bacterium | 100233 | Bacteria | Bacteria | 303 | 5.11e-78 | NTclustered | gi|2874253948|emb|OY970273.1| | 100233 | g7092 | i0 | 90.789 | 55.8122270742358 | 228 | 19 | 99 | 2 | 2 | 228 | 2622149 | 2621923 | MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1 | blastn | 12781 | 303 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | uncultured Planctomycetaceae bacterium | ||
| 17597557 | 17597557 | PRJNA1098727_P_NODE_5094_length_285_cov_2.525424_g4853_i0 | PRJNA1098727 | 5094 | 285 | 2.525424 | 7.1974584 | Gemmataceae | 1914233 | Bacteria | Bacteria | 440 | 4.8099999999999984e-119 | NTclustered | gi|12583965|gb|AF245369.1|AF245369 | 114 | g4853 | i0 | 94.7 | 167.863157894737 | 283 | 15 | 99 | 0 | 2 | 284 | 2382 | 2100 | Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence | blastn | 47841 | 440 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmata | Gemmata obscuriglobus | |
| 18062808 | 18062808 | PRJNA1098727_P_NODE_9175_length_201_cov_3.361842_g8934_i0 | PRJNA1098727 | 9175 | 201 | 3.361842 | 6.75730242 | Isosphaeraceae bacterium EP7 | 3139350 | Bacteria | Bacteria | 331 | 2.01e-86 | NTclustered | gi|2719878338|gb|CP151667.1| | 3139350 | g8934 | i0 | 96.517 | 458.696517412935 | 201 | 5 | 99 | 1 | 2 | 200 | 1600313 | 1600513 | Isosphaeraceae bacterium EP7 chromosome, complete genome | blastn | 92198 | 331 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Isosphaeraceae bacterium EP7 | ||
| 19336876 | 19336876 | PRJNA1098727_P_NODE_13176_length_168_cov_0.873950_g12935_i0 | PRJNA1098727 | 13176 | 168 | 0.87395 | 1.468236 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 119 | 1.39e-29 | NR | MEZ6015363.1 | 2026780 | g12935 | i0 | 100 | 3.92857142857143 | 55 | 0 | 98.2 | 0 | 167 | 3 | 123 | 177 | MEZ6015363.1 alkaline phosphatase family protein [Planctomycetota bacterium] | diamond | 660 | 119 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 20612280 | 20612280 | PRJNA1098727_P_NODE_11197_length_181_cov_0.810606_g10956_i0 | PRJNA1098727 | 11197 | 181 | 0.810606 | 1.46719686 | Planctomycetales bacterium 10988 | 2603660 | Bacteria | Bacteria | 228 | 2.379999999999999e-55 | NTclustered | gi|1775855904|gb|CP043547.1| | 2603660 | g10956 | i0 | 91.566 | 235.790055248619 | 166 | 12 | 91 | 2 | 7 | 171 | 2223378 | 2223214 | Planctomycetales bacterium 10988 chromosome, complete genome | blastn | 42678 | 228 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetales bacterium 10988 | |||
| 21887937 | 21887937 | PRJNA1098727_P_NODE_5098_length_285_cov_2.042373_g4857_i0 | PRJNA1098727 | 5098 | 285 | 2.042373 | 5.82076305 | uncultured Gemmataceae bacterium | 1914239 | Bacteria | Bacteria | 350 | 8.34e-92 | NTclustered | gi|2874253853|emb|OY969909.1| | 1914239 | g4857 | i0 | 89.085 | 52.8315789473684 | 284 | 28 | 99 | 3 | 2 | 284 | 2004109 | 2004390 | MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 | blastn | 15057 | 350 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | uncultured Gemmataceae bacterium | ||
| 26750737 | 26750737 | PRJNA1098727_P_NODE_13521_length_167_cov_0.881356_g13280_i0 | PRJNA1098727 | 13521 | 167 | 0.881356 | 1.47186452 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 55.8 | 2.93e-7 | NR | MBL8863036.1 | 2026780 | g13280 | i0 | 51 | 1.54491017964072 | 49 | 23 | 86.2 | 1 | 19 | 162 | 3 | 51 | MBL8863036.1 DUF1376 domain-containing protein [Planctomycetota bacterium] | diamond | 258 | 55.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 27162243 | 27162243 | PRJNA1098727_P_NODE_11942_length_174_cov_1.784000_g11701_i0 | PRJNA1098727 | 11942 | 174 | 1.784 | 3.10416 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 48.5 | 1.27e-4 | NR | MBM4009064.1 | 2026780 | g11701 | i0 | 41.5 | 1.41379310344828 | 41 | 21 | 65.5 | 1 | 124 | 11 | 135 | 175 | MBM4009064.1 DMT family transporter [Planctomycetota bacterium] | diamond | 246 | 48.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 27352362 | 27352362 | PRJNA1098727_P_NODE_14463_length_165_cov_0.896552_g14222_i0 | PRJNA1098727 | 14463 | 165 | 0.896552 | 1.4793108 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 75.5 | 3.62e-14 | NR | MFN3240355.1 | 2026780 | g14222 | i0 | 68.5 | 0.981818181818182 | 54 | 17 | 98.2 | 0 | 3 | 164 | 435 | 488 | MFN3240355.1 tetratricopeptide repeat protein [Planctomycetota bacterium] | diamond | 162 | 75.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 27857266 | 27857266 | PRJNA1098727_P_NODE_14025_length_166_cov_0.888889_g13784_i0 | PRJNA1098727 | 14025 | 166 | 0.888889 | 1.47555574 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 66.6 | 4.88e-11 | NR | MEZ6014408.1 | 2026780 | g13784 | i0 | 49 | 3.79518072289157 | 51 | 26 | 92.2 | 0 | 2 | 154 | 94 | 144 | MEZ6014408.1 hypothetical protein [Planctomycetota bacterium] | diamond | 630 | 66.6 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 28962676 | 28962676 | PRJNA1098727_P_NODE_12888_length_169_cov_0.866667_g12647_i0 | PRJNA1098727 | 12888 | 169 | 0.866667 | 1.46466723 | Planctomycetales bacterium | 2053591 | Bacteria | Bacteria | 53.9 | 1.48e-6 | NR | MCA9106575.1 | 2053591 | g12647 | i0 | 58.5 | 0.727810650887574 | 41 | 17 | 72.8 | 0 | 131 | 9 | 37 | 77 | MCA9106575.1 hypothetical protein [Planctomycetales bacterium] | diamond | 123 | 53.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetales bacterium | |||
| 29751516 | 29751516 | PRJNA1098727_P_NODE_15771_length_162_cov_0.920354_g15530_i0 | PRJNA1098727 | 15771 | 162 | 0.920354 | 1.49097348 | Isosphaeraceae bacterium | 2691532 | Bacteria | Bacteria | 98.6 | 1.2e-22 | NR | MFO0957168.1 | 2691532 | g15530 | i0 | 79.6 | 1 | 54 | 11 | 100 | 0 | 1 | 162 | 263 | 316 | MFO0957168.1 hypothetical protein [Isosphaeraceae bacterium] | diamond | 162 | 98.6 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Isosphaeraceae bacterium | ||
| 29814833 | 29814833 | PRJNA1098727_P_NODE_13031_length_168_cov_1.596639_g12790_i0 | PRJNA1098727 | 13031 | 168 | 1.596639 | 2.68235352 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 43.1 | 0.00979 | NR | HBP19403.1 | 2026780 | g12790 | i0 | 47.7 | 1.42857142857143 | 44 | 18 | 69.6 | 1 | 51 | 167 | 41 | 84 | HBP19403.1 hypothetical protein [Planctomycetota bacterium] | diamond | 240 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30067583 | 30067583 | PRJNA1098727_P_NODE_3752_length_342_cov_9.351536_g3511_i0 | PRJNA1098727 | 3752 | 342 | 9.351536 | 31.98225312 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 44.7 | 0.0226 | NR | MBL4844746.1 | 2026780 | g3511 | i0 | 43.3 | 0.526315789473684 | 60 | 33 | 51.8 | 1 | 318 | 142 | 46 | 105 | MBL4844746.1 protein kinase [Planctomycetota bacterium] | diamond | 180 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30352553 | 30352553 | PRJNA1098727_P_NODE_7812_length_221_cov_1.197674_g7571_i0 | PRJNA1098727 | 7812 | 221 | 1.197674 | 2.64685954 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 52.4 | 1.11e-5 | NR | RKY19218.1 | 2026780 | g7571 | i0 | 37.5 | 0.97737556561086 | 72 | 45 | 97.7 | 0 | 219 | 4 | 315 | 386 | RKY19218.1 MAG: hypothetical protein DRQ55_11190 [Planctomycetota bacterium] | diamond | 216 | 52.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30825885 | 30825885 | PRJNA1098727_P_NODE_13714_length_167_cov_0.881356_g13473_i0 | PRJNA1098727 | 13714 | 167 | 0.881356 | 1.47186452 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 89.4 | 3.69e-19 | NR | MBU6309917.1 | 2026780 | g13473 | i0 | 77.8 | 0.970059880239521 | 54 | 12 | 97 | 0 | 164 | 3 | 364 | 417 | MBU6309917.1 four-carbon acid sugar kinase family protein [Planctomycetota bacterium] | diamond | 162 | 89.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 31774308 | 31774308 | PRJNA1098727_P_NODE_11597_length_177_cov_1.625000_g11356_i0 | PRJNA1098727 | 11597 | 177 | 1.625 | 2.87625 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 52 | 8.51e-6 | NR | MFM1903009.1 | 2026780 | g11356 | i0 | 89.7 | 0.491525423728814 | 29 | 3 | 49.2 | 0 | 177 | 91 | 471 | 499 | MFM1903009.1 Trigger factor [Planctomycetota bacterium] | diamond | 87 | 52 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 31932510 | 31932510 | PRJNA1098727_P_NODE_13137_length_168_cov_0.873950_g12896_i0 | PRJNA1098727 | 13137 | 168 | 0.87395 | 1.468236 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 41.6 | 0.036 | NR | MCB9906960.1 | 2026780 | g12896 | i0 | 42.6 | 0.964285714285714 | 54 | 24 | 96.4 | 1 | 165 | 4 | 294 | 340 | MCB9906960.1 hypothetical protein [Planctomycetota bacterium] | diamond | 162 | 41.6 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium |
Advanced export
JSON shape: default, array, newline-delimited
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);;