contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJEB50332" and tax_phylum = "Uroviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27728921 | 27728921 | PRJEB50332_P_NODE_2024_length_395_cov_1.167665_g1943_i0 | PRJEB50332 | 2024 | 395 | 1.167665 | 4.61227675 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 127 | 6.2099999999999985e-34 | NR | XOR06219.1 | 2832643 | g1943 | i0 | 56.5 | 0.994936708860759 | 131 | 57 | 99.5 | 0 | 1 | 393 | 12 | 142 | XOR06219.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 393 | 127 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28486345 | 28486345 | PRJEB50332_P_NODE_16687_length_204_cov_0.909091_g16605_i0 | PRJEB50332 | 16687 | 204 | 0.909091 | 1.85454564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 57 | 8.75e-8 | NR | XOS25586.1 | 2832643 | g16605 | i0 | 44.9 | 1.01470588235294 | 69 | 37 | 100 | 1 | 1 | 204 | 60 | 128 | XOS25586.1 MAG: hypothetical protein MSP0005_221 [Caudoviricetes sp.] | diamond | 207 | 57 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29464716 | 29464716 | PRJEB50332_P_NODE_6890_length_242_cov_1.436464_g6808_i0 | PRJEB50332 | 6890 | 242 | 1.436464 | 3.47624288 | Achromobacter phage vB_AxyP_19-32_Axy11 | 2591042 | Viruses | Viruses | 78.6 | 9.16e-15 | NR | YP_010079427.1 | 2591042 | g6808 | i0 | 51.7 | 1.48760330578512 | 60 | 29 | 74.4 | 0 | 2 | 181 | 3375 | 3434 | YP_010079427.1 virion RNA polymerase [Achromobacter phage vB_AxyP_19-32_Axy11] | diamond | 360 | 78.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Pourcelvirus | Pourcelvirus Axy11 | |||
| 29685797 | 29685797 | PRJEB50332_P_NODE_6290_length_249_cov_1.957447_g6208_i0 | PRJEB50332 | 6290 | 249 | 1.957447 | 4.87404303 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 93.2 | 2.11e-22 | NR | XOR90598.1 | 2832643 | g6208 | i0 | 72.6 | 0.746987951807229 | 62 | 17 | 74.7 | 0 | 3 | 188 | 48 | 109 | XOR90598.1 MAG: hypothetical protein MSP1590_1 [Caudoviricetes sp.] | diamond | 186 | 93.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31076319 | 31076319 | PRJEB50332_P_NODE_18575_length_186_cov_4.144000_g18493_i0 | PRJEB50332 | 18575 | 186 | 4.144 | 7.70784 | Citromicrobium phage vB_CbaS-RXM | 2909582 | Viruses | Viruses | 122 | 1.19e-30 | NR | USM11579.1 | 2909582 | g18493 | i0 | 87.1 | 1 | 62 | 8 | 100 | 0 | 1 | 186 | 67 | 128 | USM11579.1 putative tail protein [Citromicrobium phage vB_CbaS-RXM] | diamond | 186 | 122 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Citromicrobium phage vB_CbaS-RXM | |||||
| 32151585 | 32151585 | PRJEB50332_P_NODE_13178_length_210_cov_0.872483_g13096_i0 | PRJEB50332 | 13178 | 210 | 0.872483 | 1.8322143 | Pseudomonas phage pPa_SNUABM_DT | 2820398 | Viruses | Viruses | 117 | 5.0199999999999993e-29 | NR | QTH80268.1 | 2820398 | g13096 | i0 | 73.9 | 0.985714285714286 | 69 | 18 | 98.6 | 0 | 209 | 3 | 109 | 177 | QTH80268.1 hypothetical protein PA10_00068 [Pseudomonas phage pPa_SNUABM_DT01] | diamond | 207 | 117 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage pPa_SNUABM_DT01 | |||||
| 32783138 | 32783138 | PRJEB50332_P_NODE_11120_length_218_cov_1.656051_g11038_i0 | PRJEB50332 | 11120 | 218 | 1.656051 | 3.61019118 | Myxococcus phage Mx1 | 2994995 | Viruses | Viruses | 54.7 | 1.67e-6 | NR | WNM70322.1 | 2994995 | g11038 | i0 | 57.1 | 0.577981651376147 | 42 | 18 | 57.8 | 0 | 205 | 80 | 137 | 178 | WNM70322.1 putative prohead protease [Myxococcus phage Mx1] | diamond | 126 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Myxococcus phage Mx1 |
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);;