contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA1137393" and tax_phylum = "Duplornaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26595319 | 26595319 | PRJNA1137393_P_NODE_22741_length_194_cov_1.434483_g22225_i0 | PRJNA1137393 | 22741 | 194 | 1.434483 | 2.78289702 | Penicillium chrysogenum virus | 158372 | Viruses | Viruses | 58.2 | 7.1e-8 | NR | YP_392485.1 | 158372 | g22225 | i0 | 54.2 | 0.742268041237113 | 48 | 22 | 74.2 | 0 | 192 | 49 | 799 | 846 | YP_392485.1 hypothetical protein [Penicillium chrysogenum virus] | diamond | 144 | 58.2 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus penicillii | ||
| 26742508 | 26742508 | PRJNA1137393_P_NODE_21921_length_196_cov_2.013605_g21405_i0 | PRJNA1137393 | 21921 | 196 | 2.013605 | 3.9466658 | Chrysovirus | 11014 | Viruses | Viruses | 45.4 | 0.00229 | NR | QKK35391.1 | 2742544 | g21405 | i0 | 30.6 | 1.91326530612245 | 62 | 43 | 94.9 | 0 | 192 | 7 | 762 | 823 | QKK35391.1 hypothetical protein [Erysiphe necator associated chrysovirus 3] | diamond | 375 | 45.8 | 0.991266375545852 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Chrysovirus | Erysiphe necator associated chrysovirus 3 | ||
| 26774733 | 26774733 | PRJNA1137393_P_NODE_9821_length_264_cov_2.409302_g9305_i0 | PRJNA1137393 | 9821 | 264 | 2.409302 | 6.36055728 | Chrysovirus | 11014 | Viruses | Viruses | 128 | 3.1999999999999996e-32 | NR | AFX73020.1 | 1256787 | g9305 | i0 | 72.4 | 2.97727272727273 | 87 | 24 | 98.9 | 0 | 3 | 263 | 267 | 353 | AFX73020.1 putative protease [Grapevine chrysovirus] | diamond | 786 | 129 | 0.992248062015504 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Chrysovirus | Grapevine chrysovirus | ||
| 26880717 | 26880717 | PRJNA1137393_P_NODE_31761_length_179_cov_1.176923_g31245_i0 | PRJNA1137393 | 31761 | 179 | 1.176923 | 2.10669217 | Chrysothrix chrysovirus 1 | 2682569 | Viruses | Viruses | 95.9 | 3.01e-21 | NR | YP_010088084.1 | 2682569 | g31245 | i0 | 76.3 | 0.988826815642458 | 59 | 14 | 98.9 | 0 | 1 | 177 | 41 | 99 | YP_010088084.1 RNA-dependent RNA polymerase [Chrysothrix chrysovirus 1] | diamond | 177 | 95.9 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus chrysothricis | ||
| 28018060 | 28018060 | PRJNA1137393_P_NODE_5165_length_387_cov_1.532544_g4649_i0 | PRJNA1137393 | 5165 | 387 | 1.532544 | 5.93094528 | Chrysothrix chrysovirus 1 | 2682569 | Viruses | Viruses | 94.4 | 1.69e-19 | NR | YP_010088083.1 | 2682569 | g4649 | i0 | 49 | 0.744186046511628 | 96 | 48 | 73.6 | 1 | 1 | 285 | 751 | 846 | YP_010088083.1 hypothetical protein KM773_s3gp1 [Chrysothrix chrysovirus 1] | diamond | 288 | 94.4 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus chrysothricis | ||
| 28018070 | 28018070 | PRJNA1137393_P_NODE_9965_length_262_cov_3.122066_g9449_i0 | PRJNA1137393 | 9965 | 262 | 3.122066 | 8.17981292 | Dothistroma septosporum chrysovirus 2 | 3104551 | Viruses | Viruses | 94 | 4.6e-20 | NR | WPV70703.1 | 3104551 | g9449 | i0 | 55.6 | 0.927480916030534 | 81 | 36 | 92.7 | 0 | 246 | 4 | 199 | 279 | WPV70703.1 MAG: hypothetical protein [Dothistroma septosporum chrysovirus 2] | diamond | 243 | 94 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Chrysovirus | Dothistroma septosporum chrysovirus 2 | ||
| 28144459 | 28144459 | PRJNA1137393_P_NODE_39325_length_169_cov_1.300000_g38809_i0 | PRJNA1137393 | 39325 | 169 | 1.3 | 2.197 | Cystoviridae sp. | 2584979 | Viruses | Viruses | 42.4 | 0.0163 | NR | QHJ85736.1 | 2584979 | g38809 | i0 | 66.7 | 0.585798816568047 | 33 | 10 | 58.6 | 1 | 100 | 2 | 1 | 32 | QHJ85736.1 MAG: hypothetical protein [Cystoviridae sp.] | diamond | 99 | 42.4 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Cystoviridae sp. | |||
| 28922488 | 28922488 | PRJNA1137393_P_NODE_24048_length_191_cov_1.654930_g23532_i0 | PRJNA1137393 | 24048 | 191 | 1.65493 | 3.1609163 | Chrysoviridae | 249310 | Viruses | Viruses | 69.3 | 7.89e-12 | NR | QKK35390.1 | 2742544 | g23532 | i0 | 52.4 | 1.97905759162304 | 63 | 30 | 99 | 0 | 190 | 2 | 734 | 796 | QKK35390.1 capsid protein [Erysiphe necator associated chrysovirus 3] | diamond | 378 | 69.3 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Chrysovirus | Erysiphe necator associated chrysovirus 3 | ||
| 28997049 | 28997049 | PRJNA1137393_P_NODE_26228_length_187_cov_2.253623_g25712_i0 | PRJNA1137393 | 26228 | 187 | 2.253623 | 4.21427501 | Chrysothrix chrysovirus 1 | 2682569 | Viruses | Viruses | 80.1 | 1.21e-15 | NR | YP_010088083.1 | 2682569 | g25712 | i0 | 58.3 | 0.962566844919786 | 60 | 25 | 96.3 | 0 | 187 | 8 | 202 | 261 | YP_010088083.1 hypothetical protein KM773_s3gp1 [Chrysothrix chrysovirus 1] | diamond | 180 | 80.1 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus chrysothricis | ||
| 29091580 | 29091580 | PRJNA1137393_P_NODE_19628_length_203_cov_1.564935_g19112_i0 | PRJNA1137393 | 19628 | 203 | 1.564935 | 3.17681805 | Alphachrysovirus sp. 'dothistromae' | 3024828 | Viruses | Viruses | 103 | 8.39e-24 | NR | CAI9240339.1 | 3024828 | g19112 | i0 | 73.1 | 0.990147783251232 | 67 | 18 | 99 | 0 | 201 | 1 | 441 | 507 | CAI9240339.1 capsid protein [Alphachrysovirus sp. 'dothistromae'] | diamond | 201 | 103 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus sp. 'dothistromae' | ||
| 29249198 | 29249198 | PRJNA1137393_P_NODE_6769_length_327_cov_2.208633_g6253_i0 | PRJNA1137393 | 6769 | 327 | 2.208633 | 7.22222991 | Erysiphe necator associated chrysovirus 3 | 2742544 | Viruses | Viruses | 144 | 2.89e-37 | NR | QKK35391.1 | 2742544 | g6253 | i0 | 57.4 | 0.990825688073395 | 108 | 46 | 99.1 | 0 | 326 | 3 | 613 | 720 | QKK35391.1 hypothetical protein [Erysiphe necator associated chrysovirus 3] | diamond | 324 | 144 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Chrysovirus | Erysiphe necator associated chrysovirus 3 | ||
| 29312490 | 29312490 | PRJNA1137393_P_NODE_32649_length_177_cov_1.984375_g32133_i0 | PRJNA1137393 | 32649 | 177 | 1.984375 | 3.51234375 | Erysiphe necator associated chrysovirus 3 | 2742544 | Viruses | Viruses | 89 | 8.19e-19 | NR | QKK35391.1 | 2742544 | g32133 | i0 | 70.7 | 0.983050847457627 | 58 | 17 | 98.3 | 0 | 1 | 174 | 379 | 436 | QKK35391.1 hypothetical protein [Erysiphe necator associated chrysovirus 3] | diamond | 174 | 89 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Chrysovirus | Erysiphe necator associated chrysovirus 3 | ||
| 29312502 | 29312502 | PRJNA1137393_P_NODE_6869_length_324_cov_2.007273_g6353_i0 | PRJNA1137393 | 6869 | 324 | 2.007273 | 6.50356452 | Erysiphe necator associated chrysovirus 3 | 2742544 | Viruses | Viruses | 156 | 1.01e-41 | NR | QKK35390.1 | 2742544 | g6353 | i0 | 73.8 | 1.98148148148148 | 107 | 28 | 99.1 | 0 | 323 | 3 | 322 | 428 | QKK35390.1 capsid protein [Erysiphe necator associated chrysovirus 3] | diamond | 642 | 156 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Chrysovirus | Erysiphe necator associated chrysovirus 3 | ||
| 30260228 | 30260228 | PRJNA1137393_P_NODE_7552_length_306_cov_1.564202_g7036_i0 | PRJNA1137393 | 7552 | 306 | 1.564202 | 4.78645812 | Grapevine associated chrysovirus-1 | 908828 | Viruses | Viruses | 110 | 1.31e-25 | NR | ADO60926.1 | 908828 | g7036 | i0 | 81.5 | 1.27450980392157 | 65 | 12 | 63.7 | 0 | 112 | 306 | 460 | 524 | ADO60926.1 putative RNA-dependent RNA polymerase, partial [Grapevine associated chrysovirus-1] | diamond | 390 | 110 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Chrysovirus | Grapevine associated chrysovirus-1 | ||
| 30386727 | 30386727 | PRJNA1137393_P_NODE_13673_length_229_cov_2.377778_g13157_i0 | PRJNA1137393 | 13673 | 229 | 2.377778 | 5.44511162 | Chrysothrix chrysovirus 1 | 2682569 | Viruses | Viruses | 80.5 | 1.6e-15 | NR | YP_010088083.1 | 2682569 | g13157 | i0 | 41.9 | 0.96943231441048 | 74 | 43 | 96.9 | 0 | 228 | 7 | 675 | 748 | YP_010088083.1 hypothetical protein KM773_s3gp1 [Chrysothrix chrysovirus 1] | diamond | 222 | 80.5 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus chrysothricis | ||
| 31618974 | 31618974 | PRJNA1137393_P_NODE_29556_length_182_cov_1.458647_g29040_i0 | PRJNA1137393 | 29556 | 182 | 1.458647 | 2.65473754 | Erysiphe necator associated chrysovirus 3 | 2742544 | Viruses | Viruses | 78.6 | 3.87e-15 | NR | QKK35391.1 | 2742544 | g29040 | i0 | 63.6 | 0.906593406593407 | 55 | 20 | 90.7 | 0 | 17 | 181 | 70 | 124 | QKK35391.1 hypothetical protein [Erysiphe necator associated chrysovirus 3] | diamond | 165 | 78.6 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Chrysovirus | Erysiphe necator associated chrysovirus 3 | ||
| 32536703 | 32536703 | PRJNA1137393_P_NODE_22679_length_194_cov_1.889655_g22163_i0 | PRJNA1137393 | 22679 | 194 | 1.889655 | 3.6659307 | Erysiphe necator associated chrysovirus 3 | 2742544 | Viruses | Viruses | 48.9 | 1.31e-4 | NR | QKK35390.1 | 2742544 | g22163 | i0 | 32.8 | 0.989690721649485 | 64 | 43 | 99 | 0 | 194 | 3 | 800 | 863 | QKK35390.1 capsid protein [Erysiphe necator associated chrysovirus 3] | diamond | 192 | 48.9 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Chrysovirus | Erysiphe necator associated chrysovirus 3 | ||
| 32599696 | 32599696 | PRJNA1137393_P_NODE_15360_length_220_cov_1.847953_g14844_i0 | PRJNA1137393 | 15360 | 220 | 1.847953 | 4.0654966 | Erysiphe necator associated chrysovirus 3 | 2742544 | Viruses | Viruses | 75.9 | 5.94e-14 | NR | QKK35391.1 | 2742544 | g14844 | i0 | 47.3 | 1.00909090909091 | 74 | 38 | 99.5 | 1 | 219 | 1 | 472 | 545 | QKK35391.1 hypothetical protein [Erysiphe necator associated chrysovirus 3] | diamond | 222 | 75.9 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Chrysovirus | Erysiphe necator associated chrysovirus 3 |
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);;