RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA558770" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA558770 · 6 ✖

analysis 1

  • blastn · 6 ✖

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

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