contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA1240804" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5452026 | 5452026 | PRJNA1240804_P_NODE_5525_length_518_cov_2.036247_g5168_i0 | PRJNA1240804 | 5525 | 518 | 2.036247 | 10.54775946 | Erysiphe necator associated narnavirus 17 | 2736374 | Viruses | Viruses | 186 | 7.859999999999999e-52 | NR | QJT93749.1 | 2736374 | g5168 | i0 | 57 | 0.955598455598456 | 165 | 68 | 93.8 | 2 | 28 | 513 | 1 | 165 | QJT93749.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 17] | diamond | 495 | 186 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Erysiphe necator associated narnavirus 17 | ||
| 8001790 | 8001790 | PRJNA1240804_P_NODE_52527_length_215_cov_1.409639_g52161_i0 | PRJNA1240804 | 52527 | 215 | 1.409639 | 3.03072385 | Sanya narnavirus 8 | 2905320 | Viruses | Viruses | 106 | 8.04e-25 | NR | UHR49711.1 | 2905320 | g52161 | i0 | 72.7 | 0.92093023255814 | 66 | 18 | 92.1 | 0 | 16 | 213 | 477 | 542 | UHR49711.1 MAG: RNA-dependent RNA polymerase, partial [Sanya narnavirus 8] | diamond | 198 | 106 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Sanya narnavirus 8 | ||
| 22024807 | 22024807 | PRJNA1240804_P_NODE_32818_length_257_cov_0.884615_g32452_i0 | PRJNA1240804 | 32818 | 257 | 0.884615 | 2.27346055 | Sanya narnavirus 8 | 2905320 | Viruses | Viruses | 131 | 2.65e-33 | NR | UHR49711.1 | 2905320 | g32452 | i0 | 75.6 | 2.82490272373541 | 78 | 19 | 91.1 | 0 | 5 | 238 | 344 | 421 | UHR49711.1 MAG: RNA-dependent RNA polymerase, partial [Sanya narnavirus 8] | diamond | 726 | 131 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Sanya narnavirus 8 | ||
| 26756810 | 26756810 | PRJNA1240804_P_NODE_27241_length_276_cov_1.854626_g26875_i0 | PRJNA1240804 | 27241 | 276 | 1.854626 | 5.11876776 | Erysiphe necator associated narnavirus 17 | 2736374 | Viruses | Viruses | 79 | 1.01e-14 | NR | QJT93749.1 | 2736374 | g26875 | i0 | 54.4 | 0.858695652173913 | 79 | 35 | 85.9 | 1 | 263 | 27 | 432 | 509 | QJT93749.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 17] | diamond | 237 | 79 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Erysiphe necator associated narnavirus 17 | ||
| 27010151 | 27010151 | PRJNA1240804_P_NODE_7322_length_462_cov_4.292978_g6961_i0 | PRJNA1240804 | 7322 | 462 | 4.292978 | 19.83355836 | Erysiphe necator associated narnavirus 17 | 2736374 | Viruses | Viruses | 164 | 4.22e-44 | NR | QJT93749.1 | 2736374 | g6961 | i0 | 53.7 | 0.954545454545455 | 147 | 68 | 95.5 | 0 | 17 | 457 | 527 | 673 | QJT93749.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 17] | diamond | 441 | 164 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Erysiphe necator associated narnavirus 17 | ||
| 27041924 | 27041924 | PRJNA1240804_P_NODE_44962_length_227_cov_2.443820_g44596_i0 | PRJNA1240804 | 44962 | 227 | 2.44382 | 5.5474714 | Ripabrum virus | 3130326 | Viruses | Viruses | 70.1 | 1.75e-12 | NR | WZH59433.1 | 3130326 | g44596 | i0 | 59.5 | 0.977973568281938 | 74 | 24 | 91.2 | 3 | 208 | 2 | 27 | 99 | WZH59433.1 MAG: RNA-dependent RNA polymerase, partial [Ripabrum virus] | diamond | 222 | 70.1 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Ripabrum virus | |||||
| 27768680 | 27768680 | PRJNA1240804_P_NODE_137344_length_164_cov_0.904348_g136978_i0 | PRJNA1240804 | 137344 | 164 | 0.904348 | 1.48313072 | Yellow silver pine associated narna-like virus 48 | 3067107 | Viruses | Viruses | 51.6 | 9.5e-6 | NR | WPR17317.1 | 3067107 | g136978 | i0 | 48.9 | 3.4390243902439 | 47 | 24 | 86 | 0 | 142 | 2 | 299 | 345 | WPR17317.1 MAG: RNA-dependent RNA polymerase, partial [Yellow silver pine associated narna-like virus 48] | diamond | 564 | 51.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Yellow silver pine associated narna-like virus 48 | |||
| 28526399 | 28526399 | PRJNA1240804_P_NODE_128107_length_166_cov_0.888889_g127741_i0 | PRJNA1240804 | 128107 | 166 | 0.888889 | 1.47555574 | Chronaberk virus | 3129719 | Viruses | Viruses | 94.7 | 6.360000000000001e-21 | NR | WZH58762.1 | 3129719 | g127741 | i0 | 83.7 | 0.885542168674699 | 49 | 8 | 88.6 | 0 | 20 | 166 | 219 | 267 | WZH58762.1 MAG: RNA-dependent RNA polymerase [Chronaberk virus] | diamond | 147 | 94.7 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Chronaberk virus | |||
| 29031704 | 29031704 | PRJNA1240804_P_NODE_75688_length_189_cov_2.000000_g75322_i0 | PRJNA1240804 | 75688 | 189 | 2 | 3.78 | Moss associated narna-like virus 6 | 3067018 | Viruses | Viruses | 82 | 2.21e-16 | NR | WPR17193.1 | 3067019 | g75322 | i0 | 67.2 | 0.920634920634921 | 58 | 19 | 92.1 | 0 | 182 | 9 | 380 | 437 | WPR17193.1 MAG: RNA-dependent RNA polymerase, partial [Moss associated narna-like virus 60] | diamond | 174 | 82 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Moss associated narna-like virus 60 | |||
| 29094739 | 29094739 | PRJNA1240804_P_NODE_65588_length_198_cov_1.563758_g65222_i0 | PRJNA1240804 | 65588 | 198 | 1.563758 | 3.09624084 | Hebei narnavirus 13 | 3371267 | Viruses | Viruses | 92.4 | 6.41e-20 | NR | XHY85191.1 | 3371267 | g65222 | i0 | 69.2 | 0.984848484848485 | 65 | 19 | 98.5 | 1 | 196 | 2 | 501 | 564 | XHY85191.1 MAG: hypothetical protein, partial [Hebei narnavirus 13] | diamond | 195 | 92.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Hebei narnavirus 13 | ||
| 29852439 | 29852439 | PRJNA1240804_P_NODE_23051_length_295_cov_1.662602_g22685_i0 | PRJNA1240804 | 23051 | 295 | 1.662602 | 4.9046759 | Erysiphe necator associated narnavirus 17 | 2736374 | Viruses | Viruses | 80.5 | 3.8e-15 | NR | QJT93749.1 | 2736374 | g22685 | i0 | 47.3 | 0.925423728813559 | 91 | 47 | 91.5 | 1 | 277 | 8 | 209 | 299 | QJT93749.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 17] | diamond | 273 | 80.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Erysiphe necator associated narnavirus 17 | ||
| 29870524 | 29870524 | PRJNA1240804_P_NODE_26811_length_278_cov_1.371179_g26445_i0 | PRJNA1240804 | 26811 | 278 | 1.371179 | 3.81187762 | Narnavirus | 186767 | Viruses | Viruses | 102 | 5.869999999999999e-23 | NR | UHR49711.1 | 2905320 | g26445 | i0 | 53.3 | 1.86690647482014 | 90 | 42 | 97.1 | 0 | 7 | 276 | 28 | 117 | UHR49711.1 MAG: RNA-dependent RNA polymerase, partial [Sanya narnavirus 8] | diamond | 519 | 102 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Sanya narnavirus 8 | ||
| 30484341 | 30484341 | PRJNA1240804_P_NODE_58313_length_207_cov_1.481013_g57947_i0 | PRJNA1240804 | 58313 | 207 | 1.481013 | 3.06569691 | Hebei narnavirus 13 | 3371267 | Viruses | Viruses | 73.6 | 3.13e-13 | NR | XHY85191.1 | 3371267 | g57947 | i0 | 83.7 | 0.623188405797101 | 43 | 7 | 62.3 | 0 | 196 | 68 | 252 | 294 | XHY85191.1 MAG: hypothetical protein, partial [Hebei narnavirus 13] | diamond | 129 | 73.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Hebei narnavirus 13 | ||
| 30642042 | 30642042 | PRJNA1240804_P_NODE_147133_length_162_cov_1.256637_g146767_i0 | PRJNA1240804 | 147133 | 162 | 1.256637 | 2.03575194 | Sanya narnavirus 8 | 2905320 | Viruses | Viruses | 86.7 | 4.27e-18 | NR | UHR49711.1 | 2905320 | g146767 | i0 | 72.2 | 1 | 54 | 15 | 100 | 0 | 162 | 1 | 175 | 228 | UHR49711.1 MAG: RNA-dependent RNA polymerase, partial [Sanya narnavirus 8] | diamond | 162 | 86.7 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Sanya narnavirus 8 | ||
| 31102575 | 31102575 | PRJNA1240804_P_NODE_92835_length_178_cov_1.224806_g92469_i0 | PRJNA1240804 | 92835 | 178 | 1.224806 | 2.18015468 | Hahmbtovirus | 3152728 | Viruses | Viruses | 42 | 0.0283 | NR | QDH86744.1 | 2027243 | g92469 | i0 | 41.3 | 1.56741573033708 | 46 | 27 | 77.5 | 0 | 18 | 155 | 105 | 150 | QDH86744.1 MAG: hypothetical protein H4Bulk46826_000003 [Leviviridae sp.] | diamond | 279 | 42 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. |
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);;