contig_metadata
7 rows where bioproject = "PRJNA849646" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21240092 | 21240092 | PRJNA849646_P_NODE_11937_length_284_cov_1.459716_g11819_i0 | PRJNA849646 | 11937 | 284 | 1.459716 | 4.14559344 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 420 | 6.24e-113 | NTclustered | gi|971146634|emb|LN879502.1| | 389348 | g11819 | i0 | 93.31 | 190.788732394366 | 284 | 19 | 100 | 0 | 1 | 284 | 1251190 | 1251473 | Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK | blastn | 54184 | 420 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 26706437 | 26706437 | PRJNA849646_P_NODE_36081_length_244_cov_0.900585_g35963_i0 | PRJNA849646 | 36081 | 244 | 0.900585 | 2.1974274 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 142 | 1.14e-39 | NR | MCC5833019.1 | 2047757 | g35963 | i0 | 86.4 | 1.99180327868852 | 81 | 11 | 99.6 | 0 | 243 | 1 | 131 | 211 | MCC5833019.1 enoyl-[acyl-carrier-protein] reductase [Chlamydiales bacterium] | diamond | 486 | 142 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 27813249 | 27813249 | PRJNA849646_P_NODE_28664_length_252_cov_1.502793_g28546_i0 | PRJNA849646 | 28664 | 252 | 1.502793 | 3.78703836 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 85.5 | 1.73e-19 | NR | MEI8124160.1 | 2052176 | g28546 | i0 | 55.3 | 3.52380952380952 | 76 | 26 | 81 | 1 | 5 | 208 | 25 | 100 | MEI8124160.1 DUF971 domain-containing protein [Parachlamydiaceae bacterium] | diamond | 888 | 85.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 29486194 | 29486194 | PRJNA849646_P_NODE_12550_length_283_cov_1.138095_g12432_i0 | PRJNA849646 | 12550 | 283 | 1.138095 | 3.22080885 | Parachlamydia sp. | 2052048 | Bacteria | Bacteria | 51.6 | 2.74e-6 | NR | MCE2982202.1 | 2052048 | g12432 | i0 | 75.7 | 0.392226148409894 | 37 | 9 | 39.2 | 0 | 168 | 278 | 4 | 40 | MCE2982202.1 hypothetical protein [Parachlamydia sp.] | diamond | 111 | 51.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydia | Parachlamydia sp. | |
| 31223752 | 31223752 | PRJNA849646_P_NODE_24035_length_261_cov_1.234043_g23917_i0 | PRJNA849646 | 24035 | 261 | 1.234043 | 3.22085223 | Parachlamydia sp. | 2052048 | Bacteria | Bacteria | 138 | 3.22e-37 | NR | MCE2983996.1 | 2052048 | g23917 | i0 | 69.4 | 0.977011494252874 | 85 | 26 | 97.7 | 0 | 3 | 257 | 264 | 348 | MCE2983996.1 ABC transporter ATP-binding protein [Parachlamydia sp.] | diamond | 255 | 138 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydia | Parachlamydia sp. | |
| 31888078 | 31888078 | PRJNA849646_P_NODE_15137_length_278_cov_1.185366_g15019_i0 | PRJNA849646 | 15137 | 278 | 1.185366 | 3.29531748 | Parachlamydiales bacterium | 2052178 | Bacteria | Bacteria | 139 | 3.48e-36 | NR | MFA6916908.1 | 2052178 | g15019 | i0 | 77.6 | 0.91726618705036 | 85 | 19 | 91.7 | 0 | 277 | 23 | 529 | 613 | MFA6916908.1 malto-oligosyltrehalose trehalohydrolase [Parachlamydiales bacterium] | diamond | 255 | 139 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiales bacterium | |||
| 32204641 | 32204641 | PRJNA849646_P_NODE_38538_length_241_cov_0.916667_g38420_i0 | PRJNA849646 | 38538 | 241 | 0.916667 | 2.20916747 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 121 | 8.91e-30 | NR | MBA3815389.1 | 2052176 | g38420 | i0 | 68.8 | 3.98340248962656 | 80 | 25 | 99.6 | 0 | 1 | 240 | 146 | 225 | MBA3815389.1 hypothetical protein [Parachlamydiaceae bacterium] | diamond | 960 | 121 | 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);;