contig_metadata
13 rows where bioproject = "PRJNA1010780", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26591063 | 26591063 | PRJNA1010780_S_NODE_12461_length_643_cov_2.791118_g11368_i0 | PRJNA1010780 | 12461 | 643 | 2.791118 | 17.94688874 | Criblamydia sequanensis | 340071 | Bacteria | Bacteria | 110 | 4.97e-25 | NR | WP_053332028.1 | 340071 | g11368 | i0 | 38.6 | 3.14463452566096 | 171 | 90 | 76 | 7 | 634 | 146 | 177 | 340 | WP_053332028.1 tRNA (adenosine(37)-N6)-dimethylallyltransferase MiaA [Criblamydia sequanensis] | diamond | 2022 | 110 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Criblamydiaceae | Candidatus Criblamydia | Candidatus Criblamydia sequanensis | |
| 27287482 | 27287482 | PRJNA1010780_S_NODE_3963_length_1357_cov_19.229198_g3569_i0 | PRJNA1010780 | 3963 | 1357 | 19.229198 | 260.94021686 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 132 | 1.44e-31 | NR | MBM3207451.1 | 2081524 | g3569 | i0 | 29.8 | 2.80545320560059 | 258 | 174 | 56.6 | 5 | 131 | 898 | 15 | 267 | MBM3207451.1 hypothetical protein [Chlamydiota bacterium] | diamond | 3807 | 132 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 27382332 | 27382332 | PRJNA1010780_S_NODE_13443_length_600_cov_5.003540_g12297_i0 | PRJNA1010780 | 13443 | 600 | 5.00354 | 30.02124 | Chlamydiia bacterium | 2052156 | Bacteria | Bacteria | 111 | 8.759999999999999e-25 | NR | MCB1080710.1 | 2052156 | g12297 | i0 | 38 | 0.92 | 184 | 104 | 88 | 5 | 587 | 60 | 18 | 199 | MCB1080710.1 GNAT family N-acetyltransferase [Chlamydiia bacterium] | diamond | 552 | 111 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiia bacterium | ||||
| 27698404 | 27698404 | PRJNA1010780_S_NODE_30464_length_261_cov_2.300885_g29175_i0 | PRJNA1010780 | 30464 | 261 | 2.300885 | 6.00530985 | Simkania sp. | 34094 | Bacteria | Bacteria | 89 | 4.8e-20 | NR | MCB1068645.1 | 34094 | g29175 | i0 | 49.4 | 0.954022988505747 | 83 | 41 | 95.4 | 1 | 256 | 8 | 68 | 149 | MCB1068645.1 methylated-DNA--[protein]-cysteine S-methyltransferase [Simkania sp.] | diamond | 249 | 89 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Simkaniaceae | Simkania | Simkania sp. | |
| 27950650 | 27950650 | PRJNA1010780_S_NODE_21425_length_373_cov_2.828402_g20136_i0 | PRJNA1010780 | 21425 | 373 | 2.828402 | 10.54993946 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 63.9 | 6.44e-9 | NR | MBI1870241.1 | 2081524 | g20136 | i0 | 35.8 | 0.85254691689008 | 106 | 59 | 80.4 | 3 | 365 | 66 | 794 | 896 | MBI1870241.1 hypothetical protein [Chlamydiota bacterium] | diamond | 318 | 63.9 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 28234581 | 28234581 | PRJNA1010780_S_NODE_4226_length_1321_cov_20.125972_g3569_i1 | PRJNA1010780 | 4226 | 1321 | 20.125972 | 265.86409012 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 132 | 1.1799999999999999e-31 | NR | MBM3207451.1 | 2081524 | g3569 | i1 | 29.8 | 2.88190764572294 | 258 | 174 | 58.1 | 5 | 131 | 898 | 15 | 267 | MBM3207451.1 hypothetical protein [Chlamydiota bacterium] | diamond | 3807 | 132 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 30066083 | 30066083 | PRJNA1010780_S_NODE_24972_length_317_cov_3.372340_g23683_i0 | PRJNA1010780 | 24972 | 317 | 3.37234 | 10.6903178 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 72.8 | 1.99e-12 | NR | MBM3208169.1 | 2081524 | g23683 | i0 | 47 | 1.87381703470032 | 100 | 48 | 91.8 | 2 | 291 | 1 | 75 | 172 | MBM3208169.1 hypothetical protein [Chlamydiota bacterium] | diamond | 594 | 72.8 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 30438047 | 30438047 | PRJNA1010780_S_NODE_37013_length_220_cov_2.156757_g35724_i0 | PRJNA1010780 | 37013 | 220 | 2.156757 | 4.7448654 | root | 1 | Root_unresolved | Root_unresolved | 44.7 | 0.00571 | NR | MEC7840071.1 | 2081524 | g35724 | i0 | 47.2 | 2.60454545454545 | 53 | 26 | 69.5 | 1 | 155 | 3 | 835 | 887 | MEC7840071.1 hypothetical protein [Chlamydiota bacterium] | diamond | 573 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 30887762 | 30887762 | PRJNA1010780_S_NODE_9754_length_786_cov_3.171771_g8824_i0 | PRJNA1010780 | 9754 | 786 | 3.171771 | 24.93012006 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 195 | 1.19e-57 | NR | MEI8365875.1 | 2052176 | g8824 | i0 | 44.6 | 0.881679389312977 | 231 | 120 | 86.3 | 4 | 786 | 109 | 44 | 271 | MEI8365875.1 hypothetical protein [Parachlamydiaceae bacterium] | diamond | 693 | 195 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 30982611 | 30982611 | PRJNA1010780_S_NODE_17674_length_459_cov_2.530660_g16401_i0 | PRJNA1010780 | 17674 | 459 | 2.53066 | 11.6157294 | Parachlamydia sp. | 2052048 | Bacteria | Bacteria | 172 | 1.35e-49 | NR | MCE5317616.1 | 2052048 | g16401 | i0 | 51.6 | 3.93464052287582 | 153 | 74 | 100 | 0 | 1 | 459 | 74 | 226 | MCE5317616.1 malate dehydrogenase [Parachlamydia sp.] | diamond | 1806 | 172 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydia | Parachlamydia sp. | |
| 30982663 | 30982663 | PRJNA1010780_S_NODE_35394_length_228_cov_2.932642_g34105_i0 | PRJNA1010780 | 35394 | 228 | 2.932642 | 6.68642376 | Rhabdochlamydiaceae bacterium | 2047756 | Bacteria | Bacteria | 94.7 | 1.0100000000000002e-21 | NR | HEY2811061.1 | 2047756 | g34105 | i0 | 51.3 | 1 | 76 | 37 | 100 | 0 | 1 | 228 | 46 | 121 | HEY2811061.1 cyclase family protein [Rhabdochlamydiaceae bacterium] | diamond | 228 | 94.7 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Rhabdochlamydiaceae | Rhabdochlamydiaceae bacterium | ||
| 31266973 | 31266973 | PRJNA1010780_S_NODE_46755_length_183_cov_4.182432_g45466_i0 | PRJNA1010780 | 46755 | 183 | 4.182432 | 7.65385056 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 81.6 | 2.92e-16 | NR | HEV8052334.1 | 2052176 | g45466 | i0 | 66.7 | 1.9672131147541 | 60 | 18 | 98.4 | 1 | 181 | 2 | 13 | 70 | HEV8052334.1 L-serine ammonia-lyase [Parachlamydiaceae bacterium] | diamond | 360 | 81.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 31867754 | 31867754 | PRJNA1010780_S_NODE_37017_length_220_cov_2.124324_g35728_i0 | PRJNA1010780 | 37017 | 220 | 2.124324 | 4.6735128 | Chlamydia serpentis | 1967782 | Bacteria | Bacteria | 81.6 | 4.25e-16 | NR | WP_108896745.1 | 1967782 | g35728 | i0 | 50 | 2.78181818181818 | 70 | 35 | 95.5 | 0 | 4 | 213 | 271 | 340 | WP_108896745.1 phosphoglycerate kinase [Chlamydia serpentis] | diamond | 612 | 81.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia serpentis |
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);;