contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA725806" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26767444 | 26767444 | PRJNA725806_P_NODE_78141_length_215_cov_3.893258_g77840_i0 | PRJNA725806 | 78141 | 215 | 3.893258 | 8.3705047 | Androctonus mauritanicus toursvirus | 3394651 | Viruses | Viruses | 73.9 | 1.63e-13 | NR | XNL98191.1 | 3394651 | g77840 | i0 | 76.9 | 0.544186046511628 | 39 | 9 | 54.4 | 0 | 137 | 21 | 11 | 49 | XNL98191.1 hypothetical protein [Androctonus mauritanicus toursvirus] | diamond | 117 | 73.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Ascoviridae | Toursvirus | Androctonus mauritanicus toursvirus | ||
| 27052374 | 27052374 | PRJNA725806_P_NODE_37762_length_270_cov_1.343348_g37465_i0 | PRJNA725806 | 37762 | 270 | 1.343348 | 3.6270396 | Parvovirus puccinia4426 | 3117190 | Viruses | Viruses | 70.1 | 1.25e-11 | NR | DBA47703.1 | 3117190 | g37465 | i0 | 55.4 | 1.27777777777778 | 56 | 25 | 62.2 | 0 | 177 | 10 | 6 | 61 | DBA47703.1 MAG TPA_asm: VP [Parvovirus puccinia4426] | diamond | 345 | 70.1 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus puccinia4426 | |||
| 27241813 | 27241813 | PRJNA725806_P_NODE_137123_length_175_cov_1.652174_g136821_i0 | PRJNA725806 | 137123 | 175 | 1.652174 | 2.8913045 | Dothistroma septosporum gammaflexivirus 1 | 3104549 | Viruses | Viruses | 106 | 6.46e-25 | NR | WPV70693.1 | 3104549 | g136821 | i0 | 87.9 | 0.994285714285714 | 58 | 7 | 99.4 | 0 | 174 | 1 | 412 | 469 | WPV70693.1 MAG: replicase [Dothistroma septosporum gammaflexivirus 1] | diamond | 174 | 106 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Gammaflexiviridae | Gammaflexivirus | Dothistroma septosporum gammaflexivirus 1 | ||
| 27463235 | 27463235 | PRJNA725806_P_NODE_182743_length_155_cov_1.296610_g182441_i0 | PRJNA725806 | 182743 | 155 | 1.29661 | 2.0097455 | Streptomyces phage Wakanda | 2713267 | Viruses | Viruses | 54.7 | 5.76e-7 | NR | YP_010652113.1 | 2713267 | g182441 | i0 | 45.1 | 0.987096774193548 | 51 | 28 | 98.7 | 0 | 153 | 1 | 20 | 70 | YP_010652113.1 hypothetical protein PP459_gp211 [Streptomyces phage Wakanda] | diamond | 153 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Stanwilliamsviridae | Wakandavirus | Wakandavirus wakanda | |||
| 27463236 | 27463236 | PRJNA725806_P_NODE_183583_length_154_cov_5.538462_g183281_i0 | PRJNA725806 | 183583 | 154 | 5.538462 | 8.52923148 | Photinus pyralis orthomyxo-like virus 1 | 2137183 | Viruses | Viruses | 60.8 | 4.52e-9 | NR | AVR52565.1 | 2137183 | g183281 | i0 | 64.9 | 0.720779220779221 | 37 | 13 | 72.1 | 0 | 1 | 111 | 156 | 192 | AVR52565.1 NP [Photinus pyralis orthomyxo-like virus 1] | diamond | 111 | 60.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Photinus pyralis orthomyxo-like virus 1 | |||
| 27652696 | 27652696 | PRJNA725806_P_NODE_3924_length_469_cov_2.379630_g3655_i0 | PRJNA725806 | 3924 | 469 | 2.37963 | 11.1604647 | Androctonus mauritanicus toursvirus | 3394651 | Viruses | Viruses | 180 | 6.42e-53 | NR | XNL98191.1 | 3394651 | g3655 | i0 | 67 | 0.735607675906183 | 115 | 38 | 73.6 | 0 | 378 | 34 | 119 | 233 | XNL98191.1 hypothetical protein [Androctonus mauritanicus toursvirus] | diamond | 345 | 180 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Ascoviridae | Toursvirus | Androctonus mauritanicus toursvirus | ||
| 28157966 | 28157966 | PRJNA725806_P_NODE_143885_length_171_cov_7.723881_g143583_i0 | PRJNA725806 | 143885 | 171 | 7.723881 | 13.20783651 | Androctonus mauritanicus toursvirus | 3394651 | Viruses | Viruses | 52 | 7.27e-6 | NR | XNL98191.1 | 3394651 | g143583 | i0 | 54.5 | 1.47368421052632 | 33 | 15 | 57.9 | 0 | 53 | 151 | 270 | 302 | XNL98191.1 hypothetical protein [Androctonus mauritanicus toursvirus] | diamond | 252 | 52 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Ascoviridae | Toursvirus | Androctonus mauritanicus toursvirus | ||
| 28347159 | 28347159 | PRJNA725806_P_NODE_89126_length_205_cov_9.910714_g88824_i0 | PRJNA725806 | 89126 | 205 | 9.910714 | 20.3169637 | Adintovirus androctonus13 | 3115887 | Viruses | Viruses | 44.3 | 0.00646 | NR | DBA46921.1 | 3115887 | g88824 | i0 | 61.3 | 0.878048780487805 | 31 | 12 | 45.4 | 0 | 5 | 97 | 381 | 411 | DBA46921.1 MAG TPA_asm: Hexon [Adintovirus androctonus13035] | diamond | 180 | 44.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 28947297 | 28947297 | PRJNA725806_P_NODE_13088_length_352_cov_2.873016_g12798_i0 | PRJNA725806 | 13088 | 352 | 2.873016 | 10.11301632 | Erysiphe necator associated abispo virus 3 | 2748677 | Viruses | Viruses | 165 | 5.86e-46 | NR | QLC27602.1 | 2748677 | g12798 | i0 | 70.9 | 0.9375 | 110 | 32 | 93.8 | 0 | 13 | 342 | 337 | 446 | QLC27602.1 putative methyltransferase [Erysiphe necator associated abispo virus 3] | diamond | 330 | 165 | 1 | Viruses | Erysiphe necator associated abispo virus 3 | ||||||||
| 29231369 | 29231369 | PRJNA725806_P_NODE_112689_length_188_cov_13.105960_g112387_i0 | PRJNA725806 | 112689 | 188 | 13.10596 | 24.6392048 | Androctonus mauritanicus toursvirus | 3394651 | Viruses | Viruses | 63.9 | 4.98e-10 | NR | XNL98191.1 | 3394651 | g112387 | i0 | 52.9 | 0.813829787234043 | 51 | 22 | 78.2 | 1 | 148 | 2 | 270 | 320 | XNL98191.1 hypothetical protein [Androctonus mauritanicus toursvirus] | diamond | 153 | 63.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Ascoviridae | Toursvirus | Androctonus mauritanicus toursvirus | ||
| 29389292 | 29389292 | PRJNA725806_P_NODE_99689_length_197_cov_6.700000_g99387_i0 | PRJNA725806 | 99689 | 197 | 6.7 | 13.199 | Orthopteran chu-related virus OKIAV152 | 2792595 | Viruses | Viruses | 58.2 | 7.36e-8 | NR | QPL15390.1 | 2792595 | g99387 | i0 | 48 | 0.761421319796954 | 50 | 26 | 76.1 | 0 | 2 | 151 | 413 | 462 | QPL15390.1 glycoprotein [Orthopteran chu-related virus OKIAV152] | diamond | 150 | 58.2 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Orthopteran chu-related virus OKIAV152 | |||
| 29578324 | 29578324 | PRJNA725806_P_NODE_8610_length_389_cov_3.838068_g8325_i0 | PRJNA725806 | 8610 | 389 | 3.838068 | 14.93008452 | Adintovirus homo33 | 3115912 | Viruses | Viruses | 65.9 | 1.39e-9 | NR | DBA48451.1 | 3115912 | g8325 | i0 | 52.1 | 0.370179948586118 | 48 | 23 | 37 | 0 | 162 | 19 | 6 | 53 | DBA48451.1 MAG TPA_asm: Hexon [Adintovirus homo3309] | diamond | 144 | 65.9 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus homo3309 | |||
| 29609784 | 29609784 | PRJNA725806_P_NODE_63390_length_231_cov_1.577320_g63092_i0 | PRJNA725806 | 63390 | 231 | 1.57732 | 3.6436092 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 80.5 | 1.21e-15 | NR | XOR24860.1 | 2832643 | g63092 | i0 | 53.5 | 0.922077922077922 | 71 | 33 | 92.2 | 0 | 223 | 11 | 185 | 255 | XOR24860.1 MAG: putative amidoligase [Caudoviricetes sp.] | diamond | 213 | 80.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30020839 | 30020839 | PRJNA725806_P_NODE_138271_length_174_cov_4.204380_g137969_i0 | PRJNA725806 | 138271 | 174 | 4.20438 | 7.3156212 | Androctonus mauritanicus toursvirus | 3394651 | Viruses | Viruses | 66.6 | 4.47e-11 | NR | XNL98191.1 | 3394651 | g137969 | i0 | 53.1 | 0.844827586206897 | 49 | 23 | 84.5 | 0 | 13 | 159 | 273 | 321 | XNL98191.1 hypothetical protein [Androctonus mauritanicus toursvirus] | diamond | 147 | 66.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Ascoviridae | Toursvirus | Androctonus mauritanicus toursvirus | ||
| 30368693 | 30368693 | PRJNA725806_P_NODE_8712_length_388_cov_2.444444_g8427_i0 | PRJNA725806 | 8712 | 388 | 2.444444 | 9.48444272 | Adintovirus androctonus13 | 3115887 | Viruses | Viruses | 154 | 2.3299999999999993e-42 | NR | DBA46921.1 | 3115887 | g8427 | i0 | 58.9 | 1.91752577319588 | 124 | 51 | 95.9 | 0 | 1 | 372 | 262 | 385 | DBA46921.1 MAG TPA_asm: Hexon [Adintovirus androctonus13035] | diamond | 744 | 154 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 30494721 | 30494721 | PRJNA725806_P_NODE_180293_length_156_cov_0.932773_g179991_i0 | PRJNA725806 | 180293 | 156 | 0.932773 | 1.45512588 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 79 | 6.43e-16 | NR | XOR75348.1 | 2832643 | g179991 | i0 | 74.5 | 0.980769230769231 | 51 | 13 | 98.1 | 0 | 2 | 154 | 69 | 119 | XOR75348.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 153 | 79 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30494749 | 30494749 | PRJNA725806_P_NODE_82833_length_211_cov_2.247126_g82532_i0 | PRJNA725806 | 82833 | 211 | 2.247126 | 4.74143586 | Cafeteria roenbergensis virus BV-PW1 | 693272 | Viruses | Viruses | 43.1 | 0.0173 | NR | YP_003969900.1 | 693272 | g82532 | i0 | 39.6 | 0.753554502369668 | 53 | 30 | 72.5 | 1 | 48 | 200 | 182 | 234 | YP_003969900.1 hypothetical protein crov268 [Cafeteria roenbergensis virus BV-PW1] | diamond | 159 | 43.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Rheavirus | Rheavirus sinusmexicani | ||
| 30567804 | 30567804 | PRJNA725806_P_NODE_121813_length_183_cov_3.561644_g121511_i0 | PRJNA725806 | 121813 | 183 | 3.561644 | 6.51780852 | Caeruleovirus | 1911929 | Viruses | Viruses | 40 | 0.0274 | NR | YP_009031458.1 | 584892 | g121511 | i0 | 35.4 | 1.57377049180328 | 48 | 31 | 78.7 | 0 | 176 | 33 | 10 | 57 | YP_009031458.1 membrane protein [Bacillus phage Bcp1] | diamond | 288 | 40 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Caeruleovirus | Caeruleovirus Bcp1 | |||
| 31948718 | 31948718 | PRJNA725806_P_NODE_32617_length_281_cov_2.057377_g32320_i0 | PRJNA725806 | 32617 | 281 | 2.057377 | 5.78122937 | Xanthomonas phage XbC2 | 2978503 | Viruses | Viruses | 70.1 | 5.72e-12 | NR | UYE98799.1 | 2978503 | g32320 | i0 | 41.3 | 0.800711743772242 | 75 | 40 | 75.8 | 1 | 46 | 258 | 32 | 106 | UYE98799.1 RNA synthetase class II [Xanthomonas phage XbC2] | diamond | 225 | 70.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Mimasvirus | Xanthomonas phage XbC2 | ||||
| 31980371 | 31980371 | PRJNA725806_P_NODE_111498_length_189_cov_5.940789_g111196_i0 | PRJNA725806 | 111498 | 189 | 5.940789 | 11.22809121 | Megastigmus wasp adintovirus | 2609859 | Viruses | Viruses | 45.1 | 0.00279 | NR | DAC81331.1 | 2609859 | g111196 | i0 | 57.1 | 0.555555555555556 | 35 | 15 | 55.6 | 0 | 182 | 78 | 232 | 266 | DAC81331.1 TPA_asm: PolB [Megastigmus wasp adintovirus] | diamond | 105 | 45.1 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Megastigmus wasp adintovirus | |||
| 32043737 | 32043737 | PRJNA725806_P_NODE_112338_length_189_cov_1.861842_g112036_i0 | PRJNA725806 | 112338 | 189 | 1.861842 | 3.51888138 | Plasmopara viticola lesion associated mitovirus 27 | 2719453 | Viruses | Viruses | 69.7 | 5.51e-12 | NR | QIR30250.1 | 2719453 | g112036 | i0 | 60.7 | 0.888888888888889 | 56 | 22 | 88.9 | 0 | 182 | 15 | 34 | 89 | QIR30250.1 RNA-dependent RNA polymerase [Plasmopara viticola lesion associated mitovirus 27] | diamond | 168 | 69.7 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Plasmopara viticola lesion associated mitovirus 27 | ||
| 32075403 | 32075403 | PRJNA725806_P_NODE_40018_length_265_cov_4.298246_g39721_i0 | PRJNA725806 | 40018 | 265 | 4.298246 | 11.3903519 | Partitiviridae sp. | 1955170 | Viruses | Viruses | 53.1 | 3.58e-6 | NR | WWV86449.1 | 1955170 | g39721 | i0 | 38.2 | 1.00754716981132 | 89 | 51 | 96.2 | 1 | 261 | 7 | 69 | 157 | WWV86449.1 MAG: putative capsid protein, partial [Partitiviridae sp.] | diamond | 267 | 53.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Partitiviridae sp. | |||
| 32613057 | 32613057 | PRJNA725806_P_NODE_52520_length_245_cov_1.639423_g52223_i0 | PRJNA725806 | 52520 | 245 | 1.639423 | 4.01658635 | Blattodean orthomyxo-related virus OKIAV181 | 2746285 | Viruses | Viruses | 85.5 | 3.29e-17 | NR | QMP82185.1 | 2746285 | g52223 | i0 | 53.9 | 0.930612244897959 | 76 | 35 | 93.1 | 0 | 230 | 3 | 376 | 451 | QMP82185.1 nucleocapsid protein [Blattodean orthomyxo-related virus OKIAV181] | diamond | 228 | 85.5 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Blattodean orthomyxo-related virus OKIAV181 | |||
| 32644286 | 32644286 | PRJNA725806_P_NODE_92120_length_203_cov_3.843373_g91818_i0 | PRJNA725806 | 92120 | 203 | 3.843373 | 7.80204719 | Adintovirus tuber11 | 3115950 | Viruses | Viruses | 61.2 | 6.03e-9 | NR | DBA47561.1 | 3115950 | g91818 | i0 | 52.3 | 1.71428571428571 | 65 | 26 | 91.6 | 2 | 187 | 2 | 285 | 347 | DBA47561.1 MAG TPA_asm: Adintoc3 [Adintovirus tuber11084] | diamond | 348 | 61.2 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus tuber11084 | |||
| 32801895 | 32801895 | PRJNA725806_P_NODE_91200_length_204_cov_2.221557_g90898_i0 | PRJNA725806 | 91200 | 204 | 2.221557 | 4.53197628 | Hubei lepidoptera virus 5 | 1922907 | Viruses | Viruses | 50.8 | 3.06e-5 | NR | APG79107.1 | 1922907 | g90898 | i0 | 41.7 | 0.705882352941177 | 48 | 27 | 70.6 | 1 | 154 | 11 | 196 | 242 | APG79107.1 hypothetical protein 4 [Hubei lepidoptera virus 5] | diamond | 144 | 50.8 | 1 | Viruses | Hubei lepidoptera virus 5 |
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);;