RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA534016" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 32 ✖

bioproject 1

  • PRJNA534016 · 32 ✖

analysis 1

  • diamond · 32 ✖

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
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
26856560 26856560 PRJNA534016_P_NODE_19161_length_226_cov_2.771242_g19071_i0 PRJNA534016 19161 226 2.771242 6.26300692 Caudoviricetes sp. 2832643 Viruses Viruses 70.5 5.18e-12   NR XOR60197.1 2832643 g19071 i0 45.2 2.77433628318584 73 39 96.9 1 219 1 843 914 XOR60197.1 MAG: ATP-dependent DNA helicase uvsW [Caudoviricetes sp.] diamond 627 70.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
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
28499139 28499139 PRJNA534016_P_NODE_18987_length_230_cov_2.522293_g18897_i0 PRJNA534016 18987 230 2.522293 5.8012739 Cafeteria roenbergensis virus BV-PW1 693272 Viruses Viruses 44.7 8.75e-4   NR YP_003970049.1 693272 g18897 i0 68 0.639130434782609 25 8 32.6 0 224 150 51 75 YP_003970049.1 hypothetical protein crov416 [Cafeteria roenbergensis virus BV-PW1] diamond 147 44.7 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Rheavirus Rheavirus sinusmexicani
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
30077639 30077639 PRJNA534016_P_NODE_19132_length_226_cov_6.751634_g19042_i0 PRJNA534016 19132 226 6.751634 15.25869284 Pseudomonas phage Rollin 3079657 Viruses Viruses 87.4 1.05e-20   NR WNV50608.1 3079657 g19042 i0 71 0.823008849557522 62 18 82.3 0 28 213 11 72 WNV50608.1 hypothetical protein [Pseudomonas phage Rollin] diamond 186 87.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage Rollin
30077640 30077640 PRJNA534016_P_NODE_232_length_1527_cov_4.678817_g204_i0 PRJNA534016 232 1527 4.678817 71.44553559 Paramecium bursaria Chlorella virus NE-JV-1 1278261 Viruses Viruses 79.7 2.14e-12   NR AGE56284.1 1278261 g204 i0 28.4 0.408644400785855 208 124 39.1 7 925 1521 94 285 AGE56284.1 serine/threonine-protein kinase [Paramecium bursaria Chlorella virus NE-JV-1] diamond 624 79.7 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Algavirales Phycodnaviridae Chlorovirus Paramecium bursaria Chlorella virus NE-JV-1
30867609 30867609 PRJNA534016_P_NODE_4634_length_384_cov_1.897106_g4544_i0 PRJNA534016 4634 384 1.897106 7.28488704 Caudoviricetes sp. 2832643 Viruses Viruses 150 9.879999999999999e-43   NR XOR95715.1 2832643 g4544 i0 88.8 0.625 80 9 62.5 0 145 384 3 82 XOR95715.1 MAG: minor tail protein [Caudoviricetes sp.] diamond 240 150 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30994143 30994143 PRJNA534016_P_NODE_7514_length_309_cov_2.042373_g7424_i0 PRJNA534016 7514 309 2.042373 6.31093257 Caudoviricetes sp. 2832643 Viruses Viruses 53.9 5.81e-6   NR XOR43833.1 2832643 g7424 i0 33 1.90291262135922 103 66 99 3 307 2 12 112 XOR43833.1 MAG: P23 [Caudoviricetes sp.] diamond 588 53.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31009000 31009000 PRJNA534016_P_NODE_16274_length_245_cov_1.779070_g16184_i0 PRJNA534016 16274 245 1.77907 4.3587215 Viruses 10239 Viruses Viruses 95.9 7.720000000000001e-21   NR YP_009337256.1 1923120 g16184 i0 53.8 2.87755102040816 78 36 95.5 0 7 240 331 408 YP_009337256.1 hypothetical protein 1 [Hubei picorna-like virus 4] diamond 705 95.9 1 Viruses               Hubei picorna-like virus 4
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
32242789 32242789 PRJNA534016_P_NODE_6198_length_337_cov_1.458333_g6108_i0 PRJNA534016 6198 337 1.458333 4.91458221 Narnavirus 186767 Viruses Viruses 128 4.41e-33   NR WWV90548.1 2585031 g6108 i0 56.6 3.00890207715134 113 45 97.9 2 4 333 176 287 WWV90548.1 MAG: RNA polymerase, partial [Riboviria sp.] diamond 1014 129 0.992248062015504 Viruses               Riboviria sp.
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.
32544154 32544154 PRJNA534016_P_NODE_11039_length_271_cov_1.232323_g10949_i0 PRJNA534016 11039 271 1.232323 3.33959533 Erwinia phage pEa_SNUABM_49 2859284 Viruses Viruses 53.1 1.2e-6   NR QXO12696.1 2859284 g10949 i0 37.5 0.797047970479705 72 42 77.5 2 11 220 2 72 QXO12696.1 hypothetical protein pEaSNUABM49_00464 [Erwinia phage pEa_SNUABM_49] diamond 216 53.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Eneladusvirus Eneladusvirus BF
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);;