contig_metadata
4 rows where analysis = "diamond", bioproject = "PRJNA278119" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28337402 | 28337402 | PRJNA278119_P_NODE_38526_length_167_cov_0.881356_g38277_i0 | PRJNA278119 | 38526 | 167 | 0.881356 | 1.47186452 | Chlamydia sp. 32-24 | 1895742 | Bacteria | Bacteria | 72.8 | 2.64e-13 | NR | OJU81359.1 | 1895742 | g38277 | i0 | 100 | 0.610778443113772 | 34 | 0 | 61.1 | 0 | 166 | 65 | 323 | 356 | OJU81359.1 MAG: hypothetical protein BGO10_07015 [Chlamydia sp. 32-24] | diamond | 102 | 72.8 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia sp. 32-24 | |
| 31211033 | 31211033 | PRJNA278119_P_NODE_1895_length_897_cov_3.831368_g1697_i0 | PRJNA278119 | 1895 | 897 | 3.831368 | 34.36737096 | Chlamydiales bacterium STE3 | 1910938 | Bacteria | Bacteria | 110 | 8.289999999999999e-23 | NR | KAF3362306.1 | 1910938 | g1697 | i0 | 35.9 | 2.35117056856187 | 167 | 94 | 53.2 | 6 | 869 | 393 | 561 | 722 | KAF3362306.1 hypothetical protein PHSC3_001135 [Chlamydiales bacterium STE3] | diamond | 2109 | 110 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium STE3 | |||
| 31401498 | 31401498 | PRJNA278119_P_NODE_16016_length_266_cov_0.917051_g15767_i0 | PRJNA278119 | 16016 | 266 | 0.917051 | 2.43935566 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 60.5 | 2.79e-8 | NR | MBA3721977.1 | 2052176 | g15767 | i0 | 43.6 | 0.879699248120301 | 78 | 42 | 85.7 | 1 | 1 | 228 | 311 | 388 | MBA3721977.1 DUF4116 domain-containing protein [Parachlamydiaceae bacterium] | diamond | 234 | 60.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 32508853 | 32508853 | PRJNA278119_P_NODE_42079_length_165_cov_0.896552_g41830_i0 | PRJNA278119 | 42079 | 165 | 0.896552 | 1.4793108 | Candidatus Protochlamydia sp. | 2687294 | Bacteria | Bacteria | 77 | 1.63e-16 | NR | MBA2368373.1 | 2687294 | g41830 | i0 | 71.7 | 1.67272727272727 | 46 | 13 | 83.6 | 0 | 28 | 165 | 1 | 46 | MBA2368373.1 type II toxin-antitoxin system PemK/MazF family toxin [Candidatus Protochlamydia sp.] | diamond | 276 | 77 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia sp. |
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);;