contig_metadata
12 rows where bioproject = "PRJNA744060", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3274950 | 3274950 | PRJNA744060_P_NODE_51283_length_242_cov_0.923077_g50954_i0 | PRJNA744060 | 51283 | 242 | 0.923077 | 2.23384634 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 440 | 3.9799999999999986e-119 | NTclustered | gi|971146634|emb|LN879502.1| | 389348 | g50954 | i0 | 99.587 | 1 | 242 | 0 | 100 | 1 | 1 | 242 | 2392000 | 2391760 | Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK | blastn | 242 | 440 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 5826669 | 5826669 | PRJNA744060_P_NODE_21525_length_349_cov_1.130435_g21196_i0 | PRJNA744060 | 21525 | 349 | 1.130435 | 3.94521815 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 645 | 1.1899999999999993e-180 | NTclustered | gi|971146634|emb|LN879502.1| | 389348 | g21196 | i0 | 100 | 1 | 349 | 0 | 100 | 0 | 1 | 349 | 639430 | 639778 | Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK | blastn | 349 | 645 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 7101790 | 7101790 | PRJNA744060_P_NODE_21126_length_352_cov_1.670251_g20797_i0 | PRJNA744060 | 21126 | 352 | 1.670251 | 5.87928352 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 651 | 0 | NTclustered | gi|971146634|emb|LN879502.1| | 389348 | g20797 | i0 | 100 | 1 | 352 | 0 | 100 | 0 | 1 | 352 | 1147869 | 1147518 | Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK | blastn | 352 | 651 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 7101875 | 7101875 | PRJNA744060_P_NODE_25166_length_324_cov_1.243028_g24837_i0 | PRJNA744060 | 25166 | 324 | 1.243028 | 4.02741072 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 599 | 8.67e-167 | NTclustered | gi|971146634|emb|LN879502.1| | 389348 | g24837 | i0 | 100 | 16.4043209876543 | 324 | 0 | 100 | 0 | 1 | 324 | 2024393 | 2024716 | Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK | blastn | 5315 | 599 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 13477273 | 13477273 | PRJNA744060_P_NODE_41451_length_259_cov_1.559140_g41122_i0 | PRJNA744060 | 41451 | 259 | 1.55914 | 4.0381726 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 479 | 9.13e-131 | NTclustered | gi|971146634|emb|LN879502.1| | 389348 | g41122 | i0 | 100 | 1.93436293436293 | 259 | 0 | 100 | 0 | 1 | 259 | 386592 | 386850 | Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK | blastn | 501 | 479 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 19850526 | 19850526 | PRJNA744060_P_NODE_44016_length_253_cov_0.866667_g43687_i0 | PRJNA744060 | 44016 | 253 | 0.866667 | 2.19266751 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 468 | 1.92e-127 | NTclustered | gi|971146634|emb|LN879502.1| | 389348 | g43687 | i0 | 100 | 1 | 253 | 0 | 100 | 0 | 1 | 253 | 1863055 | 1863307 | Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK | blastn | 253 | 468 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 23676574 | 23676574 | PRJNA744060_P_NODE_47539_length_247_cov_1.729885_g47210_i0 | PRJNA744060 | 47539 | 247 | 1.729885 | 4.27281595 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 457 | 4.05e-124 | NTclustered | gi|971146634|emb|LN879502.1| | 389348 | g47210 | i0 | 100 | 1 | 247 | 0 | 100 | 0 | 1 | 247 | 1655820 | 1655574 | Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK | blastn | 247 | 457 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 29263050 | 29263050 | PRJNA744060_P_NODE_7629_length_576_cov_3.121272_g7305_i0 | PRJNA744060 | 7629 | 576 | 3.121272 | 17.97852672 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 198 | 7.52e-58 | NR | MFT4553856.1 | 2047757 | g7305 | i0 | 57.9 | 6.61458333333333 | 159 | 67 | 82.8 | 0 | 2 | 478 | 279 | 437 | MFT4553856.1 alanine-glyoxylate transaminase/(R)-3-amino-2-methylpropionate-pyruvate transaminase [Chlamydiales bacterium] | diamond | 3810 | 198 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 29957843 | 29957843 | PRJNA744060_P_NODE_18791_length_372_cov_4.665552_g18462_i0 | PRJNA744060 | 18791 | 372 | 4.665552 | 17.35585344 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 68.6 | 1.21e-10 | NR | MFI0434572.1 | 2052176 | g18462 | i0 | 52.2 | 0.556451612903226 | 69 | 26 | 55.6 | 1 | 371 | 165 | 316 | 377 | MFI0434572.1 SET domain-containing protein-lysine N-methyltransferase [Parachlamydiaceae bacterium] | diamond | 207 | 68.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 30305958 | 30305958 | PRJNA744060_P_NODE_37792_length_270_cov_0.974619_g37463_i0 | PRJNA744060 | 37792 | 270 | 0.974619 | 2.6314713 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 43.5 | 0.0279 | NR | MCI0381953.1 | 2081524 | g37463 | i0 | 45.7 | 1.04444444444444 | 46 | 25 | 51.1 | 0 | 140 | 3 | 596 | 641 | MCI0381953.1 tetratricopeptide repeat protein [Chlamydiota bacterium] | diamond | 282 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 31158205 | 31158205 | PRJNA744060_P_NODE_52335_length_237_cov_3.182927_g52006_i0 | PRJNA744060 | 52335 | 237 | 3.182927 | 7.54353699 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 50.4 | 6.26e-5 | NR | MFI0434572.1 | 2052176 | g52006 | i0 | 35.6 | 0.924050632911392 | 73 | 34 | 75.9 | 1 | 57 | 236 | 19 | 91 | MFI0434572.1 SET domain-containing protein-lysine N-methyltransferase [Parachlamydiaceae bacterium] | diamond | 219 | 50.4 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 31474922 | 31474922 | PRJNA744060_P_NODE_45996_length_250_cov_0.881356_g45667_i0 | PRJNA744060 | 45996 | 250 | 0.881356 | 2.20339 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 126 | 6.16e-33 | NR | HSX12653.1 | 2047756 | g45667 | i0 | 77.8 | 1.968 | 81 | 18 | 97.2 | 0 | 250 | 8 | 99 | 179 | HSX12653.1 ribose-phosphate pyrophosphokinase [Rhabdochlamydiaceae bacterium] | diamond | 492 | 126 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae 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);;