contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA492280" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9379726 | 9379726 | PRJNA492280_P_NODE_13148_length_164_cov_5.661417_g13041_i0 | PRJNA492280 | 13148 | 164 | 5.661417 | 9.28472388 | Micavibrio sp. | 2024841 | Bacteria | Bacteria | 90.1 | 1.48e-19 | NR | HEU4837819.1 | 2024841 | g13041 | i0 | 75 | 1.09756097560976 | 60 | 7 | 95.1 | 1 | 1 | 156 | 172 | 231 | HEU4837819.1 phosphoserine transaminase [Micavibrio sp.] | diamond | 180 | 90.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio sp. | ||
| 26743844 | 26743844 | PRJNA492280_P_NODE_33221_length_150_cov_4.300885_g33114_i0 | PRJNA492280 | 33221 | 150 | 4.300885 | 6.4513275 | Bacteria | 2 | Bacteria | Bacteria | 64.3 | 2.48e-10 | NR | MCO5142205.1 | 2599941 | g33114 | i0 | 46.7 | 3.08 | 75 | 14 | 98 | 2 | 2 | 148 | 439 | 513 | MCO5142205.1 glycosyltransferase family 39 protein [Oligoflexia bacterium] | diamond | 462 | 64.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 27171025 | 27171025 | PRJNA492280_P_NODE_18702_length_164_cov_3.551181_g18595_i0 | PRJNA492280 | 18702 | 164 | 3.551181 | 5.82393684 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 51.6 | 4.92e-6 | NR | HEY8279811.1 | 3034175 | g18595 | i0 | 60.5 | 0.786585365853659 | 43 | 17 | 78.7 | 0 | 133 | 5 | 84 | 126 | HEY8279811.1 hypothetical protein [Bdellovibrionota bacterium] | diamond | 129 | 51.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 27266097 | 27266097 | PRJNA492280_P_NODE_17883_length_164_cov_3.732283_g17776_i0 | PRJNA492280 | 17883 | 164 | 3.732283 | 6.12094412 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 40 | 0.0251 | NR | MCM2348416.1 | 2081706 | g17776 | i0 | 63.3 | 0.548780487804878 | 30 | 10 | 54.9 | 1 | 94 | 5 | 42 | 70 | MCM2348416.1 hypothetical protein [Bacteriovoracaceae bacterium] | diamond | 90 | 40 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 27297654 | 27297654 | PRJNA492280_P_NODE_22303_length_164_cov_2.952756_g22196_i0 | PRJNA492280 | 22303 | 164 | 2.952756 | 4.84251984 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 50.4 | 7.53e-6 | NR | MBY0516280.1 | 2081706 | g22196 | i0 | 91.7 | 0.439024390243902 | 24 | 2 | 43.9 | 0 | 91 | 162 | 9 | 32 | MBY0516280.1 SufE family protein [Bacteriovoracaceae bacterium] | diamond | 72 | 50.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 28387211 | 28387211 | PRJNA492280_P_NODE_21226_length_164_cov_3.118110_g21119_i0 | PRJNA492280 | 21226 | 164 | 3.11811 | 5.1137004 | Bacteria | 2 | Bacteria | Bacteria | 48.5 | 1.14e-4 | NR | HRK07011.1 | 2026715 | g21119 | i0 | 91.7 | 8.78048780487805 | 24 | 2 | 43.9 | 0 | 74 | 3 | 47 | 70 | HRK07011.1 flagellar basal body P-ring protein FlgI [Pseudobdellovibrionaceae bacterium] | diamond | 1440 | 48.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 29223980 | 29223980 | PRJNA492280_P_NODE_22569_length_164_cov_2.921260_g22462_i0 | PRJNA492280 | 22569 | 164 | 2.92126 | 4.7908664 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 41.2 | 0.046 | NR | HLT23269.1 | 2081706 | g22462 | i0 | 62.1 | 0.530487804878049 | 29 | 11 | 53 | 0 | 90 | 4 | 604 | 632 | HLT23269.1 carboxypeptidase regulatory-like domain-containing protein [Bacteriovoracaceae bacterium] | diamond | 87 | 41.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 29413083 | 29413083 | PRJNA492280_P_NODE_24909_length_164_cov_2.590551_g24802_i0 | PRJNA492280 | 24909 | 164 | 2.590551 | 4.24850364 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 54.3 | 6.55e-7 | NR | MBX3019940.1 | 2026715 | g24802 | i0 | 100 | 0.457317073170732 | 25 | 0 | 45.7 | 0 | 75 | 1 | 153 | 177 | MBX3019940.1 cell division ATP-binding protein FtsE [Pseudobdellovibrionaceae bacterium] | diamond | 75 | 54.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 29444543 | 29444543 | PRJNA492280_P_NODE_16350_length_164_cov_4.125984_g16243_i0 | PRJNA492280 | 16350 | 164 | 4.125984 | 6.76661376 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 46.2 | 7.53e-4 | NR | MCM2351031.1 | 2081706 | g16243 | i0 | 83.3 | 0.439024390243902 | 24 | 4 | 43.9 | 0 | 76 | 5 | 285 | 308 | MCM2351031.1 DNA polymerase IV [Bacteriovoracaceae bacterium] | diamond | 72 | 46.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 29791911 | 29791911 | PRJNA492280_P_NODE_11311_length_164_cov_18.322835_g11204_i0 | PRJNA492280 | 11311 | 164 | 18.322835 | 30.0494494 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 45.4 | 0.00144 | NR | WP_321396741.1 | 28202 | g11204 | i0 | 32.9 | 1.5 | 82 | 26 | 97 | 1 | 160 | 2 | 85 | 166 | WP_321396741.1 FHA domain-containing protein [Peredibacter starrii] | diamond | 246 | 45.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 30581713 | 30581713 | PRJNA492280_P_NODE_33893_length_150_cov_3.522124_g33786_i0 | PRJNA492280 | 33893 | 150 | 3.522124 | 5.283186 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 73.2 | 1.89e-13 | NR | MBS1984281.1 | 2053517 | g33786 | i0 | 76.2 | 0.84 | 42 | 10 | 84 | 0 | 20 | 145 | 101 | 142 | MBS1984281.1 DDE-type integrase/transposase/recombinase [Bdellovibrionales bacterium] | diamond | 126 | 73.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31498662 | 31498662 | PRJNA492280_P_NODE_21356_length_164_cov_3.094488_g21249_i0 | PRJNA492280 | 21356 | 164 | 3.094488 | 5.07496032 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 53.1 | 2.42e-6 | NR | MBS1982881.1 | 2053517 | g21249 | i0 | 95.8 | 0.878048780487805 | 24 | 1 | 43.9 | 0 | 3 | 74 | 103 | 126 | MBS1982881.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 144 | 53.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31704268 | 31704268 | PRJNA492280_P_NODE_15237_length_164_cov_4.496063_g15130_i0 | PRJNA492280 | 15237 | 164 | 4.496063 | 7.37354332 | Bacteria | 2 | Bacteria | Bacteria | 67 | 8.79e-12 | NR | MBY0515327.1 | 2081706 | g15130 | i0 | 54.8 | 4.00609756097561 | 73 | 13 | 97 | 1 | 164 | 6 | 60 | 132 | MBY0515327.1 FAD-dependent oxidoreductase [Bacteriovoracaceae bacterium] | diamond | 657 | 67 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 31941178 | 31941178 | PRJNA492280_P_NODE_29277_length_152_cov_2.095652_g29170_i0 | PRJNA492280 | 29277 | 152 | 2.095652 | 3.18539104 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 57 | 9.86e-8 | NR | HEY8279721.1 | 3034175 | g29170 | i0 | 79.3 | 0.572368421052632 | 29 | 6 | 57.2 | 0 | 63 | 149 | 9 | 37 | HEY8279721.1 family 1 glycosylhydrolase [Bdellovibrionota bacterium] | diamond | 87 | 57 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 32337293 | 32337293 | PRJNA492280_P_NODE_23019_length_164_cov_2.858268_g22912_i0 | PRJNA492280 | 23019 | 164 | 2.858268 | 4.68755952 | Bacteria | 2 | Bacteria | Bacteria | 49.3 | 6.18e-5 | NR | HXH30901.1 | 2081706 | g22912 | i0 | 95.5 | 1.64634146341463 | 22 | 1 | 40.2 | 0 | 159 | 94 | 242 | 263 | HXH30901.1 ATP-dependent DNA ligase [Bacteriovoracaceae bacterium] | diamond | 270 | 49.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 32384301 | 32384301 | PRJNA492280_P_NODE_24779_length_164_cov_2.614173_g24672_i0 | PRJNA492280 | 24779 | 164 | 2.614173 | 4.28724372 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 44.7 | 0.00247 | NR | MBY0515756.1 | 2081706 | g24672 | i0 | 85.7 | 0.384146341463415 | 21 | 3 | 38.4 | 0 | 2 | 64 | 210 | 230 | MBY0515756.1 TetR/AcrR family transcriptional regulator [Bacteriovoracaceae bacterium] | diamond | 63 | 44.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 32873373 | 32873373 | PRJNA492280_P_NODE_17360_length_164_cov_3.866142_g17253_i0 | PRJNA492280 | 17360 | 164 | 3.866142 | 6.34047288 | Peredibacter | 263370 | Bacteria | Bacteria | 48.9 | 8.46e-5 | NR | WP_321397490.1 | 28202 | g17253 | i0 | 83.3 | 2.19512195121951 | 24 | 4 | 43.9 | 0 | 74 | 3 | 235 | 258 | WP_321397490.1 5'-nucleotidase C-terminal domain-containing protein [Peredibacter starrii] | diamond | 360 | 48.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii |
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);;