RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where bioproject = "PRJNA758088", 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

  • PRJNA758088 · 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
739027 739027 PRJNA758088_P_NODE_81_length_9972_cov_7.096979_g36_i0 PRJNA758088 81 9972 7.096979 707.71074588 Iflavirus sp. 1916690 Viruses Viruses 17937 0   NTclustered gi|2895513751|tpg|BK068496.1| 1916690 g36 i0 99.167 20.2864019253911 9967 74 99 5 7 9972 38 9996 TPA_asm: Iflavirus sp. isolate WUR25 polyprotein gene, complete cds blastn 202296 17937 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Iflavirus sp.
3285537 3285537 PRJNA758088_P_NODE_115043_length_391_cov_0.968553_g108073_i0 PRJNA758088 115043 391 0.968553 3.78704223 Sadwavirus alphananas 3052738 Viruses Viruses 529 1.4199999999999994e-145   NTclustered gi|2441902565|gb|OP860244.1| 2726258 g108073 i0 92.225 2.9079283887468 373 29 95 0 1 373 4121 4493 Pineapple secovirus A isolate PSVA/S2-1 segment RNA1, complete sequence blastn 1137 529 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus alphananas
3285799 3285799 PRJNA758088_P_NODE_130823_length_367_cov_1.551020_g123852_i0 PRJNA758088 130823 367 1.55102 5.6922434 Iflavirus sp. 1916690 Viruses Viruses 667 0   NTclustered gi|2895513745|tpg|BK068493.1| 1916690 g123852 i0 99.455 7.98092643051771 367 2 100 0 1 367 8501 8135 TPA_asm: Iflavirus sp. isolate WUR22 polyprotein gene, complete cds blastn 2929 667 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Iflavirus sp.
4562506 4562506 PRJNA758088_P_NODE_106024_length_407_cov_1.473054_g99054_i0 PRJNA758088 106024 407 1.473054 5.99532978 Sadwavirus alphananas 3052738 Viruses Viruses 564 4.06e-156   NTclustered gi|2441902603|gb|OP860263.1| 2726258 g99054 i0 91.646 5 407 34 100 0 1 407 3315 2909 Pineapple secovirus A isolate PSVA/S2-1 segment RNA2, complete sequence blastn 2035 564 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus alphananas
4563665 4563665 PRJNA758088_P_NODE_176784_length_319_cov_1.252033_g169813_i0 PRJNA758088 176784 319 1.252033 3.99398527 Sadwavirus gammananas 3433747 Viruses Viruses 505 1.91e-138   NTclustered gi|2322080717|tpg|BK061318.1| 2936685 g169813 i0 95.283 0.996865203761755 318 15 99 0 1 318 2662 2979 TPA_asm: Ananas comosus secovirus isolate Yellow Mauritius segment RNA1, complete sequence blastn 318 505 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus gammananas
4564751 4564751 PRJNA758088_P_NODE_250764_length_268_cov_1.451282_g243793_i0 PRJNA758088 250764 268 1.451282 3.88943576 Black pepper virus F 2964737 Viruses Viruses 466 7.39e-127   NTclustered gi|2270862376|gb|MZ648325.1| 2964737 g243793 i0 98.127 1.98880597014925 267 5 99 0 1 267 4877 4611 Black pepper virus F isolate ZYP-1 segment RNA1, complete sequence blastn 533 466 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Black pepper virus F
5841242 5841242 PRJNA758088_P_NODE_34385_length_803_cov_2.369863_g28381_i0 PRJNA758088 34385 803 2.369863 19.02999989 Iflavirus sp. 1916690 Viruses Viruses 1478 0   NTclustered gi|2895513745|tpg|BK068493.1| 1916690 g28381 i0 99.875 12.1581569115816 803 1 100 0 1 803 9453 8651 TPA_asm: Iflavirus sp. isolate WUR22 polyprotein gene, complete cds blastn 9763 1478 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Iflavirus sp.
8389008 8389008 PRJNA758088_P_NODE_207987_length_295_cov_1.387387_g201016_i0 PRJNA758088 207987 295 1.387387 4.09279165 Sadwavirus gammananas 3433747 Viruses Viruses 453 6.420000000000001e-123   NTclustered gi|2322080717|tpg|BK061318.1| 2936685 g201016 i0 94.276 1.00677966101695 297 15 100 1 1 295 27 323 TPA_asm: Ananas comosus secovirus isolate Yellow Mauritius segment RNA1, complete sequence blastn 297 453 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus gammananas
10938539 10938539 PRJNA758088_P_NODE_131409_length_366_cov_2.098976_g124438_i0 PRJNA758088 131409 366 2.098976 7.68225216 Black pepper virus F 2964737 Viruses Viruses 593 4.599999999999998e-165   NTclustered gi|2270862376|gb|MZ648325.1| 2964737 g124438 i0 96.143 1.98360655737705 363 14 99 0 2 364 3453 3815 Black pepper virus F isolate ZYP-1 segment RNA1, complete sequence blastn 726 593 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Black pepper virus F
10940755 10940755 PRJNA758088_P_NODE_277609_length_252_cov_1.536313_g270638_i0 PRJNA758088 277609 252 1.536313 3.87150876 Sadwavirus gammananas 3433747 Viruses Viruses 388 1.5299999999999998e-103   NTclustered gi|2322080717|tpg|BK061318.1| 2936685 g270638 i0 94.444 1 252 14 100 0 1 252 2213 2464 TPA_asm: Ananas comosus secovirus isolate Yellow Mauritius segment RNA1, complete sequence blastn 252 388 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus gammananas
13491193 13491193 PRJNA758088_P_NODE_322091_length_246_cov_0.890173_g315120_i0 PRJNA758088 322091 246 0.890173 2.18982558 Sadwavirus gammananas 3433747 Viruses Viruses 377 3.2300000000000003e-100   NTclustered gi|2322080717|tpg|BK061318.1| 2936685 g315120 i0 94.309 1 246 14 100 0 1 246 4837 5082 TPA_asm: Ananas comosus secovirus isolate Yellow Mauritius segment RNA1, complete sequence blastn 246 377 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus gammananas
14766353 14766353 PRJNA758088_P_NODE_32412_length_833_cov_1.906579_g26553_i0 PRJNA758088 32412 833 1.906579 15.88180307 Black pepper virus F 2964737 Viruses Viruses 1295 0   NTclustered gi|2270862378|gb|MZ648326.1| 2964737 g26553 i0 94.718 1.99639855942377 833 44 100 0 1 833 1456 624 Black pepper virus F isolate ZYP-1 segment RNA2, complete sequence blastn 1663 1295 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Black pepper virus F
16037820 16037820 PRJNA758088_P_NODE_173533_length_322_cov_0.967871_g166562_i0 PRJNA758088 173533 322 0.967871 3.11654462 Sadwavirus alphananas 3052738 Viruses Viruses 462 1.18e-125   NTclustered gi|2441902565|gb|OP860244.1| 2726258 g166562 i0 92.547 4.82608695652174 322 24 100 0 1 322 5757 5436 Pineapple secovirus A isolate PSVA/S2-1 segment RNA1, complete sequence blastn 1554 462 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus alphananas
18586094 18586094 PRJNA758088_P_NODE_115835_length_389_cov_2.044304_g108865_i0 PRJNA758088 115835 389 2.044304 7.95234256 Black pepper virus F 2964737 Viruses Viruses 597 3.8099999999999986e-166   NTclustered gi|2270862378|gb|MZ648326.1| 2964737 g108865 i0 94.344 2 389 22 100 0 1 389 1901 1513 Black pepper virus F isolate ZYP-1 segment RNA2, complete sequence blastn 778 597 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Black pepper virus F
18587136 18587136 PRJNA758088_P_NODE_184495_length_313_cov_0.920833_g177524_i0 PRJNA758088 184495 313 0.920833 2.88220729 Sadwavirus alphananas 3052738 Viruses Viruses 523 5.159999999999999e-144   NTclustered gi|2500669110|ref|NC_078626.1| 2726258 g177524 i0 96.805 5.04792332268371 313 10 100 0 1 313 24 336 Pineapple secovirus A isolate HANA187 segment RNA1, complete sequence blastn 1580 523 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus alphananas
18588509 18588509 PRJNA758088_P_NODE_279415_length_251_cov_1.449438_g272444_i0 PRJNA758088 279415 251 1.449438 3.63808938 Iflavirus sp. 1916690 Viruses Viruses 448 2.48e-121   NTclustered gi|2895513745|tpg|BK068493.1| 1916690 g272444 i0 98.805 1 251 3 100 0 1 251 7272 7022 TPA_asm: Iflavirus sp. isolate WUR22 polyprotein gene, complete cds blastn 251 448 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Iflavirus sp.
19862063 19862063 PRJNA758088_P_NODE_166576_length_328_cov_1.188235_g159605_i0 PRJNA758088 166576 328 1.188235 3.8974108 Sadwavirus alphananas 3052738 Viruses Viruses 442 1.5699999999999994e-119   NTclustered gi|2441902567|gb|OP860245.1| 2726258 g159605 i0 90.854 2.96646341463415 328 30 100 0 1 328 3330 3003 Pineapple secovirus A isolate PSVA/S2-2 segment RNA1, complete sequence blastn 973 442 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus alphananas
21136901 21136901 PRJNA758088_P_NODE_120717_length_382_cov_0.996764_g113747_i0 PRJNA758088 120717 382 0.996764 3.80763848 Sadwavirus alphananas 3052738 Viruses Viruses 499 1.08e-136   NTclustered gi|2441902599|gb|OP860261.1| 2726258 g113747 i0 90.501 3.97643979057592 379 35 99 1 5 382 2355 1977 Pineapple secovirus A isolate PSVA/S1-1 segment RNA2, complete sequence blastn 1519 499 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Sadwavirus Sadwavirus alphananas
21138934 21138934 PRJNA758088_P_NODE_254617_length_266_cov_1.196891_g247646_i0 PRJNA758088 254617 266 1.196891 3.18373006 Iflavirus sp. 1916690 Viruses Viruses 486 5.629999999999999e-133   NTclustered gi|2895513745|tpg|BK068493.1| 1916690 g247646 i0 99.624 11.5488721804511 266 1 100 0 1 266 5536 5801 TPA_asm: Iflavirus sp. isolate WUR22 polyprotein gene, complete cds blastn 3072 486 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Iflavirus sp.
22414659 22414659 PRJNA758088_P_NODE_316998_length_247_cov_0.885057_g310027_i0 PRJNA758088 316998 247 0.885057 2.18609079 Black pepper virus F 2964737 Viruses Viruses 418 1.9099999999999998e-112   NTclustered gi|2270862376|gb|MZ648325.1| 2964737 g310027 i0 97.166 1.98785425101215 247 7 100 0 1 247 4192 3946 Black pepper virus F isolate ZYP-1 segment RNA1, complete sequence blastn 491 418 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Black pepper virus F
22416085 22416085 PRJNA758088_P_NODE_63498_length_543_cov_1.463830_g56578_i0 PRJNA758088 63498 543 1.46383 7.9485969 Black pepper virus F 2964737 Viruses Viruses 887 0   NTclustered gi|2270862378|gb|MZ648326.1| 2964737 g56578 i0 96.133 2 543 21 100 0 1 543 2682 2140 Black pepper virus F isolate ZYP-1 segment RNA2, complete sequence blastn 1086 887 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Black pepper virus F
27558321 27558321 PRJNA758088_P_NODE_347724_length_243_cov_0.905882_g340753_i0 PRJNA758088 347724 243 0.905882 2.20129326 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 126 1.58e-31   NR XDO02803.1 3239337 g340753 i0 67.9 0.962962962962963 78 25 96.3 0 3 236 1750 1827 XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22] diamond 234 126 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
28253066 28253066 PRJNA758088_P_NODE_255926_length_265_cov_1.203125_g248955_i0 PRJNA758088 255926 265 1.203125 3.18828125 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 63.9 1.76e-9   NR XDO02803.1 3239337 g248955 i0 62.8 0.486792452830189 43 16 48.7 0 1 129 1943 1985 XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22] diamond 129 63.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
28505755 28505755 PRJNA758088_P_NODE_96887_length_427_cov_0.994350_g89917_i0 PRJNA758088 96887 427 0.99435 4.2458745 Pineapple secovirus C 3022851 Viruses Viruses 238 6.69e-70   NR WCR39296.1 3022851 g89917 i0 76.8 0.997658079625293 142 33 99.8 0 2 427 532 673 WCR39296.1 polyprotein 2 [Pineapple secovirus C] diamond 426 238 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae   Pineapple secovirus C
28632236 28632236 PRJNA758088_P_NODE_160327_length_334_cov_0.885057_g153356_i0 PRJNA758088 160327 334 0.885057 2.95609038 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 57.8 5.85e-7   NR XDO02803.1 3239337 g153356 i0 28.6 0.94311377245509 105 75 94.3 0 332 18 1267 1371 XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22] diamond 315 57.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
28695383 28695383 PRJNA758088_P_NODE_32067_length_839_cov_1.604439_g26240_i0 PRJNA758088 32067 839 1.604439 13.46124321 Pineapple secovirus C 3022851 Viruses Viruses 426 2.56e-138   NR WCR39296.1 3022851 g26240 i0 77.1 0.951132300357569 266 60 95.1 1 839 42 798 1062 WCR39296.1 polyprotein 2 [Pineapple secovirus C] diamond 798 426 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae   Pineapple secovirus C
28726744 28726744 PRJNA758088_P_NODE_15967_length_1296_cov_2.077678_g12243_i0 PRJNA758088 15967 1296 2.077678 26.92670688 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 267 3.71e-76   NR XDO02804.1 3239337 g12243 i0 42 0.909722222222222 393 196 88 9 91 1230 559 932 XDO02804.1 MAG: putative viral coat protein [Qianjiang picorna-like virus 22] diamond 1179 267 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
29358301 29358301 PRJNA758088_P_NODE_183149_length_314_cov_0.958506_g176178_i0 PRJNA758088 183149 314 0.958506 3.00970884 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 91.7 6.03e-19   NR XDO02803.1 3239337 g176178 i0 47.6 0.984076433121019 103 54 98.4 0 4 312 1469 1571 XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22] diamond 309 91.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
29547477 29547477 PRJNA758088_P_NODE_128830_length_370_cov_1.282828_g121859_i0 PRJNA758088 128830 370 1.282828 4.7464636 Pineapple secovirus C 3022851 Viruses Viruses 142 1.42e-36   NR WCR39296.1 3022851 g121859 i0 63.3 0.883783783783784 109 40 88.4 0 328 2 396 504 WCR39296.1 polyprotein 2 [Pineapple secovirus C] diamond 327 142 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae   Pineapple secovirus C
29863407 29863407 PRJNA758088_P_NODE_64391_length_538_cov_4.501075_g57462_i0 PRJNA758088 64391 538 4.501075 24.2157835 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 65.1 1.28e-8   NR XDO02804.1 3239337 g57462 i0 33.7 0.546468401486989 98 58 50.7 3 111 383 976 1073 XDO02804.1 MAG: putative viral coat protein [Qianjiang picorna-like virus 22] diamond 294 65.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
29895122 29895122 PRJNA758088_P_NODE_137611_length_358_cov_2.701754_g130640_i0 PRJNA758088 137611 358 2.701754 9.67227932 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 147 2.93e-38   NR XDO02804.1 3239337 g130640 i0 60.7 0.980446927374302 117 43 95.5 1 357 16 379 495 XDO02804.1 MAG: putative viral coat protein [Qianjiang picorna-like virus 22] diamond 351 147 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
32329571 32329571 PRJNA758088_P_NODE_213939_length_291_cov_1.403670_g206968_i0 PRJNA758088 213939 291 1.40367 4.0846797 Pineapple secovirus C 3022851 Viruses Viruses 169 3.21e-46   NR WCR39296.1 3022851 g206968 i0 81.1 0.979381443298969 95 18 97.9 0 3 287 710 804 WCR39296.1 polyprotein 2 [Pineapple secovirus C] diamond 285 169 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae   Pineapple secovirus C

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