RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where bioproject = "PRJNA911178", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 10 ✖

tax_phylum 1

  • Pisuviricota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA911178 · 10 ✖

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
3443795 3443795 PRJNA911178_P_NODE_303003_length_230_cov_2.197452_g300529_i0 PRJNA911178 303003 230 2.197452 5.0541396 Polerovirus CABYV 3431733 Viruses Viruses 403 4.92e-108   NTclustered gi|388325686|gb|JF939813.1| 91753 g300529 i0 99.548 93.6913043478261 221 1 96 0 1 221 3161 2941 Cucurbit aphid-borne yellows virus strain Sq/2005/9.2, complete genome blastn 21549 403 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae Polerovirus Polerovirus CABYV
4720749 4720749 PRJNA911178_P_NODE_214104_length_264_cov_1.492147_g211630_i0 PRJNA911178 214104 264 1.492147 3.93926808 Polerovirus CABYV 3431733 Viruses Viruses 466 7.27e-127   NTclustered gi|388325686|gb|JF939813.1| 91753 g211630 i0 99.225 75.9242424242424 258 2 98 0 7 264 4279 4536 Cucurbit aphid-borne yellows virus strain Sq/2005/9.2, complete genome blastn 20044 466 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae Polerovirus Polerovirus CABYV
7269900 7269900 PRJNA911178_P_NODE_153646_length_301_cov_451.934211_g151173_i0 PRJNA911178 153646 301 451.934211 1360.32197511 Qianjiang marna-like virus 21 3347640 Viruses Viruses 350 8.87e-92   NTclustered gi|2806503321|gb|PQ055080.1| 3347640 g151173 i0 89.531 28.9800664451827 277 28 92 1 15 291 636 361 MAG: Qianjiang marna-like virus 21 isolate QJ5MS697 genomic sequence blastn 8723 350 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Qianjiang marna-like virus 21
9820532 9820532 PRJNA911178_P_NODE_261668_length_247_cov_0.885057_g259194_i0 PRJNA911178 261668 247 0.885057 2.18609079 Potyvirus plumpoxi 3240600 Viruses Viruses 448 2.4399999999999993e-121   NTclustered gi|294313|gb|M92280.1|PPVPOLPRO 12211 g259194 i0 99.592 99.1902834008097 245 1 99 0 3 247 7503 7747 Plum pox virus strain M isolate SK 68, complete genome blastn 24500 448 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus plumpoxi
15278746 15278746 PRJNA911178_P_NODE_89812_length_378_cov_1.396721_g87342_i0 PRJNA911178 89812 378 1.396721 5.27960538 Mamastrovirus 249588 Viruses Viruses 52.8 0.036   NTclustered gi|2618184178|gb|OR711901.1| 1914442 g87342 i0 100 0.148148148148148 28 0 7 0 115 142 4050 4023 Rodent astrovirus strain CHN/YN/KM-5/2022, complete genome blastn 56 52.8 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae Mamastrovirus Rodent astrovirus
22568426 22568426 PRJNA911178_P_NODE_108818_length_349_cov_1.068841_g106346_i0 PRJNA911178 108818 349 1.068841 3.73025509 Locarnavirus sp. 2809529 Viruses Viruses 145 5.2899999999999995e-30   NTclustered gi|2196309124|gb|MZ679257.1| 2809529 g106346 i0 93 0.286532951289398 100 5 28 2 54 152 9101 9003 MAG: Locarnavirus sp. isolate s79-k141_884721 RNA-dependent RNA polymerase and structural polyprotein genes, complete cds blastn 100 145 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae Locarnavirus Locarnavirus sp.
25118370 25118370 PRJNA911178_P_NODE_221820_length_260_cov_1.502674_g219346_i0 PRJNA911178 221820 260 1.502674 3.9069524 Potyvirus plumpoxi 3240600 Viruses Viruses 472 1.53e-128   NTclustered gi|2235068481|gb|MW415764.1| 12211 g219346 i0 100 98.0538461538462 255 0 98 0 6 260 1651 1905 Plum pox virus strain Marcus isolate BrMrPc10 polyprotein gene, complete cds blastn 25494 472 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus plumpoxi
25118654 25118654 PRJNA911178_P_NODE_253840_length_248_cov_2.080000_g251366_i0 PRJNA911178 253840 248 2.08 5.1584 Polerovirus CABYV 3431733 Viruses Viruses 435 1.91e-117   NTclustered gi|388325686|gb|JF939813.1| 91753 g251366 i0 98.77 48.2338709677419 244 3 98 0 1 244 1375 1132 Cucurbit aphid-borne yellows virus strain Sq/2005/9.2, complete genome blastn 11962 435 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae Polerovirus Polerovirus CABYV
29298219 29298219 PRJNA911178_P_NODE_246949_length_250_cov_0.870056_g244475_i0 PRJNA911178 246949 250 0.870056 2.17514 Partitiviridae sp. 1955170 Viruses Viruses 50.1 1.06e-4   NR WWV86494.1 1955170 g244475 i0 44.4 0.648 54 30 64.8 0 235 74 433 486 WWV86494.1 MAG: hypothetical protein, partial [Partitiviridae sp.] diamond 162 50.1 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Partitiviridae sp.
32237763 32237763 PRJNA911178_P_NODE_272058_length_245_cov_0.895349_g269584_i0 PRJNA911178 272058 245 0.895349 2.19360505 Qianjiang picorna-like virus 55 3348782 Viruses Viruses 69.3 1.69e-11   NR XHA88525.1 3348782 g269584 i0 40.7 0.991836734693878 81 48 99.2 0 2 244 1404 1484 XHA88525.1 MAG: polyprotein [Qianjiang picorna-like virus 55] diamond 243 69.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 55

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