contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA971593" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8597199 | 8597199 | PRJNA971593_P_NODE_20567_length_261_cov_1.223404_g20418_i0 | PRJNA971593 | 20567 | 261 | 1.223404 | 3.19308444 | Narcissus common latent virus | 160844 | Viruses | Viruses | 179 | 4.95e-50 | NR | YP_699983.1 | 160844 | g20418 | i0 | 96.5 | 0.988505747126437 | 86 | 3 | 98.9 | 0 | 3 | 260 | 1858 | 1943 | YP_699983.1 RNA-dependent RNA polymerase [Narcissus common latent virus] | diamond | 258 | 179 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensnarcissi | ||
| 27658016 | 27658016 | PRJNA971593_P_NODE_24724_length_247_cov_1.770115_g24575_i0 | PRJNA971593 | 24724 | 247 | 1.770115 | 4.37218405 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 109 | 9.04e-28 | NR | CAB4197140.1 | 2100421 | g24575 | i0 | 54.1 | 0.898785425101215 | 74 | 34 | 89.9 | 0 | 230 | 9 | 74 | 147 | CAB4197140.1 phage_rel_nuc, putative phage-type endonuclease [uncultured Caudovirales phage] | diamond | 222 | 109 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28320804 | 28320804 | PRJNA971593_P_NODE_12146_length_347_cov_0.923358_g11997_i0 | PRJNA971593 | 12146 | 347 | 0.923358 | 3.20405226 | Cnidiuim virus associated satellite | 3133206 | Viruses | Viruses | 147 | 3.15e-41 | NR | WXB65927.1 | 3133206 | g11997 | i0 | 77.2 | 0.873198847262248 | 101 | 22 | 87.3 | 1 | 45 | 347 | 8 | 107 | WXB65927.1 31 kDa protein [Cnidiuim virus associated satellite] | diamond | 303 | 147 | 1 | Viruses | RNA satellites | Cnidiuim virus associated satellite | |||||||
| 28352384 | 28352384 | PRJNA971593_P_NODE_19626_length_268_cov_1.543590_g19477_i0 | PRJNA971593 | 19626 | 268 | 1.54359 | 4.1368212 | Cnidiuim virus associated satellite | 3133206 | Viruses | Viruses | 125 | 2.68e-33 | NR | WXB65927.1 | 3133206 | g19477 | i0 | 70 | 1.00746268656716 | 90 | 24 | 98.5 | 2 | 3 | 266 | 121 | 209 | WXB65927.1 31 kDa protein [Cnidiuim virus associated satellite] | diamond | 270 | 125 | 1 | Viruses | RNA satellites | Cnidiuim virus associated satellite | |||||||
| 28699922 | 28699922 | PRJNA971593_P_NODE_26927_length_244_cov_0.900585_g26778_i0 | PRJNA971593 | 26927 | 244 | 0.900585 | 2.1974274 | Plasmopara viticola lesion associated mycobunyavirales-like virus 4 | 2689127 | Viruses | Viruses | 128 | 1.19e-32 | NR | YP_010840343.1 | 2689127 | g26778 | i0 | 70.4 | 0.995901639344262 | 81 | 24 | 99.6 | 0 | 1 | 243 | 322 | 402 | YP_010840343.1 NS [Plasmopara viticola lesion associated mycobunyavirales-like virus 4] | diamond | 243 | 128 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Discoviridae | Orthodiscovirus | Orthodiscovirus iberiae | ||
| 28889121 | 28889121 | PRJNA971593_P_NODE_3208_length_672_cov_1.308848_g3065_i0 | PRJNA971593 | 3208 | 672 | 1.308848 | 8.79545856 | Narcissus common latent virus | 160844 | Viruses | Viruses | 396 | 3.95e-138 | NR | YP_699984.1 | 160844 | g3065 | i0 | 85.1 | 0.991071428571429 | 222 | 33 | 99.1 | 0 | 670 | 5 | 6 | 227 | YP_699984.1 Triple Gene Block protein 1 [Narcissus common latent virus] | diamond | 666 | 396 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensnarcissi | ||
| 29552041 | 29552041 | PRJNA971593_P_NODE_150_length_2214_cov_7.376460_g104_i0 | PRJNA971593 | 150 | 2214 | 7.37646 | 163.3148244 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 184 | 1.97e-46 | NR | YP_010781610.1 | 2126985 | g104 | i0 | 30.4 | 0.708672086720867 | 523 | 236 | 68.2 | 24 | 606 | 2114 | 83 | 497 | YP_010781610.1 hypothetical protein QJ857_gp1097 [Tupanvirus soda lake] | diamond | 1569 | 184 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 29646552 | 29646552 | PRJNA971593_P_NODE_17890_length_282_cov_1.133971_g17741_i0 | PRJNA971593 | 17890 | 282 | 1.133971 | 3.19779822 | Bodo saltans virus | 2024608 | Viruses | Viruses | 56.2 | 8.19e-7 | NR | YP_010778711.1 | 2024608 | g17741 | i0 | 31.9 | 1.92553191489362 | 94 | 59 | 97.9 | 3 | 279 | 4 | 48 | 138 | YP_010778711.1 hypothetical protein QJ851_gp0872 [Bodo saltans virus] | diamond | 543 | 56.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Theiavirus | Theiavirus salishense | ||
| 29684493 | 29684493 | PRJNA971593_P_NODE_7110_length_456_cov_1.394256_g6961_i0 | PRJNA971593 | 7110 | 456 | 1.394256 | 6.35780736 | Viruses | 10239 | Viruses | Viruses | 71.6 | 1.42e-11 | NR | AYV78946.1 | 2487765 | g6961 | i0 | 24.7 | 2.03947368421053 | 154 | 112 | 99.3 | 2 | 454 | 2 | 103 | 255 | AYV78946.1 MAG: hypothetical protein Edafosvirus56_2 [Edafosvirus sp.] | diamond | 930 | 72 | 0.994444444444444 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Edafosvirus sp. | |||
| 29899732 | 29899732 | PRJNA971593_P_NODE_18151_length_280_cov_1.115942_g18002_i0 | PRJNA971593 | 18151 | 280 | 1.115942 | 3.1246376 | Comovirinae sp. | 2767531 | Viruses | Viruses | 164 | 1.15e-44 | NR | QNN26328.1 | 2767531 | g18002 | i0 | 98.9 | 0.985714285714286 | 92 | 1 | 98.6 | 0 | 278 | 3 | 402 | 493 | QNN26328.1 polyprotein [Comovirinae sp.] | diamond | 276 | 164 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Comovirinae sp. | |||
| 30032354 | 30032354 | PRJNA971593_P_NODE_27971_length_243_cov_0.905882_g27822_i0 | PRJNA971593 | 27971 | 243 | 0.905882 | 2.20129326 | root | 1 | Root_unresolved | Root_unresolved | 45.1 | 0.00499 | NR | ARF08773.1 | 1977631 | g27822 | i0 | 64.7 | 0.91358024691358 | 34 | 12 | 42 | 0 | 103 | 2 | 97 | 130 | ARF08773.1 mitochondrial carrier protein [Catovirus CTV1] | diamond | 222 | 45.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus CTV1 | ||
| 30247355 | 30247355 | PRJNA971593_P_NODE_6972_length_461_cov_1.219072_g6823_i0 | PRJNA971593 | 6972 | 461 | 1.219072 | 5.61992192 | Burswood narna-like virus | 3118308 | Viruses | Viruses | 57 | 4.05e-6 | NR | WVL03117.1 | 3118308 | g6823 | i0 | 41.4 | 0.455531453362256 | 70 | 37 | 45.6 | 2 | 390 | 181 | 976 | 1041 | WVL03117.1 RdRp [Burswood narna-like virus] | diamond | 210 | 57 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Burswood narna-like virus | |||
| 30537749 | 30537749 | PRJNA971593_P_NODE_3933_length_610_cov_1.811918_g3789_i0 | PRJNA971593 | 3933 | 610 | 1.811918 | 11.0526998 | Viruses | 10239 | Viruses | Viruses | 49.3 | 0.00471 | NR | CAH6420287.1 | 340016 | g3789 | i0 | 22.9 | 1.62786885245902 | 166 | 113 | 81.6 | 3 | 75 | 572 | 56 | 206 | CAH6420287.1 Large eukaryotic DNA virus major capsid protein [uncultured virus] | diamond | 993 | 49.3 | 1 | Viruses | uncultured virus | ||||||||
| 30626097 | 30626097 | PRJNA971593_P_NODE_24153_length_248_cov_0.954286_g24004_i0 | PRJNA971593 | 24153 | 248 | 0.954286 | 2.36662928 | Erysiphe necator associated narnavirus 8 | 2736412 | Viruses | Viruses | 56.6 | 5.19e-7 | NR | QJT93740.1 | 2736412 | g24004 | i0 | 50 | 0.604838709677419 | 50 | 25 | 60.5 | 0 | 99 | 248 | 86 | 135 | QJT93740.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 8] | diamond | 150 | 56.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Erysiphe necator associated narnavirus 8 | ||
| 30847448 | 30847448 | PRJNA971593_P_NODE_23974_length_249_cov_0.875000_g23825_i0 | PRJNA971593 | 23974 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 66.2 | 1.71e-10 | NR | QHJ79075.1 | 2832643 | g23825 | i0 | 42.1 | 3.32530120481928 | 76 | 41 | 88 | 1 | 22 | 240 | 2 | 77 | QHJ79075.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 828 | 66.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30942391 | 30942391 | PRJNA971593_P_NODE_21414_length_254_cov_1.591160_g21265_i0 | PRJNA971593 | 21414 | 254 | 1.59116 | 4.0415464 | Wufeng shrew iflavirus 7 | 3084803 | Viruses | Viruses | 89.7 | 1.28e-18 | NR | WPV63249.1 | 3084803 | g21265 | i0 | 50 | 0.992125984251969 | 84 | 42 | 99.2 | 0 | 1 | 252 | 2385 | 2468 | WPV63249.1 MAG: polyprotein [Wufeng shrew iflavirus 7] | diamond | 252 | 89.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Wufeng shrew iflavirus 7 | ||
| 31511450 | 31511450 | PRJNA971593_P_NODE_1036_length_1101_cov_1.546693_g940_i0 | PRJNA971593 | 1036 | 1101 | 1.546693 | 17.02908993 | Comovirinae sp. | 2767531 | Viruses | Viruses | 660 | 6.97e-230 | NR | QNN26327.1 | 2767531 | g940 | i0 | 94.2 | 0.942779291553134 | 346 | 20 | 94.3 | 0 | 1038 | 1 | 542 | 887 | QNN26327.1 polyprotein 2 [Comovirinae sp.] | diamond | 1038 | 660 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Comovirinae sp. | |||
| 31511469 | 31511469 | PRJNA971593_P_NODE_2636_length_734_cov_1.611195_g2500_i0 | PRJNA971593 | 2636 | 734 | 1.611195 | 11.8261713 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 126 | 6.26e-29 | NR | WLN26256.1 | 3065075 | g2500 | i0 | 44.1 | 0.592643051771117 | 145 | 81 | 59.3 | 0 | 726 | 292 | 90 | 234 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 435 | 126 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 32365684 | 32365684 | PRJNA971593_P_NODE_20059_length_265_cov_1.203125_g19910_i0 | PRJNA971593 | 20059 | 265 | 1.203125 | 3.18828125 | Pleurochrysis sp. endemic virus 1b | 2057945 | Viruses | Viruses | 46.6 | 0.00212 | NR | AUL80795.1 | 2057945 | g19910 | i0 | 36.8 | 0.645283018867924 | 57 | 33 | 61.1 | 1 | 76 | 237 | 461 | 517 | AUL80795.1 NCLDV Major Capsid Protein [Pleurochrysis sp. endemic virus 1b] | diamond | 171 | 46.6 | 1 | Viruses | Pleurochrysis sp. endemic virus 1b | ||||||||
| 32555618 | 32555618 | PRJNA971593_P_NODE_28739_length_242_cov_0.863905_g28590_i0 | PRJNA971593 | 28739 | 242 | 0.863905 | 2.0906501 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 62.8 | 3.28e-9 | NR | CAB4196507.1 | 2100421 | g28590 | i0 | 42.1 | 0.942148760330578 | 76 | 44 | 94.2 | 0 | 13 | 240 | 223 | 298 | CAB4196507.1 hypothetical protein UFOVP1290_27 [uncultured Caudovirales phage] | diamond | 228 | 62.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32681020 | 32681020 | PRJNA971593_P_NODE_20640_length_260_cov_1.379679_g20491_i0 | PRJNA971593 | 20640 | 260 | 1.379679 | 3.5871654 | Narcissus common latent virus | 160844 | Viruses | Viruses | 171 | 4.569999999999999e-47 | NR | YP_699983.1 | 160844 | g20491 | i0 | 96.5 | 0.992307692307692 | 86 | 3 | 99.2 | 0 | 260 | 3 | 1528 | 1613 | YP_699983.1 RNA-dependent RNA polymerase [Narcissus common latent virus] | diamond | 258 | 171 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensnarcissi |
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);;