RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where bioproject = "PRJNA432257", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 32 ✖

tax_phylum 1

  • Pisuviricota · 32 ✖

tax_kingdom 1

bioproject 1

  • PRJNA432257 · 32 ✖

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
1704643 1704643 PRJNA432257_S_NODE_49562_length_232_cov_1.800000_g49181_i0 PRJNA432257 49562 232 1.8 4.176 Ipomovirus cucumisvenaflavi 3429979 Viruses Viruses 418 1.7799999999999995e-112   NTclustered gi|2106686302|gb|MZ130935.1| 137475 g49181 i0 99.138 20 232 2 100 0 1 232 6555 6324 Cucumber vein yellowing virus isolate DSMZ PV-0776, complete genome blastn 4640 418 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Ipomovirus Ipomovirus cucumisvenaflavi
2980778 2980778 PRJNA432257_S_NODE_743_length_1248_cov_273.526012_g697_i0 PRJNA432257 743 1248 273.526012 3413.60462976 Nepovirus avii 3047741 Viruses Viruses 2082 0   NTclustered gi|2106121539|gb|MW848519.1| 12615 g697 i0 98 75.8108974358974 1200 23 96 1 9 1207 6358 5159 Cherry leaf roll virus isolate NGSTPS18 segment RNA 2, complete sequence blastn 94612 2082 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus avii
4255896 4255896 PRJNA432257_S_NODE_10244_length_405_cov_3.323370_g9885_i0 PRJNA432257 10244 405 3.32337 13.4596485 Periplaneta americana dicistro-like virus 3032225 Viruses Viruses 444 5.49e-120   NTclustered gi|2754804027|tpg|BK063169.1| 3032225 g9885 i0 91.875 0.790123456790123 320 23 79 2 27 346 4350 4666 TPA_asm: Periplaneta americana dicistro-like virus hypothetical protein gene, partial cds blastn 320 444 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Periplaneta americana dicistro-like virus
5533416 5533416 PRJNA432257_S_NODE_45645_length_239_cov_2.569307_g45264_i0 PRJNA432257 45645 239 2.569307 6.14064373 Cripavirus sp. 1955141 Viruses Viruses 425 1.1e-114   NTclustered gi|2754691479|gb|PP872551.1| 1955141 g45264 i0 98.745 83.6903765690377 239 3 100 0 1 239 7223 6985 MAG: Cripavirus sp. isolate TC-CrV-1 MR233-17E/2200 genomic sequence blastn 20002 425 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus sp.
5533955 5533955 PRJNA432257_S_NODE_85825_length_187_cov_203.626667_g85444_i0 PRJNA432257 85825 187 203.626667 380.78186729 Nepovirus avii 3047741 Viruses Viruses 265 1.89e-66   NTclustered gi|2105858737|gb|MT935684.1| 12615 g85444 i0 99.315 74.096256684492 146 1 78 0 9 154 7918 7773 Cherry leaf roll virus isolate 19NR014 segment RNA1, complete sequence blastn 13856 265 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus avii
6191906 6191906 PRJNA432257_S_NODE_74865_length_198_cov_2.720497_g74484_i0 PRJNA432257 74865 198 2.720497 5.38658406 Cripavirus 144051 Viruses Viruses 355 1.17e-93   NTclustered gi|1877229187|gb|MT336161.1| 209529 g74484 i0 98.99 98.8030303030303 198 2 100 0 1 198 6689 6886 Aphid lethal paralysis virus isolate Ir-Wi, complete genome blastn 19563 355 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus mortiferum
6807941 6807941 PRJNA432257_S_NODE_87026_length_186_cov_187.959732_g86645_i0 PRJNA432257 87026 186 187.959732 349.60510152 Nepovirus avii 3047741 Viruses Viruses 265 1.88e-66   NTclustered gi|2105858737|gb|MT935684.1| 12615 g86645 i0 99.315 74.494623655914 146 1 78 0 33 178 7773 7918 Cherry leaf roll virus isolate 19NR014 segment RNA1, complete sequence blastn 13856 265 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus avii
6807999 6807999 PRJNA432257_S_NODE_92606_length_182_cov_2.062069_g92225_i0 PRJNA432257 92606 182 2.062069 3.75296558 Tocinivirus aphisi 2956538 Viruses Viruses 267 5.08e-67   NTclustered gi|2500381650|ref|NC_076866.1| 2788946 g92225 i0 93.333 0.989010989010989 180 12 99 0 3 182 19780 19601 Aphis citricidus meson-like virus putative OFR1a (QKS44_gp1), putative OFR1ab (QKS44_gp2), hypothetical protein (QKS44_gp3), hypothetical protein (QKS44_gp4), and putative OFR2a (QKS44_gp5) genes, complete cds blastn 180 267 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Mesoniviridae Tocinivirus Tocinivirus aphisi
8082830 8082830 PRJNA432257_S_NODE_3327_length_606_cov_172.008787_g697_i1 PRJNA432257 3327 606 172.008787 1042.37324922 Nepovirus avii 3047741 Viruses Viruses 987 0   NTclustered gi|2105858737|gb|MT935684.1| 12615 g697 i1 98.23 79.3118811881188 565 8 93 2 9 571 7918 7354 Cherry leaf roll virus isolate 19NR014 segment RNA1, complete sequence blastn 48063 987 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus avii
9357411 9357411 PRJNA432257_S_NODE_15448_length_351_cov_49.493631_g15067_i0 PRJNA432257 15448 351 49.493631 173.72264481 Potyvirus plumpoxi 3240600 Viruses Viruses 564 3.449999999999999e-156   NTclustered gi|314947318|gb|HQ452396.1| 12211 g15067 i0 99.357 88.9002849002849 311 2 89 0 4 314 331 21 Plum pox virus strain M isolate Godinje 1 polyprotein gene, partial cds blastn 31204 564 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus plumpoxi
10016768 10016768 PRJNA432257_S_NODE_1508_length_843_cov_2.645161_g1399_i0 PRJNA432257 1508 843 2.645161 22.29870723 Cripavirus 144051 Viruses Viruses 1435 0   NTclustered gi|408690200|gb|JX480861.1| 209529 g1399 i0 97.39 78.9572953736655 843 22 100 0 1 843 7242 8084 Aphid lethal paralysis virus isolate ALPV-An, complete genome blastn 66561 1435 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus mortiferum
10634117 10634117 PRJNA432257_S_NODE_8489_length_433_cov_2.598485_g8154_i0 PRJNA432257 8489 433 2.598485 11.25144005 Ipomovirus cucumisvenaflavi 3429979 Viruses Viruses 795 0   NTclustered gi|1783653563|gb|MK777994.1| 137475 g8154 i0 99.769 20.9237875288684 433 1 100 0 1 433 5561 5993 Cucumber vein yellowing virus isolate Esp, complete genome blastn 9060 795 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Ipomovirus Ipomovirus cucumisvenaflavi
11291736 11291736 PRJNA432257_S_NODE_1009_length_1028_cov_4.463169_g936_i0 PRJNA432257 1009 1028 4.463169 45.88137732 Cripavirus 144051 Viruses Viruses 1770 0   NTclustered gi|1758971469|gb|MK704471.1| 209529 g936 i0 97.677 82.4844357976654 1033 18 100 3 1 1028 9800 8769 Aphid lethal paralysis virus isolate ALPV-CE, complete genome blastn 84794 1773 0.998307952622673 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus mortiferum
11908011 11908011 PRJNA432257_S_NODE_14190_length_362_cov_2.523077_g13809_i0 PRJNA432257 14190 362 2.523077 9.13353874 Tocinivirus aphisi 2956538 Viruses Viruses 372 2.32e-98   NTclustered gi|2500381650|ref|NC_076866.1| 2788946 g13809 i0 86.236 0.983425414364641 356 33 96 12 17 362 20297 19948 Aphis citricidus meson-like virus putative OFR1a (QKS44_gp1), putative OFR1ab (QKS44_gp2), hypothetical protein (QKS44_gp3), hypothetical protein (QKS44_gp4), and putative OFR2a (QKS44_gp5) genes, complete cds blastn 356 372 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Mesoniviridae Tocinivirus Tocinivirus aphisi
13183122 13183122 PRJNA432257_S_NODE_24591_length_300_cov_1.851711_g24210_i0 PRJNA432257 24591 300 1.851711 5.555133 Cripavirus sp. 1955141 Viruses Viruses 555 1.7399999999999995e-153   NTclustered gi|2754691479|gb|PP872551.1| 1955141 g24210 i0 100 98.3533333333333 300 0 100 0 1 300 6380 6679 MAG: Cripavirus sp. isolate TC-CrV-1 MR233-17E/2200 genomic sequence blastn 29506 555 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus sp.
14458566 14458566 PRJNA432257_S_NODE_452_length_2031_cov_17.888666_g440_i0 PRJNA432257 452 2031 17.888666 363.31880646 Ipomovirus cucumisvenaflavi 3429979 Viruses Viruses 3657 0   NTclustered gi|2782682139|gb|PQ072292.1| 137475 g440 i0 99.65 39.8705071393402 2001 7 99 0 5 2005 9751 7751 Cucumber vein yellowing virus isolate DSMZ PV-0724, complete genome blastn 80977 3657 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Ipomovirus Ipomovirus cucumisvenaflavi
14459031 14459031 PRJNA432257_S_NODE_81912_length_191_cov_3.376623_g81531_i0 PRJNA432257 81912 191 3.376623 6.44934993 Ipomovirus cucumisvenaflavi 3429979 Viruses Viruses 348 1.87e-91   NTclustered gi|2106686302|gb|MZ130935.1| 137475 g81531 i0 99.476 20.9371727748691 191 1 100 0 1 191 7633 7443 Cucumber vein yellowing virus isolate DSMZ PV-0776, complete genome blastn 3999 348 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Ipomovirus Ipomovirus cucumisvenaflavi
15733019 15733019 PRJNA432257_S_NODE_99133_length_177_cov_1.950000_g98752_i0 PRJNA432257 99133 177 1.95 3.4515 Ipomovirus cucumisvenaflavi 3429979 Viruses Viruses 311 2.23e-80   NTclustered gi|2106686302|gb|MZ130935.1| 137475 g98752 i0 98.305 21 177 3 100 0 1 177 6896 7072 Cucumber vein yellowing virus isolate DSMZ PV-0776, complete genome blastn 3717 311 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Ipomovirus Ipomovirus cucumisvenaflavi
19556092 19556092 PRJNA432257_S_NODE_81036_length_192_cov_2.012903_g80655_i0 PRJNA432257 81036 192 2.012903 3.86477376 Cripavirus sp. 1955141 Viruses Viruses 326 8.82e-85   NTclustered gi|2754691479|gb|PP872551.1| 1955141 g80655 i0 97.382 2.99479166666667 191 5 99 0 1 191 8121 8311 MAG: Cripavirus sp. isolate TC-CrV-1 MR233-17E/2200 genomic sequence blastn 575 326 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus sp.
20832028 20832028 PRJNA432257_S_NODE_9717_length_413_cov_2.864362_g9369_i0 PRJNA432257 9717 413 2.864362 11.82981506 Cripavirus sp. 1955141 Viruses Viruses 712 0   NTclustered gi|2754691479|gb|PP872551.1| 1955141 g9369 i0 97.816 30.2106537530266 412 9 99 0 1 412 8706 8295 MAG: Cripavirus sp. isolate TC-CrV-1 MR233-17E/2200 genomic sequence blastn 12477 712 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus sp.
21490438 21490438 PRJNA432257_S_NODE_1217_length_930_cov_59.360582_g1127_i0 PRJNA432257 1217 930 59.360582 552.0534126 Potyvirus 12195 Viruses Viruses 1616 0   NTclustered gi|1750422732|gb|MK562730.1| 12211 g1127 i0 99.328 95.7537634408602 893 6 96 0 37 929 360 1252 Plum pox virus isolate MK41 polyprotein gene, partial cds blastn 89051 1616 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus plumpoxi
22106072 22106072 PRJNA432257_S_NODE_3018_length_631_cov_3.946128_g2831_i0 PRJNA432257 3018 631 3.946128 24.90006768 Nilaparvata lugens C virus 1577072 Viruses Viruses 99 7.93e-16   NTclustered gi|726973360|gb|KM270560.1| 1577072 g2831 i0 91.781 2.0459587955626 73 2 11 3 5 74 9119 9048 Nilaparvata lugens C virus, complete genome blastn 1291 99 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Nilaparvata lugens C virus
22106850 22106850 PRJNA432257_S_NODE_8678_length_430_cov_3.809160_g8339_i0 PRJNA432257 8678 430 3.80916 16.379388 Ipomovirus cucumisvenaflavi 3429979 Viruses Viruses 773 0   NTclustered gi|62326965|ref|NC_006941.1| 137475 g8339 i0 99.07 20.9720930232558 430 4 100 0 1 430 3465 3036 Cucumber vein yellowing virus, complete genome blastn 9018 773 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Ipomovirus Ipomovirus cucumisvenaflavi
23381599 23381599 PRJNA432257_S_NODE_24879_length_298_cov_95.103448_g24498_i0 PRJNA432257 24879 298 95.103448 283.40827504 Soybean thrips iflavirus 4 2802223 Viruses Viruses 460 3.88e-125   NTclustered gi|1956563492|gb|MT224138.1| 2802223 g24498 i0 98.473 1.76510067114094 262 3 88 1 1 261 875 614 Soybean thrips iflavirus 4 strain STN1 polyprotein gene, complete cds blastn 526 460 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Soybean thrips iflavirus 4
26886154 26886154 PRJNA432257_S_NODE_21781_length_313_cov_1.695652_g21400_i0 PRJNA432257 21781 313 1.695652 5.30739076 Crogonang virus 135 3062923 Viruses Viruses 83.2 5.46e-16   NR WPR18031.1 3062923 g21400 i0 48.8 2.30031948881789 80 40 76.7 1 313 74 773 851 WPR18031.1 MAG: capsid protein [Crogonang virus 135] diamond 720 83.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 135
29744549 29744549 PRJNA432257_S_NODE_106670_length_170_cov_1.759398_g106289_i0 PRJNA432257 106670 170 1.759398 2.9909766 Picornavirales 464095 Viruses Viruses 43.9 0.00555   NR YP_006607894.1 2870351 g106289 i0 41.2 5.62941176470588 51 29 90 1 7 159 389 438 YP_006607894.1 polyprotein [limnipivirus A1] diamond 957 43.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Limnipivirus Limnipivirus ablugi
29981051 29981051 PRJNA432257_S_NODE_32671_length_271_cov_1.829060_g32290_i0 PRJNA432257 32671 271 1.82906 4.9567526 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 58.9 1.07e-7   NR UNY42067.1 3003959 g32290 i0 34.9 0.952029520295203 86 54 93 2 270 19 512 597 UNY42067.1 MAG: polyprotein 2 [Picornavirales sp.] diamond 258 58.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30107294 30107294 PRJNA432257_S_NODE_43932_length_242_cov_78.775610_g43551_i0 PRJNA432257 43932 242 78.77561 190.6369762 Human blood-associated dicistrovirus 2184748 Viruses Viruses 98.2 1.13e-21   NR AWK23471.1 2184748 g43551 i0 71.8 1.7603305785124 71 16 84.3 2 205 2 220 289 AWK23471.1 structural polyprotein, partial [Human blood-associated dicistrovirus] diamond 426 98.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Human blood-associated dicistrovirus
30834103 30834103 PRJNA432257_S_NODE_38514_length_255_cov_1.857798_g38133_i0 PRJNA432257 38514 255 1.857798 4.7373849 Qianjiang marna-like virus 137 3347560 Viruses Viruses 58.9 8.51e-8   NR XHA88290.1 3347560 g38133 i0 52.1 0.564705882352941 48 23 56.5 0 3 146 774 821 XHA88290.1 MAG: putative viral coat protein [Qianjiang marna-like virus 137] diamond 144 58.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Qianjiang marna-like virus 137
32130772 32130772 PRJNA432257_S_NODE_110218_length_166_cov_1.813953_g109837_i0 PRJNA432257 110218 166 1.813953 3.01116198 Dicistroviridae sp. 1955144 Viruses Viruses 41.2 0.0459   NR ULF99805.1 1955144 g109837 i0 51.7 0.524096385542169 29 14 52.4 0 92 6 452 480 ULF99805.1 MAG: putative nonstructural polyprotein [Dicistroviridae sp.] diamond 87 41.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
32447226 32447226 PRJNA432257_S_NODE_42359_length_246_cov_1.296651_g41978_i0 PRJNA432257 42359 246 1.296651 3.18976146 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 64.3 9.58e-10   NR XCM68204.1 3003959 g41978 i0 47.6 1.98780487804878 82 41 97.6 2 3 242 707 788 XCM68204.1 MAG: structural polyprotein [Picornavirales sp.] diamond 489 64.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32510597 32510597 PRJNA432257_S_NODE_79999_length_193_cov_1.750000_g79618_i0 PRJNA432257 79999 193 1.75 3.3775 Dicistroviridae sp. 1955144 Viruses Viruses 95.9 3.58e-21   NR XCO49023.1 1955144 g79618 i0 91.8 0.761658031088083 49 4 76.2 0 3 149 818 866 XCO49023.1 MAG: putative ORF2 protein [Dicistroviridae sp.] diamond 147 95.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.

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