contig_metadata
19 rows where bioproject = "PRJNA278119" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 371042 | 371042 | PRJNA278119_P_NODE_141_length_2279_cov_5.303139_g106_i0 | PRJNA278119 | 141 | 2279 | 5.303139 | 120.85853781 | Jakapalmivirus bremiae | 3429992 | Viruses | Viruses | 3938 | 0 | NTclustered | gi|2842965605|gb|PQ150640.1| | 2719804 | g106 | i0 | 98.015 | 5.65247915752523 | 2267 | 45 | 99 | 0 | 1 | 2267 | 2267 | 1 | MAG: Bremia lactucae associated splipalmivirus 1 isolate Hebei_059 segment RNA2 RNA-dependent RNA polymerase gene, complete cds | blastn | 12882 | 3938 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Jakapalmivirus | Jakapalmivirus bremiae | ||
| 1645784 | 1645784 | PRJNA278119_P_NODE_102_length_2542_cov_5.442439_g74_i0 | PRJNA278119 | 102 | 2542 | 5.442439 | 138.34679938 | Downy mildew lesion associated splipalmivirus 2 | 2719503 | Viruses | Viruses | 4423 | 0 | NTclustered | gi|2284931862|gb|OM514591.1| | 2719503 | g74 | i0 | 98.296 | 13.7824547600315 | 2524 | 43 | 99 | 0 | 19 | 2542 | 2530 | 7 | MAG: Plasmopara viticola lesion associated narnavirus 2 isolate YSCLS230 RNA-dependent RNA polymerase gene, complete cds | blastn | 35035 | 4423 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Downy mildew lesion associated splipalmivirus 2 | ||
| 3609469 | 3609469 | PRJNA278119_P_NODE_6723_length_459_cov_4.141463_g6477_i0 | PRJNA278119 | 6723 | 459 | 4.141463 | 19.00931517 | Botybirnavirus | 1918013 | Viruses | Viruses | 385 | 3.87e-102 | NTclustered | gi|1787383272|gb|MN552386.1| | 2689573 | g6477 | i0 | 90.69 | 1.2636165577342 | 290 | 25 | 63 | 2 | 5 | 294 | 510 | 223 | Plasmopara viticola lesion associated botybirna 1 isolate DMG-B_DN55388 segment RNA1 RNA dependent RNA polymerase gene, complete cds | blastn | 580 | 385 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Botybirnaviridae | Botybirnavirus | Botybirnavirus shichi | ||
| 4198263 | 4198263 | PRJNA278119_P_NODE_19884_length_225_cov_0.886364_g19635_i0 | PRJNA278119 | 19884 | 225 | 0.886364 | 1.994319 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 322 | 1.38e-83 | NTclustered | gi|2320142594|gb|ON585070.1| | 2808997 | g19635 | i0 | 92.444 | 15.08 | 225 | 17 | 100 | 0 | 1 | 225 | 911 | 687 | MAG: Botourmiaviridae sp. isolate PMS13_Contig505 RNA-dependent RNA polymerase gene, complete cds | blastn | 3393 | 322 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 4198395 | 4198395 | PRJNA278119_P_NODE_28964_length_184_cov_1.155556_g28715_i0 | PRJNA278119 | 28964 | 184 | 1.155556 | 2.12622304 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 185 | 1.4799999999999998e-42 | NTclustered | gi|2320142588|gb|ON585067.1| | 2808997 | g28715 | i0 | 84.865 | 2.85326086956522 | 185 | 26 | 100 | 2 | 1 | 184 | 901 | 718 | MAG: Botourmiaviridae sp. isolate PMS2_Contig844 RNA-dependent RNA polymerase gene, complete cds | blastn | 525 | 185 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 4198482 | 4198482 | PRJNA278119_P_NODE_3564_length_642_cov_2.097808_g3328_i0 | PRJNA278119 | 3564 | 642 | 2.097808 | 13.46792736 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 715 | 0 | NTclustered | gi|2396040045|gb|ON813024.1| | 2808997 | g3328 | i0 | 86.801 | 32.1105919003115 | 644 | 81 | 100 | 4 | 1 | 642 | 1465 | 824 | MAG: Botourmiaviridae sp. isolate TIGMIC_38, complete genome | blastn | 20615 | 715 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 4198717 | 4198717 | PRJNA278119_P_NODE_9244_length_387_cov_1.692308_g8997_i0 | PRJNA278119 | 9244 | 387 | 1.692308 | 6.54923196 | Pseudomonas phage phiZ98 | 2981625 | Viruses | Viruses | 625 | 1.7399999999999994e-174 | NTclustered | gi|2316771794|gb|ON960066.1| | 2981625 | g8997 | i0 | 95.855 | 1.99741602067183 | 386 | 16 | 99 | 0 | 2 | 387 | 1675 | 1290 | Pseudomonas phage phiZ98 segment S, complete sequence | blastn | 773 | 625 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Cystovirus | Pseudomonas phage phiZ98 | ||
| 5474506 | 5474506 | PRJNA278119_P_NODE_1765_length_926_cov_15.140251_g1574_i0 | PRJNA278119 | 1765 | 926 | 15.140251 | 140.19872426 | Jakapalmivirus bremiae | 3429992 | Viruses | Viruses | 1574 | 0 | NTclustered | gi|2565320477|gb|OR060921.1| | 2719804 | g1574 | i0 | 97.91 | 1.88552915766739 | 909 | 19 | 98 | 0 | 18 | 926 | 3 | 911 | Bremia lactucae associated splipalmivirus 1 hypothetical protein gene, complete cds | blastn | 1746 | 1574 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Jakapalmivirus | Jakapalmivirus bremiae | ||
| 5474622 | 5474622 | PRJNA278119_P_NODE_25805_length_194_cov_1.793103_g25556_i0 | PRJNA278119 | 25805 | 194 | 1.793103 | 3.47861982 | Sopafab virus | 3131770 | Viruses | Viruses | 263 | 7.11e-66 | NTclustered | gi|2717323354|gb|PP174071.1| | 3131770 | g25556 | i0 | 91.414 | 17.2268041237113 | 198 | 8 | 99 | 9 | 2 | 194 | 3042 | 3235 | MAG: Sopafab virus isolate SP1C_k141_220867 genomic sequence | blastn | 3342 | 263 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopafab virus | |||||
| 14400018 | 14400018 | PRJNA278119_P_NODE_13392_length_306_cov_1.011673_g13144_i0 | PRJNA278119 | 13392 | 306 | 1.011673 | 3.09571938 | Pseudomonas phage phiZ98 | 2981625 | Viruses | Viruses | 477 | 3.969999999999999e-130 | NTclustered | gi|2316771794|gb|ON960066.1| | 2981625 | g13144 | i0 | 94.771 | 1.99346405228758 | 306 | 16 | 100 | 0 | 1 | 306 | 2204 | 2509 | Pseudomonas phage phiZ98 segment S, complete sequence | blastn | 610 | 477 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Cystovirus | Pseudomonas phage phiZ98 | ||
| 14400216 | 14400216 | PRJNA278119_P_NODE_26892_length_191_cov_0.971831_g26643_i0 | PRJNA278119 | 26892 | 191 | 0.971831 | 1.85619721 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 185 | 1.5499999999999998e-42 | NTclustered | gi|2320142604|gb|ON585075.1| | 2808997 | g26643 | i0 | 89.726 | 0.764397905759162 | 146 | 13 | 76 | 2 | 1 | 145 | 1760 | 1616 | MAG: Botourmiaviridae sp. isolate PMS8_Contig168 RNA-dependent RNA polymerase gene, complete cds | blastn | 146 | 185 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 15674151 | 15674151 | PRJNA278119_P_NODE_41533_length_165_cov_0.896552_g41284_i0 | PRJNA278119 | 41533 | 165 | 0.896552 | 1.4793108 | Hulunbuir Botou tick virus 7 | 2972067 | Viruses | Viruses | 267 | 4.53e-67 | NTclustered | gi|2819063280|gb|PQ150492.1| | 2972067 | g41284 | i0 | 95.758 | 5.46060606060606 | 165 | 7 | 100 | 0 | 1 | 165 | 1900 | 1736 | MAG: Hulunbuir Botou tick virus 7 isolate Hebei_059 genomic sequence | blastn | 901 | 267 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Hulunbuir Botou tick virus 7 | |||
| 17636453 | 17636453 | PRJNA278119_P_NODE_34394_length_169_cov_1.733333_g34145_i0 | PRJNA278119 | 34394 | 169 | 1.733333 | 2.92933277 | Botybirnavirus | 1918013 | Viruses | Viruses | 145 | 2.26e-30 | NTclustered | gi|1787383272|gb|MN552386.1| | 2689573 | g34145 | i0 | 82.558 | 2.03550295857988 | 172 | 23 | 100 | 7 | 1 | 169 | 153 | 320 | Plasmopara viticola lesion associated botybirna 1 isolate DMG-B_DN55388 segment RNA1 RNA dependent RNA polymerase gene, complete cds | blastn | 344 | 145 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Botybirnaviridae | Botybirnavirus | Botybirnavirus shichi | ||
| 18222864 | 18222864 | PRJNA278119_P_NODE_21855_length_212_cov_1.116564_g21606_i0 | PRJNA278119 | 21855 | 212 | 1.116564 | 2.36711568 | Grapevine wood holobiome associated mycobunyavirales-like virus 2 | 3381423 | Viruses | Viruses | 353 | 4.56e-93 | NTclustered | gi|2853283008|gb|PQ508375.1| | 3381423 | g21606 | i0 | 96.698 | 1 | 212 | 7 | 100 | 0 | 1 | 212 | 165 | 376 | Grapevine wood holobiome associated mycobunyavirales-like virus 2 isolate c22 segment RNA3 nucleocapsid gene, complete cds | blastn | 212 | 353 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Grapevine wood holobiome associated mycobunyavirales-like virus 2 | ||||
| 27200292 | 27200292 | PRJNA278119_P_NODE_26142_length_193_cov_1.444444_g25893_i0 | PRJNA278119 | 26142 | 193 | 1.444444 | 2.78777692 | Erysiphe necator associated gammapartitivirus 2 | 2742541 | Viruses | Viruses | 110 | 1.33e-26 | NR | QKK35394.1 | 2742541 | g25893 | i0 | 82.3 | 0.963730569948187 | 62 | 11 | 96.4 | 0 | 191 | 6 | 60 | 121 | QKK35394.1 capsid protein [Erysiphe necator associated gammapartitivirus 2] | diamond | 186 | 110 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Gammapartitivirus | Erysiphe necator associated gammapartitivirus 2 | ||
| 31717578 | 31717578 | PRJNA278119_P_NODE_25017_length_198_cov_0.973154_g24768_i0 | PRJNA278119 | 25017 | 198 | 0.973154 | 1.92684492 | Plasmopara viticola lesion associated mononegaambi virus 9 | 2692021 | Viruses | Viruses | 118 | 4.16e-29 | NR | YP_010798441.1 | 2692021 | g24768 | i0 | 84.4 | 0.96969696969697 | 64 | 10 | 97 | 0 | 2 | 193 | 1871 | 1934 | YP_010798441.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated mononegaambi virus 9] | diamond | 192 | 118 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Mymonaviridae | Penicillimonavirus | Penicillimonavirus etaplasmoparae | ||
| 31812470 | 31812470 | PRJNA278119_P_NODE_19697_length_226_cov_1.124294_g19448_i0 | PRJNA278119 | 19697 | 226 | 1.124294 | 2.54090444 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 56.6 | 3.82e-7 | NR | WAK77973.1 | 2808997 | g19448 | i0 | 87.1 | 0.411504424778761 | 31 | 4 | 41.2 | 0 | 1 | 93 | 482 | 512 | WAK77973.1 MAG: RNA-dependent RNA polymerase [Botourmiaviridae sp.] | diamond | 93 | 56.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 32589624 | 32589624 | PRJNA278119_P_NODE_33519_length_171_cov_1.975410_g33270_i0 | PRJNA278119 | 33519 | 171 | 1.97541 | 3.3779511 | Scleroulivirus | 2560226 | Viruses | Viruses | 67.4 | 2.89e-11 | NR | YP_010800270.1 | 2686549 | g33270 | i0 | 84.6 | 2.05263157894737 | 39 | 5 | 68.4 | 1 | 1 | 117 | 597 | 634 | YP_010800270.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated ourmia-like virus 76] | diamond | 351 | 67.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Scleroulivirus | Scleroulivirus omicronplasmoparae | ||
| 32809817 | 32809817 | PRJNA278119_P_NODE_14160_length_293_cov_1.491803_g13911_i0 | PRJNA278119 | 14160 | 293 | 1.491803 | 4.37098279 | Gammapartitivirus | 1511811 | Viruses | Viruses | 59.7 | 5.61e-8 | NR | AYP71820.1 | 358008 | g13911 | i0 | 41 | 1.69965870307167 | 83 | 49 | 85 | 0 | 45 | 293 | 48 | 130 | AYP71820.1 hypothetical protein [Aspergillus ochraceous virus] | diamond | 498 | 59.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Gammapartitivirus | Gammapartitivirus aspergilli |
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);;