RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJEB73599" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 21 ✖

bioproject 1

  • PRJEB73599 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
5237743 5237743 PRJEB73599_P_NODE_5_length_6284_cov_7.841886_g2_i0 PRJEB73599 5 6284 7.841886 492.78411624 Qianjiang marna-like virus 54 3347701 Viruses Viruses 944 4.08e-291   NR XHA88140.1 3347701 g2 i0 48.1 0.506524506683641 1061 518 49.6 14 5880 2767 686 1736 XHA88140.1 MAG: polyprotein [Qianjiang marna-like virus 54] diamond 3183 944 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Qianjiang marna-like virus 54
16711890 16711890 PRJEB73599_P_NODE_94_length_2186_cov_6.146036_g63_i0 PRJEB73599 94 2186 6.146036 134.35234696 Mitoviridae sp. 2809572 Viruses Viruses 543 1.2599999999999995e-180   NR URG16541.1 2809572 g63 i0 44.5 0.952424519670631 694 381 94.7 3 2111 42 21 714 URG16541.1 MAG: RNA dependent RNA polymerase, partial [Mitoviridae sp.] diamond 2082 543 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Mitoviridae sp.
27508283 27508283 PRJEB73599_P_NODE_4543_length_315_cov_2.195804_g4256_i0 PRJEB73599 4543 315 2.195804 6.9167826 Ripashan virus 3131120 Viruses Viruses 64.3 2.29e-9   NR WZH60887.1 3131120 g4256 i0 50 0.59047619047619 62 31 59 0 5 190 603 664 WZH60887.1 MAG: RNA-dependent RNA polymerase, partial [Ripashan virus] diamond 186 64.3 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Ripashan virus
27761017 27761017 PRJEB73599_P_NODE_84_length_2241_cov_8.401447_g55_i0 PRJEB73599 84 2241 8.401447 188.27642727 Chrocafunk virus 3129695 Viruses Viruses 230 6.1e-67   NR WZH58726.1 3129695 g55 i0 52.9 0.281124497991968 210 97 28.1 2 1387 758 2 209 WZH58726.1 MAG: RNA-dependent RNA polymerase, partial [Chrocafunk virus] diamond 630 230 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Chrocafunk virus
27792375 27792375 PRJEB73599_P_NODE_124_length_1914_cov_3.293369_g88_i0 PRJEB73599 124 1914 3.293369 63.03508266 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 537 1.1899999999999995e-169   NR XHA88175.1 3003959 g88 i0 44.2 0.996865203761755 636 347 98.9 7 1893 1 878 1510 XHA88175.1 MAG: polyprotein [Qianjiang marna-like virus 71] diamond 1908 537 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Fish-associated picorna-like virus 3
27950231 27950231 PRJEB73599_P_NODE_9125_length_169_cov_1.785714_g8838_i0 PRJEB73599 9125 169 1.785714 3.01785666 Marnaviridae sp. 2715102 Viruses Viruses 101 3.389999999999999e-23   NR ULF99991.1 2715102 g8838 i0 82.1 0.994082840236686 56 10 99.4 0 2 169 2905 2960 ULF99991.1 MAG: hypothetical protein [Marnaviridae sp.] diamond 168 101 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
28195352 28195352 PRJEB73599_P_NODE_7726_length_198_cov_1.816568_g7439_i0 PRJEB73599 7726 198 1.816568 3.59680464 Viruses 10239 Viruses Viruses 56.2 3.46e-7   NR WRQ65340.1 2809914 g7439 i0 58.7 1.74242424242424 46 18 69.7 1 196 59 249 293 WRQ65340.1 structural protein [Tolivirales sp.] diamond 345 56.6 0.992932862190813 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales     Tolivirales sp.
28455521 28455521 PRJEB73599_P_NODE_8786_length_175_cov_1.842466_g8499_i0 PRJEB73599 8786 175 1.842466 3.2243155 Crogonang virus 69 3063080 Viruses Viruses 106 6.45e-25   NR WPR18350.1 3063080 g8499 i0 86.2 1.98857142857143 58 8 99.4 0 174 1 601 658 WPR18350.1 MAG: capsid protein [Crogonang virus 69] diamond 348 106 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 69
29213336 29213336 PRJEB73599_P_NODE_6589_length_231_cov_2.702970_g6302_i0 PRJEB73599 6589 231 2.70297 6.2438607 Proteus mito-like virus 2912713 Viruses Viruses 62.4 3.7e-9   NR DAZ87243.1 2912713 g6302 i0 46.1 0.987012987012987 76 40 98.7 1 2 229 430 504 DAZ87243.1 TPA_asm: RNA-dependent polymerase [Proteus mito-like virus] diamond 228 62.4 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Proteus mito-like virus
29307769 29307769 PRJEB73599_P_NODE_8589_length_179_cov_1.613333_g8302_i0 PRJEB73599 8589 179 1.613333 2.88786607 Ripashan virus 3131120 Viruses Viruses 68.9 9.06e-12   NR WZH60887.1 3131120 g8302 i0 69.2 0.871508379888268 52 13 87.2 1 1 156 712 760 WZH60887.1 MAG: RNA-dependent RNA polymerase, partial [Ripashan virus] diamond 156 68.9 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Ripashan virus
29433823 29433823 PRJEB73599_P_NODE_70_length_2346_cov_3.078981_g47_i0 PRJEB73599 70 2346 3.078981 72.23289426 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 295 1.1e-80   NR XHA88175.1 3003959 g47 i0 43.9 0.818414322250639 319 179 40.8 0 1389 2345 202 520 XHA88175.1 MAG: polyprotein [Qianjiang marna-like virus 71] diamond 1920 295 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Fish-associated picorna-like virus 3
30350611 30350611 PRJEB73599_P_NODE_3712_length_364_cov_1.982090_g3426_i0 PRJEB73599 3712 364 1.98209 7.2148076 Ripatrop virus 3131332 Viruses Viruses 63.2 9.88e-9   NR WZH61242.1 3131332 g3426 i0 27 0.947802197802198 115 68 89.8 4 354 28 347 451 WZH61242.1 MAG: RNA-dependent RNA polymerase [Ripatrop virus] diamond 345 63.2 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Ripatrop virus
30350612 30350612 PRJEB73599_P_NODE_4272_length_330_cov_1.936877_g3985_i0 PRJEB73599 4272 330 1.936877 6.3916941 Ripashan virus 3131120 Viruses Viruses 168 6.63e-46   NR WZH60887.1 3131120 g3985 i0 72.5 0.990909090909091 109 30 99.1 0 3 329 261 369 WZH60887.1 MAG: RNA-dependent RNA polymerase, partial [Ripashan virus] diamond 327 168 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Ripashan virus
30571024 30571024 PRJEB73599_P_NODE_6633_length_230_cov_2.248756_g6346_i0 PRJEB73599 6633 230 2.248756 5.1721388 Qianjiang noda-like virus 156 3348530 Viruses Viruses 103 1.67e-23   NR XHA86180.1 3348530 g6346 i0 71.4 1.83913043478261 70 20 91.3 0 228 19 790 859 XHA86180.1 MAG: polyprotein [Qianjiang noda-like virus 156] diamond 423 103 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Nodaviridae   Qianjiang noda-like virus 156
30658827 30658827 PRJEB73599_P_NODE_7113_length_216_cov_1.636364_g6826_i0 PRJEB73599 7113 216 1.636364 3.53454624 Viruses 10239 Viruses Viruses 135 4.05e-35   NR URG14941.1 1530251 g6826 i0 80.3 4.93055555555556 71 14 98.6 0 3 215 211 281 URG14941.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 1065 136 0.992647058823529 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
30665983 30665983 PRJEB73599_P_NODE_3913_length_351_cov_3.624224_g3627_i0 PRJEB73599 3913 351 3.624224 12.72102624 Proteus mito-like virus 2912713 Viruses Viruses 44.7 0.0267   NR DAZ87243.1 2912713 g3627 i0 32.9 0.64957264957265 76 49 63.2 1 222 1 14 89 DAZ87243.1 TPA_asm: RNA-dependent polymerase [Proteus mito-like virus] diamond 228 44.7 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Proteus mito-like virus
30919002 30919002 PRJEB73599_P_NODE_9014_length_171_cov_1.549296_g8727_i0 PRJEB73599 9014 171 1.549296 2.64929616 ssRNA phage SRR7976357_8 2786748 Viruses Viruses 58.5 4.46e-9   NR YP_010769076.1 2786748 g8727 i0 87.1 0.543859649122807 31 4 54.4 0 93 1 1 31 YP_010769076.1 coat protein [ssRNA phage SRR7976357_8] diamond 93 58.5 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae Ashucavirus Ashucavirus caenivicinum
31013547 31013547 PRJEB73599_P_NODE_8535_length_180_cov_1.748344_g8248_i0 PRJEB73599 8535 180 1.748344 3.1470192 Ripatrop virus 3131332 Viruses Viruses 73.9 1.53e-13   NR WZH61242.1 3131332 g8248 i0 50.8 0.983333333333333 59 28 98.3 1 2 178 164 221 WZH61242.1 MAG: RNA-dependent RNA polymerase [Ripatrop virus] diamond 177 73.9 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Ripatrop virus
31962260 31962260 PRJEB73599_P_NODE_1058_length_733_cov_2.144886_g877_i0 PRJEB73599 1058 733 2.144886 15.72201438 Ripashan virus 3131120 Viruses Viruses 194 3.32e-53   NR WZH60887.1 3131120 g877 i0 58.4 0.679399727148704 166 67 67.1 1 162 653 54 219 WZH60887.1 MAG: RNA-dependent RNA polymerase, partial [Ripashan virus] diamond 498 194 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Ripashan virus
32088838 32088838 PRJEB73599_P_NODE_2378_length_477_cov_2.689732_g2113_i0 PRJEB73599 2378 477 2.689732 12.83002164 Qianjiang marna-like virus 141 3347565 Viruses Viruses 63.9 1.95e-8   NR XHA88296.1 3347565 g2113 i0 30.5 1.19496855345912 190 98 98.1 7 469 2 531 720 XHA88296.1 MAG: polyprotein, partial [Qianjiang marna-like virus 141] diamond 570 63.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Qianjiang marna-like virus 141
32120658 32120658 PRJEB73599_P_NODE_798_length_847_cov_2.193154_g642_i0 PRJEB73599 798 847 2.193154 18.57601438 Herophile durna-like virus 2912704 Viruses Viruses 149 6.459999999999999e-37   NR DAZ87252.1 2912704 g642 i0 40.4 0.701298701298701 198 112 68.7 4 1 582 373 568 DAZ87252.1 TPA_asm: RNA-dependent polymerase, partial [Herophile durna-like virus] diamond 594 149 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales     Herophile durna-like virus

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