contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA861969" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 846251 | 846251 | PRJNA861969_P_NODE_23741_length_281_cov_1.480769_g23510_i0 | PRJNA861969 | 23741 | 281 | 1.480769 | 4.16096089 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 136 | 2.98e-36 | NR | MFA5582961.1 | 2081706 | g23510 | i0 | 84.9 | 1.98576512455516 | 93 | 12 | 99.3 | 2 | 3 | 281 | 137 | 227 | MFA5582961.1 2-oxoglutarate dehydrogenase complex dihydrolipoyllysine-residue succinyltransferase [Bacteriovoracaceae bacterium] | diamond | 558 | 136 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 26706634 | 26706634 | PRJNA861969_P_NODE_26101_length_270_cov_1.807107_g25870_i0 | PRJNA861969 | 26101 | 270 | 1.807107 | 4.8791889 | Bacteriovoracia bacterium | 3058048 | Bacteria | Bacteria | 75.1 | 1.12e-13 | NR | MFP5386446.1 | 3058048 | g25870 | i0 | 60.3 | 1.43333333333333 | 63 | 25 | 70 | 0 | 9 | 197 | 249 | 311 | MFP5386446.1 LysR substrate-binding domain-containing protein [Bacteriovoracia bacterium] | diamond | 387 | 75.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracia bacterium | |||||
| 27094856 | 27094856 | PRJNA861969_P_NODE_32922_length_249_cov_0.875000_g32691_i0 | PRJNA861969 | 32922 | 249 | 0.875 | 2.17875 | Peredibacter | 263370 | Bacteria | Bacteria | 108 | 1.42e-27 | NR | WP_321398410.1 | 28202 | g32691 | i0 | 92.5 | 1.27710843373494 | 53 | 4 | 63.9 | 0 | 91 | 249 | 1 | 53 | WP_321398410.1 hypothetical protein [Peredibacter starrii] | diamond | 318 | 109 | 0.990825688073395 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 28255155 | 28255155 | PRJNA861969_P_NODE_38966_length_243_cov_1.541176_g38735_i0 | PRJNA861969 | 38966 | 243 | 1.541176 | 3.74505768 | Bacteriovoracia bacterium | 3058048 | Bacteria | Bacteria | 120 | 7.22e-33 | NR | MFP5385619.1 | 3058048 | g38735 | i0 | 82.6 | 0.851851851851852 | 69 | 12 | 85.2 | 0 | 241 | 35 | 62 | 130 | MFP5385619.1 Cu(I)-responsive transcriptional regulator [Bacteriovoracia bacterium] | diamond | 207 | 120 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracia bacterium | |||||
| 29644124 | 29644124 | PRJNA861969_P_NODE_40250_length_242_cov_0.911243_g40019_i0 | PRJNA861969 | 40250 | 242 | 0.911243 | 2.20520806 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 64.3 | 5.78e-10 | NR | PZP57409.1 | 349221 | g40019 | i0 | 50.8 | 0.756198347107438 | 61 | 28 | 75.6 | 1 | 223 | 41 | 29 | 87 | PZP57409.1 MAG: hypothetical protein DI586_00525 [Micavibrio aeruginosavorus] | diamond | 183 | 64.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 30466143 | 30466143 | PRJNA861969_P_NODE_35213_length_247_cov_0.885057_g34982_i0 | PRJNA861969 | 35213 | 247 | 0.885057 | 2.18609079 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 131 | 6.82e-35 | NR | MFA5582641.1 | 2081706 | g34982 | i0 | 81.9 | 3.02429149797571 | 83 | 14 | 99.6 | 1 | 1 | 246 | 86 | 168 | MFA5582641.1 FAD-dependent oxidoreductase [Bacteriovoracaceae bacterium] | diamond | 747 | 131 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 30623641 | 30623641 | PRJNA861969_P_NODE_38133_length_244_cov_0.900585_g37902_i0 | PRJNA861969 | 38133 | 244 | 0.900585 | 2.1974274 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 72.4 | 2.29e-13 | NR | MBC7397709.1 | 2599941 | g37902 | i0 | 64.7 | 1.61065573770492 | 51 | 18 | 62.7 | 0 | 92 | 244 | 67 | 117 | MBC7397709.1 class I SAM-dependent methyltransferase [Oligoflexia bacterium] | diamond | 393 | 72.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 31318996 | 31318996 | PRJNA861969_P_NODE_21855_length_290_cov_1.285714_g21624_i0 | PRJNA861969 | 21855 | 290 | 1.285714 | 3.7285706 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 109 | 1.01e-28 | NR | HLT23004.1 | 2081706 | g21624 | i0 | 84.4 | 0.662068965517241 | 64 | 10 | 66.2 | 0 | 3 | 194 | 36 | 99 | HLT23004.1 hypothetical protein [Bacteriovoracaceae bacterium] | diamond | 192 | 109 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 31983211 | 31983211 | PRJNA861969_P_NODE_38118_length_244_cov_0.900585_g37887_i0 | PRJNA861969 | 38118 | 244 | 0.900585 | 2.1974274 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 91.3 | 5.33e-20 | NR | WP_321397156.1 | 28202 | g37887 | i0 | 53.1 | 0.995901639344262 | 81 | 37 | 99.6 | 1 | 244 | 2 | 159 | 238 | WP_321397156.1 hypothetical protein [Peredibacter starrii] | diamond | 243 | 91.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 32118149 | 32118149 | PRJNA861969_P_NODE_28158_length_261_cov_1.638298_g27927_i0 | PRJNA861969 | 28158 | 261 | 1.638298 | 4.27595778 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 60.1 | 2.21e-8 | NR | WP_132326157.1 | 1513793 | g27927 | i0 | 45 | 1.40229885057471 | 60 | 33 | 69 | 0 | 260 | 81 | 195 | 254 | WP_132326157.1 ABC transporter permease subunit [Pseudobacteriovorax antillogorgiicola] | diamond | 366 | 60.5 | 0.993388429752066 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Pseudobacteriovoracaceae | Pseudobacteriovorax | Pseudobacteriovorax antillogorgiicola | ||
| 32615886 | 32615886 | PRJNA861969_P_NODE_25760_length_272_cov_1.356784_g25529_i0 | PRJNA861969 | 25760 | 272 | 1.356784 | 3.69045248 | Oligoflexus sp. | 1971216 | Bacteria | Bacteria | 124 | 1.8799999999999999e-31 | NR | MBC7530114.1 | 1971216 | g25529 | i0 | 65.6 | 0.992647058823529 | 90 | 31 | 99.3 | 0 | 270 | 1 | 346 | 435 | MBC7530114.1 isochorismate synthase [Oligoflexus sp.] | diamond | 270 | 124 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexaceae | Oligoflexus | Oligoflexus sp. | ||
| 32899105 | 32899105 | PRJNA861969_P_NODE_36780_length_245_cov_1.790698_g36549_i0 | PRJNA861969 | 36780 | 245 | 1.790698 | 4.3872101 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 115 | 4.26e-28 | NR | HLT22217.1 | 2081706 | g36549 | i0 | 64.2 | 0.991836734693878 | 81 | 29 | 99.2 | 0 | 3 | 245 | 57 | 137 | HLT22217.1 hypothetical protein [Bacteriovoracaceae bacterium] | diamond | 243 | 115 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae 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);;