RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where bioproject = "PRJNA508758", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 24 ✖

tax_phylum 1

  • Pisuviricota · 24 ✖

tax_kingdom 1

bioproject 1

  • PRJNA508758 · 24 ✖

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
484372 484372 PRJNA508758_P_NODE_1801_length_1887_cov_6.003308_g1559_i0 PRJNA508758 1801 1887 6.003308 113.28242196 Picornaviridae sp. 1530251 Viruses Viruses 3450 0   NTclustered gi|2245485642|gb|ON161938.1| 1530251 g1559 i0 99.682 1.51033386327504 1886 6 99 0 2 1887 6258 4373 MAG: Picornaviridae sp. isolate 81b-k141_69037_2 RNA dependent RNA polymerase gene, partial cds; and capsid protein gene, complete cds blastn 2850 3450 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
484416 484416 PRJNA508758_P_NODE_21_length_7225_cov_36.531739_g13_i0 PRJNA508758 21 7225 36.531739 2639.41814275 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 2483 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g13 i0 91.812 0.65038062283737 1783 141 65 5 13 1792 7109 5329 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 4699 2483 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
484573 484573 PRJNA508758_P_NODE_3961_length_1258_cov_1.241350_g3461_i0 PRJNA508758 3961 1258 1.24135 15.616183 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 852 0   NTclustered gi|2754691796|gb|PP872666.1| 3003959 g3461 i0 78.985 2.64149443561208 1261 255 99 10 1 1256 4952 6207 MAG: Picornavirales sp. isolate TC-PLV-110 MR233-17E/426 genomic sequence blastn 3323 852 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
1760101 1760101 PRJNA508758_P_NODE_82022_length_245_cov_1.447674_g80974_i0 PRJNA508758 82022 245 1.447674 3.5468013 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 403 5.299999999999998e-108   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g80974 i0 96.327 1 245 9 100 0 1 245 6839 7083 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 245 403 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
8137920 8137920 PRJNA508758_P_NODE_71727_length_254_cov_4.961326_g70679_i0 PRJNA508758 71727 254 4.961326 12.60176804 Dicistroviridae sp. 1955144 Viruses Viruses 464 2.4999999999999994e-126   NTclustered gi|2196304120|gb|MZ679074.1| 1955144 g70679 i0 99.606 4.20866141732283 254 1 100 0 1 254 3958 4211 MAG: Dicistroviridae sp. isolate 165b-k141_223275 hypothetical protein 1 and hypothetical protein 2 genes, partial cds blastn 1069 464 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
11963021 11963021 PRJNA508758_P_NODE_10490_length_661_cov_2.469388_g9514_i0 PRJNA508758 10490 661 2.469388 16.32265468 Picornaviridae sp. 1530251 Viruses Viruses 1192 0   NTclustered gi|2245485642|gb|ON161938.1| 1530251 g9514 i0 99.242 9.1482602118003 660 5 99 0 2 661 3932 3273 MAG: Picornaviridae sp. isolate 81b-k141_69037_2 RNA dependent RNA polymerase gene, partial cds; and capsid protein gene, complete cds blastn 6047 1192 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
15138730 15138730 PRJNA508758_P_NODE_83512_length_244_cov_1.350877_g82464_i0 PRJNA508758 83512 244 1.350877 3.29613988 Picornavirales 464095 Viruses Viruses 446 8.639999999999999e-121   NTclustered gi|2245485642|gb|ON161938.1| 1530251 g82464 i0 99.59 6 244 1 100 0 1 244 1967 1724 MAG: Picornaviridae sp. isolate 81b-k141_69037_2 RNA dependent RNA polymerase gene, partial cds; and capsid protein gene, complete cds blastn 1464 446 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
17061687 17061687 PRJNA508758_P_NODE_14_length_8150_cov_10.687879_g7_i0 PRJNA508758 14 8150 10.687879 871.0621385 Zebrafish picornavirus 1 2304617 Viruses Viruses 13319 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g7 i0 96.162 3.04208588957055 8156 304 100 6 1 8150 8175 23 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 24793 13319 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
17062156 17062156 PRJNA508758_P_NODE_70214_length_257_cov_2.510870_g69166_i0 PRJNA508758 70214 257 2.51087 6.4529359 Zebrafish picornavirus 1 2304617 Viruses Viruses 448 2.5499999999999995e-121   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g69166 i0 98.054 3 257 5 100 0 1 257 4704 4448 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 771 448 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
18336375 18336375 PRJNA508758_P_NODE_5375_length_1048_cov_2.548718_g4655_i0 PRJNA508758 5375 1048 2.548718 26.71056464 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 656 1.51e-213   NR UNY42028.1 3003959 g4655 i0 93.4 1.99809160305344 349 23 99.9 0 1 1047 1820 2168 UNY42028.1 MAG: polyprotein [Picornavirales sp.] diamond 2094 656 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
21512587 21512587 PRJNA508758_P_NODE_30477_length_368_cov_1.793220_g29429_i0 PRJNA508758 30477 368 1.79322 6.5990496 Picornavirales 464095 Viruses Viruses 658 0   NTclustered gi|2245485642|gb|ON161938.1| 1530251 g29429 i0 98.913 5.51630434782609 368 4 100 0 1 368 1232 1599 MAG: Picornaviridae sp. isolate 81b-k141_69037_2 RNA dependent RNA polymerase gene, partial cds; and capsid protein gene, complete cds blastn 2030 658 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
23437005 23437005 PRJNA508758_P_NODE_3579_length_1334_cov_3.076923_g3123_i0 PRJNA508758 3579 1334 3.076923 41.04615282 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 1003 0   NTclustered gi|2214231615|gb|OM622294.1| 3003959 g3123 i0 80.27 0.999250374812594 1333 261 99 2 1 1332 7368 8699 MAG: Picornavirales sp. isolate HPLV-39 genomic sequence blastn 1333 1003 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
23437127 23437127 PRJNA508758_P_NODE_5399_length_1044_cov_7.892894_g7_i1 PRJNA508758 5399 1044 7.892894 82.40181336 Zebrafish picornavirus 1 2304617 Viruses Viruses 1797 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g7 i1 97.708 3.37164750957854 1047 21 100 1 1 1044 8175 7129 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 3520 1797 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
24710575 24710575 PRJNA508758_P_NODE_41460_length_324_cov_1.932271_g40412_i0 PRJNA508758 41460 324 1.932271 6.26055804 Freshwater macrophyte associated picorna-like virus 1 2946039 Viruses Viruses 521 1.9299999999999993e-143   NTclustered gi|2242598914|gb|ON125119.1| 2946039 g40412 i0 95.679 1 324 14 100 0 1 324 9416 9739 Freshwater macrophyte associated picorna-like virus 1 isolate P-N1_1, complete genome blastn 324 521 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Freshwater macrophyte associated picorna-like virus 1
27645989 27645989 PRJNA508758_P_NODE_15044_length_528_cov_1.015385_g14013_i0 PRJNA508758 15044 528 1.015385 5.3612328 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 191 1.74e-52   NR UNY42028.1 3003959 g14013 i0 57.8 2.04545454545455 180 71 100 3 1 528 1917 2095 UNY42028.1 MAG: polyprotein [Picornavirales sp.] diamond 1080 191 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28103089 28103089 PRJNA508758_P_NODE_51525_length_296_cov_1.381166_g50477_i0 PRJNA508758 51525 296 1.381166 4.08825136 Picornavirales 464095 Viruses Viruses 101 1.99e-22   NR UNY42173.1 1955153 g50477 i0 49 4.83445945945946 96 49 97.3 0 295 8 1297 1392 UNY42173.1 MAG: polyprotein, partial [Picornavirales sp.] diamond 1431 102 0.990196078431373 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Picornavirales sp.
28119341 28119341 PRJNA508758_P_NODE_57765_length_282_cov_1.827751_g56717_i0 PRJNA508758 57765 282 1.827751 5.15425782 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 176 8e-49   NR UNY42028.1 3003959 g56717 i0 88.2 0.98936170212766 93 11 98.9 0 281 3 223 315 UNY42028.1 MAG: polyprotein [Picornavirales sp.] diamond 279 176 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28593105 28593105 PRJNA508758_P_NODE_36127_length_343_cov_1.140741_g35079_i0 PRJNA508758 36127 343 1.140741 3.91274163 Flumine Astrovirus 22 2940951 Viruses Viruses 148 2.62e-41   NR UQB75984.1 2940951 g35079 i0 67.5 0.997084548104956 114 37 99.7 0 1 342 93 206 UQB75984.1 RNA-dependent RNA polymerase [Flumine Astrovirus 22] diamond 342 148 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Flumine Astrovirus 22
28656249 28656249 PRJNA508758_P_NODE_29207_length_375_cov_1.274834_g28159_i0 PRJNA508758 29207 375 1.274834 4.7806275 Stellavirales sp. 2809883 Viruses Viruses 179 2.23e-49   NR WAY16553.1 2809883 g28159 i0 70.2 0.992 124 37 99.2 0 374 3 873 996 WAY16553.1 RNA-dependent RNA polymerase, partial [Stellavirales sp.] diamond 372 179 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales     Stellavirales sp.
28940507 28940507 PRJNA508758_P_NODE_10628_length_655_cov_2.192440_g9649_i0 PRJNA508758 10628 655 2.19244 14.360482 Stellavirales sp. 2809883 Viruses Viruses 225 4.26e-64   NR WAY16553.1 2809883 g9649 i0 54.8 0.993893129770992 217 95 99.4 1 653 3 594 807 WAY16553.1 RNA-dependent RNA polymerase, partial [Stellavirales sp.] diamond 651 225 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales     Stellavirales sp.
29413826 29413826 PRJNA508758_P_NODE_16889_length_494_cov_1.463183_g15842_i0 PRJNA508758 16889 494 1.463183 7.22812402 Qianjiang marna-like virus 162 3347588 Viruses Viruses 95.5 2.41e-19   NR XHA88335.1 3347588 g15842 i0 47.9 0.582995951417004 96 49 57.7 1 290 6 1092 1187 XHA88335.1 MAG: polyprotein [Qianjiang marna-like virus 162] diamond 288 95.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Qianjiang marna-like virus 162
30171848 30171848 PRJNA508758_P_NODE_67992_length_262_cov_1.296296_g66944_i0 PRJNA508758 67992 262 1.296296 3.39629552 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 142 5.99e-37   NR XCM68434.1 3003959 g66944 i0 74.7 0.950381679389313 83 21 95 0 250 2 615 697 XCM68434.1 MAG: structural polyprotein [Picornavirales sp.] diamond 249 142 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32416838 32416838 PRJNA508758_P_NODE_88359_length_241_cov_0.916667_g87311_i0 PRJNA508758 88359 241 0.916667 2.20916747 Zebrafish gut calicivirus RQ08 Viruses Viruses 120 1.2299999999999998e-29   NR DAZ91097.1 RQ08 g87311 i0 62.5 0.995850622406639 80 30 99.6 0 241 2 1792 1871 DAZ91097.1 TPA_asm: nonstructural protein, partial [Newt calicivirus] diamond 240 120 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
32732415 32732415 PRJNA508758_P_NODE_42640_length_321_cov_0.931452_g41592_i0 PRJNA508758 42640 321 0.931452 2.98996092 Zebrafish jaw picornavirus RQ13 Viruses Viruses 58.5 2.73e-7   NR YP_009552756.1 RQ13 g41592 i0 38.9 1.00934579439252 108 61 97.2 3 313 2 1707 1813 YP_009552756.1 polyprotein [Rhimavirus A] diamond 324 58.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish jaw picornavirus

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