contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA906294" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14916971 | 14916971 | PRJNA906294_P_NODE_51612_length_688_cov_2.035772_g47622_i0 | PRJNA906294 | 51612 | 688 | 2.035772 | 14.00611136 | Lychnis mottle virus | 1676256 | Viruses | Viruses | 453 | 2.849999999999999e-150 | NR | QXI69680.1 | 1676256 | g47622 | i0 | 96.9 | 0.994186046511628 | 228 | 7 | 99.4 | 0 | 687 | 4 | 167 | 394 | QXI69680.1 polyprotein [Lychnis mottle virus] | diamond | 684 | 453 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Stralarivirus | Stralarivirus lychnis | ||
| 26834553 | 26834553 | PRJNA906294_P_NODE_168161_length_288_cov_1.888372_g164045_i0 | PRJNA906294 | 168161 | 288 | 1.888372 | 5.43851136 | Varroa destructor virus 2 | 2056384 | Viruses | Viruses | 186 | 2e-52 | NR | YP_009552119.1 | 2056384 | g164045 | i0 | 96.8 | 3.95833333333333 | 95 | 3 | 99 | 0 | 3 | 287 | 1347 | 1441 | YP_009552119.1 polyprotein [Varroa destructor virus 2] | diamond | 1140 | 186 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Iflavirus vadestruente | ||
| 28192723 | 28192723 | PRJNA906294_P_NODE_161286_length_297_cov_0.991071_g157170_i0 | PRJNA906294 | 161286 | 297 | 0.991071 | 2.94348087 | Varroa destructor virus 2 | 2056384 | Viruses | Viruses | 202 | 9.66e-58 | NR | QFS19921.1 | 2056384 | g157170 | i0 | 98 | 2 | 99 | 2 | 100 | 0 | 297 | 1 | 989 | 1087 | QFS19921.1 polyprotein [Varroa destructor virus 2] | diamond | 594 | 202 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Iflavirus vadestruente | ||
| 28263440 | 28263440 | PRJNA906294_P_NODE_48946_length_716_cov_2.412131_g45004_i0 | PRJNA906294 | 48946 | 716 | 2.412131 | 17.27085796 | Stralarivirus | 2948915 | Viruses | Viruses | 453 | 2.7899999999999993e-152 | NR | BBG58107.1 | 1676255 | g45004 | i0 | 93.3 | 3.9804469273743 | 238 | 16 | 99.7 | 0 | 1 | 714 | 487 | 724 | BBG58107.1 polyprotein, partial [Cnidium vein yellowing virus 2] | diamond | 2850 | 453 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Cnidium vein yellowing virus 2 | ||||
| 28982492 | 28982492 | PRJNA906294_P_NODE_102788_length_407_cov_1.541916_g98673_i0 | PRJNA906294 | 102788 | 407 | 1.541916 | 6.27559812 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 114 | 2.99e-26 | NR | WLN26256.1 | 3065075 | g98673 | i0 | 46.4 | 0.921375921375921 | 125 | 65 | 90.7 | 1 | 405 | 37 | 110 | 234 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 375 | 114 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 30782640 | 30782640 | PRJNA906294_P_NODE_57514_length_635_cov_1.211744_g53466_i0 | PRJNA906294 | 57514 | 635 | 1.211744 | 7.6945744 | Lychnis mottle virus | 1676256 | Viruses | Viruses | 409 | 7.199999999999999e-141 | NR | YP_010840983.1 | 1676256 | g53466 | i0 | 95.3 | 3.98740157480315 | 211 | 10 | 99.7 | 0 | 2 | 634 | 129 | 339 | YP_010840983.1 large coat protein [Lychnis mottle virus] | diamond | 2532 | 409 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Stralarivirus | Stralarivirus lychnis | ||
| 31129852 | 31129852 | PRJNA906294_P_NODE_196755_length_258_cov_2.102703_g192639_i0 | PRJNA906294 | 196755 | 258 | 2.102703 | 5.42497374 | Lychnis mottle virus | 1676256 | Viruses | Viruses | 169 | 3.0999999999999996e-49 | NR | YP_010840983.1 | 1676256 | g192639 | i0 | 94.1 | 0.988372093023256 | 85 | 5 | 98.8 | 0 | 3 | 257 | 175 | 259 | YP_010840983.1 large coat protein [Lychnis mottle virus] | diamond | 255 | 169 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Stralarivirus | Stralarivirus lychnis | ||
| 31351594 | 31351594 | PRJNA906294_P_NODE_164916_length_292_cov_1.397260_g160800_i0 | PRJNA906294 | 164916 | 292 | 1.39726 | 4.0799992 | Soybean thrips partiti-like virus 8 | 2801010 | Viruses | Viruses | 137 | 2.06e-35 | NR | QQO81404.1 | 2801010 | g160800 | i0 | 67.7 | 1.97260273972603 | 96 | 31 | 98.6 | 0 | 290 | 3 | 479 | 574 | QQO81404.1 RNA-dependent RNA polymerase [Soybean thrips partiti-like virus 8] | diamond | 576 | 137 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Soybean thrips partiti-like virus 8 | |||
| 31770171 | 31770171 | PRJNA906294_P_NODE_144797_length_319_cov_1.357724_g140681_i0 | PRJNA906294 | 144797 | 319 | 1.357724 | 4.3311395600000004 | Iflavirus | 232799 | Viruses | Viruses | 204 | 1.48e-58 | NR | QFS19921.1 | 2056384 | g140681 | i0 | 99.1 | 4.98432601880878 | 106 | 1 | 99.7 | 0 | 1 | 318 | 1296 | 1401 | QFS19921.1 polyprotein [Varroa destructor virus 2] | diamond | 1590 | 204 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Iflavirus vadestruente | ||
| 31991600 | 31991600 | PRJNA906294_P_NODE_231198_length_241_cov_0.904762_g227082_i0 | PRJNA906294 | 231198 | 241 | 0.904762 | 2.18047642 | Iflavirus | 232799 | Viruses | Viruses | 166 | 1.4099999999999998e-45 | NR | QFS19921.1 | 2056384 | g227082 | i0 | 97.5 | 2.95020746887967 | 79 | 2 | 98.3 | 0 | 3 | 239 | 1686 | 1764 | QFS19921.1 polyprotein [Varroa destructor virus 2] | diamond | 711 | 167 | 0.994011976047904 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Iflavirus vadestruente | ||
| 32522324 | 32522324 | PRJNA906294_P_NODE_174419_length_281_cov_1.682692_g170303_i0 | PRJNA906294 | 174419 | 281 | 1.682692 | 4.72836452 | Varroa destructor virus 2 | 2056384 | Viruses | Viruses | 182 | 4.09e-51 | NR | YP_009552119.1 | 2056384 | g170303 | i0 | 91.4 | 1.98576512455516 | 93 | 8 | 99.3 | 0 | 1 | 279 | 1872 | 1964 | YP_009552119.1 polyprotein [Varroa destructor virus 2] | diamond | 558 | 182 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Iflavirus vadestruente | ||
| 32742835 | 32742835 | PRJNA906294_P_NODE_55060_length_656_cov_2.205832_g51029_i0 | PRJNA906294 | 55060 | 656 | 2.205832 | 14.47025792 | Lychnis mottle virus | 1676256 | Viruses | Viruses | 399 | 1.69e-137 | NR | YP_010840982.1 | 1676256 | g51029 | i0 | 96.2 | 1.92073170731707 | 210 | 8 | 96 | 0 | 26 | 655 | 1 | 210 | YP_010840982.1 movement protein [Lychnis mottle virus] | diamond | 1260 | 399 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Stralarivirus | Stralarivirus lychnis |
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);;