contig_metadata
17 rows where bioproject = "PRJNA283169", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15674489 | 15674489 | PRJNA283169_P_NODE_4193_length_205_cov_1.333333_g4130_i0 | PRJNA283169 | 4193 | 205 | 1.333333 | 2.73333265 | Bdellovibrio | 958 | Bacteria | Bacteria | 104 | 4.51e-25 | NR | MEN0057906.1 | 28201 | g4130 | i0 | 75 | 5.95609756097561 | 68 | 17 | 99.5 | 0 | 1 | 204 | 162 | 229 | MEN0057906.1 acyl-CoA dehydrogenase family protein [Bdellovibrio sp.] | diamond | 1221 | 105 | 0.990476190476191 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 23323822 | 23323822 | PRJNA283169_P_NODE_4779_length_194_cov_1.427586_g4716_i0 | PRJNA283169 | 4779 | 194 | 1.427586 | 2.76951684 | Bdellovibrio sp. HCB337 | 3394358 | Bacteria | Bacteria | 291 | 3.2599999999999993e-74 | NTclustered | gi|2895525383|gb|CP178621.1| | 3394358 | g4716 | i0 | 93.814 | 225.046391752577 | 194 | 11 | 100 | 1 | 1 | 194 | 3447798 | 3447990 | Bdellovibrio sp. HCB337 chromosome, complete genome | blastn | 43659 | 291 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB337 | ||
| 23323831 | 23323831 | PRJNA283169_P_NODE_5399_length_184_cov_1.133333_g5336_i0 | PRJNA283169 | 5399 | 184 | 1.133333 | 2.08533272 | Bdellovibrio sp. NC01 | 2220073 | Bacteria | Bacteria | 268 | 1.43e-67 | NTclustered | gi|1700686220|gb|CP030034.1| | 2220073 | g5336 | i0 | 93.085 | 2.43478260869565 | 188 | 5 | 100 | 4 | 1 | 184 | 215160 | 214977 | Bdellovibrio sp. NC01 chromosome, complete genome | blastn | 448 | 268 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. NC01 | ||
| 26598976 | 26598976 | PRJNA283169_P_NODE_4601_length_198_cov_0.879195_g4538_i0 | PRJNA283169 | 4601 | 198 | 0.879195 | 1.7408061 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 68.9 | 5.52e-12 | NR | MEK7355206.1 | 3034175 | g4538 | i0 | 50.8 | 2.68181818181818 | 59 | 29 | 89.4 | 0 | 177 | 1 | 179 | 237 | MEK7355206.1 FliH/SctL family protein [Bdellovibrionota bacterium] | diamond | 531 | 68.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 26902125 | 26902125 | PRJNA283169_P_NODE_7101_length_166_cov_0.871795_g7038_i0 | PRJNA283169 | 7101 | 166 | 0.871795 | 1.4471797 | Bdellovibrio | 958 | Bacteria | Bacteria | 112 | 2.76e-28 | NR | WP_374076269.1 | 958 | g7038 | i0 | 89.1 | 3.97590361445783 | 55 | 6 | 99.4 | 0 | 166 | 2 | 284 | 338 | WP_374076269.1 MULTISPECIES: hypothetical protein [Bdellovibrio] | diamond | 660 | 113 | 0.991150442477876 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | |||
| 27863709 | 27863709 | PRJNA283169_P_NODE_2685_length_252_cov_1.773399_g2622_i0 | PRJNA283169 | 2685 | 252 | 1.773399 | 4.46896548 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 57.4 | 2.74e-7 | NR | MES3036618.1 | 3034175 | g2622 | i0 | 46 | 0.595238095238095 | 50 | 27 | 59.5 | 0 | 239 | 90 | 7 | 56 | MES3036618.1 alpha/beta fold hydrolase [Bdellovibrionota bacterium] | diamond | 150 | 57.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 28021832 | 28021832 | PRJNA283169_P_NODE_1065_length_382_cov_1.408408_g1003_i0 | PRJNA283169 | 1065 | 382 | 1.408408 | 5.38011856 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 72.8 | 5.16e-12 | NR | MBK7961858.1 | 2053517 | g1003 | i0 | 60 | 0.549738219895288 | 70 | 28 | 55 | 0 | 298 | 89 | 210 | 279 | MBK7961858.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 210 | 72.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28337439 | 28337439 | PRJNA283169_S_NODE_2366_length_186_cov_0.109489_g2352_i0 | PRJNA283169 | 2366 | 186 | 0.109489 | 0.20364954 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 66.6 | 6.38e-11 | NR | MBK9293443.1 | 2599941 | g2352 | i0 | 77.8 | 0.580645161290323 | 36 | 8 | 58.1 | 0 | 118 | 11 | 361 | 396 | MBK9293443.1 Ppx/GppA family phosphatase [Oligoflexia bacterium] | diamond | 108 | 66.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 29000835 | 29000835 | PRJNA283169_P_NODE_7468_length_164_cov_1.252174_g7405_i0 | PRJNA283169 | 7468 | 164 | 1.252174 | 2.05356536 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 68.9 | 8.06e-14 | NR | MCM2349523.1 | 2081706 | g7405 | i0 | 80.9 | 0.859756097560976 | 47 | 9 | 86 | 0 | 1 | 141 | 21 | 67 | MCM2349523.1 hypothetical protein [Bacteriovoracaceae bacterium] | diamond | 141 | 68.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 29252810 | 29252810 | PRJNA283169_S_NODE_1109_length_253_cov_1.990196_g1095_i0 | PRJNA283169 | 1109 | 253 | 1.990196 | 5.03519588 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 144 | 2.49e-41 | NR | MBX9767865.1 | 2053517 | g1095 | i0 | 90.8 | 0.901185770750988 | 76 | 7 | 90.1 | 0 | 230 | 3 | 1 | 76 | MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 228 | 144 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29252812 | 29252812 | PRJNA283169_S_NODE_2769_length_174_cov_0.112000_g2755_i0 | PRJNA283169 | 2769 | 174 | 0.112 | 0.19488 | Micavibrio sp. | 2024841 | Bacteria | Bacteria | 59.7 | 1.52e-8 | NR | MDB5491835.1 | 2024841 | g2755 | i0 | 47.4 | 0.982758620689655 | 57 | 30 | 98.3 | 0 | 172 | 2 | 1169 | 1225 | MDB5491835.1 TonB-dependent receptor [Micavibrio sp.] | diamond | 171 | 59.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio sp. | ||
| 30611109 | 30611109 | PRJNA283169_P_NODE_6793_length_167_cov_0.881356_g6730_i0 | PRJNA283169 | 6793 | 167 | 0.881356 | 1.47186452 | Bacteriovorax sp. | 2608087 | Bacteria | Bacteria | 97.8 | 7.42e-23 | NR | MDD4976358.1 | 2608087 | g6730 | i0 | 78.2 | 0.988023952095808 | 55 | 12 | 98.8 | 0 | 165 | 1 | 218 | 272 | MDD4976358.1 radical SAM protein [Bacteriovorax sp.] | diamond | 165 | 97.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax sp. | ||
| 30705917 | 30705917 | PRJNA283169_S_NODE_2194_length_192_cov_0.216783_g2180_i0 | PRJNA283169 | 2194 | 192 | 0.216783 | 0.41622336 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 45.1 | 8.71e-4 | NR | MBX3017963.1 | 2026715 | g2180 | i0 | 63.6 | 0.515625 | 33 | 8 | 51.6 | 1 | 93 | 191 | 1 | 29 | MBX3017963.1 hypothetical protein [Pseudobdellovibrionaceae bacterium] | diamond | 99 | 45.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 30800692 | 30800692 | PRJNA283169_P_NODE_4814_length_194_cov_0.979310_g4751_i0 | PRJNA283169 | 4814 | 194 | 0.97931 | 1.8998614 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 57 | 1.84e-7 | NR | MDZ4082971.1 | 2053517 | g4751 | i0 | 42.3 | 1.0979381443299 | 71 | 33 | 97.4 | 3 | 3 | 191 | 1030 | 1100 | MDZ4082971.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 213 | 57 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30913417 | 30913417 | PRJNA283169_P_NODE_4674_length_196_cov_1.238095_g4611_i0 | PRJNA283169 | 4674 | 196 | 1.238095 | 2.4266662 | Bdellovibrio | 958 | Bacteria | Bacteria | 115 | 8.160000000000001e-29 | NR | MBY0413485.1 | 2053517 | g4611 | i0 | 85.9 | 1.95918367346939 | 64 | 9 | 98 | 0 | 195 | 4 | 281 | 344 | MBY0413485.1 phospholipase D family protein [Bdellovibrionales bacterium] | diamond | 384 | 116 | 0.991379310344828 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32336639 | 32336639 | PRJNA283169_P_NODE_1559_length_323_cov_1.120438_g1497_i0 | PRJNA283169 | 1559 | 323 | 1.120438 | 3.61901474 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 50.1 | 2.6e-4 | NR | OFZ40669.1 | 1797398 | g1497 | i0 | 49.1 | 1.86687306501548 | 57 | 28 | 52.9 | 1 | 276 | 106 | 228 | 283 | OFZ40669.1 MAG: hypothetical protein A2485_15915, partial [Bdellovibrionales bacterium RIFOXYC12_FULL_39_17] | diamond | 603 | 50.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium RIFOXYC12_FULL_39_17 | ||||
| 32540486 | 32540486 | PRJNA283169_P_NODE_2539_length_259_cov_1.161905_g2477_i0 | PRJNA283169 | 2539 | 259 | 1.161905 | 3.00933395 | Bdellovibrio bacteriovorus | 959 | Bacteria | Bacteria | 124 | 1.3e-30 | NR | WP_061836132.1 | 959 | g2477 | i0 | 67.4 | 0.996138996138996 | 86 | 28 | 99.6 | 0 | 258 | 1 | 382 | 467 | WP_061836132.1 translocation/assembly module TamB domain-containing protein [Bdellovibrio bacteriovorus] | diamond | 258 | 124 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus |
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);;