contig_metadata
29 rows where analysis = "diamond", bioproject = "PRJNA983848" and tax_kingdom = "Orthornavirae"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26677870 | 26677870 | PRJNA983848_P_NODE_22301_length_1109_cov_3.417954_g17510_i0 | PRJNA983848 | 22301 | 1109 | 3.417954 | 37.90510986 | Beijing sediment noda-like virus 3 | 2824385 | Viruses | Viruses | 79.7 | 2.53e-12 | NR | WWZ85777.1 | 2824385 | g17510 | i0 | 29.6 | 1.3688007213706 | 213 | 135 | 54.4 | 4 | 968 | 366 | 80 | 289 | WWZ85777.1 coat protein [Beijing sediment noda-like virus 3] | diamond | 1518 | 79.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodaviridae | Beijing sediment noda-like virus 3 | |||
| 27184224 | 27184224 | PRJNA983848_P_NODE_123582_length_269_cov_1.469388_g117699_i0 | PRJNA983848 | 123582 | 269 | 1.469388 | 3.95265372 | brine shrimp tombus-like virus 1 | 2900476 | Viruses | Viruses | 43.9 | 0.0191 | NR | UNI73989.1 | 2900476 | g117699 | i0 | 63.3 | 0.33457249070632 | 30 | 11 | 33.5 | 0 | 266 | 177 | 348 | 377 | UNI73989.1 MAG: coat protein [brine shrimp tombus-like virus 1] | diamond | 90 | 43.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | brine shrimp tombus-like virus 1 | |||
| 27247572 | 27247572 | PRJNA983848_P_NODE_123003_length_269_cov_3.668367_g117120_i0 | PRJNA983848 | 123003 | 269 | 3.668367 | 9.86790723 | Wuhan House Fly Virus 1 | 1608104 | Viruses | Viruses | 42.7 | 0.0496 | NR | APG78745.1 | 1608104 | g117120 | i0 | 29.5 | 1.05947955390335 | 95 | 59 | 97 | 1 | 3 | 263 | 200 | 294 | APG78745.1 putative nucleoprotein [Wuhan House Fly Virus 1] | diamond | 285 | 42.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sigmavirus | Sigmavirus wuhan | ||
| 27531918 | 27531918 | PRJNA983848_P_NODE_57703_length_435_cov_3.325967_g51823_i0 | PRJNA983848 | 57703 | 435 | 3.325967 | 14.46795645 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 155 | 1.6399999999999999e-40 | NR | YP_009333157.1 | 1922390 | g51823 | i0 | 49 | 1.0551724137931 | 153 | 67 | 99.3 | 2 | 433 | 2 | 1541 | 1691 | YP_009333157.1 RNA-dependent RNA polymerase [Beihai hermit crab virus 3] | diamond | 459 | 155 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 28352767 | 28352767 | PRJNA983848_P_NODE_54246_length_457_cov_4.442708_g48367_i0 | PRJNA983848 | 54246 | 457 | 4.442708 | 20.30317556 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 84 | 1.73e-15 | NR | YP_009333157.1 | 1922390 | g48367 | i0 | 35.2 | 0.800875273522976 | 122 | 79 | 80.1 | 0 | 2 | 367 | 2207 | 2328 | YP_009333157.1 RNA-dependent RNA polymerase [Beihai hermit crab virus 3] | diamond | 366 | 84 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 28605434 | 28605434 | PRJNA983848_P_NODE_78367_length_351_cov_1.122302_g72484_i0 | PRJNA983848 | 78367 | 351 | 1.122302 | 3.93928002 | Sicuhan sediment noda-like virus | 2824543 | Viruses | Viruses | 189 | 3.95e-53 | NR | QYF49987.1 | 2824543 | g72484 | i0 | 73.3 | 3.97435897435897 | 116 | 31 | 99.1 | 0 | 351 | 4 | 624 | 739 | QYF49987.1 MAG: RNA-dependent RNA polymerase [Sicuhan sediment noda-like virus] | diamond | 1395 | 189 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodaviridae | Sicuhan sediment noda-like virus | |||
| 28763182 | 28763182 | PRJNA983848_P_NODE_40167_length_598_cov_4.563810_g34340_i0 | PRJNA983848 | 40167 | 598 | 4.56381 | 27.2915838 | Austropotamobius brown spot virus | 2576634 | Viruses | Viruses | 191 | 1.26e-52 | NR | QCO84580.1 | 2576634 | g34340 | i0 | 46.4 | 1.94648829431438 | 194 | 98 | 97.3 | 1 | 582 | 1 | 646 | 833 | QCO84580.1 glycoprotein, partial [Austropotamobius brown spot virus] | diamond | 1164 | 191 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Austropotamobius brown spot virus | ||||
| 28857920 | 28857920 | PRJNA983848_P_NODE_78508_length_350_cov_2.667870_g72625_i0 | PRJNA983848 | 78508 | 350 | 2.66787 | 9.337545 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 51.2 | 1.31e-4 | NR | YP_009333156.1 | 1922390 | g72625 | i0 | 32.9 | 0.728571428571429 | 85 | 56 | 72.9 | 1 | 94 | 348 | 1 | 84 | YP_009333156.1 hypothetical protein 2 [Beihai hermit crab virus 3] | diamond | 255 | 51.2 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 29016209 | 29016209 | PRJNA983848_P_NODE_78608_length_350_cov_1.841155_g72725_i0 | PRJNA983848 | 78608 | 350 | 1.841155 | 6.4440425 | Boana pugnax lyssa-like virus 1 | 2985438 | Viruses | Viruses | 48.9 | 8.13e-4 | NR | UYD62334.1 | 2985438 | g72725 | i0 | 36.4 | 0.565714285714286 | 66 | 40 | 56.6 | 1 | 206 | 9 | 197 | 260 | UYD62334.1 nucleoprotein [Boana pugnax lyssa-like virus 1] | diamond | 198 | 48.9 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Amplylivirus | Amplylivirus pugnax | ||
| 29237009 | 29237009 | PRJNA983848_P_NODE_60729_length_418_cov_1.953623_g54847_i0 | PRJNA983848 | 60729 | 418 | 1.953623 | 8.16614414 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 252 | 1.59e-74 | NR | YP_009333157.1 | 1922390 | g54847 | i0 | 86.3 | 0.997607655502392 | 139 | 19 | 99.8 | 0 | 417 | 1 | 540 | 678 | YP_009333157.1 RNA-dependent RNA polymerase [Beihai hermit crab virus 3] | diamond | 417 | 252 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 29457604 | 29457604 | PRJNA983848_P_NODE_47130_length_516_cov_4.749436_g41260_i0 | PRJNA983848 | 47130 | 516 | 4.749436 | 24.50708976 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 182 | 1.78e-49 | NR | YP_009333157.1 | 1922390 | g41260 | i0 | 50.9 | 0.994186046511628 | 171 | 84 | 99.4 | 0 | 2 | 514 | 189 | 359 | YP_009333157.1 RNA-dependent RNA polymerase [Beihai hermit crab virus 3] | diamond | 513 | 182 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 29527106 | 29527106 | PRJNA983848_P_NODE_93450_length_315_cov_1.611570_g87567_i0 | PRJNA983848 | 93450 | 315 | 1.61157 | 5.0764455 | Viruses | 10239 | Viruses | Viruses | 178 | 1.68e-49 | NR | YP_009329823.1 | 1926968 | g87567 | i0 | 81 | 2 | 105 | 20 | 100 | 0 | 315 | 1 | 655 | 759 | YP_009329823.1 structural protein [Bivalve RNA virus G5] | diamond | 630 | 178 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Bivalve RNA virus G5 | |||
| 29552415 | 29552415 | PRJNA983848_P_NODE_33630_length_716_cov_2.931571_g27928_i0 | PRJNA983848 | 33630 | 716 | 2.931571 | 20.99004836 | Otter fecal bunyavirus | 1504566 | Viruses | Viruses | 173 | 4.75e-50 | NR | AIB06815.1 | 1504566 | g27928 | i0 | 51.3 | 0.791899441340782 | 189 | 85 | 78.4 | 4 | 1 | 561 | 49 | 232 | AIB06815.1 nucleocapsid protein, partial [Otter fecal bunyavirus] | diamond | 567 | 173 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Peribunyaviridae | Otter fecal bunyavirus | |||
| 29646962 | 29646962 | PRJNA983848_P_NODE_139530_length_252_cov_1.279330_g133647_i0 | PRJNA983848 | 139530 | 252 | 1.27933 | 3.2239116 | Picornavirales Q_sR_OV_ | 464095 | Viruses | Viruses | 101 | 1.1200000000000001e-22 | NR | ASG92545.1 | 2016075 | g133647 | i0 | 63.4 | 1.97619047619048 | 82 | 29 | 97.6 | 1 | 7 | 252 | 721 | 801 | ASG92545.1 putative non-structural protein [Picornavirales Q_sR_OV_023] | diamond | 498 | 101 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornavirales Q_sR_OV_023 | ||||
| 29773527 | 29773527 | PRJNA983848_P_NODE_54271_length_457_cov_3.427083_g48392_i0 | PRJNA983848 | 54271 | 457 | 3.427083 | 15.66176931 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 179 | 1.01e-48 | NR | YP_009333157.1 | 1922390 | g48392 | i0 | 57.7 | 0.978118161925602 | 149 | 63 | 97.8 | 0 | 7 | 453 | 1398 | 1546 | YP_009333157.1 RNA-dependent RNA polymerase [Beihai hermit crab virus 3] | diamond | 447 | 179 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 30120978 | 30120978 | PRJNA983848_P_NODE_111572_length_284_cov_3.748815_g105689_i0 | PRJNA983848 | 111572 | 284 | 3.748815 | 10.6466346 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 79.7 | 6.31e-15 | NR | YP_009333157.1 | 1922390 | g105689 | i0 | 38 | 0.971830985915493 | 92 | 57 | 97.2 | 0 | 9 | 284 | 1690 | 1781 | YP_009333157.1 RNA-dependent RNA polymerase [Beihai hermit crab virus 3] | diamond | 276 | 79.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 30152496 | 30152496 | PRJNA983848_P_NODE_16852_length_1464_cov_4.304098_g12881_i0 | PRJNA983848 | 16852 | 1464 | 4.304098 | 63.01199472 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 276 | 2.769999999999999e-82 | NR | YP_009333156.1 | 1922390 | g12881 | i0 | 35.6 | 1.03073770491803 | 503 | 292 | 99.2 | 12 | 3 | 1454 | 90 | 579 | YP_009333156.1 hypothetical protein 2 [Beihai hermit crab virus 3] | diamond | 1509 | 276 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 30152497 | 30152497 | PRJNA983848_P_NODE_20072_length_1242_cov_3.779299_g15583_i0 | PRJNA983848 | 20072 | 1242 | 3.779299 | 46.93889358 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 587 | 2.629999999999999e-188 | NR | YP_009333157.1 | 1922390 | g15583 | i0 | 66.6 | 0.997584541062802 | 413 | 138 | 99.8 | 0 | 2 | 1240 | 794 | 1206 | YP_009333157.1 RNA-dependent RNA polymerase [Beihai hermit crab virus 3] | diamond | 1239 | 587 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 30405933 | 30405933 | PRJNA983848_P_NODE_95773_length_310_cov_3.312236_g89890_i0 | PRJNA983848 | 95773 | 310 | 3.312236 | 10.2679316 | Otter fecal bunyavirus | 1504566 | Viruses | Viruses | 99.8 | 1.42e-22 | NR | AIB06816.1 | 1504566 | g89890 | i0 | 44.7 | 1.81935483870968 | 94 | 52 | 91 | 0 | 7 | 288 | 88 | 181 | AIB06816.1 glycoprotein, partial [Otter fecal bunyavirus] | diamond | 564 | 99.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Peribunyaviridae | Otter fecal bunyavirus | |||
| 30531809 | 30531809 | PRJNA983848_P_NODE_86753_length_329_cov_3.156250_g80870_i0 | PRJNA983848 | 86753 | 329 | 3.15625 | 10.3840625 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 78.6 | 2.73e-14 | NR | YP_009333154.1 | 1922390 | g80870 | i0 | 34.3 | 0.984802431610942 | 108 | 71 | 98.5 | 0 | 1 | 324 | 325 | 432 | YP_009333154.1 putative glycoprotein [Beihai hermit crab virus 3] | diamond | 324 | 78.6 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 31005801 | 31005801 | PRJNA983848_P_NODE_27354_length_891_cov_3.979218_g21976_i0 | PRJNA983848 | 27354 | 891 | 3.979218 | 35.45483238 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 106 | 1.58e-21 | NR | YP_009333154.1 | 1922390 | g21976 | i0 | 31.2 | 0.723905723905724 | 215 | 147 | 72.4 | 1 | 9 | 653 | 526 | 739 | YP_009333154.1 putative glycoprotein [Beihai hermit crab virus 3] | diamond | 645 | 106 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 31169522 | 31169522 | PRJNA983848_P_NODE_103515_length_297_cov_1.196429_g97632_i0 | PRJNA983848 | 103515 | 297 | 1.196429 | 3.55339413 | Viruses | 10239 | Viruses | Viruses | 67.4 | 1.64e-10 | NR | AWK77858.1 | 2201290 | g97632 | i0 | 38.3 | 1.93939393939394 | 94 | 47 | 94.9 | 2 | 294 | 13 | 2383 | 2465 | AWK77858.1 polyprotein [Bundaberg bee virus 7] | diamond | 576 | 67.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Bundaberg bee virus 7 | ||||
| 31258646 | 31258646 | PRJNA983848_P_NODE_55215_length_451_cov_4.103175_g49336_i0 | PRJNA983848 | 55215 | 451 | 4.103175 | 18.50531925 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 66.2 | 2.2e-9 | NR | YP_009333154.1 | 1922390 | g49336 | i0 | 35.6 | 0.69179600886918 | 104 | 59 | 65.9 | 3 | 145 | 441 | 76 | 176 | YP_009333154.1 putative glycoprotein [Beihai hermit crab virus 3] | diamond | 312 | 66.2 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 31480338 | 31480338 | PRJNA983848_P_NODE_20236_length_1230_cov_3.491789_g15724_i0 | PRJNA983848 | 20236 | 1230 | 3.491789 | 42.9490047 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 349 | 4.84e-104 | NR | YP_009333157.1 | 1922390 | g15724 | i0 | 45.4 | 1 | 410 | 222 | 99.5 | 1 | 7 | 1230 | 1780 | 2189 | YP_009333157.1 RNA-dependent RNA polymerase [Beihai hermit crab virus 3] | diamond | 1230 | 349 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 31701447 | 31701447 | PRJNA983848_P_NODE_20517_length_1213_cov_4.097368_g15972_i0 | PRJNA983848 | 20517 | 1213 | 4.097368 | 49.70107384 | Austropotamobius brown spot virus | 2576634 | Viruses | Viruses | 241 | 8.299999999999999e-68 | NR | QCO84580.1 | 2576634 | g15972 | i0 | 31.3 | 0.9719703215169 | 393 | 266 | 96.5 | 4 | 1171 | 2 | 167 | 558 | QCO84580.1 glycoprotein, partial [Austropotamobius brown spot virus] | diamond | 1179 | 241 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Austropotamobius brown spot virus | ||||
| 31707405 | 31707405 | PRJNA983848_P_NODE_76977_length_355_cov_1.333333_g71094_i0 | PRJNA983848 | 76977 | 355 | 1.333333 | 4.73333215 | Viruses | 10239 | Viruses | Viruses | 206 | 6.999999999999998e-59 | NR | ASG92545.1 | 2016075 | g71094 | i0 | 83.9 | 2.99154929577465 | 118 | 19 | 99.7 | 0 | 2 | 355 | 1133 | 1250 | ASG92545.1 putative non-structural protein [Picornavirales Q_sR_OV_023] | diamond | 1062 | 206 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornavirales Q_sR_OV_023 | ||||
| 32271060 | 32271060 | PRJNA983848_P_NODE_48218_length_507_cov_1.467742_g42345_i0 | PRJNA983848 | 48218 | 507 | 1.467742 | 7.44145194 | Picornavirales Q_sR_OV_ | 464095 | Viruses | Viruses | 201 | 1.6399999999999998e-56 | NR | ASG92546.1 | 2016075 | g42345 | i0 | 55.2 | 1.01775147928994 | 172 | 73 | 99.4 | 1 | 2 | 505 | 762 | 933 | ASG92546.1 putative structural protein [Picornavirales Q_sR_OV_023] | diamond | 516 | 201 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornavirales Q_sR_OV_023 | ||||
| 32429224 | 32429224 | PRJNA983848_P_NODE_61919_length_412_cov_2.203540_g56037_i0 | PRJNA983848 | 61919 | 412 | 2.20354 | 9.0785848 | Bivalve RNA virus G5 | 1926968 | Viruses | Viruses | 270 | 2.979999999999999e-82 | NR | YP_009329823.1 | 1926968 | g56037 | i0 | 94.2 | 0.997572815533981 | 137 | 8 | 99.8 | 0 | 411 | 1 | 463 | 599 | YP_009329823.1 structural protein [Bivalve RNA virus G5] | diamond | 411 | 270 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Bivalve RNA virus G5 | |||
| 32556020 | 32556020 | PRJNA983848_P_NODE_99739_length_303_cov_1.765217_g93856_i0 | PRJNA983848 | 99739 | 303 | 1.765217 | 5.34860751 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 176 | 1.07e-48 | NR | YP_009333157.1 | 1922390 | g93856 | i0 | 84.8 | 0.98019801980198 | 99 | 15 | 98 | 0 | 5 | 301 | 693 | 791 | YP_009333157.1 RNA-dependent RNA polymerase [Beihai hermit crab virus 3] | diamond | 297 | 176 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus |
Advanced export
JSON shape: default, array, newline-delimited
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);;