RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJNA884104" and tax_phylum = "Kitrinoviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kitrinoviricota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA884104 · 20 ✖

analysis 1

  • blastn · 20 ✖

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
860767 860767 PRJNA884104_S_NODE_40561_length_325_cov_1.436508_g39818_i0 PRJNA884104 40561 325 1.436508 4.668651 Trichovirus mali 12175 Viruses Viruses 505 1.95e-138   NTclustered gi|373940186|gb|JN634760.1| 12175 g39818 i0 94.753 17.4 324 17 99 0 1 324 3923 4246 Apple chlorotic leaf spot virus isolate Z1, complete genome blastn 5655 505 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus mali
2135649 2135649 PRJNA884104_S_NODE_1582_length_1558_cov_2.152862_g1345_i0 PRJNA884104 1582 1558 2.152862 33.54158996 Trichovirus mali 12175 Viruses Viruses 2617 0   NTclustered gi|2426332688|gb|ON024143.1| 12175 g1345 i0 96.983 94.1688061617458 1558 47 100 0 1 1558 5985 7542 Apple chlorotic leaf spot virus isolate NODE-11 coat protein (CP) gene, complete cds blastn 146715 2617 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus mali
2136070 2136070 PRJNA884104_S_NODE_35802_length_344_cov_0.948339_g35059_i0 PRJNA884104 35802 344 0.948339 3.26228616 Peach virus T 1958978 Viruses Viruses 407 6.03e-109   NTclustered gi|1180718232|gb|KY348615.1| 1958978 g35059 i0 88.047 1.99418604651163 343 41 99 0 1 343 5184 5526 Peach virus T isolate JH polyprotein and putative movement protein genes, complete cds blastn 686 407 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales     Peach virus T
2137123 2137123 PRJNA884104_S_NODE_8762_length_684_cov_1.913257_g8065_i0 PRJNA884104 8762 684 1.913257 13.08667788 Prunus persica marafivirus 3120871 Viruses Viruses 318 6.09e-82   NTclustered gi|2675378649|gb|PP317290.1| 3120871 g8065 i0 80.615 0.618421052631579 423 72 61 7 262 679 3546 3963 MAG: Prunus persica marafivirus isolate NBPGR-Shimla-1 genomic sequence blastn 423 318 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Tymoviridae Marafivirus Prunus persica marafivirus
4689558 4689558 PRJNA884104_S_NODE_61004_length_267_cov_1.592784_g60261_i0 PRJNA884104 61004 267 1.592784 4.25273328 Trichovirus mali 12175 Viruses Viruses 455 1.5900000000000002e-123   NTclustered gi|2426332694|gb|ON024146.1| 12175 g60261 i0 97.378 22.625468164794 267 7 100 0 1 267 4412 4678 Apple chlorotic leaf spot virus isolate NODE-14 coat protein (CP) gene, complete cds blastn 6041 455 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus mali
6345155 6345155 PRJNA884104_S_NODE_10945_length_610_cov_1.977654_g10225_i0 PRJNA884104 10945 610 1.977654 12.0636894 Marafivirus 12051 Viruses Viruses 730 0   NTclustered gi|2701263236|gb|PP475428.1| 1955730 g10225 i0 88.322 4.99016393442623 608 71 99 0 3 610 4242 3635 Peach virus D isolate IARI replicase polyprotein gene, partial cds blastn 3044 734 0.994550408719346 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Tymoviridae Marafivirus Marafivirus pruni
7239152 7239152 PRJNA884104_S_NODE_52926_length_288_cov_0.809302_g52183_i0 PRJNA884104 52926 288 0.809302 2.33078976 Peach virus T 1958978 Viruses Viruses 202 2.5e-47   NTclustered gi|1180718229|gb|KY348614.1| 1958978 g52183 i0 79.655 2.85416666666667 290 51 99 7 1 286 2238 2523 Peach virus T isolate BC polyprotein and putative movement protein genes, complete cds blastn 822 202 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales     Peach virus T
8513701 8513701 PRJNA884104_S_NODE_44207_length_313_cov_1.254167_g43464_i0 PRJNA884104 44207 313 1.254167 3.92554271 Trichovirus mali 12175 Viruses Viruses 556 5.09e-154   NTclustered gi|373940186|gb|JN634760.1| 12175 g43464 i0 98.722 21.9456869009585 313 4 100 0 1 313 5950 6262 Apple chlorotic leaf spot virus isolate Z1, complete genome blastn 6869 556 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus mali
9788477 9788477 PRJNA884104_S_NODE_3008_length_1156_cov_1.450600_g2614_i0 PRJNA884104 3008 1156 1.4506 16.768936 Trichovirus mali 12175 Viruses Viruses 1919 0   NTclustered gi|1214575054|gb|KY310577.1| 12175 g2614 i0 96.783 99.5043252595156 1150 37 99 0 1 1150 5963 4814 Trichovirus mali isolate JH, complete genome blastn 115027 1919 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus mali
9788599 9788599 PRJNA884104_S_NODE_36368_length_341_cov_1.798507_g35625_i0 PRJNA884104 36368 341 1.798507 6.13290887 Trichovirus mali 12175 Viruses Viruses 527 4.3899999999999996e-145   NTclustered gi|374279248|gb|JN848982.1| 12175 g35625 i0 94.94 30.9648093841642 336 17 99 0 1 336 336 1 Apple chlorotic leaf spot virus isolate HB3 coat protein gene, complete cds blastn 10559 527 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus mali
11064328 11064328 PRJNA884104_S_NODE_42689_length_318_cov_1.000000_g41946_i0 PRJNA884104 42689 318 1 3.18 Trichovirus mali 12175 Viruses Viruses 510 4.09e-140   NTclustered gi|373940186|gb|JN634760.1| 12175 g41946 i0 95.597 17.0283018867925 318 14 100 0 1 318 4879 4562 Apple chlorotic leaf spot virus isolate Z1, complete genome blastn 5415 510 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus mali
11064579 11064579 PRJNA884104_S_NODE_55369_length_281_cov_1.471154_g54626_i0 PRJNA884104 55369 281 1.471154 4.13394274 Peach virus T 1958978 Viruses Viruses 348 2.95e-91   NTclustered gi|1180718232|gb|KY348615.1| 1958978 g54626 i0 89.007 2.93950177935943 282 29 100 2 1 281 1094 814 Peach virus T isolate JH polyprotein and putative movement protein genes, complete cds blastn 826 348 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales     Peach virus T
11064877 11064877 PRJNA884104_S_NODE_69689_length_251_cov_0.865169_g68946_i0 PRJNA884104 69689 251 0.865169 2.17157419 Marafivirus pruni 3052333 Viruses Viruses 318 2.03e-82   NTclustered gi|1150147038|ref|NC_033828.1| 1955730 g68946 i0 89.641 3 251 25 100 1 1 251 1354 1105 Peach virus D isolate SK, complete genome blastn 753 318 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Tymoviridae Marafivirus Marafivirus pruni
17439463 17439463 PRJNA884104_S_NODE_67934_length_252_cov_0.977654_g67191_i0 PRJNA884104 67934 252 0.977654 2.46368808 Trichovirus mali 12175 Viruses Viruses 394 3.3e-105   NTclustered gi|1214575054|gb|KY310577.1| 12175 g67191 i0 95.181 14.5119047619048 249 12 99 0 1 249 3689 3937 Trichovirus mali isolate JH, complete genome blastn 3657 394 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus mali
18712413 18712413 PRJNA884104_S_NODE_53935_length_285_cov_1.117925_g53192_i0 PRJNA884104 53935 285 1.117925 3.18608625 Trichovirus mali 12175 Viruses Viruses 453 6.18e-123   NTclustered gi|2426332694|gb|ON024146.1| 12175 g53192 i0 95.423 11.9719298245614 284 13 99 0 2 285 3252 3535 Apple chlorotic leaf spot virus isolate NODE-14 coat protein (CP) gene, complete cds blastn 3412 453 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus mali
18712492 18712492 PRJNA884104_S_NODE_58415_length_274_cov_1.019900_g57672_i0 PRJNA884104 58415 274 1.0199 2.794526 Trichovirus chloropersicae 3432984 Viruses Viruses 315 2.91e-81   NTclustered gi|2504505089|gb|OP923917.1| 2358294 g57672 i0 88.06 10.9890510948905 268 29 98 1 7 274 7131 7395 Peach chlorotic leaf spot virus isolate Apricot XJ, complete genome blastn 3011 315 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus chloropersicae
18712985 18712985 PRJNA884104_S_NODE_83875_length_242_cov_1.147929_g83132_i0 PRJNA884104 83875 242 1.147929 2.77798818 Trichovirus chloropersicae 3432984 Viruses Viruses 233 7.25e-57   NTclustered gi|2504505089|gb|OP923917.1| 2358294 g83132 i0 84.232 14.595041322314 241 36 99 2 3 242 6569 6808 Peach chlorotic leaf spot virus isolate Apricot XJ, complete genome blastn 3532 233 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus chloropersicae
19987439 19987439 PRJNA884104_S_NODE_4156_length_989_cov_3.286026_g3662_i0 PRJNA884104 4156 989 3.286026 32.49879714 Peach virus T 1958978 Viruses Viruses 1393 0   NTclustered gi|1180718232|gb|KY348615.1| 1958978 g3662 i0 92.261 5.9726996966633 982 76 99 0 7 988 6420 5439 Peach virus T isolate JH polyprotein and putative movement protein genes, complete cds blastn 5907 1393 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales     Peach virus T
22537446 22537446 PRJNA884104_S_NODE_37778_length_335_cov_5.583969_g37035_i0 PRJNA884104 37778 335 5.583969 18.70629615 Sugarcane mild mosaic virus 126071 Viruses Viruses 52.8 0.032   NTclustered gi|2370428304|gb|OM296203.1| 126071 g37035 i0 100 0.0835820895522388 28 0 8 0 1 28 6 33 Sugarcane mild mosaic virus isolate 16N-5 viral replicase, polyprotein, p6 protein, heat shock protein 70-like protein, heat shock protein 90, and major capsid protein genes, complete cds; and p24 protein gene, partial cds blastn 28 52.8 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae Ampelovirus Sugarcane mild mosaic virus
22537511 22537511 PRJNA884104_S_NODE_40858_length_324_cov_1.314741_g40115_i0 PRJNA884104 40858 324 1.314741 4.25976084 Trichovirus mali 12175 Viruses Viruses 544 4.12e-150   NTclustered gi|667714325|gb|KJ754185.1| 12175 g40115 i0 96.914 29.2469135802469 324 10 100 0 1 324 7 330 Apple chlorotic leaf spot virus isolate SDA3 coat protein gene, complete cds blastn 9476 544 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus mali

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