contig_metadata
6 rows where bioproject = "PRJNA1137393" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21961661 | 21961661 | PRJNA1137393_P_NODE_8998_length_277_cov_1.192982_g8482_i0 | PRJNA1137393 | 8998 | 277 | 1.192982 | 3.30456014 | Chemarfal virus 262 | 3063354 | Viruses | Viruses | 490 | 4.56e-134 | NTclustered | gi|2626080003|gb|OR270572.1| | 3063354 | g8482 | i0 | 98.556 | 2 | 277 | 4 | 100 | 0 | 1 | 277 | 760 | 1036 | MAG: Chemarfal virus 262 isolate ML188 genomic sequence | blastn | 554 | 490 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Chemarfal virus 262 | ||||
| 24510656 | 24510656 | PRJNA1137393_P_NODE_37580_length_171_cov_1.295082_g37064_i0 | PRJNA1137393 | 37580 | 171 | 1.295082 | 2.21459022 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 316 | 4.6e-82 | NTclustered | gi|2499447400|emb|OX492971.1| | 2697049 | g37064 | i0 | 100 | 100 | 171 | 0 | 100 | 0 | 1 | 171 | 13946 | 13776 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 17100 | 316 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 28227748 | 28227748 | PRJNA1137393_P_NODE_39306_length_169_cov_1.300000_g38790_i0 | PRJNA1137393 | 39306 | 169 | 1.3 | 2.197 | Viruses | 10239 | Viruses | Viruses | 102 | 1.6499999999999995e-23 | NR | QXV86355.1 | 1955170 | g38790 | i0 | 73.2 | 1.98816568047337 | 56 | 15 | 99.4 | 0 | 169 | 2 | 246 | 301 | QXV86355.1 RNA-dependent RNA polymerase [Partitiviridae sp.] | diamond | 336 | 102 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Partitiviridae sp. | |||
| 28807020 | 28807020 | PRJNA1137393_P_NODE_65008_length_163_cov_1.561404_g64492_i0 | PRJNA1137393 | 65008 | 163 | 1.561404 | 2.54508852 | Coprinus comatus partitivirus 1 | 3115824 | Viruses | Viruses | 67.8 | 1.85e-11 | NR | WUR08103.1 | 3115824 | g64492 | i0 | 52.5 | 1.12269938650307 | 61 | 21 | 97.5 | 1 | 162 | 4 | 432 | 492 | WUR08103.1 RNA-dependent RNA polymerase [Coprinus comatus partitivirus 1] | diamond | 183 | 67.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Coprinus comatus partitivirus 1 | |||
| 30986811 | 30986811 | PRJNA1137393_P_NODE_6834_length_325_cov_1.974638_g6318_i0 | PRJNA1137393 | 6834 | 325 | 1.974638 | 6.4175735 | Coprinus comatus partitivirus | 3115581 | Viruses | Viruses | 187 | 2.8499999999999996e-54 | NR | WTM26314.1 | 3115581 | g6318 | i0 | 78.7 | 0.996923076923077 | 108 | 23 | 99.7 | 0 | 324 | 1 | 130 | 237 | WTM26314.1 RNA-dependent RNA polymerase [Coprinus comatus partitivirus] | diamond | 324 | 187 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Coprinus comatus partitivirus | |||
| 32252047 | 32252047 | PRJNA1137393_P_NODE_42158_length_169_cov_0.866667_g41642_i0 | PRJNA1137393 | 42158 | 169 | 0.866667 | 1.46466723 | Coprinus comatus partitivirus 1 | 3115824 | Viruses | Viruses | 64.7 | 2.35e-10 | NR | WUR08103.1 | 3115824 | g41642 | i0 | 56.6 | 0.940828402366864 | 53 | 21 | 94.1 | 1 | 161 | 3 | 305 | 355 | WUR08103.1 RNA-dependent RNA polymerase [Coprinus comatus partitivirus 1] | diamond | 159 | 64.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Coprinus comatus partitivirus 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);;