RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJEB25583" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 24 ✖

tax_kingdom 1

bioproject 1

  • PRJEB25583 · 24 ✖

analysis 1

  • diamond · 24 ✖

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
4814234 4814234 PRJEB25583_P_NODE_1764_length_319_cov_5.361702_g1587_i0 PRJEB25583 1764 319 5.361702 17.10382938 Picornavirales 464095 Viruses Viruses 187 2.85e-53   NR URG14941.1 1530251 g1587 i0 84.8 4.94670846394984 105 16 98.7 0 316 2 278 382 URG14941.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 1578 187 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
27184621 27184621 PRJEB25583_P_NODE_6122_length_168_cov_2.282443_g5945_i0 PRJEB25583 6122 168 2.2824430000000002 3.83450424 Viruses 10239 Viruses Viruses 55.8 3.18e-7   NR URG15009.1 1530251 g5945 i0 50 3.82142857142857 54 27 96.4 0 6 167 1558 1611 URG15009.1 MAG: polyprotein [Picornaviridae sp.] diamond 642 56.2 0.99288256227758 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
27317816 27317816 PRJEB25583_P_NODE_5143_length_181_cov_2.034722_g4966_i0 PRJEB25583 5143 181 2.034722 3.68284682 Qianjiang picorna-like virus 126 3348721 Viruses Viruses 60.8 6.38e-9   NR XHA88635.1 3348721 g4966 i0 54 0.828729281767956 50 23 82.9 0 24 173 130 179 XHA88635.1 MAG: putative RNA-dependent RNA polymerase [Qianjiang picorna-like virus 126] diamond 150 60.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 126
27507347 27507347 PRJEB25583_P_NODE_4363_length_195_cov_3.734177_g4186_i0 PRJEB25583 4363 195 3.734177 7.28164515 Qianjiang marna-like virus 79 3347728 Viruses Viruses 45.4 0.00232   NR XHA88191.1 3347728 g4186 i0 36.4 0.846153846153846 55 33 83.1 2 10 171 877 930 XHA88191.1 MAG: polyprotein [Qianjiang marna-like virus 79] diamond 165 45.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Qianjiang marna-like virus 79
27696957 27696957 PRJEB25583_P_NODE_5424_length_177_cov_1.578571_g5247_i0 PRJEB25583 5424 177 1.578571 2.79407067 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 117 7.79e-29   NR XCM68155.1 3003959 g5247 i0 91.4 1.96610169491525 58 5 98.3 0 2 175 1272 1329 XCM68155.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 348 117 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28043914 28043914 PRJEB25583_P_NODE_4725_length_188_cov_5.364238_g4548_i0 PRJEB25583 4725 188 5.364238 10.08476744 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 43.5 0.00985   NR XCM67741.1 3003959 g4548 i0 60.7 0.446808510638298 28 11 44.7 0 97 180 250 277 XCM67741.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 84 43.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28612289 28612289 PRJEB25583_P_NODE_3807_length_207_cov_13.164706_g3630_i0 PRJEB25583 3807 207 13.164706 27.25094142 Crogonang virus 24 3062947 Viruses Viruses 127 5.279999999999999e-32   NR WPR18079.1 3062947 g3630 i0 86.6 0.971014492753623 67 9 97.1 0 7 207 245 311 WPR18079.1 MAG: structural polyprotein [Crogonang virus 24] diamond 201 127 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 24
28896296 28896296 PRJEB25583_P_NODE_6928_length_160_cov_3.902439_g6751_i0 PRJEB25583 6928 160 3.902439 6.2439024 Crogonang virus 58 3063050 Viruses Viruses 42.7 0.0124   NR WPR18299.1 3063050 g6751 i0 51.1 0.88125 47 23 88.1 0 147 7 187 233 WPR18299.1 MAG: structural polyprotein, partial [Crogonang virus 58] diamond 141 42.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 58
29086020 29086020 PRJEB25583_P_NODE_3248_length_224_cov_9.395722_g3071_i0 PRJEB25583 3248 224 9.395722 21.04641728 Marnaviridae sp. 2715102 Viruses Viruses 134 1.31e-34   NR ULF99924.1 2715102 g3071 i0 84.9 0.977678571428571 73 11 97.8 0 4 222 1579 1651 ULF99924.1 MAG: hypothetical protein 1 [Marnaviridae sp.] diamond 219 134 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
29212328 29212328 PRJEB25583_P_NODE_5189_length_180_cov_6.132867_g5012_i0 PRJEB25583 5189 180 6.132867 11.0391606 Marnaviridae sp. 2715102 Viruses Viruses 108 1.49e-25   NR ULF99999.1 2715102 g5012 i0 94.5 0.916666666666667 55 3 91.7 0 13 177 417 471 ULF99999.1 MAG: hypothetical protein [Marnaviridae sp.] diamond 165 108 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
29906950 29906950 PRJEB25583_P_NODE_2971_length_235_cov_2.722222_g2794_i0 PRJEB25583 2971 235 2.722222 6.3972217 Crogonang virus 24 3062947 Viruses Viruses 131 1.86e-33   NR WPR18079.1 3062947 g2794 i0 95.6 0.868085106382979 68 3 86.8 0 204 1 375 442 WPR18079.1 MAG: structural polyprotein [Crogonang virus 24] diamond 204 131 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 24
30096244 30096244 PRJEB25583_P_NODE_3852_length_206_cov_4.715976_g3675_i0 PRJEB25583 3852 206 4.715976 9.71491056 Crogonang virus 47 3063018 Viruses Viruses 72 9.59e-13   NR WPR18235.1 3063018 g3675 i0 50.8 1.89320388349515 65 32 94.7 0 196 2 312 376 WPR18235.1 MAG: RNA-dependent RNA polymerase [Crogonang virus 47] diamond 390 72 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 47
30286363 30286363 PRJEB25583_P_NODE_2892_length_238_cov_5.253731_g2715_i0 PRJEB25583 2892 238 5.253731 12.50387978 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 170 6.29e-47   NR UNY42034.1 3003959 g2715 i0 98.7 0.995798319327731 79 1 99.6 0 1 237 232 310 UNY42034.1 MAG: polyprotein 1 [Picornavirales sp.] diamond 237 170 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30601777 30601777 PRJEB25583_P_NODE_5253_length_179_cov_8.732394_g5076_i0 PRJEB25583 5253 179 8.732394 15.63098526 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 94.4 1.05e-20   NR UNY42034.1 3003959 g5076 i0 90.6 0.888268156424581 53 5 88.8 0 21 179 726 778 UNY42034.1 MAG: polyprotein 1 [Picornavirales sp.] diamond 159 94.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30753461 30753461 PRJEB25583_P_NODE_5774_length_172_cov_6.014815_g5597_i0 PRJEB25583 5774 172 6.014815 10.3454818 Viruses 10239 Viruses Viruses 73.9 1.44e-13   NR URG14941.1 1530251 g5597 i0 73.3 1.56976744186047 45 12 78.5 0 135 1 37 81 URG14941.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 270 73.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
31006160 31006160 PRJEB25583_P_NODE_4814_length_187_cov_1.240000_g4637_i0 PRJEB25583 4814 187 1.24 2.3188 Viruses 10239 Viruses Viruses 117 1.27e-28   NR XHA88244.1 3347532 g4637 i0 91.8 2.93582887700535 61 5 97.9 0 187 5 509 569 XHA88244.1 MAG: polyprotein [Qianjiang marna-like virus 111] diamond 549 117 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Qianjiang marna-like virus 111
31322197 31322197 PRJEB25583_P_NODE_5795_length_172_cov_2.014815_g5618_i0 PRJEB25583 5795 172 2.014815 3.4654818 Viruses 10239 Viruses Viruses 46.2 8.72e-4   NR UNY42030.1 1955153 g5618 i0 52.4 3.78488372093023 42 20 73.3 0 172 47 325 366 UNY42030.1 MAG: polyprotein 2 [Picornavirales sp.] diamond 651 46.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Picornavirales sp.
31644876 31644876 PRJEB25583_P_NODE_5077_length_182_cov_4.275862_g4900_i0 PRJEB25583 5077 182 4.275862 7.78206884 Marnaviridae sp. 2715102 Viruses Viruses 94.4 1.1e-20   NR ULF99924.1 2715102 g4900 i0 66.7 0.989010989010989 60 20 98.9 0 1 180 1219 1278 ULF99924.1 MAG: hypothetical protein 1 [Marnaviridae sp.] diamond 180 94.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
31859838 31859838 PRJEB25583_P_NODE_2537_length_256_cov_7.420091_g2360_i0 PRJEB25583 2537 256 7.420091 18.99543296 Viruses 10239 Viruses Viruses 103 2.38e-23   NR ULF99991.1 2715102 g2360 i0 55.6 1.6875 81 36 94.9 0 12 254 1065 1145 ULF99991.1 MAG: hypothetical protein [Marnaviridae sp.] diamond 432 103 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
31866272 31866272 PRJEB25583_P_NODE_1717_length_325_cov_12.482639_g1540_i0 PRJEB25583 1717 325 12.482639 40.56857675 Marnaviridae sp. 2715102 Viruses Viruses 198 2.28e-56   NR ULF99969.1 2715102 g1540 i0 100 0.932307692307692 101 0 93.2 0 304 2 323 423 ULF99969.1 MAG: hypothetical protein 1 [Marnaviridae sp.] diamond 303 198 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
31866273 31866273 PRJEB25583_P_NODE_2557_length_255_cov_19.573394_g2380_i0 PRJEB25583 2557 255 19.573394 49.9121547 Marnaviridae sp. 2715102 Viruses Viruses 140 2.69e-36   NR ULF99969.1 2715102 g2380 i0 80 0.941176470588235 80 16 94.1 0 240 1 167 246 ULF99969.1 MAG: hypothetical protein 1 [Marnaviridae sp.] diamond 240 140 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
31898081 31898081 PRJEB25583_P_NODE_5037_length_183_cov_1.561644_g4860_i0 PRJEB25583 5037 183 1.561644 2.85780852 Marnaviridae sp. 2715102 Viruses Viruses 88.6 1.18e-18   NR ULF99985.1 2715102 g4860 i0 75.9 4.42622950819672 54 13 88.5 0 163 2 2431 2484 ULF99985.1 MAG: hypothetical protein [Marnaviridae sp.] diamond 810 88.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
32594167 32594167 PRJEB25583_P_NODE_8040_length_152_cov_2.391304_g7863_i0 PRJEB25583 8040 152 2.391304 3.63478208 Marnaviridae sp. 2715102 Viruses Viruses 98.6 2.29e-22   NR ULF99924.1 2715102 g7863 i0 94 1.97368421052632 50 3 98.7 0 2 151 311 360 ULF99924.1 MAG: hypothetical protein 1 [Marnaviridae sp.] diamond 300 98.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
32782792 32782792 PRJEB25583_P_NODE_5200_length_180_cov_2.867133_g5023_i0 PRJEB25583 5200 180 2.867133 5.1608394 Marnaviridae sp. 2715102 Viruses Viruses 124 4.119999999999999e-31   NR ULF99985.1 2715102 g5023 i0 94.9 2.95 59 3 98.3 0 2 178 2547 2605 ULF99985.1 MAG: hypothetical protein [Marnaviridae sp.] diamond 531 124 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);;