RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA400391" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA400391 · 14 ✖

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
5517760 5517760 PRJNA400391_S_NODE_1405_length_318_cov_1.332155_g1344_i0 PRJNA400391 1405 318 1.332155 4.2362529 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 124 6.2299999999999996e-24   NTclustered gi|1698237878|gb|MN034986.1| 3003959 g1344 i0 97.26 1.65723270440252 73 2 23 0 246 318 79 7 MAG: Picornavirales sp. isolate H1_Bulk_30_scaffold_9721 sequence blastn 527 124 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28054463 28054463 PRJNA400391_S_NODE_5905_length_161_cov_6.095238_g5844_i0 PRJNA400391 5905 161 6.095238 9.81333318 Salisharnavirus sp. 2809832 Viruses Viruses 55.8 2.91e-7   NR ULG00117.1 2809832 g5844 i0 51 1.82608695652174 51 25 95 0 2 154 1322 1372 ULG00117.1 MAG: hypothetical protein, partial [Salisharnavirus sp.] diamond 294 55.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae Salisharnavirus Salisharnavirus sp.
28639803 28639803 PRJNA400391_S_NODE_6067_length_159_cov_1.645161_g6006_i0 PRJNA400391 6067 159 1.645161 2.61580599 Sogarnavirus 2560230 Viruses Viruses 45.4 0.00132   NR YP_009666859.1 2315692 g6006 i0 42.9 2.9622641509434 49 27 90.6 1 2 145 475 523 YP_009666859.1 structural polyprotein, partial [Marine RNA virus BC-2] diamond 471 45.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae Sogarnavirus Sogarnavirus gustavseniae
28970233 28970233 PRJNA400391_S_NODE_2988_length_233_cov_2.186869_g2927_i0 PRJNA400391 2988 233 2.186869 5.09540477 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 78.2 1.08e-14   NR XCM67851.1 3003959 g2927 i0 52.1 0.939914163090129 73 35 94 0 10 228 426 498 XCM67851.1 MAG: structural polyprotein [Picornavirales sp.] diamond 219 78.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29208119 29208119 PRJNA400391_S_NODE_4889_length_180_cov_2.565517_g4828_i0 PRJNA400391 4889 180 2.565517 4.6179306 Viruses 10239 Viruses Viruses 50.8 2.2e-5   NR UNY42071.1 1955153 g4828 i0 39.3 3.73333333333333 56 33 91.7 1 170 6 624 679 UNY42071.1 MAG: polyprotein 2 [Picornavirales sp.] diamond 672 50.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Picornavirales sp.
29475077 29475077 PRJNA400391_S_NODE_6230_length_157_cov_1.221311_g6169_i0 PRJNA400391 6230 157 1.221311 1.91745827 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 49.7 4.19e-5   NR XCM68013.1 3003959 g6169 i0 68.4 0.726114649681529 38 12 72.6 0 150 37 1686 1723 XCM68013.1 MAG: polyprotein, partial [Picornavirales sp.] diamond 114 49.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29555054 29555054 PRJNA400391_S_NODE_2770_length_241_cov_1.679612_g2709_i0 PRJNA400391 2770 241 1.679612 4.04786492 Viruses 10239 Viruses Viruses 55.8 9.05e-7   NR WAQ80625.1 3003958 g2709 i0 41.4 1.6804979253112 70 40 87.1 1 25 234 1053 1121 WAQ80625.1 MAG: hypothetical protein [Fish-associated picorna-like virus 2] diamond 405 55.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 2
29601372 29601372 PRJNA400391_S_NODE_870_length_371_cov_3.553571_g809_i0 PRJNA400391 870 371 3.553571 13.18374841 Picornaviridae sp. 1530251 Viruses Viruses 109 6.53e-26   NR URG14382.1 1530251 g809 i0 46.3 0.978436657681941 121 63 97 2 5 364 163 282 URG14382.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 363 109 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
29632855 29632855 PRJNA400391_S_NODE_4610_length_186_cov_1.847682_g4549_i0 PRJNA400391 4610 186 1.847682 3.43668852 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 84.7 2.77e-17   NR UNY42033.1 3003959 g4549 i0 54.1 0.983870967741935 61 28 98.4 0 3 185 1054 1114 UNY42033.1 MAG: polyprotein [Picornavirales sp.] diamond 183 84.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29744437 29744437 PRJNA400391_S_NODE_3310_length_221_cov_2.333333_g3249_i0 PRJNA400391 3310 221 2.333333 5.15666593 Sogarnavirus 2560230 Viruses Viruses 76.6 3.23e-14   NR YP_010084314.1 1045800 g3249 i0 48.6 4.81900452488688 70 36 95 0 6 215 431 500 YP_010084314.1 putative replication related protein [Chaetoceros species RNA virus 02] diamond 1065 77 0.994805194805195 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae Sogarnavirus Sogarnavirus tomaruii
30960164 30960164 PRJNA400391_S_NODE_5634_length_166_cov_2.083969_g5573_i0 PRJNA400391 5634 166 2.083969 3.45938854 Crogonang virus 121 3062991 Viruses Viruses 79.7 1.17e-15   NR WPR18179.1 3062991 g5573 i0 67.3 0.939759036144578 52 17 94 0 164 9 1207 1258 WPR18179.1 MAG: capsid protein, partial [Crogonang virus 121] diamond 156 79.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 121
31655496 31655496 PRJNA400391_S_NODE_6617_length_151_cov_1.034483_g6556_i0 PRJNA400391 6617 151 1.034483 1.56206933 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 85.9 6.69e-18   NR XNT21102.1 3003959 g6556 i0 80 0.993377483443709 50 10 99.3 0 2 151 1676 1725 XNT21102.1 MAG: polyprotein [Picornavirales sp.] diamond 150 85.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32193575 32193575 PRJNA400391_S_NODE_3498_length_215_cov_2.138889_g3437_i0 PRJNA400391 3498 215 2.138889 4.59861135 Macrobrachium rosenbergii virus 5 2971790 Viruses Viruses 67.4 5.31e-11   NR UUV42145.1 2971790 g3437 i0 41.8 1.10232558139535 79 37 97.7 2 5 214 418 496 UUV42145.1 MAG: nonstructural protein [Macrobrachium rosenbergii virus 5] diamond 237 67.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae Sogarnavirus Macrobrachium rosenbergii virus 5
32762081 32762081 PRJNA400391_S_NODE_3160_length_226_cov_3.842932_g3099_i0 PRJNA400391 3160 226 3.842932 8.68502632 Qianjiang marna-like virus 58 3347705 Viruses Viruses 70.9 3.72e-12   NR XHA88150.1 3347705 g3099 i0 46.8 1.02212389380531 77 37 98.2 2 222 1 231 306 XHA88150.1 MAG: putative viral coat protein, partial [Qianjiang marna-like virus 58] diamond 231 70.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Qianjiang marna-like 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);;