contig_metadata
7 rows where bioproject = "PRJNA682370" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14693252 | 14693252 | PRJNA682370_S_NODE_18792_length_166_cov_1.496183_g18180_i0 | PRJNA682370 | 18792 | 166 | 1.496183 | 2.48366378 | Bdellovibrio bacteriovorus | 959 | Bacteria | Bacteria | 52.8 | 0.014 | NTclustered | gi|578016248|gb|CP002190.1| | 765869 | g18180 | i0 | 100 | 0.168674698795181 | 28 | 0 | 17 | 0 | 27 | 54 | 2423663 | 2423636 | Bdellovibrio bacteriovorus W, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 15203349 | 15203349 | PRJNA682370_S_NODE_4032_length_404_cov_4.861789_g3421_i0 | PRJNA682370 | 4032 | 404 | 4.861789 | 19.64162756 | Bacteriovorax | 146784 | Bacteria | Bacteria | 398 | 4.319999999999999e-106 | NTclustered | gi|1700689994|gb|CP030035.1| | 960 | g3421 | i0 | 84.559 | 184.027227722772 | 408 | 55 | 100 | 8 | 1 | 404 | 1660780 | 1660377 | Bacteriovorax stolpii strain AC01 chromosome, complete genome | blastn | 74347 | 398 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 19791357 | 19791357 | PRJNA682370_S_NODE_3456_length_442_cov_3.412776_g2851_i0 | PRJNA682370 | 3456 | 442 | 3.412776 | 15.08446992 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 143 | 4.84e-38 | NR | MCB0386755.1 | 2053517 | g2851 | i0 | 55.7 | 0.889140271493213 | 131 | 50 | 85.5 | 4 | 22 | 399 | 108 | 235 | MCB0386755.1 C1 family peptidase [Bdellovibrionales bacterium] | diamond | 393 | 143 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 19791364 | 19791364 | PRJNA682370_S_NODE_3636_length_430_cov_2.118987_g3030_i0 | PRJNA682370 | 3636 | 430 | 2.118987 | 9.1116441 | Bdellovibrio sp. HCB337 | 3394358 | Bacteria | Bacteria | 575 | 1.9899999999999994e-159 | NTclustered | gi|2895525383|gb|CP178621.1| | 3394358 | g3030 | i0 | 90.805 | 175.779069767442 | 435 | 33 | 99 | 4 | 1 | 428 | 3446993 | 3447427 | Bdellovibrio sp. HCB337 chromosome, complete genome | blastn | 75585 | 575 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB337 | ||
| 26892494 | 26892494 | PRJNA682370_S_NODE_7101_length_286_cov_1.940239_g6489_i0 | PRJNA682370 | 7101 | 286 | 1.940239 | 5.54908354 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 83.2 | 2.49e-16 | NR | MCB0386755.1 | 2053517 | g6489 | i0 | 44.1 | 0.975524475524476 | 93 | 46 | 93.4 | 4 | 267 | 1 | 266 | 356 | MCB0386755.1 C1 family peptidase [Bdellovibrionales bacterium] | diamond | 279 | 83.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27871749 | 27871749 | PRJNA682370_S_NODE_20885_length_159_cov_1.491935_g20273_i0 | PRJNA682370 | 20885 | 159 | 1.491935 | 2.37217665 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 42.7 | 0.0122 | NR | MCB0386755.1 | 2053517 | g20273 | i0 | 65.5 | 0.547169811320755 | 29 | 10 | 54.7 | 0 | 129 | 43 | 28 | 56 | MCB0386755.1 C1 family peptidase [Bdellovibrionales bacterium] | diamond | 87 | 42.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29639648 | 29639648 | PRJNA682370_S_NODE_20430_length_160_cov_3.344000_g19818_i0 | PRJNA682370 | 20430 | 160 | 3.344 | 5.3504 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 47.8 | 2.06e-4 | NR | MCB0386755.1 | 2053517 | g19818 | i0 | 57.1 | 0.65625 | 35 | 15 | 65.6 | 0 | 145 | 41 | 55 | 89 | MCB0386755.1 C1 family peptidase [Bdellovibrionales bacterium] | diamond | 105 | 47.8 | 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);;