contig_metadata
6 rows where bioproject = "PRJNA753704" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21604220 | 21604220 | PRJNA753704_P_NODE_23857_length_252_cov_0.871508_g23496_i0 | PRJNA753704 | 23857 | 252 | 0.871508 | 2.19620016 | Tobamovirus | 12234 | Viruses | Viruses | 466 | 6.89e-127 | NTclustered | gi|2431684801|gb|ON557629.1| | 12239 | g23496 | i0 | 100 | 98.8095238095238 | 252 | 0 | 100 | 0 | 1 | 252 | 1833 | 1582 | Pepper mild mottle virus isolate G07, partial genome | blastn | 24900 | 466 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 27590193 | 27590193 | PRJNA753704_P_NODE_11824_length_345_cov_1.147059_g11463_i0 | PRJNA753704 | 11824 | 345 | 1.147059 | 3.95735355 | Ripegast virus | 3130561 | Viruses | Viruses | 121 | 7.48e-32 | NR | WZH59875.1 | 3130561 | g11463 | i0 | 53.2 | 0.947826086956522 | 109 | 49 | 94.8 | 1 | 13 | 339 | 65 | 171 | WZH59875.1 MAG: RNA-dependent RNA polymerase, partial [Ripegast virus] | diamond | 327 | 121 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Ripegast virus | ||||
| 27968886 | 27968886 | PRJNA753704_P_NODE_27505_length_244_cov_0.912281_g27144_i0 | PRJNA753704 | 27505 | 244 | 0.912281 | 2.22596564 | Salarius guttatus piscichuvirus | 2951531 | Viruses | Viruses | 69.3 | 1.62e-11 | NR | UVF58767.1 | 2951531 | g27144 | i0 | 45.6 | 0.971311475409836 | 79 | 42 | 95.9 | 1 | 236 | 3 | 1 | 79 | UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus] | diamond | 237 | 69.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | Salarius guttatus piscichuvirus | ||
| 29958087 | 29958087 | PRJNA753704_P_NODE_8031_length_411_cov_2.032544_g7670_i0 | PRJNA753704 | 8031 | 411 | 2.032544 | 8.35375584 | Erysiphe necator associated negative-stranded RNA virus 4 | 2737071 | Viruses | Viruses | 54.7 | 1.63e-5 | NR | QJW70357.1 | 2737071 | g7670 | i0 | 31.3 | 1.92700729927007 | 131 | 80 | 92.7 | 3 | 388 | 8 | 1192 | 1316 | QJW70357.1 RNA-dependent RNA polymerase [Erysiphe necator associated negative-stranded RNA virus 4] | diamond | 792 | 54.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Erysiphe necator associated negative-stranded RNA virus 4 | ||||||
| 32244439 | 32244439 | PRJNA753704_P_NODE_27778_length_243_cov_1.376471_g27417_i0 | PRJNA753704 | 27778 | 243 | 1.376471 | 3.34482453 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 48.1 | 4.74e-4 | NR | YP_010797603.1 | 3065075 | g27417 | i0 | 32.9 | 2.64197530864198 | 76 | 43 | 86.4 | 2 | 6 | 215 | 46 | 119 | YP_010797603.1 L protein [Wenling fish chu-like virus] | diamond | 642 | 48.1 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 32875365 | 32875365 | PRJNA753704_P_NODE_22620_length_257_cov_1.695652_g22259_i0 | PRJNA753704 | 22620 | 257 | 1.695652 | 4.35782564 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 73.9 | 4.71e-13 | NR | WLN26256.1 | 3065075 | g22259 | i0 | 56.3 | 2.21789883268483 | 64 | 28 | 74.7 | 0 | 194 | 3 | 229 | 292 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 570 | 73.9 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus |
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);;