RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where analysis = "blastn", bioproject = "PRJNA602115" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 33 ✖

bioproject 1

  • PRJNA602115 · 33 ✖

analysis 1

  • blastn · 33 ✖

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
575612 575612 PRJNA602115_P_NODE_1_length_7596_cov_5.270206_g0_i0 PRJNA602115 1 7596 5.270206 400.32484776 Potyvirus sacchari 3240610 Viruses Viruses 13729 0   NTclustered gi|1173652586|gb|KU886553.1| 12224 g0 i0 99.289 99.675355450237 7596 54 100 0 1 7596 8214 619 Sugarcane mosaic virus isolate Yunan, complete genome blastn 757134 13729 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus sacchari
575657 575657 PRJNA602115_P_NODE_3621_length_322_cov_1.375479_g3596_i0 PRJNA602115 3621 322 1.375479 4.42904238 Microvirus sp. 2202559 Viruses Viruses 446 1.1899999999999999e-120   NTclustered gi|2581533517|gb|OR350223.1| 2202559 g3596 i0 92.089 2.6583850931677 316 25 98 0 1 316 3881 4196 MAG: Microvirus sp. isolate LSWO_304 clone LS456, complete genome blastn 856 446 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
575720 575720 PRJNA602115_P_NODE_5621_length_268_cov_1.342995_g5596_i0 PRJNA602115 5621 268 1.342995 3.5992266 Cressdnaviricota sp. 2748378 Viruses Viruses 381 2.759999999999999e-101   NTclustered gi|2896100955|gb|PQ792342.1| 2748378 g5596 i0 92.509 0.996268656716418 267 18 99 2 1 266 3168 2903 MAG: Cressdnaviricota sp. isolate SbovineF090_cress11 genomic sequence blastn 267 381 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
1851351 1851351 PRJNA602115_P_NODE_10182_length_205_cov_1.020833_g10157_i0 PRJNA602115 10182 205 1.020833 2.09270765 Microviridae sp. 2202644 Viruses Viruses 198 2.17e-46   NTclustered gi|2302019813|gb|MT206358.1| 2202644 g10157 i0 84.577 1.56585365853659 201 29 98 2 6 205 2963 2764 MAG: Microviridae sp. isolate CN7_L17_103, complete genome blastn 321 198 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
1851408 1851408 PRJNA602115_P_NODE_1382_length_503_cov_2.581448_g1357_i0 PRJNA602115 1382 503 2.581448 12.98468344 Microvirus sp. 2202559 Viruses Viruses 730 0   NTclustered gi|2581533517|gb|OR350223.1| 2202559 g1357 i0 92.857 1.00198807157058 504 35 100 1 1 503 2928 3431 MAG: Microvirus sp. isolate LSWO_304 clone LS456, complete genome blastn 504 730 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
3126635 3126635 PRJNA602115_P_NODE_11523_length_202_cov_0.907801_g11498_i0 PRJNA602115 11523 202 0.907801 1.83375802 Ralstonia phage C22 3076817 Viruses Viruses 357 3.3299999999999996e-94   NTclustered gi|2875302554|gb|OR538033.2| 3076817 g11498 i0 98.515 2.98019801980198 202 3 100 0 1 202 28282 28483 Ralstonia phage C22, complete genome blastn 602 357 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Ralstonia phage C22
4403308 4403308 PRJNA602115_P_NODE_1144_length_549_cov_1.729508_g1119_i0 PRJNA602115 1144 549 1.729508 9.49499892 Microviridae sp. 2202644 Viruses Viruses 520 1.23e-142   NTclustered gi|1986762546|gb|MW347815.1| 2202644 g1119 i0 89.512 16.591985428051 410 43 75 0 140 549 88 497 MAG: Microviridae sp. isolate 5cz-micro-4 major capsid protein gene, partial cds blastn 9109 520 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
4403412 4403412 PRJNA602115_P_NODE_4_length_4429_cov_10.644689_g0_i1 PRJNA602115 4 4429 10.644689 471.45327581 Potyvirus sacchari 3240610 Viruses Viruses 8022 0   NTclustered gi|1173652586|gb|KU886553.1| 12224 g0 i1 99.368 93.5527207044479 4428 28 99 0 2 4429 9598 5171 Sugarcane mosaic virus isolate Yunan, complete genome blastn 414345 8022 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus sacchari
4403433 4403433 PRJNA602115_P_NODE_5724_length_265_cov_2.367647_g5699_i0 PRJNA602115 5724 265 2.367647 6.27426455 Potyvirus sacchari 3240610 Viruses Viruses 473 4.3599999999999987e-129   NTclustered gi|447380343|gb|JX047396.1| 12224 g5699 i0 98.868 74.777358490566 265 3 100 0 1 265 6557 6293 Sugarcane mosaic virus isolate NX7271, complete genome blastn 19816 473 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus sacchari
4403466 4403466 PRJNA602115_P_NODE_6764_length_244_cov_1.256831_g6739_i0 PRJNA602115 6764 244 1.256831 3.06666764 Microviridae sp. 2202644 Viruses Viruses 80.5 1.01e-10   NTclustered gi|2636869240|gb|OR408952.1| 2202644 g6739 i0 80.583 0.422131147540984 103 20 42 0 142 244 932 830 MAG: Microviridae sp. isolate xizangnaqu28-14668 genomic sequence blastn 103 80.5 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
4403499 4403499 PRJNA602115_P_NODE_8104_length_220_cov_1.207547_g8079_i0 PRJNA602115 8104 220 1.207547 2.6566034 Microvirus sp. 2202559 Viruses Viruses 274 3.82e-69   NTclustered gi|2581533517|gb|OR350223.1| 2202559 g8079 i0 89.401 11.9681818181818 217 23 99 0 1 217 1508 1292 MAG: Microvirus sp. isolate LSWO_304 clone LS456, complete genome blastn 2633 274 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
4403501 4403501 PRJNA602115_P_NODE_8164_length_219_cov_1.132911_g8139_i0 PRJNA602115 8164 219 1.132911 2.48107509 Microvirus sp. 2202559 Viruses Viruses 320 4.81e-83   NTclustered gi|2581533517|gb|OR350223.1| 2202559 g8139 i0 94.258 1.46118721461187 209 12 95 0 11 219 2420 2628 MAG: Microvirus sp. isolate LSWO_304 clone LS456, complete genome blastn 320 320 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
5679416 5679416 PRJNA602115_P_NODE_3185_length_340_cov_1.379928_g3160_i0 PRJNA602115 3185 340 1.379928 4.6917552 Wigfec virus K19_555 2986010 Viruses Viruses 573 5.54e-159   NTclustered gi|2316504316|gb|OP549837.1| 2986010 g3160 i0 97.059 1 340 10 100 0 1 340 479 818 MAG: Wigfec virus K19_555, complete genome blastn 340 573 1 Viruses   Shotokuvirae Cressdnaviricota         Wigfec virus K19_555
5679486 5679486 PRJNA602115_P_NODE_5_length_4405_cov_9.531077_g0_i2 PRJNA602115 5 4405 9.531077 419.84394185 Potyvirus sacchari 3240610 Viruses Viruses 7354 0   NTclustered gi|1728384937|gb|MH580837.1| 12224 g0 i2 96.82 94.6061293984109 4403 138 99 2 5 4405 9539 5137 Sugarcane mosaic virus strain Shanxi, complete genome blastn 416740 7354 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus sacchari
6953924 6953924 PRJNA602115_P_NODE_1226_length_531_cov_4.838298_g1201_i0 PRJNA602115 1226 531 4.838298 25.69136238 Potyvirus sacchari 3240610 Viruses Viruses 970 0   NTclustered gi|987898853|gb|KU171817.1| 12224 g1201 i0 99.623 84.5875706214689 531 2 100 0 1 531 547 17 Sugarcane mosaic virus isolate CN:HB:15, complete genome blastn 44916 970 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus sacchari
6953966 6953966 PRJNA602115_P_NODE_3106_length_344_cov_0.904594_g3081_i0 PRJNA602115 3106 344 0.904594 3.11180336 Microviridae sp. 2202644 Viruses Viruses 279 1.37e-70   NTclustered gi|1986762564|gb|MW348211.1| 2202644 g3081 i0 96.45 1.0203488372093 169 6 49 0 176 344 1 169 MAG: Microviridae sp. isolate 6nt-micro-4 major capsid protein gene, partial cds blastn 351 279 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
8795695 8795695 PRJNA602115_P_NODE_2447_length_385_cov_0.851852_g2422_i0 PRJNA602115 2447 385 0.851852 3.2796302 Viruses 10239 Viruses Viruses 183 1.25e-41   NTclustered gi|2056936201|tpg|BK022393.1| 2219103 g2422 i0 85.246 6.07272727272727 183 21 46 6 207 385 14048 14228 MAG TPA_asm: Inoviridae sp. isolate ct6Da14, partial genome blastn 2338 183 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
10779979 10779979 PRJNA602115_P_NODE_3009_length_350_cov_1.013841_g2984_i0 PRJNA602115 3009 350 1.013841 3.5484435 Retroviridae sp. 2681591 Viruses Viruses 625 1.5499999999999995e-174   NTclustered gi|2896100155|gb|PQ791973.1| 2681591 g2984 i0 99.135 1.98285714285714 347 3 99 0 1 347 2476 2822 MAG: Retroviridae sp. isolate Hpika254_retro1 genomic sequence blastn 694 625 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae   Retroviridae sp.
10780046 10780046 PRJNA602115_P_NODE_5369_length_274_cov_1.201878_g5344_i0 PRJNA602115 5369 274 1.201878 3.29314572 Cressdnaviricota sp. 2748378 Viruses Viruses 460 3.53e-125   NTclustered gi|2896100955|gb|PQ792342.1| 2748378 g5344 i0 99.603 0.91970802919708 252 1 92 0 1 252 1130 879 MAG: Cressdnaviricota sp. isolate SbovineF090_cress11 genomic sequence blastn 252 460 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
12054949 12054949 PRJNA602115_P_NODE_3410_length_330_cov_0.951673_g3385_i0 PRJNA602115 3410 330 0.951673 3.1405209 Cressdnaviricota sp. 2748378 Viruses Viruses 516 9.17e-142   NTclustered gi|2896100955|gb|PQ792342.1| 2748378 g3385 i0 94.848 1.19090909090909 330 17 100 0 1 330 3220 3549 MAG: Cressdnaviricota sp. isolate SbovineF090_cress11 genomic sequence blastn 393 516 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
13329715 13329715 PRJNA602115_P_NODE_4051_length_307_cov_1.821138_g4026_i0 PRJNA602115 4051 307 1.821138 5.59089366 Potyvirus sacchari 3240610 Viruses Viruses 518 2.35e-142   NTclustered gi|1782804217|gb|MN756484.1| 12224 g4026 i0 100 91.1074918566775 280 0 91 0 1 280 3583 3862 Sugarcane mosaic virus isolate SCMV Mara13-TZA, complete genome blastn 27970 518 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus sacchari
13329771 13329771 PRJNA602115_P_NODE_591_length_751_cov_1.314493_g568_i0 PRJNA602115 591 751 1.314493 9.87184243 Microvirus sp. 2202559 Viruses Viruses 499 2.24e-136   NTclustered gi|2581533517|gb|OR350223.1| 2202559 g568 i0 82.453 0.781624500665779 587 87 77 15 173 751 1787 2365 MAG: Microvirus sp. isolate LSWO_304 clone LS456, complete genome blastn 587 499 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
17153483 17153483 PRJNA602115_P_NODE_6734_length_245_cov_1.043478_g6709_i0 PRJNA602115 6734 245 1.043478 2.5565211 Genomoviridae sp. 2202565 Viruses Viruses 381 2.4799999999999995e-101   NTclustered gi|1832329329|gb|MT309858.1| 2202565 g6709 i0 94.694 14.4 245 13 100 0 1 245 1355 1111 MAG: Genomoviridae sp. isolate 6434_413, complete genome blastn 3528 381 1 Viruses   Shotokuvirae Cressdnaviricota Repensiviricetes Geplafuvirales Genomoviridae   Genomoviridae sp.
18427699 18427699 PRJNA602115_P_NODE_4455_length_296_cov_0.872340_g4430_i0 PRJNA602115 4455 296 0.87234 2.5821264 Cressdnaviricota sp. 2748378 Viruses Viruses 403 6.59e-108   NTclustered gi|2896100955|gb|PQ792342.1| 2748378 g4430 i0 91.275 1.00675675675676 298 22 100 2 1 296 2583 2878 MAG: Cressdnaviricota sp. isolate SbovineF090_cress11 genomic sequence blastn 298 403 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
18427799 18427799 PRJNA602115_P_NODE_795_length_663_cov_1.340532_g770_i0 PRJNA602115 795 663 1.340532 8.88772716 Microvirus sp. 2202559 Viruses Viruses 745 0   NTclustered gi|2581533517|gb|OR350223.1| 2202559 g770 i0 92.802 17.3212669683258 514 37 78 0 1 514 155 668 MAG: Microvirus sp. isolate LSWO_304 clone LS456, complete genome blastn 11484 745 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
18427810 18427810 PRJNA602115_P_NODE_8295_length_217_cov_0.897436_g8270_i0 PRJNA602115 8295 217 0.897436 1.94743612 Microvirus sp. 2202559 Viruses Viruses 340 3.6499999999999996e-89   NTclustered gi|2581532085|gb|OR350021.1| 2202559 g8270 i0 94.931 9.10138248847926 217 11 100 0 1 217 3415 3631 MAG: Microvirus sp. isolate LSLA_262 clone LS254, complete genome blastn 1975 340 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
18427823 18427823 PRJNA602115_P_NODE_8815_length_209_cov_0.864865_g8790_i0 PRJNA602115 8815 209 0.864865 1.80756785 Microviridae sp. 2202644 Viruses Viruses 195 2.88e-45   NTclustered gi|2216796470|gb|MW202471.1| 2202644 g8790 i0 85.714 0.904306220095694 189 21 89 5 21 206 3224 3409 Microviridae sp. isolate ctUFZ915, complete genome blastn 189 195 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
19702251 19702251 PRJNA602115_P_NODE_16_length_3300_cov_7.861377_g0_i3 PRJNA602115 16 3300 7.861377 259.425441 Potyvirus sacchari 3240610 Viruses Viruses 5862 0   NTclustered gi|1173652586|gb|KU886553.1| 12224 g0 i3 98.727 99.5763636363636 3300 42 100 0 1 3300 4915 8214 Sugarcane mosaic virus isolate Yunan, complete genome blastn 328602 5862 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus sacchari
20978078 20978078 PRJNA602115_P_NODE_637_length_726_cov_1.493233_g613_i0 PRJNA602115 637 726 1.493233 10.84087158 Genomoviridae sp. 2202565 Viruses Viruses 1184 0   NTclustered gi|1832329329|gb|MT309858.1| 2202565 g613 i0 96.639 41.961432506887 714 22 98 2 10 722 1444 2156 MAG: Genomoviridae sp. isolate 6434_413, complete genome blastn 30464 1184 1 Viruses   Shotokuvirae Cressdnaviricota Repensiviricetes Geplafuvirales Genomoviridae   Genomoviridae sp.
22252962 22252962 PRJNA602115_P_NODE_9938_length_206_cov_0.882759_g9913_i0 PRJNA602115 9938 206 0.882759 1.81848354 Wigfec virus K19_555 2986010 Viruses Viruses 215 2.17e-51   NTclustered gi|2316504316|gb|OP549837.1| 2986010 g9913 i0 86.911 0.927184466019418 191 25 93 0 13 203 1335 1525 MAG: Wigfec virus K19_555, complete genome blastn 191 215 1 Viruses   Shotokuvirae Cressdnaviricota         Wigfec virus K19_555
23528089 23528089 PRJNA602115_P_NODE_2599_length_375_cov_1.187898_g2574_i0 PRJNA602115 2599 375 1.187898 4.4546175 Retroviridae sp. 2681591 Viruses Viruses 255 2.53e-63   NTclustered gi|2896100019|gb|PQ791907.1| 2681591 g2574 i0 98.611 0.384 144 2 38 0 1 144 144 1 MAG: Retroviridae sp. isolate Hpika137_retro1 genomic sequence blastn 144 255 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae   Retroviridae sp.
24801857 24801857 PRJNA602115_P_NODE_1560_length_477_cov_1.269231_g1535_i0 PRJNA602115 1560 477 1.269231 6.05423187 Microviridae sp. 2202644 Viruses Viruses 337 1.1399999999999999e-87   NTclustered gi|2636872893|gb|OR410766.1| 2202644 g1535 i0 82.323 2.55555555555556 396 62 82 7 37 428 1200 809 MAG: Microviridae sp. isolate xizangshannan41-10874 genomic sequence blastn 1219 337 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
24801909 24801909 PRJNA602115_P_NODE_3560_length_324_cov_1.589354_g3535_i0 PRJNA602115 3560 324 1.589354 5.14950696 Potyvirus sacchari 3240610 Viruses Viruses 582 8.729999999999998e-162   NTclustered gi|1368163998|gb|MF467399.1| 12224 g3535 i0 99.074 88.9197530864197 324 3 100 0 1 324 6961 7284 Sugarcane mosaic virus isolate NA41-Tz, complete genome blastn 28810 582 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus sacchari

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