contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA1063685" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9107295 | 9107295 | PRJNA1063685_S_NODE_48628_length_325_cov_3.198413_g48085_i0 | PRJNA1063685 | 48628 | 325 | 3.198413 | 10.39484225 | Ustilaginoidea virens partitivirus 14 | 2971976 | Viruses | Viruses | 163 | 6.599999999999999e-46 | NR | UVX28931.1 | 2971976 | g48085 | i0 | 82.3 | 1.82769230769231 | 96 | 17 | 88.6 | 0 | 34 | 321 | 96 | 191 | UVX28931.1 MAG: RNA dependent RNA polymerase [Ustilaginoidea virens partitivirus 14] | diamond | 594 | 163 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Ustilaginoidea virens partitivirus 14 | |||
| 27027156 | 27027156 | PRJNA1063685_S_NODE_29382_length_433_cov_7.675000_g28840_i0 | PRJNA1063685 | 29382 | 433 | 7.675 | 33.23275 | Pandoravirus | 2060084 | Viruses | Viruses | 118 | 1.37e-27 | NR | YP_009481560.1 | 2107707 | g28840 | i0 | 54.6 | 4.35103926096998 | 97 | 39 | 63.7 | 1 | 8 | 283 | 1645 | 1741 | YP_009481560.1 serine-threonine kinase [Pandoravirus macleodensis] | diamond | 1884 | 118 | 1 | Viruses | Pandoravirus | Pandoravirus macleodensis | |||||||
| 27098675 | 27098675 | PRJNA1063685_S_NODE_15442_length_557_cov_3.376033_g14914_i0 | PRJNA1063685 | 15442 | 557 | 3.376033 | 18.80450381 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 80.5 | 4.68e-14 | NR | CAB4130906.1 | 2100421 | g14914 | i0 | 56.8 | 0.398563734290844 | 74 | 32 | 39.9 | 0 | 444 | 223 | 295 | 368 | CAB4130906.1 S14_ClpP_1 domain containing protein [uncultured Caudovirales phage] | diamond | 222 | 80.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27415063 | 27415063 | PRJNA1063685_S_NODE_67403_length_257_cov_1.913043_g66860_i0 | PRJNA1063685 | 67403 | 257 | 1.913043 | 4.91652051 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 91.7 | 9.92e-20 | NR | YP_010782487.1 | 2126985 | g66860 | i0 | 53 | 0.968871595330739 | 83 | 38 | 95.7 | 1 | 246 | 1 | 218 | 300 | YP_010782487.1 phosphoribosyl transferase domain protein [Tupanvirus soda lake] | diamond | 249 | 91.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 27817166 | 27817166 | PRJNA1063685_S_NODE_45304_length_341_cov_2.264925_g44761_i0 | PRJNA1063685 | 45304 | 341 | 2.264925 | 7.72339425 | Totivirus | 11007 | Viruses | Viruses | 102 | 9.97e-23 | NR | QJW70335.1 | 2737096 | g44761 | i0 | 48.4 | 1.67155425219941 | 95 | 49 | 83.6 | 0 | 323 | 39 | 702 | 796 | QJW70335.1 RNA-dependent RNA polymerase [Erysiphe necator associated totivirus 6] | diamond | 570 | 102 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Erysiphe necator associated totivirus 6 | ||
| 27856704 | 27856704 | PRJNA1063685_S_NODE_27425_length_448_cov_2.440000_g26884_i0 | PRJNA1063685 | 27425 | 448 | 2.44 | 10.9312 | Adintovirus notospermus15 | 3115931 | Viruses | Viruses | 130 | 3.71e-33 | NR | DBA47338.1 | 3115931 | g26884 | i0 | 46.3 | 2.98660714285714 | 149 | 74 | 98.4 | 3 | 5 | 445 | 72 | 216 | DBA47338.1 MAG TPA_asm: Integrase [Adintovirus notospermus15040] | diamond | 1338 | 130 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus notospermus15040 | |||
| 28227168 | 28227168 | PRJNA1063685_S_NODE_1606_length_969_cov_13.924107_g1314_i0 | PRJNA1063685 | 1606 | 969 | 13.924107 | 134.92459683 | Lenarviricota | 2732407 | Viruses | Viruses | 97.8 | 2.06e-18 | NR | UJQ92589.1 | 2809572 | g1314 | i0 | 34.6 | 1.1671826625387 | 188 | 105 | 53.3 | 9 | 3 | 518 | 507 | 692 | UJQ92589.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.] | diamond | 1131 | 97.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 29309125 | 29309125 | PRJNA1063685_S_NODE_31529_length_418_cov_2.443478_g30987_i0 | PRJNA1063685 | 31529 | 418 | 2.443478 | 10.21373804 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 104 | 3.69e-25 | NR | YP_010804033.1 | 3060017 | g30987 | i0 | 37.2 | 0.983253588516746 | 137 | 83 | 98.3 | 1 | 411 | 1 | 5 | 138 | YP_010804033.1 mitochondrial 18kda protein [Fadolivirus algeromassiliense] | diamond | 411 | 104 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 29458501 | 29458501 | PRJNA1063685_S_NODE_19310_length_516_cov_6.823928_g18773_i0 | PRJNA1063685 | 19310 | 516 | 6.823928 | 35.21146848 | Totivirus | 11007 | Viruses | Viruses | 139 | 9.91e-35 | NR | QJW70338.1 | 2737097 | g18773 | i0 | 43 | 1.84883720930233 | 158 | 90 | 91.9 | 0 | 39 | 512 | 28 | 185 | QJW70338.1 coat protein [Erysiphe necator associated totivirus 7] | diamond | 954 | 140 | 0.992857142857143 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Erysiphe necator associated totivirus 7 | ||
| 29592964 | 29592964 | PRJNA1063685_S_NODE_42430_length_355_cov_7.971631_g41887_i0 | PRJNA1063685 | 42430 | 355 | 7.971631 | 28.29929005 | Trichoderma gamsii alphapartitivirus 1 | 3032463 | Viruses | Viruses | 209 | 5.26e-62 | NR | WGH72964.1 | 3032463 | g41887 | i0 | 86.4 | 0.929577464788732 | 110 | 15 | 93 | 0 | 18 | 347 | 70 | 179 | WGH72964.1 MAG: putative RNA-dependent RNA polymerase [Trichoderma gamsii alphapartitivirus 1] | diamond | 330 | 209 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Alphapartitivirus | Trichoderma gamsii alphapartitivirus 1 | ||
| 29782790 | 29782790 | PRJNA1063685_S_NODE_23171_length_480_cov_12.783784_g22631_i0 | PRJNA1063685 | 23171 | 480 | 12.783784 | 61.3621632 | Malassezia restricta virus MrV4 | 76775 | Viruses | Viruses | 112 | 1.82e-28 | NR | QJA42333.1 | 2727864 | g22631 | i0 | 62.5 | 0.5 | 80 | 30 | 50 | 0 | 240 | 479 | 1 | 80 | QJA42333.1 hypothetical protein MRV40S_001 [Malassezia restricta virus MrV40S] | diamond | 240 | 112 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 29940914 | 29940914 | PRJNA1063685_S_NODE_52691_length_307_cov_4.363248_g52148_i0 | PRJNA1063685 | 52691 | 307 | 4.363248 | 13.39517136 | Erysiphe necator associated virga-like virus 9 | 2743136 | Viruses | Viruses | 114 | 4.33e-27 | NR | QKN22706.1 | 2743136 | g52148 | i0 | 55.7 | 3.79153094462541 | 97 | 41 | 92.8 | 1 | 292 | 8 | 1014 | 1110 | QKN22706.1 RNA-dependent RNA polymerase [Erysiphe necator associated virga-like virus 9] | diamond | 1164 | 114 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Erysiphe necator associated virga-like virus 9 | |||
| 29940917 | 29940917 | PRJNA1063685_S_NODE_57611_length_288_cov_7.246512_g57068_i0 | PRJNA1063685 | 57611 | 288 | 7.246512 | 20.86995456 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 82.4 | 7.13e-16 | NR | UJQ92566.1 | 2809572 | g57068 | i0 | 52.5 | 0.635416666666667 | 61 | 29 | 63.5 | 0 | 104 | 286 | 2 | 62 | UJQ92566.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.] | diamond | 183 | 82.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 30035590 | 30035590 | PRJNA1063685_S_NODE_40971_length_363_cov_4.534483_g40428_i0 | PRJNA1063685 | 40971 | 363 | 4.534483 | 16.46017329 | Totivirus sp. | 2776824 | Viruses | Viruses | 155 | 9.33e-45 | NR | QOQ37363.1 | 2776824 | g40428 | i0 | 71.7 | 0.933884297520661 | 113 | 32 | 93.4 | 0 | 340 | 2 | 24 | 136 | QOQ37363.1 RNA-dependent RNA polymerase, partial [Totivirus sp.] | diamond | 339 | 155 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 30730604 | 30730604 | PRJNA1063685_S_NODE_62334_length_272_cov_2.748744_g61791_i0 | PRJNA1063685 | 62334 | 272 | 2.748744 | 7.47658368 | Sylvanvirus sp. | 2487774 | Viruses | Viruses | 94.4 | 3.87e-20 | NR | AYV86995.1 | 2487774 | g61791 | i0 | 53.1 | 1.85294117647059 | 81 | 31 | 89.3 | 2 | 29 | 271 | 885 | 958 | AYV86995.1 MAG: putative DNA topoisomerase 2-like isoform X1 [Sylvanvirus sp.] | diamond | 504 | 94.4 | 1 | Viruses | Sylvanvirus sp. | ||||||||
| 31204057 | 31204057 | PRJNA1063685_S_NODE_16195_length_548_cov_10.400000_g15665_i0 | PRJNA1063685 | 16195 | 548 | 10.4 | 56.992 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 181 | 2.18e-49 | NR | CAI9858973.1 | 3048756 | g15665 | i0 | 59.9 | 0.804744525547445 | 147 | 59 | 80.5 | 0 | 107 | 547 | 59 | 205 | CAI9858973.1 RNA-dependent RNA polymerase [Malassezia globosa associated totivirus 1] | diamond | 441 | 181 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia globosa associated totivirus 1 | ||
| 31489449 | 31489449 | PRJNA1063685_S_NODE_21656_length_494_cov_4.152019_g21117_i0 | PRJNA1063685 | 21656 | 494 | 4.152019 | 20.51097386 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 58.9 | 7.66e-8 | NR | CAB4126251.1 | 2100421 | g21117 | i0 | 38.2 | 0.412955465587045 | 68 | 42 | 41.3 | 0 | 493 | 290 | 45 | 112 | CAB4126251.1 hypothetical protein UFOVP69_61 [uncultured Caudovirales phage] | diamond | 204 | 58.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32058569 | 32058569 | PRJNA1063685_S_NODE_44098_length_347_cov_1.967153_g43555_i0 | PRJNA1063685 | 44098 | 347 | 1.967153 | 6.82602091 | Red clover powdery mildew-associated totivirus 4 | 1714365 | Viruses | Viruses | 176 | 6.05e-49 | NR | BAT62484.1 | 1714365 | g43555 | i0 | 79.4 | 0.92507204610951 | 107 | 22 | 92.5 | 0 | 25 | 345 | 86 | 192 | BAT62484.1 RNA dependent RNA polymerase, partial [Red clover powdery mildew-associated totivirus 4] | diamond | 321 | 176 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Red clover powdery mildew-associated totivirus 4 | |||
| 32312024 | 32312024 | PRJNA1063685_S_NODE_14219_length_571_cov_6.590361_g13694_i0 | PRJNA1063685 | 14219 | 571 | 6.590361 | 37.630961310000004 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 180 | 1.33e-50 | NR | CAB4126196.1 | 2100421 | g13694 | i0 | 59.5 | 0.882661996497373 | 168 | 64 | 88.3 | 1 | 565 | 62 | 17 | 180 | CAB4126196.1 Bacteriophage HP1, Orf23 [uncultured Caudovirales phage] | diamond | 504 | 180 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32375131 | 32375131 | PRJNA1063685_S_NODE_61539_length_275_cov_1.094059_g60996_i0 | PRJNA1063685 | 61539 | 275 | 1.094059 | 3.00866225 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 88.2 | 5.07e-18 | NR | YP_010782467.1 | 2126985 | g60996 | i0 | 50.5 | 0.992727272727273 | 91 | 43 | 99.3 | 2 | 273 | 1 | 344 | 432 | YP_010782467.1 hypothetical protein QJ857_gp0240 [Tupanvirus soda lake] | diamond | 273 | 88.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 32785157 | 32785157 | PRJNA1063685_S_NODE_79540_length_213_cov_6.078571_g78997_i0 | PRJNA1063685 | 79540 | 213 | 6.078571 | 12.94735623 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 61.2 | 7.42e-9 | NR | CAI9858976.1 | 3048757 | g78997 | i0 | 76.9 | 0.549295774647887 | 39 | 9 | 54.9 | 0 | 74 | 190 | 523 | 561 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 117 | 61.2 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 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);;