contig_metadata
7 rows where bioproject = "PRJNA846110", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2108525 | 2108525 | PRJNA846110_P_NODE_2442_length_663_cov_1.964407_g2212_i0 | PRJNA846110 | 2442 | 663 | 1.964407 | 13.02401841 | Chlamydiales bacterium QZY | 2803004 | Bacteria | Bacteria | 795 | 0 | NTclustered | gi|1955632013|gb|MW471098.1| | 2803004 | g2212 | i0 | 91.552 | 176.419306184012 | 580 | 43 | 87 | 4 | 86 | 663 | 37 | 612 | Chlamydiales bacterium QZY 16S ribosomal RNA gene, partial sequence | blastn | 116966 | 795 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium QZY | |||
| 2506879 | 2506879 | PRJNA846110_P_NODE_5122_length_460_cov_1.981912_g4878_i0 | PRJNA846110 | 5122 | 460 | 1.981912 | 9.1167952 | Waddlia | 71666 | Bacteria | Bacteria | 326 | 2.38e-84 | NTclustered | gi|470485904|ref|NR_076723.1| | 71667 | g4878 | i0 | 80.499 | 182.713043478261 | 441 | 72 | 95 | 10 | 1 | 436 | 1326 | 1757 | Waddlia chondrophila strain WSU 86-1044 23S ribosomal RNA gene, complete sequence | blastn | 84048 | 326 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Waddliaceae | Waddlia | Waddlia chondrophila | |
| 12312346 | 12312346 | PRJNA846110_P_NODE_8750_length_358_cov_1.877193_g8506_i0 | PRJNA846110 | 8750 | 358 | 1.877193 | 6.72035094 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 252 | 3.11e-62 | NTclustered | gi|1869331976|gb|CP058704.1| | 2052176 | g8506 | i0 | 79.614 | 147.237430167598 | 363 | 64 | 100 | 10 | 1 | 358 | 835896 | 836253 | Parachlamydiaceae bacterium isolate SSA5 chromosome | blastn | 52711 | 252 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 13586810 | 13586810 | PRJNA846110_P_NODE_711_length_1185_cov_2.313849_g573_i0 | PRJNA846110 | 711 | 1185 | 2.313849 | 27.41911065 | uncultured Parachlamydiaceae bacterium | 464461 | Bacteria | Bacteria | 1009 | 0 | NTclustered | gi|2874253811|emb|OY969795.1| | 464461 | g573 | i0 | 82.794 | 195.95864978903 | 1174 | 159 | 97 | 38 | 38 | 1185 | 2059748 | 2058592 | MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 | blastn | 232211 | 1009 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | uncultured Parachlamydiaceae bacterium | ||
| 29052800 | 29052800 | PRJNA846110_P_NODE_24908_length_248_cov_0.880000_g24663_i0 | PRJNA846110 | 24908 | 248 | 0.88 | 2.1824 | Candidatus Similichlamydia | 1348235 | Bacteria | Bacteria | 152 | 1.95e-45 | NR | WP_275655994.1 | 1903953 | g24663 | i0 | 90.1 | 1.95967741935484 | 81 | 8 | 98 | 0 | 248 | 6 | 10 | 90 | WP_275655994.1 Clp protease N-terminal domain-containing protein, partial [Candidatus Similichlamydia epinepheli] | diamond | 486 | 152 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Parilichlamydiaceae | Candidatus Similichlamydia | Candidatus Similichlamydia epinepheli | |
| 31706674 | 31706674 | PRJNA846110_P_NODE_28877_length_243_cov_0.905882_g28632_i0 | PRJNA846110 | 28877 | 243 | 0.905882 | 2.20129326 | Parachlamydiales | 1963360 | Bacteria | Bacteria | 55.5 | 1.21e-6 | NR | WP_108623814.1 | 1903953 | g28632 | i0 | 39.2 | 3.5679012345679 | 74 | 40 | 85.2 | 1 | 35 | 241 | 3 | 76 | WP_108623814.1 tetratricopeptide repeat protein [Candidatus Similichlamydia epinepheli] | diamond | 867 | 55.8 | 0.99462365591397806 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Parilichlamydiaceae | Candidatus Similichlamydia | Candidatus Similichlamydia epinepheli | |
| 32173011 | 32173011 | PRJNA846110_P_NODE_18298_length_271_cov_2.691919_g18053_i0 | PRJNA846110 | 18298 | 271 | 2.691919 | 7.29510049 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 103 | 5.31e-25 | NR | MFN4174080.1 | 2052176 | g18053 | i0 | 69.4 | 0.686346863468635 | 62 | 19 | 68.6 | 0 | 188 | 3 | 1 | 62 | MFN4174080.1 carotenoid oxygenase family protein [Parachlamydiaceae bacterium] | diamond | 186 | 103 | 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);;