contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA784979" and tax_phylum = "Uroviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26673453 | 26673453 | PRJNA784979_S_NODE_5661_length_206_cov_0.866242_g5619_i0 | PRJNA784979 | 5661 | 206 | 0.866242 | 1.78445852 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 80.1 | 4.22e-16 | NR | CAB4127550.1 | 2100421 | g5619 | i0 | 64.1 | 0.932038834951456 | 64 | 23 | 93.2 | 0 | 1 | 192 | 207 | 270 | CAB4127550.1 hypothetical protein UFOVP92_32 [uncultured Caudovirales phage] | diamond | 192 | 80.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 26705233 | 26705233 | PRJNA784979_S_NODE_6681_length_194_cov_1.262069_g6639_i0 | PRJNA784979 | 6681 | 194 | 1.262069 | 2.44841386 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 68.6 | 1.52e-11 | NR | CAB4137057.1 | 2100421 | g6639 | i0 | 50.8 | 1.94845360824742 | 63 | 31 | 97.4 | 0 | 194 | 6 | 274 | 336 | CAB4137057.1 portal_PBSX, phage portal protein, PBSX family, partial [uncultured Caudovirales phage] | diamond | 378 | 68.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 26800424 | 26800424 | PRJNA784979_S_NODE_12421_length_163_cov_0.894737_g12379_i0 | PRJNA784979 | 12421 | 163 | 0.894737 | 1.45842131 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 85.9 | 6.91e-18 | NR | CAB4126923.1 | 2100421 | g12379 | i0 | 87 | 0.993865030674847 | 54 | 7 | 99.4 | 0 | 2 | 163 | 241 | 294 | CAB4126923.1 major_cap_HK97, phage major capsid protein, HK97 family [uncultured Caudovirales phage] | diamond | 162 | 85.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 26927096 | 26927096 | PRJNA784979_S_NODE_10662_length_166_cov_1.307692_g10620_i0 | PRJNA784979 | 10662 | 166 | 1.307692 | 2.17076872 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 85.9 | 8.34e-18 | NR | CAB4194469.1 | 2100421 | g10620 | i0 | 73.1 | 0.939759036144578 | 52 | 14 | 94 | 0 | 1 | 156 | 54 | 105 | CAB4194469.1 DEXDc domain containing protein [uncultured Caudovirales phage] | diamond | 156 | 85.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27338238 | 27338238 | PRJNA784979_S_NODE_12523_length_163_cov_0.859649_g12481_i0 | PRJNA784979 | 12523 | 163 | 0.859649 | 1.40122787 | Ralstonia phage RsoM2USA | 2070027 | Viruses | Viruses | 55.5 | 4.08e-7 | NR | AVH85009.1 | 2070027 | g12481 | i0 | 65.1 | 0.791411042944785 | 43 | 15 | 79.1 | 0 | 129 | 1 | 68 | 110 | AVH85009.1 hypothetical protein RsoM2USA_80 [Ralstonia phage RsoM2USA] | diamond | 129 | 55.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Ralstonia phage RsoM2USA | |||||
| 27906246 | 27906246 | PRJNA784979_S_NODE_12985_length_162_cov_0.902655_g12943_i0 | PRJNA784979 | 12985 | 162 | 0.902655 | 1.4623011 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 70.1 | 2.72e-12 | NR | CAB4162584.1 | 2100421 | g12943 | i0 | 65.3 | 0.907407407407407 | 49 | 17 | 90.7 | 0 | 2 | 148 | 166 | 214 | CAB4162584.1 HELICc domain containing protein [uncultured Caudovirales phage] | diamond | 147 | 70.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28064322 | 28064322 | PRJNA784979_S_NODE_12405_length_163_cov_0.894737_g12363_i0 | PRJNA784979 | 12405 | 163 | 0.894737 | 1.45842131 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 84.3 | 2.63e-17 | NR | CAB4174292.1 | 2100421 | g12363 | i0 | 75 | 0.957055214723926 | 52 | 13 | 95.7 | 0 | 161 | 6 | 366 | 417 | CAB4174292.1 Bacteriophage/Gene transfer agent portal protein [uncultured Caudovirales phage] | diamond | 156 | 84.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28095942 | 28095942 | PRJNA784979_S_NODE_10045_length_168_cov_1.084034_g10003_i0 | PRJNA784979 | 10045 | 168 | 1.084034 | 1.82117712 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 58.5 | 5.14e-9 | NR | XOS51574.1 | 2832643 | g10003 | i0 | 50 | 1.03571428571429 | 58 | 27 | 100 | 1 | 168 | 1 | 27 | 84 | XOS51574.1 MAG: hypothetical protein MSP0347_24 [Caudoviricetes sp.] | diamond | 174 | 58.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28696033 | 28696033 | PRJNA784979_S_NODE_10267_length_167_cov_1.016949_g10225_i0 | PRJNA784979 | 10267 | 167 | 1.016949 | 1.69830483 | Serratia phage vB_SmaM_Hera | 2777369 | Viruses | Viruses | 86.3 | 3.77e-18 | NR | QPX74732.1 | 2777369 | g10225 | i0 | 70.9 | 1.9940119760479 | 55 | 16 | 98.8 | 0 | 2 | 166 | 284 | 338 | QPX74732.1 major capsid protein [Serratia phage vB_SmaM_Hera] | diamond | 333 | 86.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lindbergviridae | Myosmarvirus | Myosmarvirus MTx | |||
| 29579674 | 29579674 | PRJNA784979_S_NODE_6810_length_193_cov_1.062500_g6768_i0 | PRJNA784979 | 6810 | 193 | 1.0625 | 2.050625 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 68.9 | 1.31e-12 | NR | CAB4121148.1 | 2100421 | g6768 | i0 | 50 | 0.963730569948187 | 62 | 31 | 96.4 | 0 | 2 | 187 | 8 | 69 | CAB4121148.1 hypothetical protein UFOVP9_14 [uncultured Caudovirales phage] | diamond | 186 | 68.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29683569 | 29683569 | PRJNA784979_S_NODE_9890_length_169_cov_0.858333_g9848_i0 | PRJNA784979 | 9890 | 169 | 0.858333 | 1.45058277 | root | 1 | Root_unresolved | Root_unresolved | 49.3 | 6.33e-5 | NR | CAB4127793.1 | 2100421 | g9848 | i0 | 49.1 | 1.91715976331361 | 57 | 23 | 95.9 | 2 | 6 | 167 | 129 | 182 | CAB4127793.1 hypothetical protein UFOVP97_41 [uncultured Caudovirales phage] | diamond | 324 | 49.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29958856 | 29958856 | PRJNA784979_S_NODE_11411_length_165_cov_0.879310_g11369_i0 | PRJNA784979 | 11411 | 165 | 0.87931 | 1.4508615 | Pseudomonas phage KP1 | 2562463 | Viruses | Viruses | 45.1 | 9.59e-4 | NR | YP_010597311.1 | 2562463 | g11369 | i0 | 64.3 | 0.509090909090909 | 28 | 10 | 50.9 | 0 | 3 | 86 | 124 | 151 | YP_010597311.1 tail terminator [Pseudomonas phage KP1] | diamond | 84 | 45.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Kipunavirus | Kipunavirus KP1 | ||||
| 30053493 | 30053493 | PRJNA784979_S_NODE_14111_length_152_cov_2.203883_g14069_i0 | PRJNA784979 | 14111 | 152 | 2.203883 | 3.34990216 | Pectobacterium phage Arno162 | 2500577 | Viruses | Viruses | 67.8 | 1.56e-11 | NR | AZV02114.1 | 2500577 | g14069 | i0 | 62 | 4.91447368421053 | 50 | 17 | 98.7 | 1 | 150 | 1 | 86 | 133 | AZV02114.1 hypothetical protein Arno162_74 [Pectobacterium phage Arno162] | diamond | 747 | 67.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Andersonviridae | Arnovirus | Arnovirus arno162 | |||
| 30401673 | 30401673 | PRJNA784979_S_NODE_13353_length_161_cov_0.910714_g13311_i0 | PRJNA784979 | 13353 | 161 | 0.910714 | 1.46624954 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 92.4 | 5.360000000000001e-21 | NR | CAB4127145.1 | 2100421 | g13311 | i0 | 80.4 | 2.03105590062112 | 56 | 8 | 98.8 | 1 | 3 | 161 | 187 | 242 | CAB4127145.1 XerD Site-specific recombinase XerD [uncultured Caudovirales phage] | diamond | 327 | 92.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30496118 | 30496118 | PRJNA784979_S_NODE_8653_length_177_cov_0.937500_g8611_i0 | PRJNA784979 | 8653 | 177 | 0.9375 | 1.659375 | Klebsiella phage vB_KpM_FBKp34 | 2801835 | Viruses | Viruses | 74.7 | 2.37e-14 | NR | QQV91784.1 | 2801835 | g8611 | i0 | 63 | 1.84745762711864 | 54 | 20 | 91.5 | 0 | 4 | 165 | 49 | 102 | QQV91784.1 PhoH-like protein [Klebsiella phage vB_KpM_FBKp34] | diamond | 327 | 74.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Klebsiella phage vB_KpM_FBKp34 | |||||
| 30558958 | 30558958 | PRJNA784979_S_NODE_11053_length_165_cov_1.758621_g11011_i0 | PRJNA784979 | 11053 | 165 | 1.758621 | 2.90172465 | Bacillus phage vB_BpsS-36 | 2419622 | Viruses | Viruses | 68.9 | 3.26e-12 | NR | AYP68755.1 | 2419622 | g11011 | i0 | 56.9 | 0.927272727272727 | 51 | 22 | 92.7 | 0 | 157 | 5 | 168 | 218 | AYP68755.1 DNA polymerase III PolC-type [Bacillus phage vB_BpsS-36] | diamond | 153 | 68.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Ehrlichviridae | Nairobivirus | Nairobivirus nv36 | |||
| 31570838 | 31570838 | PRJNA784979_S_NODE_7856_length_183_cov_1.246269_g7814_i0 | PRJNA784979 | 7856 | 183 | 1.246269 | 2.28067227 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 76.3 | 2.48e-14 | NR | CAB4151976.1 | 2100421 | g7814 | i0 | 60.3 | 0.950819672131147 | 58 | 22 | 93.4 | 1 | 12 | 182 | 122 | 179 | CAB4151976.1 hypothetical protein UFOVP585_45 [uncultured Caudovirales phage] | diamond | 174 | 76.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31602430 | 31602430 | PRJNA784979_S_NODE_5276_length_211_cov_0.962963_g5234_i0 | PRJNA784979 | 5276 | 211 | 0.962963 | 2.03185193 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 100 | 1.14e-22 | NR | XOS47056.1 | 2832643 | g5234 | i0 | 70.6 | 0.966824644549763 | 68 | 18 | 93.8 | 1 | 205 | 8 | 483 | 550 | XOS47056.1 MAG: hypothetical protein MSP0423_46 [Caudoviricetes sp.] | diamond | 204 | 100 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31633825 | 31633825 | PRJNA784979_S_NODE_11796_length_164_cov_0.886957_g11754_i0 | PRJNA784979 | 11796 | 164 | 0.886957 | 1.45460948 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 53.1 | 2.72e-6 | NR | CAB4159173.1 | 2100421 | g11754 | i0 | 51 | 0.932926829268293 | 51 | 25 | 93.3 | 0 | 162 | 10 | 976 | 1026 | CAB4159173.1 hypothetical protein UFOVP707_59 [uncultured Caudovirales phage] | diamond | 153 | 53.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32045201 | 32045201 | PRJNA784979_S_NODE_10878_length_166_cov_0.871795_g10836_i0 | PRJNA784979 | 10878 | 166 | 0.871795 | 1.4471797 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 69.3 | 5.54e-12 | NR | CAB4124876.1 | 2100421 | g10836 | i0 | 57.4 | 0.849397590361446 | 47 | 20 | 84.9 | 0 | 25 | 165 | 215 | 261 | CAB4124876.1 hypothetical protein UFOVP61_43 [uncultured Caudovirales phage] | diamond | 141 | 69.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32677197 | 32677197 | PRJNA784979_S_NODE_11740_length_164_cov_0.965217_g11698_i0 | PRJNA784979 | 11740 | 164 | 0.965217 | 1.58295588 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 106 | 8.16e-27 | NR | CAB4127509.1 | 2100421 | g11698 | i0 | 92.6 | 0.98780487804878 | 54 | 4 | 98.8 | 0 | 1 | 162 | 47 | 100 | CAB4127509.1 AAA domain containing protein [uncultured Caudovirales phage] | diamond | 162 | 106 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32708828 | 32708828 | PRJNA784979_S_NODE_12900_length_162_cov_0.902655_g12858_i0 | PRJNA784979 | 12900 | 162 | 0.902655 | 1.4623011 | Delftia phage PhiW-14 | 665032 | Viruses | Viruses | 55.1 | 4.93e-7 | NR | YP_003358887.1 | 665032 | g12858 | i0 | 44.4 | 1 | 54 | 30 | 100 | 0 | 1 | 162 | 93 | 146 | YP_003358887.1 exonuclease [Delftia phage PhiW-14] | diamond | 162 | 55.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Ionavirus | Ionavirus W14 | ||||
| 32812521 | 32812521 | PRJNA784979_S_NODE_3220_length_258_cov_1.205742_g3178_i0 | PRJNA784979 | 3220 | 258 | 1.205742 | 3.11081436 | Viruses | 10239 | Viruses | Viruses | 116 | 2.51e-28 | NR | QQV91752.1 | 2801835 | g3178 | i0 | 66.3 | 1.93023255813953 | 83 | 28 | 96.5 | 0 | 255 | 7 | 403 | 485 | QQV91752.1 putative terminase large subunit [Klebsiella phage vB_KpM_FBKp34] | diamond | 498 | 116 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Klebsiella phage vB_KpM_FBKp34 | |||||
| 32897643 | 32897643 | PRJNA784979_S_NODE_12760_length_162_cov_0.991150_g12718_i0 | PRJNA784979 | 12760 | 162 | 0.99115 | 1.605663 | Schitoviridae sp. | 2853078 | Viruses | Viruses | 75.5 | 3.53e-14 | NR | XOE99613.1 | 2853078 | g12718 | i0 | 82.1 | 2.88888888888889 | 39 | 7 | 72.2 | 0 | 162 | 46 | 437 | 475 | XOE99613.1 MAG: major head protein [Schitoviridae sp.] | diamond | 468 | 75.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Schitoviridae sp. | ||||
| 32897644 | 32897644 | PRJNA784979_S_NODE_2800_length_276_cov_1.295154_g2758_i0 | PRJNA784979 | 2800 | 276 | 1.295154 | 3.57462504 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 121 | 7.96e-30 | NR | DAH57114.1 | 2832643 | g2758 | i0 | 80.9 | 0.739130434782609 | 68 | 13 | 73.9 | 0 | 268 | 65 | 468 | 535 | DAH57114.1 MAG TPA: DNA directed DNA polymerase [Caudoviricetes sp.] | diamond | 204 | 121 | 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);;