contig_metadata
15 rows where bioproject = "PRJNA1123309", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 278322 | 278322 | PRJNA1123309_P_NODE_30961_length_293_cov_1.381818_g30581_i0 | PRJNA1123309 | 30961 | 293 | 1.381818 | 4.04872674 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 477 | 3.78e-130 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g30581 | i0 | 96.528 | 295.740614334471 | 288 | 10 | 98 | 0 | 6 | 293 | 511374 | 511661 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 86652 | 477 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 13031854 | 13031854 | PRJNA1123309_P_NODE_26011_length_316_cov_1.526749_g25631_i0 | PRJNA1123309 | 26011 | 316 | 1.526749 | 4.82452684 | Bdellovibrio sp. qaytius | 1916293 | Bacteria | Bacteria | 52.8 | 0.03 | NTclustered | gi|1552089877|gb|CP025734.1| | 1916293 | g25631 | i0 | 96.875 | 0.10126582278481 | 32 | 0 | 10 | 1 | 134 | 164 | 2476842 | 2476873 | Bdellovibrio sp. qaytius chromosome, complete genome | blastn | 32 | 52.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. qaytius | ||
| 15056772 | 15056772 | PRJNA1123309_P_NODE_62232_length_244_cov_0.912281_g61852_i0 | PRJNA1123309 | 62232 | 244 | 0.912281 | 2.22596564 | Bdellovibrionia bacterium | 3034169 | Bacteria | Bacteria | 109 | 2.63e-26 | NR | MFL5814622.1 | 3034169 | g61852 | i0 | 93.2 | 0.725409836065574 | 59 | 4 | 72.5 | 0 | 178 | 2 | 1 | 59 | MFL5814622.1 sigma-54 interaction domain-containing protein [Bdellovibrionia bacterium] | diamond | 177 | 109 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionia bacterium | |||||
| 18129803 | 18129803 | PRJNA1123309_P_NODE_13055_length_423_cov_1.780000_g12679_i0 | PRJNA1123309 | 13055 | 423 | 1.78 | 7.5294 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 684 | 0 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g12679 | i0 | 96.181 | 151.03073286052 | 419 | 14 | 99 | 1 | 7 | 423 | 512140 | 511722 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 63886 | 684 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 27449592 | 27449592 | PRJNA1123309_P_NODE_61563_length_245_cov_0.906977_g61183_i0 | PRJNA1123309 | 61563 | 245 | 0.906977 | 2.22209365 | Oligoflexus sp. | 1971216 | Bacteria | Bacteria | 150 | 5.219999999999999e-43 | NR | MBC7530283.1 | 1971216 | g61183 | i0 | 89.6 | 1.88571428571429 | 77 | 8 | 94.3 | 0 | 9 | 239 | 59 | 135 | MBC7530283.1 YmdB family metallophosphoesterase [Oligoflexus sp.] | diamond | 462 | 150 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexaceae | Oligoflexus | Oligoflexus sp. | ||
| 28007153 | 28007153 | PRJNA1123309_P_NODE_32865_length_288_cov_1.390698_g32485_i0 | PRJNA1123309 | 32865 | 288 | 1.390698 | 4.00521024 | Bacteria | 2 | Bacteria | Bacteria | 137 | 1.68e-35 | NR | OFZ12845.1 | 1797384 | g32485 | i0 | 68.2 | 1.83333333333333 | 88 | 28 | 91.7 | 0 | 265 | 2 | 334 | 421 | OFZ12845.1 MAG: hypothetical protein A2X86_08430 [Bdellovibrionales bacterium GWA2_49_15] | diamond | 528 | 137 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium GWA2_49_15 | ||||
| 28428298 | 28428298 | PRJNA1123309_P_NODE_63206_length_244_cov_0.912281_g62826_i0 | PRJNA1123309 | 63206 | 244 | 0.912281 | 2.22596564 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 120 | 2.0099999999999997e-30 | NR | MBA2404888.1 | 2053517 | g62826 | i0 | 83.1 | 0.94672131147541 | 77 | 13 | 94.7 | 0 | 233 | 3 | 295 | 371 | MBA2404888.1 ABC transporter substrate-binding protein [Bdellovibrionales bacterium] | diamond | 231 | 120 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29690825 | 29690825 | PRJNA1123309_P_NODE_33550_length_286_cov_1.849765_g33170_i0 | PRJNA1123309 | 33550 | 286 | 1.849765 | 5.2903279 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 144 | 4.08e-41 | NR | MBX9767865.1 | 2053517 | g33170 | i0 | 90.8 | 0.797202797202797 | 76 | 7 | 79.7 | 0 | 59 | 286 | 1 | 76 | MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 228 | 144 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29817317 | 29817317 | PRJNA1123309_P_NODE_62431_length_244_cov_0.912281_g62051_i0 | PRJNA1123309 | 62431 | 244 | 0.912281 | 2.22596564 | Bdellovibrionia bacterium | 3034169 | Bacteria | Bacteria | 63.9 | 3.19e-11 | NR | MFL5815226.1 | 3034169 | g62051 | i0 | 75 | 0.442622950819672 | 36 | 9 | 44.3 | 0 | 109 | 2 | 10 | 45 | MFL5815226.1 hypothetical protein [Bdellovibrionia bacterium] | diamond | 108 | 63.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionia bacterium | |||||
| 30133049 | 30133049 | PRJNA1123309_P_NODE_61112_length_245_cov_0.906977_g60732_i0 | PRJNA1123309 | 61112 | 245 | 0.906977 | 2.22209365 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 104 | 7.420000000000001e-27 | NR | WP_321398416.1 | 28202 | g60732 | i0 | 84.4 | 0.783673469387755 | 64 | 10 | 78.4 | 0 | 4 | 195 | 60 | 123 | WP_321398416.1 30S ribosome-binding factor RbfA [Peredibacter starrii] | diamond | 192 | 104 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 30196409 | 30196409 | PRJNA1123309_P_NODE_55232_length_248_cov_1.325714_g54852_i0 | PRJNA1123309 | 55232 | 248 | 1.325714 | 3.28777072 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 59.3 | 5.63e-8 | NR | MBS1968655.1 | 2053517 | g54852 | i0 | 42.3 | 1.80241935483871 | 71 | 41 | 85.9 | 0 | 3 | 215 | 148 | 218 | MBS1968655.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 447 | 59.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31555817 | 31555817 | PRJNA1123309_P_NODE_39376_length_272_cov_1.417085_g38996_i0 | PRJNA1123309 | 39376 | 272 | 1.417085 | 3.8544712 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 48.1 | 3.38e-4 | NR | MDX9730915.1 | 2053517 | g38996 | i0 | 32.7 | 0.606617647058823 | 55 | 37 | 60.7 | 0 | 171 | 7 | 32 | 86 | MDX9730915.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 165 | 48.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31776926 | 31776926 | PRJNA1123309_P_NODE_58977_length_246_cov_0.901734_g58597_i0 | PRJNA1123309 | 58977 | 246 | 0.901734 | 2.21826564 | Oligoflexus sp. | 1971216 | Bacteria | Bacteria | 118 | 1.13e-28 | NR | MBC7530237.1 | 1971216 | g58597 | i0 | 75 | 1.8780487804878 | 76 | 17 | 92.7 | 1 | 14 | 241 | 733 | 806 | MBC7530237.1 protein kinase [Oligoflexus sp.] | diamond | 462 | 118 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexaceae | Oligoflexus | Oligoflexus sp. | ||
| 31808597 | 31808597 | PRJNA1123309_P_NODE_40097_length_270_cov_1.771574_g39717_i0 | PRJNA1123309 | 40097 | 270 | 1.771574 | 4.7832498 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 64.7 | 9.35e-10 | NR | MCM2323379.1 | 2599941 | g39717 | i0 | 41.9 | 0.955555555555556 | 86 | 44 | 95.6 | 1 | 260 | 3 | 186 | 265 | MCM2323379.1 hypothetical protein [Oligoflexia bacterium] | diamond | 258 | 64.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 32219975 | 32219975 | PRJNA1123309_P_NODE_61338_length_245_cov_0.906977_g60958_i0 | PRJNA1123309 | 61338 | 245 | 0.906977 | 2.22209365 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 58.2 | 1.42e-7 | NR | WP_321398586.1 | 28202 | g60958 | i0 | 32.1 | 0.955102040816327 | 78 | 49 | 94.3 | 2 | 14 | 244 | 687 | 761 | WP_321398586.1 hypothetical protein [Peredibacter starrii] | diamond | 234 | 58.2 | 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);;