contig_metadata
17 rows where bioproject = "PRJNA797475", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3332426 | 3332426 | PRJNA797475_P_NODE_19943_length_258_cov_1.248649_g19844_i0 | PRJNA797475 | 19943 | 258 | 1.248649 | 3.22151442 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 459 | 1.18e-124 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g19844 | i0 | 98.837 | 194.410852713178 | 258 | 1 | 99 | 1 | 3 | 258 | 511962 | 511705 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 50158 | 459 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 5884865 | 5884865 | PRJNA797475_P_NODE_16685_length_275_cov_1.153465_g16586_i0 | PRJNA797475 | 16685 | 275 | 1.153465 | 3.17202875 | uncultured Oligoflexales bacterium | 2735263 | Bacteria | Bacteria | 265 | 2.9799999999999995e-66 | NTclustered | gi|2531963191|emb|OY282434.1| | 2735263 | g16586 | i0 | 84.058 | 94.6727272727273 | 276 | 43 | 100 | 1 | 1 | 275 | 955395 | 955120 | MAG: uncultured Oligoflexales bacterium genome assembly, chromosome: 1 | blastn | 26035 | 265 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | uncultured Oligoflexales bacterium | ||||
| 5885103 | 5885103 | PRJNA797475_P_NODE_7445_length_374_cov_3.275748_g7346_i0 | PRJNA797475 | 7445 | 374 | 3.275748 | 12.25129752 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 196 | 6.51e-60 | NR | MCB0369725.1 | 2053517 | g7346 | i0 | 76.5 | 0.954545454545455 | 119 | 28 | 95.5 | 0 | 16 | 372 | 10 | 128 | MCB0369725.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 357 | 196 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 26904884 | 26904884 | PRJNA797475_P_NODE_25261_length_247_cov_0.885057_g25162_i0 | PRJNA797475 | 25261 | 247 | 0.885057 | 2.18609079 | Bacteria | 2 | Bacteria | Bacteria | 123 | 2.06e-30 | NR | MCM2348451.1 | 2081706 | g25162 | i0 | 68.3 | 1.9919028340081 | 82 | 26 | 99.6 | 0 | 2 | 247 | 963 | 1044 | MCM2348451.1 hypothetical protein [Bacteriovoracaceae bacterium] | diamond | 492 | 123 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 27527811 | 27527811 | PRJNA797475_P_NODE_24543_length_248_cov_0.880000_g24444_i0 | PRJNA797475 | 24543 | 248 | 0.88 | 2.1824 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 105 | 5.51e-25 | NR | WP_321393691.1 | 28202 | g24444 | i0 | 90.2 | 0.737903225806452 | 61 | 6 | 73.8 | 0 | 2 | 184 | 314 | 374 | WP_321393691.1 DUF1385 domain-containing protein [Peredibacter starrii] | diamond | 183 | 105 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 27622751 | 27622751 | PRJNA797475_P_NODE_6224_length_405_cov_1.259036_g6126_i0 | PRJNA797475 | 6224 | 405 | 1.259036 | 5.0990958 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 209 | 1.5099999999999998e-67 | NR | MCB0370659.1 | 2053517 | g6126 | i0 | 97.3 | 0.814814814814815 | 110 | 3 | 81.5 | 0 | 2 | 331 | 2 | 111 | MCB0370659.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 330 | 209 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28262978 | 28262978 | PRJNA797475_P_NODE_27406_length_244_cov_0.900585_g27307_i0 | PRJNA797475 | 27406 | 244 | 0.900585 | 2.1974274 | Bacteria | 2 | Bacteria | Bacteria | 139 | 5.49e-36 | NR | MCM2350982.1 | 2081706 | g27307 | i0 | 90 | 2.95081967213115 | 80 | 8 | 98.4 | 0 | 242 | 3 | 914 | 993 | MCM2350982.1 efflux RND transporter permease subunit [Bacteriovoracaceae bacterium] | diamond | 720 | 140 | 0.992857142857143 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 28380335 | 28380335 | PRJNA797475_P_NODE_8646_length_352_cov_1.512545_g8547_i0 | PRJNA797475 | 8646 | 352 | 1.512545 | 5.3241584 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 178 | 8.269999999999997e-55 | NR | MCB0369646.1 | 2053517 | g8547 | i0 | 86 | 0.852272727272727 | 100 | 14 | 85.2 | 0 | 51 | 350 | 46 | 145 | MCB0369646.1 50S ribosomal protein L22 [Bdellovibrionales bacterium] | diamond | 300 | 178 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28538454 | 28538454 | PRJNA797475_P_NODE_25987_length_246_cov_0.890173_g25888_i0 | PRJNA797475 | 25987 | 246 | 0.890173 | 2.18982558 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 146 | 1.99e-39 | NR | MCB0370360.1 | 2053517 | g25888 | i0 | 90.1 | 0.98780487804878 | 81 | 8 | 98.8 | 0 | 1 | 243 | 306 | 386 | MCB0370360.1 HAD-IC family P-type ATPase [Bdellovibrionales bacterium] | diamond | 243 | 146 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28569728 | 28569728 | PRJNA797475_P_NODE_14007_length_289_cov_1.254630_g13908_i0 | PRJNA797475 | 14007 | 289 | 1.25463 | 3.6258807 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 144 | 6.889999999999998e-41 | NR | MBA2404823.1 | 2053517 | g13908 | i0 | 72 | 0.965397923875433 | 93 | 26 | 96.5 | 0 | 282 | 4 | 34 | 126 | MBA2404823.1 M4 family metallopeptidase [Bdellovibrionales bacterium] | diamond | 279 | 144 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28633165 | 28633165 | PRJNA797475_P_NODE_29867_length_241_cov_1.375000_g29768_i0 | PRJNA797475 | 29867 | 241 | 1.375 | 3.31375 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 131 | 2.39e-34 | NR | MCB0368368.1 | 2053517 | g29768 | i0 | 81.3 | 0.995850622406639 | 80 | 15 | 99.6 | 0 | 241 | 2 | 135 | 214 | MCB0368368.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 240 | 131 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29201420 | 29201420 | PRJNA797475_P_NODE_24409_length_248_cov_0.880000_g24310_i0 | PRJNA797475 | 24409 | 248 | 0.88 | 2.1824 | Bacteriovoracia bacterium | 3058048 | Bacteria | Bacteria | 138 | 7.14e-38 | NR | MFP5387464.1 | 3058048 | g24310 | i0 | 74.1 | 0.979838709677419 | 81 | 21 | 98 | 0 | 1 | 243 | 226 | 306 | MFP5387464.1 ABC transporter ATP-binding protein [Bacteriovoracia bacterium] | diamond | 243 | 138 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracia bacterium | |||||
| 29652020 | 29652020 | PRJNA797475_P_NODE_26870_length_245_cov_0.895349_g26771_i0 | PRJNA797475 | 26870 | 245 | 0.895349 | 2.19360505 | Peredibacter | 263370 | Bacteria | Bacteria | 126 | 2.06e-32 | NR | WP_321398322.1 | 28202 | g26771 | i0 | 75.3 | 1.98367346938776 | 81 | 20 | 99.2 | 0 | 244 | 2 | 10 | 90 | WP_321398322.1 diaminopimelate decarboxylase [Peredibacter starrii] | diamond | 486 | 127 | 0.992125984251969 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 30654085 | 30654085 | PRJNA797475_P_NODE_12233_length_305_cov_1.327586_g12134_i0 | PRJNA797475 | 12233 | 305 | 1.327586 | 4.0491373 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 122 | 1.19e-30 | NR | MCB0369454.1 | 2053517 | g12134 | i0 | 56.3 | 1.01311475409836 | 103 | 39 | 95.4 | 1 | 13 | 303 | 11 | 113 | MCB0369454.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 309 | 122 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31001844 | 31001844 | PRJNA797475_P_NODE_8834_length_349_cov_1.115942_g8735_i0 | PRJNA797475 | 8834 | 349 | 1.115942 | 3.89463758 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 120 | 8.13e-32 | NR | MCB0369154.1 | 2053517 | g8735 | i0 | 67.9 | 0.696275071633238 | 81 | 26 | 69.6 | 0 | 344 | 102 | 46 | 126 | MCB0369154.1 C39 family peptidase [Bdellovibrionales bacterium] | diamond | 243 | 120 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32077038 | 32077038 | PRJNA797475_P_NODE_27398_length_244_cov_1.140351_g27299_i0 | PRJNA797475 | 27398 | 244 | 1.140351 | 2.78245644 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 68.9 | 2.19e-11 | NR | MCM2349899.1 | 2081706 | g27299 | i0 | 39.3 | 1.09426229508197 | 89 | 41 | 93.4 | 1 | 17 | 244 | 184 | 272 | MCM2349899.1 phospholipase D family protein [Bacteriovoracaceae bacterium] | diamond | 267 | 68.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 32235572 | 32235572 | PRJNA797475_P_NODE_17938_length_268_cov_1.579487_g17839_i0 | PRJNA797475 | 17938 | 268 | 1.579487 | 4.23302516 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 139 | 1.1099999999999999e-39 | NR | MCB0369154.1 | 2053517 | g17839 | i0 | 74.1 | 0.951492537313433 | 85 | 22 | 95.1 | 0 | 256 | 2 | 1 | 85 | MCB0369154.1 C39 family peptidase [Bdellovibrionales bacterium] | diamond | 255 | 139 | 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);;