contig_metadata
19 rows where bioproject = "PRJEB75230", tax_kingdom = "Pseudomonadati" and tax_phylum = "Bdellovibrionota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 136058 | 136058 | PRJEB75230_P_NODE_132821_length_249_cov_0.875000_g132639_i0 | PRJEB75230 | 132821 | 249 | 0.875 | 2.17875 | Bacteria | 2 | Bacteria | Bacteria | 97.1 | 8.049999999999999e-23 | NR | MCB9072629.1 | 2026715 | g132639 | i0 | 64.1 | 3.10843373493976 | 64 | 23 | 77.1 | 0 | 247 | 56 | 148 | 211 | MCB9072629.1 succinate dehydrogenase cytochrome b subunit [Pseudobdellovibrionaceae bacterium] | diamond | 774 | 97.4 | 0.996919917864476 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 4823981 | 4823981 | PRJEB75230_P_NODE_173984_length_242_cov_0.911243_g173802_i0 | PRJEB75230 | 173984 | 242 | 0.911243 | 2.20520806 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 115 | 1.24e-30 | NR | MES3037699.1 | 3034175 | g173802 | i0 | 65.4 | 1.93388429752066 | 78 | 27 | 96.7 | 0 | 8 | 241 | 56 | 133 | MES3037699.1 potassium channel family protein [Bdellovibrionota bacterium] | diamond | 468 | 115 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 27034167 | 27034167 | PRJEB75230_P_NODE_125362_length_250_cov_0.870056_g125180_i0 | PRJEB75230 | 125362 | 250 | 0.870056 | 2.17514 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 98.2 | 2.25e-22 | NR | MCB0379076.1 | 2053517 | g125180 | i0 | 58 | 0.972 | 81 | 33 | 97.2 | 1 | 7 | 249 | 87 | 166 | MCB0379076.1 formimidoylglutamase [Bdellovibrionales bacterium] | diamond | 243 | 98.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27761099 | 27761099 | PRJEB75230_P_NODE_17644_length_397_cov_1.246914_g17462_i0 | PRJEB75230 | 17644 | 397 | 1.246914 | 4.95024858 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 67 | 7.12e-10 | NR | MBS1969835.1 | 2053517 | g17462 | i0 | 31.4 | 1.05793450881612 | 140 | 80 | 99.7 | 3 | 396 | 1 | 741 | 872 | MBS1969835.1 endonuclease/exonuclease/phosphatase family protein [Bdellovibrionales bacterium] | diamond | 420 | 67 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27981859 | 27981859 | PRJEB75230_P_NODE_150525_length_246_cov_0.890173_g150343_i0 | PRJEB75230 | 150525 | 246 | 0.890173 | 2.18982558 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 119 | 2.3e-31 | NR | MBA2405764.1 | 2053517 | g150343 | i0 | 71.3 | 0.975609756097561 | 80 | 23 | 97.6 | 0 | 243 | 4 | 118 | 197 | MBA2405764.1 sulfite exporter TauE/SafE family protein [Bdellovibrionales bacterium] | diamond | 240 | 119 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28044882 | 28044882 | PRJEB75230_P_NODE_133045_length_249_cov_0.875000_g132863_i0 | PRJEB75230 | 133045 | 249 | 0.875 | 2.17875 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 45.4 | 0.00358 | NR | HEY8279653.1 | 3034175 | g132863 | i0 | 41.8 | 0.662650602409639 | 55 | 30 | 66.3 | 2 | 241 | 77 | 8 | 60 | HEY8279653.1 hypothetical protein [Bdellovibrionota bacterium] | diamond | 165 | 45.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 28076413 | 28076413 | PRJEB75230_P_NODE_142605_length_247_cov_0.885057_g142423_i0 | PRJEB75230 | 142605 | 247 | 0.885057 | 2.18609079 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 125 | 2.27e-32 | NR | MBY0518024.1 | 2081706 | g142423 | i0 | 72 | 1.9919028340081 | 82 | 23 | 99.6 | 0 | 247 | 2 | 92 | 173 | MBY0518024.1 flagellar biosynthesis protein FlhB [Bacteriovoracaceae bacterium] | diamond | 492 | 125 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 28139948 | 28139948 | PRJEB75230_P_NODE_93925_length_268_cov_1.482051_g93743_i0 | PRJEB75230 | 93925 | 268 | 1.482051 | 3.97189668 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 52 | 2.67e-5 | NR | MBX2988612.1 | 2026715 | g93743 | i0 | 36.7 | 1.00746268656716 | 90 | 49 | 94 | 2 | 3 | 254 | 297 | 384 | MBX2988612.1 glycosyltransferase family 9 protein [Pseudobdellovibrionaceae bacterium] | diamond | 270 | 52 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 28297472 | 28297472 | PRJEB75230_P_NODE_65786_length_293_cov_1.159091_g65604_i0 | PRJEB75230 | 65786 | 293 | 1.159091 | 3.39613663 | Oligoflexaceae bacterium | 2957744 | Bacteria | Bacteria | 44.7 | 0.0112 | NR | MDA9951656.1 | 2957744 | g65604 | i0 | 51.3 | 0.399317406143345 | 39 | 18 | 39.9 | 1 | 230 | 114 | 192 | 229 | MDA9951656.1 SDR family NAD(P)-dependent oxidoreductase [Oligoflexaceae bacterium] | diamond | 117 | 44.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexaceae | Oligoflexaceae bacterium | |||
| 28929035 | 28929035 | PRJEB75230_P_NODE_183868_length_241_cov_0.916667_g183686_i0 | PRJEB75230 | 183868 | 241 | 0.916667 | 2.20916747 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 139 | 3.3999999999999996e-36 | NR | PZP57031.1 | 349221 | g183686 | i0 | 87.2 | 0.970954356846473 | 78 | 10 | 97.1 | 0 | 236 | 3 | 166 | 243 | PZP57031.1 MAG: ribonuclease R [Micavibrio aeruginosavorus] | diamond | 234 | 139 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 29276194 | 29276194 | PRJEB75230_P_NODE_146969_length_246_cov_1.734104_g146787_i0 | PRJEB75230 | 146969 | 246 | 1.734104 | 4.26589584 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 44.7 | 0.00842 | NR | MDY0029759.1 | 2026715 | g146787 | i0 | 32.8 | 0.817073170731707 | 67 | 45 | 81.7 | 0 | 222 | 22 | 233 | 299 | MDY0029759.1 double-strand break repair protein AddB [Pseudobdellovibrionaceae bacterium] | diamond | 201 | 44.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 29529030 | 29529030 | PRJEB75230_P_NODE_107150_length_258_cov_1.378378_g106968_i0 | PRJEB75230 | 107150 | 258 | 1.378378 | 3.5562152400000002 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 81.3 | 1.29e-15 | NR | MDX9730787.1 | 2053517 | g106968 | i0 | 56.7 | 1.04651162790698 | 90 | 32 | 96.5 | 1 | 258 | 10 | 834 | 923 | MDX9730787.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 270 | 81.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29654817 | 29654817 | PRJEB75230_P_NODE_166030_length_243_cov_1.429412_g165848_i0 | PRJEB75230 | 166030 | 243 | 1.429412 | 3.47347116 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 68.6 | 2.6e-11 | NR | MBY0314892.1 | 2053517 | g165848 | i0 | 43.8 | 0.987654320987654 | 80 | 45 | 98.8 | 0 | 240 | 1 | 148 | 227 | MBY0314892.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 240 | 68.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29869032 | 29869032 | PRJEB75230_P_NODE_3571_length_719_cov_2.003096_g3399_i0 | PRJEB75230 | 3571 | 719 | 2.003096 | 14.40226024 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 64.7 | 7.3900000000000007e-08 | NR | PIP93190.1 | 1975529 | g3399 | i0 | 35.4 | 2.94993045897079 | 127 | 66 | 50.5 | 4 | 143 | 505 | 864 | 980 | PIP93190.1 MAG: hypothetical protein COW78_16385 [Bdellovibrio sp. CG22_combo_CG10-13_8_21_14_all_39_27] | diamond | 2121 | 65.1 | 0.993855606758833 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. CG22_combo_CG10-13_8_21_14_all_39_27 | ||
| 29971024 | 29971024 | PRJEB75230_P_NODE_163091_length_244_cov_0.900585_g162909_i0 | PRJEB75230 | 163091 | 244 | 0.900585 | 2.1974274 | Bdellovibrio bacteriovorus | 959 | Bacteria | Bacteria | 61.6 | 7.36e-9 | NR | WP_061834842.1 | 959 | g162909 | i0 | 45.7 | 0.995901639344262 | 81 | 42 | 98.4 | 2 | 3 | 242 | 175 | 254 | WP_061834842.1 hypothetical protein [Bdellovibrio bacteriovorus] | diamond | 243 | 61.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 30445120 | 30445120 | PRJEB75230_P_NODE_170673_length_243_cov_0.905882_g170491_i0 | PRJEB75230 | 170673 | 243 | 0.905882 | 2.20129326 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 47 | 0.00109 | NR | MBY0313984.1 | 2053517 | g170491 | i0 | 33.8 | 0.987654320987654 | 80 | 53 | 98.8 | 0 | 242 | 3 | 154 | 233 | MBY0313984.1 tRNA (adenosine(37)-N6)-dimethylallyltransferase MiaA [Bdellovibrionales bacterium] | diamond | 240 | 47 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30943352 | 30943352 | PRJEB75230_P_NODE_101914_length_262_cov_1.222222_g101732_i0 | PRJEB75230 | 101914 | 262 | 1.222222 | 3.20222164 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 53.1 | 8.28e-6 | NR | MBC7421275.1 | 28201 | g101732 | i0 | 47.2 | 2.40458015267176 | 53 | 28 | 60.7 | 0 | 165 | 7 | 137 | 189 | MBC7421275.1 MOSC domain-containing protein [Bdellovibrio sp.] | diamond | 630 | 53.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 31424594 | 31424594 | PRJEB75230_P_NODE_133456_length_249_cov_0.875000_g133274_i0 | PRJEB75230 | 133456 | 249 | 0.875 | 2.17875 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 89 | 2.02e-18 | NR | MCB9073096.1 | 2026715 | g133274 | i0 | 56.1 | 1.95180722891566 | 82 | 35 | 97.6 | 1 | 2 | 244 | 334 | 415 | MCB9073096.1 PAS domain-containing protein [Pseudobdellovibrionaceae bacterium] | diamond | 486 | 89 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 32500513 | 32500513 | PRJEB75230_P_NODE_89379_length_272_cov_1.160804_g89197_i0 | PRJEB75230 | 89379 | 272 | 1.160804 | 3.15738688 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 92 | 2.47e-19 | NR | MBX3041694.1 | 2026715 | g89197 | i0 | 47.2 | 1.96323529411765 | 89 | 47 | 98.2 | 0 | 270 | 4 | 566 | 654 | MBX3041694.1 insulinase family protein [Pseudobdellovibrionaceae bacterium] | diamond | 534 | 92 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae 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);;