contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA839281" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3380352 | 3380352 | PRJNA839281_S_NODE_14263_length_213_cov_1.554878_g13994_i0 | PRJNA839281 | 14263 | 213 | 1.554878 | 3.31189014 | Neorhodopirellula lusitana | 445327 | Bacteria | Bacteria | 103 | 1.11e-24 | NR | WP_404308400.1 | 445327 | g13994 | i0 | 64.8 | 1 | 71 | 24 | 98.6 | 1 | 4 | 213 | 106 | 176 | WP_404308400.1 NADPH-dependent aldehyde reductase Ahr [Neorhodopirellula lusitana] | diamond | 213 | 103 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Neorhodopirellula | Neorhodopirellula lusitana | |
| 4658175 | 4658175 | PRJNA839281_S_NODE_30824_length_165_cov_0.879310_g30555_i0 | PRJNA839281 | 30824 | 165 | 0.87931 | 1.4508615 | Tautonia marina | 2653855 | Bacteria | Bacteria | 103 | 3.66e-24 | NR | WP_201750339.1 | 2653855 | g30555 | i0 | 92.7 | 1 | 55 | 4 | 100 | 0 | 1 | 165 | 249 | 303 | WP_201750339.1 efflux RND transporter permease subunit [Tautonia marina] | diamond | 165 | 103 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Tautonia | Tautonia marina | |
| 26706217 | 26706217 | PRJNA839281_S_NODE_15361_length_207_cov_0.962025_g15092_i0 | PRJNA839281 | 15361 | 207 | 0.962025 | 1.99139175 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 64.7 | 3.46e-11 | NR | MBM4055472.1 | 2026780 | g15092 | i0 | 54.5 | 4.89855072463768 | 55 | 25 | 79.7 | 0 | 9 | 173 | 45 | 99 | MBM4055472.1 hemin receptor [Planctomycetota bacterium] | diamond | 1014 | 64.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 27884393 | 27884393 | PRJNA839281_S_NODE_8025_length_282_cov_1.901288_g7756_i0 | PRJNA839281 | 8025 | 282 | 1.901288 | 5.36163216 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 134 | 5.079999999999998e-35 | NR | NUQ35036.1 | 2026779 | g7756 | i0 | 78.3 | 12.3617021276596 | 83 | 18 | 88.3 | 0 | 282 | 34 | 399 | 481 | NUQ35036.1 adenosylhomocysteinase [Planctomycetaceae bacterium] | diamond | 3486 | 135 | 0.992592592592593 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 30063033 | 30063033 | PRJNA839281_S_NODE_33431_length_163_cov_0.894737_g33162_i0 | PRJNA839281 | 33431 | 163 | 0.894737 | 1.45842131 | Planctomycetia | 203683 | Bacteria | Bacteria | 77.4 | 3.1e-15 | NR | TVS19381.1 | 2026779 | g33162 | i0 | 57.4 | 6.95705521472393 | 54 | 23 | 99.4 | 0 | 163 | 2 | 83 | 136 | TVS19381.1 MAG: dihydroorotate dehydrogenase electron transfer subunit [Planctomycetaceae bacterium] | diamond | 1134 | 77.8 | 0.994858611825193 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 30528546 | 30528546 | PRJNA839281_S_NODE_16333_length_202_cov_0.993464_g16064_i0 | PRJNA839281 | 16333 | 202 | 0.993464 | 2.00679728 | Phycisphaerae bacterium | 2026778 | Bacteria | Bacteria | 45.4 | 0.00243 | NR | MBW7905979.1 | 2026778 | g16064 | i0 | 39.6 | 1.42574257425743 | 48 | 29 | 71.3 | 0 | 199 | 56 | 83 | 130 | MBW7905979.1 alpha/beta fold hydrolase [Phycisphaerae bacterium] | diamond | 288 | 45.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerae bacterium | ||||
| 31413548 | 31413548 | PRJNA839281_S_NODE_9456_length_258_cov_1.655502_g9187_i0 | PRJNA839281 | 9456 | 258 | 1.655502 | 4.27119516 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 130 | 1.8899999999999998e-34 | NR | MBK7404499.1 | 2052180 | g9187 | i0 | 67.1 | 2.95348837209302 | 85 | 28 | 98.8 | 0 | 257 | 3 | 35 | 119 | MBK7404499.1 NAD(P)-dependent alcohol dehydrogenase [Phycisphaerales bacterium] | diamond | 762 | 130 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 32552728 | 32552728 | PRJNA839281_S_NODE_26319_length_167_cov_1.296610_g26050_i0 | PRJNA839281 | 26319 | 167 | 1.29661 | 2.1653387 | Singulisphaera sp. | 1906241 | Bacteria | Bacteria | 44.3 | 0.00378 | NR | MEJ7637766.1 | 1906241 | g26050 | i0 | 52.5 | 0.718562874251497 | 40 | 18 | 71.9 | 1 | 126 | 7 | 147 | 185 | MEJ7637766.1 sigma factor [Singulisphaera sp.] | diamond | 120 | 44.3 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Isosphaerales | Isosphaeraceae | Singulisphaera | Singulisphaera 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);;