contig_metadata
4 rows where bioproject = "PRJNA385073" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8059468 | 8059468 | PRJNA385073_P_NODE_46667_length_248_cov_0.880000_g46505_i0 | PRJNA385073 | 46667 | 248 | 0.88 | 2.1824 | Polerovirus TUYV | 3431793 | Viruses | Viruses | 448 | 2.4499999999999996e-121 | NTclustered | gi|336444814|gb|JN015068.1| | 1046403 | g46505 | i0 | 99.194 | 99.7943548387097 | 248 | 2 | 100 | 0 | 1 | 248 | 2384 | 2137 | Brassica yellows virus, complete genome | blastn | 24749 | 448 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Polerovirus | Polerovirus TUYV | ||
| 18258060 | 18258060 | PRJNA385073_P_NODE_63295_length_221_cov_5.560811_g63133_i0 | PRJNA385073 | 63295 | 221 | 5.560811 | 12.28939231 | Lentinula eaodes hypovirus 2 | 2992848 | Viruses | Viruses | 359 | 1.03e-94 | NTclustered | gi|2324991072|gb|OK636212.1| | 2992848 | g63133 | i0 | 95.928 | 1 | 221 | 9 | 100 | 0 | 1 | 221 | 4982 | 5202 | Lentinula eaodes hypovirus 2 isolate LED2-8 RNA-dependent RNA polymerase (RdRp) gene, complete cds | blastn | 221 | 359 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Hypovirus | Lentinula eaodes hypovirus 2 | ||
| 24632343 | 24632343 | PRJNA385073_P_NODE_34340_length_267_cov_1.829897_g34178_i0 | PRJNA385073 | 34340 | 267 | 1.829897 | 4.88582499 | Sichuan mamastrovirus 11 | 2933222 | Viruses | Viruses | 215 | 2.94e-51 | NTclustered | gi|2203408192|gb|MW784105.1| | 2933222 | g34178 | i0 | 86.911 | 31.1647940074906 | 191 | 25 | 72 | 0 | 77 | 267 | 194 | 4 | MAG: Sichuan mamastrovirus 11 isolate R69-151373, complete genome | blastn | 8321 | 215 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Mamastrovirus | Sichuan mamastrovirus 11 | ||
| 28401652 | 28401652 | PRJNA385073_P_NODE_36926_length_261_cov_1.425532_g36764_i0 | PRJNA385073 | 36926 | 261 | 1.425532 | 3.72063852 | Lentinula eaodes hypovirus 2 | 2992848 | Viruses | Viruses | 161 | 7.9e-44 | NR | UZA97544.1 | 2992848 | g36764 | i0 | 98.8 | 0.977011494252874 | 85 | 1 | 97.7 | 0 | 2 | 256 | 1565 | 1649 | UZA97544.1 RNA-dependent RNA polymerase [Lentinula eaodes hypovirus 2] | diamond | 255 | 161 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Hypovirus | Lentinula eaodes hypovirus 2 |
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);;