contig_metadata
6 rows where bioproject = "PRJNA1009807", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5257705 | 5257705 | PRJNA1009807_S_NODE_1705_length_234_cov_18.589744_g1677_i0 | PRJNA1009807 | 1705 | 234 | 18.589744 | 43.50000096 | Bdellovibrio bacteriovorus | 959 | Bacteria | Bacteria | 296 | 8.77e-76 | NTclustered | gi|2800948966|gb|CP168973.1| | 959 | g1677 | i0 | 89.744 | 135.465811965812 | 234 | 20 | 99 | 4 | 2 | 233 | 815494 | 815725 | Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome | blastn | 31699 | 296 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 6532977 | 6532977 | PRJNA1009807_S_NODE_186_length_587_cov_12.062044_g165_i0 | PRJNA1009807 | 186 | 587 | 12.062044 | 70.80419828 | Bdellovibrio sp. HCB337 | 3394358 | Bacteria | Bacteria | 798 | 0 | NTclustered | gi|2895525383|gb|CP178621.1| | 3394358 | g165 | i0 | 91.092 | 105.829642248722 | 595 | 45 | 100 | 5 | 1 | 587 | 3447393 | 3446799 | Bdellovibrio sp. HCB337 chromosome, complete genome | blastn | 62122 | 798 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB337 | ||
| 8654527 | 8654527 | PRJNA1009807_S_NODE_187_length_585_cov_9.335165_g166_i0 | PRJNA1009807 | 187 | 585 | 9.335165 | 54.61071525 | Pseudobdellovibrio | 2862745 | Bacteria | Bacteria | 880 | 0 | NTclustered | gi|507148233|ref|NR_103040.1| | 453816 | g166 | i0 | 93.718 | 92.5504273504274 | 589 | 33 | 100 | 4 | 1 | 585 | 1733 | 1145 | Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence | blastn | 54142 | 880 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 12480244 | 12480244 | PRJNA1009807_S_NODE_630_length_367_cov_5.914634_g602_i0 | PRJNA1009807 | 630 | 367 | 5.914634 | 21.70670678 | Pseudobdellovibrio | 2862745 | Bacteria | Bacteria | 446 | 1.3699999999999999e-120 | NTclustered | gi|507148233|ref|NR_103040.1| | 453816 | g602 | i0 | 88.649 | 349.261580381471 | 370 | 37 | 100 | 5 | 1 | 367 | 500 | 133 | Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence | blastn | 128179 | 446 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 20555968 | 20555968 | PRJNA1009807_S_NODE_137_length_636_cov_19.266332_g118_i0 | PRJNA1009807 | 137 | 636 | 19.266332 | 122.53387152 | Bdellovibrio bacteriovorus | 959 | Bacteria | Bacteria | 979 | 0 | NTclustered | gi|2800948966|gb|CP168973.1| | 959 | g118 | i0 | 94.762 | 202.504716981132 | 630 | 32 | 99 | 1 | 8 | 636 | 1677583 | 1676954 | Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome | blastn | 128793 | 979 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 23953719 | 23953719 | PRJNA1009807_S_NODE_1079_length_292_cov_4.272727_g1051_i0 | PRJNA1009807 | 1079 | 292 | 4.272727 | 12.47636284 | Pseudobdellovibrio | 2862745 | Bacteria | Bacteria | 324 | 5.19e-84 | NTclustered | gi|507148233|ref|NR_103040.1| | 453816 | g1051 | i0 | 86.986 | 65.0068493150685 | 292 | 33 | 99 | 3 | 1 | 289 | 500 | 211 | Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence | blastn | 18982 | 324 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus |
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);;