RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJEB29441" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJEB29441 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
8953893 8953893 PRJEB29441_P_NODE_8968_length_381_cov_2.352410_g8527_i0 PRJEB29441 8968 381 2.35241 8.9626821 Marnaviridae sp. 2715102 Viruses Viruses 259 2.6400000000000002e-77   NR ULF99969.1 2715102 g8527 i0 100 1 127 0 100 0 381 1 335 461 ULF99969.1 MAG: hypothetical protein 1 [Marnaviridae sp.] diamond 381 259 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
27127677 27127677 PRJEB29441_P_NODE_9522_length_369_cov_1.750000_g9081_i0 PRJEB29441 9522 369 1.75 6.4575 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 86.7 6.47e-17   NR UNY42030.1 3003959 g9081 i0 47.7 2.09756097560976 86 39 69.9 1 259 2 318 397 UNY42030.1 MAG: polyprotein 2 [Picornavirales sp.] diamond 774 86.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27444411 27444411 PRJEB29441_P_NODE_33683_length_180_cov_1.618321_g33242_i0 PRJEB29441 33683 180 1.618321 2.9129778 Crogonang virus 69 3063080 Viruses Viruses 113 1.9e-27   NR WPR18350.1 3063080 g33242 i0 86.7 1 60 8 100 0 180 1 598 657 WPR18350.1 MAG: capsid protein [Crogonang virus 69] diamond 180 113 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 69
27760146 27760146 PRJEB29441_P_NODE_17084_length_261_cov_1.490566_g16643_i0 PRJEB29441 17084 261 1.490566 3.89037726 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 92 2.24e-19   NR AVM87418.1 3063761 g16643 i0 58.4 1.73563218390805 77 28 86.2 3 34 258 779 853 AVM87418.1 polyprotein [Yancheng osbecks grenadier anchovy picornavirus] diamond 453 92 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
28233185 28233185 PRJEB29441_P_NODE_28366_length_197_cov_1.033784_g27925_i0 PRJEB29441 28366 197 1.033784 2.03655448 Chemarfal virus 127 3062889 Viruses Viruses 132 7.83e-34   NR WPR17966.1 3062889 g27925 i0 95.4 0.989847715736041 65 3 99 0 195 1 370 434 WPR17966.1 MAG: hypothetical protein [Chemarfal virus 127] diamond 195 132 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Chemarfal virus 127
28959878 28959878 PRJEB29441_P_NODE_44308_length_163_cov_0.894737_g43867_i0 PRJEB29441 44308 163 0.894737 1.45842131 Picornaviridae sp. 1530251 Viruses Viruses 77 1.04e-14   NR URG14849.1 1530251 g43867 i0 58.5 1.91411042944785 53 22 97.5 0 163 5 458 510 URG14849.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 312 77 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
29054513 29054513 PRJEB29441_P_NODE_29648_length_192_cov_1.797203_g29207_i0 PRJEB29441 29648 192 1.797203 3.45062976 Barns Ness breadcrumb sponge aquatic picorna-like virus 1 2021877 Viruses Viruses 56.6 2.51e-7   NR ASM94051.1 2021877 g29207 i0 82.8 0.90625 29 5 45.3 0 88 174 987 1015 ASM94051.1 hypothetical protein [Barns Ness breadcrumb sponge aquatic picorna-like virus 1] diamond 174 56.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Barns Ness breadcrumb sponge aquatic picorna-like virus 1
30001824 30001824 PRJEB29441_P_NODE_11531_length_329_cov_2.121429_g11090_i0 PRJEB29441 11531 329 2.121429 6.97950141 Marnaviridae sp. 2715102 Viruses Viruses 193 1.3499999999999998e-54   NR ULF99999.1 2715102 g11090 i0 81.7 1.98784194528875 109 20 99.4 0 3 329 638 746 ULF99999.1 MAG: hypothetical protein [Marnaviridae sp.] diamond 654 193 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
30033381 30033381 PRJEB29441_P_NODE_31651_length_186_cov_1.489051_g31210_i0 PRJEB29441 31651 186 1.489051 2.76963486 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 119 2.56e-29   NR XCM67828.1 3003959 g31210 i0 90.2 0.983870967741935 61 6 98.4 0 3 185 586 646 XCM67828.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 183 119 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30184667 30184667 PRJEB29441_P_NODE_28792_length_195_cov_1.890411_g28351_i0 PRJEB29441 28792 195 1.890411 3.68630145 Viruses 10239 Viruses Viruses 136 1.7999999999999998e-35   NR ULF99999.1 2715102 g28351 i0 96.9 1.96923076923077 64 2 98.5 0 2 193 1985 2048 ULF99999.1 MAG: hypothetical protein [Marnaviridae sp.] diamond 384 136 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
30191112 30191112 PRJEB29441_P_NODE_19552_length_241_cov_2.614583_g19111_i0 PRJEB29441 19552 241 2.614583 6.30114503 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 102 3.75e-23   NR AVM87439.1 3063761 g19111 i0 62 0.883817427385892 71 27 88.4 0 2 214 1073 1143 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 213 102 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
30633380 30633380 PRJEB29441_P_NODE_24833_length_211_cov_1.888889_g24392_i0 PRJEB29441 24833 211 1.888889 3.98555579 Marnaviridae sp. 2715102 Viruses Viruses 66.6 9.57e-11   NR ULF99985.1 2715102 g24392 i0 50 0.995260663507109 70 35 99.5 0 211 2 1030 1099 ULF99985.1 MAG: hypothetical protein [Marnaviridae sp.] diamond 210 66.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
30665162 30665162 PRJEB29441_P_NODE_17413_length_258_cov_1.980861_g16972_i0 PRJEB29441 17413 258 1.980861 5.11062138 Marnaviridae sp. 2715102 Viruses Viruses 171 2.4699999999999997e-47   NR ULF99985.1 2715102 g16972 i0 92.9 3.96511627906977 85 6 98.8 0 255 1 2516 2600 ULF99985.1 MAG: hypothetical protein [Marnaviridae sp.] diamond 1023 171 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
30886353 30886353 PRJEB29441_P_NODE_20794_length_232_cov_2.961749_g20353_i0 PRJEB29441 20794 232 2.961749 6.87125768 Crogonang virus 1 3062897 Viruses Viruses 144 1.95e-38   NR WPR18491.1 3063241 g20353 i0 85.7 0.995689655172414 77 11 99.6 0 2 232 408 484 WPR18491.1 MAG: capsid protein, partial [Crogonang virus 100] diamond 231 144 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 100
31233739 31233739 PRJEB29441_P_NODE_48815_length_151_cov_2.274510_g48374_i0 PRJEB29441 48815 151 2.27451 3.4345101 Crogonang virus 24 3062947 Viruses Viruses 84.7 1.63e-17   NR WPR18079.1 3062947 g48374 i0 81.6 0.973509933774834 49 9 97.4 0 3 149 441 489 WPR18079.1 MAG: structural polyprotein [Crogonang virus 24] diamond 147 84.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 24
31353970 31353970 PRJEB29441_P_NODE_28016_length_198_cov_1.590604_g27575_i0 PRJEB29441 28016 198 1.590604 3.14939592 Viruses 10239 Viruses Viruses 117 5.01e-29   NR URG14887.1 1530251 g27575 i0 86.4 4 66 9 100 0 198 1 237 302 URG14887.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 792 117 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
31360590 31360590 PRJEB29441_P_NODE_33016_length_182_cov_1.533835_g32575_i0 PRJEB29441 33016 182 1.533835 2.7915797 Chemarfal virus 22 3062880 Viruses Viruses 54.7 1.01e-6   NR WPR17949.1 3062880 g32575 i0 48.3 0.989010989010989 60 31 98.9 0 1 180 3283 3342 WPR17949.1 MAG: capsid protein [Chemarfal virus 22] diamond 180 54.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Chemarfal virus 22
31670174 31670174 PRJEB29441_P_NODE_48217_length_156_cov_2.747664_g47776_i0 PRJEB29441 48217 156 2.747664 4.28635584 Viruses 10239 Viruses Viruses 105 9.24e-25   NR UNY42139.1 1955153 g47776 i0 98.1 3 52 1 100 0 1 156 1022 1073 UNY42139.1 MAG: polyprotein, partial [Picornavirales sp.] diamond 468 106 0.990566037735849 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Picornavirales sp.
31676617 31676617 PRJEB29441_P_NODE_28277_length_197_cov_1.702703_g27836_i0 PRJEB29441 28277 197 1.702703 3.35432491 Freshwater macrophyte associated sobeli-like virus 3 2946069 Viruses Viruses 63.2 1.22e-9   NR UQZ09597.1 2946069 g27836 i0 50 0.913705583756345 60 29 89.8 1 2 178 346 405 UQZ09597.1 putative capsid protein [Freshwater macrophyte associated sobeli-like virus 3] diamond 180 63.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales     Freshwater macrophyte associated sobeli-like virus 3
32309803 32309803 PRJEB29441_P_NODE_23399_length_218_cov_2.041420_g22958_i0 PRJEB29441 23399 218 2.04142 4.4502956 Marnaviridae sp. 2715102 Viruses Viruses 127 3.2299999999999997e-32   NR ULF99969.1 2715102 g22958 i0 83.3 0.990825688073395 72 12 99.1 0 3 218 200 271 ULF99969.1 MAG: hypothetical protein 1 [Marnaviridae sp.] diamond 216 127 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
32309806 32309806 PRJEB29441_P_NODE_36499_length_172_cov_2.902439_g36058_i0 PRJEB29441 36499 172 2.902439 4.99219508 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 55.5 4.75e-7   NR AVM87439.1 3063761 g36058 i0 46.7 1.04651162790698 60 29 99.4 1 2 172 451 510 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 180 55.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
32404500 32404500 PRJEB29441_P_NODE_21119_length_230_cov_2.055249_g20678_i0 PRJEB29441 21119 230 2.055249 4.7270727 Marnaviridae sp. 2715102 Viruses Viruses 155 1.01e-41   NR ULF99969.1 2715102 g20678 i0 92.1 0.991304347826087 76 6 99.1 0 2 229 112 187 ULF99969.1 MAG: hypothetical protein 1 [Marnaviridae sp.] diamond 228 155 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
32751545 32751545 PRJEB29441_P_NODE_9560_length_368_cov_1.896552_g9119_i0 PRJEB29441 9560 368 1.896552 6.97931136 Marnaviridae sp. 2715102 Viruses Viruses 198 4.109999999999998e-56   NR ULF99999.1 2715102 g9119 i0 83.2 0.921195652173913 113 19 92.1 0 28 366 832 944 ULF99999.1 MAG: hypothetical protein [Marnaviridae sp.] diamond 339 198 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae 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);;