contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA744060" 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 |
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);;