contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA781196" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13513132 | 13513132 | PRJNA781196_P_NODE_38911_length_286_cov_1.830986_g38534_i0 | PRJNA781196 | 38911 | 286 | 1.830986 | 5.23661996 | Hulunbuir tick virus 1 | 2972183 | Viruses | Viruses | 172 | 2.66e-47 | NR | UYL95332.1 | 2972183 | g38534 | i0 | 83.2 | 0.996503496503496 | 95 | 16 | 99.7 | 0 | 286 | 2 | 3098 | 3192 | UYL95332.1 MAG: polyprotein [Hulunbuir tick virus 1] | diamond | 285 | 172 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Hulunbuir tick virus 1 | |||
| 26610066 | 26610066 | PRJNA781196_P_NODE_10321_length_499_cov_1.730047_g9945_i0 | PRJNA781196 | 10321 | 499 | 1.730047 | 8.63293453 | Exserohilum turcicum hypovirus 1 | 3229025 | Viruses | Viruses | 217 | 5.9499999999999995e-62 | NR | XBY85566.1 | 3229025 | g9945 | i0 | 62 | 1.95991983967936 | 163 | 61 | 98 | 1 | 3 | 491 | 2615 | 2776 | XBY85566.1 MAG: polyprotein [Exserohilum turcicum hypovirus 1] | diamond | 978 | 217 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Hypovirus | Exserohilum turcicum hypovirus 1 | ||
| 26641939 | 26641939 | PRJNA781196_P_NODE_40561_length_281_cov_1.500000_g40184_i0 | PRJNA781196 | 40561 | 281 | 1.5 | 4.215 | Pithovirus LCDPAC | 2506601 | Viruses | Viruses | 50.8 | 2.85e-5 | NR | QBK84922.1 | 2506601 | g40184 | i0 | 45.3 | 0.683274021352313 | 64 | 32 | 65.1 | 2 | 95 | 277 | 12 | 75 | QBK84922.1 MAG: hypothetical protein LCDPAC02_01210 [Pithovirus LCDPAC02] | diamond | 192 | 50.8 | 1 | Viruses | Pithoviruses | Pithovirus LCDPAC02 | |||||||
| 27274819 | 27274819 | PRJNA781196_P_NODE_43183_length_273_cov_0.975000_g42806_i0 | PRJNA781196 | 43183 | 273 | 0.975 | 2.66175 | Microcystis phage Mel-JY | 3126654 | Viruses | Viruses | 75.1 | 1.14e-13 | NR | WWT39610.1 | 3126654 | g42806 | i0 | 42 | 0.967032967032967 | 88 | 51 | 96.7 | 0 | 271 | 8 | 160 | 247 | WWT39610.1 hypothetical protein [Microcystis phage Mel-JY03] | diamond | 264 | 75.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Microcystis phage Mel-JY03 | |||||
| 27780189 | 27780189 | PRJNA781196_P_NODE_29884_length_321_cov_1.092742_g29507_i0 | PRJNA781196 | 29884 | 321 | 1.092742 | 3.50770182 | Dracophyllum associated narna-like virus 59 | 3066895 | Viruses | Viruses | 130 | 4.79e-36 | NR | WPR17262.1 | 3066895 | g29507 | i0 | 56.3 | 0.962616822429907 | 103 | 45 | 96.3 | 0 | 6 | 314 | 43 | 145 | WPR17262.1 MAG: RNA-dependent RNA polymerase, partial [Dracophyllum associated narna-like virus 59] | diamond | 309 | 130 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Dracophyllum associated narna-like virus 59 | |||
| 28127476 | 28127476 | PRJNA781196_P_NODE_32125_length_311_cov_1.105042_g31748_i0 | PRJNA781196 | 32125 | 311 | 1.105042 | 3.43668062 | Barrevirus sp. | 2487763 | Viruses | Viruses | 47.8 | 0.00102 | NR | AYV77273.1 | 2487763 | g31748 | i0 | 23.7 | 0.935691318327974 | 97 | 72 | 93.6 | 1 | 295 | 5 | 9 | 103 | AYV77273.1 MAG: START domain containing protein [Barrevirus sp.] | diamond | 291 | 47.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Barrevirus sp. | |||
| 28389283 | 28389283 | PRJNA781196_P_NODE_24826_length_346_cov_1.142857_g24449_i0 | PRJNA781196 | 24826 | 346 | 1.142857 | 3.95428522 | Wolframvirales | 2732502 | Viruses | Viruses | 58.5 | 1.92e-7 | NR | WNA22205.1 | 2719492 | g24449 | i0 | 44.1 | 1.8728323699422 | 59 | 33 | 51.2 | 0 | 11 | 187 | 60 | 118 | WNA22205.1 MAG: hypothetical protein [Downy mildew lesion associated splipalmivirus 1] | diamond | 648 | 58.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Downy mildew lesion associated splipalmivirus 1 | ||
| 28515714 | 28515714 | PRJNA781196_P_NODE_38467_length_288_cov_1.088372_g38090_i0 | PRJNA781196 | 38467 | 288 | 1.088372 | 3.13451136 | Lispiviridae | 2501987 | Viruses | Viruses | 114 | 1.33e-27 | NR | UNI74075.1 | 2900377 | g38090 | i0 | 53.2 | 2.95833333333333 | 94 | 44 | 97.9 | 0 | 282 | 1 | 135 | 228 | UNI74075.1 MAG: hypothetical protein [brine shrimp arlivirus 2] | diamond | 852 | 115 | 0.991304347826087 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsasecalis | ||
| 28569358 | 28569358 | PRJNA781196_P_NODE_57407_length_248_cov_0.891429_g57030_i0 | PRJNA781196 | 57407 | 248 | 0.891429 | 2.21074392 | Poaceae Liege nepovirus A | 2822470 | Viruses | Viruses | 121 | 9.71e-30 | NR | YP_010840366.1 | 2822470 | g57030 | i0 | 68.4 | 0.919354838709677 | 76 | 24 | 91.9 | 0 | 242 | 15 | 1177 | 1252 | YP_010840366.1 polyprotein [Poaceae Liege nepovirus A] | diamond | 228 | 121 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus poaceae | ||
| 28578901 | 28578901 | PRJNA781196_P_NODE_60807_length_246_cov_0.901734_g60430_i0 | PRJNA781196 | 60807 | 246 | 0.901734 | 2.21826564 | Chuvivirus | 2842604 | Viruses | Viruses | 122 | 1.69e-30 | NR | WET19887.1 | 2842604 | g60430 | i0 | 69.1 | 1.97560975609756 | 81 | 25 | 98.8 | 0 | 246 | 4 | 281 | 361 | WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1] | diamond | 486 | 122 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Chuvivirus | ||
| 28948523 | 28948523 | PRJNA781196_P_NODE_14128_length_436_cov_3.181818_g13751_i0 | PRJNA781196 | 14128 | 436 | 3.181818 | 13.87272648 | Sobelivirales sp. | 2809868 | Viruses | Viruses | 77.4 | 1.84e-13 | NR | WRQ64935.1 | 2809868 | g13751 | i0 | 40 | 0.825688073394495 | 120 | 65 | 79.8 | 5 | 2 | 349 | 259 | 375 | WRQ64935.1 structural protein, partial [Sobelivirales sp.] | diamond | 360 | 77.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Sobelivirales sp. | ||||
| 29232620 | 29232620 | PRJNA781196_P_NODE_62209_length_245_cov_0.906977_g61832_i0 | PRJNA781196 | 62209 | 245 | 0.906977 | 2.22209365 | Poaceae Liege nepovirus A | 2822470 | Viruses | Viruses | 122 | 3.66e-30 | NR | YP_010840366.1 | 2822470 | g61832 | i0 | 74.7 | 1.01632653061224 | 83 | 19 | 99.2 | 2 | 2 | 244 | 1049 | 1131 | YP_010840366.1 polyprotein [Poaceae Liege nepovirus A] | diamond | 249 | 122 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus poaceae | ||
| 29516506 | 29516506 | PRJNA781196_P_NODE_59710_length_247_cov_0.896552_g59333_i0 | PRJNA781196 | 59710 | 247 | 0.896552 | 2.21448344 | Durnavirales sp. | 2809355 | Viruses | Viruses | 53.9 | 4.28e-6 | NR | WRQ64726.1 | 2809355 | g59333 | i0 | 36.3 | 1.94331983805668 | 80 | 50 | 96 | 1 | 242 | 6 | 98 | 177 | WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.] | diamond | 480 | 53.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Durnavirales sp. | ||||
| 29705633 | 29705633 | PRJNA781196_P_NODE_33650_length_305_cov_1.008621_g33273_i0 | PRJNA781196 | 33650 | 305 | 1.008621 | 3.07629405 | Hulunbuir tick virus 1 | 2972183 | Viruses | Viruses | 179 | 9.4e-50 | NR | UYL95332.1 | 2972183 | g33273 | i0 | 75.2 | 0.99344262295082 | 101 | 25 | 99.3 | 0 | 2 | 304 | 3386 | 3486 | UYL95332.1 MAG: polyprotein [Hulunbuir tick virus 1] | diamond | 303 | 179 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Hulunbuir tick virus 1 | |||
| 30148071 | 30148071 | PRJNA781196_P_NODE_31572_length_313_cov_1.300000_g31195_i0 | PRJNA781196 | 31572 | 313 | 1.3 | 4.069 | Sobelivirales sp. | 2809868 | Viruses | Viruses | 129 | 3.05e-33 | NR | WRQ64934.1 | 2809868 | g31195 | i0 | 63.1 | 0.987220447284345 | 103 | 37 | 98.7 | 1 | 312 | 4 | 147 | 248 | WRQ64934.1 RNA-dependent RNA polymerase [Sobelivirales sp.] | diamond | 309 | 129 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Sobelivirales sp. | ||||
| 30179780 | 30179780 | PRJNA781196_P_NODE_58072_length_248_cov_0.891429_g57695_i0 | PRJNA781196 | 58072 | 248 | 0.891429 | 2.21074392 | Riboviria sp. | 2585031 | Viruses | Viruses | 80.9 | 1.51e-15 | NR | WKV33085.1 | 2585031 | g57695 | i0 | 50 | 2.9758064516129 | 82 | 39 | 99.2 | 1 | 246 | 1 | 126 | 205 | WKV33085.1 MAG: RNA-dependent RNA polymerase, partial [Riboviria sp.] | diamond | 738 | 80.9 | 1 | Viruses | Riboviria sp. | ||||||||
| 30338343 | 30338343 | PRJNA781196_P_NODE_51592_length_252_cov_0.871508_g51215_i0 | PRJNA781196 | 51592 | 252 | 0.871508 | 2.19620016 | Beet ringspot virus | 191547 | Viruses | Viruses | 134 | 1.69e-34 | NR | NP_734032.2 | 191547 | g51215 | i0 | 75.6 | 1.95238095238095 | 82 | 20 | 97.6 | 0 | 2 | 247 | 451 | 532 | NP_734032.2 NTP-binding domain [Beet ringspot virus] | diamond | 492 | 134 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus betae | ||
| 30369956 | 30369956 | PRJNA781196_P_NODE_6472_length_611_cov_3.178439_g6101_i0 | PRJNA781196 | 6472 | 611 | 3.178439 | 19.42026229 | Heterosigma akashiwo virus | 97195 | Viruses | Viruses | 114 | 1.83e-26 | NR | YP_009507458.1 | 97195 | g6101 | i0 | 38.4 | 0.869067103109656 | 177 | 102 | 84.5 | 4 | 1 | 516 | 129 | 303 | YP_009507458.1 putative RNA methylase [Heterosigma akashiwo virus 01] | diamond | 531 | 114 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Raphidovirus | Raphidovirus japonicum | ||
| 30969909 | 30969909 | PRJNA781196_P_NODE_19934_length_378_cov_1.534426_g19557_i0 | PRJNA781196 | 19934 | 378 | 1.534426 | 5.80013028 | Sobelivirales sp. | 2809868 | Viruses | Viruses | 145 | 3.79e-39 | NR | WRQ64935.1 | 2809868 | g19557 | i0 | 61.7 | 0.952380952380952 | 120 | 44 | 94.4 | 2 | 17 | 373 | 114 | 232 | WRQ64935.1 structural protein, partial [Sobelivirales sp.] | diamond | 360 | 145 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Sobelivirales sp. | ||||
| 31886756 | 31886756 | PRJNA781196_P_NODE_817_length_1459_cov_3.401876_g689_i0 | PRJNA781196 | 817 | 1459 | 3.401876 | 49.63337084 | Hebei hypo-like virus 3 | 3401102 | Viruses | Viruses | 437 | 1.2699999999999999e-133 | NR | XHY85258.1 | 3401102 | g689 | i0 | 64.2 | 1.99657299520219 | 327 | 112 | 66.2 | 2 | 1459 | 494 | 1722 | 2048 | XHY85258.1 MAG: polyprotein, partial [Hebei hypo-like virus 3] | diamond | 2913 | 437 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Hebei hypo-like virus 3 | |||
| 32361662 | 32361662 | PRJNA781196_P_NODE_39979_length_283_cov_1.414286_g39602_i0 | PRJNA781196 | 39979 | 283 | 1.414286 | 4.00242938 | Tomato black ring virus | 12275 | Viruses | Viruses | 150 | 1.18e-39 | NR | NP_958814.1 | 12275 | g39602 | i0 | 79.6 | 1.96113074204947 | 93 | 19 | 98.6 | 0 | 281 | 3 | 1123 | 1215 | NP_958814.1 polyprotein [Tomato black ring virus] | diamond | 555 | 150 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus nigranuli |
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);;