contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJEB64798" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26716878 | 26716878 | PRJEB64798_P_NODE_45941_length_290_cov_3.116183_g44176_i0 | PRJEB64798 | 45941 | 290 | 3.116183 | 9.0369307 | Bunyaviricetes sp. | 3240187 | Viruses | Viruses | 124 | 1.45e-30 | NR | XKB76362.1 | 3240187 | g44176 | i0 | 59.1 | 0.962068965517241 | 93 | 38 | 96.2 | 0 | 284 | 6 | 1034 | 1126 | XKB76362.1 MAG: RNA-dependent RNA polymerase, partial [Bunyaviricetes sp.] | diamond | 279 | 124 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Bunyaviricetes sp. | |||||
| 26812240 | 26812240 | PRJEB64798_P_NODE_166341_length_180_cov_6.122137_g164575_i0 | PRJEB64798 | 166341 | 180 | 6.122137 | 11.0198466 | Fusarium culmorum yue-like virus 1 | 3233859 | Viruses | Viruses | 61.2 | 4.71e-9 | NR | XCO56027.1 | 3233859 | g164575 | i0 | 65.2 | 1.53333333333333 | 46 | 16 | 76.7 | 0 | 38 | 175 | 484 | 529 | XCO56027.1 MAG: putative RNA-dependent RNA polymerase [Fusarium culmorum yue-like virus 1] | diamond | 276 | 61.2 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | Fusarium culmorum yue-like virus 1 | |||
| 27033729 | 27033729 | PRJEB64798_P_NODE_203602_length_166_cov_5.794872_g201836_i0 | PRJEB64798 | 203602 | 166 | 5.794872 | 9.61948752 | Plasmopara viticola lesion associated mononegaambi virus 9 | 2692021 | Viruses | Viruses | 42.7 | 0.0118 | NR | WKE35292.1 | 2692021 | g201836 | i0 | 41.5 | 0.957831325301205 | 53 | 31 | 95.8 | 0 | 159 | 1 | 20 | 72 | WKE35292.1 hypothetical protein [Plasmopara viticola lesion associated mononegaambi virus 9] | diamond | 159 | 42.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Mymonaviridae | Penicillimonavirus | Penicillimonavirus etaplasmoparae | ||
| 27191584 | 27191584 | PRJEB64798_P_NODE_115822_length_208_cov_8.779874_g114056_i0 | PRJEB64798 | 115822 | 208 | 8.779874 | 18.26213792 | Penicillium discovirus | 2185132 | Viruses | Viruses | 64.3 | 3.39e-10 | NR | YP_010840287.1 | 2185132 | g114056 | i0 | 90.3 | 0.447115384615385 | 31 | 3 | 44.7 | 0 | 97 | 5 | 157 | 187 | YP_010840287.1 Nucleocapsid [Penicillium discovirus] | diamond | 93 | 64.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Discoviridae | Orthodiscovirus | Orthodiscovirus missouriense | ||
| 28265290 | 28265290 | PRJEB64798_P_NODE_153866_length_186_cov_7.481752_g152100_i0 | PRJEB64798 | 153866 | 186 | 7.481752 | 13.91605872 | Soybean thrips bunya-like virus 3 | 2802229 | Viruses | Viruses | 55.1 | 7.72e-7 | NR | QQX28936.1 | 2802229 | g152100 | i0 | 46.2 | 0.838709677419355 | 52 | 28 | 83.9 | 0 | 163 | 8 | 1085 | 1136 | QQX28936.1 RNA-dependent RNA polymerase [Soybean thrips bunya-like virus 3] | diamond | 156 | 55.1 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Soybean thrips bunya-like virus 3 | ||||
| 28423473 | 28423473 | PRJEB64798_P_NODE_137686_length_194_cov_11.393103_g135920_i0 | PRJEB64798 | 137686 | 194 | 11.393103 | 22.10261982 | Grapevine wood holobiome associated mononegaambi virus 2 | 3385176 | Viruses | Viruses | 46.6 | 8.36e-4 | NR | XLV09870.1 | 3385176 | g135920 | i0 | 73.3 | 0.463917525773196 | 30 | 8 | 46.4 | 0 | 11 | 100 | 345 | 374 | XLV09870.1 hypothetical protein [Grapevine wood holobiome associated mononegaambi virus 2] | diamond | 90 | 46.6 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Grapevine wood holobiome associated mononegaambi virus 2 | ||||
| 28455194 | 28455194 | PRJEB64798_P_NODE_234646_length_157_cov_3.222222_g232880_i0 | PRJEB64798 | 234646 | 157 | 3.222222 | 5.05888854 | Bunyaviricetes sp. | 3240187 | Viruses | Viruses | 53.5 | 1.74e-6 | NR | XKB76362.1 | 3240187 | g232880 | i0 | 57.1 | 0.936305732484076 | 49 | 21 | 93.6 | 0 | 152 | 6 | 1205 | 1253 | XKB76362.1 MAG: RNA-dependent RNA polymerase, partial [Bunyaviricetes sp.] | diamond | 147 | 53.5 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Bunyaviricetes sp. | |||||
| 28897019 | 28897019 | PRJEB64798_P_NODE_81528_length_214_cov_2.127273_g79762_i0 | PRJEB64798 | 81528 | 214 | 2.127273 | 4.55236422 | Spider peribunya-like virus 2 | 3067789 | Viruses | Viruses | 77.8 | 1.17e-14 | NR | WPR16587.1 | 3067789 | g79762 | i0 | 55.9 | 0.827102803738318 | 59 | 26 | 82.7 | 0 | 32 | 208 | 705 | 763 | WPR16587.1 MAG: RNA-dependent RNA polymerase [Spider peribunya-like virus 2] | diamond | 177 | 77.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Spider peribunya-like virus 2 | ||||
| 29054938 | 29054938 | PRJEB64798_P_NODE_136888_length_195_cov_3.205479_g135122_i0 | PRJEB64798 | 136888 | 195 | 3.205479 | 6.25068405 | Bunyaviricetes sp. | 3240187 | Viruses | Viruses | 54.7 | 1.2e-6 | NR | XKB76367.1 | 3240187 | g135122 | i0 | 43.3 | 1.03076923076923 | 67 | 34 | 96.9 | 1 | 193 | 5 | 1395 | 1461 | XKB76367.1 MAG: RNA-dependent RNA polymerase [Bunyaviricetes sp.] | diamond | 201 | 54.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Bunyaviricetes sp. | |||||
| 29213035 | 29213035 | PRJEB64798_P_NODE_47129_length_286_cov_3.004219_g45364_i0 | PRJEB64798 | 47129 | 286 | 3.004219 | 8.59206634 | Bunyaviricetes sp. | 3240187 | Viruses | Viruses | 53.9 | 7.36e-6 | NR | XKB76367.1 | 3240187 | g45364 | i0 | 48.8 | 0.451048951048951 | 43 | 22 | 45.1 | 0 | 281 | 153 | 1321 | 1363 | XKB76367.1 MAG: RNA-dependent RNA polymerase [Bunyaviricetes sp.] | diamond | 129 | 53.9 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Bunyaviricetes sp. | |||||
| 29363831 | 29363831 | PRJEB64798_P_NODE_210369_length_164_cov_16.426087_g208603_i0 | PRJEB64798 | 210369 | 164 | 16.426087 | 26.93878268 | Viruses | 10239 | Viruses | Viruses | 52 | 6.97e-6 | NR | UNI74171.1 | 2900456 | g208603 | i0 | 68.8 | 2.46951219512195 | 32 | 10 | 58.5 | 0 | 103 | 8 | 633 | 664 | UNI74171.1 MAG: RNA-dependent RNA polymerase [brine shrimp yue-like virus 4] | diamond | 405 | 52 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 4 | |||
| 29552896 | 29552896 | PRJEB64798_P_NODE_149710_length_188_cov_11.172662_g147944_i0 | PRJEB64798 | 149710 | 188 | 11.172662 | 21.00460456 | Ophiovirus | 88129 | Viruses | Viruses | 127 | 2.86e-32 | NR | UYL94508.1 | 2985702 | g147944 | i0 | 91.9 | 2.93617021276596 | 62 | 5 | 98.9 | 0 | 187 | 2 | 698 | 759 | UYL94508.1 MAG: RNA-dependent RNA polymerase [Leptosphaeria biglobosa negative single-stranded RNA virus 7] | diamond | 552 | 128 | 0.9921875 | Viruses | Orthornavirae | Negarnaviricota | Leptosphaeria biglobosa negative single-stranded RNA virus 7 | ||||||
| 30002354 | 30002354 | PRJEB64798_P_NODE_231471_length_158_cov_4.110092_g229705_i0 | PRJEB64798 | 231471 | 158 | 4.110092 | 6.49394536 | Phytophthora palustris bunya-like virus 11 | 2976276 | Viruses | Viruses | 74.3 | 8.47e-14 | NR | WAK73634.1 | 2976276 | g229705 | i0 | 68.6 | 0.968354430379747 | 51 | 16 | 96.8 | 0 | 158 | 6 | 895 | 945 | WAK73634.1 RNA-dependent RNA polymerase [Phytophthora palustris bunya-like virus 11] | diamond | 153 | 74.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Phytophthora palustris bunya-like virus 11 | ||||
| 30255342 | 30255342 | PRJEB64798_P_NODE_58732_length_254_cov_6.487805_g56967_i0 | PRJEB64798 | 58732 | 254 | 6.487805 | 16.4790247 | Freshwater macrophyte associated yue-like virus 1 | 2946074 | Viruses | Viruses | 108 | 4.16e-25 | NR | UQZ09611.1 | 2946074 | g56967 | i0 | 55.6 | 3.93307086614173 | 81 | 36 | 95.7 | 0 | 5 | 247 | 553 | 633 | UQZ09611.1 putative RNA-dependent RNA polymerase [Freshwater macrophyte associated yue-like virus 1] | diamond | 999 | 108 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | Freshwater macrophyte associated yue-like virus 1 | |||
| 30476282 | 30476282 | PRJEB64798_P_NODE_232313_length_158_cov_2.522936_g230547_i0 | PRJEB64798 | 232313 | 158 | 2.522936 | 3.98623888 | Curvularia pseudobrachyspora bunya-like virus 1 | 3391148 | Viruses | Viruses | 56.6 | 1.34e-7 | NR | XMD53699.1 | 3391148 | g230547 | i0 | 49 | 1.86075949367089 | 49 | 25 | 93 | 0 | 2 | 148 | 206 | 254 | XMD53699.1 nucleocapsid protein [Curvularia pseudobrachyspora bunya-like virus 1] | diamond | 294 | 56.6 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Curvularia pseudobrachyspora bunya-like virus 1 | ||||
| 30792066 | 30792066 | PRJEB64798_P_NODE_239054_length_155_cov_7.358491_g237288_i0 | PRJEB64798 | 239054 | 155 | 7.358491 | 11.40566105 | Penicillium glabrum negative-stranded RNA virus 1 | 2587552 | Viruses | Viruses | 97.8 | 4.47e-22 | NR | YP_010798256.1 | 2587552 | g237288 | i0 | 98 | 1.89677419354839 | 49 | 1 | 94.8 | 0 | 153 | 7 | 1134 | 1182 | YP_010798256.1 MAG: RNA-dependent RNA polymerase [Penicillium glabrum negative-stranded RNA virus 1] | diamond | 294 | 97.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Mymonaviridae | Penicillimonavirus | Penicillimonavirus betapenicillii | ||
| 31013322 | 31013322 | PRJEB64798_P_NODE_9955_length_633_cov_7.150685_g8469_i0 | PRJEB64798 | 9955 | 633 | 7.150685 | 45.26383605 | brine shrimp yue-like virus 2 | 2900454 | Viruses | Viruses | 75.9 | 4.48e-12 | NR | UNI74148.1 | 2900454 | g8469 | i0 | 27.6 | 0.824644549763033 | 174 | 126 | 82.5 | 0 | 631 | 110 | 148 | 321 | UNI74148.1 MAG: hypothetical protein [brine shrimp yue-like virus 2] | diamond | 522 | 75.9 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 2 | |||
| 31582473 | 31582473 | PRJEB64798_P_NODE_161196_length_183_cov_1.686567_g159430_i0 | PRJEB64798 | 161196 | 183 | 1.686567 | 3.08641761 | Halophytophthora RNA virus 8 | 2717550 | Viruses | Viruses | 64.3 | 4.24e-10 | NR | QLF99175.1 | 2717550 | g159430 | i0 | 64.6 | 0.786885245901639 | 48 | 17 | 78.7 | 0 | 144 | 1 | 1409 | 1456 | QLF99175.1 RNA-dependent RNA polymerase [Halophytophthora RNA virus 8] | diamond | 144 | 64.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Halophytophthora RNA virus 8 | ||||
| 31701951 | 31701951 | PRJEB64798_P_NODE_129477_length_198_cov_7.651007_g127711_i0 | PRJEB64798 | 129477 | 198 | 7.651007 | 15.14899386 | Penicillimonavirus | 2842949 | Viruses | Viruses | 48.5 | 1.89e-4 | NR | YP_010798432.1 | 2692016 | g127711 | i0 | 62.5 | 0.893939393939394 | 32 | 12 | 48.5 | 0 | 193 | 98 | 878 | 909 | YP_010798432.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated mononegaambi virus 4] | diamond | 177 | 48.9 | 0.991820040899796 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Mymonaviridae | Penicillimonavirus | Penicillimonavirus betaplasmoparae | ||
| 31740480 | 31740480 | PRJEB64798_P_NODE_88257_length_212_cov_9.312883_g86491_i0 | PRJEB64798 | 88257 | 212 | 9.312883 | 19.74331196 | Fox fecal bunyavirus | 1504567 | Viruses | Viruses | 52 | 7.66e-6 | NR | AIB06817.1 | 1504567 | g86491 | i0 | 39.4 | 1.79716981132075 | 66 | 40 | 93.4 | 0 | 212 | 15 | 6 | 71 | AIB06817.1 nucleocapsid protein, partial [Fox fecal bunyavirus] | diamond | 381 | 52 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Peribunyaviridae | Fox fecal bunyavirus | |||
| 31765143 | 31765143 | PRJEB64798_P_NODE_134197_length_196_cov_6.176871_g132431_i0 | PRJEB64798 | 134197 | 196 | 6.176871 | 12.10666716 | Yuyuevirus | 2508253 | Viruses | Viruses | 62 | 3.28e-9 | NR | YP_009330274.1 | 1922663 | g132431 | i0 | 45.5 | 2.02040816326531 | 66 | 34 | 98 | 1 | 1 | 192 | 737 | 802 | YP_009330274.1 RNA-dependent RNA polymerase [Beihai sesarmid crab virus 3] | diamond | 396 | 62 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | Yuyuevirus | Yuyuevirus beihaiense | ||
| 31898642 | 31898642 | PRJEB64798_P_NODE_168037_length_179_cov_13.592308_g166271_i0 | PRJEB64798 | 168037 | 179 | 13.592308 | 24.33023132 | Grapevine wood holobiome associated mycobunyavirales-like virus 1 | 3381422 | Viruses | Viruses | 100 | 8.67e-24 | NR | XKM51330.1 | 3381422 | g166271 | i0 | 77.6 | 0.972067039106145 | 58 | 13 | 97.2 | 0 | 2 | 175 | 231 | 288 | XKM51330.1 nucleocapsid [Grapevine wood holobiome associated mycobunyavirales-like virus 1] | diamond | 174 | 100 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Grapevine wood holobiome associated mycobunyavirales-like virus 1 |
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);;