contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA382357" and tax_phylum = "Lenarviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16980723 | 16980723 | PRJNA382357_P_NODE_17454_length_523_cov_1.350649_g16724_i0 | PRJNA382357 | 17454 | 523 | 1.350649 | 7.06389427 | Ripasel virus | 3131493 | Viruses | Viruses | 166 | 1.3899999999999998e-48 | NR | WZH61509.1 | 3131493 | g16724 | i0 | 84.9 | 0.533460803059273 | 93 | 14 | 53.3 | 0 | 523 | 245 | 11 | 103 | WZH61509.1 MAG: RNA-dependent RNA polymerase, partial [Ripasel virus] | diamond | 279 | 166 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Ripasel virus | |||
| 26663244 | 26663244 | PRJNA382357_P_NODE_13181_length_586_cov_70.407619_g12460_i0 | PRJNA382357 | 13181 | 586 | 70.407619 | 412.58864734 | Plasmopara viticola lesion associated mitovirus 21 | 2719447 | Viruses | Viruses | 102 | 1.44e-21 | NR | QIR30244.1 | 2719447 | g12460 | i0 | 58.5 | 0.48122866894198 | 94 | 38 | 47.6 | 1 | 374 | 96 | 49 | 142 | QIR30244.1 RNA-dependent RNA polymerase [Plasmopara viticola lesion associated mitovirus 21] | diamond | 282 | 102 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Plasmopara viticola lesion associated mitovirus 21 | ||
| 26695128 | 26695128 | PRJNA382357_P_NODE_341_length_2871_cov_78.447687_g81_i0 | PRJNA382357 | 341 | 2871 | 78.447687 | 2252.23309377 | Hangzhou mitovirus 3 | 2905238 | Viruses | Viruses | 318 | 2.03e-92 | NR | UHK03166.1 | 2905238 | g81 | i0 | 34.8 | 0.689655172413793 | 660 | 383 | 67.5 | 20 | 2050 | 113 | 48 | 674 | UHK03166.1 MAG: RNA-dependent RNA polymerase, partial [Hangzhou mitovirus 3] | diamond | 1980 | 318 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Hangzhou mitovirus 3 | ||
| 27422970 | 27422970 | PRJNA382357_P_NODE_303_length_3175_cov_52.189788_g51_i0 | PRJNA382357 | 303 | 3175 | 52.189788 | 1657.025769 | Yunnan mito-like virus 32 | 2937238 | Viruses | Viruses | 154 | 1.9e-34 | NR | UPW42288.1 | 2937238 | g51 | i0 | 33.6 | 0.854173228346457 | 298 | 177 | 26.6 | 7 | 1568 | 2413 | 171 | 463 | UPW42288.1 MAG: putative RNA dependent RNA polymerase [Yunnan mito-like virus 32] | diamond | 2712 | 154 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Yunnan mito-like virus 32 | |||
| 28085710 | 28085710 | PRJNA382357_P_NODE_425_length_2407_cov_126.497016_g81_i1 | PRJNA382357 | 425 | 2407 | 126.497016 | 3044.78317512 | Hangzhou mitovirus 3 | 2905238 | Viruses | Viruses | 226 | 8.06e-60 | NR | UHK03166.1 | 2905238 | g81 | i1 | 34.8 | 0.523473203157457 | 420 | 258 | 51.1 | 11 | 2279 | 1050 | 168 | 581 | UHK03166.1 MAG: RNA-dependent RNA polymerase, partial [Hangzhou mitovirus 3] | diamond | 1260 | 226 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Hangzhou mitovirus 3 | ||
| 29348821 | 29348821 | PRJNA382357_P_NODE_150789_length_204_cov_0.909091_g150050_i0 | PRJNA382357 | 150789 | 204 | 0.909091 | 1.85454564 | Guiyang mito-like virus 4 | 2970162 | Viruses | Viruses | 66.6 | 8.27e-11 | NR | UUW21446.1 | 2970162 | g150050 | i0 | 51.5 | 1.92647058823529 | 66 | 32 | 97.1 | 0 | 3 | 200 | 113 | 178 | UUW21446.1 MAG: RNA-dependent RNA polymerase [Guiyang mito-like virus 4] | diamond | 393 | 66.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Guiyang mito-like virus 4 | |||
| 29569699 | 29569699 | PRJNA382357_P_NODE_490_length_2212_cov_128.728033_g81_i4 | PRJNA382357 | 490 | 2212 | 128.728033 | 2847.46408996 | Hangzhou mitovirus 3 | 2905238 | Viruses | Viruses | 237 | 2.6e-64 | NR | UHK03166.1 | 2905238 | g81 | i4 | 34.9 | 0.594032549728752 | 438 | 269 | 58 | 11 | 129 | 1412 | 168 | 599 | UHK03166.1 MAG: RNA-dependent RNA polymerase, partial [Hangzhou mitovirus 3] | diamond | 1314 | 237 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Hangzhou mitovirus 3 | ||
| 30328373 | 30328373 | PRJNA382357_P_NODE_2812_length_1107_cov_127.379541_g81_i7 | PRJNA382357 | 2812 | 1107 | 127.379541 | 1410.09151887 | Hangzhou mitovirus 3 | 2905238 | Viruses | Viruses | 133 | 2.9299999999999997e-30 | NR | UHK03166.1 | 2905238 | g81 | i7 | 35.4 | 0.750677506775068 | 277 | 161 | 72.4 | 9 | 195 | 995 | 406 | 674 | UHK03166.1 MAG: RNA-dependent RNA polymerase, partial [Hangzhou mitovirus 3] | diamond | 831 | 133 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Hangzhou mitovirus 3 | ||
| 31275735 | 31275735 | PRJNA382357_P_NODE_475_length_2258_cov_126.609467_g81_i3 | PRJNA382357 | 475 | 2258 | 126.609467 | 2858.84176486 | Hangzhou mitovirus 3 | 2905238 | Viruses | Viruses | 273 | 3.0900000000000002e-77 | NR | UHK03166.1 | 2905238 | g81 | i3 | 35.5 | 0.688219663418955 | 518 | 309 | 67 | 15 | 635 | 2146 | 168 | 674 | UHK03166.1 MAG: RNA-dependent RNA polymerase, partial [Hangzhou mitovirus 3] | diamond | 1554 | 273 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Hangzhou mitovirus 3 | ||
| 31497361 | 31497361 | PRJNA382357_P_NODE_436_length_2377_cov_90.207686_g81_i2 | PRJNA382357 | 436 | 2377 | 90.207686 | 2144.23669622 | Hangzhou mitovirus 3 | 2905238 | Viruses | Viruses | 318 | 6.95e-94 | NR | UHK03166.1 | 2905238 | g81 | i2 | 34.8 | 0.83298275136727 | 660 | 383 | 81.5 | 20 | 2050 | 113 | 48 | 674 | UHK03166.1 MAG: RNA-dependent RNA polymerase, partial [Hangzhou mitovirus 3] | diamond | 1980 | 318 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Hangzhou mitovirus 3 | ||
| 32320032 | 32320032 | PRJNA382357_P_NODE_142779_length_207_cov_2.671233_g142040_i0 | PRJNA382357 | 142779 | 207 | 2.671233 | 5.52945231 | Rhizoctonia cerealis duamitovirus | 3068666 | Viruses | Viruses | 57.4 | 1.57e-7 | NR | WMI40069.1 | 3068666 | g142040 | i0 | 53 | 0.956521739130435 | 66 | 31 | 95.7 | 0 | 206 | 9 | 53 | 118 | WMI40069.1 MAG: RNA-dependent RNA polymerase [Rhizoctonia cerealis duamitovirus] | diamond | 198 | 57.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Duamitovirus | Rhizoctonia cerealis duamitovirus | ||
| 32382964 | 32382964 | PRJNA382357_P_NODE_1819_length_1292_cov_142.524777_g81_i6 | PRJNA382357 | 1819 | 1292 | 142.524777 | 1841.42011884 | Hangzhou mitovirus 3 | 2905238 | Viruses | Viruses | 176 | 1.1999999999999998e-44 | NR | UHK03166.1 | 2905238 | g81 | i6 | 38.3 | 0.703560371517028 | 303 | 171 | 68.7 | 9 | 293 | 1180 | 381 | 674 | UHK03166.1 MAG: RNA-dependent RNA polymerase, partial [Hangzhou mitovirus 3] | diamond | 909 | 176 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Hangzhou mitovirus 3 | ||
| 32730348 | 32730348 | PRJNA382357_P_NODE_520_length_2152_cov_125.491153_g81_i5 | PRJNA382357 | 520 | 2152 | 125.491153 | 2700.56961256 | Hangzhou mitovirus 3 | 2905238 | Viruses | Viruses | 204 | 2.2599999999999998e-52 | NR | UHK03166.1 | 2905238 | g81 | i5 | 35.6 | 0.50185873605948 | 360 | 220 | 49.1 | 8 | 129 | 1184 | 168 | 523 | UHK03166.1 MAG: RNA-dependent RNA polymerase, partial [Hangzhou mitovirus 3] | diamond | 1080 | 204 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Hangzhou mitovirus 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);;