contig_metadata
6 rows where bioproject = "PRJNA1063685" and tax_phylum = "Pisuviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4840048 | 4840048 | PRJNA1063685_S_NODE_44704_length_344_cov_1.892989_g44161_i0 | PRJNA1063685 | 44704 | 344 | 1.892989 | 6.51188216 | Viruses | 10239 | Viruses | Viruses | 593 | 4.3099999999999986e-165 | NTclustered | gi|2806502719|gb|PQ054859.1| | 2789443 | g44161 | i0 | 100 | 2.79941860465116 | 321 | 0 | 93 | 0 | 24 | 344 | 3499 | 3819 | MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence | blastn | 963 | 593 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 9107295 | 9107295 | PRJNA1063685_S_NODE_48628_length_325_cov_3.198413_g48085_i0 | PRJNA1063685 | 48628 | 325 | 3.198413 | 10.39484225 | Ustilaginoidea virens partitivirus 14 | 2971976 | Viruses | Viruses | 163 | 6.599999999999999e-46 | NR | UVX28931.1 | 2971976 | g48085 | i0 | 82.3 | 1.82769230769231 | 96 | 17 | 88.6 | 0 | 34 | 321 | 96 | 191 | UVX28931.1 MAG: RNA dependent RNA polymerase [Ustilaginoidea virens partitivirus 14] | diamond | 594 | 163 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Ustilaginoidea virens partitivirus 14 | |||
| 12933099 | 12933099 | PRJNA1063685_S_NODE_15891_length_551_cov_13.537657_g15362_i0 | PRJNA1063685 | 15891 | 551 | 13.537657 | 74.59249007 | Skokie dicistro-like virus | 2789443 | Viruses | Viruses | 922 | 0 | NTclustered | gi|1935607033|gb|MT747992.1| | 2789443 | g15362 | i0 | 98.47 | 0.949183303085299 | 523 | 8 | 95 | 0 | 24 | 546 | 672 | 1194 | Skokie dicistro-like virus strain USAdf-2 polyprotein 1 and polyprotein 2 genes, complete cds | blastn | 523 | 922 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 19305115 | 19305115 | PRJNA1063685_S_NODE_19136_length_518_cov_7.188764_g18599_i0 | PRJNA1063685 | 19136 | 518 | 7.188764 | 37.23779752 | Cucurbita moschata potyvirus | 2740139 | Viruses | Viruses | 771 | 0 | NTclustered | gi|1846260041|gb|MN735449.1| | 2740139 | g18599 | i0 | 94.758 | 95.972972972973 | 496 | 25 | 96 | 1 | 24 | 518 | 8576 | 9071 | Cucurbita moschata potyvirus strain pt063-pot-16, complete genome | blastn | 49714 | 771 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Cucurbita moschata potyvirus | |||
| 20580746 | 20580746 | PRJNA1063685_S_NODE_45717_length_339_cov_2.281955_g45174_i0 | PRJNA1063685 | 45717 | 339 | 2.281955 | 7.73582745 | Polerovirus TUYV | 3431793 | Viruses | Viruses | 121 | 8.65e-23 | NTclustered | gi|2461860523|dbj|LC726803.1| | 1046403 | g45174 | i0 | 96 | 20.811209439528 | 75 | 1 | 22 | 2 | 242 | 315 | 1073 | 1146 | Brassica yellows virus DN134266_c8_g2_i1 gene for CP readthrough protein | blastn | 7055 | 121 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Polerovirus | Polerovirus TUYV | ||
| 29592964 | 29592964 | PRJNA1063685_S_NODE_42430_length_355_cov_7.971631_g41887_i0 | PRJNA1063685 | 42430 | 355 | 7.971631 | 28.29929005 | Trichoderma gamsii alphapartitivirus 1 | 3032463 | Viruses | Viruses | 209 | 5.26e-62 | NR | WGH72964.1 | 3032463 | g41887 | i0 | 86.4 | 0.929577464788732 | 110 | 15 | 93 | 0 | 18 | 347 | 70 | 179 | WGH72964.1 MAG: putative RNA-dependent RNA polymerase [Trichoderma gamsii alphapartitivirus 1] | diamond | 330 | 209 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Alphapartitivirus | Trichoderma gamsii alphapartitivirus 1 |
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);;