contig_metadata
11 rows where bioproject = "PRJNA380660", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2349565 | 2349565 | PRJNA380660_P_NODE_7182_length_271_cov_2.900826_g6782_i0 | PRJNA380660 | 7182 | 271 | 2.900826 | 7.86123846 | Viruses | 10239 | Viruses | Viruses | 298 | 2.89e-76 | NTclustered | gi|2214231626|gb|OM622299.1| | 1955153 | g6782 | i0 | 98.802 | 2.03690036900369 | 167 | 2 | 100 | 0 | 105 | 271 | 5531 | 5697 | MAG: Picornavirales sp. isolate HPLV-44 genomic sequence | blastn | 552 | 298 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornavirales sp. | ||||
| 10606005 | 10606005 | PRJNA380660_P_NODE_6809_length_283_cov_1587.318898_g6409_i0 | PRJNA380660 | 6809 | 283 | 1587.318898 | 4492.11248134 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g6409 | i0 | 100 | 0.102473498233216 | 29 | 0 | 10 | 0 | 255 | 283 | 30001 | 30029 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 13156006 | 13156006 | PRJNA380660_P_NODE_8751_length_230_cov_2.034826_g8351_i0 | PRJNA380660 | 8751 | 230 | 2.034826 | 4.6800998 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 265 | 2.42e-66 | NTclustered | gi|2214231626|gb|OM622299.1| | 3003959 | g8351 | i0 | 97.419 | 1.34782608695652 | 155 | 4 | 67 | 0 | 1 | 155 | 3807 | 3653 | MAG: Picornavirales sp. isolate HPLV-44 genomic sequence | blastn | 310 | 265 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 27169596 | 27169596 | PRJNA380660_P_NODE_12562_length_157_cov_2.062500_g12162_i0 | PRJNA380660 | 12562 | 157 | 2.0625 | 3.238125 | Rosellinia necatrix partitivirus 21 | 2699389 | Viruses | Viruses | 72.8 | 2.94e-13 | NR | BBU59850.1 | 2699389 | g12162 | i0 | 64.2 | 1.01273885350318 | 53 | 17 | 99.4 | 2 | 1 | 156 | 168 | 219 | BBU59850.1 RNA dependent RNA polymerase [Rosellinia necatrix partitivirus 21] | diamond | 159 | 72.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Rosellinia necatrix partitivirus 21 | |||
| 27233056 | 27233056 | PRJNA380660_P_NODE_2563_length_527_cov_2.078313_g2201_i0 | PRJNA380660 | 2563 | 527 | 2.078313 | 10.95270951 | Macrophomina phaseolina single-stranded RNA virus 1 | 1708488 | Viruses | Viruses | 86.7 | 4.1e-16 | NR | YP_010799203.1 | 1708488 | g2201 | i0 | 32.3 | 0.916508538899431 | 161 | 107 | 91.7 | 1 | 526 | 44 | 1337 | 1495 | YP_010799203.1 RNA-dependent RNA polymerase [Macrophomina phaseolina single-stranded RNA virus 1] | diamond | 483 | 86.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Fusariviridae | Alphafusarivirus | Alphafusarivirus macrophominae | ||
| 27296281 | 27296281 | PRJNA380660_P_NODE_5403_length_336_cov_1.775244_g5004_i0 | PRJNA380660 | 5403 | 336 | 1.775244 | 5.96481984 | Aspergillus chevalieri partitivirus 1 | 3238293 | Viruses | Viruses | 87 | 3.08e-17 | NR | BFP29929.1 | 3238293 | g5004 | i0 | 50 | 0.732142857142857 | 82 | 41 | 73.2 | 0 | 333 | 88 | 451 | 532 | BFP29929.1 MAG: coat protein [Aspergillus chevalieri partitivirus 1] | diamond | 246 | 87 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Aspergillus chevalieri partitivirus 1 | |||
| 29190916 | 29190916 | PRJNA380660_P_NODE_1189_length_795_cov_4.468668_g918_i0 | PRJNA380660 | 1189 | 795 | 4.468668 | 35.5259106 | Trichoderma citrinoviride partitivirus 1 | 2501046 | Viruses | Viruses | 210 | 1.72e-59 | NR | AZT88593.1 | 2501046 | g918 | i0 | 47.7 | 0.886792452830189 | 235 | 117 | 86.4 | 1 | 687 | 1 | 1 | 235 | AZT88593.1 coat protein [Trichoderma citrinoviride partitivirus 1] | diamond | 705 | 210 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Trichoderma citrinoviride partitivirus 1 | |||
| 29790515 | 29790515 | PRJNA380660_P_NODE_8431_length_237_cov_4.394231_g8031_i0 | PRJNA380660 | 8431 | 237 | 4.3942310000000004 | 10.41432747 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 137 | 1.26e-35 | NR | XCM67829.1 | 3003959 | g8031 | i0 | 78.2 | 0.987341772151899 | 78 | 17 | 98.7 | 0 | 3 | 236 | 415 | 492 | XCM67829.1 MAG: structural polyprotein [Picornavirales sp.] | diamond | 234 | 137 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 31402421 | 31402421 | PRJNA380660_P_NODE_5156_length_346_cov_3.539432_g4758_i0 | PRJNA380660 | 5156 | 346 | 3.539432 | 12.24643472 | Sclerotinia sclerotiorum partitivirus 1 | 1232468 | Viruses | Viruses | 131 | 7.06e-33 | NR | AFR78160.1 | 1232468 | g4758 | i0 | 56.6 | 0.979768786127168 | 113 | 49 | 98 | 0 | 340 | 2 | 18 | 130 | AFR78160.1 RNA-dependent RNA polymerase [Sclerotinia sclerotiorum partitivirus 1] | diamond | 339 | 131 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Sclerotinia sclerotiorum partitivirus 1 | |||
| 31497283 | 31497283 | PRJNA380660_P_NODE_4696_length_368_cov_4.938053_g4299_i0 | PRJNA380660 | 4696 | 368 | 4.938053 | 18.17203504 | Leptosphaeria biglobosa partitivirus 3 | 3062775 | Viruses | Viruses | 89.4 | 7.05e-18 | NR | WKR37728.1 | 3062775 | g4299 | i0 | 53.8 | 0.758152173913043 | 93 | 42 | 75 | 1 | 78 | 353 | 4 | 96 | WKR37728.1 putative RNA-dependent RNA polymerase, partial [Leptosphaeria biglobosa partitivirus 3] | diamond | 279 | 89.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Leptosphaeria biglobosa partitivirus 3 | |||
| 31798606 | 31798606 | PRJNA380660_P_NODE_8477_length_236_cov_4.748792_g8077_i0 | PRJNA380660 | 8477 | 236 | 4.748792 | 11.20714912 | Viruses | 10239 | Viruses | Viruses | 144 | 2.95e-39 | NR | WAK75580.1 | 1955170 | g8077 | i0 | 87.2 | 2.97457627118644 | 78 | 10 | 99.2 | 0 | 3 | 236 | 191 | 268 | WAK75580.1 MAG: putative RNA-dependent RNA polymerase, partial [Partitiviridae sp.] | diamond | 702 | 144 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Partitiviridae sp. |
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);;