contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA558770" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26635694 | 26635694 | PRJNA558770_P_NODE_69421_length_249_cov_12.855140_g67416_i0 | PRJNA558770 | 69421 | 249 | 12.85514 | 32.0092986 | Curvularia pseudobrachyspora bunya-like virus 1 | 3391148 | Viruses | Viruses | 69.7 | 1.28e-11 | NR | XMD53700.1 | 3391148 | g67416 | i0 | 50 | 1.01204819277108 | 84 | 39 | 97.6 | 2 | 4 | 246 | 256 | 339 | XMD53700.1 nonstructural protein [Curvularia pseudobrachyspora bunya-like virus 1] | diamond | 252 | 69.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Curvularia pseudobrachyspora bunya-like virus 1 | ||||
| 26889330 | 26889330 | PRJNA558770_P_NODE_395001_length_160_cov_4.560000_g392996_i0 | PRJNA558770 | 395001 | 160 | 4.56 | 7.296 | Marnaviridae sp. | 2715102 | Viruses | Viruses | 74.3 | 8.86e-14 | NR | XCO48635.1 | 2715102 | g392996 | i0 | 64.7 | 0.95625 | 51 | 18 | 95.6 | 0 | 8 | 160 | 1771 | 1821 | XCO48635.1 MAG: putative ORF1 protein [Marnaviridae sp.] | diamond | 153 | 74.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Marnaviridae sp. | |||
| 27078895 | 27078895 | PRJNA558770_P_NODE_201442_length_234_cov_3.728643_g199437_i0 | PRJNA558770 | 201442 | 234 | 3.728643 | 8.72502462 | Totiviridae sp. | 1955172 | Viruses | Viruses | 47 | 0.00105 | NR | WAK77569.1 | 1955172 | g199437 | i0 | 86.4 | 0.282051282051282 | 22 | 3 | 28.2 | 0 | 167 | 232 | 539 | 560 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 66 | 47 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 28026531 | 28026531 | PRJNA558770_P_NODE_133405_length_234_cov_7.788945_g131400_i0 | PRJNA558770 | 133405 | 234 | 7.788945 | 18.2261313 | Botrytis cinerea botybirnavirus 2 | 2735874 | Viruses | Viruses | 45.8 | 0.00286 | NR | QJT73738.1 | 2735874 | g131400 | i0 | 35.1 | 0.987179487179487 | 77 | 48 | 98.7 | 1 | 4 | 234 | 672 | 746 | QJT73738.1 hypothetical protein [Botrytis cinerea botybirnavirus 2] | diamond | 231 | 45.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Botybirnaviridae | Botybirnavirus | Botybirnavirus kyu | ||
| 28121210 | 28121210 | PRJNA558770_P_NODE_43925_length_320_cov_13.438596_g41927_i0 | PRJNA558770 | 43925 | 320 | 13.438596 | 43.0035072 | Coniothyrium diplodiella negative-stranded RNA virus 1 | 2587545 | Viruses | Viruses | 45.4 | 0.0101 | NR | YP_010840596.1 | 2587545 | g41927 | i0 | 45.7 | 0.43125 | 46 | 25 | 43.1 | 0 | 1 | 138 | 268 | 313 | YP_010840596.1 NS1 [Coniothyrium diplodiella negative-stranded RNA virus 1] | diamond | 138 | 45.4 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Discoviridae | Orthodiscovirus | Orthodiscovirus coniellae | ||
| 28847244 | 28847244 | PRJNA558770_P_NODE_57328_length_276_cov_11.435685_g55324_i0 | PRJNA558770 | 57328 | 276 | 11.435685 | 31.5624906 | Coniothyrium diplodiella negative-stranded RNA virus 1 | 2587545 | Viruses | Viruses | 45.4 | 0.00631 | NR | YP_010840596.1 | 2587545 | g55324 | i0 | 45.7 | 0.5 | 46 | 25 | 50 | 0 | 276 | 139 | 268 | 313 | YP_010840596.1 NS1 [Coniothyrium diplodiella negative-stranded RNA virus 1] | diamond | 138 | 45.4 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Discoviridae | Orthodiscovirus | Orthodiscovirus coniellae | ||
| 29037042 | 29037042 | PRJNA558770_P_NODE_170108_length_234_cov_5.160804_g168103_i0 | PRJNA558770 | 170108 | 234 | 5.160804 | 12.07628136 | Fusarium oxysporum chrysovirus 1 | 434898 | Viruses | Viruses | 45.8 | 0.00206 | NR | YP_009665201.1 | 434898 | g168103 | i0 | 35.1 | 0.987179487179487 | 77 | 31 | 98.7 | 1 | 2 | 232 | 6 | 63 | YP_009665201.1 coat protein, partial [Fusarium oxysporum chrysovirus 1] | diamond | 231 | 45.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus fusarii | ||
| 29068530 | 29068530 | PRJNA558770_P_NODE_160488_length_234_cov_5.728643_g158483_i0 | PRJNA558770 | 160488 | 234 | 5.728643 | 13.40502462 | Crogonang virus 58 | 3063050 | Viruses | Viruses | 68.9 | 2.02e-11 | NR | WPR18299.1 | 3063050 | g158483 | i0 | 43.4 | 2.12820512820513 | 83 | 42 | 100 | 1 | 1 | 234 | 791 | 873 | WPR18299.1 MAG: structural polyprotein, partial [Crogonang virus 58] | diamond | 498 | 68.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Crogonang virus 58 | ||||
| 29921112 | 29921112 | PRJNA558770_P_NODE_175391_length_234_cov_4.874372_g173386_i0 | PRJNA558770 | 175391 | 234 | 4.874372 | 11.40603048 | Coniothyrium diplodiella negative-stranded RNA virus 1 | 2587545 | Viruses | Viruses | 73.2 | 6.34e-13 | NR | YP_010840597.1 | 2587545 | g173386 | i0 | 51.9 | 0.987179487179487 | 77 | 12 | 98.7 | 1 | 233 | 3 | 779 | 830 | YP_010840597.1 MAG: RNA-dependent RNA polymerase [Coniothyrium diplodiella negative-stranded RNA virus 1] | diamond | 231 | 73.2 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Discoviridae | Orthodiscovirus | Orthodiscovirus coniellae | ||
| 30788090 | 30788090 | PRJNA558770_P_NODE_7014_length_655_cov_26.840323_g5655_i0 | PRJNA558770 | 7014 | 655 | 26.840323 | 175.80411565 | Negarnaviricota | 2497569 | Viruses | Viruses | 300 | 5.6999999999999995e-99 | NR | YP_010840348.1 | 2737680 | g5655 | i0 | 71.6 | 3.67786259541985 | 208 | 55 | 95.3 | 1 | 654 | 31 | 117 | 320 | YP_010840348.1 NC [Plasmopara viticola lesion associated mycobunyavirales-like virus 8] | diamond | 2409 | 300 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Discoviridae | Orthodiscovirus | Orthodiscovirus hispaniae | ||
| 30868705 | 30868705 | PRJNA558770_P_NODE_239154_length_234_cov_2.562814_g237149_i0 | PRJNA558770 | 239154 | 234 | 2.562814 | 5.99698476 | Penicillium roseopurpureum chrysovirus 1 | 2485919 | Viruses | Viruses | 68.6 | 2.74e-11 | NR | AYP71814.1 | 2485919 | g237149 | i0 | 49.4 | 0.987179487179487 | 77 | 36 | 98.7 | 1 | 4 | 234 | 304 | 377 | AYP71814.1 hypothetical protein [Penicillium roseopurpureum chrysovirus 1] | diamond | 231 | 68.6 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus penicillii | ||
| 31374612 | 31374612 | PRJNA558770_P_NODE_119976_length_234_cov_9.211055_g117971_i0 | PRJNA558770 | 119976 | 234 | 9.211055 | 21.5538687 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 48.1 | 4.26e-4 | NR | CAI9858976.1 | 3048757 | g117971 | i0 | 83.3 | 0.307692307692308 | 24 | 4 | 30.8 | 0 | 75 | 4 | 242 | 265 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 72 | 48.1 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 31880366 | 31880366 | PRJNA558770_P_NODE_161917_length_234_cov_5.643216_g159912_i0 | PRJNA558770 | 161917 | 234 | 5.643216 | 13.20512544 | Crogonang virus 58 | 3063050 | Viruses | Viruses | 55.1 | 1.55e-6 | NR | WPR18299.1 | 3063050 | g159912 | i0 | 80 | 0.320512820512821 | 25 | 5 | 32.1 | 0 | 160 | 234 | 628 | 652 | WPR18299.1 MAG: structural polyprotein, partial [Crogonang virus 58] | diamond | 75 | 55.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Crogonang virus 58 | ||||
| 32274536 | 32274536 | PRJNA558770_P_NODE_162998_length_234_cov_5.572864_g160993_i0 | PRJNA558770 | 162998 | 234 | 5.572864 | 13.04050176 | Ghabrivirales | 2732540 | Viruses | Viruses | 49.3 | 1.6e-4 | NR | AOX47598.1 | 1905690 | g160993 | i0 | 31.6 | 8.71794871794872 | 76 | 40 | 97.4 | 1 | 6 | 233 | 251 | 314 | AOX47598.1 RNA-dependent RNA polymerase, partial [Pterostylis totivirus-like] | diamond | 2040 | 49.3 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Pterostylis totivirus-like | ||
| 32513735 | 32513735 | PRJNA558770_P_NODE_74039_length_241_cov_8.087379_g72034_i0 | PRJNA558770 | 74039 | 241 | 8.087379 | 19.49058339 | Crogonang virus 47 | 3063018 | Viruses | Viruses | 48.5 | 3.24e-4 | NR | WPR18235.1 | 3063018 | g72034 | i0 | 84.6 | 0.647302904564315 | 26 | 4 | 32.4 | 0 | 82 | 5 | 296 | 321 | WPR18235.1 MAG: RNA-dependent RNA polymerase [Crogonang virus 47] | diamond | 156 | 48.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Crogonang virus 47 | ||||
| 32576818 | 32576818 | PRJNA558770_P_NODE_383819_length_201_cov_2.602410_g381814_i0 | PRJNA558770 | 383819 | 201 | 2.60241 | 5.2308441 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 113 | 2.57e-27 | NR | XCM67829.1 | 3003959 | g381814 | i0 | 83.6 | 0.91044776119403 | 61 | 10 | 91 | 0 | 198 | 16 | 810 | 870 | XCM67829.1 MAG: structural polyprotein [Picornavirales sp.] | diamond | 183 | 113 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 32734201 | 32734201 | PRJNA558770_P_NODE_185780_length_234_cov_4.371859_g183775_i0 | PRJNA558770 | 185780 | 234 | 4.371859 | 10.23015006 | Exserohilum turcicum mycobunyavirales-like virus 2 | 3229032 | Viruses | Viruses | 45.1 | 0.00517 | NR | XBY85604.1 | 3229032 | g183775 | i0 | 83.3 | 0.615384615384615 | 24 | 4 | 30.8 | 0 | 73 | 2 | 1636 | 1659 | XBY85604.1 MAG: RNA-dependent RNA polymerase [Exserohilum turcicum mycobunyavirales-like virus 2] | diamond | 144 | 45.1 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Exserohilum turcicum mycobunyavirales-like virus 2 | ||||
| 32891342 | 32891342 | PRJNA558770_P_NODE_208960_length_234_cov_3.452261_g206955_i0 | PRJNA558770 | 208960 | 234 | 3.452261 | 8.07829074 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 48.1 | 4.09e-4 | NR | CAI9858974.1 | 3048756 | g206955 | i0 | 84 | 0.320512820512821 | 25 | 4 | 32.1 | 0 | 2 | 76 | 647 | 671 | CAI9858974.1 capsid protein [Malassezia globosa associated totivirus 1] | diamond | 75 | 48.1 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia globosa associated totivirus 1 | ||
| 32891365 | 32891365 | PRJNA558770_P_NODE_335840_length_233_cov_4.777778_g333835_i0 | PRJNA558770 | 335840 | 233 | 4.777778 | 11.13222274 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 53.9 | 3.74e-6 | NR | CAI9858976.1 | 3048757 | g333835 | i0 | 100 | 0.296137339055794 | 23 | 0 | 29.6 | 0 | 3 | 71 | 375 | 397 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 69 | 53.9 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 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);;