contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA572587" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5662848 | 5662848 | PRJNA572587_P_NODE_46725_length_161_cov_3.196429_g46397_i0 | PRJNA572587 | 46725 | 161 | 3.196429 | 5.14625069 | Peredibacter | 263370 | Bacteria | Bacteria | 75.9 | 1.53e-14 | NR | WP_321389441.1 | 28202 | g46397 | i0 | 76.7 | 1.60248447204969 | 43 | 10 | 80.1 | 0 | 159 | 31 | 158 | 200 | WP_321389441.1 hypothetical protein [Peredibacter starrii] | diamond | 258 | 76.3 | 0.99475753604194 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 28153556 | 28153556 | PRJNA572587_P_NODE_31065_length_199_cov_11.213333_g30737_i0 | PRJNA572587 | 31065 | 199 | 11.213333 | 22.31453267 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 53.5 | 3.17e-6 | NR | MEO5668519.1 | 3034175 | g30737 | i0 | 42.4 | 1.98994974874372 | 66 | 36 | 98 | 2 | 199 | 5 | 29 | 93 | MEO5668519.1 hypothetical protein [Bdellovibrionota bacterium] | diamond | 396 | 53.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 29573979 | 29573979 | PRJNA572587_P_NODE_35310_length_185_cov_23.566176_g34982_i0 | PRJNA572587 | 35310 | 185 | 23.566176 | 43.5974256 | Bdellovibrionales bacterium GWB1_55_8 | 1797386 | Bacteria | Bacteria | 67.4 | 2.98e-11 | NR | OFZ20096.1 | 1797386 | g34982 | i0 | 64.3 | 1.81621621621622 | 56 | 20 | 90.8 | 0 | 3 | 170 | 262 | 317 | OFZ20096.1 MAG: hypothetical protein A2X94_09300 [Bdellovibrionales bacterium GWB1_55_8] | diamond | 336 | 67.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium GWB1_55_8 | ||||
| 30061324 | 30061324 | PRJNA572587_P_NODE_29331_length_205_cov_11.916667_g29003_i0 | PRJNA572587 | 29331 | 205 | 11.916667 | 24.42916735 | Bdellovibrio | 958 | Bacteria | Bacteria | 84 | 3.85e-19 | NR | WP_142697577.1 | 2220073 | g29003 | i0 | 68.4 | 2.50243902439024 | 57 | 18 | 83.4 | 0 | 195 | 25 | 45 | 101 | WP_142697577.1 polyhydroxyalkanoic acid system family protein [Bdellovibrio sp. NC01] | diamond | 513 | 84 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. NC01 | ||
| 30269343 | 30269343 | PRJNA572587_P_NODE_16072_length_286_cov_5.443038_g15744_i0 | PRJNA572587 | 16072 | 286 | 5.443038 | 15.56708868 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 67 | 1.88e-10 | NR | HLD99388.1 | 3034175 | g15744 | i0 | 58.8 | 1.04895104895105 | 51 | 21 | 53.5 | 0 | 210 | 58 | 744 | 794 | HLD99388.1 hypothetical protein [Bdellovibrionota bacterium] | diamond | 300 | 67 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 31768190 | 31768190 | PRJNA572587_P_NODE_7617_length_440_cov_200.370844_g7292_i0 | PRJNA572587 | 7617 | 440 | 200.370844 | 881.6317136 | Peredibacter | 263370 | Bacteria | Bacteria | 108 | 3.62e-24 | NR | WP_321394767.1 | 28202 | g7292 | i0 | 72.4 | 1.76590909090909 | 87 | 22 | 58 | 1 | 283 | 29 | 102 | 188 | WP_321394767.1 TrkH family potassium uptake protein [Peredibacter starrii] | diamond | 777 | 109 | 0.990825688073395 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 31912821 | 31912821 | PRJNA572587_P_NODE_18857_length_262_cov_3.497653_g18529_i0 | PRJNA572587 | 18857 | 262 | 3.497653 | 9.16385086 | Oligoflexales bacterium | 2687297 | Bacteria | Bacteria | 50.4 | 3.45e-5 | NR | MBF0443082.1 | 2687297 | g18529 | i0 | 34.3 | 0.767175572519084 | 67 | 25 | 55 | 1 | 118 | 261 | 51 | 117 | MBF0443082.1 hypothetical protein [Oligoflexales bacterium] | diamond | 201 | 50.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexales bacterium | ||||
| 32545853 | 32545853 | PRJNA572587_P_NODE_22019_length_240_cov_83.162304_g21691_i0 | PRJNA572587 | 22019 | 240 | 83.162304 | 199.5895296 | Bdellovibrio bacteriovorus | 959 | Bacteria | Bacteria | 89 | 1.97e-18 | NR | WP_063205553.1 | 959 | g21691 | i0 | 50.7 | 2.7375 | 73 | 36 | 91.3 | 0 | 22 | 240 | 30 | 102 | WP_063205553.1 replication restart helicase PriA [Bdellovibrio bacteriovorus] | diamond | 657 | 89 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus |
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);;