contig_metadata
13 rows where bioproject = "PRJNA1144090", tax_phylum = "Lenarviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 286781 | 286781 | PRJNA1144090_P_NODE_100761_length_250_cov_0.870056_g100226_i0 | PRJNA1144090 | 100761 | 250 | 0.870056 | 2.17514 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 52.8 | 0.023 | NTclustered | gi|2245489900|gb|ON164060.1| | 2809572 | g100226 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 165 | 192 | 792 | 765 | MAG: Mitoviridae sp. isolate s59-k141_998920 RNA dependent RNA polymerase gene, partial cds | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 24513143 | 24513143 | PRJNA1144090_P_NODE_360_length_3167_cov_23.190692_g317_i0 | PRJNA1144090 | 360 | 3167 | 23.190692 | 734.44921564 | Narnavirus sp. | 2587225 | Viruses | Viruses | 1073 | 0 | NR | CAK7594499.1 | 2587225 | g317 | i0 | 53.5 | 1.87180296810862 | 993 | 447 | 93.2 | 9 | 3046 | 95 | 1 | 987 | CAK7594499.1 RNA-dependent RNA polymerase [Narnavirus sp.] | diamond | 5928 | 1073 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Narnavirus sp. | ||
| 27102065 | 27102065 | PRJNA1144090_P_NODE_98182_length_252_cov_1.720670_g97647_i0 | PRJNA1144090 | 98182 | 252 | 1.72067 | 4.3360884 | Dracophyllum associated narna-like virus 55 | 3066892 | Viruses | Viruses | 78.2 | 7.12e-15 | NR | WPR17259.1 | 3066892 | g97647 | i0 | 46.4 | 1 | 84 | 45 | 100 | 0 | 1 | 252 | 4 | 87 | WPR17259.1 MAG: RNA-dependent RNA polymerase, partial [Dracophyllum associated narna-like virus 55] | diamond | 252 | 78.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Dracophyllum associated narna-like virus 55 | |||
| 27196691 | 27196691 | PRJNA1144090_P_NODE_1022_length_2310_cov_12.686187_g931_i0 | PRJNA1144090 | 1022 | 2310 | 12.686187 | 293.0509197 | Downy mildew lesion associated splipalmivirus 4 | 2719525 | Viruses | Viruses | 388 | 3.87e-120 | NR | WNA22212.1 | 2719525 | g931 | i0 | 39.2 | 1.52077922077922 | 571 | 333 | 73.2 | 7 | 2020 | 329 | 70 | 633 | WNA22212.1 MAG: RdRp [Downy mildew lesion associated splipalmivirus 4] | diamond | 3513 | 388 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Jakapalmivirus | Jakapalmivirus italiense | ||
| 27481291 | 27481291 | PRJNA1144090_P_NODE_45783_length_378_cov_3.006557_g45248_i0 | PRJNA1144090 | 45783 | 378 | 3.006557 | 11.36478546 | Downy mildew lesion associated splipalmivirus 46 | 3065434 | Viruses | Viruses | 61.2 | 5.54e-8 | NR | WLJ60693.1 | 3065434 | g45248 | i0 | 32 | 0.793650793650794 | 100 | 66 | 79.4 | 2 | 316 | 17 | 191 | 288 | WLJ60693.1 MAG: putative RdRp [Downy mildew lesion associated splipalmivirus 46] | diamond | 300 | 61.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Downy mildew lesion associated splipalmivirus 46 | ||
| 28606901 | 28606901 | PRJNA1144090_P_NODE_807_length_2506_cov_20.563913_g726_i0 | PRJNA1144090 | 807 | 2506 | 20.563913 | 515.33165978 | Narnavirus | 186767 | Viruses | Viruses | 464 | 3.03e-147 | NR | QJT93782.1 | 2736407 | g726 | i0 | 38.5 | 3.59377494014366 | 753 | 428 | 87.3 | 12 | 210 | 2396 | 44 | 785 | QJT93782.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 50] | diamond | 9006 | 465 | 0.997849462365591 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Erysiphe necator associated narnavirus 50 | ||
| 28670175 | 28670175 | PRJNA1144090_P_NODE_25567_length_527_cov_3.491189_g25035_i0 | PRJNA1144090 | 25567 | 527 | 3.491189 | 18.39856603 | Narnavirus | 186767 | Viruses | Viruses | 58.5 | 1.98e-6 | NR | WNA22215.1 | 2719531 | g25035 | i0 | 26.8 | 2.63567362428843 | 149 | 107 | 83.7 | 2 | 501 | 61 | 292 | 440 | WNA22215.1 MAG: RdRp [Downy mildew lesion associated splipalmivirus 6] | diamond | 1389 | 58.9 | 0.99320882852292 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Downy mildew lesion associated splipalmivirus 6 | ||
| 29912760 | 29912760 | PRJNA1144090_P_NODE_991_length_2330_cov_4.832964_g901_i0 | PRJNA1144090 | 991 | 2330 | 4.832964 | 112.6080612 | Penaeus vannamei narna-like virus 2 | 3132560 | Viruses | Viruses | 554 | 5.699999999999997e-184 | NR | WWZ85650.1 | 3132560 | g901 | i0 | 45.3 | 0.849785407725322 | 660 | 343 | 83.9 | 11 | 41 | 1996 | 2 | 651 | WWZ85650.1 hypothetical protein [Penaeus vannamei narna-like virus 2] | diamond | 1980 | 554 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Penaeus vannamei narna-like virus 2 | |||
| 30292078 | 30292078 | PRJNA1144090_P_NODE_4852_length_1289_cov_10.805921_g4573_i0 | PRJNA1144090 | 4852 | 1289 | 10.805921 | 139.28832169 | Downy mildew lesion associated splipalmivirus 1 | 2719492 | Viruses | Viruses | 68.9 | 3.41e-9 | NR | WNA22205.1 | 2719492 | g4573 | i0 | 30.9 | 0.474786656322731 | 204 | 116 | 45.2 | 7 | 1127 | 546 | 42 | 230 | WNA22205.1 MAG: hypothetical protein [Downy mildew lesion associated splipalmivirus 1] | diamond | 612 | 68.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Downy mildew lesion associated splipalmivirus 1 | ||
| 31039216 | 31039216 | PRJNA1144090_P_NODE_6635_length_1108_cov_24.632850_g6299_i0 | PRJNA1144090 | 6635 | 1108 | 24.63285 | 272.931978 | Wolframvirales | 2732502 | Viruses | Viruses | 69.3 | 1.7e-9 | NR | WNA22207.1 | 2719503 | g6299 | i0 | 25.7 | 1.23736462093863 | 249 | 153 | 67.1 | 6 | 211 | 954 | 11 | 228 | WNA22207.1 MAG: hypothetical protein, partial [Downy mildew lesion associated splipalmivirus 2] | diamond | 1371 | 69.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Downy mildew lesion associated splipalmivirus 2 | ||
| 31176060 | 31176060 | PRJNA1144090_P_NODE_5675_length_1203_cov_164.884071_g5365_i0 | PRJNA1144090 | 5675 | 1203 | 164.884071 | 1983.55537413 | Narnavirus sp. | 2587225 | Viruses | Viruses | 65.1 | 1.52e-8 | NR | CAK8705411.1 | 2587225 | g5365 | i0 | 34.4 | 1.14214463840399 | 128 | 73 | 31.4 | 3 | 1106 | 729 | 4 | 122 | CAK8705411.1 uncharacterized [Narnavirus sp.] | diamond | 1374 | 65.1 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Narnavirus sp. | ||
| 31461153 | 31461153 | PRJNA1144090_P_NODE_119056_length_232_cov_2.754717_g118521_i0 | PRJNA1144090 | 119056 | 232 | 2.754717 | 6.39094344 | Praha narna-like virus 4 | 2789507 | Viruses | Viruses | 82.4 | 3.37e-16 | NR | QPN36961.1 | 2789507 | g118521 | i0 | 59.5 | 0.956896551724138 | 74 | 27 | 95.7 | 1 | 230 | 9 | 526 | 596 | QPN36961.1 hypothetical protein [Praha narna-like virus 4] | diamond | 222 | 82.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Praha narna-like virus 4 | |||
| 31639582 | 31639582 | PRJNA1144090_P_NODE_18576_length_633_cov_5.464286_g18053_i0 | PRJNA1144090 | 18576 | 633 | 5.464286 | 34.58893038 | Narnavirus | 186767 | Viruses | Viruses | 85.5 | 2.52e-15 | NR | WNA22223.1 | 3070777 | g18053 | i0 | 31.5 | 1.52132701421801 | 162 | 108 | 76.3 | 3 | 604 | 122 | 117 | 276 | WNA22223.1 MAG: RdRp [Downy mildew lesion associated splipalmivirus 45] | diamond | 963 | 85.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Downy mildew lesion associated splipalmivirus 45 |
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);;