contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA700095" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30240759 | 30240759 | PRJNA700095_P_NODE_26152_length_335_cov_2.637405_g24888_i0 | PRJNA700095 | 26152 | 335 | 2.6374050000000002 | 8.83530675 | Silvanigrellaceae bacterium | 2654442 | Bacteria | Bacteria | 70.9 | 1.07e-13 | NR | MBX9703359.1 | 2654442 | g24888 | i0 | 64.3 | 0.376119402985075 | 42 | 15 | 37.6 | 0 | 293 | 168 | 1 | 42 | MBX9703359.1 hypothetical protein [Silvanigrellaceae bacterium] | diamond | 126 | 70.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellaceae | Silvanigrellaceae bacterium | |||
| 30335923 | 30335923 | PRJNA700095_P_NODE_4512_length_928_cov_17.304094_g3582_i0 | PRJNA700095 | 4512 | 928 | 17.304094 | 160.58199232 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 375 | 4.78e-129 | NR | MBX9767865.1 | 2053517 | g3582 | i0 | 90.5 | 0.649784482758621 | 201 | 19 | 65 | 0 | 261 | 863 | 1 | 201 | MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 603 | 375 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30462310 | 30462310 | PRJNA700095_P_NODE_14893_length_480_cov_3.137592_g13632_i0 | PRJNA700095 | 14893 | 480 | 3.137592 | 15.0604416 | Bdellovibrionia bacterium | 3034169 | Bacteria | Bacteria | 140 | 1.69e-39 | NR | MEO5970318.1 | 3034169 | g13632 | i0 | 57.8 | 3.15625 | 128 | 48 | 79.4 | 2 | 381 | 1 | 2 | 124 | MEO5970318.1 hotdog fold thioesterase [Bdellovibrionia bacterium] | diamond | 1515 | 140 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionia bacterium | |||||
| 30493574 | 30493574 | PRJNA700095_P_NODE_58893_length_245_cov_1.691860_g57629_i0 | PRJNA700095 | 58893 | 245 | 1.69186 | 4.145057 | Bdellovibrio sp. GT3 | 3136282 | Bacteria | Bacteria | 42.4 | 0.0495 | NR | WP_340596188.1 | 3136282 | g57629 | i0 | 37.9 | 0.710204081632653 | 58 | 36 | 71 | 0 | 6 | 179 | 75 | 132 | WP_340596188.1 hypothetical protein [Bdellovibrio sp. GT3] | diamond | 174 | 42.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. GT3 | ||
| 30651210 | 30651210 | PRJNA700095_P_NODE_8173_length_692_cov_4.179321_g7006_i0 | PRJNA700095 | 8173 | 692 | 4.179321 | 28.92090132 | Pigmentibacter ruber | 2683196 | Bacteria | Bacteria | 90.5 | 1.37e-19 | NR | WP_158998151.1 | 2683196 | g7006 | i0 | 52.4 | 1.4393063583815 | 84 | 40 | 36.4 | 0 | 208 | 459 | 2 | 85 | WP_158998151.1 30S ribosomal protein S15 [Pigmentibacter ruber] | diamond | 996 | 90.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellaceae | Pigmentibacter | Pigmentibacter ruber | ||
| 30915568 | 30915568 | PRJNA700095_P_NODE_49494_length_254_cov_1.801105_g48230_i0 | PRJNA700095 | 49494 | 254 | 1.801105 | 4.5748067 | Bdellovibrio | 958 | Bacteria | Bacteria | 64.7 | 4.36e-11 | NR | WP_246845325.1 | 2220073 | g48230 | i0 | 44.6 | 7.88976377952756 | 56 | 31 | 66.1 | 0 | 253 | 86 | 65 | 120 | WP_246845325.1 DOPA 4,5-dioxygenase family protein [Bdellovibrio sp. NC01] | diamond | 2004 | 65.1 | 0.993855606758833 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. NC01 | ||
| 32528653 | 32528653 | PRJNA700095_P_NODE_15139_length_475_cov_3.256219_g13878_i0 | PRJNA700095 | 15139 | 475 | 3.256219 | 15.46704025 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 78.6 | 1.48e-13 | NR | MBC77950.1 | 2026745 | g13878 | i0 | 40.4 | 7.95789473684211 | 99 | 40 | 62.5 | 2 | 174 | 470 | 808 | 887 | MBC77950.1 hypothetical protein [Halobacteriovoraceae bacterium] | diamond | 3780 | 78.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovoraceae bacterium | |||
| 32863804 | 32863804 | PRJNA700095_P_NODE_16940_length_440_cov_2.264305_g15677_i0 | PRJNA700095 | 16940 | 440 | 2.264305 | 9.962942 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 213 | 1.4e-66 | NR | MBX9767866.1 | 2053517 | g15677 | i0 | 71.4 | 1.00227272727273 | 147 | 41 | 99.5 | 1 | 3 | 440 | 2 | 148 | MBX9767866.1 GTP-binding protein [Bdellovibrionales bacterium] | diamond | 441 | 213 | 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);;