contig_metadata
9 rows where bioproject = "PRJEB66218", tax_kingdom = "Bacillati" and tax_phylum = "Mycoplasmatota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1407375 | 1407375 | PRJEB66218_P_NODE_242142_length_201_cov_4.642857_g239711_i0 | PRJEB66218 | 242142 | 201 | 4.642857 | 9.33214257 | Candidatus Hepatoplasma vulgare | 3132032 | Bacteria | Bacteria | 82.4 | 2.23e-11 | NTclustered | gi|2416256354|dbj|AP027131.1| | 3132032 | g239711 | i0 | 88.406 | 3.54726368159204 | 69 | 6 | 34 | 2 | 10 | 77 | 478404 | 478471 | MAG: Candidatus Hepatoplasma vulgare Av-JP DNA, complete genome | blastn | 713 | 82.4 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Mycoplasmatales | Candidatus Hepatoplasmataceae | Candidatus Hepatoplasma | Candidatus Hepatoplasma vulgare | ||
| 2270269 | 2270269 | PRJEB66218_P_NODE_76422_length_363_cov_11.937086_g73996_i0 | PRJEB66218 | 76422 | 363 | 11.937086 | 43.33162218 | Mycoplasma | 2093 | Bacteria | Bacteria | 67.6 | 1.23e-6 | NTclustered | gi|2294785939|gb|CP103424.1| | 51364 | g73996 | i0 | 97.5 | 10.5730027548209 | 40 | 0 | 11 | 1 | 4 | 42 | 73047 | 73086 | Mycoplasma cottewii strain VIS chromosome, complete genome | blastn | 3838 | 67.6 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Mycoplasmatales | Mycoplasmataceae | Mycoplasma | Mycoplasma cottewii | ||
| 15433453 | 15433453 | PRJEB66218_P_NODE_132133_length_259_cov_2.373737_g129704_i0 | PRJEB66218 | 132133 | 259 | 2.373737 | 6.14797883 | Spiroplasma endosymbiont of Melieria omissa | 3139324 | Bacteria | Bacteria | 54.7 | 0.007 | NTclustered | gi|2719904899|emb|OZ035012.1| | 3139324 | g129704 | i0 | 100 | 0.22007722007722 | 29 | 0 | 11 | 0 | 57 | 85 | 1304158 | 1304130 | Spiroplasma endosymbiont of Melieria omissa isolate 7b93cfef-5182-4d29-b531-169777273f43 genome assembly, chromosome: 1 | blastn | 57 | 54.7 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Entomoplasmatales | Spiroplasmataceae | Spiroplasma | Spiroplasma endosymbiont of Melieria omissa | ||
| 21807516 | 21807516 | PRJEB66218_P_NODE_120558_length_274_cov_1.384977_g118129_i0 | PRJEB66218 | 120558 | 274 | 1.384977 | 3.79483698 | Mesomycoplasma ovipneumoniae | 29562 | Bacteria | Bacteria | 52.8 | 0.025 | NTclustered | gi|2582038664|gb|CP134944.1| | 29562 | g118129 | i0 | 100 | 0.102189781021898 | 28 | 0 | 10 | 0 | 176 | 203 | 642778 | 642805 | Mesomycoplasma ovipneumoniae strain MoS3261N22A chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Metamycoplasmataceae | Mesomycoplasma | Mesomycoplasma ovipneumoniae | |||
| 24360573 | 24360573 | PRJEB66218_P_NODE_96060_length_314_cov_1.841897_g93632_i0 | PRJEB66218 | 96060 | 314 | 1.841897 | 5.78355658 | Candidatus Tyloplasma litorale | 3132031 | Bacteria | Bacteria | 52.8 | 0.029 | NTclustered | gi|2413215879|dbj|AP027078.1| | 3132031 | g93632 | i0 | 100 | 0.089171974522293 | 28 | 0 | 9 | 0 | 58 | 85 | 209769 | 209742 | MAG: Candidatus Tyloplasma litorale Fukuoka2020 DNA, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Mycoplasmatales | Candidatus Hepatoplasmataceae | Candidatus Tyloplasma | Candidatus Tyloplasma litorale | ||
| 28486896 | 28486896 | PRJEB66218_P_NODE_241167_length_202_cov_0.921986_g238736_i0 | PRJEB66218 | 241167 | 202 | 0.921986 | 1.86241172 | Acholeplasma granularum | 264635 | Bacteria | Bacteria | 54.7 | 1.19e-6 | NR | WP_025725131.1 | 264635 | g238736 | i0 | 51.1 | 0.698019801980198 | 47 | 23 | 69.8 | 0 | 143 | 3 | 233 | 279 | WP_025725131.1 ribosome small subunit-dependent GTPase A [Acholeplasma granularum] | diamond | 141 | 54.7 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Acholeplasmatales | Acholeplasmataceae | Acholeplasma | Acholeplasma granularum | ||
| 30287133 | 30287133 | PRJEB66218_P_NODE_116092_length_280_cov_1.794521_g113663_i0 | PRJEB66218 | 116092 | 280 | 1.794521 | 5.0246588 | Acholeplasmatales bacterium | 2053494 | Bacteria | Bacteria | 84.7 | 4.47e-17 | NR | MBR4496985.1 | 2053494 | g113663 | i0 | 46.6 | 3.71785714285714 | 88 | 45 | 92.1 | 1 | 258 | 1 | 139 | 226 | MBR4496985.1 annexin [Acholeplasmatales bacterium] | diamond | 1041 | 84.7 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Acholeplasmatales | Acholeplasmatales bacterium | ||||
| 31993783 | 31993783 | PRJEB66218_P_NODE_133218_length_258_cov_1.700508_g130789_i0 | PRJEB66218 | 133218 | 258 | 1.700508 | 4.38731064 | Mollicutes bacterium | 37628 | Bacteria | Bacteria | 46.6 | 0.00105 | NR | NLL44599.1 | 37628 | g130789 | i0 | 42.1 | 1.55813953488372 | 76 | 43 | 87.2 | 1 | 29 | 253 | 2 | 77 | NLL44599.1 translation initiation factor IF-3 [Mollicutes bacterium] | diamond | 402 | 46.6 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Mollicutes bacterium | |||||
| 32500326 | 32500326 | PRJEB66218_P_NODE_213059_length_208_cov_0.884354_g210629_i0 | PRJEB66218 | 213059 | 208 | 0.884354 | 1.83945632 | Mycoplasmatota bacterium | 2231116 | Bacteria | Bacteria | 42 | 0.0464 | NR | QWB99420.1 | 2231116 | g210629 | i0 | 35.2 | 1.02403846153846 | 71 | 42 | 98.1 | 2 | 207 | 4 | 122 | 191 | QWB99420.1 DUF5011 domain-containing protein [Mycoplasmatota bacterium] | diamond | 213 | 42 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmatota 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);;