RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA1195374" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 16 ✖

bioproject 1

  • PRJNA1195374 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
21444734 21444734 PRJNA1195374_P_NODE_5197_length_917_cov_2.110190_g4934_i0 PRJNA1195374 5197 917 2.11019 19.3504423 Exserohilum turcicum hypovirus 1 3229025 Viruses Viruses 227 3.42e-63   NR XBY85566.1 3229025 g4934 i0 58.8 1.10250817884406 170 70 55.6 0 917 408 2824 2993 XBY85566.1 MAG: polyprotein [Exserohilum turcicum hypovirus 1] diamond 1011 227 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Hypoviridae Hypovirus Exserohilum turcicum hypovirus 1
26723734 26723734 PRJNA1195374_P_NODE_21461_length_490_cov_1.258993_g21118_i0 PRJNA1195374 21461 490 1.258993 6.1690657 Hangzhou marna-like virus 1 3029006 Viruses Viruses 219 8.53e-63   NR WEU70895.1 3029006 g21118 i0 64.2 0.991836734693878 162 58 99.2 0 490 5 925 1086 WEU70895.1 MAG: polyprotein [Hangzhou marna-like virus 1] diamond 486 219 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Hangzhou marna-like virus 1
26723758 26723758 PRJNA1195374_P_NODE_42121_length_343_cov_1.140741_g41777_i0 PRJNA1195374 42121 343 1.140741 3.91274163 Blattella germanica narna-like virus 1 3133484 Viruses Viruses 127 3.2099999999999996e-31   NR DBA56653.1 3133484 g41777 i0 57.3 0.962099125364432 110 42 96.2 2 335 6 543 647 DBA56653.1 TPA_asm: RNA-dependent RNA polymerase [Blattella germanica narna-like virus 1] diamond 330 127 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Blattella germanica narna-like virus 1
27325317 27325317 PRJNA1195374_P_NODE_5543_length_894_cov_1.806334_g5273_i0 PRJNA1195374 5543 894 1.806334 16.14862596 Hangzhou marna-like virus 1 3029006 Viruses Viruses 375 5.94e-115   NR WEU70895.1 3029006 g5273 i0 65.7 0.996644295302013 297 101 99.3 1 890 3 2338 2634 WEU70895.1 MAG: polyprotein [Hangzhou marna-like virus 1] diamond 891 375 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Hangzhou marna-like virus 1
27483241 27483241 PRJNA1195374_P_NODE_59583_length_281_cov_1.110577_g59239_i0 PRJNA1195374 59583 281 1.110577 3.12072137 Qianjiang picorna-like virus 47 3348773 Viruses Viruses 80.9 2.3e-15   NR XHA88515.1 3348773 g59239 i0 47.3 0.99288256227758 93 49 99.3 0 2 280 202 294 XHA88515.1 MAG: putative viral coat protein [Qianjiang picorna-like virus 47] diamond 279 80.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 47
28398878 28398878 PRJNA1195374_P_NODE_66566_length_262_cov_1.555556_g66222_i0 PRJNA1195374 66566 262 1.555556 4.07555672 Sanya dicistrovirus 1 2905415 Viruses Viruses 145 5.01e-38   NR UHM27589.1 2905415 g66222 i0 92.8 0.950381679389313 83 6 95 0 8 256 480 562 UHM27589.1 MAG: capsid protein [Sanya dicistrovirus 1] diamond 249 145 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Sanya dicistrovirus 1
28430500 28430500 PRJNA1195374_P_NODE_18326_length_529_cov_1.918860_g17983_i0 PRJNA1195374 18326 529 1.91886 10.1507694 Blattella germanica narna-like virus 1 3133484 Viruses Viruses 83.2 6.48e-15   NR DBA56653.1 3133484 g17983 i0 33 1.03213610586011 182 109 96.4 4 19 528 768 948 DBA56653.1 TPA_asm: RNA-dependent RNA polymerase [Blattella germanica narna-like virus 1] diamond 546 83.2 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Blattella germanica narna-like virus 1
28651456 28651456 PRJNA1195374_P_NODE_22187_length_482_cov_1.506112_g21843_i0 PRJNA1195374 22187 482 1.506112 7.25945984 Picornaviridae sp. 1530251 Viruses Viruses 312 8.909999999999998e-101   NR URG14866.1 1530251 g21843 i0 92.5 0.995850622406639 160 12 99.6 0 2 481 26 185 URG14866.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 480 312 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
29125366 29125366 PRJNA1195374_P_NODE_63329_length_271_cov_1.166667_g62985_i0 PRJNA1195374 63329 271 1.166667 3.16166757 Sanya dicistrovirus 1 2905415 Viruses Viruses 157 3.44e-42   NR UHM27589.1 2905415 g62985 i0 80.9 1.97047970479705 89 17 98.5 0 3 269 665 753 UHM27589.1 MAG: capsid protein [Sanya dicistrovirus 1] diamond 534 157 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Sanya dicistrovirus 1
29314493 29314493 PRJNA1195374_P_NODE_13849_length_604_cov_2.451977_g13511_i0 PRJNA1195374 13849 604 2.451977 14.80994108 Fusarium oxysporum dianthi hypovirus 2 2698666 Viruses Viruses 248 4.26e-72   NR YP_010800030.1 2698666 g13511 i0 59.7 1.99668874172185 201 79 99.8 1 603 1 2501 2699 YP_010800030.1 polyprotein [Fusarium oxysporum dianthi hypovirus 2] diamond 1206 248 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Hypoviridae Betahypovirus Betahypovirus fusarii
29787916 29787916 PRJNA1195374_P_NODE_24171_length_462_cov_1.287918_g23827_i0 PRJNA1195374 24171 462 1.287918 5.95018116 Picornaviridae sp. 1530251 Viruses Viruses 268 2.91e-86   NR URG14693.1 1530251 g23827 i0 95.6 0.876623376623377 135 6 87.7 0 462 58 290 424 URG14693.1 MAG: polyprotein, partial [Picornaviridae sp.] diamond 405 268 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
30040797 30040797 PRJNA1195374_P_NODE_19611_length_512_cov_1.674260_g19268_i0 PRJNA1195374 19611 512 1.67426 8.5722112 Hebei hypo-like virus 3 3401102 Viruses Viruses 266 4.3e-79   NR XHY85258.1 3401102 g19268 i0 72.2 0.990234375 169 47 99 0 1 507 1491 1659 XHY85258.1 MAG: polyprotein, partial [Hebei hypo-like virus 3] diamond 507 266 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Hypoviridae   Hebei hypo-like virus 3
30357293 30357293 PRJNA1195374_P_NODE_44052_length_334_cov_1.908046_g43708_i0 PRJNA1195374 44052 334 1.908046 6.37287364 Hangzhou marna-like virus 1 3029006 Viruses Viruses 206 5.27e-59   NR WEU70895.1 3029006 g43708 i0 82.9 0.997005988023952 111 19 99.7 0 1 333 2179 2289 WEU70895.1 MAG: polyprotein [Hangzhou marna-like virus 1] diamond 333 206 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Hangzhou marna-like virus 1
31747501 31747501 PRJNA1195374_P_NODE_86057_length_227_cov_2.266234_g85713_i0 PRJNA1195374 86057 227 2.266234 5.14435118 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 73.9 3.1e-13   NR UNY42204.1 3003959 g85713 i0 62.7 0.674008810572687 51 19 67.4 0 75 227 607 657 UNY42204.1 MAG: polyprotein, partial [Picornavirales sp.] diamond 153 73.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32095504 32095504 PRJNA1195374_P_NODE_1658_length_1362_cov_6.121800_g1508_i0 PRJNA1195374 1658 1362 6.1218 83.378916 Durnavirales sp. 2809355 Viruses Viruses 248 4.45e-73   NR WRQ64726.1 2809355 g1508 i0 35.3 0.94273127753304 428 269 93.2 5 94 1362 10 434 WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.] diamond 1284 248 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales     Durnavirales sp.
32696017 32696017 PRJNA1195374_P_NODE_44680_length_332_cov_1.000000_g44336_i0 PRJNA1195374 44680 332 1 3.32 Picornaviridae sp. 1530251 Viruses Viruses 130 8.36e-33   NR URG14866.1 1530251 g44336 i0 95.3 0.578313253012048 64 3 57.8 0 3 194 276 339 URG14866.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 192 130 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);;