contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA376117" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26631732 | 26631732 | PRJNA376117_P_NODE_37061_length_248_cov_0.880000_g36759_i0 | PRJNA376117 | 37061 | 248 | 0.88 | 2.1824 | Enterococcus phage EF-P29 | 1932891 | Viruses | Viruses | 83.6 | 3.82e-17 | NR | APU00244.1 | 1932891 | g36759 | i0 | 53.8 | 0.967741935483871 | 80 | 37 | 96.8 | 0 | 245 | 6 | 164 | 243 | APU00244.1 hypothetical protein EFP29_58 [Enterococcus phage EF-P29] | diamond | 240 | 83.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Saphexavirus | Enterococcus phage EF-P29 | ||||
| 26790158 | 26790158 | PRJNA376117_P_NODE_43321_length_242_cov_0.911243_g43019_i0 | PRJNA376117 | 43321 | 242 | 0.911243 | 2.20520806 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 85.1 | 3.91e-18 | NR | DBA50340.1 | 2609864 | g43019 | i0 | 50 | 2.97520661157025 | 80 | 40 | 99.2 | 0 | 1 | 240 | 74 | 153 | DBA50340.1 MAG TPA_asm: PacK [Adintovirus pavo15764] | diamond | 720 | 85.1 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 26965389 | 26965389 | PRJNA376117_P_NODE_15322_length_350_cov_1.920578_g15020_i0 | PRJNA376117 | 15322 | 350 | 1.920578 | 6.722023 | root | 1 | Root_unresolved | Root_unresolved | 56.6 | 4.79e-7 | NR | XOS24387.1 | 2832643 | g15020 | i0 | 39 | 1.23428571428571 | 77 | 46 | 66 | 1 | 113 | 343 | 76 | 151 | XOS24387.1 MAG: putative tail fiber protein [Caudoviricetes sp.] | diamond | 432 | 56.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27643772 | 27643772 | PRJNA376117_P_NODE_43704_length_242_cov_0.911243_g43402_i0 | PRJNA376117 | 43704 | 242 | 0.911243 | 2.20520806 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 54.3 | 2.26e-6 | NR | DBA50496.1 | 3115894 | g43402 | i0 | 43 | 0.979338842975207 | 79 | 45 | 97.9 | 0 | 1 | 237 | 73 | 151 | DBA50496.1 MAG TPA_asm: Adintoc2 [Adintovirus bos4377] | diamond | 237 | 54.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 27675380 | 27675380 | PRJNA376117_P_NODE_39444_length_246_cov_0.890173_g39142_i0 | PRJNA376117 | 39444 | 246 | 0.890173 | 2.18982558 | Pseudomonas phage GP1 | 2055238 | Viruses | Viruses | 152 | 8.03e-41 | NR | SPF82138.1 | 2055238 | g39142 | i0 | 93.8 | 0.98780487804878 | 81 | 5 | 98.8 | 0 | 244 | 2 | 1143 | 1223 | SPF82138.1 hypothetical protein [Pseudomonas phage GP100] | diamond | 243 | 152 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zobellviridae | Pseudomonas phage GP100 | ||||
| 27770077 | 27770077 | PRJNA376117_P_NODE_31324_length_260_cov_1.235294_g31022_i0 | PRJNA376117 | 31324 | 260 | 1.235294 | 3.2117644 | Vibrio phage jenny 12G5 | 573176 | Viruses | Viruses | 123 | 1.18e-32 | NR | AGN51381.1 | 573176 | g31022 | i0 | 69.8 | 1.97307692307692 | 86 | 26 | 99.2 | 0 | 1 | 258 | 87 | 172 | AGN51381.1 DNA methylase [Vibrio phage jenny 12G5] | diamond | 513 | 123 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage jenny 12G5 | |||||
| 28180089 | 28180089 | PRJNA376117_P_NODE_22106_length_294_cov_1.393665_g21804_i0 | PRJNA376117 | 22106 | 294 | 1.393665 | 4.0973751 | Bacteriophage sp. | 38018 | Viruses | Viruses | 107 | 1.2699999999999999e-24 | NR | QHJ81062.1 | 38018 | g21804 | i0 | 59.6 | 0.908163265306122 | 89 | 36 | 90.8 | 0 | 292 | 26 | 617 | 705 | QHJ81062.1 MAG: hypothetical protein [Bacteriophage sp.] | diamond | 267 | 107 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 28369671 | 28369671 | PRJNA376117_P_NODE_30206_length_264_cov_1.554974_g29904_i0 | PRJNA376117 | 30206 | 264 | 1.554974 | 4.10513136 | Aeromonas phage 1233 | 3074390 | Viruses | Viruses | 115 | 2.14e-30 | NR | WMX18609.1 | 3074390 | g29904 | i0 | 63.6 | 1 | 88 | 27 | 100 | 1 | 1 | 264 | 1 | 83 | WMX18609.1 hypothetical protein [Aeromonas phage 1233] | diamond | 264 | 115 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aeromonas phage 1233 | |||||
| 28464625 | 28464625 | PRJNA376117_P_NODE_44406_length_241_cov_0.916667_g44104_i0 | PRJNA376117 | 44406 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 50.4 | 6.48e-5 | NR | DAE71708.1 | 2832643 | g44104 | i0 | 55 | 0.49792531120332 | 40 | 18 | 49.8 | 0 | 120 | 239 | 17 | 56 | DAE71708.1 MAG TPA: DNA REPLICATION protein [Caudoviricetes sp.] | diamond | 120 | 50.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28496180 | 28496180 | PRJNA376117_P_NODE_16067_length_343_cov_1.233333_g15765_i0 | PRJNA376117 | 16067 | 343 | 1.233333 | 4.23033219 | Burdock mosaic virus | 3036445 | Viruses | Viruses | 229 | 6.729999999999999e-67 | NR | WEU75084.1 | 3036445 | g15765 | i0 | 98.2 | 0.997084548104956 | 114 | 2 | 99.7 | 0 | 2 | 343 | 1504 | 1617 | WEU75084.1 polyprotein [Burdock mosaic virus] | diamond | 342 | 229 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Torradovirus | Torradovirus arctii | ||
| 28496189 | 28496189 | PRJNA376117_P_NODE_31147_length_261_cov_0.872340_g30845_i0 | PRJNA376117 | 31147 | 261 | 0.87234 | 2.2768074 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 89 | 5.38e-19 | NR | XOR63742.1 | 2832643 | g30845 | i0 | 47.1 | 1 | 87 | 46 | 100 | 0 | 261 | 1 | 93 | 179 | XOR63742.1 MAG: putative virion structural protein [Caudoviricetes sp.] | diamond | 261 | 89 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28702707 | 28702707 | PRJNA376117_P_NODE_42447_length_243_cov_0.905882_g42145_i0 | PRJNA376117 | 42447 | 243 | 0.905882 | 2.20129326 | Winklervirus | 2560256 | Viruses | Viruses | 71.6 | 8.25e-13 | NR | YP_010092347.1 | 2006942 | g42145 | i0 | 43.9 | 2.80246913580247 | 66 | 37 | 81.5 | 0 | 2 | 199 | 59 | 124 | YP_010092347.1 baseplate hub assembly catalyst [Serratia phage X20] | diamond | 681 | 71.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Winklervirus | Winklervirus xtwenty | ||
| 29285251 | 29285251 | PRJNA376117_P_NODE_31229_length_260_cov_1.647059_g30927_i0 | PRJNA376117 | 31229 | 260 | 1.647059 | 4.2823534 | Pseudomonas phage PaBG | 1335230 | Viruses | Viruses | 56.2 | 8.26e-7 | NR | YP_008433590.2 | 1335230 | g30927 | i0 | 44.6 | 0.75 | 65 | 29 | 71.5 | 2 | 253 | 68 | 21 | 81 | YP_008433590.2 putative adhesin [Pseudomonas phage PaBG] | diamond | 195 | 56.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Baikalvirus | Baikalvirus PaBG | ||||
| 29537908 | 29537908 | PRJNA376117_P_NODE_27050_length_276_cov_1.034483_g26748_i0 | PRJNA376117 | 27050 | 276 | 1.034483 | 2.85517308 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 158 | 1.46e-42 | NR | XOR25286.1 | 2832643 | g26748 | i0 | 87.9 | 0.989130434782609 | 91 | 11 | 98.9 | 0 | 2 | 274 | 450 | 540 | XOR25286.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 273 | 158 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29663927 | 29663927 | PRJNA376117_P_NODE_20430_length_306_cov_1.111588_g20128_i0 | PRJNA376117 | 20430 | 306 | 1.111588 | 3.40145928 | Synechococcus phage S-H35 | 1983572 | Viruses | Viruses | 42 | 0.0156 | NR | YP_010090281.1 | 1983572 | g20128 | i0 | 27.4 | 0.607843137254902 | 62 | 45 | 60.8 | 0 | 86 | 271 | 1 | 62 | YP_010090281.1 hypothetical protein KNT63_gp014 [Synechococcus phage S-H35] | diamond | 186 | 42 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Kyanoviridae | Shandvirus | Shandvirus sh35 | ||
| 30391321 | 30391321 | PRJNA376117_P_NODE_9633_length_433_cov_1.800000_g9331_i0 | PRJNA376117 | 9633 | 433 | 1.8 | 7.794 | rice curl dwarf-associated dicistro-like virus 1 | 3377419 | Viruses | Viruses | 56.2 | 5.71e-6 | NR | XFO60888.1 | 3377419 | g9331 | i0 | 42.4 | 0.685912240184757 | 59 | 34 | 40.9 | 0 | 429 | 253 | 789 | 847 | XFO60888.1 structural polyprotein [rice curl dwarf-associated dicistro-like virus 1] | diamond | 297 | 56.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | rice curl dwarf-associated dicistro-like virus 1 | |||
| 31022806 | 31022806 | PRJNA376117_P_NODE_33275_length_252_cov_2.016760_g32973_i0 | PRJNA376117 | 33275 | 252 | 2.01676 | 5.0822352 | Pseudomonas phage MR4 | 2711171 | Viruses | Viruses | 71.2 | 2.46e-13 | NR | QJD54730.1 | 2711171 | g32973 | i0 | 68 | 0.595238095238095 | 50 | 16 | 59.5 | 0 | 251 | 102 | 102 | 151 | QJD54730.1 putative GNAT family acetyltransferase protein [Pseudomonas phage MR4] | diamond | 150 | 71.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Gajwadongvirus | Gajwadongvirus MR4 | |||
| 31370694 | 31370694 | PRJNA376117_P_NODE_16336_length_340_cov_2.269663_g16034_i0 | PRJNA376117 | 16336 | 340 | 2.269663 | 7.7168542 | Yasminevirus sp. GU-2 | 3060817 | Viruses | Viruses | 63.5 | 5.5e-9 | NR | VBB18109.1 | 2420051 | g16034 | i0 | 56.3 | 0.847058823529412 | 48 | 19 | 42.4 | 1 | 144 | 1 | 358 | 403 | VBB18109.1 Cytochrome b5-like heme/steroid binding domain [Yasminevirus sp. GU-2018] | diamond | 288 | 63.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Yasminevirus | Yasminevirus saudimassiliense | ||
| 31387773 | 31387773 | PRJNA376117_P_NODE_34316_length_251_cov_0.865169_g34014_i0 | PRJNA376117 | 34316 | 251 | 0.865169 | 2.17157419 | Prasinovirus | 181084 | Viruses | Viruses | 54.3 | 7.39e-7 | NR | AET84477.1 | 754063 | g34014 | i0 | 44.2 | 4.49402390438247 | 43 | 24 | 51.4 | 0 | 105 | 233 | 3 | 45 | AET84477.1 hypothetical protein OLOG_00011 [Ostreococcus lucimarinus virus OlV4] | diamond | 1128 | 54.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Prasinovirus | Ostreococcus lucimarinus virus OlV4 | ||
| 31528733 | 31528733 | PRJNA376117_P_NODE_27616_length_273_cov_2.560000_g27314_i0 | PRJNA376117 | 27616 | 273 | 2.56 | 6.9888 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 54.7 | 1.01e-6 | NR | YP_010803991.1 | 3060017 | g27314 | i0 | 39.7 | 0.802197802197802 | 73 | 43 | 80.2 | 1 | 259 | 41 | 1 | 72 | YP_010803991.1 hypothetical protein QKU48_gp1108 [Fadolivirus algeromassiliense] | diamond | 219 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 31686676 | 31686676 | PRJNA376117_P_NODE_45157_length_230_cov_2.770701_g44855_i0 | PRJNA376117 | 45157 | 230 | 2.770701 | 6.3726123 | Bacteriophage sp. | 38018 | Viruses | Viruses | 110 | 4.46e-26 | NR | QHJ81062.1 | 38018 | g44855 | i0 | 68.4 | 0.991304347826087 | 76 | 24 | 99.1 | 0 | 1 | 228 | 201 | 276 | QHJ81062.1 MAG: hypothetical protein [Bacteriophage sp.] | diamond | 228 | 110 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 31908181 | 31908181 | PRJNA376117_P_NODE_26757_length_277_cov_1.132353_g26455_i0 | PRJNA376117 | 26757 | 277 | 1.132353 | 3.13661781 | Burdock mosaic virus | 3036445 | Viruses | Viruses | 174 | 2.6499999999999997e-48 | NR | WEU75084.1 | 3036445 | g26455 | i0 | 94.6 | 0.996389891696751 | 92 | 5 | 99.6 | 0 | 2 | 277 | 1882 | 1973 | WEU75084.1 polyprotein [Burdock mosaic virus] | diamond | 276 | 174 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Torradovirus | Torradovirus arctii | ||
| 32288216 | 32288216 | PRJNA376117_P_NODE_25679_length_280_cov_1.545894_g25377_i0 | PRJNA376117 | 25679 | 280 | 1.545894 | 4.3285032 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 99 | 8.7e-22 | NR | XOR74384.1 | 2832643 | g25377 | i0 | 60 | 1.77857142857143 | 75 | 30 | 80.4 | 0 | 278 | 54 | 442 | 516 | XOR74384.1 MAG: virion structural protein [Caudoviricetes sp.] | diamond | 498 | 99 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32414576 | 32414576 | PRJNA376117_P_NODE_37819_length_247_cov_1.683908_g37517_i0 | PRJNA376117 | 37819 | 247 | 1.683908 | 4.15925276 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 46.6 | 3.96e-4 | NR | AYV76392.1 | 2487775 | g37517 | i0 | 52 | 0.607287449392713 | 50 | 22 | 58.3 | 1 | 235 | 92 | 1 | 50 | AYV76392.1 MAG: hypothetical protein Terrestrivirus6_18 [Terrestrivirus sp.] | diamond | 150 | 46.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 32572879 | 32572879 | PRJNA376117_P_NODE_29579_length_266_cov_2.295337_g29277_i0 | PRJNA376117 | 29579 | 266 | 2.295337 | 6.10559642 | Ralstonia phage FLC4-3B | 3157663 | Viruses | Viruses | 48.9 | 3.32e-4 | NR | BFM93901.1 | 3157663 | g29277 | i0 | 43.6 | 0.879699248120301 | 78 | 44 | 88 | 0 | 11 | 244 | 631 | 708 | BFM93901.1 hypothetical protein [Ralstonia phage FLC4-3B] | diamond | 234 | 48.9 | 1 | Viruses | Ralstonia phage FLC4-3B | ||||||||
| 32855921 | 32855921 | PRJNA376117_P_NODE_40720_length_244_cov_2.403509_g40418_i0 | PRJNA376117 | 40720 | 244 | 2.403509 | 5.86456196 | Pectobacterium phage vB_PcaM_CBB | 2772511 | Viruses | Viruses | 63.9 | 7.36e-10 | NR | YP_009594642.1 | 2772511 | g40418 | i0 | 62.2 | 0.55327868852459 | 45 | 17 | 55.3 | 0 | 232 | 98 | 200 | 244 | YP_009594642.1 metallo-phosphoesterase [Pectobacterium phage vB_PcaM_CBB] | diamond | 135 | 63.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Mimasvirus | Mimasvirus CBB | ||||
| 32887323 | 32887323 | PRJNA376117_P_NODE_14500_length_360_cov_1.073171_g14198_i0 | PRJNA376117 | 14500 | 360 | 1.073171 | 3.8634156 | Klebsiella phage RCIP | 3094191 | Viruses | Viruses | 85.5 | 3.81e-19 | NR | WPJ50475.1 | 3094191 | g14198 | i0 | 57.4 | 0.566666666666667 | 68 | 29 | 56.7 | 0 | 84 | 287 | 13 | 80 | WPJ50475.1 hypothetical protein RCIP0023_00433 [Klebsiella phage RCIP0023] | diamond | 204 | 85.5 | 1 | Viruses | Klebsiella phage RCIP0023 |
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);;