RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA640143" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 10 ✖

bioproject 1

  • PRJNA640143 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
5713686 5713686 PRJNA640143_S_NODE_31185_length_154_cov_2.435897_g30975_i0 PRJNA640143 31185 154 2.435897 3.75128138 Sopafab virus 3131770 Viruses Viruses 126 7.34e-25   NTclustered gi|2717323354|gb|PP174071.1| 3131770 g30975 i0 84.058 71.8636363636364 138 15 85 5 24 154 3330 3193 MAG: Sopafab virus isolate SP1C_k141_220867 genomic sequence blastn 11067 126 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes       Sopafab virus
6988770 6988770 PRJNA640143_S_NODE_8926_length_285_cov_203.375000_g8716_i0 PRJNA640143 8926 285 203.375 579.61875 Erysiphe necator associated ourmia-like virus 85 2741865 Viruses Viruses 407 4.88e-109   NTclustered gi|1848976703|gb|MN611613.1| 2741865 g8716 i0 96.356 1.73333333333333 247 9 87 0 2 248 1886 1640 Erysiphe necator associated ourmia-like virus 85 isolate PMS4_45, complete genome blastn 494 407 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Ourmiavirus Erysiphe necator associated ourmia-like virus 85
8263266 8263266 PRJNA640143_S_NODE_2727_length_476_cov_6.742597_g2541_i0 PRJNA640143 2727 476 6.742597 32.09476172 Potexvirus pepini 3433856 Viruses Viruses 813 0   NTclustered gi|1345606506|gb|MF422613.1| 112229 g2541 i0 99.774 90.8697478991597 443 1 93 0 34 476 5966 6408 Pepino mosaic virus isolate CH_bpo162, complete genome blastn 43254 813 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus pepini
13363804 13363804 PRJNA640143_S_NODE_11_length_2482_cov_7.131288_g10_i0 PRJNA640143 11 2482 7.131288 176.99856816 Geotrichum candidum totivirus 3a 2971328 Viruses Viruses 2601 0   NTclustered gi|2284067729|gb|ON862169.1| 2971328 g10 i0 85.582 2.00080580177276 2483 356 100 2 1 2482 2520 39 Geotrichum candidum totivirus 3a isolate GcTV3a-HK1, complete genome blastn 4966 2601 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Geotrichum candidum totivirus 3a
14639060 14639060 PRJNA640143_S_NODE_5012_length_367_cov_27.109091_g4802_i0 PRJNA640143 5012 367 27.109091 99.49036397 Potexvirus pepini 3433856 Viruses Viruses 586 7.729999999999998e-163   NTclustered gi|217031250|gb|FJ457097.1| 112229 g4802 i0 99.688 54.1607629427793 320 1 87 0 13 332 2021 1702 Pepino mosaic virus isolate PCH 06/104 replicase, triple gene block protein 1 (TGBp1), triple gene block protein 2 (TGBp2), triple gene block protein 3 (TGBp3), and coat protein genes, complete cds blastn 19877 586 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus pepini
14639160 14639160 PRJNA640143_S_NODE_8932_length_285_cov_14.370968_g8722_i0 PRJNA640143 8932 285 14.370968 40.9572588 Penoulivirus alphaerysiphe 3060537 Viruses Viruses 455 1.72e-123   NTclustered gi|2500387314|ref|NC_077170.1| 2741801 g8722 i0 99.598 2.1719298245614 249 1 87 0 4 252 249 1 Erysiphe necator associated ourmia-like virus 21 isolate RDPM33, complete genome blastn 619 455 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Penoulivirus Penoulivirus alphaerysiphe
15912534 15912534 PRJNA640143_S_NODE_12173_length_248_cov_13.279621_g11963_i0 PRJNA640143 12173 248 13.279621 32.93346008 Chrocagost virus 3129398 Viruses Viruses 281 2.63e-71   NTclustered gi|2717317482|gb|PP171846.1| 3129398 g11963 i0 91.667 670.298387096774 204 16 82 1 1 203 5658 5861 MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence blastn 166234 281 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes       Chrocagost virus
17187878 17187878 PRJNA640143_S_NODE_24254_length_179_cov_2.161972_g24044_i0 PRJNA640143 24254 179 2.161972 3.86992988 Penoulivirus alphaerysiphe 3060537 Viruses Viruses 281 1.78e-71   NTclustered gi|1848976575|gb|MN611549.1| 2741801 g24044 i0 94.972 2 179 9 100 0 1 179 2199 2377 Erysiphe necator associated ourmia-like virus 21 isolate PMS10_36, complete genome blastn 358 281 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Penoulivirus Penoulivirus alphaerysiphe
22286715 22286715 PRJNA640143_S_NODE_11258_length_257_cov_10.009091_g11048_i0 PRJNA640143 11258 257 10.009091 25.72336387 Erysiphe necator associated ourmia-like virus 85 2741865 Viruses Viruses 364 2.6399999999999993e-96   NTclustered gi|1848976703|gb|MN611613.1| 2741865 g11048 i0 95.982 2.54474708171206 224 9 87 0 34 257 579 802 Erysiphe necator associated ourmia-like virus 85 isolate PMS4_45, complete genome blastn 654 364 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Ourmiavirus Erysiphe necator associated ourmia-like virus 85
24836311 24836311 PRJNA640143_S_NODE_26740_length_170_cov_1.759398_g26530_i0 PRJNA640143 26740 170 1.759398 2.9909766 Erysiphe necator associated ourmia-like virus 69 2741849 Viruses Viruses 243 7.859999999999999e-60   NTclustered gi|2198202689|dbj|LC671618.1| 2741849 g26530 i0 92.814 3.94705882352941 167 12 98 0 1 167 1831 1997 Erysiphe necator associated ourmia-like virus 69 2020-AMS-01 RNA, complete genome blastn 671 243 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Ourmiavirus Erysiphe necator associated ourmia-like virus 69

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