contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA798511" and tax_phylum = "Negarnaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3340696 | 3340696 | PRJNA798511_P_NODE_11223_length_1395_cov_42.943268_g6889_i1 | PRJNA798511 | 11223 | 1395 | 42.943268 | 599.0585886 | brine shrimp arlivirus 8 | 2900383 | Viruses | Viruses | 414 | 1.41e-138 | NR | UNI74120.1 | 2900383 | g6889 | i1 | 54.2 | 0.789247311827957 | 367 | 168 | 78.9 | 0 | 1269 | 169 | 1 | 367 | UNI74120.1 MAG: hypothetical protein [brine shrimp arlivirus 8] | diamond | 1101 | 414 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsaeighalis | ||
| 9719355 | 9719355 | PRJNA798511_P_NODE_9108_length_1651_cov_39.595691_g6889_i0 | PRJNA798511 | 9108 | 1651 | 39.595691 | 653.72485841 | brine shrimp arlivirus 8 | 2900383 | Viruses | Viruses | 382 | 5.95e-125 | NR | UNI74120.1 | 2900383 | g6889 | i0 | 54.7 | 0.614173228346457 | 338 | 153 | 61.4 | 0 | 1525 | 512 | 1 | 338 | UNI74120.1 MAG: hypothetical protein [brine shrimp arlivirus 8] | diamond | 1014 | 382 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsaeighalis | ||
| 26927362 | 26927362 | PRJNA798511_P_NODE_23902_length_668_cov_2.858824_g19748_i0 | PRJNA798511 | 23902 | 668 | 2.858824 | 19.09694432 | Zahedan rhabdovirus | 1620507 | Viruses | Viruses | 67.8 | 3.42e-9 | NR | YP_009552801.1 | 1620507 | g19748 | i0 | 27.3 | 0.839820359281437 | 187 | 117 | 78.1 | 8 | 146 | 667 | 30 | 210 | YP_009552801.1 nucleoprotein [Zahedan rhabdovirus] | diamond | 561 | 67.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Zarhavirus | Zarhavirus zahedan | ||
| 28001669 | 28001669 | PRJNA798511_P_NODE_50985_length_352_cov_1.655914_g46719_i0 | PRJNA798511 | 50985 | 352 | 1.655914 | 5.82881728 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 227 | 3.4399999999999997e-66 | NR | UNI74094.1 | 2900380 | g46719 | i0 | 98.3 | 0.988636363636364 | 116 | 2 | 98.9 | 0 | 350 | 3 | 1132 | 1247 | UNI74094.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 5] | diamond | 348 | 227 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 28412064 | 28412064 | PRJNA798511_P_NODE_8306_length_1770_cov_8.104302_g6271_i0 | PRJNA798511 | 8306 | 1770 | 8.104302 | 143.4461454 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 511 | 4.1299999999999986e-173 | NR | UNI74091.1 | 2900380 | g6271 | i0 | 54.1 | 0.86779661016949206 | 512 | 235 | 86.8 | 0 | 1745 | 210 | 1 | 512 | UNI74091.1 MAG: hypothetical protein [brine shrimp arlivirus 5] | diamond | 1536 | 511 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 28506731 | 28506731 | PRJNA798511_P_NODE_51387_length_350_cov_2.198556_g47121_i0 | PRJNA798511 | 51387 | 350 | 2.198556 | 7.694946 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 239 | 1.24e-70 | NR | UNI74094.1 | 2900380 | g47121 | i0 | 94.8 | 0.994285714285714 | 116 | 6 | 99.4 | 0 | 2 | 349 | 1677 | 1792 | UNI74094.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 5] | diamond | 348 | 239 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 28664605 | 28664605 | PRJNA798511_P_NODE_13667_length_1174_cov_2.671208_g10516_i0 | PRJNA798511 | 13667 | 1174 | 2.671208 | 31.35998192 | brine shrimp yue-like virus 3 | 2900455 | Viruses | Viruses | 155 | 4.3299999999999995e-37 | NR | UNI73808.1 | 2900455 | g10516 | i0 | 37.8 | 2.17206132879046 | 283 | 146 | 64.9 | 6 | 946 | 185 | 1935 | 2216 | UNI73808.1 MAG: RNA-dependent RNA polymerase [brine shrimp yue-like virus 3] | diamond | 2550 | 155 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 3 | |||
| 28980482 | 28980482 | PRJNA798511_P_NODE_21528_length_744_cov_3.023845_g17477_i0 | PRJNA798511 | 21528 | 744 | 3.023845 | 22.4974068 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 433 | 2.82e-136 | NR | UNI74094.1 | 2900380 | g17477 | i0 | 86.7 | 1 | 248 | 33 | 100 | 0 | 744 | 1 | 1783 | 2030 | UNI74094.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 5] | diamond | 744 | 433 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 29169907 | 29169907 | PRJNA798511_P_NODE_67329_length_296_cov_1.161435_g63063_i0 | PRJNA798511 | 67329 | 296 | 1.161435 | 3.4378476 | brine shrimp yue-like virus 6 | 2900458 | Viruses | Viruses | 74.3 | 5.31e-13 | NR | UNI74180.1 | 2900458 | g63063 | i0 | 68.1 | 0.476351351351351 | 47 | 15 | 47.6 | 0 | 289 | 149 | 441 | 487 | UNI74180.1 MAG: hypothetical protein [brine shrimp yue-like virus 6] | diamond | 141 | 74.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 6 | |||
| 29296032 | 29296032 | PRJNA798511_P_NODE_58809_length_321_cov_3.072581_g54543_i0 | PRJNA798511 | 58809 | 321 | 3.072581 | 9.86298501 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 213 | 2.18e-61 | NR | UNI74094.1 | 2900380 | g54543 | i0 | 90.6 | 0.990654205607477 | 106 | 10 | 99.1 | 0 | 319 | 2 | 1457 | 1562 | UNI74094.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 5] | diamond | 318 | 213 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 30654125 | 30654125 | PRJNA798511_P_NODE_16453_length_976_cov_4.231451_g12866_i0 | PRJNA798511 | 16453 | 976 | 4.231451 | 41.29896176 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 337 | 2.0499999999999995e-112 | NR | UNI74093.1 | 2900380 | g12866 | i0 | 62.2 | 0.903688524590164 | 294 | 73 | 84.5 | 2 | 974 | 150 | 1 | 275 | UNI74093.1 MAG: hypothetical protein [brine shrimp arlivirus 5] | diamond | 882 | 337 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 30812180 | 30812180 | PRJNA798511_P_NODE_79134_length_268_cov_2.369231_g74868_i0 | PRJNA798511 | 79134 | 268 | 2.369231 | 6.34953908 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 168 | 4.38e-46 | NR | UNI74094.1 | 2900380 | g74868 | i0 | 88.6 | 0.985074626865672 | 88 | 10 | 98.5 | 0 | 266 | 3 | 1240 | 1327 | UNI74094.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 5] | diamond | 264 | 168 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 31065229 | 31065229 | PRJNA798511_P_NODE_27715_length_578_cov_15.784158_g23496_i0 | PRJNA798511 | 27715 | 578 | 15.784158 | 91.23243324 | brine shrimp yue-like virus 3 | 2900455 | Viruses | Viruses | 95.5 | 2.38e-19 | NR | UNI73809.1 | 2900455 | g23496 | i0 | 31.3 | 1.58823529411765 | 182 | 113 | 90.3 | 3 | 523 | 2 | 10 | 187 | UNI73809.1 MAG: hypothetical protein [brine shrimp yue-like virus 3] | diamond | 918 | 95.5 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 3 | |||
| 31096483 | 31096483 | PRJNA798511_P_NODE_26875_length_596_cov_3.673040_g22665_i0 | PRJNA798511 | 26875 | 596 | 3.67304 | 21.8913184 | Lone star tick rhabdovirus | 1756186 | Viruses | Viruses | 66.6 | 5.23e-9 | NR | YP_010796342.1 | 1756186 | g22665 | i0 | 29.6 | 0.76510067114094 | 152 | 103 | 75 | 3 | 5 | 451 | 237 | 387 | YP_010796342.1 nucleoprotein [Lone star tick rhabdovirus] | diamond | 456 | 66.6 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lostrhavirus | Lostrhavirus lonestar | ||
| 31286134 | 31286134 | PRJNA798511_P_NODE_81195_length_264_cov_1.507853_g76929_i0 | PRJNA798511 | 81195 | 264 | 1.507853 | 3.98073192 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 162 | 3.38e-44 | NR | UNI74094.1 | 2900380 | g76929 | i0 | 93.1 | 0.988636363636364 | 87 | 6 | 98.9 | 0 | 261 | 1 | 1318 | 1404 | UNI74094.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 5] | diamond | 261 | 162 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 31317849 | 31317849 | PRJNA798511_P_NODE_42975_length_398_cov_1.658462_g38711_i0 | PRJNA798511 | 42975 | 398 | 1.658462 | 6.60067876 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 248 | 3.59e-73 | NR | UNI74094.1 | 2900380 | g38711 | i0 | 94.7 | 0.994974874371859 | 132 | 7 | 99.5 | 0 | 1 | 396 | 457 | 588 | UNI74094.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 5] | diamond | 396 | 248 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 31381313 | 31381313 | PRJNA798511_P_NODE_30376_length_533_cov_1.521739_g26137_i0 | PRJNA798511 | 30376 | 533 | 1.521739 | 8.11086887 | brine shrimp yue-like virus 9 | 2900461 | Viruses | Viruses | 185 | 1.88e-50 | NR | UNI74195.1 | 2900461 | g26137 | i0 | 67.8 | 0.821763602251407 | 146 | 43 | 81.1 | 2 | 2 | 433 | 2247 | 2390 | UNI74195.1 MAG: RNA-dependent RNA polymerase [brine shrimp yue-like virus 9] | diamond | 438 | 185 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 9 | |||
| 31539412 | 31539412 | PRJNA798511_P_NODE_77896_length_271_cov_1.580808_g73630_i0 | PRJNA798511 | 77896 | 271 | 1.580808 | 4.28398968 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 169 | 1.38e-46 | NR | UNI74094.1 | 2900380 | g73630 | i0 | 85.6 | 0.996309963099631 | 90 | 13 | 99.6 | 0 | 2 | 271 | 1014 | 1103 | UNI74094.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 5] | diamond | 270 | 169 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 31602711 | 31602711 | PRJNA798511_P_NODE_96756_length_245_cov_0.895349_g92490_i0 | PRJNA798511 | 96756 | 245 | 0.895349 | 2.19360505 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 134 | 1.77e-34 | NR | UNI74094.1 | 2900380 | g92490 | i0 | 79 | 0.991836734693878 | 81 | 17 | 99.2 | 0 | 244 | 2 | 7 | 87 | UNI74094.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 5] | diamond | 243 | 134 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 32181206 | 32181206 | PRJNA798511_P_NODE_78918_length_269_cov_1.255102_g74652_i0 | PRJNA798511 | 78918 | 269 | 1.255102 | 3.37622438 | Chuviridae | 2501952 | Viruses | Viruses | 65.1 | 6.62e-10 | NR | YP_009666264.1 | 1608120 | g74652 | i0 | 44.1 | 3.27881040892193 | 68 | 38 | 75.8 | 0 | 265 | 62 | 333 | 400 | YP_009666264.1 putative nucleoprotein [Wuhan louse fly virus 6] | diamond | 882 | 65.1 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Boscovirus | Boscovirus hypoboscidae | ||
| 32456929 | 32456929 | PRJNA798511_P_NODE_31559_length_514_cov_13.154195_g27311_i0 | PRJNA798511 | 31559 | 514 | 13.154195 | 67.6125623 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 159 | 5.5e-47 | NR | UNI74092.1 | 2900380 | g27311 | i0 | 63.3 | 0.700389105058366 | 120 | 44 | 70 | 0 | 419 | 60 | 1 | 120 | UNI74092.1 MAG: hypothetical protein [brine shrimp arlivirus 5] | diamond | 360 | 159 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 32740808 | 32740808 | PRJNA798511_P_NODE_23340_length_684_cov_11.266776_g19208_i0 | PRJNA798511 | 23340 | 684 | 11.266776 | 77.06474784 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 193 | 1.84e-59 | NR | UNI74092.1 | 2900380 | g19208 | i0 | 89.2 | 0.486842105263158 | 111 | 12 | 48.7 | 0 | 673 | 341 | 8 | 118 | UNI74092.1 MAG: hypothetical protein [brine shrimp arlivirus 5] | diamond | 333 | 193 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 32897955 | 32897955 | PRJNA798511_P_NODE_93140_length_248_cov_0.862857_g88874_i0 | PRJNA798511 | 93140 | 248 | 0.862857 | 2.13988536 | brine shrimp yue-like virus 4 | 2900456 | Viruses | Viruses | 110 | 3.86e-26 | NR | UNI74172.1 | 2900456 | g88874 | i0 | 65.9 | 0.991935483870968 | 82 | 28 | 99.2 | 0 | 3 | 248 | 196 | 277 | UNI74172.1 MAG: hypothetical protein [brine shrimp yue-like virus 4] | diamond | 246 | 110 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 4 |
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);;