contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA635874" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18459071 | 18459071 | PRJNA635874_P_NODE_19935_length_353_cov_1.100000_g19788_i0 | PRJNA635874 | 19935 | 353 | 1.1 | 3.883 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 185 | 1.04e-53 | NR | XOS43889.1 | 2832643 | g19788 | i0 | 75.9 | 1.87818696883853 | 116 | 28 | 98.6 | 0 | 5 | 352 | 97 | 212 | XOS43889.1 MAG: phage protein [Caudoviricetes sp.] | diamond | 663 | 185 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23560476 | 23560476 | PRJNA635874_P_NODE_53879_length_248_cov_0.880000_g53732_i0 | PRJNA635874 | 53879 | 248 | 0.88 | 2.1824 | Bacteriophage sp. | 38018 | Viruses | Viruses | 90.1 | 9.61e-22 | NR | QHJ81528.1 | 38018 | g53732 | i0 | 53 | 0.798387096774194 | 66 | 31 | 79.8 | 0 | 5 | 202 | 1 | 66 | QHJ81528.1 MAG: hypothetical protein [Bacteriophage sp.] | diamond | 198 | 90.1 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 26637749 | 26637749 | PRJNA635874_P_NODE_58741_length_246_cov_0.890173_g58594_i0 | PRJNA635874 | 58741 | 246 | 0.890173 | 2.18982558 | Campylobacter phage CJLB-4 | 2781358 | Viruses | Viruses | 67.4 | 1.66e-12 | NR | QPB10280.1 | 2781358 | g58594 | i0 | 62.3 | 0.646341463414634 | 53 | 20 | 64.6 | 0 | 231 | 73 | 37 | 89 | QPB10280.1 hypothetical protein [Campylobacter phage CJLB-4] | diamond | 159 | 67.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lambdavirus | Campylobacter phage CJLB-4 | ||||
| 26732445 | 26732445 | PRJNA635874_P_NODE_9241_length_479_cov_1.546798_g9094_i0 | PRJNA635874 | 9241 | 479 | 1.546798 | 7.40916242 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 112 | 9.32e-29 | NR | DAH93386.1 | 2832643 | g9094 | i0 | 62.4 | 0.532359081419624 | 85 | 32 | 53.2 | 0 | 256 | 2 | 1 | 85 | DAH93386.1 MAG TPA: hypothetical protein, partial [Caudoviricetes sp.] | diamond | 255 | 112 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26859841 | 26859841 | PRJNA635874_P_NODE_62761_length_245_cov_0.895349_g62614_i0 | PRJNA635874 | 62761 | 245 | 0.895349 | 2.19360505 | Stenotrophomonas phage Silvanus | 2859659 | Viruses | Viruses | 81.6 | 7.76e-16 | NR | QYW02488.1 | 2859659 | g62614 | i0 | 62.8 | 0.955102040816327 | 78 | 29 | 95.5 | 0 | 236 | 3 | 803 | 880 | QYW02488.1 tape measure protein [Stenotrophomonas phage Silvanus] | diamond | 234 | 81.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Stenotrophomonas phage Silvanus | |||||
| 27365763 | 27365763 | PRJNA635874_P_NODE_64003_length_244_cov_0.900585_g63856_i0 | PRJNA635874 | 64003 | 244 | 0.900585 | 2.1974274 | Staphylococcus phage S-CoN_Ph17 | 3076573 | Viruses | Viruses | 149 | 4.729999999999999e-42 | NR | WNM54416.1 | 3076573 | g63856 | i0 | 92.5 | 2.95081967213115 | 80 | 6 | 98.4 | 0 | 241 | 2 | 61 | 140 | WNM54416.1 portal protein [Staphylococcus phage S-CoN_Ph17] | diamond | 720 | 149 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sextaecvirus | Staphylococcus phage S-CoN_Ph17 | ||||
| 27630710 | 27630710 | PRJNA635874_P_NODE_41384_length_265_cov_1.093750_g41237_i0 | PRJNA635874 | 41384 | 265 | 1.09375 | 2.8984375 | Marafivirus | 12051 | Viruses | Viruses | 129 | 1.28e-32 | NR | UEP57879.1 | 630199 | g41237 | i0 | 67 | 6.97358490566038 | 88 | 29 | 99.6 | 0 | 264 | 1 | 44 | 131 | UEP57879.1 putative 230 kDa polyprotein, partial [Grapevine Syrah virus 1] | diamond | 1848 | 129 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Marafivirus | Marafivirus syrahense | ||
| 27713176 | 27713176 | PRJNA635874_P_NODE_33184_length_290_cov_1.419355_g33037_i0 | PRJNA635874 | 33184 | 290 | 1.419355 | 4.1161295 | Olive latent virus 3 | 626962 | Viruses | Viruses | 124 | 1.99e-30 | NR | WQF62470.1 | 626962 | g33037 | i0 | 59.4 | 0.993103448275862 | 96 | 39 | 99.3 | 0 | 2 | 289 | 1028 | 1123 | WQF62470.1 MAG: replicase [Olive latent virus 3] | diamond | 288 | 124 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Marafivirus | Marafivirus oleae | ||
| 27744630 | 27744630 | PRJNA635874_P_NODE_1204_length_1032_cov_1.980188_g1101_i0 | PRJNA635874 | 1204 | 1032 | 1.980188 | 20.43554016 | Guiyang Paspalum paspaloides tymo-like virus 1 | 2970310 | Viruses | Viruses | 274 | 5.77e-79 | NR | UUW20925.1 | 2970310 | g1101 | i0 | 52.1 | 0.837209302325581 | 288 | 128 | 83.7 | 3 | 3 | 866 | 1843 | 2120 | UUW20925.1 MAG: methyltransferase [Guiyang Paspalum paspaloides tymo-like virus 1] | diamond | 864 | 274 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Guiyang Paspalum paspaloides tymo-like virus 1 | |||
| 27776131 | 27776131 | PRJNA635874_P_NODE_58244_length_247_cov_0.879310_g58097_i0 | PRJNA635874 | 58244 | 247 | 0.87931 | 2.1718957 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 70.1 | 8.78e-12 | NR | CAB4241496.1 | 2100421 | g58097 | i0 | 41.8 | 0.959514170040486 | 79 | 46 | 96 | 0 | 237 | 1 | 30 | 108 | CAB4241496.1 Myoviridae tail sheath stabiliser [uncultured Caudovirales phage] | diamond | 237 | 70.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27851420 | 27851420 | PRJNA635874_P_NODE_41324_length_265_cov_1.203125_g41177_i0 | PRJNA635874 | 41324 | 265 | 1.203125 | 3.18828125 | Gammaretrovirus | 153135 | Viruses | Viruses | 169 | 1.72e-46 | NR | NP_057933.2 | 11801 | g41177 | i0 | 96.6 | 12.9509433962264 | 88 | 3 | 99.6 | 0 | 265 | 2 | 1171 | 1258 | NP_057933.2 Pr180 [Moloney murine leukemia virus] | diamond | 3432 | 169 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 27933815 | 27933815 | PRJNA635874_P_NODE_36805_length_279_cov_1.097087_g36658_i0 | PRJNA635874 | 36805 | 279 | 1.097087 | 3.06087273 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 112 | 1.9e-26 | NR | XOS19684.1 | 2832643 | g36658 | i0 | 63.9 | 0.89247311827957 | 83 | 30 | 89.2 | 0 | 4 | 252 | 238 | 320 | XOS19684.1 MAG: putative tail fiber protein [Caudoviricetes sp.] | diamond | 249 | 112 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28754736 | 28754736 | PRJNA635874_P_NODE_57947_length_247_cov_0.885057_g57800_i0 | PRJNA635874 | 57947 | 247 | 0.885057 | 2.18609079 | Prokaryotic dsDNA virus sp. | 2591644 | Viruses | Viruses | 67 | 1.87e-11 | NR | QDP48152.1 | 2591644 | g57800 | i0 | 45.1 | 0.862348178137652 | 71 | 37 | 85 | 2 | 241 | 32 | 109 | 178 | QDP48152.1 MAG: hypothetical protein Unbinned6437contig1000_6 [Prokaryotic dsDNA virus sp.] | diamond | 213 | 67 | 1 | Viruses | Prokaryotic dsDNA virus sp. | ||||||||
| 28767162 | 28767162 | PRJNA635874_P_NODE_43067_length_260_cov_1.235294_g42920_i0 | PRJNA635874 | 43067 | 260 | 1.235294 | 3.2117644 | Marafivirus | 12051 | Viruses | Viruses | 48.1 | 5.97e-4 | NR | QQG34652.1 | 2794433 | g42920 | i0 | 33.3 | 3.98076923076923 | 90 | 50 | 99.2 | 3 | 1 | 258 | 961 | 1044 | QQG34652.1 polyprotein [Davidia involucrata marafivirus 1] | diamond | 1035 | 48.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Marafivirus | Davidia involucrata marafivirus 1 | ||
| 28849261 | 28849261 | PRJNA635874_P_NODE_7488_length_523_cov_2.313333_g7342_i0 | PRJNA635874 | 7488 | 523 | 2.313333 | 12.09873159 | Guiyang Paspalum paspaloides tymo-like virus 1 | 2970310 | Viruses | Viruses | 182 | 1.4e-49 | NR | UUW20925.1 | 2970310 | g7342 | i0 | 53.9 | 0.957934990439771 | 167 | 77 | 95.8 | 0 | 518 | 18 | 1105 | 1271 | UUW20925.1 MAG: methyltransferase [Guiyang Paspalum paspaloides tymo-like virus 1] | diamond | 501 | 182 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Guiyang Paspalum paspaloides tymo-like virus 1 | |||
| 29493422 | 29493422 | PRJNA635874_P_NODE_36390_length_280_cov_1.323671_g36243_i0 | PRJNA635874 | 36390 | 280 | 1.323671 | 3.7062788 | Chuvivirus | 2842604 | Viruses | Viruses | 113 | 3.5e-27 | NR | WET19887.1 | 2842604 | g36243 | i0 | 62 | 1.97142857142857 | 92 | 35 | 98.6 | 0 | 277 | 2 | 255 | 346 | WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1] | diamond | 552 | 113 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Chuvivirus | ||
| 29733269 | 29733269 | PRJNA635874_P_NODE_19610_length_355_cov_1.457447_g19463_i0 | PRJNA635874 | 19610 | 355 | 1.457447 | 5.17393685 | Moloney murine leukemia virus | 11801 | Viruses | Viruses | 242 | 2.09e-71 | NR | NP_057933.2 | 11801 | g19463 | i0 | 100 | 5.9830985915493 | 118 | 0 | 99.7 | 0 | 355 | 2 | 1051 | 1168 | NP_057933.2 Pr180 [Moloney murine leukemia virus] | diamond | 2124 | 242 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 30017902 | 30017902 | PRJNA635874_P_NODE_70131_length_242_cov_0.911243_g69984_i0 | PRJNA635874 | 70131 | 242 | 0.911243 | 2.20520806 | Acinetobacter phage vB_AbaP_Acibel | 2865959 | Viruses | Viruses | 123 | 1.18e-32 | NR | YP_009103227.1 | 1481187 | g69984 | i0 | 67.5 | 0.991735537190083 | 80 | 26 | 99.2 | 0 | 3 | 242 | 28 | 107 | YP_009103227.1 DNA primase [Acinetobacter phage vB_AbaP_Acibel007] | diamond | 240 | 123 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autoscriptoviridae | Daemvirus | Daemvirus acibel007 | ||
| 31376690 | 31376690 | PRJNA635874_P_NODE_21716_length_342_cov_1.144981_g21569_i0 | PRJNA635874 | 21716 | 342 | 1.144981 | 3.91583502 | Escherichia phage Lambda | 2681611 | Viruses | Viruses | 71.2 | 8.07e-14 | NR | NP_040643.1 | 2681611 | g21569 | i0 | 46.9 | 0.56140350877193 | 64 | 34 | 56.1 | 0 | 205 | 14 | 1 | 64 | NP_040643.1 hypothetical protein lambdap73 [Escherichia phage Lambda] | diamond | 192 | 71.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lambdavirus | Lambdavirus lambda | ||||
| 31882524 | 31882524 | PRJNA635874_P_NODE_26517_length_317_cov_1.618852_g26370_i0 | PRJNA635874 | 26517 | 317 | 1.618852 | 5.13176084 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 97.4 | 4.599999999999999e-24 | NR | XOR26773.1 | 2832643 | g26370 | i0 | 94 | 0.473186119873817 | 50 | 3 | 47.3 | 0 | 151 | 2 | 1 | 50 | XOR26773.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 150 | 97.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32104101 | 32104101 | PRJNA635874_P_NODE_3378_length_716_cov_3.256610_g3241_i0 | PRJNA635874 | 3378 | 716 | 3.25661 | 23.3173276 | Pseudomonas phage ER16 | 2917704 | Viruses | Viruses | 49.3 | 3.44e-4 | NR | UNI73398.1 | 2917704 | g3241 | i0 | 34.8 | 0.289106145251397 | 69 | 45 | 28.9 | 0 | 242 | 36 | 1 | 69 | UNI73398.1 hypothetical protein ER16_Large9 [Pseudomonas phage ER16] | diamond | 207 | 49.3 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Pseudomonas phage ER16 |
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);;