contig_metadata
10 rows where bioproject = "PRJEB41113", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26994876 | 26994876 | PRJEB41113_S_NODE_2922_length_209_cov_1.563953_g2913_i0 | PRJEB41113 | 2922 | 209 | 1.563953 | 3.26866177 | Bdellovibrio | 958 | Bacteria | Bacteria | 48.5 | 1.2e-4 | NR | WP_415063881.1 | 28201 | g2913 | i0 | 53.8 | 1.19138755980861 | 39 | 18 | 56 | 0 | 118 | 2 | 7 | 45 | WP_415063881.1 hypothetical protein [Bdellovibrio sp.] | diamond | 249 | 48.9 | 0.991820040899796 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 28012806 | 28012806 | PRJEB41113_S_NODE_6785_length_175_cov_10.681159_g6776_i0 | PRJEB41113 | 6785 | 175 | 10.681159 | 18.69202825 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 68.6 | 1.13e-11 | NR | MCO5113943.1 | 2026715 | g6776 | i0 | 58.5 | 0.908571428571429 | 53 | 22 | 90.9 | 0 | 169 | 11 | 239 | 291 | MCO5113943.1 HD domain-containing protein [Pseudobdellovibrionaceae bacterium] | diamond | 159 | 68.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 29464628 | 29464628 | PRJEB41113_S_NODE_13750_length_152_cov_2.965217_g13741_i0 | PRJEB41113 | 13750 | 152 | 2.965217 | 4.50712984 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 58.9 | 1.34e-8 | NR | MBA2405754.1 | 2053517 | g13741 | i0 | 50 | 0.986842105263158 | 50 | 25 | 98.7 | 0 | 2 | 151 | 130 | 179 | MBA2405754.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 150 | 58.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29685715 | 29685715 | PRJEB41113_S_NODE_7030_length_174_cov_3.167883_g7021_i0 | PRJEB41113 | 7030 | 174 | 3.167883 | 5.51211642 | Bdellovibrionia bacterium | 3034169 | Bacteria | Bacteria | 84 | 2.16e-19 | NR | MEQ1877469.1 | 3034169 | g7021 | i0 | 78.4 | 1.74137931034483 | 51 | 11 | 87.9 | 0 | 1 | 153 | 43 | 93 | MEQ1877469.1 XRE family transcriptional regulator [Bdellovibrionia bacterium] | diamond | 303 | 84 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionia bacterium | |||||
| 29742297 | 29742297 | PRJEB41113_S_NODE_4730_length_189_cov_3.776316_g4721_i0 | PRJEB41113 | 4730 | 189 | 3.776316 | 7.13723724 | Bdellovibrionota | 3018035 | Bacteria | Bacteria | 90.5 | 9.57e-21 | NR | WP_321393174.1 | 28202 | g4721 | i0 | 84 | 1.58730158730159 | 50 | 8 | 79.4 | 0 | 3 | 152 | 151 | 200 | WP_321393174.1 CPBP family intramembrane glutamic endopeptidase [Peredibacter starrii] | diamond | 300 | 91.3 | 0.991237677984666 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 30854896 | 30854896 | PRJEB41113_S_NODE_12974_length_153_cov_2.508621_g12965_i0 | PRJEB41113 | 12974 | 153 | 2.508621 | 3.83819013 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 60.1 | 8.1e-9 | NR | MBA2403405.1 | 2053517 | g12965 | i0 | 61.2 | 0.96078431372549 | 49 | 19 | 96.1 | 0 | 3 | 149 | 282 | 330 | MBA2403405.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 147 | 60.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31233931 | 31233931 | PRJEB41113_S_NODE_2935_length_208_cov_10.251462_g2926_i0 | PRJEB41113 | 2935 | 208 | 10.251462 | 21.32304096 | Halobacteriovorax sp. | 2020862 | Bacteria | Bacteria | 70.9 | 2.62e-12 | NR | MBH48932.1 | 2020862 | g2926 | i0 | 43.1 | 0.9375 | 65 | 37 | 93.8 | 0 | 3 | 197 | 352 | 416 | MBH48932.1 hypothetical protein [Halobacteriovorax sp.] | diamond | 195 | 70.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovorax | Halobacteriovorax sp. | ||
| 31455599 | 31455599 | PRJEB41113_S_NODE_3776_length_197_cov_3.743750_g3767_i0 | PRJEB41113 | 3776 | 197 | 3.74375 | 7.3751875 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 103 | 1.65e-25 | NR | HXH32036.1 | 2081706 | g3767 | i0 | 65.1 | 0.959390862944162 | 63 | 22 | 95.9 | 0 | 191 | 3 | 106 | 168 | HXH32036.1 prolipoprotein diacylglyceryl transferase family protein [Bacteriovoracaceae bacterium] | diamond | 189 | 103 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 31765098 | 31765098 | PRJEB41113_S_NODE_5837_length_182_cov_2.062069_g5828_i0 | PRJEB41113 | 5837 | 182 | 2.062069 | 3.75296558 | Bdellovibrio | 958 | Bacteria | Bacteria | 117 | 2.36e-29 | NR | WP_088616813.1 | 1732569 | g5828 | i0 | 91.7 | 2.96703296703297 | 60 | 5 | 98.9 | 0 | 180 | 1 | 79 | 138 | WP_088616813.1 M16 family metallopeptidase [Bdellovibrio sp. SKB1291214] | diamond | 540 | 117 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. SKB1291214 | ||
| 31891660 | 31891660 | PRJEB41113_S_NODE_417_length_318_cov_1.747331_g408_i0 | PRJEB41113 | 417 | 318 | 1.747331 | 5.55651258 | Bacteria | 2 | Bacteria | Bacteria | 165 | 9.56e-45 | NR | HXH31216.1 | 2081706 | g408 | i0 | 75.5 | 3.88679245283019 | 106 | 26 | 100 | 0 | 1 | 318 | 739 | 844 | HXH31216.1 tetratricopeptide repeat protein [Bacteriovoracaceae bacterium] | diamond | 1236 | 165 | 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);;