contig_metadata
20 rows where bioproject = "PRJEB14664", tax_phylum = "Bdellovibrionota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21210 | 21210 | PRJEB14664_P_NODE_16341_length_173_cov_0.847826_g16211_i0 | PRJEB14664 | 16341 | 173 | 0.847826 | 1.46673898 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 246 | 6.2099999999999995e-61 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g16211 | i0 | 92.135 | 107.49132947976901 | 178 | 9 | 100 | 3 | 1 | 173 | 512028 | 511851 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 18596 | 246 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 4813579 | 4813579 | PRJEB14664_P_NODE_13324_length_198_cov_1.417178_g13194_i0 | PRJEB14664 | 13324 | 198 | 1.417178 | 2.80601244 | Pseudobdellovibrionaceae | 213483 | Bacteria | Bacteria | 318 | 1.53e-82 | NTclustered | gi|507148233|ref|NR_103040.1| | 453816 | g13194 | i0 | 98.343 | 163.646464646465 | 181 | 3 | 91 | 0 | 1 | 181 | 776 | 956 | Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence | blastn | 32402 | 318 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 5123590 | 5123590 | PRJEB14664_P_NODE_16285_length_173_cov_1.195652_g16155_i0 | PRJEB14664 | 16285 | 173 | 1.195652 | 2.06847796 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 298 | 1.69e-76 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g16155 | i0 | 97.688 | 244.35838150289 | 173 | 4 | 100 | 0 | 1 | 173 | 512848 | 512676 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 42274 | 298 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 6399333 | 6399333 | PRJEB14664_P_NODE_17126_length_167_cov_1.325758_g16996_i0 | PRJEB14664 | 17126 | 167 | 1.325758 | 2.21401586 | Bdellovibrio sp. qaytius | 1916293 | Bacteria | Bacteria | 274 | 2.75e-69 | NTclustered | gi|1552089877|gb|CP025734.1| | 1916293 | g16996 | i0 | 96.386 | 84.7784431137725 | 166 | 6 | 99 | 0 | 2 | 167 | 666654 | 666819 | Bdellovibrio sp. qaytius chromosome, complete genome | blastn | 14158 | 274 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. qaytius | ||
| 6399347 | 6399347 | PRJEB14664_P_NODE_1866_length_676_cov_1.962559_g1759_i0 | PRJEB14664 | 1866 | 676 | 1.962559 | 13.26689884 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 246 | 9.3e-80 | NR | MCB0370127.1 | 2053517 | g1759 | i0 | 87.9 | 0.625739644970414 | 141 | 17 | 62.6 | 0 | 456 | 34 | 30 | 170 | MCB0370127.1 40S ribosomal protein S14 [Bdellovibrionales bacterium] | diamond | 423 | 246 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 6399364 | 6399364 | PRJEB14664_P_NODE_20186_length_151_cov_1.034483_g20056_i0 | PRJEB14664 | 20186 | 151 | 1.034483 | 1.56206933 | Peredibacter sp. HCB2-198 | 3383025 | Bacteria | Bacteria | 87.9 | 3.38e-13 | NTclustered | gi|2867657404|gb|CP174607.1| | 3383025 | g20056 | i0 | 81.308 | 0.708609271523179 | 107 | 20 | 71 | 0 | 43 | 149 | 3861887 | 3861993 | Peredibacter sp. HCB2-198 chromosome, complete genome | blastn | 107 | 87.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter sp. HCB2-198 | ||
| 7673380 | 7673380 | PRJEB14664_P_NODE_14427_length_188_cov_1.568627_g14297_i0 | PRJEB14664 | 14427 | 188 | 1.568627 | 2.94901876 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 167 | 5.509999999999999e-37 | NTclustered | gi|469926873|gb|CP003538.1| | 349215 | g14297 | i0 | 88.889 | 72.8776595744681 | 135 | 15 | 72 | 0 | 3 | 137 | 1544969 | 1544835 | Micavibrio aeruginosavorus EPB, complete genome | blastn | 13701 | 167 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 7673494 | 7673494 | PRJEB14664_P_NODE_5967_length_340_cov_1.196721_g5837_i0 | PRJEB14664 | 5967 | 340 | 1.196721 | 4.0688514 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 189 | 2.6400000000000007e-59 | NR | MCB0369869.1 | 2053517 | g5837 | i0 | 81.3 | 0.988235294117647 | 112 | 21 | 98.8 | 0 | 336 | 1 | 1 | 112 | MCB0369869.1 uL15 family ribosomal protein [Bdellovibrionales bacterium] | diamond | 336 | 189 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 7673506 | 7673506 | PRJEB14664_P_NODE_6927_length_309_cov_1.813869_g6797_i0 | PRJEB14664 | 6927 | 309 | 1.813869 | 5.60485521 | Peredibacter sp. HCB2-198 | 3383025 | Bacteria | Bacteria | 459 | 1.46e-124 | NTclustered | gi|2867657404|gb|CP174607.1| | 3383025 | g6797 | i0 | 93.528 | 464.957928802589 | 309 | 19 | 100 | 1 | 1 | 309 | 1292920 | 1293227 | Peredibacter sp. HCB2-198 chromosome, complete genome | blastn | 143672 | 459 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter sp. HCB2-198 | ||
| 8948291 | 8948291 | PRJEB14664_P_NODE_9688_length_247_cov_1.759434_g9558_i0 | PRJEB14664 | 9688 | 247 | 1.759434 | 4.34580198 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 103 | 4.68e-26 | NR | MCB0369389.1 | 2053517 | g9558 | i0 | 71 | 0.838056680161943 | 69 | 19 | 83.8 | 1 | 41 | 247 | 25 | 92 | MCB0369389.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 207 | 103 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 21697889 | 21697889 | PRJEB14664_P_NODE_15318_length_180_cov_1.924138_g15188_i0 | PRJEB14664 | 15318 | 180 | 1.924138 | 3.4634484 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 233 | 5.08e-57 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g15188 | i0 | 90.11 | 9.56111111111111 | 182 | 14 | 100 | 3 | 1 | 180 | 510888 | 510709 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 1721 | 233 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 22662701 | 22662701 | PRJEB14664_P_NODE_3098_length_512_cov_5.643606_g2976_i0 | PRJEB14664 | 3098 | 512 | 5.643606 | 28.89526272 | Bacteriovorax | 146784 | Bacteria | Bacteria | 564 | 5.21e-156 | NTclustered | gi|1700689994|gb|CP030035.1| | 960 | g2976 | i0 | 86.745 | 139.119140625 | 513 | 60 | 99 | 8 | 4 | 512 | 1660853 | 1660345 | Bacteriovorax stolpii strain AC01 chromosome, complete genome | blastn | 71229 | 564 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 26843402 | 26843402 | PRJEB14664_P_NODE_9501_length_251_cov_1.291667_g9371_i0 | PRJEB14664 | 9501 | 251 | 1.291667 | 3.24208417 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 116 | 3.829999999999999e-31 | NR | MCB0368309.1 | 2053517 | g9371 | i0 | 71.1 | 0.99203187250996006 | 83 | 24 | 99.2 | 0 | 3 | 251 | 17 | 99 | MCB0368309.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 249 | 116 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28043794 | 28043794 | PRJEB14664_P_NODE_11725_length_216_cov_2.038674_g11595_i0 | PRJEB14664 | 11725 | 216 | 2.038674 | 4.40353584 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 94 | 1.48e-22 | NR | MCB0368309.1 | 2053517 | g11595 | i0 | 70.4 | 0.986111111111111 | 71 | 21 | 98.6 | 0 | 214 | 2 | 29 | 99 | MCB0368309.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 213 | 94 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29464217 | 29464217 | PRJEB14664_P_NODE_4670_length_400_cov_1.884932_g4540_i0 | PRJEB14664 | 4670 | 400 | 1.884932 | 7.539728 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 223 | 1.6299999999999998e-72 | NR | MCB0369869.1 | 2053517 | g4540 | i0 | 84.1 | 0.99 | 132 | 21 | 99 | 0 | 397 | 2 | 1 | 132 | MCB0369869.1 uL15 family ribosomal protein [Bdellovibrionales bacterium] | diamond | 396 | 223 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29622060 | 29622060 | PRJEB14664_P_NODE_6090_length_335_cov_2.266667_g5960_i0 | PRJEB14664 | 6090 | 335 | 2.266667 | 7.59333445 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 45.8 | 0.00914 | NR | MCB0348069.1 | 2053517 | g5960 | i0 | 48 | 0.447761194029851 | 50 | 23 | 44.8 | 1 | 153 | 302 | 409 | 455 | MCB0348069.1 PKD domain-containing protein [Bdellovibrionales bacterium] | diamond | 150 | 45.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29780346 | 29780346 | PRJEB14664_P_NODE_16691_length_170_cov_1.481481_g16561_i0 | PRJEB14664 | 16691 | 170 | 1.481481 | 2.5185177 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 85.9 | 1.23e-19 | NR | MCB0370359.1 | 2053517 | g16561 | i0 | 80.9 | 0.829411764705882 | 47 | 9 | 82.9 | 0 | 30 | 170 | 18 | 64 | MCB0370359.1 cation transporting ATPase C-terminal domain-containing protein [Bdellovibrionales bacterium] | diamond | 141 | 85.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29906835 | 29906835 | PRJEB14664_P_NODE_15571_length_178_cov_1.958042_g15441_i0 | PRJEB14664 | 15571 | 178 | 1.958042 | 3.48531476 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 97.4 | 4.319999999999999e-24 | NR | MCB0370715.1 | 2053517 | g15441 | i0 | 79.7 | 0.99438202247191 | 59 | 12 | 99.4 | 0 | 2 | 178 | 84 | 142 | MCB0370715.1 fibrillarin-like rRNA/tRNA 2'-O-methyltransferase [Bdellovibrionales bacterium] | diamond | 177 | 97.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31518510 | 31518510 | PRJEB14664_P_NODE_9976_length_242_cov_1.913043_g9846_i0 | PRJEB14664 | 9976 | 242 | 1.913043 | 4.62956406 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 119 | 4.72e-32 | NR | MCB0369646.1 | 2053517 | g9846 | i0 | 66.7 | 1.07851239669421 | 87 | 22 | 99.2 | 1 | 240 | 1 | 10 | 96 | MCB0369646.1 50S ribosomal protein L22 [Bdellovibrionales bacterium] | diamond | 261 | 119 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31644769 | 31644769 | PRJEB14664_P_NODE_9377_length_253_cov_1.467890_g9247_i0 | PRJEB14664 | 9377 | 253 | 1.46789 | 3.7137617 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 143 | 3.07e-42 | NR | MCB0370921.1 | 2053517 | g9247 | i0 | 79.5 | 0.984189723320158 | 83 | 17 | 98.4 | 0 | 3 | 251 | 6 | 88 | MCB0370921.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 249 | 143 | 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);;