contig_metadata
11 rows where bioproject = "PRJNA879221" and tax_phylum = "Planctomycetota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8510121 | 8510121 | PRJNA879221_P_NODE_54727_length_246_cov_0.890173_g54587_i0 | PRJNA879221 | 54727 | 246 | 0.890173 | 2.18982558 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 72.4 | 1.27e-12 | NR | MCA9286879.1 | 2052180 | g54587 | i0 | 52.6 | 2.8780487804878 | 76 | 34 | 90.2 | 1 | 23 | 244 | 316 | 391 | MCA9286879.1 DUF418 domain-containing protein [Phycisphaerales bacterium] | diamond | 708 | 72.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 11060662 | 11060662 | PRJNA879221_P_NODE_38509_length_281_cov_1.360577_g38369_i0 | PRJNA879221 | 38509 | 281 | 1.360577 | 3.82322137 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 150 | 1.22e-41 | NR | MFO0966402.1 | 2052164 | g38369 | i0 | 89.4 | 2.71174377224199 | 85 | 9 | 90.7 | 0 | 1 | 255 | 86 | 170 | MFO0966402.1 FAD-binding protein [Gemmataceae bacterium] | diamond | 762 | 150 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 12336406 | 12336406 | PRJNA879221_P_NODE_61870_length_242_cov_0.911243_g61730_i0 | PRJNA879221 | 61870 | 242 | 0.911243 | 2.20520806 | Aquisphaera giovannonii | 406548 | Bacteria | Bacteria | 150 | 7.509999999999998e-32 | NTclustered | gi|1730068067|gb|CP042997.1| | 406548 | g61730 | i0 | 85.616 | 0.603305785123967 | 146 | 17 | 60 | 4 | 99 | 242 | 2984225 | 2984082 | Aquisphaera giovannonii strain OJF2 chromosome, complete genome | blastn | 146 | 150 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Aquisphaera | Aquisphaera giovannonii | |
| 25083419 | 25083419 | PRJNA879221_P_NODE_6920_length_709_cov_8.594340_g6789_i0 | PRJNA879221 | 6920 | 709 | 8.59434 | 60.9338706 | Pirellulaceae bacterium | 2699754 | Bacteria | Bacteria | 201 | 2.0399999999999997e-57 | NR | MDX1947833.1 | 2699754 | g6789 | i0 | 60.7 | 0.634696755994358 | 150 | 59 | 63.5 | 0 | 689 | 240 | 208 | 357 | MDX1947833.1 DUF3386 family protein [Pirellulaceae bacterium] | diamond | 450 | 201 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Pirellulaceae bacterium | ||
| 29116104 | 29116104 | PRJNA879221_P_NODE_48788_length_250_cov_0.870056_g48648_i0 | PRJNA879221 | 48788 | 250 | 0.870056 | 2.17514 | Pirellulales | 2691354 | Bacteria | Bacteria | 132 | 5.49e-35 | NR | MBA4106052.1 | 117 | g48648 | i0 | 79.3 | 1.968 | 82 | 17 | 98.4 | 0 | 246 | 1 | 176 | 257 | MBA4106052.1 hypothetical protein [Pirellula sp.] | diamond | 492 | 132 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Pirellula | Pirellula sp. | |
| 29549784 | 29549784 | PRJNA879221_P_NODE_37630_length_285_cov_1.283019_g37490_i0 | PRJNA879221 | 37630 | 285 | 1.283019 | 3.65660415 | Planctomycetaceae bacterium | 2026779 | Bacteria | Bacteria | 139 | 7.65e-36 | NR | MBX3452621.1 | 2026779 | g37490 | i0 | 77.9 | 1 | 95 | 21 | 100 | 0 | 1 | 285 | 1211 | 1305 | MBX3452621.1 autotransporter domain-containing protein [Planctomycetaceae bacterium] | diamond | 285 | 139 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 29897433 | 29897433 | PRJNA879221_P_NODE_52891_length_247_cov_0.885057_g52751_i0 | PRJNA879221 | 52891 | 247 | 0.885057 | 2.18609079 | Phycisphaeraceae bacterium | 2026777 | Bacteria | Bacteria | 76.3 | 6.14e-14 | NR | MCC7191929.1 | 2026777 | g52751 | i0 | 60.9 | 0.777327935222672 | 64 | 24 | 76.5 | 1 | 190 | 2 | 11 | 74 | MCC7191929.1 iron-sulfur cluster-binding protein [Phycisphaeraceae bacterium] | diamond | 192 | 76.3 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaeraceae | Phycisphaeraceae bacterium | ||
| 31003225 | 31003225 | PRJNA879221_P_NODE_58814_length_244_cov_0.900585_g58674_i0 | PRJNA879221 | 58814 | 244 | 0.900585 | 2.1974274 | Pirellulales bacterium | 2715253 | Bacteria | Bacteria | 68.9 | 2.32e-11 | NR | HEV2970763.1 | 2715253 | g58674 | i0 | 62.1 | 0.811475409836066 | 66 | 25 | 81.1 | 0 | 199 | 2 | 1446 | 1511 | HEV2970763.1 autotransporter-associated beta strand repeat-containing protein [Pirellulales bacterium] | diamond | 198 | 68.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulales bacterium | |||
| 31319183 | 31319183 | PRJNA879221_P_NODE_58275_length_244_cov_0.900585_g58135_i0 | PRJNA879221 | 58275 | 244 | 0.900585 | 2.1974274 | Gemmata sp. | 1914242 | Bacteria | Bacteria | 71.2 | 3.47e-12 | NR | MFM8272512.1 | 1914242 | g58135 | i0 | 53.8 | 3.84836065573771 | 78 | 36 | 95.9 | 0 | 5 | 238 | 227 | 304 | MFM8272512.1 peptidylprolyl isomerase [Gemmata sp.] | diamond | 939 | 71.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmata | Gemmata sp. | |
| 32363412 | 32363412 | PRJNA879221_P_NODE_42559_length_264_cov_1.356021_g42419_i0 | PRJNA879221 | 42559 | 264 | 1.356021 | 3.57989544 | Candidatus Scalindua sediminis | 2798304 | Bacteria | Bacteria | 174 | 3.07e-52 | NR | MEE9260883.1 | 2798304 | g42419 | i0 | 94.3 | 0.988636363636364 | 87 | 5 | 98.9 | 0 | 3 | 263 | 126 | 212 | MEE9260883.1 glycosyltransferase family 2 protein [Candidatus Scalindua sediminis] | diamond | 261 | 174 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Candidatus Brocadiia | Candidatus Brocadiales | Candidatus Scalinduaceae | Candidatus Scalindua | Candidatus Scalindua sediminis | |
| 32489929 | 32489929 | PRJNA879221_P_NODE_44399_length_256_cov_2.174863_g44259_i0 | PRJNA879221 | 44399 | 256 | 2.174863 | 5.56764928 | Lacipirellulaceae bacterium | 2691534 | Bacteria | Bacteria | 99 | 1.57e-24 | NR | HEX5471700.1 | 2691534 | g44259 | i0 | 69.2 | 1.58203125 | 65 | 20 | 76.2 | 0 | 1 | 195 | 57 | 121 | HEX5471700.1 type II toxin-antitoxin system RelE/ParE family toxin [Lacipirellulaceae bacterium] | diamond | 405 | 99 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Lacipirellulaceae | Lacipirellulaceae 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);;