contig_metadata
10 rows where bioproject = "PRJNA561212", tax_clade = "PVC group" and tax_phylum = "Chlamydiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3096532 | 3096532 | PRJNA561212_P_NODE_9643_length_355_cov_0.872340_g9432_i0 | PRJNA561212 | 9643 | 355 | 0.87234 | 3.096807 | uncultured Parachlamydiaceae bacterium | 464461 | Bacteria | Bacteria | 555 | 2.0999999999999995e-153 | NTclustered | gi|2874253811|emb|OY969795.1| | 464461 | g9432 | i0 | 95.665 | 107.729577464789 | 346 | 14 | 97 | 1 | 10 | 355 | 655845 | 656189 | MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 | blastn | 38244 | 555 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | uncultured Parachlamydiaceae bacterium | ||
| 9473896 | 9473896 | PRJNA561212_P_NODE_168_length_2055_cov_4.857719_g132_i0 | PRJNA561212 | 168 | 2055 | 4.857719 | 99.82612545 | root | 1 | Root_unresolved | Root_unresolved | 786 | 9.259999999999999e-279 | NR | WP_013182645.1 | 71667 | g132 | i0 | 62.3 | 55.0919708029197 | 599 | 219 | 87.2 | 5 | 1840 | 50 | 10 | 603 | WP_013182645.1 phosphoenolpyruvate carboxykinase (GTP) [Waddlia chondrophila] | diamond | 113214 | 788 | 0.99746192893401 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Waddliaceae | Waddlia | Waddlia chondrophila | |
| 12024337 | 12024337 | PRJNA561212_P_NODE_11810_length_323_cov_0.904000_g11599_i0 | PRJNA561212 | 11810 | 323 | 0.904 | 2.91992 | uncultured Parachlamydiaceae bacterium | 464461 | Bacteria | Bacteria | 250 | 1e-61 | NTclustered | gi|2874253811|emb|OY969795.1| | 464461 | g11599 | i0 | 81.672 | 32.4953560371517 | 311 | 47 | 94 | 8 | 10 | 314 | 2059953 | 2060259 | MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 | blastn | 10496 | 250 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | uncultured Parachlamydiaceae bacterium | ||
| 12024349 | 12024349 | PRJNA561212_P_NODE_12570_length_314_cov_1.228216_g12359_i0 | PRJNA561212 | 12570 | 314 | 1.228216 | 3.85659824 | Parachlamydiales bacterium | 2052178 | Bacteria | Bacteria | 259 | 1.6100000000000002e-64 | NTclustered | gi|2874253843|emb|OY969899.1| | 2052178 | g12359 | i0 | 85 | 138.041401273885 | 260 | 34 | 82 | 5 | 12 | 269 | 2631817 | 2632073 | MAG: Parachlamydiales bacterium isolate MFD00082.bin.c.1 genome assembly, chromosome: 1 | blastn | 43345 | 259 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiales bacterium | |||
| 12024666 | 12024666 | PRJNA561212_P_NODE_9630_length_355_cov_1.262411_g9419_i0 | PRJNA561212 | 9630 | 355 | 1.262411 | 4.48155905 | uncultured Parachlamydiaceae bacterium | 464461 | Bacteria | Bacteria | 496 | 1.29e-135 | NTclustered | gi|2874253811|emb|OY969795.1| | 464461 | g9419 | i0 | 93.452 | 165.397183098592 | 336 | 19 | 94 | 3 | 9 | 343 | 654397 | 654730 | MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 | blastn | 58716 | 496 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | uncultured Parachlamydiaceae bacterium | ||
| 16433401 | 16433401 | PRJNA561212_P_NODE_8493_length_377_cov_1.207237_g8282_i0 | PRJNA561212 | 8493 | 377 | 1.207237 | 4.55128349 | Waddlia | 71666 | Bacteria | Bacteria | 276 | 1.96e-69 | NTclustered | gi|297375547|gb|CP001928.1| | 716544 | g8282 | i0 | 81.111 | 144.596816976127 | 360 | 55 | 94 | 11 | 14 | 368 | 1839144 | 1838793 | Waddlia chondrophila WSU 86-1044, complete genome | blastn | 54513 | 276 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Waddliaceae | Waddlia | Waddlia chondrophila | |
| 19671898 | 19671898 | PRJNA561212_P_NODE_19636_length_256_cov_1.612022_g19425_i0 | PRJNA561212 | 19636 | 256 | 1.612022 | 4.12677632 | uncultured Parachlamydiaceae bacterium | 464461 | Bacteria | Bacteria | 182 | 2.84e-41 | NTclustered | gi|2874253811|emb|OY969795.1| | 464461 | g19425 | i0 | 80.658 | 31.5234375 | 243 | 39 | 93 | 8 | 10 | 247 | 2058798 | 2059037 | MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 | blastn | 8070 | 182 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | uncultured Parachlamydiaceae bacterium | ||
| 22222338 | 22222338 | PRJNA561212_P_NODE_12458_length_315_cov_1.371901_g12247_i0 | PRJNA561212 | 12458 | 315 | 1.371901 | 4.32148815 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 453 | 6.92e-123 | NTclustered | gi|1869331976|gb|CP058704.1| | 2052176 | g12247 | i0 | 94.257 | 155.911111111111 | 296 | 17 | 94 | 0 | 10 | 305 | 835843 | 836138 | Parachlamydiaceae bacterium isolate SSA5 chromosome | blastn | 49112 | 453 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 24771647 | 24771647 | PRJNA561212_P_NODE_2080_length_756_cov_2.455344_g1885_i0 | PRJNA561212 | 2080 | 756 | 2.455344 | 18.56240064 | uncultured Parachlamydiaceae bacterium | 464461 | Bacteria | Bacteria | 778 | 0 | NTclustered | gi|2874253811|emb|OY969795.1| | 464461 | g1885 | i0 | 86.95 | 106.57671957672 | 705 | 77 | 92 | 13 | 1 | 699 | 654305 | 653610 | MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 | blastn | 80572 | 778 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | uncultured Parachlamydiaceae bacterium | ||
| 28942552 | 28942552 | PRJNA561212_P_NODE_7308_length_406_cov_2.108108_g7097_i0 | PRJNA561212 | 7308 | 406 | 2.108108 | 8.55891848 | Candidatus Acheromyda pituitae | 3076874 | Bacteria | Bacteria | 88.6 | 6.33e-18 | NR | MBX3718576.1 | 3076874 | g7097 | i0 | 54.7 | 0.554187192118227 | 75 | 33 | 55.4 | 1 | 177 | 401 | 1 | 74 | MBX3718576.1 NAD(P)H-quinone oxidoreductase [Candidatus Acheromyda pituitae] | diamond | 225 | 88.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Candidatus Acheromyda | Candidatus Acheromyda pituitae |
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);;