contig_metadata
9 rows where analysis = "diamond", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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);;