contig_metadata
12 rows where bioproject = "PRJNA796753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3768413 | 3768413 | PRJNA796753_P_NODE_35263_length_262_cov_1.873016_g34951_i0 | PRJNA796753 | 35263 | 262 | 1.873016 | 4.90730192 | Parachlamydiales | 1963360 | Bacteria | Bacteria | 129 | 4.67e-33 | NR | WP_032125010.1 | 389348 | g34951 | i0 | 78.7 | 7.78625954198473 | 75 | 16 | 85.9 | 0 | 262 | 38 | 215 | 289 | WP_032125010.1 asparagine--tRNA ligase [Candidatus Protochlamydia naegleriophila] | diamond | 2040 | 130 | 0.992307692307692 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 10984751 | 10984751 | PRJNA796753_P_NODE_44369_length_248_cov_0.880000_g44057_i0 | PRJNA796753 | 44369 | 248 | 0.88 | 2.1824 | Chlamydia serpentis | 1967782 | Bacteria | Bacteria | 52.8 | 0.022 | NTclustered | gi|1376449303|emb|LT993738.1| | 1967782 | g44057 | i0 | 100 | 0.112903225806452 | 28 | 0 | 11 | 0 | 128 | 155 | 72844 | 72817 | Chlamydia sp. H15-1957-10C genome assembly, chromosome: I | blastn | 28 | 52.8 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia serpentis | |
| 13534496 | 13534496 | PRJNA796753_P_NODE_51331_length_243_cov_0.905882_g51019_i0 | PRJNA796753 | 51331 | 243 | 0.905882 | 2.20129326 | Chlamydiia | 204429 | Bacteria | Bacteria | 129 | 3.16e-34 | NR | PIS01434.1 | 1973935 | g51019 | i0 | 75 | 13.6666666666667 | 80 | 20 | 98.8 | 0 | 2 | 241 | 122 | 201 | PIS01434.1 MAG: transaldolase [Chlamydiae bacterium CG10_big_fil_rev_8_21_14_0_10_35_9] | diamond | 3321 | 130 | 0.992307692307692 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiae bacterium CG10_big_fil_rev_8_21_14_0_10_35_9 | |||||
| 28380274 | 28380274 | PRJNA796753_P_NODE_15586_length_362_cov_2.820069_g15274_i0 | PRJNA796753 | 15586 | 362 | 2.820069 | 10.20864978 | Estrella lausannensis | 483423 | Bacteria | Bacteria | 48.9 | 3.33e-4 | NR | WP_098037980.1 | 483423 | g15274 | i0 | 32.6 | 1.64917127071823 | 95 | 63 | 77.9 | 1 | 318 | 37 | 35 | 129 | WP_098037980.1 Dps family protein [Estrella lausannensis] | diamond | 597 | 48.9 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Criblamydiaceae | Estrella | Estrella lausannensis | |
| 28601425 | 28601425 | PRJNA796753_P_NODE_28827_length_284_cov_1.303318_g28515_i0 | PRJNA796753 | 28827 | 284 | 1.303318 | 3.70142312 | Chlamydiia bacterium | 2052156 | Bacteria | Bacteria | 45.1 | 0.00888 | NR | MCB1111823.1 | 2052156 | g28515 | i0 | 29.7 | 0.78169014084507 | 74 | 52 | 78.2 | 0 | 222 | 1 | 299 | 372 | MCB1111823.1 nucleoside hydrolase [Chlamydiia bacterium] | diamond | 222 | 45.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiia bacterium | ||||
| 29611385 | 29611385 | PRJNA796753_P_NODE_33430_length_269_cov_1.178571_g33118_i0 | PRJNA796753 | 33430 | 269 | 1.178571 | 3.17035599 | Chlamydiia bacterium | 2052156 | Bacteria | Bacteria | 96.7 | 1.98e-21 | NR | MCB1111560.1 | 2052156 | g33118 | i0 | 55.7 | 0.981412639405205 | 88 | 38 | 98.1 | 1 | 266 | 3 | 222 | 308 | MCB1111560.1 dihydroorotate dehydrogenase [Chlamydiia bacterium] | diamond | 264 | 96.7 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiia bacterium | ||||
| 29896000 | 29896000 | PRJNA796753_P_NODE_12111_length_402_cov_2.765957_g11799_i0 | PRJNA796753 | 12111 | 402 | 2.7659570000000002 | 11.11914714 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 142 | 2.86e-40 | NR | MCP5470420.1 | 2047757 | g11799 | i0 | 82.1 | 0.582089552238806 | 78 | 14 | 58.2 | 0 | 401 | 168 | 2 | 79 | MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium] | diamond | 234 | 142 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 30717236 | 30717236 | PRJNA796753_P_NODE_2954_length_770_cov_1.810617_g2679_i0 | PRJNA796753 | 2954 | 770 | 1.810617 | 13.9417509 | Simkania sp. | 34094 | Bacteria | Bacteria | 250 | 1.11e-79 | NR | MCB1084310.1 | 34094 | g2679 | i0 | 67.9 | 0.751948051948052 | 193 | 62 | 75.2 | 0 | 50 | 628 | 1 | 193 | MCB1084310.1 hypothetical protein [Simkania sp.] | diamond | 579 | 250 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 30907162 | 30907162 | PRJNA796753_P_NODE_40734_length_250_cov_0.870056_g40422_i0 | PRJNA796753 | 40734 | 250 | 0.870056 | 2.17514 | Chlamydia sp. 32-24 | 1895742 | Bacteria | Bacteria | 55.1 | 1.2e-6 | NR | OJU81840.1 | 1895742 | g40422 | i0 | 47.3 | 3.876 | 55 | 27 | 63.6 | 1 | 91 | 249 | 15 | 69 | OJU81840.1 MAG: hypothetical protein BGO10_08110 [Chlamydia sp. 32-24] | diamond | 969 | 55.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia sp. 32-24 | |
| 31381233 | 31381233 | PRJNA796753_P_NODE_23536_length_308_cov_1.855319_g23224_i0 | PRJNA796753 | 23536 | 308 | 1.855319 | 5.71438252 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 85.9 | 5.46e-19 | NR | QLH37614.1 | 2052176 | g23224 | i0 | 50 | 0.818181818181818 | 84 | 35 | 75 | 1 | 296 | 66 | 40 | 123 | QLH37614.1 MAG: Helicase associated domain protein [Parachlamydiaceae bacterium] | diamond | 252 | 85.9 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 31792047 | 31792047 | PRJNA796753_P_NODE_51197_length_243_cov_0.905882_g50885_i0 | PRJNA796753 | 51197 | 243 | 0.905882 | 2.20129326 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 64.3 | 2.8e-10 | NR | MBA3958664.1 | 2052176 | g50885 | i0 | 44.9 | 0.851851851851852 | 69 | 36 | 85.2 | 1 | 211 | 5 | 8 | 74 | MBA3958664.1 SAM-dependent methyltransferase [Parachlamydiaceae bacterium] | diamond | 207 | 64.3 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 32803490 | 32803490 | PRJNA796753_P_NODE_29580_length_281_cov_1.730769_g29268_i0 | PRJNA796753 | 29580 | 281 | 1.730769 | 4.86346089 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 60.8 | 2.39e-9 | NR | QLH37614.1 | 2052176 | g29268 | i0 | 54.4 | 0.608540925266904 | 57 | 25 | 60.9 | 1 | 109 | 279 | 27 | 82 | QLH37614.1 MAG: Helicase associated domain protein [Parachlamydiaceae bacterium] | diamond | 171 | 60.8 | 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);;