contig_metadata
14 rows where bioproject = "PRJNA784298" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2041218 | 2041218 | PRJNA784298_P_NODE_18342_length_289_cov_1.425926_g18141_i0 | PRJNA784298 | 18342 | 289 | 1.425926 | 4.12092614 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 381 | 2.9999999999999997e-101 | NTclustered | gi|2698055994|gb|CP089982.1| | 2905690 | g18141 | i0 | 90.592 | 133.076124567474 | 287 | 27 | 99 | 0 | 1 | 287 | 7408471 | 7408185 | Pendulispora brunnea strain MSr12523 chromosome, complete genome | blastn | 38459 | 381 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 5868896 | 5868896 | PRJNA784298_P_NODE_25745_length_244_cov_1.660819_g25544_i0 | PRJNA784298 | 25745 | 244 | 1.660819 | 4.05239836 | Stigmatella aurantiaca | 41 | Bacteria | Bacteria | 261 | 3.36e-65 | NTclustered | gi|2244675|emb|X87291.1| | 41 | g25544 | i0 | 90.05 | 222.987704918033 | 201 | 20 | 82 | 0 | 35 | 235 | 358 | 558 | S.aurantiaca 23S rRNA gene | blastn | 54409 | 261 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Stigmatella | Stigmatella aurantiaca | ||
| 10969384 | 10969384 | PRJNA784298_P_NODE_13809_length_336_cov_1.437262_g13608_i0 | PRJNA784298 | 13809 | 336 | 1.437262 | 4.82920032 | Cystobacter fuscus | 43 | Bacteria | Bacteria | 562 | 1.18e-155 | NTclustered | gi|2579665545|gb|CP043492.1| | 43 | g13608 | i0 | 97.015 | 256.77380952381 | 335 | 9 | 99 | 1 | 1 | 335 | 452035 | 452368 | Cystobacter fuscus strain Cbf 8 chromosome, complete genome | blastn | 86276 | 562 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Cystobacter | Cystobacter fuscus | ||
| 19892295 | 19892295 | PRJNA784298_P_NODE_6656_length_491_cov_1.863636_g6456_i0 | PRJNA784298 | 6656 | 491 | 1.863636 | 9.15045276 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 761 | 0 | NTclustered | gi|2698055994|gb|CP089982.1| | 2905690 | g6456 | i0 | 95.041 | 154.452138492872 | 484 | 24 | 99 | 0 | 8 | 491 | 7408838 | 7408355 | Pendulispora brunnea strain MSr12523 chromosome, complete genome | blastn | 75836 | 761 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 21167899 | 21167899 | PRJNA784298_P_NODE_23497_length_252_cov_1.290503_g23296_i0 | PRJNA784298 | 23497 | 252 | 1.290503 | 3.25206756 | Cystobacter fuscus | 43 | Bacteria | Bacteria | 296 | 9.56e-76 | NTclustered | gi|2579656172|gb|CP043491.1| | 43 | g23296 | i0 | 92.344 | 118.289682539683 | 209 | 15 | 83 | 1 | 45 | 252 | 396075 | 396283 | Cystobacter fuscus strain Cbf 10 chromosome, complete genome | blastn | 29809 | 296 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Cystobacter | Cystobacter fuscus | ||
| 27274927 | 27274927 | PRJNA784298_P_NODE_19843_length_277_cov_2.264706_g19642_i0 | PRJNA784298 | 19843 | 277 | 2.264706 | 6.27323562 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 47.8 | 2.29e-4 | NR | MEZ4411320.1 | 3034171 | g19642 | i0 | 53.3 | 1.31046931407942 | 45 | 21 | 48.7 | 0 | 5 | 139 | 23 | 67 | MEZ4411320.1 type IV pili twitching motility protein PilT [Polyangiales bacterium] | diamond | 363 | 47.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 27748891 | 27748891 | PRJNA784298_P_NODE_7824_length_450_cov_2.538462_g7623_i0 | PRJNA784298 | 7824 | 450 | 2.538462 | 11.423079 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 64.7 | 6.87e-9 | NR | TNF00116.1 | 2026735 | g7623 | i0 | 66 | 0.626666666666667 | 47 | 16 | 31.3 | 0 | 2 | 142 | 248 | 294 | TNF00116.1 MAG: hypothetical protein EP326_06965, partial [Deltaproteobacteria bacterium] | diamond | 282 | 64.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28443447 | 28443447 | PRJNA784298_P_NODE_2826_length_759_cov_3.548105_g2640_i0 | PRJNA784298 | 2826 | 759 | 3.548105 | 26.93011695 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 179 | 9.179999999999999e-48 | NR | MBL4818683.1 | 2026735 | g2640 | i0 | 47.8 | 0.968379446640316 | 245 | 122 | 95.3 | 4 | 757 | 35 | 269 | 511 | MBL4818683.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 735 | 179 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28948672 | 28948672 | PRJNA784298_P_NODE_4548_length_597_cov_2.045802_g4350_i0 | PRJNA784298 | 4548 | 597 | 2.045802 | 12.21343794 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 62 | 1.63e-7 | NR | MCX5855004.1 | 2026735 | g4350 | i0 | 38.6 | 0.442211055276382 | 88 | 50 | 42.2 | 1 | 321 | 572 | 144 | 231 | MCX5855004.1 sensor domain-containing diguanylate cyclase [Deltaproteobacteria bacterium] | diamond | 264 | 62 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29358965 | 29358965 | PRJNA784298_P_NODE_4869_length_576_cov_2.805169_g4670_i0 | PRJNA784298 | 4869 | 576 | 2.805169 | 16.15777344 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 109 | 7.97e-24 | NR | MBL4818683.1 | 2026735 | g4670 | i0 | 43.8 | 1.01041666666667 | 194 | 106 | 100 | 2 | 576 | 1 | 526 | 718 | MBL4818683.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 582 | 109 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29390596 | 29390596 | PRJNA784298_P_NODE_18649_length_286_cov_2.854460_g18448_i0 | PRJNA784298 | 18649 | 286 | 2.85446 | 8.1637556 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 81.3 | 4.72e-17 | NR | RLC14517.1 | 2026735 | g18448 | i0 | 54 | 0.660839160839161 | 63 | 29 | 66.1 | 0 | 285 | 97 | 84 | 146 | RLC14517.1 MAG: hypothetical protein DRI24_13345 [Deltaproteobacteria bacterium] | diamond | 189 | 81.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30053470 | 30053470 | PRJNA784298_P_NODE_13171_length_344_cov_2.070111_g12970_i0 | PRJNA784298 | 13171 | 344 | 2.070111 | 7.12118184 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 72.4 | 4.27e-12 | NR | MCL5885335.1 | 2026735 | g12970 | i0 | 67.2 | 0.505813953488372 | 58 | 19 | 50.6 | 0 | 171 | 344 | 1 | 58 | MCL5885335.1 hemolysin family protein [Deltaproteobacteria bacterium] | diamond | 174 | 72.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30653823 | 30653823 | PRJNA784298_P_NODE_9573_length_406_cov_3.651652_g9372_i0 | PRJNA784298 | 9573 | 406 | 3.651652 | 14.82570712 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 44.7 | 0.0319 | NR | MBW2643474.1 | 2026735 | g9372 | i0 | 26.6 | 0.694581280788177 | 94 | 61 | 63.5 | 2 | 316 | 59 | 135 | 228 | MBW2643474.1 sugar phosphate isomerase/epimerase [Deltaproteobacteria bacterium] | diamond | 282 | 44.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32203351 | 32203351 | PRJNA784298_P_NODE_20538_length_272_cov_1.658291_g20337_i0 | PRJNA784298 | 20538 | 272 | 1.658291 | 4.51055152 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 46.2 | 0.00291 | NR | HTU57712.1 | 3034171 | g20337 | i0 | 95.5 | 0.242647058823529 | 22 | 1 | 24.3 | 0 | 206 | 271 | 1 | 22 | HTU57712.1 oxygenase MpaB family protein [Polyangiales bacterium] | diamond | 66 | 46.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales 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);;