RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA558770", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 11 ✖

tax_phylum 1

  • Pisuviricota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA558770 · 11 ✖

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
538119 538119 PRJNA558770_P_NODE_150381_length_234_cov_6.391960_g148376_i0 PRJNA558770 150381 234 6.39196 14.9571864 Orthonoravirus melanogastri 3060507 Viruses Viruses 139 1.56e-28   NTclustered gi|2070847598|gb|MW976819.1| 3071212 g148376 i0 100 23.5213675213675 75 0 62 0 1 75 10585 10511 Drosophila melanogaster Nora virus isolate k119_18666 RNA-dependent RNA polymerase gene, complete cds blastn 5504 139 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Noraviridae Orthonoravirus Orthonoravirus melanogastri
1818016 1818016 PRJNA558770_P_NODE_58242_length_274_cov_4.447699_g56238_i0 PRJNA558770 58242 274 4.447699 12.18669526 Sobemovirus sp. 2809869 Viruses Viruses 69.4 2.5e-7   NTclustered gi|2171145024|gb|MZ218240.1| 2809869 g56238 i0 85.938 74.029197080292 64 9 23 0 4 67 5128 5191 MAG: Sobemovirus sp. isolate 267-k141_60134 genomic sequence blastn 20284 69.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae Sobemovirus Sobemovirus sp.
3092553 3092553 PRJNA558770_P_NODE_386583_length_189_cov_3.857143_g384578_i0 PRJNA558770 386583 189 3.857143 7.29000027 Megareus marna-like virus 1 2980093 Viruses Viruses 294 2.44e-75   NTclustered gi|2306601800|gb|OP191694.1| 2980093 g384578 i0 100 0.841269841269841 159 0 84 0 31 189 477 635 MAG: Megareus marna-like virus 1 isolate Nanocul1, partial genome blastn 159 294 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Megareus marna-like virus 1
11332110 11332110 PRJNA558770_P_NODE_187309_length_234_cov_4.301508_g185304_i0 PRJNA558770 187309 234 4.301508 10.06552872 Viruses 10239 Viruses Viruses 128 3.38e-25   NTclustered gi|1240412277|gb|KY595973.1| 2030912 g185304 i0 97.333 0.641025641025641 75 2 32 0 160 234 247 321 Penicillium aurantiogriseum partiti-like virus 1 strain MUT4330 segment RNA2 putative coat protein gene, complete cds blastn 150 128 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Penicillium aurantiogriseum partiti-like virus 1
11332706 11332706 PRJNA558770_P_NODE_290309_length_234_cov_1.562814_g288304_i0 PRJNA558770 290309 234 1.562814 3.65698476 Viruses 10239 Viruses Viruses 115 2.64e-21   NTclustered gi|2626079445|gb|OR270332.1| 3063018 g288304 i0 95.775 0.606837606837607 71 3 30 0 164 234 1329 1259 MAG: Crogonang virus 47 isolate CGH03 genomic sequence blastn 142 115 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 47
19669225 19669225 PRJNA558770_P_NODE_74816_length_240_cov_3.243902_g72811_i0 PRJNA558770 74816 240 3.243902 7.7853648 Crogonang virus 58 3063050 Viruses Viruses 89.8 1.65e-13   NTclustered gi|2626079542|gb|OR270365.1| 3063050 g72811 i0 82.828 0.4125 99 17 41 0 1 99 72 170 MAG: Crogonang virus 58 isolate CGH03 genomic sequence blastn 99 89.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 58
26889330 26889330 PRJNA558770_P_NODE_395001_length_160_cov_4.560000_g392996_i0 PRJNA558770 395001 160 4.56 7.296 Marnaviridae sp. 2715102 Viruses Viruses 74.3 8.86e-14   NR XCO48635.1 2715102 g392996 i0 64.7 0.95625 51 18 95.6 0 8 160 1771 1821 XCO48635.1 MAG: putative ORF1 protein [Marnaviridae sp.] diamond 153 74.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
29068530 29068530 PRJNA558770_P_NODE_160488_length_234_cov_5.728643_g158483_i0 PRJNA558770 160488 234 5.728643 13.40502462 Crogonang virus 58 3063050 Viruses Viruses 68.9 2.02e-11   NR WPR18299.1 3063050 g158483 i0 43.4 2.12820512820513 83 42 100 1 1 234 791 873 WPR18299.1 MAG: structural polyprotein, partial [Crogonang virus 58] diamond 498 68.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 58
31880366 31880366 PRJNA558770_P_NODE_161917_length_234_cov_5.643216_g159912_i0 PRJNA558770 161917 234 5.643216 13.20512544 Crogonang virus 58 3063050 Viruses Viruses 55.1 1.55e-6   NR WPR18299.1 3063050 g159912 i0 80 0.320512820512821 25 5 32.1 0 160 234 628 652 WPR18299.1 MAG: structural polyprotein, partial [Crogonang virus 58] diamond 75 55.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 58
32513735 32513735 PRJNA558770_P_NODE_74039_length_241_cov_8.087379_g72034_i0 PRJNA558770 74039 241 8.087379 19.49058339 Crogonang virus 47 3063018 Viruses Viruses 48.5 3.24e-4   NR WPR18235.1 3063018 g72034 i0 84.6 0.647302904564315 26 4 32.4 0 82 5 296 321 WPR18235.1 MAG: RNA-dependent RNA polymerase [Crogonang virus 47] diamond 156 48.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 47
32576818 32576818 PRJNA558770_P_NODE_383819_length_201_cov_2.602410_g381814_i0 PRJNA558770 383819 201 2.60241 5.2308441 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 113 2.57e-27   NR XCM67829.1 3003959 g381814 i0 83.6 0.91044776119403 61 10 91 0 198 16 810 870 XCM67829.1 MAG: structural polyprotein [Picornavirales sp.] diamond 183 113 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3

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