contig_metadata
7 rows where bioproject = "PRJNA330616" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 389813 | 389813 | PRJNA330616_P_NODE_30521_length_162_cov_4.106195_g30112_i0 | PRJNA330616 | 30521 | 162 | 4.106195 | 6.6520359 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 300 | 4.36e-77 | NTclustered | gi|971146634|emb|LN879502.1| | 389348 | g30112 | i0 | 100 | 173.555555555556 | 162 | 0 | 100 | 0 | 1 | 162 | 1251959 | 1251798 | Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK | blastn | 28116 | 300 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 2344738 | 2344738 | PRJNA330616_P_NODE_4622_length_394_cov_3.237681_g4213_i0 | PRJNA330616 | 4622 | 394 | 3.237681 | 12.75646314 | Candidatus Protochlamydia | 282132 | Bacteria | Bacteria | 590 | 6.459999999999999e-164 | NTclustered | gi|1691252667|emb|BX908798.2| | 264201 | g4213 | i0 | 93.671 | 174.225888324873 | 395 | 23 | 100 | 2 | 1 | 394 | 1249056 | 1249449 | Candidatus Protochlamydia amoebophila UWE25 complete genome | blastn | 68645 | 595 | 0.991596638655462 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia amoebophila | |
| 13143172 | 13143172 | PRJNA330616_P_NODE_18891_length_194_cov_1.055172_g18482_i0 | PRJNA330616 | 18891 | 194 | 1.055172 | 2.04703368 | uncultured Chlamydiales bacterium | 174324 | Bacteria | Bacteria | 226 | 9.319999999999998e-55 | NTclustered | gi|2874253712|emb|OY969554.1| | 174324 | g18482 | i0 | 87.629 | 189.530927835052 | 194 | 24 | 100 | 0 | 1 | 194 | 1826595 | 1826402 | MAG: uncultured Chlamydiales bacterium isolate MFD04540.bin.c.3 genome assembly, chromosome: 1 | blastn | 36769 | 226 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | uncultured Chlamydiales bacterium | |||
| 18241367 | 18241367 | PRJNA330616_P_NODE_27315_length_165_cov_3.870690_g26906_i0 | PRJNA330616 | 27315 | 165 | 3.87069 | 6.3866385 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 305 | 9.59e-79 | NTclustered | gi|971146634|emb|LN879502.1| | 389348 | g26906 | i0 | 100 | 11.0363636363636 | 165 | 0 | 100 | 0 | 1 | 165 | 1251368 | 1251204 | Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK | blastn | 1821 | 305 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 19515577 | 19515577 | PRJNA330616_P_NODE_24456_length_171_cov_1.155738_g24047_i0 | PRJNA330616 | 24456 | 171 | 1.155738 | 1.97631198 | uncultured Parachlamydiaceae bacterium | 464461 | Bacteria | Bacteria | 176 | 8.149999999999999e-40 | NTclustered | gi|2874253811|emb|OY969795.1| | 464461 | g24047 | i0 | 85.629 | 186.374269005848 | 167 | 24 | 98 | 0 | 1 | 167 | 653887 | 653721 | MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 | blastn | 31870 | 176 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | uncultured Parachlamydiaceae bacterium | ||
| 20791244 | 20791244 | PRJNA330616_P_NODE_297_length_1711_cov_4.143201_g124_i1 | PRJNA330616 | 297 | 1711 | 4.143201 | 70.89016911 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 2878 | 0 | NTclustered | gi|971146634|emb|LN879502.1| | 389348 | g124 | i1 | 98.471 | 111.189947399182 | 1635 | 21 | 95 | 4 | 1 | 1633 | 1251045 | 1249413 | Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK | blastn | 190246 | 2878 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 24021268 | 24021268 | PRJNA330616_P_NODE_5359_length_363_cov_3.012739_g4950_i0 | PRJNA330616 | 5359 | 363 | 3.012739 | 10.93624257 | Candidatus Protochlamydia | 282132 | Bacteria | Bacteria | 671 | 0 | NTclustered | gi|971146634|emb|LN879502.1| | 389348 | g4950 | i0 | 100 | 111.787878787879 | 363 | 0 | 100 | 0 | 1 | 363 | 1247172 | 1247534 | Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK | blastn | 40579 | 671 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila |
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);;