contig_metadata
10 rows where bioproject = "PRJNA385064" and tax_clade = "PVC group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 405379 | 405379 | PRJNA385064_P_NODE_4981_length_192_cov_1.363636_g4856_i0 | PRJNA385064 | 4981 | 192 | 1.363636 | 2.61818112 | Paludisphaera borealis | 1387353 | Bacteria | Bacteria | 322 | 1.14e-83 | NTclustered | gi|1133581311|gb|CP019082.1| | 1387353 | g4856 | i0 | 96.875 | 125.505208333333 | 192 | 6 | 100 | 0 | 1 | 192 | 122449 | 122640 | Paludisphaera borealis strain PX4 chromosome, complete genome | blastn | 24097 | 322 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Paludisphaera | Paludisphaera borealis | |
| 405381 | 405381 | PRJNA385064_P_NODE_5161_length_188_cov_1.345324_g5036_i0 | PRJNA385064 | 5161 | 188 | 1.345324 | 2.52920912 | uncultured Chlamydiales bacterium | 174324 | Bacteria | Bacteria | 237 | 4.14e-58 | NTclustered | gi|880804258|gb|KT263002.1| | 174324 | g5036 | i0 | 92.216 | 130.686170212766 | 167 | 13 | 89 | 0 | 22 | 188 | 1 | 167 | Uncultured Chlamydiales bacterium clone SW41C 16S ribosomal RNA gene, partial sequence | blastn | 24569 | 237 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | uncultured Chlamydiales bacterium | |||
| 7453874 | 7453874 | PRJNA385064_P_NODE_3866_length_221_cov_1.418605_g3741_i0 | PRJNA385064 | 3866 | 221 | 1.418605 | 3.13511705 | Pirellulaceae | 2691357 | Bacteria | Bacteria | 243 | 1.08e-59 | NTclustered | gi|1015448679|gb|CP011272.1| | 1632865 | g3741 | i0 | 87.215 | 470.597285067873 | 219 | 21 | 98 | 5 | 3 | 218 | 3094893 | 3095107 | Pirellula sp. SH-Sr6A, complete genome | blastn | 104002 | 244 | 0.995901639344262 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Pirellula | Pirellula sp. SH-Sr6A | |
| 8728564 | 8728564 | PRJNA385064_P_NODE_4707_length_198_cov_1.000000_g4582_i0 | PRJNA385064 | 4707 | 198 | 1 | 1.98 | Planctomycetia | 203683 | Bacteria | Bacteria | 254 | 4.38e-63 | NTclustered | gi|2874254106|emb|OY970189.1| | 100233 | g4582 | i0 | 89.899 | 117.469696969697 | 198 | 19 | 100 | 1 | 1 | 198 | 4318508 | 4318312 | MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1 | blastn | 23259 | 254 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | uncultured Planctomycetaceae bacterium | ||
| 13159096 | 13159096 | PRJNA385064_P_NODE_6171_length_171_cov_0.860656_g6046_i0 | PRJNA385064 | 6171 | 171 | 0.860656 | 1.47172176 | Paludisphaera borealis | 1387353 | Bacteria | Bacteria | 239 | 1.02e-58 | NTclustered | gi|1133581311|gb|CP019082.1| | 1387353 | g6046 | i0 | 95.918 | 95.2748538011696 | 147 | 6 | 86 | 0 | 23 | 169 | 122120 | 121974 | Paludisphaera borealis strain PX4 chromosome, complete genome | blastn | 16292 | 239 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Paludisphaera | Paludisphaera borealis | |
| 18256886 | 18256886 | PRJNA385064_P_NODE_3035_length_252_cov_1.768473_g2910_i0 | PRJNA385064 | 3035 | 252 | 1.768473 | 4.45655196 | uncultured Pirellula sp. | 298571 | Bacteria | Bacteria | 466 | 6.89e-127 | NTclustered | gi|511202468|gb|KC994699.1| | 298571 | g2910 | i0 | 100 | 98.7619047619048 | 252 | 0 | 100 | 0 | 1 | 252 | 1406 | 1155 | Uncultured Pirellula sp. clone BF 019 16S ribosomal RNA gene, partial sequence | blastn | 24888 | 466 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Pirellula | uncultured Pirellula sp. | |
| 18256906 | 18256906 | PRJNA385064_P_NODE_7915_length_162_cov_0.902655_g7790_i0 | PRJNA385064 | 7915 | 162 | 0.902655 | 1.4623011 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 159 | 7.72e-35 | NTclustered | gi|2874254065|emb|OY970130.1| | 412056 | g7790 | i0 | 84.756 | 1.97530864197531 | 164 | 19 | 100 | 6 | 1 | 162 | 1683040 | 1683199 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1 | blastn | 320 | 159 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 29885778 | 29885778 | PRJNA385064_P_NODE_4031_length_216_cov_1.161677_g3906_i0 | PRJNA385064 | 4031 | 216 | 1.161677 | 2.50922232 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 44.7 | 0.00574 | NR | GDY12475.1 | 2026780 | g3906 | i0 | 44.9 | 0.680555555555556 | 49 | 23 | 68.1 | 1 | 61 | 207 | 659 | 703 | GDY12475.1 hypothetical protein LBMAG53_13530 [Planctomycetota bacterium] | diamond | 147 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 32130167 | 32130167 | PRJNA385064_P_NODE_6838_length_166_cov_0.871795_g6713_i0 | PRJNA385064 | 6838 | 166 | 0.871795 | 1.4471797 | Phycisphaerae bacterium | 2026778 | Bacteria | Bacteria | 90.1 | 1.56e-19 | NR | MBP7933803.1 | 2026778 | g6713 | i0 | 69.1 | 4.96987951807229 | 55 | 17 | 99.4 | 0 | 165 | 1 | 132 | 186 | MBP7933803.1 exo-alpha-sialidase [Phycisphaerae bacterium] | diamond | 825 | 90.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerae bacterium | ||||
| 32146926 | 32146926 | PRJNA385064_P_NODE_7238_length_164_cov_0.886957_g7113_i0 | PRJNA385064 | 7238 | 164 | 0.886957 | 1.45460948 | Planctomycetia | 203683 | Bacteria | Bacteria | 95.9 | 3.0800000000000003e-22 | NR | MBV8486726.1 | 2026779 | g7113 | i0 | 87 | 1.95731707317073 | 54 | 7 | 98.8 | 0 | 163 | 2 | 37 | 90 | MBV8486726.1 adenosylcobinamide-GDP ribazoletransferase [Planctomycetaceae bacterium] | diamond | 321 | 95.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae 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);;