contig_metadata
9 rows where analysis = "diamond" and tax_clade = "Caudoviricetes code 15 clade"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26916200 | 26916200 | PRJNA315399_P_NODE_385062_length_163_cov_5.238095_g384614_i0 | PRJNA315399 | 385062 | 163 | 5.238095 | 8.53809485 | phage Lak_Megaphage_RVC_AP3_GC31 | 3109226 | Viruses | Viruses | 66.6 | 5.72e-12 | NR | WQJ51768.1 | 3109226 | g384614 | i0 | 61.9 | 0.773006134969325 | 42 | 16 | 77.3 | 0 | 142 | 17 | 113 | 154 | WQJ51768.1 MAG: hypothetical protein [phage Lak_Megaphage_RVC_AP3_GC31] | diamond | 126 | 66.6 | 1 | Viruses | Caudoviricetes code 15 clade | Heunggongvirae | Uroviricota | Caudoviricetes | phage Lak_Megaphage_RVC_AP3_GC31 | ||||
| 27074017 | 27074017 | PRJNA270367_P_NODE_32782_length_192_cov_1.104895_g32577_i0 | PRJNA270367 | 32782 | 192 | 1.104895 | 2.1213984 | phage Lak_Megaphage_RVC_AP1_GC26 | 3109224 | Viruses | Viruses | 44.3 | 0.00551 | NR | WQJ54389.1 | 3109224 | g32577 | i0 | 39.6 | 0.828125 | 53 | 30 | 79.7 | 1 | 168 | 16 | 142 | 194 | WQJ54389.1 MAG: nucleotidyltransferase [phage Lak_Megaphage_RVC_AP1_GC26] | diamond | 159 | 44.3 | 1 | Viruses | Caudoviricetes code 15 clade | Heunggongvirae | Uroviricota | Caudoviricetes | phage Lak_Megaphage_RVC_AP1_GC26 | ||||
| 28160917 | 28160917 | PRJNA879314_P_NODE_10165_length_244_cov_0.912281_g10115_i0 | PRJNA879314 | 10165 | 244 | 0.912281 | 2.22596564 | phage Lak_Megaphage_RVC_AP3_GC31 | 3109226 | Viruses | Viruses | 84 | 1.13e-16 | NR | WQJ52055.1 | 3109226 | g10115 | i0 | 48.8 | 0.983606557377049 | 80 | 40 | 98.4 | 1 | 242 | 3 | 503 | 581 | WQJ52055.1 MAG: Neutral endopeptidase [phage Lak_Megaphage_RVC_AP3_GC31] | diamond | 240 | 84 | 1 | Viruses | Caudoviricetes code 15 clade | Heunggongvirae | Uroviricota | Caudoviricetes | phage Lak_Megaphage_RVC_AP3_GC31 | ||||
| 29206228 | 29206228 | PRJNA1010780_S_NODE_25429_length_312_cov_1.765343_g24140_i0 | PRJNA1010780 | 25429 | 312 | 1.765343 | 5.50787016 | Viruses | 10239 | Viruses | Viruses | 93.6 | 8.07e-21 | NR | WQJ54341.1 | 3109224 | g24140 | i0 | 48.5 | 1.98076923076923 | 103 | 52 | 99 | 1 | 312 | 4 | 21 | 122 | WQJ54341.1 MAG: hypothetical protein [phage Lak_Megaphage_RVC_AP1_GC26] | diamond | 618 | 93.6 | 1 | Viruses | Caudoviricetes code 15 clade | Heunggongvirae | Uroviricota | Caudoviricetes | phage Lak_Megaphage_RVC_AP1_GC26 | ||||
| 29897535 | 29897535 | PRJNA883229_P_NODE_8811_length_253_cov_0.866667_g8765_i0 | PRJNA883229 | 8811 | 253 | 0.866667 | 2.19266751 | phage Lak_Megaphage_RVC_AP3_GC26 | 3109225 | Viruses | Viruses | 55.1 | 1.97e-6 | NR | WQJ51155.1 | 3109225 | g8765 | i0 | 40.6 | 0.758893280632411 | 64 | 37 | 75.9 | 1 | 253 | 62 | 32 | 94 | WQJ51155.1 MAG: SbcC-like subunit of palindrome specific endonuclease [phage Lak_Megaphage_RVC_AP3_GC26] | diamond | 192 | 55.1 | 1 | Viruses | Caudoviricetes code 15 clade | Heunggongvirae | Uroviricota | Caudoviricetes | phage Lak_Megaphage_RVC_AP3_GC26 | ||||
| 30539104 | 30539104 | PRJEB58983_P_NODE_23933_length_270_cov_1.492386_g23518_i0 | PRJEB58983 | 23933 | 270 | 1.492386 | 4.0294422 | phage Lak_Megaphage_Sonny | 3109229 | Viruses | Viruses | 47.4 | 0.00102 | NR | WQJ53232.1 | 3109229 | g23518 | i0 | 61.3 | 0.344444444444444 | 31 | 12 | 34.4 | 0 | 267 | 175 | 107 | 137 | WQJ53232.1 MAG: hypothetical protein [phage Lak_Megaphage_Sonny] | diamond | 93 | 47.4 | 1 | Viruses | Caudoviricetes code 15 clade | Heunggongvirae | Uroviricota | Caudoviricetes | phage Lak_Megaphage_Sonny | ||||
| 31433474 | 31433474 | PRJNA340009_P_NODE_47516_length_187_cov_2.572464_g47209_i0 | PRJNA340009 | 47516 | 187 | 2.572464 | 4.81050768 | phage Lak_Megaphage_Sonny | 3109229 | Viruses | Viruses | 53.5 | 5.05e-7 | NR | WQJ53760.1 | 3109229 | g47209 | i0 | 50 | 0.737967914438503 | 46 | 22 | 73.8 | 1 | 47 | 184 | 19 | 63 | WQJ53760.1 MAG: hypothetical protein [phage Lak_Megaphage_Sonny] | diamond | 138 | 53.5 | 1 | Viruses | Caudoviricetes code 15 clade | Heunggongvirae | Uroviricota | Caudoviricetes | phage Lak_Megaphage_Sonny | ||||
| 32037458 | 32037458 | PRJNA529241_P_NODE_62698_length_263_cov_5.336283_g60376_i0 | PRJNA529241 | 62698 | 263 | 5.336283 | 14.03442429 | phage Lak_Megaphage_RVC_AP1_GC26 | 3109224 | Viruses | Viruses | 90.5 | 2.57e-20 | NR | WQJ54391.1 | 3109224 | g60376 | i0 | 51.4 | 0.821292775665399 | 72 | 35 | 82.1 | 0 | 47 | 262 | 1 | 72 | WQJ54391.1 MAG: hypothetical protein [phage Lak_Megaphage_RVC_AP1_GC26] | diamond | 216 | 90.5 | 1 | Viruses | Caudoviricetes code 15 clade | Heunggongvirae | Uroviricota | Caudoviricetes | phage Lak_Megaphage_RVC_AP1_GC26 | ||||
| 33018091 | 33018091 | PRJNA1233465d_S_NODE_127268_length_166_cov_1.675214_g126157_i0 | PRJNA1233465 | 127268 | 166 | 1.675214 | 2.78085524 | phage Lak_Megaphage_Sonny | 3109229 | Viruses | Viruses | 55.5 | 4.12e-7 | NR | WQJ53519.1 | 3109229 | g126157 | i0 | 57.4 | 1.95180722891566 | 54 | 23 | 97.6 | 0 | 164 | 3 | 239 | 292 | WQJ53519.1 MAG: transposase [phage Lak_Megaphage_Sonny] | diamond | 324 | 55.5 | 1 | Viruses | Caudoviricetes code 15 clade | Heunggongvirae | Uroviricota | Caudoviricetes | phage Lak_Megaphage_Sonny |
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);;