contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA928559" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26739484 | 26739484 | PRJNA928559_P_NODE_178901_length_260_cov_1.582888_g177332_i0 | PRJNA928559 | 178901 | 260 | 1.582888 | 4.1155088 | ssRNA phage SRR79763 | 2846170 | Viruses | Viruses | 50.4 | 8.57e-5 | NR | YP_010771095.1 | 2786661 | g177332 | i0 | 54.3 | 0.530769230769231 | 46 | 16 | 48.5 | 2 | 157 | 32 | 119 | 163 | YP_010771095.1 maturation protein, partial [ssRNA phage SRR7976301_11] | diamond | 138 | 50.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Timlovirales | Steitzviridae | Sdenfavirus | Sdenfavirus sp. 'asiovicinum' | ||
| 26835108 | 26835108 | PRJNA928559_P_NODE_58541_length_454_cov_1.842520_g56974_i0 | PRJNA928559 | 58541 | 454 | 1.84252 | 8.3650408 | Ripistub virus | 3131286 | Viruses | Viruses | 65.5 | 2.97e-9 | NR | WZH61163.1 | 3131286 | g56974 | i0 | 43.4 | 2.97356828193833 | 83 | 38 | 54.8 | 1 | 176 | 424 | 109 | 182 | WZH61163.1 MAG: RNA-dependent RNA polymerase, partial [Ripistub virus] | diamond | 1350 | 65.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Ripistub virus | ||||
| 27372803 | 27372803 | PRJNA928559_P_NODE_187883_length_253_cov_0.866667_g186314_i0 | PRJNA928559 | 187883 | 253 | 0.866667 | 2.19266751 | Macrophomina phaseolina umbra-like virus 1 | 2741665 | Viruses | Viruses | 103 | 1.8899999999999998e-24 | NR | QOE55593.1 | 2741665 | g186314 | i0 | 66.3 | 0.948616600790514 | 80 | 27 | 94.9 | 0 | 2 | 241 | 195 | 274 | QOE55593.1 hypothetical protein [Macrophomina phaseolina umbra-like virus 1] | diamond | 240 | 103 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Umbravirus | Macrophomina phaseolina umbra-like virus 1 | ||
| 27404262 | 27404262 | PRJNA928559_P_NODE_65543_length_432_cov_6.181058_g63974_i0 | PRJNA928559 | 65543 | 432 | 6.181058 | 26.70217056 | Chronawunb virus | 3129988 | Viruses | Viruses | 59.7 | 1.37e-7 | NR | WZH59067.1 | 3129988 | g63974 | i0 | 37.5 | 1.48611111111111 | 104 | 65 | 72.2 | 0 | 431 | 120 | 108 | 211 | WZH59067.1 MAG: RNA-dependent RNA polymerase, partial [Chronawunb virus] | diamond | 642 | 59.7 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Chronawunb virus | |||
| 27884805 | 27884805 | PRJNA928559_P_NODE_166465_length_271_cov_2.060606_g164896_i0 | PRJNA928559 | 166465 | 271 | 2.060606 | 5.58424226 | Cystovirus | 10878 | Viruses | Viruses | 108 | 1.04e-25 | NR | UNI73393.1 | 2917704 | g164896 | i0 | 56.7 | 1.99261992619926 | 90 | 39 | 99.6 | 0 | 1 | 270 | 20 | 109 | UNI73393.1 RNA dependent RNA polymerase [Pseudomonas phage ER16] | diamond | 540 | 108 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Pseudomonas phage ER16 | |||
| 28288023 | 28288023 | PRJNA928559_P_NODE_36866_length_547_cov_3.829114_g35315_i0 | PRJNA928559 | 36866 | 547 | 3.829114 | 20.94525358 | Chronakynb virus | 3129881 | Viruses | Viruses | 89.4 | 5.2e-17 | NR | WZH58918.1 | 3129881 | g35315 | i0 | 34.8 | 0.89945155393053 | 164 | 97 | 85.6 | 4 | 15 | 482 | 62 | 223 | WZH58918.1 MAG: RNA-dependent RNA polymerase, partial [Chronakynb virus] | diamond | 492 | 89.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Chronakynb virus | |||
| 28990213 | 28990213 | PRJNA928559_P_NODE_129408_length_312_cov_1.958159_g127839_i0 | PRJNA928559 | 129408 | 312 | 1.958159 | 6.10945608 | Viruses | 10239 | Viruses | Viruses | 44.7 | 0.0169 | NR | WAK75317.1 | 2583949 | g127839 | i0 | 35.6 | 3 | 104 | 57 | 99 | 5 | 310 | 2 | 294 | 388 | WAK75317.1 MAG: RNA-dependent RNA polymerase [Narnaviridae sp.] | diamond | 936 | 44.7 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 29526763 | 29526763 | PRJNA928559_P_NODE_149690_length_288_cov_1.451163_g148121_i0 | PRJNA928559 | 149690 | 288 | 1.451163 | 4.17934944 | Negarnaviricota | 2497569 | Viruses | Viruses | 47 | 0.00212 | NR | UUW20965.1 | 2970002 | g148121 | i0 | 44.4 | 2.26041666666667 | 63 | 32 | 62.5 | 1 | 236 | 57 | 1062 | 1124 | UUW20965.1 MAG: RNA-dependent RNA polymerase [Sanya bunya-like virus 18] | diamond | 651 | 47 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Sanya bunya-like virus 18 | ||||
| 29747429 | 29747429 | PRJNA928559_P_NODE_47430_length_495_cov_1.883886_g45868_i0 | PRJNA928559 | 47430 | 495 | 1.883886 | 9.3252357 | Narnavirus | 186767 | Viruses | Viruses | 54.7 | 3.38e-5 | NR | CAK7594509.1 | 2587225 | g45868 | i0 | 27.2 | 2.84848484848485 | 147 | 71 | 88.5 | 3 | 3 | 440 | 539 | 650 | CAK7594509.1 RNA-dependent RNA polymerase [Narnavirus sp.] | diamond | 1410 | 55.1 | 0.992740471869329 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Narnavirus sp. | ||
| 31699901 | 31699901 | PRJNA928559_P_NODE_116957_length_329_cov_3.625000_g115388_i0 | PRJNA928559 | 116957 | 329 | 3.625 | 11.92625 | Leptosphaeria biglobosa narnavirus 9 | 2985684 | Viruses | Viruses | 89 | 5.85e-18 | NR | UYL94476.1 | 2985684 | g115388 | i0 | 45 | 0.993920972644377 | 109 | 58 | 99.4 | 2 | 2 | 328 | 142 | 248 | UYL94476.1 MAG: RNA-dependent RNA polymerase [Leptosphaeria biglobosa narnavirus 9] | diamond | 327 | 89 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Leptosphaeria biglobosa narnavirus 9 | ||
| 32150071 | 32150071 | PRJNA928559_P_NODE_164718_length_273_cov_1.470000_g163149_i0 | PRJNA928559 | 164718 | 273 | 1.47 | 4.0131 | Mitovirus | 186768 | Viruses | Viruses | 75.9 | 1.12e-13 | NR | DBA06308.1 | 2993407 | g163149 | i0 | 46.7 | 1.97802197802198 | 90 | 48 | 98.9 | 0 | 271 | 2 | 37 | 126 | DBA06308.1 TPA_asm: RdRp, partial [Austropotamobius pallipes associated mitovirus 1] | diamond | 540 | 76.3 | 0.99475753604194 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Austropotamobius pallipes associated mitovirus 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);;