contig_metadata
7 rows where bioproject = "PRJNA849822", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27149297 | 27149297 | PRJNA849822_P_NODE_19522_length_327_cov_2.330709_g19348_i0 | PRJNA849822 | 19522 | 327 | 2.330709 | 7.62141843 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 140 | 2.98e-36 | NR | MFT5319030.1 | 2047757 | g19348 | i0 | 60.7 | 0.981651376146789 | 107 | 42 | 98.2 | 0 | 1 | 321 | 86 | 192 | MFT5319030.1 5-histidylcysteine sulfoxide synthase/putative 4-mercaptohistidine N1-methyltransferase [Chlamydiales bacterium] | diamond | 321 | 140 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 28097171 | 28097171 | PRJNA849822_P_NODE_2145_length_1123_cov_2.055238_g2031_i0 | PRJNA849822 | 2145 | 1123 | 2.055238 | 23.08032274 | Parachlamydiales bacterium | 2052178 | Bacteria | Bacteria | 54.7 | 3.29e-4 | NR | MFA6915704.1 | 2052178 | g2031 | i0 | 30.2 | 0.515583259127337 | 96 | 59 | 25.6 | 2 | 506 | 219 | 22 | 109 | MFA6915704.1 collagen-binding domain-containing protein [Parachlamydiales bacterium] | diamond | 579 | 54.7 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiales bacterium | |||
| 29202422 | 29202422 | PRJNA849822_P_NODE_18889_length_333_cov_1.200000_g18715_i0 | PRJNA849822 | 18889 | 333 | 1.2 | 3.996 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 53.1 | 2.4e-5 | NR | MBX9923428.1 | 2047756 | g18715 | i0 | 35.9 | 0.702702702702703 | 78 | 45 | 70.3 | 1 | 3 | 236 | 1118 | 1190 | MBX9923428.1 hypothetical protein [Rhabdochlamydiaceae bacterium] | diamond | 234 | 53.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae bacterium | ||
| 29368493 | 29368493 | PRJNA849822_P_NODE_33609_length_253_cov_0.866667_g33435_i0 | PRJNA849822 | 33609 | 253 | 0.866667 | 2.19266751 | Chlamydiia | 204429 | Bacteria | Bacteria | 70.5 | 3.1e-12 | NR | SCA63848.1 | 1871323 | g33435 | i0 | 65.3 | 7.92094861660079 | 49 | 17 | 58.1 | 0 | 252 | 106 | 207 | 255 | SCA63848.1 Uncharacterized protein SCG7086_BG_00050 [Chlamydiales bacterium SCGC AG-110-P3] | diamond | 2004 | 70.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium SCGC AG-110-P3 | |||
| 30750103 | 30750103 | PRJNA849822_P_NODE_39454_length_246_cov_0.901734_g39280_i0 | PRJNA849822 | 39454 | 246 | 0.901734 | 2.21826564 | Chlamydiia bacterium | 2052156 | Bacteria | Bacteria | 105 | 1.73e-25 | NR | MCB1111046.1 | 2052156 | g39280 | i0 | 64.4 | 0.890243902439024 | 73 | 26 | 89 | 0 | 237 | 19 | 193 | 265 | MCB1111046.1 cysteine synthase family protein [Chlamydiia bacterium] | diamond | 219 | 105 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiia bacterium | ||||
| 31327084 | 31327084 | PRJNA849822_P_NODE_21175_length_315_cov_1.157025_g21001_i0 | PRJNA849822 | 21175 | 315 | 1.157025 | 3.64462875 | Bacteria | 2 | Bacteria | Bacteria | 79 | 8.78e-15 | NR | OGN63406.1 | 1797604 | g21001 | i0 | 46.2 | 3.9047619047619 | 78 | 42 | 74.3 | 0 | 234 | 1 | 6 | 83 | OGN63406.1 MAG: hypothetical protein A3E26_02390, partial [Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_49_32] | diamond | 1230 | 79.7 | 0.991217063989962 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_49_32 | |||||
| 31793081 | 31793081 | PRJNA849822_P_NODE_26877_length_281_cov_1.307692_g26703_i0 | PRJNA849822 | 26877 | 281 | 1.307692 | 3.67461452 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 112 | 1.5400000000000002e-27 | NR | MBX9743860.1 | 2047757 | g26703 | i0 | 55.4 | 1.9644128113879 | 92 | 39 | 96.1 | 2 | 272 | 3 | 161 | 252 | MBX9743860.1 methyltransferase domain-containing protein [Chlamydiales bacterium] | diamond | 552 | 112 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | 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);;