contig_metadata
22 rows where bioproject = "PRJNA744060", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3274392 | 3274392 | PRJNA744060_P_NODE_19123_length_369_cov_2.206081_g18794_i0 | PRJNA744060 | 19123 | 369 | 2.206081 | 8.14043889 | Bdellovibrio sp. | 28201 | Bacteria | Bacteria | 130 | 1.57e-25 | NTclustered | gi|289320|gb|M61238.1|BDLDDAI | 28201 | g18794 | i0 | 82.468 | 19.420054200542 | 154 | 21 | 41 | 6 | 216 | 366 | 603 | 753 | Bdellovibrio sp. 16S rRNA gene, partial cds | blastn | 7166 | 130 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 4551485 | 4551485 | PRJNA744060_P_NODE_14644_length_420_cov_1.904899_g14315_i0 | PRJNA744060 | 14644 | 420 | 1.904899 | 8.0005758 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 223 | 1.98e-70 | NR | MBX2996387.1 | 2026715 | g14315 | i0 | 84.2 | 1.98571428571429 | 139 | 22 | 99.3 | 0 | 418 | 2 | 36 | 174 | MBX2996387.1 flagellin FliC [Pseudobdellovibrionaceae bacterium] | diamond | 834 | 223 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 10927394 | 10927394 | PRJNA744060_P_NODE_3869_length_794_cov_7.024965_g3585_i0 | PRJNA744060 | 3869 | 794 | 7.024965 | 55.7782221 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 189 | 3.14e-53 | NR | MBC7385198.1 | 2599941 | g3585 | i0 | 55.4 | 2.65617128463476 | 177 | 77 | 66.9 | 1 | 780 | 250 | 238 | 412 | MBC7385198.1 M20/M25/M40 family metallo-hydrolase [Oligoflexia bacterium] | diamond | 2109 | 189 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 12678106 | 12678106 | PRJNA744060_P_NODE_29490_length_301_cov_1.368421_g29161_i0 | PRJNA744060 | 29490 | 301 | 1.368421 | 4.11894721 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 74.7 | 1.35e-13 | NR | MBS1969970.1 | 2053517 | g29161 | i0 | 49.4 | 5.12292358803987 | 85 | 24 | 84.7 | 3 | 256 | 2 | 6 | 71 | MBS1969970.1 methyltransferase domain-containing protein [Bdellovibrionales bacterium] | diamond | 1542 | 74.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 13476780 | 13476780 | PRJNA744060_P_NODE_14651_length_420_cov_1.527378_g14322_i0 | PRJNA744060 | 14651 | 420 | 1.527378 | 6.4149876 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 189 | 3.78e-56 | NR | WP_088566726.1 | 959 | g14322 | i0 | 70.9 | 5.45 | 127 | 37 | 90.7 | 0 | 412 | 32 | 256 | 382 | WP_088566726.1 cystathionine gamma-synthase [Bdellovibrio bacteriovorus] | diamond | 2289 | 189 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 13476960 | 13476960 | PRJNA744060_P_NODE_24551_length_328_cov_1.376471_g24222_i0 | PRJNA744060 | 24551 | 328 | 1.376471 | 4.51482488 | Bdellovibrio sp. HCB209 | 3394354 | Bacteria | Bacteria | 117 | 1.08e-21 | NTclustered | gi|2895998570|gb|CP178618.1| | 3394354 | g24222 | i0 | 79.191 | 5.41158536585366 | 173 | 32 | 52 | 4 | 8 | 178 | 2692020 | 2691850 | Bdellovibrio sp. HCB209 chromosome, complete genome | blastn | 1775 | 117 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB209 | ||
| 24949857 | 24949857 | PRJNA744060_P_NODE_34700_length_280_cov_1.507246_g34371_i0 | PRJNA744060 | 34700 | 280 | 1.507246 | 4.2202888 | Bdellovibrio bacteriovorus | 959 | Bacteria | Bacteria | 416 | 7.939999999999998e-112 | NTclustered | gi|2800920897|gb|CP168968.1| | 959 | g34371 | i0 | 93.548 | 43.9071428571429 | 279 | 18 | 99 | 0 | 1 | 279 | 929791 | 930069 | Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome | blastn | 12294 | 416 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 26894744 | 26894744 | PRJNA744060_P_NODE_51861_length_240_cov_2.239521_g51532_i0 | PRJNA744060 | 51861 | 240 | 2.239521 | 5.3748504 | Oligoflexales bacterium | 2687297 | Bacteria | Bacteria | 70.9 | 4.36e-12 | NR | MFK7873564.1 | 2687297 | g51532 | i0 | 43.4 | 1.0375 | 83 | 40 | 95 | 1 | 230 | 3 | 513 | 595 | MFK7873564.1 hypothetical protein [Oligoflexales bacterium] | diamond | 249 | 70.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexales bacterium | ||||
| 27305740 | 27305740 | PRJNA744060_P_NODE_8683_length_542_cov_2.140725_g8358_i0 | PRJNA744060 | 8683 | 542 | 2.140725 | 11.6027295 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 99.4 | 4.64e-21 | NR | MBN22211.1 | 2026715 | g8358 | i0 | 41.6 | 0.891143911439114 | 161 | 85 | 86.9 | 6 | 72 | 542 | 15 | 170 | MBN22211.1 hypothetical protein [Pseudobdellovibrionaceae bacterium] | diamond | 483 | 99.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 28126673 | 28126673 | PRJNA744060_P_NODE_49745_length_244_cov_0.912281_g49416_i0 | PRJNA744060 | 49745 | 244 | 0.912281 | 2.22596564 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 112 | 4.18e-29 | NR | MEZ0391714.1 | 2026715 | g49416 | i0 | 70.5 | 0.959016393442623 | 78 | 22 | 94.7 | 1 | 232 | 2 | 34 | 111 | MEZ0391714.1 hypothetical protein [Pseudobdellovibrionaceae bacterium] | diamond | 234 | 112 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 28442461 | 28442461 | PRJNA744060_P_NODE_39946_length_263_cov_1.642105_g39617_i0 | PRJNA744060 | 39946 | 263 | 1.642105 | 4.31873615 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 129 | 1.05e-33 | NR | MCB0363622.1 | 2053517 | g39617 | i0 | 65.5 | 1.90494296577947 | 84 | 29 | 95.8 | 0 | 259 | 8 | 33 | 116 | MCB0363622.1 S9 family peptidase [Bdellovibrionales bacterium] | diamond | 501 | 129 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28979210 | 28979210 | PRJNA744060_P_NODE_37308_length_271_cov_2.196970_g36979_i0 | PRJNA744060 | 37308 | 271 | 2.19697 | 5.9537887 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 74.3 | 3.33e-13 | NR | MDR3608077.1 | 2599941 | g36979 | i0 | 89.5 | 0.885608856088561 | 38 | 4 | 42.1 | 0 | 270 | 157 | 277 | 314 | MDR3608077.1 cystathionine gamma-synthase [Oligoflexia bacterium] | diamond | 240 | 74.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 29011015 | 29011015 | PRJNA744060_P_NODE_29588_length_300_cov_2.898678_g29259_i0 | PRJNA744060 | 29588 | 300 | 2.898678 | 8.696034 | Pseudobacteriovorax sp. | 2020859 | Bacteria | Bacteria | 51.6 | 3.49e-5 | NR | NRA64141.1 | 2020859 | g29259 | i0 | 42.9 | 0.56 | 56 | 31 | 55 | 1 | 3 | 167 | 72 | 127 | NRA64141.1 trypsin-like peptidase domain-containing protein [Pseudobacteriovorax sp.] | diamond | 168 | 51.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Pseudobacteriovoracaceae | Pseudobacteriovorax | Pseudobacteriovorax sp. | ||
| 29263036 | 29263036 | PRJNA744060_P_NODE_45009_length_251_cov_1.589888_g44680_i0 | PRJNA744060 | 45009 | 251 | 1.589888 | 3.99061888 | Bacteriovorax stolpii | 960 | Bacteria | Bacteria | 75.1 | 7.1e-14 | NR | WP_102243639.1 | 960 | g44680 | i0 | 46.2 | 5.28286852589641 | 78 | 41 | 93.2 | 1 | 13 | 246 | 52 | 128 | WP_102243639.1 trypsin-like serine peptidase [Bacteriovorax stolpii] | diamond | 1326 | 75.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 29620090 | 29620090 | PRJNA744060_P_NODE_46170_length_249_cov_2.250000_g45841_i0 | PRJNA744060 | 46170 | 249 | 2.25 | 5.6025 | root | 1 | Root_unresolved | Root_unresolved | 66.6 | 1.57e-10 | NR | WP_015468752.1 | 453816 | g45841 | i0 | 43.7 | 3.07228915662651 | 87 | 41 | 96.4 | 3 | 249 | 10 | 309 | 394 | WP_015468752.1 thrombospondin type-1 domain-containing protein [Pseudobdellovibrio exovorus] | diamond | 765 | 67 | 0.994029850746269 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 29957894 | 29957894 | PRJNA744060_P_NODE_47751_length_247_cov_0.896552_g47422_i0 | PRJNA744060 | 47751 | 247 | 0.896552 | 2.21448344 | Bdellovibrio sp. | 28201 | Bacteria | Bacteria | 43.9 | 0.0134 | NR | WP_415062841.1 | 28201 | g47422 | i0 | 47.8 | 0.995951417004049 | 46 | 24 | 55.9 | 0 | 23 | 160 | 5 | 50 | WP_415062841.1 hypothetical protein [Bdellovibrio sp.] | diamond | 246 | 43.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 30347603 | 30347603 | PRJNA744060_P_NODE_46432_length_249_cov_0.886364_g46103_i0 | PRJNA744060 | 46432 | 249 | 0.886364 | 2.20704636 | Bdellovibrio | 958 | Bacteria | Bacteria | 143 | 1.06e-39 | NR | WP_374073910.1 | 958 | g46103 | i0 | 80.7 | 4 | 83 | 16 | 100 | 0 | 249 | 1 | 158 | 240 | WP_374073910.1 MULTISPECIES: asparaginase [Bdellovibrio] | diamond | 996 | 143 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | |||
| 30463840 | 30463840 | PRJNA744060_P_NODE_20993_length_353_cov_1.735714_g20664_i0 | PRJNA744060 | 20993 | 353 | 1.735714 | 6.12707042 | Silvanigrellaceae bacterium | 2654442 | Bacteria | Bacteria | 45.4 | 0.00112 | NR | MBX9703359.1 | 2654442 | g20664 | i0 | 40.4 | 0.39943342776204 | 47 | 28 | 39.9 | 0 | 78 | 218 | 1 | 47 | MBX9703359.1 hypothetical protein [Silvanigrellaceae bacterium] | diamond | 141 | 45.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellaceae | Silvanigrellaceae bacterium | |||
| 31221504 | 31221504 | PRJNA744060_P_NODE_2935_length_901_cov_2.991546_g2679_i0 | PRJNA744060 | 2935 | 901 | 2.991546 | 26.95382946 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 242 | 1.28e-76 | NR | MBX9767865.1 | 2053517 | g2679 | i0 | 55.7 | 0.669256381798002 | 201 | 89 | 66.9 | 0 | 822 | 220 | 1 | 201 | MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 603 | 242 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32180881 | 32180881 | PRJNA744060_P_NODE_18238_length_378_cov_1.416393_g17909_i0 | PRJNA744060 | 18238 | 378 | 1.416393 | 5.35396554 | Bdellovibrio | 958 | Bacteria | Bacteria | 103 | 1e-23 | NR | WP_374074152.1 | 959 | g17909 | i0 | 38.6 | 2.01587301587302 | 127 | 76 | 99.2 | 1 | 375 | 1 | 60 | 186 | WP_374074152.1 trypsin-like serine peptidase [Bdellovibrio bacteriovorus] | diamond | 762 | 104 | 0.990384615384615 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 32202392 | 32202392 | PRJNA744060_P_NODE_10098_length_504_cov_2.199536_g9771_i0 | PRJNA744060 | 10098 | 504 | 2.199536 | 11.08566144 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 47.4 | 0.00584 | NR | MBC6416186.1 | 2053517 | g9771 | i0 | 60 | 0.452380952380952 | 35 | 14 | 20.8 | 0 | 500 | 396 | 84 | 118 | MBC6416186.1 sel1 repeat family protein [Bdellovibrionales bacterium] | diamond | 228 | 47.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32202457 | 32202457 | PRJNA744060_P_NODE_47198_length_248_cov_0.891429_g46869_i0 | PRJNA744060 | 47198 | 248 | 0.891429 | 2.21074392 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 127 | 1.48e-33 | NR | MEZ0391836.1 | 2026715 | g46869 | i0 | 73.2 | 0.991935483870968 | 82 | 22 | 99.2 | 0 | 247 | 2 | 184 | 265 | MEZ0391836.1 signal peptide peptidase SppA [Pseudobdellovibrionaceae bacterium] | diamond | 246 | 127 | 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);;