contig_metadata
5 rows where bioproject = "PRJNA1092581" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10399046 | 10399046 | PRJNA1092581_P_NODE_111589_length_237_cov_5.207317_g111056_i0 | PRJNA1092581 | 111589 | 237 | 5.207317 | 12.34134129 | uncultured Parachlamydiaceae bacterium | 464461 | Bacteria | Bacteria | 296 | 8.900000000000001e-76 | NTclustered | gi|2874253811|emb|OY969795.1| | 464461 | g111056 | i0 | 91.628 | 142.122362869198 | 215 | 16 | 90 | 2 | 25 | 237 | 655403 | 655189 | MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 | blastn | 33683 | 296 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | uncultured Parachlamydiaceae bacterium | ||
| 12497333 | 12497333 | PRJNA1092581_P_NODE_62030_length_336_cov_2.631179_g61497_i0 | PRJNA1092581 | 62030 | 336 | 2.631179 | 8.84076144 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 255 | 2.25e-63 | NTclustered | gi|2874253676|emb|OY969110.1| | 305355 | g61497 | i0 | 82.353 | 101.979166666667 | 306 | 42 | 90 | 10 | 32 | 334 | 1641657 | 1641361 | MAG: uncultured Chlamydiae bacterium isolate MFD00082.bin.c.5 genome assembly, chromosome: 1 | blastn | 34265 | 255 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | uncultured Chlamydiae bacterium | ||||
| 21872874 | 21872874 | PRJNA1092581_P_NODE_126338_length_202_cov_77.488372_g125805_i0 | PRJNA1092581 | 126338 | 202 | 77.488372 | 156.52651144 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 174 | 3.6e-39 | NTclustered | gi|1869331976|gb|CP058704.1| | 2052176 | g125805 | i0 | 84.53 | 39.8613861386139 | 181 | 22 | 88 | 6 | 24 | 201 | 1334287 | 1334110 | Parachlamydiaceae bacterium isolate SSA5 chromosome | blastn | 8052 | 174 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 21873776 | 21873776 | PRJNA1092581_P_NODE_43838_length_410_cov_5.388724_g43305_i0 | PRJNA1092581 | 43838 | 410 | 5.388724 | 22.0937684 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 593 | 5.219999999999998e-165 | NTclustered | gi|971146634|emb|LN879502.1| | 389348 | g43305 | i0 | 93.12 | 129.40243902439 | 407 | 24 | 99 | 4 | 1 | 405 | 1250390 | 1249986 | Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK | blastn | 53055 | 593 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 30320885 | 30320885 | PRJNA1092581_P_NODE_91872_length_266_cov_2.595855_g91339_i0 | PRJNA1092581 | 91872 | 266 | 2.595855 | 6.9049743 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 58.9 | 9.72e-8 | NR | MBA3815754.1 | 2052176 | g91339 | i0 | 42 | 0.913533834586466 | 81 | 44 | 90.2 | 2 | 260 | 21 | 446 | 524 | MBA3815754.1 ankyrin repeat domain-containing protein [Parachlamydiaceae bacterium] | diamond | 243 | 58.9 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae 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);;