contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJEB20058" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25514256 | 25514256 | PRJEB20058_P_NODE_134009_length_339_cov_1.669065_g131189_i0 | PRJEB20058 | 134009 | 339 | 1.669065 | 5.65813035 | Candidatus Protochlamydia amoebophila UWE25 | 264201 | Bacteria | Bacteria | 363 | 1.3e-95 | NTclustered | gi|1691252667|emb|BX908798.2| | 264201 | g131189 | i0 | 86.431 | 120.660766961652 | 339 | 37 | 99 | 9 | 1 | 334 | 1881413 | 1881747 | Candidatus Protochlamydia amoebophila UWE25 complete genome | blastn | 40904 | 363 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia amoebophila | |
| 25515757 | 25515757 | PRJEB20058_P_NODE_168249_length_289_cov_19.013158_g165426_i0 | PRJEB20058 | 168249 | 289 | 19.013158 | 54.94802662 | uncultured Parachlamydiaceae bacterium | 464461 | Bacteria | Bacteria | 324 | 5.13e-84 | NTclustered | gi|2874253811|emb|OY969795.1| | 464461 | g165426 | i0 | 88.321 | 93.8096885813149 | 274 | 27 | 93 | 5 | 1 | 270 | 655131 | 655403 | MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 | blastn | 27111 | 324 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | uncultured Parachlamydiaceae bacterium | ||
| 25924321 | 25924321 | PRJEB20058_P_NODE_175876_length_280_cov_24.182648_g173053_i0 | PRJEB20058 | 175876 | 280 | 24.182648 | 67.7114144 | Chlamydiales bacterium QZY | 2803004 | Bacteria | Bacteria | 307 | 4.9900000000000007e-79 | NTclustered | gi|1955632013|gb|MW471098.1| | 2803004 | g173053 | i0 | 88.933 | 83.0285714285714 | 253 | 23 | 89 | 3 | 9 | 258 | 600 | 350 | Chlamydiales bacterium QZY 16S ribosomal RNA gene, partial sequence | blastn | 23248 | 307 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium QZY | |||
| 25925473 | 25925473 | PRJEB20058_P_NODE_20292_length_921_cov_10.920930_g18218_i0 | PRJEB20058 | 20292 | 921 | 10.92093 | 100.5817653 | uncultured Parachlamydiaceae bacterium | 464461 | Bacteria | Bacteria | 675 | 0 | NTclustered | gi|2874253811|emb|OY969795.1| | 464461 | g18218 | i0 | 80.876 | 0.942453854505972 | 868 | 156 | 94 | 10 | 35 | 897 | 2249683 | 2250545 | MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 | blastn | 868 | 675 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | uncultured Parachlamydiaceae bacterium | ||
| 26059581 | 26059581 | PRJEB20058_P_NODE_159341_length_300_cov_30.744770_g156518_i0 | PRJEB20058 | 159341 | 300 | 30.74477 | 92.23431 | Parachlamydia acanthamoebae | 83552 | Bacteria | Bacteria | 257 | 5.51e-64 | NTclustered | gi|1491674|emb|Y07555.1| | 83552 | g156518 | i0 | 97.368 | 67.35 | 152 | 3 | 77 | 1 | 128 | 278 | 1251 | 1100 | Parachlamydia acanthamoebae genomic LSU rRNA | blastn | 20205 | 257 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydia | Parachlamydia acanthamoebae | |
| 26065226 | 26065226 | PRJEB20058_P_NODE_62309_length_530_cov_8.682303_g59547_i0 | PRJEB20058 | 62309 | 530 | 8.682303 | 46.0162059 | uncultured Chlamydiales bacterium | 174324 | Bacteria | Bacteria | 505 | 3.319999999999999e-138 | NTclustered | gi|2874253688|emb|OY969414.1| | 174324 | g59547 | i0 | 84.825 | 147.294339622642 | 514 | 65 | 96 | 10 | 1 | 509 | 2363933 | 2364438 | MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1 | blastn | 78066 | 505 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | uncultured Chlamydiales 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);;