contig_metadata
7 rows where bioproject = "PRJNA861969", tax_clade = "PVC group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 846450 | 846450 | PRJNA861969_P_NODE_33781_length_248_cov_0.880000_g33550_i0 | PRJNA861969 | 33781 | 248 | 0.88 | 2.1824 | Gemmata massiliana | 1210884 | Bacteria | Bacteria | 265 | 2.6499999999999997e-66 | NTclustered | gi|1804905141|emb|LR593886.1| | 1210884 | g33550 | i0 | 85.944 | 1.00403225806452 | 249 | 33 | 100 | 2 | 1 | 248 | 4104838 | 4104591 | Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1 | blastn | 249 | 265 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmata | Gemmata massiliana | |
| 23798674 | 23798674 | PRJNA861969_P_NODE_33059_length_249_cov_0.875000_g32828_i0 | PRJNA861969 | 33059 | 249 | 0.875 | 2.17875 | uncultured Planctomycetaceae bacterium | 100233 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2874254106|emb|OY970189.1| | 100233 | g32828 | i0 | 94.286 | 0.140562248995984 | 35 | 2 | 14 | 0 | 184 | 218 | 7103919 | 7103885 | MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1 | blastn | 35 | 54.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | uncultured Planctomycetaceae bacterium | ||
| 26960021 | 26960021 | PRJNA861969_P_NODE_33562_length_248_cov_1.760000_g33331_i0 | PRJNA861969 | 33562 | 248 | 1.76 | 4.3648 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 151 | 1.69e-42 | NR | MFO0852601.1 | 2052164 | g33331 | i0 | 81.7 | 0.991935483870968 | 82 | 15 | 99.2 | 0 | 2 | 247 | 259 | 340 | MFO0852601.1 sialidase family protein [Gemmataceae bacterium] | diamond | 246 | 151 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 28160734 | 28160734 | PRJNA861969_P_NODE_27525_length_264_cov_1.476440_g27294_i0 | PRJNA861969 | 27525 | 264 | 1.47644 | 3.8978016 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 44.3 | 0.013 | NR | MBM4009064.1 | 2026780 | g27294 | i0 | 38.6 | 1 | 44 | 24 | 46.6 | 1 | 249 | 127 | 135 | 178 | MBM4009064.1 DMT family transporter [Planctomycetota bacterium] | diamond | 264 | 44.3 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30908327 | 30908327 | PRJNA861969_P_NODE_23114_length_284_cov_1.459716_g22883_i0 | PRJNA861969 | 23114 | 284 | 1.459716 | 4.14559344 | Candidatus Laterigemmans baculatus | 2770505 | Bacteria | Bacteria | 180 | 1.77e-52 | NR | WP_164101029.1 | 2770505 | g22883 | i0 | 96.8 | 1.98591549295775 | 94 | 3 | 99.3 | 0 | 284 | 3 | 214 | 307 | WP_164101029.1 V-type ATP synthase subunit B [Candidatus Laterigemmans baculatus] | diamond | 564 | 180 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Candidatus Laterigemmans | Candidatus Laterigemmans baculatus | |
| 30939945 | 30939945 | PRJNA861969_P_NODE_37294_length_245_cov_0.895349_g37063_i0 | PRJNA861969 | 37294 | 245 | 0.895349 | 2.19360505 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 70.1 | 6.57e-13 | NR | MCI0332210.1 | 2026780 | g37063 | i0 | 47.8 | 0.820408163265306 | 67 | 35 | 82 | 0 | 1 | 201 | 84 | 150 | MCI0332210.1 hypothetical protein [Planctomycetota bacterium] | diamond | 201 | 70.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 32489742 | 32489742 | PRJNA861969_P_NODE_37559_length_245_cov_0.895349_g37328_i0 | PRJNA861969 | 37559 | 245 | 0.895349 | 2.19360505 | Fimbriiglobus sp. | 1914235 | Bacteria | Bacteria | 92 | 7.42e-20 | NR | MCU0705219.1 | 1914235 | g37328 | i0 | 57.1 | 0.942857142857143 | 77 | 33 | 94.3 | 0 | 242 | 12 | 192 | 268 | MCU0705219.1 ATP-grasp domain-containing protein [Fimbriiglobus sp.] | diamond | 231 | 92 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Fimbriiglobus | Fimbriiglobus sp. |
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);;