RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where bioproject = "PRJNA534016" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

analysis 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 26 ✖

bioproject 1

  • PRJNA534016 · 26 ✖

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
507582 507582 PRJNA534016_P_NODE_1_length_9955_cov_165.904270_g0_i0 PRJNA534016 1 9955 165.90427 16515.7700785 Freshwater macrophyte associated picorna-like virus 1 2946039 Viruses Viruses 14224 0   NTclustered gi|2242598914|gb|ON125119.1| 2946039 g0 i0 92.576 1.67011551983928 9914 728 99 8 41 9948 9964 53 Freshwater macrophyte associated picorna-like virus 1 isolate P-N1_1, complete genome blastn 16626 14224 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Freshwater macrophyte associated picorna-like virus 1
1782919 1782919 PRJNA534016_P_NODE_2_length_7203_cov_16.246704_g1_i0 PRJNA534016 2 7203 16.246704 1170.25008912 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 2532 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g1 i0 92.316 0.667221990837151 1783 132 67 5 5421 7201 5329 7108 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 4806 2532 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
8160293 8160293 PRJNA534016_P_NODE_18447_length_241_cov_0.916667_g18357_i0 PRJNA534016 18447 241 0.916667 2.20916747 Zebrafish picornavirus 1 2304617 Viruses Viruses 372 1.47e-98   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g18357 i0 94.583 2.98755186721992 240 13 99 0 1 240 4049 4288 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 720 372 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
26824792 26824792 PRJNA534016_P_NODE_3481_length_438_cov_2.520548_g3391_i0 PRJNA534016 3481 438 2.520548 11.04000024 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 53.5 5.44e-5   NR UNY41972.1 3003959 g3391 i0 29.3 0.910958904109589 133 81 89 3 401 12 3041 3163 UNY41972.1 MAG: polyprotein [Picornavirales sp.] diamond 399 53.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27077803 27077803 PRJNA534016_P_NODE_1062_length_802_cov_2.296296_g985_i0 PRJNA534016 1062 802 2.296296 18.41629392 Zebrafish gut calicivirus RQ08 Viruses Viruses 143 1.24e-34   NR XBS25272.1 RQ08 g985 i0 31.3 1.12219451371571 300 158 96.1 10 24 794 739 1033 XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] diamond 900 143 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
27235823 27235823 PRJNA534016_P_NODE_1803_length_608_cov_1.390654_g1716_i0 PRJNA534016 1803 608 1.390654 8.45517632 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 48.1 0.014   NR XCM68002.1 3003959 g1716 i0 50 0.1875 38 19 18.8 0 116 3 1 38 XCM68002.1 MAG: polyprotein [Picornavirales sp.] diamond 114 48.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27267423 27267423 PRJNA534016_P_NODE_163_length_1726_cov_3.079250_g142_i0 PRJNA534016 163 1726 3.07925 53.147855 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 824 3.69e-273   NR XCM68002.1 3003959 g142 i0 70.5 0.995944380069525 573 166 99.6 2 6 1724 1455 2024 XCM68002.1 MAG: polyprotein [Picornavirales sp.] diamond 1719 824 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27488656 27488656 PRJNA534016_P_NODE_9643_length_282_cov_1.200957_g9553_i0 PRJNA534016 9643 282 1.200957 3.38669874 Durnavirales sp. 2809355 Viruses Viruses 86.3 2.73e-17   NR WRQ64726.1 2809355 g9553 i0 56.8 0.787234042553192 74 32 78.7 0 282 61 367 440 WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.] diamond 222 86.3 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales     Durnavirales sp.
27646673 27646673 PRJNA534016_P_NODE_824_length_912_cov_1.700834_g750_i0 PRJNA534016 824 912 1.700834 15.51160608 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 273 3.61e-79   NR XCM68002.1 3003959 g750 i0 62.7 0.697368421052632 212 79 69.7 0 644 9 652 863 XCM68002.1 MAG: polyprotein [Picornavirales sp.] diamond 636 273 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27835791 27835791 PRJNA534016_P_NODE_424_length_1231_cov_5.780656_g373_i0 PRJNA534016 424 1231 5.780656 71.15987536 Narnavirus sp. 2587225 Viruses Viruses 65.1 1.58e-8   NR CAK8705411.1 2587225 g373 i0 34.4 0.731112916328188 128 73 30.7 3 91 468 4 122 CAK8705411.1 uncharacterized [Narnavirus sp.] diamond 900 65.1 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae Narnavirus Narnavirus sp.
28246156 28246156 PRJNA534016_P_NODE_1366_length_704_cov_1.855784_g1282_i0 PRJNA534016 1366 704 1.855784 13.06471936 Zebrafish gut calicivirus RQ08 Viruses Viruses 70.1 1.02e-9   NR AVM87224.1 RQ08 g1282 i0 33.3 0.613636363636364 144 83 57.1 5 1 402 43 183 AVM87224.1 polyprotein [Fujian spotted paddle-tail newt calicivirus] diamond 432 70.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
28877740 28877740 PRJNA534016_P_NODE_3088_length_465_cov_1.372449_g2998_i0 PRJNA534016 3088 465 1.372449 6.38188785 Zebrafish gut calicivirus RQ08 Viruses Viruses 113 8.250000000000001e-26   NR AVM87212.1 RQ08 g2998 i0 36.8 2.94193548387097 152 96 98.1 0 5 460 351 502 AVM87212.1 polyprotein [Dongbei arctic lamprey calicivirus 2] diamond 1368 113 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
28941230 28941230 PRJNA534016_P_NODE_2528_length_515_cov_2.773756_g2438_i0 PRJNA534016 2528 515 2.773756 14.2848434 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 281 3.49e-84   NR XCM68002.1 3003959 g2438 i0 79.5 0.996116504854369 171 35 99.6 0 513 1 38 208 XCM68002.1 MAG: polyprotein [Picornavirales sp.] diamond 513 281 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29572347 29572347 PRJNA534016_P_NODE_6030_length_341_cov_0.929104_g5940_i0 PRJNA534016 6030 341 0.929104 3.16824464 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 200 5.999999999999999e-57   NR XCM68002.1 3003959 g5940 i0 79.6 0.994134897360704 113 23 99.4 0 1 339 273 385 XCM68002.1 MAG: polyprotein [Picornavirales sp.] diamond 339 200 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29587094 29587094 PRJNA534016_P_NODE_4030_length_410_cov_1.551929_g3940_i0 PRJNA534016 4030 410 1.551929 6.3629089 Picornavirales 464095 Viruses Viruses 159 4.6e-42   NR URG14823.1 1530251 g3940 i0 63.5 3 137 48 98.8 1 3 407 311 447 URG14823.1 MAG: capsid protein [Picornaviridae sp.] diamond 1230 160 0.99375 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
29698366 29698366 PRJNA534016_P_NODE_10_length_3983_cov_5.904859_g6_i0 PRJNA534016 10 3983 5.904859 235.19053397 Zebrafish gut calicivirus RQ08 Viruses Viruses 976 0   NR XBS25272.1 RQ08 g6 i0 45.7 0.866934471503892 1151 592 85.5 15 8 3412 1070 2203 XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] diamond 3453 976 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
29920004 29920004 PRJNA534016_P_NODE_6291_length_335_cov_1.416031_g6201_i0 PRJNA534016 6291 335 1.416031 4.74370385 Hemiptera picorna-like virus 3066417 Viruses Viruses 69.7 3.94e-11   NR WPR17520.1 3066417 g6201 i0 38.5 0.814925373134328 91 55 81.5 1 334 62 1926 2015 WPR17520.1 MAG: RNA-dependent RNA polymerase, partial [Hemiptera picorna-like virus] diamond 273 69.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Hemiptera picorna-like virus
31373537 31373537 PRJNA534016_P_NODE_16116_length_246_cov_0.890173_g16026_i0 PRJNA534016 16116 246 0.890173 2.18982558 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 55.5 1.34e-6   NR XCM68141.1 3003959 g16026 i0 31.7 2.89024390243902 82 54 97.6 2 246 7 292 373 XCM68141.1 MAG: polyprotein, partial [Picornavirales sp.] diamond 711 55.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31689606 31689606 PRJNA534016_P_NODE_757_length_948_cov_3.513143_g685_i0 PRJNA534016 757 948 3.513143 33.30459564 Hemiptera picorna-like virus 3066417 Viruses Viruses 83.2 1.64e-13   NR WPR17521.1 3066417 g685 i0 28.3 0.882911392405063 279 168 81.3 9 3 773 678 946 WPR17521.1 MAG: capsid protein [Hemiptera picorna-like virus] diamond 837 83.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Hemiptera picorna-like virus
31942542 31942542 PRJNA534016_P_NODE_3337_length_446_cov_3.798928_g3247_i0 PRJNA534016 3337 446 3.798928 16.94321888 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 243 2.87e-71   NR XCM68002.1 3003959 g3247 i0 78.4 0.995515695067265 148 32 99.6 0 2 445 372 519 XCM68002.1 MAG: polyprotein [Picornavirales sp.] diamond 444 243 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32006100 32006100 PRJNA534016_P_NODE_718_length_968_cov_2.803352_g646_i0 PRJNA534016 718 968 2.803352 27.13644736 Zebrafish gut calicivirus RQ08 Viruses Viruses 260 1.81e-74   NR AVM87226.1 RQ08 g646 i0 44.7 0.963842975206612 311 167 95.8 4 964 38 92 399 AVM87226.1 polyprotein [Zhejiang gunthers frog calicivirus 1] diamond 933 260 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
32385744 32385744 PRJNA534016_P_NODE_4779_length_378_cov_2.268852_g4689_i0 PRJNA534016 4779 378 2.268852 8.57626056 Hemiptera picorna-like virus 3066417 Viruses Viruses 64.7 3.64e-9   NR WPR17521.1 3066417 g4689 i0 32.6 1.02380952380952 129 74 92.1 4 4 351 407 535 WPR17521.1 MAG: capsid protein [Hemiptera picorna-like virus] diamond 387 64.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Hemiptera picorna-like virus
32527520 32527520 PRJNA534016_P_NODE_16279_length_245_cov_1.755814_g16189_i0 PRJNA534016 16279 245 1.755814 4.3017443 Viruses 10239 Viruses Viruses 52.8 1.13e-5   NR URG14823.1 1530251 g16189 i0 56.1 1.00408163265306 41 18 50.2 0 243 121 835 875 URG14823.1 MAG: capsid protein [Picornaviridae sp.] diamond 246 53.1 0.994350282485876 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
32606981 32606981 PRJNA534016_P_NODE_15140_length_248_cov_0.880000_g15050_i0 PRJNA534016 15140 248 0.88 2.1824 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 68.2 4.43e-11   NR XCM67689.1 3003959 g15050 i0 39.8 1.06451612903226 88 44 96.8 3 247 8 817 903 XCM67689.1 MAG: structural polyprotein [Picornavirales sp.] diamond 264 68.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32638214 32638214 PRJNA534016_P_NODE_460_length_1188_cov_1.612556_g406_i0 PRJNA534016 460 1188 1.612556 19.15716528 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 623 3.91e-201   NR XCM68002.1 3003959 g406 i0 79.2 0.946969696969697 375 78 94.7 0 1 1125 952 1326 XCM68002.1 MAG: polyprotein [Picornavirales sp.] diamond 1125 623 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32827455 32827455 PRJNA534016_P_NODE_320_length_1358_cov_3.355642_g280_i0 PRJNA534016 320 1358 3.355642 45.56961836 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 671 4.649999999999998e-218   NR XCM68002.1 3003959 g280 i0 74.7 0.949926362297496 430 101 93.7 2 1356 85 2048 2475 XCM68002.1 MAG: polyprotein [Picornavirales sp.] diamond 1290 671 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);;