RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA715462" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 14 ✖

bioproject 1

  • PRJNA715462 · 14 ✖

analysis 1

  • blastn · 14 ✖

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
1981841 1981841 PRJNA715462_P_NODE_3522_length_1379_cov_6.535988_g3058_i0 PRJNA715462 3522 1379 6.535988 90.13127452 Nepovirus avii 3047741 Viruses Viruses 1029 0   NTclustered gi|1229202697|emb|LT883166.1| 12615 g3058 i0 87.889 59.9260333575054 900 78 92 10 486 1379 5314 6188 Cherry leaf roll virus Polyprotein 2 gene for polyprotein, 2A, 2B, movement protein, coat protein region, segment RNA2, isolate E327 blastn 82638 1029 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus avii
1982601 1982601 PRJNA715462_P_NODE_9802_length_682_cov_12.371100_g3058_i3 PRJNA715462 9802 682 12.3711 84.370902 Nepovirus avii 3047741 Viruses Viruses 998 0   NTclustered gi|2108668857|gb|MZ291951.1| 12615 g3058 i3 93.235 83.0366568914956 680 43 99 3 2 678 6350 5671 Cherry leaf roll virus isolate 19SP057 segment RNA2, complete sequence blastn 56631 998 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus avii
3257780 3257780 PRJNA715462_P_NODE_6823_length_887_cov_3.998771_g3058_i1 PRJNA715462 6823 887 3.998771 35.46909877 Nepovirus avii 3047741 Viruses Viruses 652 0   NTclustered gi|2073341497|gb|MW854282.1| 12615 g3058 i1 92.06 29.2356257046223 466 34 98 2 407 870 6753 6289 Cherry leaf roll virus isolate DSMZ PV-0797 segment RNA 1, partial sequence blastn 25932 652 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus avii
4534327 4534327 PRJNA715462_P_NODE_41024_length_278_cov_1.248780_g40228_i0 PRJNA715462 41024 278 1.24878 3.4716084 Nepovirus avii 3047741 Viruses Viruses 318 2.2899999999999995e-82   NTclustered gi|378406127|gb|JN104385.1| 12615 g40228 i0 87.41 9.49640287769784 278 33 99 2 2 278 4378 4654 Cherry leaf roll virus isolate Olm1 segment RNA2, complete sequence blastn 2640 318 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus avii
4534388 4534388 PRJNA715462_P_NODE_43844_length_269_cov_1.964286_g43048_i0 PRJNA715462 43844 269 1.964286 5.28392934 Nepovirus avii 3047741 Viruses Viruses 335 2.18e-87   NTclustered gi|1723623683|gb|MK402281.1| 12615 g43048 i0 89.179 26.3011152416357 268 29 99 0 1 268 4829 4562 Cherry leaf roll virus isolate CLRV_BpenGer407526 segment RNA1 putative polyprotein gene, partial cds blastn 7075 335 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus avii
5810025 5810025 PRJNA715462_P_NODE_63585_length_244_cov_0.900585_g62789_i0 PRJNA715462 63585 244 0.900585 2.1974274 Maculavirus vitis 3047853 Viruses Viruses 424 4.05e-114   NTclustered gi|2269685740|gb|ON567253.1| 103722 g62789 i0 97.951 30.6475409836066 244 5 100 0 1 244 5538 5781 Grapevine fleck virus isolate A1567c replicase (REP) and coat protein (CP) genes, complete cds; and hypothetical protein (ORF3) and hypothetical protein (ORF4) genes, partial cds blastn 7478 424 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Tymoviridae Maculavirus Maculavirus vitis
8359437 8359437 PRJNA715462_P_NODE_49547_length_253_cov_1.688889_g48751_i0 PRJNA715462 49547 253 1.688889 4.27288917 Foveavirus rupestris 3428812 Viruses Viruses 462 8.95e-126   NTclustered gi|2289713684|gb|MZ484931.1| 196400 g48751 i0 99.605 100.138339920949 253 1 100 0 1 253 8331 8583 Grapevine rupestris stem pitting-associated virus isolate 16GVP043B, complete genome blastn 25335 462 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Foveavirus Foveavirus rupestris
13459727 13459727 PRJNA715462_P_NODE_43451_length_271_cov_0.904040_g42655_i0 PRJNA715462 43451 271 0.90404 2.4499484 Maculavirus vitis 3047853 Viruses Viruses 468 2.08e-127   NTclustered gi|2269685798|gb|ON584185.1| 103722 g42655 i0 97.786 83.8671586715867 271 6 100 0 1 271 5600 5330 Grapevine fleck virus isolate A1587c, partial genome blastn 22728 468 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Tymoviridae Maculavirus Maculavirus vitis
13460273 13460273 PRJNA715462_P_NODE_8511_length_758_cov_7.430657_g3058_i2 PRJNA715462 8511 758 7.430657 56.32438006 Nepovirus avii 3047741 Viruses Viruses 1114 0   NTclustered gi|2520246190|gb|OQ731914.1| 12615 g3058 i2 93.272 80.9406332453826 758 47 99 4 3 758 6833 7588 Cherry leaf roll virus isolate DSMZ PV-1382 segment RNA1, complete sequence blastn 61353 1114 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus avii
14734131 14734131 PRJNA715462_P_NODE_10412_length_655_cov_12.403780_g3058_i4 PRJNA715462 10412 655 12.40378 81.244759 Nepovirus avii 3047741 Viruses Viruses 957 0   NTclustered gi|2520246190|gb|OQ731914.1| 12615 g3058 i4 93.364 81.7465648854962 648 42 99 1 5 651 7858 7211 Cherry leaf roll virus isolate DSMZ PV-1382 segment RNA1, complete sequence blastn 53544 957 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus avii
17770019 17770019 PRJNA715462_P_NODE_62814_length_244_cov_1.350877_g62018_i0 PRJNA715462 62814 244 1.350877 3.29613988 Viruses 10239 Viruses Viruses 440 4.019999999999999e-119   NTclustered gi|2177952863|gb|OL452263.1| 2900479 g62018 i0 99.18 3.99590163934426 244 2 100 0 1 244 6480 6237 MAG: Brine shrimp chuvirus 1 isolate CHN/15, complete genome blastn 975 440 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae   brine shrimp chuvirus 1
18557424 18557424 PRJNA715462_P_NODE_24455_length_366_cov_1.051195_g23659_i0 PRJNA715462 24455 366 1.051195 3.8473737 Nepovirus avii 3047741 Viruses Viruses 429 1.37e-115   NTclustered gi|2419396262|gb|ON924206.1| 12615 g23659 i0 88.825 14.4535519125683 349 39 95 0 18 366 5734 5386 Cherry leaf roll virus isolate DSMZ PV-0200 segment RNA 1, complete sequence blastn 5290 429 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus avii
18557504 18557504 PRJNA715462_P_NODE_27515_length_342_cov_1.427509_g26719_i0 PRJNA715462 27515 342 1.427509 4.88208078 Foveavirus rupestris 3428812 Viruses Viruses 632 9.079999999999999e-177   NTclustered gi|2289713751|gb|MZ484941.1| 196400 g26719 i0 100 99.827485380117 342 0 100 0 1 342 8546 8205 Grapevine rupestris stem pitting-associated virus isolate 16GVP057B, complete genome blastn 34141 632 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Foveavirus Foveavirus rupestris
22382722 22382722 PRJNA715462_P_NODE_1038_length_2589_cov_13.558824_g845_i0 PRJNA715462 1038 2589 13.558824 351.03795336 brine shrimp chuvirus 1 2900479 Viruses Viruses 95.3 4.4e-14   NTclustered gi|2177952885|gb|OL452274.1| 2900479 g845 i0 90.278 0.166473541908073 72 7 3 0 2517 2588 7030 7101 MAG: Brine shrimp chuvirus 1 isolate YC/91, complete genome blastn 431 95.3 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae   brine shrimp chuvirus 1

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