RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where analysis = "diamond", bioproject = "PRJNA1199330" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 33 ✖

bioproject 1

  • PRJNA1199330 · 33 ✖

analysis 1

  • diamond · 33 ✖

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
1600533 1600533 PRJNA1199330_P_NODE_6202_length_856_cov_3.197957_g5646_i0 PRJNA1199330 6202 856 3.197957 27.37451192 Perth bee virus 4 2201298 Viruses Viruses 459 9.369999999999999e-148   NR AWK77898.1 2201298 g5646 i0 75.7 0.995327102803738 284 69 99.5 0 3 854 1137 1420 AWK77898.1 nonstructural polyprotein, partial [Perth bee virus 4] diamond 852 459 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Perth bee virus 4
6703863 6703863 PRJNA1199330_P_NODE_7546_length_769_cov_1.859195_g6946_i0 PRJNA1199330 7546 769 1.859195 14.29720955 Murine astrovirus 2 2171380 Viruses Viruses 439 2.02e-146   NR AWB14570.1 2171380 g6946 i0 82.1 3 257 45 99.9 1 1 768 326 582 AWB14570.1 ORF2 [Murine astrovirus 2] diamond 2307 439 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Murine astrovirus 2
18176799 18176799 PRJNA1199330_P_NODE_13015_length_571_cov_1.959839_g12335_i0 PRJNA1199330 13015 571 1.959839 11.19068069 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 360 9.1e-118   NR XCM67899.1 3003959 g12335 i0 87.9 0.998248686514886 190 23 99.8 0 570 1 419 608 XCM67899.1 MAG: structural polyprotein [Picornavirales sp.] diamond 570 360 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
22001986 22001986 PRJNA1199330_P_NODE_198_length_3144_cov_18.849560_g3_i2 PRJNA1199330 198 3144 18.84956 592.6301664 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1048 0   NR WKU61618.1 3063761 g3 i2 79.1 0.666030534351145 698 145 66.6 1 2096 3 1120 1816 WKU61618.1 polyprotein [Zebrafish picornavirus 2] diamond 2094 1048 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
26787852 26787852 PRJNA1199330_P_NODE_36221_length_344_cov_1.151292_g35522_i0 PRJNA1199330 36221 344 1.151292 3.96044448 Zebrafish gut calicivirus RQ08 Viruses Viruses 89 7.84e-18   NR XBS25272.1 RQ08 g35522 i0 38.7 0.968023255813954 111 67 95.9 1 12 341 210 320 XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] diamond 333 89 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
26977620 26977620 PRJNA1199330_P_NODE_15882_length_513_cov_2.897727_g15192_i0 PRJNA1199330 15882 513 2.897727 14.86533951 Zebrafish gut calicivirus RQ08 Viruses Viruses 68.9 5.06e-10   NR AVM87224.1 RQ08 g15192 i0 31.4 1.00584795321637 172 101 92.4 7 491 18 34 202 AVM87224.1 polyprotein [Fujian spotted paddle-tail newt calicivirus] diamond 516 68.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
27167197 27167197 PRJNA1199330_P_NODE_17562_length_488_cov_1.448193_g16870_i0 PRJNA1199330 17562 488 1.448193 7.06718184 Zebrafish gut calicivirus RQ08 Viruses Viruses 77.8 3.35e-13   NR UFQ21768.1 RQ08 g16870 i0 35.9 1.02663934426229 167 85 92.8 7 19 471 975 1135 UFQ21768.1 polyprotein [Ameiurus nebulosus calicivirus 1] diamond 501 77.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
27198737 27198737 PRJNA1199330_P_NODE_1822_length_1556_cov_1.947404_g1591_i0 PRJNA1199330 1822 1556 1.947404 30.30160624 Zebrafish gut calicivirus RQ08 Viruses Viruses 203 3.73e-52   NR XBS25272.1 RQ08 g1591 i0 34 0.726863753213368 377 233 71.7 8 3 1118 1838 2203 XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] diamond 1131 203 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
27217647 27217647 PRJNA1199330_P_NODE_54082_length_298_cov_2.071111_g53383_i0 PRJNA1199330 54082 298 2.071111 6.17191078 Viruses 10239 Viruses Viruses 111 3.2e-26   NR AWK77899.1 2201298 g53383 i0 89.3 1.12751677852349 56 6 56.4 0 296 129 495 550 AWK77899.1 structural polyprotein [Perth bee virus 4] diamond 336 111 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Perth bee virus 4
27230555 27230555 PRJNA1199330_P_NODE_27683_length_392_cov_0.968652_g26987_i0 PRJNA1199330 27683 392 0.968652 3.79711584 Zebrafish gut calicivirus RQ08 Viruses Viruses 184 7.470000000000002e-51   NR DAZ91097.1 RQ08 g26987 i0 62.9 3.01530612244898 132 47 99.5 1 3 392 1784 1915 DAZ91097.1 TPA_asm: nonstructural protein, partial [Newt calicivirus] diamond 1182 184 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
27262294 27262294 PRJNA1199330_P_NODE_3303_length_1179_cov_6.148282_g2932_i0 PRJNA1199330 3303 1179 6.148282 72.48824478 Zebrafish jaw picornavirus RQ13 Viruses Viruses 73.6 7.7e-10   NR ULF99604.1 RQ13 g2932 i0 24.8 0.974554707379135 383 204 90.8 11 1079 9 849 1173 ULF99604.1 MAG: polyprotein, partial [Kobuvirus sp.] diamond 1149 73.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Kobuvirus Zebrafish jaw picornavirus
27262301 27262301 PRJNA1199330_P_NODE_53503_length_299_cov_1.115044_g52804_i0 PRJNA1199330 53503 299 1.115044 3.33398156 Wenzhou bat picorna-like virus 5 3083956 Viruses Viruses 100 7.199999999999999e-24   NR WPV63447.1 3083956 g52804 i0 56.8 0.953177257525084 95 36 94.3 3 283 2 78 168 WPV63447.1 MAG: polyprotein, partial [Wenzhou bat picorna-like virus 5] diamond 285 100 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Wenzhou bat picorna-like virus 5
27799269 27799269 PRJNA1199330_P_NODE_21884_length_438_cov_1.649315_g21190_i0 PRJNA1199330 21884 438 1.649315 7.2239997 Perth bee virus 4 2201298 Viruses Viruses 284 4.33e-91   NR AWK77899.1 2201298 g21190 i0 93.1 1.98630136986301 145 10 99.3 0 436 2 157 301 AWK77899.1 structural polyprotein [Perth bee virus 4] diamond 870 284 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Perth bee virus 4
28209376 28209376 PRJNA1199330_P_NODE_27246_length_394_cov_3.482866_g26550_i0 PRJNA1199330 27246 394 3.482866 13.72249204 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 87.4 5.15e-17   NR UNY41988.1 3003959 g26550 i0 40.6 1.97969543147208 128 62 97.5 4 393 10 2249 2362 UNY41988.1 MAG: polyprotein [Picornavirales sp.] diamond 780 87.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28872511 28872511 PRJNA1199330_P_NODE_22568_length_431_cov_2.966480_g21873_i0 PRJNA1199330 22568 431 2.96648 12.7855288 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 283 2.3199999999999996e-85   NR XCM68193.1 3003959 g21873 i0 96.5 1.9907192575406 143 5 99.5 0 2 430 1060 1202 XCM68193.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 858 283 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28999257 28999257 PRJNA1199330_P_NODE_28628_length_386_cov_0.955272_g27932_i0 PRJNA1199330 28628 386 0.955272 3.68734992 Striga asiatica dicistro-like virus 1 2943843 Viruses Viruses 237 3.970000000000001e-71   NR UQR78685.1 2943843 g27932 i0 88.3 0.994818652849741 128 15 99.5 0 385 2 60 187 UQR78685.1 structural polyprotein, partial [Striga asiatica dicistro-like virus 1] diamond 384 237 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Striga asiatica dicistro-like virus 1
29522955 29522955 PRJNA1199330_P_NODE_121430_length_230_cov_2.687898_g120731_i0 PRJNA1199330 121430 230 2.687898 6.1821654 Zebrafish jaw picornavirus RQ13 Viruses Viruses 94.7 1.6e-20   NR ADL38962.1 RQ13 g120731 i0 60.5 8.92173913043478 76 29 97.8 1 225 1 2115 2190 ADL38962.1 polyprotein [Oscivirus A2] diamond 2052 94.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Oscivirus Zebrafish jaw picornavirus
29756543 29756543 PRJNA1199330_P_NODE_5591_length_902_cov_1.855247_g5063_i0 PRJNA1199330 5591 902 1.855247 16.73432794 Perth bee virus 4 2201298 Viruses Viruses 495 4.74e-161   NR AWK77898.1 2201298 g5063 i0 79.1 1.00443458980044 302 61 99.8 1 900 1 776 1077 AWK77898.1 nonstructural polyprotein, partial [Perth bee virus 4] diamond 906 495 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Perth bee virus 4
29819600 29819600 PRJNA1199330_P_NODE_30351_length_375_cov_2.311258_g29655_i0 PRJNA1199330 30351 375 2.311258 8.6672175 Zebrafish gut calicivirus RQ08 Viruses Viruses 94.4 1.47e-19   NR AVM87226.1 RQ08 g29655 i0 42.5 1.792 106 60 84 1 359 45 294 399 AVM87226.1 polyprotein [Zhejiang gunthers frog calicivirus 1] diamond 672 94.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
29819608 29819608 PRJNA1199330_P_NODE_57311_length_293_cov_1.618182_g56612_i0 PRJNA1199330 57311 293 1.618182 4.74127326 Perth bee virus 4 2201298 Viruses Viruses 129 3.6199999999999996e-32   NR AWK77898.1 2201298 g56612 i0 67 0.993174061433447 97 31 99.3 1 3 293 631 726 AWK77898.1 nonstructural polyprotein, partial [Perth bee virus 4] diamond 291 129 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Perth bee virus 4
29977717 29977717 PRJNA1199330_P_NODE_85231_length_267_cov_5.036082_g84532_i0 PRJNA1199330 85231 267 5.036082 13.44633894 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 150 7.2699999999999995e-40   NR XCM68193.1 3003959 g84532 i0 85.2 0.98876404494382 88 13 98.9 0 1 264 900 987 XCM68193.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 264 150 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30154376 30154376 PRJNA1199330_P_NODE_54952_length_296_cov_1.852018_g54253_i0 PRJNA1199330 54952 296 1.852018 5.48197328 Viruses 10239 Viruses Viruses 55.5 2.47e-6   NR AVM87195.1 2116161 g54253 i0 38.8 2.0472972972973 98 57 96.3 2 287 3 1535 1632 AVM87195.1 polyprotein [Beihai conger calicivirus] diamond 606 55.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Beihai conger calicivirus
30262363 30262363 PRJNA1199330_P_NODE_114332_length_243_cov_1.835294_g113633_i0 PRJNA1199330 114332 243 1.835294 4.45976442 Botryosphaeria dothidea victorivirus 2 2516210 Viruses Viruses 121 6.549999999999998e-30   NR QBA82442.1 2516210 g113633 i0 66.2 3.90123456790123 77 26 95.1 0 243 13 460 536 QBA82442.1 CP [Botryosphaeria dothidea victorivirus 2] diamond 948 121 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Pseudototiviridae Victorivirus Victorivirus nijyugo
30262366 30262366 PRJNA1199330_P_NODE_122372_length_228_cov_2.012903_g121673_i0 PRJNA1199330 122372 228 2.012903 4.5894188400000004 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 131 1.64e-33   NR XCM68193.1 3003959 g121673 i0 74.3 0.973684210526316 74 19 97.4 0 227 6 753 826 XCM68193.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 222 131 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30483346 30483346 PRJNA1199330_P_NODE_43633_length_313_cov_1.950000_g42934_i0 PRJNA1199330 43633 313 1.95 6.1035 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 96.3 1.4e-20   NR XCM68034.1 3003959 g42934 i0 47.1 0.996805111821086 104 48 99.7 2 313 2 469 565 XCM68034.1 MAG: structural polyprotein [Picornavirales sp.] diamond 312 96.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30577824 30577824 PRJNA1199330_P_NODE_28353_length_387_cov_2.646497_g27657_i0 PRJNA1199330 28353 387 2.646497 10.24194339 Perth bee virus 4 2201298 Viruses Viruses 186 7.72e-52   NR AWK77898.1 2201298 g27657 i0 68.5 0.984496124031008 127 40 98.4 0 383 3 12 138 AWK77898.1 nonstructural polyprotein, partial [Perth bee virus 4] diamond 381 186 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Perth bee virus 4
31052267 31052267 PRJNA1199330_P_NODE_35715_length_346_cov_2.758242_g35016_i0 PRJNA1199330 35715 346 2.758242 9.54351732 Zebrafish gut calicivirus RQ08 Viruses Viruses 132 6.31e-33   NR AVM87226.1 RQ08 g35016 i0 54.4 3.84104046242775 114 52 98.8 0 346 5 81 194 AVM87226.1 polyprotein [Zhejiang gunthers frog calicivirus 1] diamond 1329 132 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
31304802 31304802 PRJNA1199330_P_NODE_41835_length_318_cov_3.081633_g41136_i0 PRJNA1199330 41835 318 3.081633 9.79959294 Durnavirales sp. 2809355 Viruses Viruses 103 3.639999999999999e-23   NR WRQ64726.1 2809355 g41136 i0 47.6 0.990566037735849 105 55 99.1 0 4 318 255 359 WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.] diamond 315 103 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales     Durnavirales sp.
31937350 31937350 PRJNA1199330_P_NODE_58557_length_292_cov_1.132420_g57858_i0 PRJNA1199330 58557 292 1.13242 3.3066664 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 192 2.81e-54   NR XCM68193.1 3003959 g57858 i0 91.8 0.996575342465753 97 8 99.7 0 1 291 1227 1323 XCM68193.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 291 192 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31969069 31969069 PRJNA1199330_P_NODE_7938_length_748_cov_3.765926_g7325_i0 PRJNA1199330 7938 748 3.765926 28.16912648 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 438 4.51e-147   NR XCM67899.1 3003959 g7325 i0 89.6 0.998663101604278 249 26 99.9 0 1 747 178 426 XCM67899.1 MAG: structural polyprotein [Picornavirales sp.] diamond 747 438 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32651820 32651820 PRJNA1199330_P_NODE_95900_length_257_cov_2.233696_g95201_i0 PRJNA1199330 95900 257 2.233696 5.74059872 Viruses 10239 Viruses Viruses 150 7.28e-41   NR AWK77899.1 2201298 g95201 i0 88.3 1.79766536964981 77 9 89.9 0 255 25 474 550 AWK77899.1 structural polyprotein [Perth bee virus 4] diamond 462 150 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Perth bee virus 4
32759194 32759194 PRJNA1199330_P_NODE_100_length_3822_cov_4.142971_g84_i0 PRJNA1199330 100 3822 4.142971 158.34435162 Zebrafish jaw picornavirus RQ13 Viruses Viruses 504 4.1199999999999996e-147   NR XBH24011.1 RQ13 g84 i0 33.9 0.89403453689168 1139 592 86.8 31 160 3477 1375 2385 XBH24011.1 MAG: polyprotein [Coleura bat picornavirus] diamond 3417 504 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Zebrafish jaw picornavirus
32853582 32853582 PRJNA1199330_P_NODE_12740_length_578_cov_2.562376_g12060_i0 PRJNA1199330 12740 578 2.562376 14.81053328 Zebrafish jaw picornavirus RQ13 Viruses Viruses 73.6 2.37e-11   NR XEQ84337.1 RQ13 g12060 i0 30.4 0.8719723183391 168 104 80.4 3 530 66 288 455 XEQ84337.1 polyprotein, partial [Mink kobuvirus] diamond 504 73.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Kobuvirus 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);;