RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJNA1063685", tax_phylum = "Kitrinoviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 22 ✖

tax_phylum 1

  • Kitrinoviricota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1063685 · 22 ✖

tax_clade 0

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
179388 179388 PRJNA1063685_S_NODE_14561_length_567_cov_7.137652_g14034_i0 PRJNA1063685 14561 567 7.137652 40.47048684 Asian prunus virus 3 351428 Viruses Viruses 909 0   NTclustered gi|967079770|gb|KT893298.1| 351428 g14034 i0 95.745 27.037037037037 564 24 99 0 1 564 8181 8744 Asian prunus virus 3 isolate Tatao25 Q-375-02, partial genome blastn 15330 909 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Foveavirus Asian prunus virus 3
1454215 1454215 PRJNA1063685_S_NODE_30762_length_423_cov_4.560000_g30220_i0 PRJNA1063685 30762 423 4.56 19.2888 Potexvirus eczygocacti 3433841 Viruses Viruses 392 2.11e-104   NTclustered gi|38146346|gb|AY366208.1| 253701 g30220 i0 85.233 6.69267139479905 386 51 91 2 17 401 381 1 Zygocactus virus X strain B1 replication-associated protein, triple gene block protein 1, triple gene block protein 2, triple gene block protein 3, and coat protein genes, complete cds blastn 2831 392 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus eczygocacti
4005771 4005771 PRJNA1063685_S_NODE_1144_length_1065_cov_14.196573_g901_i0 PRJNA1063685 1144 1065 14.196573 151.19350245 Robigovirus viridiavii 3432176 Viruses Viruses 1773 0   NTclustered gi|408355234|gb|JX501670.1| 65467 g901 i0 96.714 14.8300469483568 1065 35 100 0 1 1065 5415 4351 Cherry green ring mottle virus isolate F9, complete genome blastn 15794 1773 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Robigovirus Robigovirus viridiavii
4005827 4005827 PRJNA1063685_S_NODE_17304_length_536_cov_8.557235_g16770_i0 PRJNA1063685 17304 536 8.557235 45.8667796 Trichovirus chloropersicae 3432984 Viruses Viruses 719 0   NTclustered gi|1479557639|gb|MH084696.1| 2358294 g16770 i0 90.858 97.9757462686567 536 49 100 0 1 536 856 321 Peach chlorotic leaf spot virus isolate RP19-2, complete genome blastn 52515 719 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus chloropersicae
5282185 5282185 PRJNA1063685_S_NODE_2065_length_897_cov_6.487864_g1729_i0 PRJNA1063685 2065 897 6.487864 58.19614008 Trichovirus mali 12175 Viruses Viruses 1280 0   NTclustered gi|1214575042|gb|KY310574.1| 12175 g1729 i0 93.511 13.4827201783724 863 52 96 4 24 884 1710 2570 Trichovirus mali isolate BC, complete genome blastn 12094 1280 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus mali
5282367 5282367 PRJNA1063685_S_NODE_37365_length_382_cov_6.922330_g36822_i0 PRJNA1063685 37365 382 6.92233 26.4433006 Trichovirus mali 12175 Viruses Viruses 623 6.159999999999999e-174   NTclustered gi|1214575050|gb|KY310576.1| 12175 g36822 i0 97.527 94.6204188481675 364 9 95 0 19 382 290 653 Trichovirus mali isolate CJ, complete genome blastn 36145 623 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus mali
5282518 5282518 PRJNA1063685_S_NODE_5325_length_723_cov_17.726154_g4879_i0 PRJNA1063685 5325 723 17.726154 128.16009342 Robigovirus viridiavii 3432176 Viruses Viruses 1171 0   NTclustered gi|2108668298|gb|MZ148117.1| 65467 g4879 i0 96.987 85.8727524204703 697 21 96 0 1 697 7657 8353 Cherry green ring mottle virus isolate 13C297, complete genome blastn 62086 1171 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Robigovirus Robigovirus viridiavii
6557252 6557252 PRJNA1063685_S_NODE_11086_length_613_cov_3.312963_g10571_i0 PRJNA1063685 11086 613 3.312963 20.30846319 Trichovirus chloropersicae 3432984 Viruses Viruses 725 0   NTclustered gi|1479557639|gb|MH084696.1| 2358294 g10571 i0 88.264 9.65742251223491 605 71 99 0 9 613 3533 4137 Peach chlorotic leaf spot virus isolate RP19-2, complete genome blastn 5920 725 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus chloropersicae
6557354 6557354 PRJNA1063685_S_NODE_21066_length_499_cov_19.723005_g20528_i0 PRJNA1063685 21066 499 19.723005 98.41779495 Robigovirus viridiavii 3432176 Viruses Viruses 802 0   NTclustered gi|2108668298|gb|MZ148117.1| 65467 g20528 i0 97.059 68.7054108216433 476 14 95 0 1 476 7482 7007 Cherry green ring mottle virus isolate 13C297, complete genome blastn 34284 802 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Robigovirus Robigovirus viridiavii
9106929 9106929 PRJNA1063685_S_NODE_12688_length_590_cov_27.940039_g12170_i0 PRJNA1063685 12688 590 27.940039 164.8462301 Trichovirus chloropersicae 3432984 Viruses Viruses 721 0   NTclustered gi|1479557639|gb|MH084696.1| 2358294 g12170 i0 89.594 4.37118644067797 567 59 96 0 1 567 6718 6152 Peach chlorotic leaf spot virus isolate RP19-2, complete genome blastn 2579 721 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus chloropersicae
10382971 10382971 PRJNA1063685_S_NODE_4869_length_736_cov_12.167421_g4439_i0 PRJNA1063685 4869 736 12.167421 89.55221856 Asian prunus virus 3 351428 Viruses Viruses 1266 0   NTclustered gi|78364914|gb|DQ205238.1| 351428 g4439 i0 97.693 27.3546195652174 737 15 100 2 1 736 2243 1508 Asian prunus virus 3 isolate Ku Chu'a Hung Q-375-18 triple gene block protein 3 (TGBp3) gene, partial cds; and coat protein (CP) gene, complete cds blastn 20133 1266 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Foveavirus Asian prunus virus 3
11658486 11658486 PRJNA1063685_S_NODE_8410_length_655_cov_8.998282_g7906_i0 PRJNA1063685 8410 655 8.998282 58.9387471 Trichovirus mali 12175 Viruses Viruses 1022 0   NTclustered gi|1214575042|gb|KY310574.1| 12175 g7906 i0 96.019 24.7267175572519 628 25 96 0 26 653 5851 6478 Trichovirus mali isolate BC, complete genome blastn 16196 1022 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus mali
12933317 12933317 PRJNA1063685_S_NODE_35931_length_390_cov_11.605678_g35388_i0 PRJNA1063685 35931 390 11.605678 45.2621442 Potexvirus eczygocacti 3433841 Viruses Viruses 669 0   NTclustered gi|828276863|gb|KM288845.1| 253701 g35388 i0 99.457 18.3589743589744 368 2 94 0 23 390 1982 2349 Zygocactus virus X isolate TW-5149-17 replication-associated protein (RdRP) gene, partial cds; and triple gene block protein 1 (TGB1), triple gene block protein 2 (TGB2), triple gene block protein 3 (TGB3), and coat protein (CP) genes, complete cds blastn 7160 669 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus eczygocacti
12933503 12933503 PRJNA1063685_S_NODE_58611_length_285_cov_1.891509_g58068_i0 PRJNA1063685 58611 285 1.891509 5.39080065 Robigovirus viridiavii 3432176 Viruses Viruses 446 1.03e-120   NTclustered gi|2108668298|gb|MZ148117.1| 65467 g58068 i0 97.328 5.36842105263158 262 7 92 0 21 282 3607 3868 Cherry green ring mottle virus isolate 13C297, complete genome blastn 1530 446 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Robigovirus Robigovirus viridiavii
12933631 12933631 PRJNA1063685_S_NODE_8211_length_658_cov_36.741880_g7710_i0 PRJNA1063685 8211 658 36.74188 241.7615704 Robigovirus viridiavii 3432176 Viruses Viruses 1000 0   NTclustered gi|408355234|gb|JX501670.1| 65467 g7710 i0 96.975 43.773556231003 595 18 90 0 48 642 1 595 Cherry green ring mottle virus isolate F9, complete genome blastn 28803 1000 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Robigovirus Robigovirus viridiavii
12933651 12933651 PRJNA1063685_S_NODE_9931_length_630_cov_5.357271_g9419_i0 PRJNA1063685 9931 630 5.357271 33.7508073 Trichovirus mali 12175 Viruses Viruses 1064 0   NTclustered gi|1214575042|gb|KY310574.1| 12175 g9419 i0 97.735 92.6126984126984 618 14 98 0 13 630 7538 6921 Trichovirus mali isolate BC, complete genome blastn 58346 1064 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus mali
15482145 15482145 PRJNA1063685_S_NODE_14113_length_572_cov_7.837675_g13589_i0 PRJNA1063685 14113 572 7.837675 44.831501 Trichovirus chloropersicae 3432984 Viruses Viruses 846 0   NTclustered gi|1479557639|gb|MH084696.1| 2358294 g13589 i0 93.939 62.9195804195804 561 33 98 1 1 561 7452 6893 Peach chlorotic leaf spot virus isolate RP19-2, complete genome blastn 35990 846 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus chloropersicae
19305176 19305176 PRJNA1063685_S_NODE_24796_length_467_cov_13.482234_g24256_i0 PRJNA1063685 24796 467 13.482234 62.96203278 Robigovirus viridiavii 3432176 Viruses Viruses 660 0   NTclustered gi|2108668298|gb|MZ148117.1| 65467 g24256 i0 93.468 3.77516059957173 444 29 95 0 24 467 1594 2037 Cherry green ring mottle virus isolate 13C297, complete genome blastn 1763 660 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Robigovirus Robigovirus viridiavii
21856446 21856446 PRJNA1063685_S_NODE_38678_length_375_cov_5.052980_g38135_i0 PRJNA1063685 38678 375 5.05298 18.948675 Potexvirus ecscacti 3433821 Viruses Viruses 628 1.2999999999999994e-175   NTclustered gi|386267043|gb|JF937699.1| 112227 g38135 i0 98.864 30.6906666666667 352 4 94 0 1 352 6592 6241 Cactus virus X isolate NTU, complete genome blastn 11509 628 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus ecscacti
21856555 21856555 PRJNA1063685_S_NODE_52738_length_307_cov_2.952991_g52195_i0 PRJNA1063685 52738 307 2.952991 9.06568237 Foveavirus duoasiaticum 3428809 Viruses Viruses 243 1.58e-59   NTclustered gi|967079599|gb|KT893295.1| 351426 g52195 i0 82.206 2.36807817589577 281 50 92 0 24 304 5989 6269 Asian prunus virus 2 isolate Bonsai, complete genome blastn 727 243 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Foveavirus Foveavirus duoasiaticum
23131786 23131786 PRJNA1063685_S_NODE_27239_length_449_cov_5.558511_g26698_i0 PRJNA1063685 27239 449 5.558511 24.95771439 Allexivirus ecsallii 3433712 Viruses Viruses 697 0   NTclustered gi|1722561632|gb|MN059412.1| 150284 g26698 i0 97.317 87.8596881959911 410 11 91 0 17 426 7931 7522 Garlic virus X isolate G43-1, complete genome blastn 39449 697 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Allexivirus Allexivirus ecsallii
29940914 29940914 PRJNA1063685_S_NODE_52691_length_307_cov_4.363248_g52148_i0 PRJNA1063685 52691 307 4.363248 13.39517136 Erysiphe necator associated virga-like virus 9 2743136 Viruses Viruses 114 4.33e-27   NR QKN22706.1 2743136 g52148 i0 55.7 3.79153094462541 97 41 92.8 1 292 8 1014 1110 QKN22706.1 RNA-dependent RNA polymerase [Erysiphe necator associated virga-like virus 9] diamond 1164 114 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae   Erysiphe necator associated virga-like virus 9

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;