contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA591127" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27616909 | 27616909 | PRJNA591127_P_NODE_17144_length_197_cov_2.581250_g16975_i0 | PRJNA591127 | 17144 | 197 | 2.58125 | 5.0850625 | Lake Baikal virophage 15 | 3086120 | Viruses | Viruses | 43.9 | 0.00731 | NR | WPF46879.1 | 3086120 | g16975 | i0 | 36.9 | 0.989847715736041 | 65 | 37 | 97.5 | 2 | 196 | 5 | 26 | 87 | WPF46879.1 MAG: putative packaging ATPase [Lake Baikal virophage 15] | diamond | 195 | 43.9 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Lake Baikal virophage 15 | |||
| 27995774 | 27995774 | PRJNA591127_P_NODE_19185_length_197_cov_2.050000_g19016_i0 | PRJNA591127 | 19185 | 197 | 2.05 | 4.0385 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 61.6 | 4.77e-10 | NR | XOE97102.1 | 2832643 | g19016 | i0 | 50.7 | 1.08121827411168 | 71 | 25 | 92.9 | 1 | 189 | 7 | 11 | 81 | XOE97102.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 213 | 61.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28058769 | 28058769 | PRJNA591127_P_NODE_14845_length_197_cov_3.768750_g14676_i0 | PRJNA591127 | 14845 | 197 | 3.76875 | 7.4244375 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 53.9 | 4.51e-7 | NR | CAB4219235.1 | 2100421 | g14676 | i0 | 87.5 | 0.365482233502538 | 24 | 3 | 36.5 | 0 | 124 | 195 | 26 | 49 | CAB4219235.1 hypothetical protein UFOVP1604_318, partial [uncultured Caudovirales phage] | diamond | 72 | 53.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28153746 | 28153746 | PRJNA591127_P_NODE_13205_length_202_cov_2.969697_g13036_i0 | PRJNA591127 | 13205 | 202 | 2.969697 | 5.99878794 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 119 | 2.43e-29 | NR | XOE97057.1 | 2832643 | g13036 | i0 | 84.8 | 0.98019801980198 | 66 | 10 | 98 | 0 | 202 | 5 | 649 | 714 | XOE97057.1 MAG: terminase large subunit [Caudoviricetes sp.] | diamond | 198 | 119 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28248100 | 28248100 | PRJNA591127_P_NODE_29746_length_151_cov_3.500000_g29577_i0 | PRJNA591127 | 29746 | 151 | 3.5 | 5.285 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 6.35e-7 | NR | DAJ69398.1 | 2832643 | g29577 | i0 | 68.4 | 7.2317880794702 | 38 | 12 | 75.5 | 0 | 151 | 38 | 175 | 212 | DAJ69398.1 MAG TPA: Cytosine specific methyltransferase [Caudoviricetes sp.] | diamond | 1092 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28311489 | 28311489 | PRJNA591127_P_NODE_11086_length_221_cov_2.315217_g10917_i0 | PRJNA591127 | 11086 | 221 | 2.315217 | 5.11662957 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 62.4 | 8.21e-11 | NR | DAS98795.1 | 2832643 | g10917 | i0 | 65.7 | 0.950226244343891 | 35 | 12 | 47.5 | 0 | 221 | 117 | 40 | 74 | DAS98795.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 210 | 62.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28595767 | 28595767 | PRJNA591127_P_NODE_22887_length_182_cov_1.344828_g22718_i0 | PRJNA591127 | 22887 | 182 | 1.344828 | 2.44758696 | Leviviridae sp. | 2027243 | Viruses | Viruses | 75.9 | 3.43e-14 | NR | URG16528.1 | 2027243 | g22718 | i0 | 56.7 | 1.97802197802198 | 60 | 26 | 98.9 | 0 | 180 | 1 | 509 | 568 | URG16528.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 360 | 75.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 28595768 | 28595768 | PRJNA591127_P_NODE_25947_length_163_cov_3.404762_g25778_i0 | PRJNA591127 | 25947 | 163 | 3.404762 | 5.54976206 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 78.6 | 2.96e-15 | NR | XOQ93838.1 | 2832643 | g25778 | i0 | 67.3 | 1.01226993865031 | 55 | 17 | 99.4 | 1 | 1 | 162 | 461 | 515 | XOQ93838.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 165 | 78.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29542710 | 29542710 | PRJNA591127_P_NODE_32010_length_150_cov_2.823009_g31841_i0 | PRJNA591127 | 32010 | 150 | 2.823009 | 4.2345135 | Pseudomonas phage vB_PpuM-KoPa-4 | 3132618 | Viruses | Viruses | 50.1 | 1.85e-6 | NR | WYV99295.1 | 3132618 | g31841 | i0 | 75 | 0.56 | 28 | 7 | 56 | 0 | 1 | 84 | 35 | 62 | WYV99295.1 hypothetical protein KoPa4_00127 [Pseudomonas phage vB_PpuM-KoPa-4] | diamond | 84 | 50.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Tartuvirus | Tartuvirus kopa4 | |||
| 30585053 | 30585053 | PRJNA591127_P_NODE_21433_length_192_cov_2.754839_g21264_i0 | PRJNA591127 | 21433 | 192 | 2.754839 | 5.28929088 | Salarius guttatus piscichuvirus | 2951531 | Viruses | Viruses | 49.3 | 9.26e-5 | NR | UVF58767.1 | 2951531 | g21264 | i0 | 34.9 | 0.984375 | 63 | 41 | 98.4 | 0 | 3 | 191 | 90 | 152 | UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus] | diamond | 189 | 49.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | Salarius guttatus piscichuvirus | ||
| 30996049 | 30996049 | PRJNA591127_P_NODE_25714_length_164_cov_6.976378_g25545_i0 | PRJNA591127 | 25714 | 164 | 6.976378 | 11.44125992 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 62.8 | 4.54e-10 | NR | CAB4165361.1 | 2100421 | g25545 | i0 | 83.9 | 1.13414634146341 | 31 | 5 | 56.7 | 0 | 3 | 95 | 96 | 126 | CAB4165361.1 hypothetical protein UFOVP827_37 [uncultured Caudovirales phage] | diamond | 186 | 62.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31280337 | 31280337 | PRJNA591127_P_NODE_15395_length_197_cov_3.325000_g15226_i0 | PRJNA591127 | 15395 | 197 | 3.325 | 6.55025 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 46.2 | 0.00102 | NR | DAX62429.1 | 2832643 | g15226 | i0 | 76 | 0.380710659898477 | 25 | 6 | 38.1 | 0 | 195 | 121 | 81 | 105 | DAX62429.1 MAG TPA: Structural protein [Caudoviricetes sp.] | diamond | 75 | 46.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31470371 | 31470371 | PRJNA591127_P_NODE_30696_length_151_cov_2.640351_g30527_i0 | PRJNA591127 | 30696 | 151 | 2.640351 | 3.98693001 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 42.7 | 0.0103 | NR | CAB5221954.1 | 2100421 | g30527 | i0 | 58.6 | 0.576158940397351 | 29 | 12 | 57.6 | 0 | 88 | 2 | 112 | 140 | CAB5221954.1 COG0603 Predicted PP-loop superfamily ATPase [uncultured Caudovirales phage] | diamond | 87 | 42.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31610211 | 31610211 | PRJNA591127_P_NODE_28916_length_151_cov_5.096491_g28747_i0 | PRJNA591127 | 28916 | 151 | 5.096491 | 7.69570141 | root | 1 | Root_unresolved | Root_unresolved | 43.5 | 0.00576 | NR | YP_008241759.1 | 1327970 | g28747 | i0 | 44.4 | 2.02649006622517 | 36 | 19 | 69.5 | 1 | 150 | 46 | 170 | 205 | YP_008241759.1 terminase large subunit [Cellulophaga phage phi19:1] | diamond | 306 | 43.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Assiduviridae | Cellubavirus | Cellubavirus phi19una | |||
| 31754779 | 31754779 | PRJNA591127_P_NODE_17317_length_197_cov_2.525000_g17148_i0 | PRJNA591127 | 17317 | 197 | 2.525 | 4.97425 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 42 | 0.016 | NR | XOQ93875.1 | 2832643 | g17148 | i0 | 69.6 | 0.350253807106599 | 23 | 7 | 35 | 0 | 191 | 123 | 13 | 35 | XOQ93875.1 MAG: P45 [Caudoviricetes sp.] | diamond | 69 | 42 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31849667 | 31849667 | PRJNA591127_P_NODE_31577_length_150_cov_3.867257_g31408_i0 | PRJNA591127 | 31577 | 150 | 3.867257 | 5.8008855 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 50.1 | 8.42e-6 | NR | XOE97092.1 | 2832643 | g31408 | i0 | 84 | 0.5 | 25 | 4 | 50 | 0 | 76 | 150 | 77 | 101 | XOE97092.1 MAG: Sak4-like ssDNA annealing protein [Caudoviricetes sp.] | diamond | 75 | 50.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31944470 | 31944470 | PRJNA591127_P_NODE_26257_length_162_cov_1.248000_g26088_i0 | PRJNA591127 | 26257 | 162 | 1.248 | 2.02176 | ssRNA phage Gerhypos.2_3 | 2786263 | Viruses | Viruses | 70.5 | 1.98e-12 | NR | YP_010770593.1 | 2786264 | g26088 | i0 | 75 | 0.740740740740741 | 40 | 10 | 74.1 | 0 | 3 | 122 | 368 | 407 | YP_010770593.1 maturation protein, partial [ssRNA phage Gerhypos.2_30] | diamond | 120 | 70.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Timlovirales | Steitzviridae | Hodnevirus | Hodnevirus neosolivicinum | ||
| 31958054 | 31958054 | PRJNA591127_P_NODE_13997_length_197_cov_5.462500_g13828_i0 | PRJNA591127 | 13997 | 197 | 5.4625 | 10.761125 | root | 1 | Root_unresolved | Root_unresolved | 42 | 0.039 | NR | DAQ54163.1 | 2832643 | g13828 | i0 | 65.2 | 0.700507614213198 | 23 | 8 | 35 | 0 | 74 | 6 | 763 | 785 | DAQ54163.1 MAG TPA: Putative tail protein [Caudoviricetes sp.] | diamond | 138 | 42 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32166328 | 32166328 | PRJNA591127_P_NODE_25998_length_163_cov_1.857143_g25829_i0 | PRJNA591127 | 25998 | 163 | 1.857143 | 3.02714309 | Plasmopara viticola lesion associated ourmia-like virus 82 | 2686556 | Viruses | Viruses | 108 | 1.06e-25 | NR | YP_010800276.1 | 2686556 | g25829 | i0 | 90.6 | 0.975460122699387 | 53 | 5 | 97.5 | 0 | 3 | 161 | 231 | 283 | YP_010800276.1 RNA dependent RNA polymerase, partial [Plasmopara viticola lesion associated ourmia-like virus 82] | diamond | 159 | 108 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Penoulivirus | Penoulivirus alphaplasmoparae | ||
| 32640130 | 32640130 | PRJNA591127_P_NODE_30800_length_151_cov_2.517544_g30631_i0 | PRJNA591127 | 30800 | 151 | 2.517544 | 3.80149144 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 48.9 | 4.4e-5 | NR | DAN50260.1 | 2832643 | g30631 | i0 | 60.5 | 0.754966887417219 | 38 | 12 | 69.5 | 1 | 26 | 130 | 5 | 42 | DAN50260.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 114 | 48.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32640132 | 32640132 | PRJNA591127_P_NODE_6920_length_280_cov_2.045267_g6752_i0 | PRJNA591127 | 6920 | 280 | 2.045267 | 5.7267476 | Flavobacterium phage vB_FspP_elemoA_7-9A | 2743781 | Viruses | Viruses | 42 | 0.0192 | NR | YP_010108887.1 | 2743781 | g6752 | i0 | 69.6 | 0.246428571428571 | 23 | 7 | 24.6 | 0 | 90 | 158 | 4 | 26 | YP_010108887.1 hypothetical protein KNV10_gp41 [Flavobacterium phage vB_FspP_elemoA_7-9A] | diamond | 69 | 42 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Elemovirus | Elemovirus elemoA | ||||
| 32766245 | 32766245 | PRJNA591127_P_NODE_14200_length_197_cov_4.743750_g14031_i0 | PRJNA591127 | 14200 | 197 | 4.74375 | 9.3451875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 80.9 | 7.27e-16 | NR | XOS39819.1 | 2832643 | g14031 | i0 | 64.6 | 1.97969543147208 | 65 | 14 | 99 | 1 | 196 | 2 | 277 | 332 | XOS39819.1 MAG: phage tail protein gpI [Caudoviricetes sp.] | diamond | 390 | 80.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. |
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);;