contig_metadata
11 rows where bioproject = "PRJNA1197996" and tax_phylum = "Myxococcota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1598575 | 1598575 | PRJNA1197996_S_NODE_17262_length_281_cov_1.062500_g17208_i0 | PRJNA1197996 | 17262 | 281 | 1.0625 | 2.985625 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 274 | 5.08e-69 | NTclustered | gi|2258824976|gb|CP060221.1| | 2026763 | g17208 | i0 | 85.496 | 237.177935943061 | 262 | 38 | 93 | 0 | 1 | 262 | 1313248 | 1313509 | MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome | blastn | 66647 | 274 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 5427018 | 5427018 | PRJNA1197996_S_NODE_12905_length_308_cov_1.940426_g12851_i0 | PRJNA1197996 | 12905 | 308 | 1.940426 | 5.97651208 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 366 | 9.039999999999999e-97 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g12851 | i0 | 88.179 | 114.805194805195 | 313 | 29 | 100 | 6 | 1 | 308 | 3943010 | 3943319 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 35360 | 366 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 22001016 | 22001016 | PRJNA1197996_S_NODE_5278_length_407_cov_1.529940_g5224_i0 | PRJNA1197996 | 5278 | 407 | 1.52994 | 6.2268558 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 582 | 1.1199999999999999e-161 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g5224 | i0 | 92.982 | 132.724815724816 | 399 | 28 | 98 | 0 | 9 | 407 | 3942500 | 3942102 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 54019 | 582 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 26660717 | 26660717 | PRJNA1197996_S_NODE_1821_length_577_cov_16.678571_g1772_i0 | PRJNA1197996 | 1821 | 577 | 16.678571 | 96.23535467 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 66.6 | 1.06e-9 | NR | MCB9637778.1 | 2026763 | g1772 | i0 | 37.8 | 0.426343154246101 | 82 | 46 | 41.1 | 2 | 47 | 283 | 4 | 83 | MCB9637778.1 hypothetical protein [Myxococcales bacterium] | diamond | 246 | 66.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27799242 | 27799242 | PRJNA1197996_S_NODE_24244_length_249_cov_1.903409_g24190_i0 | PRJNA1197996 | 24244 | 249 | 1.903409 | 4.73948841 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 42.7 | 0.041 | NR | MFO0749967.1 | 2818507 | g24190 | i0 | 37 | 0.650602409638554 | 54 | 30 | 65.1 | 1 | 44 | 205 | 1920 | 1969 | MFO0749967.1 hypothetical protein [Myxococcota bacterium] | diamond | 162 | 42.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 28430648 | 28430648 | PRJNA1197996_S_NODE_2306_length_532_cov_17.845316_g2255_i0 | PRJNA1197996 | 2306 | 532 | 17.845316 | 94.93708112 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 53.9 | 7.38e-5 | NR | MFN7698658.1 | 2026735 | g2255 | i0 | 42.9 | 0.473684210526316 | 42 | 24 | 23.7 | 0 | 1 | 126 | 58 | 99 | MFN7698658.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 252 | 53.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28588593 | 28588593 | PRJNA1197996_S_NODE_2767_length_501_cov_9.126168_g2715_i0 | PRJNA1197996 | 2767 | 501 | 9.126168 | 45.72210168 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 49.7 | 0.00191 | NR | TNE50471.1 | 2026735 | g2715 | i0 | 40 | 0.754491017964072 | 60 | 34 | 35.9 | 1 | 483 | 304 | 31 | 88 | TNE50471.1 MAG: hypothetical protein EP343_08380 [Deltaproteobacteria bacterium] | diamond | 378 | 49.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28999237 | 28999237 | PRJNA1197996_S_NODE_3368_length_470_cov_7.546599_g3314_i0 | PRJNA1197996 | 3368 | 470 | 7.546599 | 35.4690153 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 49.7 | 0.00146 | NR | TNE50471.1 | 2026735 | g3314 | i0 | 40 | 0.804255319148936 | 60 | 34 | 38.3 | 1 | 452 | 273 | 31 | 88 | TNE50471.1 MAG: hypothetical protein EP343_08380 [Deltaproteobacteria bacterium] | diamond | 378 | 49.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29409264 | 29409264 | PRJNA1197996_S_NODE_1689_length_592_cov_106.034682_g1641_i0 | PRJNA1197996 | 1689 | 592 | 106.034682 | 627.72531744 | Nannocystaceae bacterium | 2545255 | Bacteria | Bacteria | 107 | 2.44e-26 | NR | MEX1363673.1 | 2545255 | g1641 | i0 | 51 | 0.993243243243243 | 96 | 45 | 48.1 | 2 | 501 | 217 | 1 | 95 | MEX1363673.1 calcium-binding EGF-like domain-containing protein [Nannocystaceae bacterium] | diamond | 588 | 107 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystaceae bacterium | ||||
| 29724791 | 29724791 | PRJNA1197996_S_NODE_1070_length_697_cov_22.966346_g1027_i0 | PRJNA1197996 | 1070 | 697 | 22.966346 | 160.07543162 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 57.8 | 5.27e-6 | NR | MCA9711701.1 | 2026763 | g1027 | i0 | 31.8 | 0.378766140602583 | 88 | 58 | 37.9 | 2 | 114 | 377 | 156 | 241 | MCA9711701.1 hypothetical protein [Myxococcales bacterium] | diamond | 264 | 57.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30262346 | 30262346 | PRJNA1197996_S_NODE_12112_length_314_cov_3.929461_g12058_i0 | PRJNA1197996 | 12112 | 314 | 3.929461 | 12.33850754 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 48.9 | 5.71e-4 | NR | MBN2493263.1 | 2026735 | g12058 | i0 | 52.5 | 0.754777070063694 | 40 | 17 | 38.2 | 1 | 35 | 154 | 453 | 490 | MBN2493263.1 metallophosphoesterase [Deltaproteobacteria bacterium] | diamond | 237 | 48.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria 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);;