contig_metadata
6 rows where bioproject = "PRJNA564810" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4381629 | 4381629 | PRJNA564810_S_NODE_1924_length_341_cov_1.231884_g1902_i0 | PRJNA564810 | 1924 | 341 | 1.231884 | 4.20072444 | Bacteria | 2 | Bacteria | Bacteria | 116 | 1.08e-30 | NR | MBI3821448.1 | 2026780 | g1902 | i0 | 82.5 | 30.1407624633431 | 63 | 11 | 55.4 | 0 | 3 | 191 | 87 | 149 | MBI3821448.1 NADP-dependent phosphogluconate dehydrogenase [Planctomycetota bacterium] | diamond | 10278 | 117 | 0.991452991452991 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 21535541 | 21535541 | PRJNA564810_S_NODE_3037_length_297_cov_1.465517_g3015_i0 | PRJNA564810 | 3037 | 297 | 1.465517 | 4.35258549 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 53.1 | 1.47e-5 | NR | MEM6392893.1 | 2026780 | g3015 | i0 | 41.3 | 6.07070707070707 | 75 | 40 | 75.8 | 3 | 244 | 20 | 206 | 276 | MEM6392893.1 magnesium/cobalt transporter CorA [Planctomycetota bacterium] | diamond | 1803 | 53.5 | 0.992523364485981 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 24780419 | 24780419 | PRJNA564810_S_NODE_8560_length_202_cov_2.474453_g8538_i0 | PRJNA564810 | 8560 | 202 | 2.474453 | 4.99839506 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 52.8 | 0.018 | NTclustered | gi|2621785075|emb|OY781533.1| | 2026780 | g8538 | i0 | 100 | 0.138613861386139 | 28 | 0 | 14 | 0 | 23 | 50 | 3269720 | 3269747 | MAG: Planctomycetota bacterium isolate 5c15c3fa-c5a4-4479-8b82-14142e451f6c genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 29510730 | 29510730 | PRJNA564810_S_NODE_5290_length_248_cov_2.890710_g5268_i0 | PRJNA564810 | 5290 | 248 | 2.89071 | 7.1689608 | Urbifossiella sp. | 2807431 | Bacteria | Bacteria | 44.3 | 0.01 | NR | HYH63325.1 | 2807431 | g5268 | i0 | 52.6 | 0.459677419354839 | 38 | 18 | 46 | 0 | 7 | 120 | 187 | 224 | HYH63325.1 2OG-Fe(II) oxygenase [Urbifossiella sp.] | diamond | 114 | 44.3 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Urbifossiella | Urbifossiella sp. | |
| 31641550 | 31641550 | PRJNA564810_S_NODE_5596_length_243_cov_2.539326_g5574_i0 | PRJNA564810 | 5596 | 243 | 2.539326 | 6.17056218 | Bacteria | 2 | Bacteria | Bacteria | 51.6 | 2.7e-5 | NR | HEY2910011.1 | 2052164 | g5574 | i0 | 59 | 1.90123456790123 | 39 | 16 | 48.1 | 0 | 242 | 126 | 260 | 298 | HEY2910011.1 c-type cytochrome domain-containing protein [Gemmataceae bacterium] | diamond | 462 | 51.6 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 32482289 | 32482289 | PRJNA564810_S_NODE_3219_length_292_cov_2.603524_g3197_i0 | PRJNA564810 | 3219 | 292 | 2.603524 | 7.60229008 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 53.9 | 2.74e-6 | NR | GMV79991.1 | 2026780 | g3197 | i0 | 49 | 1.09931506849315 | 51 | 26 | 52.4 | 0 | 4 | 156 | 11 | 61 | GMV79991.1 MAG: hypothetical protein AMXMBFR7_11750 [Planctomycetota bacterium] | diamond | 321 | 53.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota 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);;