contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA611476" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18441231 | 18441231 | PRJNA611476_P_NODE_2035_length_1381_cov_1.941131_g1522_i0 | PRJNA611476 | 2035 | 1381 | 1.941131 | 26.80701911 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 890 | 1.55e-305 | NR | XDJ26655.1 | 1530251 | g1522 | i0 | 92.3 | 1.01882693700217 | 469 | 27 | 99.9 | 1 | 1380 | 1 | 1072 | 1540 | XDJ26655.1 polyprotein [Picornaviridae sp.] | diamond | 1407 | 890 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 20991568 | 20991568 | PRJNA611476_P_NODE_23097_length_418_cov_1.397101_g22306_i0 | PRJNA611476 | 23097 | 418 | 1.397101 | 5.83988218 | Apple latent spherical virus | 101688 | Viruses | Viruses | 213 | 6.25e-61 | NR | NP_620568.1 | 101688 | g22306 | i0 | 76.3 | 0.997607655502392 | 139 | 33 | 99.8 | 0 | 2 | 418 | 448 | 586 | NP_620568.1 235K polyprotein [Apple latent spherical virus] | diamond | 417 | 213 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Cheravirus | Cheravirus mali | ||
| 26649931 | 26649931 | PRJNA611476_P_NODE_54401_length_296_cov_2.475336_g53610_i0 | PRJNA611476 | 54401 | 296 | 2.475336 | 7.32699456 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 46.2 | 0.0044 | NR | UCS96340.1 | RQ13 | g53610 | i0 | 40.8 | 3.31418918918919 | 71 | 40 | 69.9 | 1 | 13 | 219 | 1208 | 1278 | UCS96340.1 MAG: polyprotein, partial [Picornaviridae sp.] | diamond | 981 | 46.6 | 0.991416309012876 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish jaw picornavirus | |||
| 26668416 | 26668416 | PRJNA611476_P_NODE_29921_length_376_cov_1.283828_g29130_i0 | PRJNA611476 | 29921 | 376 | 1.283828 | 4.82719328 | Currant latent virus | 1476584 | Viruses | Viruses | 71.6 | 1.28e-11 | NR | WMN13751.1 | 1476584 | g29130 | i0 | 42.2 | 0.86968085106383 | 109 | 62 | 87 | 1 | 329 | 3 | 17 | 124 | WMN13751.1 polyprotein [Currant latent virus] | diamond | 327 | 71.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Cheravirus | Cheravirus ribis | ||
| 26763695 | 26763695 | PRJNA611476_P_NODE_8301_length_673_cov_2.145000_g7527_i0 | PRJNA611476 | 8301 | 673 | 2.145 | 14.43585 | Sea turtle neural virus 1 | 3112944 | Viruses | Viruses | 49.3 | 0.0065 | NR | WET19891.1 | 3112944 | g7527 | i0 | 52.5 | 0.178306092124814 | 40 | 19 | 17.8 | 0 | 673 | 554 | 458 | 497 | WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1] | diamond | 120 | 49.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Sea turtle neural virus 1 | ||
| 27522484 | 27522484 | PRJNA611476_P_NODE_3143_length_1110_cov_1.689489_g2537_i0 | PRJNA611476 | 3143 | 1110 | 1.689489 | 18.7533279 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 267 | 3.63e-76 | NR | XBH24011.1 | RQ13 | g2537 | i0 | 51.7 | 4.18648648648649 | 259 | 123 | 69.5 | 2 | 6 | 776 | 2127 | 2385 | XBH24011.1 MAG: polyprotein [Coleura bat picornavirus] | diamond | 4647 | 267 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Zebrafish jaw picornavirus | ||||
| 27901227 | 27901227 | PRJNA611476_P_NODE_19965_length_446_cov_1.139410_g19174_i0 | PRJNA611476 | 19965 | 446 | 1.13941 | 5.0817686 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 276 | 5.57e-83 | NR | XDJ26655.1 | 1530251 | g19174 | i0 | 99.3 | 0.995515695067265 | 148 | 1 | 99.6 | 0 | 446 | 3 | 29 | 176 | XDJ26655.1 polyprotein [Picornaviridae sp.] | diamond | 444 | 276 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 28438372 | 28438372 | PRJNA611476_P_NODE_67766_length_271_cov_1.166667_g66975_i0 | PRJNA611476 | 67766 | 271 | 1.166667 | 3.16166757 | Apple latent spherical virus | 101688 | Viruses | Viruses | 182 | 3.44e-51 | NR | NP_620568.1 | 101688 | g66975 | i0 | 95.5 | 1.97047970479705 | 89 | 4 | 98.5 | 0 | 269 | 3 | 1447 | 1535 | NP_620568.1 235K polyprotein [Apple latent spherical virus] | diamond | 534 | 182 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Cheravirus | Cheravirus mali | ||
| 28722495 | 28722495 | PRJNA611476_P_NODE_54827_length_295_cov_1.734234_g54036_i0 | PRJNA611476 | 54827 | 295 | 1.734234 | 5.1159903 | Apple latent spherical virus | 101688 | Viruses | Viruses | 183 | 3.69e-51 | NR | NP_620568.1 | 101688 | g54036 | i0 | 90.8 | 1.99322033898305 | 98 | 9 | 99.7 | 0 | 1 | 294 | 1975 | 2072 | NP_620568.1 235K polyprotein [Apple latent spherical virus] | diamond | 588 | 183 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Cheravirus | Cheravirus mali | ||
| 28753892 | 28753892 | PRJNA611476_P_NODE_112687_length_242_cov_0.911243_g111896_i0 | PRJNA611476 | 112687 | 242 | 0.911243 | 2.20520806 | Glyptostrobus pensilis prunevirus | 2765862 | Viruses | Viruses | 138 | 1.26e-39 | NR | DAF42475.1 | 2765862 | g111896 | i0 | 83.8 | 0.991735537190083 | 80 | 13 | 99.2 | 0 | 242 | 3 | 74 | 153 | DAF42475.1 TPA_exp: movement protein, partial [Glyptostrobus pensilis prunevirus] | diamond | 240 | 138 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Glyptostrobus pensilis prunevirus | ||
| 28830059 | 28830059 | PRJNA611476_P_NODE_87868_length_249_cov_0.875000_g87077_i0 | PRJNA611476 | 87868 | 249 | 0.875 | 2.17875 | Prunevirus | 1914295 | Viruses | Viruses | 102 | 2.97e-23 | NR | BBH55948.1 | 2560282 | g87077 | i0 | 57.3 | 1.80722891566265 | 75 | 32 | 90.4 | 0 | 23 | 247 | 168 | 242 | BBH55948.1 movement protein [Actinidia seed borne latent virus] | diamond | 450 | 102 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Prunevirus actinidiae | ||
| 28880131 | 28880131 | PRJNA611476_P_NODE_33348_length_361_cov_1.069444_g32557_i0 | PRJNA611476 | 33348 | 361 | 1.069444 | 3.86069284 | Daiswa trichovirus 1 | 2794435 | Viruses | Viruses | 215 | 6.469999999999998e-69 | NR | QQG34597.1 | 2794435 | g32557 | i0 | 93.3 | 0.988919667590028 | 119 | 8 | 98.9 | 0 | 359 | 3 | 3 | 121 | QQG34597.1 CP [Daiswa trichovirus 1] | diamond | 357 | 215 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Trichovirus | Daiswa trichovirus 1 | ||
| 29258883 | 29258883 | PRJNA611476_P_NODE_39569_length_338_cov_1.490566_g38778_i0 | PRJNA611476 | 39569 | 338 | 1.490566 | 5.03811308 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 209 | 4.56e-60 | NR | XDJ26655.1 | 1530251 | g38778 | i0 | 87.5 | 0.994082840236686 | 112 | 14 | 99.4 | 0 | 337 | 2 | 1530 | 1641 | XDJ26655.1 polyprotein [Picornaviridae sp.] | diamond | 336 | 209 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 29985441 | 29985441 | PRJNA611476_P_NODE_26771_length_393_cov_1.968750_g25980_i0 | PRJNA611476 | 26771 | 393 | 1.96875 | 7.7371875 | Apple latent spherical virus | 101688 | Viruses | Viruses | 204 | 4.26e-58 | NR | NP_620569.1 | 101688 | g25980 | i0 | 96 | 2.26717557251908 | 99 | 4 | 75.6 | 0 | 1 | 297 | 863 | 961 | NP_620569.1 108K polyprotein [Apple latent spherical virus] | diamond | 891 | 204 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Cheravirus | Cheravirus mali | ||
| 30396618 | 30396618 | PRJNA611476_P_NODE_47573_length_314_cov_2.182573_g46782_i0 | PRJNA611476 | 47573 | 314 | 2.182573 | 6.85327922 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 63.9 | 3.25e-9 | NR | YP_009552756.1 | RQ13 | g46782 | i0 | 40.7 | 3.14331210191083 | 108 | 59 | 99.4 | 3 | 1 | 312 | 1713 | 1819 | YP_009552756.1 polyprotein [Rhimavirus A] | diamond | 987 | 63.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish jaw picornavirus | |||
| 30788384 | 30788384 | PRJNA611476_P_NODE_40814_length_334_cov_1.314176_g40023_i0 | PRJNA611476 | 40814 | 334 | 1.314176 | 4.38934784 | Chuvivirus | 2842604 | Viruses | Viruses | 140 | 4.71e-37 | NR | WET19887.1 | 2842604 | g40023 | i0 | 60.9 | 1.97604790419162 | 110 | 43 | 98.8 | 0 | 332 | 3 | 255 | 364 | WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1] | diamond | 660 | 140 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Chuvivirus | ||
| 30978095 | 30978095 | PRJNA611476_P_NODE_115574_length_241_cov_0.916667_g114783_i0 | PRJNA611476 | 115574 | 241 | 0.916667 | 2.20916747 | Prunevirus | 1914295 | Viruses | Viruses | 135 | 9.16e-36 | NR | BBH55948.1 | 2560282 | g114783 | i0 | 77.5 | 1.99170124481328 | 80 | 18 | 99.6 | 0 | 241 | 2 | 115 | 194 | BBH55948.1 movement protein [Actinidia seed borne latent virus] | diamond | 480 | 135 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Prunevirus actinidiae | ||
| 31154061 | 31154061 | PRJNA611476_P_NODE_41075_length_333_cov_2.026923_g40284_i0 | PRJNA611476 | 41075 | 333 | 2.026923 | 6.74965359 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 216 | 1.21e-62 | NR | XDJ26655.1 | 1530251 | g40284 | i0 | 93.7 | 1 | 111 | 7 | 100 | 0 | 1 | 333 | 620 | 730 | XDJ26655.1 polyprotein [Picornaviridae sp.] | diamond | 333 | 216 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 31280814 | 31280814 | PRJNA611476_P_NODE_24795_length_406_cov_1.228228_g24004_i0 | PRJNA611476 | 24795 | 406 | 1.228228 | 4.98660568 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 278 | 1.28e-83 | NR | XDJ26655.1 | 1530251 | g24004 | i0 | 97 | 0.997536945812808 | 135 | 4 | 99.8 | 0 | 405 | 1 | 358 | 492 | XDJ26655.1 polyprotein [Picornaviridae sp.] | diamond | 405 | 278 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 31534161 | 31534161 | PRJNA611476_P_NODE_8516_length_665_cov_1.390203_g7741_i0 | PRJNA611476 | 8516 | 665 | 1.390203 | 9.24484995 | Actinidia seed borne latent virus | 2560282 | Viruses | Viruses | 192 | 7.580000000000001e-58 | NR | YP_009553505.1 | 2560282 | g7741 | i0 | 59.1 | 1.43458646616541 | 159 | 63 | 71.7 | 1 | 189 | 665 | 1 | 157 | YP_009553505.1 coat protein [Actinidia seed borne latent virus] | diamond | 954 | 192 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Prunevirus actinidiae | ||
| 32135109 | 32135109 | PRJNA611476_P_NODE_20658_length_439_cov_1.196721_g19867_i0 | PRJNA611476 | 20658 | 439 | 1.196721 | 5.25360519 | Glyptostrobus pensilis prunevirus | 2765862 | Viruses | Viruses | 109 | 1.5800000000000002e-27 | NR | DAF42478.1 | 2765862 | g19867 | i0 | 52.5 | 0.690205011389522 | 101 | 47 | 69 | 1 | 432 | 130 | 26 | 125 | DAF42478.1 TPA_exp: nucleic acid binding protein [Glyptostrobus pensilis prunevirus] | diamond | 303 | 109 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Glyptostrobus pensilis prunevirus | ||
| 32293590 | 32293590 | PRJNA611476_P_NODE_60619_length_284_cov_1.094787_g59828_i0 | PRJNA611476 | 60619 | 284 | 1.094787 | 3.10919508 | Daiswa trichovirus 1 | 2794435 | Viruses | Viruses | 167 | 7.66e-46 | NR | QQG34598.1 | 2794435 | g59828 | i0 | 92 | 0.919014084507042 | 87 | 7 | 91.9 | 0 | 283 | 23 | 1175 | 1261 | QQG34598.1 RdRp [Daiswa trichovirus 1] | diamond | 261 | 167 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Trichovirus | Daiswa trichovirus 1 | ||
| 32798086 | 32798086 | PRJNA611476_P_NODE_51820_length_303_cov_1.339130_g51029_i0 | PRJNA611476 | 51820 | 303 | 1.33913 | 4.0575639 | Apple latent spherical virus | 101688 | Viruses | Viruses | 193 | 9.229999999999998e-55 | NR | NP_620568.1 | 101688 | g51029 | i0 | 91.9 | 1.96039603960396 | 99 | 8 | 98 | 0 | 2 | 298 | 1831 | 1929 | NP_620568.1 235K polyprotein [Apple latent spherical virus] | diamond | 594 | 193 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Cheravirus | Cheravirus mali |
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);;