contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA493827" and tax_phylum = "Lenarviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10676527 | 10676527 | PRJNA493827_P_NODE_3949_length_2170_cov_6.212685_g3344_i0 | PRJNA493827 | 3949 | 2170 | 6.212685 | 134.8152645 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 308 | 4.530000000000001e-91 | NR | UJQ92477.1 | 2809572 | g3344 | i0 | 39.2 | 1.94792626728111 | 480 | 259 | 63.7 | 13 | 234 | 1616 | 24 | 489 | UJQ92477.1 MAG: putative RNA-dependent RNA polymerase, partial [Mitoviridae sp.] | diamond | 4227 | 308 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 26601758 | 26601758 | PRJNA493827_P_NODE_3581_length_2293_cov_6.705405_g3015_i0 | PRJNA493827 | 3581 | 2293 | 6.705405 | 153.75493665 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 280 | 1.5e-79 | NR | UJQ92439.1 | 2809572 | g3015 | i0 | 38.8 | 1.22982991713912 | 477 | 258 | 59.9 | 13 | 2077 | 704 | 29 | 490 | UJQ92439.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.] | diamond | 2820 | 280 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 26665009 | 26665009 | PRJNA493827_P_NODE_183441_length_251_cov_1.730337_g181243_i0 | PRJNA493827 | 183441 | 251 | 1.730337 | 4.34314587 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 62.8 | 3.63e-9 | NR | QYV43037.1 | 2583949 | g181243 | i0 | 50 | 2.41434262948207 | 66 | 32 | 77.7 | 1 | 3 | 197 | 139 | 204 | QYV43037.1 MAG: RNA-dependent RNA polymerase [Narnaviridae sp.] | diamond | 606 | 62.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 26760100 | 26760100 | PRJNA493827_P_NODE_108021_length_329_cov_1.449219_g105823_i0 | PRJNA493827 | 108021 | 329 | 1.449219 | 4.76793051 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 113 | 1.39e-26 | NR | UJQ92566.1 | 2809572 | g105823 | i0 | 55.8 | 0.78419452887538 | 86 | 38 | 78.4 | 0 | 273 | 16 | 2 | 87 | UJQ92566.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.] | diamond | 258 | 113 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 26965884 | 26965884 | PRJNA493827_P_NODE_221842_length_243_cov_0.905882_g219644_i0 | PRJNA493827 | 221842 | 243 | 0.905882 | 2.20129326 | Leviviricetes | 2842243 | Viruses | Viruses | 112 | 3.5700000000000005e-27 | NR | URG15825.1 | 2027243 | g219644 | i0 | 63 | 3 | 81 | 30 | 100 | 0 | 243 | 1 | 98 | 178 | URG15825.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 729 | 113 | 0.991150442477876 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 27029203 | 27029203 | PRJNA493827_P_NODE_76122_length_396_cov_1.897833_g73924_i0 | PRJNA493827 | 76122 | 396 | 1.897833 | 7.51541868 | Viruses | 10239 | Viruses | Viruses | 79.7 | 2.36e-14 | NR | QOW97241.1 | 2784741 | g73924 | i0 | 44.1 | 1.58333333333333 | 93 | 52 | 70.5 | 0 | 107 | 385 | 300 | 392 | QOW97241.1 RNA-dependent RNA polymerase [Mito-like picolinusvirus] | diamond | 627 | 80.1 | 0.995006242197254 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Mito-like picolinusvirus | |||
| 27361449 | 27361449 | PRJNA493827_P_NODE_122483_length_309_cov_1.101695_g120285_i0 | PRJNA493827 | 122483 | 309 | 1.101695 | 3.40423755 | ssRNA phage Gerhypos.3_19 | 2786292 | Viruses | Viruses | 58.9 | 1.6e-7 | NR | YP_010769541.1 | 2786292 | g120285 | i0 | 34.7 | 0.922330097087379 | 95 | 48 | 92.2 | 2 | 285 | 1 | 225 | 305 | YP_010769541.1 maturation protein [ssRNA phage Gerhypos.3_19] | diamond | 285 | 58.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Mihkrovirus | Mihkrovirus soladaptatum | ||
| 27519231 | 27519231 | PRJNA493827_P_NODE_238123_length_229_cov_2.750000_g235924_i0 | PRJNA493827 | 238123 | 229 | 2.75 | 6.2975 | Hangzhou atkins-like virus 2 | 3028992 | Viruses | Viruses | 90.1 | 6.42e-19 | NR | WEU70907.1 | 3028992 | g235924 | i0 | 58.3 | 2.77729257641921 | 72 | 30 | 94.3 | 0 | 13 | 228 | 246 | 317 | WEU70907.1 MAG: RNA-dependent RNA polymerase [Hangzhou atkins-like virus 2] | diamond | 636 | 90.1 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Atkinsviridae | Hangzhou atkins-like virus 2 | |||
| 27677376 | 27677376 | PRJNA493827_P_NODE_40184_length_575_cov_1.946215_g38004_i0 | PRJNA493827 | 40184 | 575 | 1.946215 | 11.19073625 | Sanya mito-like virus 1 | 2970201 | Viruses | Viruses | 239 | 9.2e-72 | NR | UUW21442.1 | 2970201 | g38004 | i0 | 60.2 | 0.996521739130435 | 191 | 74 | 99.7 | 1 | 2 | 574 | 290 | 478 | UUW21442.1 MAG: RNA-dependent RNA polymerase [Sanya mito-like virus 1] | diamond | 573 | 239 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Sanya mito-like virus 1 | |||
| 28055798 | 28055798 | PRJNA493827_P_NODE_177765_length_256_cov_1.262295_g175567_i0 | PRJNA493827 | 177765 | 256 | 1.262295 | 3.2314752 | Soybean thrips narna-like virus 1 | 2800851 | Viruses | Viruses | 80.5 | 2.21e-15 | NR | QQP18719.1 | 2800851 | g175567 | i0 | 56.2 | 0.85546875 | 73 | 28 | 85.5 | 1 | 221 | 3 | 402 | 470 | QQP18719.1 RNA-dependent RNA polymerase, partial [Soybean thrips narna-like virus 1] | diamond | 219 | 80.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Soybean thrips narna-like virus 1 | |||
| 28908201 | 28908201 | PRJNA493827_P_NODE_77788_length_391_cov_1.833333_g75590_i0 | PRJNA493827 | 77788 | 391 | 1.833333 | 7.16833203 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 121 | 5.94e-29 | NR | WAK72382.1 | 2809572 | g75590 | i0 | 55.1 | 0.820971867007673 | 107 | 47 | 81.3 | 1 | 389 | 72 | 489 | 595 | WAK72382.1 MAG: RNA-dependent RNA polymerase [Mitoviridae sp.] | diamond | 321 | 121 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 29129714 | 29129714 | PRJNA493827_P_NODE_36689_length_608_cov_1.678505_g34526_i0 | PRJNA493827 | 36689 | 608 | 1.678505 | 10.2053104 | Zhangye Narna tick virus 1 | 2972236 | Viruses | Viruses | 49.7 | 9.09e-4 | NR | UYL95383.1 | 2972236 | g34526 | i0 | 30.6 | 0.532894736842105 | 108 | 63 | 47.4 | 2 | 186 | 473 | 5 | 112 | UYL95383.1 MAG: hypothetical protein [Zhangye Narna tick virus 1] | diamond | 324 | 49.7 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Zhangye Narna tick virus 1 | |||
| 29649845 | 29649845 | PRJNA493827_P_NODE_116330_length_317_cov_1.057377_g114132_i0 | PRJNA493827 | 116330 | 317 | 1.057377 | 3.35188509 | Fiersviridae | 2842319 | Viruses | Viruses | 43.5 | 0.0463 | NR | YP_010769860.1 | 2786472 | g114132 | i0 | 35.7 | 1.94952681388013 | 56 | 36 | 53 | 0 | 135 | 302 | 85 | 140 | YP_010769860.1 RNA-directed RNA polymerase [ssRNA phage SRR5467091_7] | diamond | 618 | 43.9 | 0.990888382687927 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Shebanavirus | Shebanavirus borborovicinum | ||
| 30234697 | 30234697 | PRJNA493827_P_NODE_101392_length_340_cov_1.441948_g99194_i0 | PRJNA493827 | 101392 | 340 | 1.441948 | 4.9026232 | Hangzhou narnavirus 2 | 2905324 | Viruses | Viruses | 86.3 | 6.39e-17 | NR | UHK02994.1 | 2905324 | g99194 | i0 | 43 | 1.00588235294118 | 114 | 50 | 98.8 | 3 | 5 | 340 | 567 | 667 | UHK02994.1 MAG: RNA-dependent RNA polymerase [Hangzhou narnavirus 2] | diamond | 342 | 86.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Hangzhou narnavirus 2 | ||
| 30456387 | 30456387 | PRJNA493827_P_NODE_98653_length_345_cov_1.158088_g96455_i0 | PRJNA493827 | 98653 | 345 | 1.158088 | 3.9954036 | Mito-like picolinusvirus | 2784741 | Viruses | Viruses | 58.5 | 3.43e-7 | NR | QOW97241.1 | 2784741 | g96455 | i0 | 34.8 | 0.973913043478261 | 112 | 69 | 93.9 | 3 | 326 | 3 | 75 | 186 | QOW97241.1 RNA-dependent RNA polymerase [Mito-like picolinusvirus] | diamond | 336 | 58.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Mito-like picolinusvirus | |||
| 30519128 | 30519128 | PRJNA493827_P_NODE_159813_length_271_cov_1.353535_g157615_i0 | PRJNA493827 | 159813 | 271 | 1.353535 | 3.66807985 | ssRNA phage Gerhypos.2_3 | 2786263 | Viruses | Viruses | 93.2 | 7.51e-20 | NR | YP_010770593.1 | 2786264 | g157615 | i0 | 51.2 | 0.952029520295203 | 86 | 42 | 95.2 | 0 | 12 | 269 | 349 | 434 | YP_010770593.1 maturation protein, partial [ssRNA phage Gerhypos.2_30] | diamond | 258 | 93.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Timlovirales | Steitzviridae | Hodnevirus | Hodnevirus neosolivicinum | ||
| 31040623 | 31040623 | PRJNA493827_P_NODE_127995_length_302_cov_1.344978_g125797_i0 | PRJNA493827 | 127995 | 302 | 1.344978 | 4.06183356 | Narnavirus | 186767 | Viruses | Viruses | 92 | 3.65e-19 | NR | QJT93745.1 | 2736370 | g125797 | i0 | 38.4 | 5.9205298013245 | 99 | 61 | 98.3 | 0 | 299 | 3 | 234 | 332 | QJT93745.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 13] | diamond | 1788 | 92 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Erysiphe necator associated narnavirus 13 | ||
| 31356591 | 31356591 | PRJNA493827_P_NODE_3456_length_2332_cov_6.346171_g2907_i0 | PRJNA493827 | 3456 | 2332 | 6.346171 | 147.99270772 | Mitoviridae | 2732892 | Viruses | Viruses | 257 | 6.95e-71 | NR | QCF24462.1 | 2557976 | g2907 | i0 | 30.4 | 5.57161234991424 | 672 | 404 | 81.8 | 19 | 2065 | 158 | 39 | 682 | QCF24462.1 RNA-dependent RNA polymerase [Entomophthora muscae mitovirus 3] | diamond | 12993 | 259 | 0.992277992277992 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Unuamitovirus | Unuamitovirus enmu3 | ||
| 31372613 | 31372613 | PRJNA493827_P_NODE_38776_length_588_cov_1.201942_g36600_i0 | PRJNA493827 | 38776 | 588 | 1.201942 | 7.06741896 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 147 | 4.4e-37 | NR | WAK72376.1 | 2809572 | g36600 | i0 | 42.1 | 1.00510204081633 | 197 | 106 | 99 | 5 | 588 | 7 | 26 | 217 | WAK72376.1 MAG: RNA-dependent RNA polymerases [Mitoviridae sp.] | diamond | 591 | 147 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 31720255 | 31720255 | PRJNA493827_P_NODE_110557_length_325_cov_1.666667_g108359_i0 | PRJNA493827 | 110557 | 325 | 1.666667 | 5.41666775 | Zhangye Narna tick virus 1 | 2972236 | Viruses | Viruses | 78.2 | 3.58e-14 | NR | UYL95382.1 | 2972236 | g108359 | i0 | 39.4 | 1.00615384615385 | 109 | 64 | 98.8 | 1 | 322 | 2 | 507 | 615 | UYL95382.1 MAG: RNA-dependent RNA polymerase [Zhangye Narna tick virus 1] | diamond | 327 | 78.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Zhangye Narna tick virus 1 | |||
| 31720273 | 31720273 | PRJNA493827_P_NODE_13657_length_1099_cov_2.641326_g12169_i0 | PRJNA493827 | 13657 | 1099 | 2.641326 | 29.02817274 | Mito-like spartanusvirus | 2784742 | Viruses | Viruses | 82.4 | 5.62e-13 | NR | QOW97240.1 | 2784742 | g12169 | i0 | 38.2 | 0.335759781619654 | 123 | 71 | 33.3 | 3 | 5 | 370 | 417 | 535 | QOW97240.1 RNA-dependent RNA polymerase [Mito-like spartanusvirus] | diamond | 369 | 82.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Mito-like spartanusvirus | |||
| 31878383 | 31878383 | PRJNA493827_P_NODE_78897_length_388_cov_1.466667_g76699_i0 | PRJNA493827 | 78897 | 388 | 1.466667 | 5.69066796 | ssRNA phage Esthiorhiza.3_1 | 2786077 | Viruses | Viruses | 120 | 6.31e-29 | NR | YP_010771737.1 | 2786077 | g76699 | i0 | 51.2 | 0.997422680412371 | 129 | 57 | 99.7 | 1 | 1 | 387 | 466 | 588 | YP_010771737.1 RNA-directed RNA polymerase [ssRNA phage Esthiorhiza.3_1] | diamond | 387 | 120 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Timlovirales | Steitzviridae | Hodnevirus | Hodnevirus neohumivicinum | ||
| 32068223 | 32068223 | PRJNA493827_P_NODE_213158_length_245_cov_0.895349_g210960_i0 | PRJNA493827 | 213158 | 245 | 0.895349 | 2.19360505 | Erysiphales narna-like virus 3 | 2719866 | Viruses | Viruses | 99.8 | 3.33e-22 | NR | QIP68041.1 | 2719866 | g210960 | i0 | 64.2 | 0.991836734693878 | 81 | 29 | 99.2 | 0 | 2 | 244 | 260 | 340 | QIP68041.1 RNA-dependent RNA polymerase [Erysiphales narna-like virus 3] | diamond | 243 | 99.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Erysiphales narna-like virus 3 | |||
| 32290181 | 32290181 | PRJNA493827_P_NODE_198739_length_248_cov_0.880000_g196541_i0 | PRJNA493827 | 198739 | 248 | 0.88 | 2.1824 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 75.5 | 1.16e-13 | NR | WAK72376.1 | 2809572 | g196541 | i0 | 64.3 | 0.67741935483871 | 56 | 20 | 67.7 | 0 | 80 | 247 | 1 | 56 | WAK72376.1 MAG: RNA-dependent RNA polymerases [Mitoviridae sp.] | diamond | 168 | 75.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 32857947 | 32857947 | PRJNA493827_P_NODE_68540_length_420_cov_2.193084_g66343_i0 | PRJNA493827 | 68540 | 420 | 2.193084 | 9.2109528 | Hangzhou nephotettix cincticeps narnavirus 1 | 2905330 | Viruses | Viruses | 94.4 | 2.43e-19 | NR | UHK03296.1 | 2905330 | g66343 | i0 | 45.1 | 0.871428571428571 | 122 | 62 | 84.3 | 3 | 62 | 415 | 248 | 368 | UHK03296.1 MAG: RNA-dependent DNA polymerase, partial [Hangzhou nephotettix cincticeps narnavirus 1] | diamond | 366 | 94.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Hangzhou nephotettix cincticeps narnavirus 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);;