contig_metadata
7 rows where bioproject = "PRJNA599208", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 572270 | 572270 | PRJNA599208_P_NODE_5781_length_324_cov_2.439024_g5585_i0 | PRJNA599208 | 5781 | 324 | 2.439024 | 7.90243776 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 335 | 2.7e-87 | NTclustered | gi|971146634|emb|LN879502.1| | 389348 | g5585 | i0 | 94.091 | 113.663580246914 | 220 | 13 | 68 | 0 | 103 | 322 | 1251355 | 1251574 | Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK | blastn | 36827 | 335 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 4399977 | 4399977 | PRJNA599208_P_NODE_8404_length_246_cov_2.186603_g8208_i0 | PRJNA599208 | 8404 | 246 | 2.186603 | 5.37904338 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 431 | 2.4399999999999992e-116 | NTclustered | gi|971146634|emb|LN879502.1| | 389348 | g8208 | i0 | 98.374 | 157.284552845528 | 246 | 3 | 100 | 1 | 1 | 246 | 1249681 | 1249925 | Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK | blastn | 38692 | 431 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 5675908 | 5675908 | PRJNA599208_P_NODE_13065_length_178_cov_1.099291_g12869_i0 | PRJNA599208 | 13065 | 178 | 1.099291 | 1.95673798 | uncultured Chlamydiae bacterium | 305355 | Bacteria | Bacteria | 117 | 5.26e-22 | NTclustered | gi|2874253676|emb|OY969110.1| | 305355 | g12869 | i0 | 81.757 | 6.62921348314607 | 148 | 20 | 80 | 7 | 18 | 160 | 416036 | 415891 | MAG: uncultured Chlamydiae bacterium isolate MFD00082.bin.c.5 genome assembly, chromosome: 1 | blastn | 1180 | 117 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | uncultured Chlamydiae bacterium | ||||
| 10776458 | 10776458 | PRJNA599208_P_NODE_11829_length_191_cov_0.915584_g11633_i0 | PRJNA599208 | 11829 | 191 | 0.915584 | 1.74876544 | Chlamydiales bacterium CRIB 32 | 492525 | Bacteria | Bacteria | 195 | 2.5799999999999997e-45 | NTclustered | gi|165911248|gb|EU363464.1| | 492525 | g11633 | i0 | 94.444 | 63.7696335078534 | 126 | 7 | 66 | 0 | 66 | 191 | 136 | 11 | Chlamydiales bacterium CRIB 32 16S ribosomal RNA gene, partial sequence | blastn | 12180 | 195 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium CRIB 32 | |||
| 10776470 | 10776470 | PRJNA599208_P_NODE_13069_length_178_cov_1.099291_g12873_i0 | PRJNA599208 | 13069 | 178 | 1.099291 | 1.95673798 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 318 | 1.34e-82 | NTclustered | gi|971146634|emb|LN879502.1| | 389348 | g12873 | i0 | 98.876 | 163.455056179775 | 178 | 2 | 100 | 0 | 1 | 178 | 1249580 | 1249403 | Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK | blastn | 29095 | 318 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 15875015 | 15875015 | PRJNA599208_P_NODE_5053_length_357_cov_1.881250_g4858_i0 | PRJNA599208 | 5053 | 357 | 1.88125 | 6.7160625 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 446 | 1.33e-120 | NTclustered | gi|971146634|emb|LN879502.1| | 389348 | g4858 | i0 | 96.642 | 96.5658263305322 | 268 | 9 | 75 | 0 | 1 | 268 | 1250332 | 1250065 | Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK | blastn | 34474 | 446 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 17719281 | 17719281 | PRJNA599208_P_NODE_13114_length_177_cov_2.228571_g12918_i0 | PRJNA599208 | 13114 | 177 | 2.228571 | 3.94457067 | Parachlamydia | 83551 | Bacteria | Bacteria | 327 | 2.2199999999999996e-85 | NTclustered | gi|470491594|ref|NR_077046.1| | 83552 | g12918 | i0 | 100 | 105.774011299435 | 177 | 0 | 100 | 0 | 1 | 177 | 1492 | 1668 | Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence | blastn | 18722 | 327 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydia | Parachlamydia acanthamoebae |
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);;