contig_metadata
26 rows where bioproject = "PRJNA385073" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6783496 | 6783496 | PRJNA385073_P_NODE_28586_length_283_cov_1.276190_g28424_i0 | PRJNA385073 | 28586 | 283 | 1.27619 | 3.6116177 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 132 | 1.94e-33 | NR | MDR3607015.1 | 2599941 | g28424 | i0 | 61.7 | 1.99293286219081 | 94 | 36 | 99.6 | 0 | 2 | 283 | 340 | 433 | MDR3607015.1 isoleucine--tRNA ligase [Oligoflexia bacterium] | diamond | 564 | 133 | 0.992481203007519 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 6784262 | 6784262 | PRJNA385073_P_NODE_63666_length_217_cov_4.020833_g63504_i0 | PRJNA385073 | 63666 | 217 | 4.020833 | 8.72520761 | Bdellovibrio bacteriovorus | 959 | Bacteria | Bacteria | 159 | 1.1e-34 | NTclustered | gi|2800924434|gb|CP168967.1| | 959 | g63504 | i0 | 80.476 | 33.8110599078341 | 210 | 39 | 96 | 2 | 9 | 217 | 2323809 | 2323601 | Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome | blastn | 7337 | 159 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 9333807 | 9333807 | PRJNA385073_P_NODE_26128_length_290_cov_1.672811_g25966_i0 | PRJNA385073 | 26128 | 290 | 1.672811 | 4.8511519 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 180 | 4.06e-51 | NR | MES2768523.1 | 3034175 | g25966 | i0 | 87.5 | 0.993103448275862 | 96 | 12 | 99.3 | 0 | 290 | 3 | 260 | 355 | MES2768523.1 primosomal protein N' [Bdellovibrionota bacterium] | diamond | 288 | 180 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 26948525 | 26948525 | PRJNA385073_P_NODE_54782_length_243_cov_1.288235_g54620_i0 | PRJNA385073 | 54782 | 243 | 1.288235 | 3.13041105 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 132 | 7.91e-34 | NR | MCM2281156.1 | 2026715 | g54620 | i0 | 80 | 0.987654320987654 | 80 | 16 | 98.8 | 0 | 3 | 242 | 263 | 342 | MCM2281156.1 beta-N-acetylhexosaminidase [Pseudobdellovibrionaceae bacterium] | diamond | 240 | 132 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 27106642 | 27106642 | PRJNA385073_P_NODE_53242_length_244_cov_0.900585_g53080_i0 | PRJNA385073 | 53242 | 244 | 0.900585 | 2.1974274 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 112 | 2.58e-29 | NR | GIL18072.1 | 2599941 | g53080 | i0 | 64.6 | 0.971311475409836 | 79 | 28 | 97.1 | 0 | 242 | 6 | 56 | 134 | GIL18072.1 MAG: hypothetical protein BroJett040_18230 [Oligoflexia bacterium] | diamond | 237 | 112 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 27580657 | 27580657 | PRJNA385073_P_NODE_62264_length_228_cov_3.696774_g62102_i0 | PRJNA385073 | 62264 | 228 | 3.696774 | 8.42864472 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 75.1 | 1e-13 | NR | MEK6772466.1 | 3034175 | g62102 | i0 | 56.3 | 0.934210526315789 | 71 | 31 | 93.4 | 0 | 16 | 228 | 1 | 71 | MEK6772466.1 hypothetical protein [Bdellovibrionota bacterium] | diamond | 213 | 75.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 27738949 | 27738949 | PRJNA385073_P_NODE_56984_length_242_cov_0.911243_g56822_i0 | PRJNA385073 | 56984 | 242 | 0.911243 | 2.20520806 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 72.4 | 1.72e-13 | NR | MCM2281623.1 | 2026715 | g56822 | i0 | 48.6 | 0.892561983471074 | 72 | 36 | 88 | 1 | 3 | 215 | 51 | 122 | MCM2281623.1 hypothetical protein [Pseudobdellovibrionaceae bacterium] | diamond | 216 | 72.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 28622810 | 28622810 | PRJNA385073_P_NODE_34587_length_266_cov_3.984456_g34425_i0 | PRJNA385073 | 34587 | 266 | 3.984456 | 10.59865296 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 124 | 2.53e-32 | NR | HEX4924925.1 | 2053517 | g34425 | i0 | 62.1 | 0.981203007518797 | 87 | 33 | 98.1 | 0 | 4 | 264 | 138 | 224 | HEX4924925.1 M14 family metallopeptidase [Bdellovibrionales bacterium] | diamond | 261 | 124 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28686031 | 28686031 | PRJNA385073_P_NODE_28587_length_283_cov_1.257143_g28425_i0 | PRJNA385073 | 28587 | 283 | 1.257143 | 3.55771469 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 105 | 6.97e-24 | NR | HEY8278715.1 | 3034175 | g28425 | i0 | 49.5 | 1.00706713780919 | 95 | 47 | 99.6 | 1 | 2 | 283 | 418 | 512 | HEY8278715.1 transglutaminase domain-containing protein [Bdellovibrionota bacterium] | diamond | 285 | 105 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 29064814 | 29064814 | PRJNA385073_P_NODE_37108_length_260_cov_2.994652_g36946_i0 | PRJNA385073 | 37108 | 260 | 2.994652 | 7.7860952 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 105 | 1.6099999999999997e-24 | NR | MCM2282510.1 | 2026715 | g36946 | i0 | 62.8 | 0.992307692307692 | 86 | 32 | 99.2 | 0 | 1 | 258 | 182 | 267 | MCM2282510.1 chorismate-binding protein [Pseudobdellovibrionaceae bacterium] | diamond | 258 | 105 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 29569796 | 29569796 | PRJNA385073_P_NODE_38970_length_256_cov_1.677596_g38808_i0 | PRJNA385073 | 38970 | 256 | 1.677596 | 4.29464576 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 85.5 | 4.38e-19 | NR | MCM2280868.1 | 2026715 | g38808 | i0 | 49.4 | 0.99609375 | 85 | 38 | 93.8 | 1 | 252 | 13 | 41 | 125 | MCM2280868.1 hypothetical protein [Pseudobdellovibrionaceae bacterium] | diamond | 255 | 85.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 30012162 | 30012162 | PRJNA385073_P_NODE_60711_length_235_cov_3.049383_g60549_i0 | PRJNA385073 | 60711 | 235 | 3.049383 | 7.16605005 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 142 | 2.21e-38 | NR | MCM2282002.1 | 2026715 | g60549 | i0 | 88.5 | 0.995744680851064 | 78 | 9 | 99.6 | 0 | 234 | 1 | 397 | 474 | MCM2282002.1 dihydrolipoyl dehydrogenase [Pseudobdellovibrionaceae bacterium] | diamond | 234 | 142 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 30012166 | 30012166 | PRJNA385073_P_NODE_65011_length_202_cov_4.325581_g64849_i0 | PRJNA385073 | 65011 | 202 | 4.325581 | 8.73767362 | Halobacteriovoraceae bacterium | 2026745 | Bacteria | Bacteria | 53.1 | 4.57e-6 | NR | MAW07942.1 | 2026745 | g64849 | i0 | 49.2 | 0.876237623762376 | 59 | 30 | 87.6 | 0 | 14 | 190 | 123 | 181 | MAW07942.1 hypothetical protein [Halobacteriovoraceae bacterium] | diamond | 177 | 53.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovoraceae bacterium | |||
| 30265082 | 30265082 | PRJNA385073_P_NODE_26312_length_290_cov_0.898618_g26150_i0 | PRJNA385073 | 26312 | 290 | 0.898618 | 2.6059922 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 75.1 | 2.71e-14 | NR | PZQ46217.1 | 349221 | g26150 | i0 | 56.5 | 1.48965517241379 | 69 | 30 | 71.4 | 0 | 56 | 262 | 5 | 73 | PZQ46217.1 MAG: hypothetical protein DI551_05565 [Micavibrio aeruginosavorus] | diamond | 432 | 75.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 30296845 | 30296845 | PRJNA385073_P_NODE_54372_length_243_cov_3.441176_g54210_i0 | PRJNA385073 | 54372 | 243 | 3.441176 | 8.36205768 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 97.1 | 1.24e-22 | NR | MBA2404886.1 | 2053517 | g54210 | i0 | 62.5 | 0.987654320987654 | 80 | 30 | 98.8 | 0 | 241 | 2 | 84 | 163 | MBA2404886.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 240 | 97.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30471385 | 30471385 | PRJNA385073_P_NODE_27133_length_287_cov_1.691589_g26971_i0 | PRJNA385073 | 27133 | 287 | 1.691589 | 4.85486043 | Bdellovibrio | 958 | Bacteria | Bacteria | 113 | 4.03e-30 | NR | WP_061834347.1 | 959 | g26971 | i0 | 60.7 | 3.66898954703833 | 89 | 35 | 93 | 0 | 19 | 285 | 2 | 90 | WP_061834347.1 PilZ domain-containing protein [Bdellovibrio bacteriovorus] | diamond | 1053 | 113 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 30485996 | 30485996 | PRJNA385073_P_NODE_56113_length_242_cov_2.603550_g55951_i0 | PRJNA385073 | 56113 | 242 | 2.60355 | 6.300591 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 66.6 | 4.94e-11 | NR | MBX3022149.1 | 2053517 | g55951 | i0 | 78 | 1.04132231404959 | 41 | 9 | 50.8 | 0 | 3 | 125 | 190 | 230 | MBX3022149.1 response regulator [Bdellovibrionales bacterium] | diamond | 252 | 66.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30801819 | 30801819 | PRJNA385073_P_NODE_40374_length_253_cov_1.327778_g40212_i0 | PRJNA385073 | 40374 | 253 | 1.327778 | 3.35927834 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 105 | 4.85e-24 | NR | GIL17310.1 | 2599941 | g40212 | i0 | 54.8 | 0.99604743083004 | 84 | 38 | 99.6 | 0 | 252 | 1 | 225 | 308 | GIL17310.1 MAG: ATP-dependent DNA helicase RecG [Oligoflexia bacterium] | diamond | 252 | 105 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 31433958 | 31433958 | PRJNA385073_P_NODE_38416_length_257_cov_2.385870_g38254_i0 | PRJNA385073 | 38416 | 257 | 2.38587 | 6.1316859 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 146 | 3.0499999999999993e-40 | NR | HMN67674.1 | 2053517 | g38254 | i0 | 80 | 0.992217898832685 | 85 | 17 | 99.2 | 0 | 2 | 256 | 274 | 358 | HMN67674.1 formate-dependent phosphoribosylglycinamide formyltransferase [Bdellovibrionales bacterium] | diamond | 255 | 146 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31497471 | 31497471 | PRJNA385073_P_NODE_46576_length_248_cov_0.880000_g46414_i0 | PRJNA385073 | 46576 | 248 | 0.88 | 2.1824 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 131 | 3.45e-34 | NR | MDZ4677387.1 | 2599941 | g46414 | i0 | 80.2 | 0.979838709677419 | 81 | 16 | 98 | 0 | 248 | 6 | 377 | 457 | MDZ4677387.1 cystathionine beta-synthase [Oligoflexia bacterium] | diamond | 243 | 131 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 31971730 | 31971730 | PRJNA385073_P_NODE_45798_length_249_cov_0.869318_g45636_i0 | PRJNA385073 | 45798 | 249 | 0.869318 | 2.16460182 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 43.1 | 0.0296 | NR | MCB0403606.1 | 2053517 | g45636 | i0 | 37 | 0.975903614457831 | 81 | 46 | 96.4 | 2 | 242 | 3 | 320 | 396 | MCB0403606.1 transcription-repair coupling factor [Bdellovibrionales bacterium] | diamond | 243 | 43.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31971737 | 31971737 | PRJNA385073_P_NODE_56198_length_242_cov_1.822485_g56036_i0 | PRJNA385073 | 56198 | 242 | 1.822485 | 4.4104137 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 68.2 | 1.93e-11 | NR | NQZ18541.1 | 2053517 | g56036 | i0 | 45.7 | 3.39669421487603 | 70 | 38 | 86.8 | 0 | 238 | 29 | 82 | 151 | NQZ18541.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 822 | 68.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32003497 | 32003497 | PRJNA385073_P_NODE_62878_length_226_cov_2.562092_g62716_i0 | PRJNA385073 | 62878 | 226 | 2.562092 | 5.79032792 | Bdellovibrio sp. | 28201 | Bacteria | Bacteria | 117 | 5.34e-29 | NR | MEN0058081.1 | 28201 | g62716 | i0 | 70.3 | 7.83185840707965 | 74 | 22 | 98.2 | 0 | 3 | 224 | 195 | 268 | MEN0058081.1 MFS transporter [Bdellovibrio sp.] | diamond | 1770 | 117 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 32351697 | 32351697 | PRJNA385073_P_NODE_36279_length_262_cov_2.312169_g36117_i0 | PRJNA385073 | 36279 | 262 | 2.312169 | 6.05788278 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 135 | 2.04e-36 | NR | MFA5583960.1 | 2081706 | g36117 | i0 | 66.7 | 0.961832061068702 | 84 | 28 | 96.2 | 0 | 9 | 260 | 133 | 216 | MFA5583960.1 hypothetical protein [Bacteriovoracaceae bacterium] | diamond | 252 | 135 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 32414914 | 32414914 | PRJNA385073_P_NODE_64879_length_203_cov_4.923077_g64717_i0 | PRJNA385073 | 64879 | 203 | 4.923077 | 9.99384631 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 126 | 9.94e-36 | NR | HMN67470.1 | 2053517 | g64717 | i0 | 79.1 | 0.990147783251232 | 67 | 14 | 99 | 0 | 203 | 3 | 55 | 121 | HMN67470.1 DUF3307 domain-containing protein [Bdellovibrionales bacterium] | diamond | 201 | 126 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32635656 | 32635656 | PRJNA385073_P_NODE_41160_length_251_cov_1.719101_g40998_i0 | PRJNA385073 | 41160 | 251 | 1.719101 | 4.31494351 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 90.1 | 8.62e-20 | NR | MBS1958980.1 | 2053517 | g40998 | i0 | 87.5 | 0.573705179282869 | 48 | 6 | 57.4 | 0 | 248 | 105 | 203 | 250 | MBS1958980.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 144 | 90.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales 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);;