RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJNA1174207", tax_kingdom = "Orthornavirae" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 22 ✖

tax_kingdom 1

  • Orthornavirae · 22 ✖

bioproject 1

  • PRJNA1174207 · 22 ✖

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
1590053 1590053 PRJNA1174207_P_NODE_14702_length_378_cov_2.026230_g14173_i0 PRJNA1174207 14702 378 2.02623 7.6591494 Varroa picorna-like virus 2873563 Viruses Viruses 366 1.1299999999999996e-96   NTclustered gi|2111829811|gb|MZ822077.1| 2873563 g14173 i0 84.392 1 378 54 99 5 2 378 841 468 MAG: Varroa picorna-like virus isolate No11-Mi016-HLJ2018, complete genome blastn 378 366 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Varroa picorna-like virus
1590134 1590134 PRJNA1174207_P_NODE_19242_length_323_cov_2.208000_g18713_i0 PRJNA1174207 19242 323 2.208 7.13184 Varroa picorna-like virus 2873563 Viruses Viruses 560 4.08e-155   NTclustered gi|2111829811|gb|MZ822077.1| 2873563 g18713 i0 98.131 1.98761609907121 321 6 99 0 3 323 5484 5164 MAG: Varroa picorna-like virus isolate No11-Mi016-HLJ2018, complete genome blastn 642 560 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Varroa picorna-like virus
4868967 4868967 PRJNA1174207_P_NODE_9744_length_492_cov_1.439141_g9218_i0 PRJNA1174207 9744 492 1.439141 7.08057372 Viruses 10239 Viruses Viruses 749 0   NTclustered gi|2756423860|gb|PP745721.1| 1955144 g9218 i0 94.106 2 492 29 100 0 1 492 2717 3208 MAG: Dicistroviridae sp. isolate 017_5547 genomic sequence blastn 984 749 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
6693372 6693372 PRJNA1174207_P_NODE_20226_length_315_cov_1.586777_g19697_i0 PRJNA1174207 20226 315 1.586777 4.99834755 Varroa picorna-like virus 2873563 Viruses Viruses 494 4.08e-135   NTclustered gi|2111829811|gb|MZ822077.1| 2873563 g19697 i0 94.921 2 315 16 100 0 1 315 3389 3075 MAG: Varroa picorna-like virus isolate No11-Mi016-HLJ2018, complete genome blastn 630 494 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Varroa picorna-like virus
9243223 9243223 PRJNA1174207_P_NODE_11528_length_440_cov_2.833787_g11001_i0 PRJNA1174207 11528 440 2.833787 12.4686628 Dicistroviridae sp. 1955144 Viruses Viruses 488 2.7399999999999993e-133   NTclustered gi|2756423860|gb|PP745721.1| 1955144 g11001 i0 87.215 1.99090909090909 438 44 98 9 2 433 1794 2225 MAG: Dicistroviridae sp. isolate 017_5547 genomic sequence blastn 876 488 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
10519623 10519623 PRJNA1174207_P_NODE_809_length_2121_cov_42.583008_g640_i0 PRJNA1174207 809 2121 42.583008 903.18559968 Dicistroviridae sp. 1955144 Viruses Viruses 3217 0   NTclustered gi|2756423860|gb|PP745721.1| 1955144 g640 i0 96.368 1.89297501178689 1955 71 92 0 2 1956 3161 5115 MAG: Dicistroviridae sp. isolate 017_5547 genomic sequence blastn 4015 3217 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
14344488 14344488 PRJNA1174207_P_NODE_21352_length_309_cov_1.580508_g20823_i0 PRJNA1174207 21352 309 1.580508 4.88376972 Dicistroviridae sp. 1955144 Viruses Viruses 316 9.269999999999999e-82   NTclustered gi|2756423860|gb|PP745721.1| 1955144 g20823 i0 85.342 1.98705501618123 307 43 99 2 3 308 700 1005 MAG: Dicistroviridae sp. isolate 017_5547 genomic sequence blastn 614 316 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
14344934 14344934 PRJNA1174207_P_NODE_552_length_2568_cov_73.924248_g430_i0 PRJNA1174207 552 2568 73.924248 1898.37468864 Varroa picorna-like virus 2873563 Viruses Viruses 3504 0   NTclustered gi|2111829811|gb|MZ822077.1| 2873563 g430 i0 91.849 1.91471962616822 2515 199 98 6 1 2512 5421 7932 MAG: Varroa picorna-like virus isolate No11-Mi016-HLJ2018, complete genome blastn 4917 3504 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Varroa picorna-like virus
15618740 15618740 PRJNA1174207_P_NODE_8393_length_543_cov_1.631915_g7869_i0 PRJNA1174207 8393 543 1.631915 8.86129845 Varroa picorna-like virus 2873563 Viruses Viruses 976 0   NTclustered gi|2111829811|gb|MZ822077.1| 2873563 g7869 i0 99.079 2 543 5 100 0 1 543 4690 4148 MAG: Varroa picorna-like virus isolate No11-Mi016-HLJ2018, complete genome blastn 1086 976 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Varroa picorna-like virus
16342883 16342883 PRJNA1174207_P_NODE_12053_length_428_cov_1.636620_g11526_i0 PRJNA1174207 12053 428 1.63662 7.0047336 Viruses 10239 Viruses Viruses 425 2.11e-114   NTclustered gi|2756423860|gb|PP745721.1| 1955144 g11526 i0 84.941 1.98598130841122 425 58 99 5 5 426 1740 1319 MAG: Dicistroviridae sp. isolate 017_5547 genomic sequence blastn 850 425 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
16892409 16892409 PRJNA1174207_P_NODE_11774_length_434_cov_3.277008_g11247_i0 PRJNA1174207 11774 434 3.277008 14.22221472 Varroa picorna-like virus 2873563 Viruses Viruses 725 0   NTclustered gi|2111829811|gb|MZ822077.1| 2873563 g11247 i0 96.984 1.98617511520737 431 13 99 0 4 434 5114 4684 MAG: Varroa picorna-like virus isolate No11-Mi016-HLJ2018, complete genome blastn 862 725 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Varroa picorna-like virus
18167604 18167604 PRJNA1174207_P_NODE_8215_length_551_cov_2.110879_g7691_i0 PRJNA1174207 8215 551 2.110879 11.63094329 Marnaviridae sp. 2715102 Viruses Viruses 291 2.05e-94   NR QRI44260.1 2715102 g7691 i0 78.1 0.996370235934664 183 40 99.6 0 551 3 181 363 QRI44260.1 MAG: hypothetical protein 1, partial [Marnaviridae sp.] diamond 549 291 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
19441348 19441348 PRJNA1174207_P_NODE_14516_length_381_cov_1.250000_g13987_i0 PRJNA1174207 14516 381 1.25 4.7625 Varroa picorna-like virus 2873563 Viruses Viruses 442 1.8399999999999993e-119   NTclustered gi|2111829811|gb|MZ822077.1| 2873563 g13987 i0 87.632 0.99737532808399 380 47 99 0 2 381 3399 3020 MAG: Varroa picorna-like virus isolate No11-Mi016-HLJ2018, complete genome blastn 380 442 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Varroa picorna-like virus
21992048 21992048 PRJNA1174207_P_NODE_178_length_3993_cov_402.771429_g129_i0 PRJNA1174207 178 3993 402.771429 16082.66315997 Severe acute respiratory syndrome coronavirus 2 2697049 Viruses Viruses 2459 0   NR ULP78342.1 2697049 g129 i0 98.3 9.5717505634861 1277 15 95.4 1 3945 136 1 1277 ULP78342.1 surface glycoprotein [Severe acute respiratory syndrome coronavirus 2] diamond 38220 2459 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
25266707 25266707 PRJNA1174207_P_NODE_15220_length_370_cov_2.296296_g14691_i0 PRJNA1174207 15220 370 2.296296 8.4962952 Viruses 10239 Viruses Viruses 623 5.939999999999999e-174   NTclustered gi|2756423860|gb|PP745721.1| 1955144 g14691 i0 97.027 2 370 11 100 0 1 370 948 1317 MAG: Dicistroviridae sp. isolate 017_5547 genomic sequence blastn 740 623 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
26692230 26692230 PRJNA1174207_P_NODE_9241_length_508_cov_2.604598_g8716_i0 PRJNA1174207 9241 508 2.604598 13.23135784 Picornaviridae sp. 1530251 Viruses Viruses 266 5.39e-79   NR URG14835.1 1530251 g8716 i0 78.6 0.992125984251969 168 36 99.2 0 506 3 1448 1615 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 504 266 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28019847 28019847 PRJNA1174207_P_NODE_6365_length_656_cov_1.814751_g5850_i0 PRJNA1174207 6365 656 1.814751 11.90476656 Picornaviridae sp. 1530251 Viruses Viruses 301 1.66e-90   NR URG14835.1 1530251 g5850 i0 67 0.996951219512195 218 71 99.7 1 655 2 1188 1404 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 654 301 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28146186 28146186 PRJNA1174207_P_NODE_8605_length_534_cov_1.845987_g8081_i0 PRJNA1174207 8605 534 1.845987 9.85757058 Picornaviridae sp. 1530251 Viruses Viruses 265 2.67e-78   NR URG14835.1 1530251 g8081 i0 65.7 0.98314606741573 175 59 97.8 1 530 9 324 498 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 525 265 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28872105 28872105 PRJNA1174207_P_NODE_41168_length_241_cov_1.636905_g40639_i0 PRJNA1174207 41168 241 1.636905 3.94494105 Shenzhen dicistro-like virus 2789378 Viruses Viruses 75.1 1.51e-13   NR QPG92982.1 2789378 g40639 i0 49.5 2.2655601659751 91 32 95.9 1 11 241 991 1081 QPG92982.1 polyprotein [Shenzhen dicistro-like virus] diamond 546 75.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Shenzhen dicistro-like virus
29629581 29629581 PRJNA1174207_P_NODE_710_length_2258_cov_6.094737_g560_i0 PRJNA1174207 710 2258 6.094737 137.61916146 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 810 1.94e-282   NR XCM67754.1 3003959 g560 i0 60.3 0.919397697077059 692 257 90.6 5 2 2047 215 898 XCM67754.1 MAG: structural polyprotein [Picornavirales sp.] diamond 2076 810 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29977318 29977318 PRJNA1174207_P_NODE_5351_length_732_cov_3.444613_g4849_i0 PRJNA1174207 5351 732 3.444613 25.21456716 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 156 1.98e-39   NR XCM67754.1 3003959 g4849 i0 55.8 0.565573770491803 138 57 56.6 1 292 705 71 204 XCM67754.1 MAG: structural polyprotein [Picornavirales sp.] diamond 414 156 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31430898 31430898 PRJNA1174207_P_NODE_31456_length_258_cov_2.729730_g30927_i0 PRJNA1174207 31456 258 2.72973 7.0427034 Picornaviridae sp. 1530251 Viruses Viruses 65.1 6.14e-10   NR URG14835.1 1530251 g30927 i0 42.1 0.883720930232558 76 43 87.2 1 244 20 844 919 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 228 65.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae 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);;