RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where bioproject = "PRJNA1160211" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 24 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1160211 · 24 ✖

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
310873 310873 PRJNA1160211_S_NODE_88061_length_481_cov_5.154412_g86839_i0 PRJNA1160211 88061 481 5.154412 24.79272172 Capsicum annuum fabavirus 2738914 Viruses Viruses 767 0   NTclustered gi|1845309146|gb|MN814312.1| 2738914 g86839 i0 96.943 88.8544698544699 458 13 95 1 16 472 598 141 Capsicum annuum fabavirus strain pt066-sec-4 segment RNA2, complete sequence blastn 42739 767 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Capsicum annuum fabavirus
1585389 1585389 PRJNA1160211_S_NODE_76862_length_505_cov_11.719907_g75647_i0 PRJNA1160211 76862 505 11.719907 59.18553035 Shenzhen dicistro-like virus 2789378 Viruses Viruses 889 0   NTclustered gi|1940198121|gb|MT757492.1| 2789378 g75647 i0 98.416 4.0019801980198 505 8 100 0 1 505 4753 4249 Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds blastn 2021 889 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Shenzhen dicistro-like virus
2860243 2860243 PRJNA1160211_S_NODE_156543_length_365_cov_9.828767_g155310_i0 PRJNA1160211 156543 365 9.828767 35.87499955 Betacoronavirus pandemicum 3418604 Viruses Viruses 73.1 2.66e-8   NTclustered gi|2165834194|emb|OV195900.1| 2697049 g155310 i0 95.556 11.7780821917808 45 2 12 0 11 55 30036 29992 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 4299 73.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
2861671 2861671 PRJNA1160211_S_NODE_85483_length_486_cov_20.026634_g84263_i0 PRJNA1160211 85483 486 20.026634 97.32944124 Shenzhen dicistro-like virus 2789378 Viruses Viruses 95.9 1.62e-19   NR QPG92982.1 2789378 g84263 i0 41.8 1.55555555555556 134 70 77.8 3 48 425 747 880 QPG92982.1 polyprotein [Shenzhen dicistro-like virus] diamond 756 95.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Shenzhen dicistro-like virus
4137552 4137552 PRJNA1160211_S_NODE_67604_length_527_cov_45.259912_g66402_i0 PRJNA1160211 67604 527 45.259912 238.51973624 Shenzhen dicistro-like virus 2789378 Viruses Viruses 737 0   NTclustered gi|1935607040|gb|MT747995.1| 2789378 g66402 i0 94.033 2.76660341555977 486 29 92 0 18 503 3260 2775 Shenzhen dicistro-like virus strain USAdp-3 polyprotein gene, complete cds blastn 1458 737 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Shenzhen dicistro-like virus
6687216 6687216 PRJNA1160211_S_NODE_147386_length_378_cov_7.068852_g146153_i0 PRJNA1160211 147386 378 7.068852 26.72026056 Betacoronavirus gravedinis 3433757 Viruses Viruses 54.7 0.01   NTclustered gi|2445173937|gb|ON554068.1| 31631 g146153 i0 100 0.0767195767195767 29 0 8 0 310 338 12719 12747 Human coronavirus OC43 isolate HCoV-OC43/BIME321-03/2018, complete genome blastn 29 54.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus gravedinis
6687753 6687753 PRJNA1160211_S_NODE_21706_length_698_cov_7.096000_g20684_i0 PRJNA1160211 21706 698 7.096 49.53008 Trichoderma gamsii alphapartitivirus 1 3032463 Viruses Viruses 347 1e-113   NR WGH72964.1 3032463 g20684 i0 84.5 0.829512893982808 193 30 83 0 581 3 1 193 WGH72964.1 MAG: putative RNA-dependent RNA polymerase [Trichoderma gamsii alphapartitivirus 1] diamond 579 347 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Alphapartitivirus Trichoderma gamsii alphapartitivirus 1
7962355 7962355 PRJNA1160211_S_NODE_128367_length_407_cov_11.802395_g127135_i0 PRJNA1160211 128367 407 11.802395 48.03574765 Qianjiang picorna-like virus 82 3348812 Viruses Viruses 516 1.15e-141   NTclustered gi|2806504153|gb|PQ055410.1| 3348812 g127135 i0 90.722 1.90663390663391 388 35 95 1 21 407 127 514 MAG: Qianjiang picorna-like virus 82 isolate QJ3DG646 genomic sequence blastn 776 516 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 82
10513779 10513779 PRJNA1160211_S_NODE_254629_length_258_cov_1.664865_g253396_i0 PRJNA1160211 254629 258 1.664865 4.2953517 Periplaneta americana dicistro-like virus 3032225 Viruses Viruses 104 6.39e-18   NTclustered gi|2754804027|tpg|BK063169.1| 3032225 g253396 i0 100 0.217054263565891 56 0 22 0 11 66 4570 4625 TPA_asm: Periplaneta americana dicistro-like virus hypothetical protein gene, partial cds blastn 56 104 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Periplaneta americana dicistro-like virus
11789202 11789202 PRJNA1160211_S_NODE_51830_length_570_cov_19.048290_g50663_i0 PRJNA1160211 51830 570 19.04829 108.575253 Polerovirus TUYV 3431793 Viruses Viruses 126 3.27e-24   NTclustered gi|2461860523|dbj|LC726803.1| 1046403 g50663 i0 98.592 12.0614035087719 71 1 12 0 498 568 1075 1145 Brassica yellows virus DN134266_c8_g2_i1 gene for CP readthrough protein blastn 6875 126 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae Polerovirus Polerovirus TUYV
13064098 13064098 PRJNA1160211_S_NODE_46091_length_589_cov_3.354651_g44935_i0 PRJNA1160211 46091 589 3.354651 19.75889439 Skokie dicistro-like virus 2789443 Viruses Viruses 994 0   NTclustered gi|2806502719|gb|PQ054859.1| 2789443 g44935 i0 97.114 2 589 17 100 0 1 589 5311 4723 MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence blastn 1178 994 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Skokie dicistro-like virus
16340734 16340734 PRJNA1160211_S_NODE_14193_length_759_cov_17.241983_g13306_i0 PRJNA1160211 14193 759 17.241983 130.86665097 Viruses 10239 Viruses Viruses 130 3.42e-25   NTclustered gi|2461860523|dbj|LC726803.1| 1046403 g13306 i0 98.63 9.1870882740448 73 1 10 0 60 132 1145 1073 Brassica yellows virus DN134266_c8_g2_i1 gene for CP readthrough protein blastn 6973 130 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae Polerovirus Polerovirus TUYV
18161156 18161156 PRJNA1160211_S_NODE_178775_length_336_cov_2.049430_g177542_i0 PRJNA1160211 178775 336 2.04943 6.8860848 Periplaneta americana dicistro-like virus 2 3032226 Viruses Viruses 577 4.229999999999999e-160   NTclustered gi|2754804057|tpg|BK063183.1| 3032226 g177542 i0 97.619 3 336 8 100 0 1 336 2377 2712 TPA_asm: Periplaneta americana dicistro-like virus 2 hypothetical protein genes, partial cds blastn 1008 577 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Periplaneta americana dicistro-like virus 2
20165179 20165179 PRJNA1160211_S_NODE_36456_length_623_cov_21.065455_g35329_i0 PRJNA1160211 36456 623 21.065455 131.23778465 Viruses 10239 Viruses Viruses 121 1.6700000000000001e-22   NTclustered gi|2461860523|dbj|LC726803.1| 1046403 g35329 i0 97.183 11.1765650080257 71 2 11 0 513 583 1073 1143 Brassica yellows virus DN134266_c8_g2_i1 gene for CP readthrough protein blastn 6963 122 0.991803278688525 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae Polerovirus Polerovirus TUYV
20710619 20710619 PRJNA1160211_S_NODE_14097_length_760_cov_13.129549_g13212_i0 PRJNA1160211 14097 760 13.129549 99.7845724 Shenzhen dicistro-like virus 2789378 Viruses Viruses 1125 0   NTclustered gi|1940198121|gb|MT757492.1| 2789378 g13212 i0 93.85 2.96052631578947 748 44 98 2 14 760 4081 3335 Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds blastn 2250 1125 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Shenzhen dicistro-like virus
20711146 20711146 PRJNA1160211_S_NODE_204497_length_306_cov_0.892704_g203264_i0 PRJNA1160211 204497 306 0.892704 2.73167424 Periplaneta americana dicistro-like virus 2 3032226 Viruses Viruses 494 3.95e-135   NTclustered gi|2754804057|tpg|BK063183.1| 3032226 g203264 i0 96.04 2.9640522875817 303 12 99 0 1 303 2113 2415 TPA_asm: Periplaneta americana dicistro-like virus 2 hypothetical protein genes, partial cds blastn 907 494 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Periplaneta americana dicistro-like virus 2
20711880 20711880 PRJNA1160211_S_NODE_43817_length_596_cov_5.216061_g42663_i0 PRJNA1160211 43817 596 5.216061 31.08772356 Potyvirus telosmae 3240618 Viruses Viruses 1096 0   NTclustered gi|1802924506|gb|MK340754.1| 400394 g42663 i0 99.832 88.239932885906 596 1 100 0 1 596 10039 9444 Telosma mosaic virus isolate Fuzhou, complete genome blastn 52591 1096 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus telosmae
22716022 22716022 PRJNA1160211_S_NODE_92138_length_473_cov_2.712500_g90915_i0 PRJNA1160211 92138 473 2.7125 12.830125 root 1 Root_unresolved Root_unresolved 121 1.24e-22   NTclustered gi|2461860523|dbj|LC726803.1| 1046403 g90915 i0 94.872 14.9873150105708 78 3 16 1 392 468 1073 1150 Brassica yellows virus DN134266_c8_g2_i1 gene for CP readthrough protein blastn 7089 121 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae Polerovirus Polerovirus TUYV
24535011 24535011 PRJNA1160211_S_NODE_111060_length_437_cov_1.530220_g109831_i0 PRJNA1160211 111060 437 1.53022 6.6870614 Betacoronavirus pandemicum 3418604 Viruses Viruses 117 1.48e-21   NTclustered gi|2165836832|emb|OV197136.1| 2697049 g109831 i0 93.671 14.4759725400458 79 3 18 2 8 86 29988 29912 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 6326 117 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
24535119 24535119 PRJNA1160211_S_NODE_122720_length_416_cov_17.399417_g121491_i0 PRJNA1160211 122720 416 17.399417 72.38157472 Shenzhen dicistro-like virus 2789378 Viruses Viruses 634 3.1199999999999998e-177   NTclustered gi|1940198121|gb|MT757492.1| 2789378 g121491 i0 95.685 1.88221153846154 394 17 95 0 23 416 7767 8160 Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds blastn 783 634 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Shenzhen dicistro-like virus
25265378 25265378 PRJNA1160211_S_NODE_85920_length_485_cov_25.526699_g84700_i0 PRJNA1160211 85920 485 25.526699 123.80449015 Viruses 10239 Viruses Viruses 130 2.12e-25   NTclustered gi|2461860523|dbj|LC726803.1| 1046403 g84700 i0 98.63 14.3773195876289 73 1 15 0 60 132 1145 1073 Brassica yellows virus DN134266_c8_g2_i1 gene for CP readthrough protein blastn 6973 130 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae Polerovirus Polerovirus TUYV
29377280 29377280 PRJNA1160211_S_NODE_80869_length_496_cov_12.548463_g79652_i0 PRJNA1160211 80869 496 12.548463 62.24037648 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 80.1 5.43e-14   NR XCM68108.1 3003959 g79652 i0 38 0.653225806451613 108 65 65.3 2 492 169 882 987 XCM68108.1 MAG: structural polyprotein [Picornavirales sp.] diamond 324 80.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29440065 29440065 PRJNA1160211_S_NODE_128830_length_407_cov_1.832335_g127598_i0 PRJNA1160211 128830 407 1.832335 7.45760345 Drosophila biauraria male killing partitivirus 1 2933356 Viruses Viruses 88.2 1.26e-17   NR BDH75795.1 2933356 g127598 i0 39.7 0.855036855036855 116 70 85.5 0 6 353 175 290 BDH75795.1 uncharacterized protein [Drosophila biauraria male killing partitivirus 1] diamond 348 88.2 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Drosophila biauraria male killing partitivirus 1
31494256 31494256 PRJNA1160211_S_NODE_204656_length_305_cov_7.663793_g203423_i0 PRJNA1160211 204656 305 7.663793 23.37456865 Cherry virus Trakiya 2074132 Viruses Viruses 131 4.88e-33   NR YP_009551963.1 2074132 g203423 i0 76 0.737704918032787 75 18 73.8 0 281 57 1769 1843 YP_009551963.1 replicase [Cherry virus Trakiya] diamond 225 131 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Cherry virus Trakiya

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