contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA832865" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8475013 | 8475013 | PRJNA832865_S_NODE_10727_length_1395_cov_41.695915_g7785_i0 | PRJNA832865 | 10727 | 1395 | 41.695915 | 581.65801425 | brine shrimp arlivirus 8 | 2900383 | Viruses | Viruses | 412 | 4.0099999999999983e-138 | NR | UNI74120.1 | 2900383 | g7785 | i0 | 54 | 0.789247311827957 | 367 | 169 | 78.9 | 0 | 1269 | 169 | 1 | 367 | UNI74120.1 MAG: hypothetical protein [brine shrimp arlivirus 8] | diamond | 1101 | 412 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsaeighalis | ||
| 26928041 | 26928041 | PRJNA832865_S_NODE_69542_length_296_cov_1.161435_g64456_i0 | PRJNA832865 | 69542 | 296 | 1.161435 | 3.4378476 | brine shrimp yue-like virus 6 | 2900458 | Viruses | Viruses | 74.3 | 5.31e-13 | NR | UNI74180.1 | 2900458 | g64456 | 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 | |||
| 27434068 | 27434068 | PRJNA832865_S_NODE_27443_length_578_cov_12.825743_g22422_i0 | PRJNA832865 | 27443 | 578 | 12.825743 | 74.13279454 | brine shrimp yue-like virus 3 | 2900455 | Viruses | Viruses | 95.5 | 2.38e-19 | NR | UNI73809.1 | 2900455 | g22422 | i0 | 31.3 | 1.58823529411765 | 182 | 113 | 90.3 | 3 | 56 | 577 | 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 | |||
| 27718435 | 27718435 | PRJNA832865_S_NODE_99764_length_248_cov_0.862857_g94678_i0 | PRJNA832865 | 99764 | 248 | 0.862857 | 2.13988536 | brine shrimp yue-like virus 4 | 2900456 | Viruses | Viruses | 110 | 3.86e-26 | NR | UNI74172.1 | 2900456 | g94678 | 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 | |||
| 27749805 | 27749805 | PRJNA832865_S_NODE_13244_length_1174_cov_2.741144_g9747_i0 | PRJNA832865 | 13244 | 1174 | 2.741144 | 32.18103056 | brine shrimp yue-like virus 3 | 2900455 | Viruses | Viruses | 155 | 4.3299999999999995e-37 | NR | UNI73808.1 | 2900455 | g9747 | 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 | |||
| 27939124 | 27939124 | PRJNA832865_S_NODE_51905_length_350_cov_2.198556_g46819_i0 | PRJNA832865 | 51905 | 350 | 2.198556 | 7.694946 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 239 | 1.24e-70 | NR | UNI74094.1 | 2900380 | g46819 | 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 | ||
| 28191365 | 28191365 | PRJNA832865_S_NODE_31286_length_514_cov_12.603175_g26220_i0 | PRJNA832865 | 31286 | 514 | 12.603175 | 64.7803195 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 159 | 5.5e-47 | NR | UNI74092.1 | 2900380 | g26220 | 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 | ||
| 28191382 | 28191382 | PRJNA832865_S_NODE_7826_length_1770_cov_7.843842_g5591_i0 | PRJNA832865 | 7826 | 1770 | 7.843842 | 138.8360034 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 511 | 4.1299999999999986e-173 | NR | UNI74091.1 | 2900380 | g5591 | 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 | ||
| 28317885 | 28317885 | PRJNA832865_S_NODE_35106_length_466_cov_2.068702_g30024_i0 | PRJNA832865 | 35106 | 466 | 2.068702 | 9.64015132 | Zahedan rhabdovirus | 1620507 | Viruses | Viruses | 62.8 | 3.69e-8 | NR | YP_009552801.1 | 1620507 | g30024 | i0 | 26.7 | 1.03648068669528 | 161 | 102 | 96.6 | 6 | 16 | 465 | 55 | 210 | YP_009552801.1 nucleoprotein [Zahedan rhabdovirus] | diamond | 483 | 62.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Zarhavirus | Zarhavirus zahedan | ||
| 28444343 | 28444343 | PRJNA832865_S_NODE_22766_length_691_cov_11.152104_g17919_i0 | PRJNA832865 | 22766 | 691 | 11.152104 | 77.06103864 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 193 | 1.9800000000000001e-59 | NR | UNI74092.1 | 2900380 | g17919 | i0 | 89.2 | 0.481910274963821 | 111 | 12 | 48.2 | 0 | 680 | 348 | 8 | 118 | UNI74092.1 MAG: hypothetical protein [brine shrimp arlivirus 5] | diamond | 333 | 193 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 29044261 | 29044261 | PRJNA832865_S_NODE_58668_length_325_cov_3.039683_g53582_i0 | PRJNA832865 | 58668 | 325 | 3.039683 | 9.87896975 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 213 | 2.37e-61 | NR | UNI74094.1 | 2900380 | g53582 | i0 | 89.7 | 0.987692307692308 | 107 | 11 | 98.8 | 0 | 322 | 2 | 1456 | 1562 | UNI74094.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 5] | diamond | 321 | 213 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 29896739 | 29896739 | PRJNA832865_S_NODE_16091_length_976_cov_4.188261_g11994_i0 | PRJNA832865 | 16091 | 976 | 4.188261 | 40.87742736 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 337 | 2.0499999999999995e-112 | NR | UNI74093.1 | 2900380 | g11994 | 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 | ||
| 30180877 | 30180877 | PRJNA832865_S_NODE_30132_length_533_cov_1.521739_g25081_i0 | PRJNA832865 | 30132 | 533 | 1.521739 | 8.11086887 | brine shrimp yue-like virus 9 | 2900461 | Viruses | Viruses | 185 | 1.88e-50 | NR | UNI74195.1 | 2900461 | g25081 | 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 | |||
| 31002511 | 31002511 | PRJNA832865_S_NODE_103714_length_245_cov_0.895349_g98628_i0 | PRJNA832865 | 103714 | 245 | 0.895349 | 2.19360505 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 134 | 1.77e-34 | NR | UNI74094.1 | 2900380 | g98628 | 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 | ||
| 31318466 | 31318466 | PRJNA832865_S_NODE_42955_length_398_cov_1.658462_g37869_i0 | PRJNA832865 | 42955 | 398 | 1.658462 | 6.60067876 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 248 | 3.59e-73 | NR | UNI74094.1 | 2900380 | g37869 | 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 | ||
| 31666318 | 31666318 | PRJNA832865_S_NODE_21237_length_744_cov_3.025335_g16486_i0 | PRJNA832865 | 21237 | 744 | 3.025335 | 22.5084924 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 433 | 2.82e-136 | NR | UNI74094.1 | 2900380 | g16486 | 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 | ||
| 31729664 | 31729664 | PRJNA832865_S_NODE_85717_length_264_cov_1.507853_g80631_i0 | PRJNA832865 | 85717 | 264 | 1.507853 | 3.98073192 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 162 | 3.38e-44 | NR | UNI74094.1 | 2900380 | g80631 | 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 | ||
| 31832986 | 31832986 | PRJNA832865_S_NODE_82977_length_269_cov_1.255102_g77891_i0 | PRJNA832865 | 82977 | 269 | 1.255102 | 3.37622438 | Chuviridae | 2501952 | Viruses | Viruses | 65.1 | 6.62e-10 | NR | YP_009666264.1 | 1608120 | g77891 | 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 | ||
| 32204297 | 32204297 | PRJNA832865_S_NODE_51478_length_352_cov_1.655914_g46392_i0 | PRJNA832865 | 51478 | 352 | 1.655914 | 5.82881728 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 227 | 3.4399999999999997e-66 | NR | UNI74094.1 | 2900380 | g46392 | 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 | ||
| 32204312 | 32204312 | PRJNA832865_S_NODE_83238_length_268_cov_2.369231_g78152_i0 | PRJNA832865 | 83238 | 268 | 2.369231 | 6.34953908 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 168 | 4.38e-46 | NR | UNI74094.1 | 2900380 | g78152 | 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 | ||
| 32489271 | 32489271 | PRJNA832865_S_NODE_75959_length_282_cov_1.555024_g70873_i0 | PRJNA832865 | 75959 | 282 | 1.555024 | 4.38516768 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 175 | 2.02e-48 | NR | UNI74094.1 | 2900380 | g70873 | i0 | 84.9 | 0.98936170212766 | 93 | 14 | 98.9 | 0 | 2 | 280 | 1014 | 1106 | UNI74094.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 5] | diamond | 279 | 175 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 32552617 | 32552617 | PRJNA832865_S_NODE_12759_length_1212_cov_48.150132_g7785_i1 | PRJNA832865 | 12759 | 1212 | 48.150132 | 583.57959984 | brine shrimp arlivirus 8 | 2900383 | Viruses | Viruses | 406 | 1.2e-136 | NR | UNI74120.1 | 2900383 | g7785 | i1 | 54.3 | 0.888613861386139 | 359 | 164 | 88.9 | 0 | 127 | 1203 | 1 | 359 | UNI74120.1 MAG: hypothetical protein [brine shrimp arlivirus 8] | diamond | 1077 | 406 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsaeighalis | ||
| 32709738 | 32709738 | PRJNA832865_S_NODE_26600_length_596_cov_3.711281_g21595_i0 | PRJNA832865 | 26600 | 596 | 3.711281 | 22.11923476 | Lone star tick rhabdovirus | 1756186 | Viruses | Viruses | 66.6 | 5.23e-9 | NR | YP_010796342.1 | 1756186 | g21595 | 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 |
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);;