contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA1188114" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4146908 | 4146908 | PRJNA1188114_P_NODE_17064_length_163_cov_0.894737_g17012_i0 | PRJNA1188114 | 17064 | 163 | 0.894737 | 1.45842131 | Staphylococcus phage vB_SauM_JDF86 | 3038179 | Viruses | Viruses | 61.6 | 2.4e-9 | NR | WFG33963.1 | 3038179 | g17012 | i0 | 49.1 | 1.04907975460123 | 57 | 26 | 99.4 | 1 | 162 | 1 | 44 | 100 | WFG33963.1 hypothetical protein F10086_41 [Staphylococcus phage vB_SauM_JDF86] | diamond | 171 | 61.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Baoshanvirus | Staphylococcus phage vB_SauM_JDF86 | |||
| 27641202 | 27641202 | PRJNA1188114_P_NODE_15924_length_164_cov_0.886957_g15872_i0 | PRJNA1188114 | 15924 | 164 | 0.886957 | 1.45460948 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 78.6 | 2.98e-15 | NR | XOQ88409.1 | 2832643 | g15872 | i0 | 72.2 | 0.98780487804878 | 54 | 15 | 98.8 | 0 | 162 | 1 | 202 | 255 | XOQ88409.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 162 | 78.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27956818 | 27956818 | PRJNA1188114_P_NODE_19445_length_161_cov_0.910714_g19393_i0 | PRJNA1188114 | 19445 | 161 | 0.910714 | 1.46624954 | Achromobacter phage JWF | 1589748 | Viruses | Viruses | 44.3 | 0.00315 | NR | YP_009224008.1 | 1589748 | g19393 | i0 | 46.9 | 0.91304347826087 | 49 | 26 | 91.3 | 0 | 152 | 6 | 3 | 51 | YP_009224008.1 hypothetical protein AXJ13_gp002 [Achromobacter phage JWF] | diamond | 147 | 44.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Achromobacter phage JWF | |||||
| 28177532 | 28177532 | PRJNA1188114_P_NODE_18346_length_162_cov_0.902655_g18294_i0 | PRJNA1188114 | 18346 | 162 | 0.902655 | 1.4623011 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 78.2 | 1.12e-16 | NR | XOR51484.1 | 2832643 | g18294 | i0 | 73.6 | 0.981481481481482 | 53 | 14 | 98.1 | 0 | 2 | 160 | 70 | 122 | XOR51484.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 159 | 78.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29333474 | 29333474 | PRJNA1188114_P_NODE_15389_length_164_cov_1.478261_g15337_i0 | PRJNA1188114 | 15389 | 164 | 1.478261 | 2.42434804 | Nipunavirus | 1982239 | Viruses | Viruses | 91.7 | 7.44e-20 | NR | YP_009603583.1 | 1175654 | g15337 | i0 | 79.6 | 2.96341463414634 | 54 | 11 | 98.8 | 0 | 1 | 162 | 148 | 201 | YP_009603583.1 DNA polymerase [Pseudomonas phage PaMx25] | diamond | 486 | 91.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Nipunavirus | Nipunavirus PaMx25 | ||||
| 29566925 | 29566925 | PRJNA1188114_P_NODE_14230_length_165_cov_1.577586_g14178_i0 | PRJNA1188114 | 14230 | 165 | 1.577586 | 2.6030169 | Bacteriophage sp. | 38018 | Viruses | Viruses | 55.8 | 3e-7 | NR | UVX43097.1 | 38018 | g14178 | i0 | 52 | 1.76363636363636 | 50 | 24 | 90.9 | 0 | 3 | 152 | 203 | 252 | UVX43097.1 MAG: zinc-binding loop region of homing endonuclease [Bacteriophage sp.] | diamond | 291 | 55.8 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 29566928 | 29566928 | PRJNA1188114_P_NODE_19010_length_161_cov_1.589286_g18958_i0 | PRJNA1188114 | 19010 | 161 | 1.589286 | 2.55875046 | Sea turtle neural virus 1 | 3112944 | Viruses | Viruses | 48.5 | 1.11e-4 | NR | WET19891.1 | 3112944 | g18958 | i0 | 52.5 | 0.745341614906832 | 40 | 19 | 74.5 | 0 | 2 | 121 | 458 | 497 | WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1] | diamond | 120 | 48.5 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Sea turtle neural virus 1 | ||
| 30040768 | 30040768 | PRJNA1188114_P_NODE_7311_length_186_cov_1.489051_g7259_i0 | PRJNA1188114 | 7311 | 186 | 1.489051 | 2.76963486 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 118 | 1.14e-30 | NR | XOR59523.1 | 2832643 | g7259 | i0 | 91.8 | 0.983870967741935 | 61 | 5 | 98.4 | 0 | 3 | 185 | 140 | 200 | XOR59523.1 MAG: putative phage protein [Caudoviricetes sp.] | diamond | 183 | 118 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30451736 | 30451736 | PRJNA1188114_P_NODE_18793_length_162_cov_0.902655_g18741_i0 | PRJNA1188114 | 18793 | 162 | 0.902655 | 1.4623011 | Staphylococcus phage Alsa_1 | 3076561 | Viruses | Viruses | 59.3 | 8.89e-10 | NR | WNM50486.1 | 3076561 | g18741 | i0 | 56 | 0.925925925925926 | 50 | 21 | 92.6 | 1 | 4 | 153 | 1 | 49 | WNM50486.1 hypothetical protein Alsa1_CDS0136 [Staphylococcus phage Alsa_1] | diamond | 150 | 59.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Staphylococcus phage Alsa_1 | ||||
| 30596782 | 30596782 | PRJNA1188114_P_NODE_11573_length_169_cov_1.275000_g11521_i0 | PRJNA1188114 | 11573 | 169 | 1.275 | 2.15475 | Pradovirus | 1985733 | Viruses | Viruses | 52 | 6.67e-6 | NR | YP_009275435.1 | 1784979 | g11521 | i0 | 43.8 | 4.27810650887574 | 48 | 27 | 85.2 | 0 | 145 | 2 | 4 | 51 | YP_009275435.1 DNA primase [Xanthomonas phage f20-Xaj] | diamond | 723 | 52 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autonotataviridae | Pradovirus | Pradovirus f20 | ||
| 31273079 | 31273079 | PRJNA1188114_P_NODE_14835_length_165_cov_0.879310_g14783_i0 | PRJNA1188114 | 14835 | 165 | 0.87931 | 1.4508615 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 43.1 | 0.00956 | NR | XOS63369.1 | 2832643 | g14783 | i0 | 51 | 0.927272727272727 | 51 | 25 | 92.7 | 0 | 157 | 5 | 1080 | 1130 | XOS63369.1 MAG: hypothetical protein MSP0629_1, partial [Caudoviricetes sp.] | diamond | 153 | 43.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31715859 | 31715859 | PRJNA1188114_P_NODE_7197_length_187_cov_1.108696_g7145_i0 | PRJNA1188114 | 7197 | 187 | 1.108696 | 2.07326152 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 124 | 4.279999999999999e-34 | NR | XOR59517.1 | 2832643 | g7145 | i0 | 95.2 | 0.994652406417112 | 62 | 3 | 99.5 | 0 | 187 | 2 | 144 | 205 | XOR59517.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 186 | 124 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31797942 | 31797942 | PRJNA1188114_P_NODE_357_length_730_cov_2.767988_g310_i0 | PRJNA1188114 | 357 | 730 | 2.767988 | 20.2063124 | Gammaretrovirus | 153135 | Viruses | Viruses | 506 | 2.39e-164 | NR | ARB03489.1 | 11786 | g310 | i0 | 98.8 | 10.9849315068493 | 243 | 3 | 99.9 | 0 | 730 | 2 | 747 | 989 | ARB03489.1 putative gag-pro-pol polyprotein [Murine leukemia virus] | diamond | 8019 | 511 | 0.990215264187867 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 32158928 | 32158928 | PRJNA1188114_P_NODE_13798_length_166_cov_0.871795_g13746_i0 | PRJNA1188114 | 13798 | 166 | 0.871795 | 1.4471797 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 96.7 | 1.93e-23 | NR | XOR59527.1 | 2832643 | g13746 | i0 | 78.2 | 0.993975903614458 | 55 | 12 | 99.4 | 0 | 166 | 2 | 60 | 114 | XOR59527.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 165 | 96.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32317307 | 32317307 | PRJNA1188114_P_NODE_1299_length_377_cov_1.643293_g1247_i0 | PRJNA1188114 | 1299 | 377 | 1.643293 | 6.19521461 | Moloney murine leukemia virus | 11801 | Viruses | Viruses | 256 | 3.98e-76 | NR | NP_057933.2 | 11801 | g1247 | i0 | 100 | 4.97347480106101 | 125 | 0 | 99.5 | 0 | 3 | 377 | 1048 | 1172 | NP_057933.2 Pr180 [Moloney murine leukemia virus] | diamond | 1875 | 256 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 32348876 | 32348876 | PRJNA1188114_P_NODE_6579_length_189_cov_1.442857_g6527_i0 | PRJNA1188114 | 6579 | 189 | 1.442857 | 2.72699973 | Acinetobacter phage Presley | 1406780 | Viruses | Viruses | 108 | 1.68e-25 | NR | YP_009007656.1 | 1406780 | g6527 | i0 | 73 | 1 | 63 | 17 | 100 | 0 | 189 | 1 | 52 | 114 | YP_009007656.1 portal protein [Acinetobacter phage Presley] | diamond | 189 | 108 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Presleyvirus | Presleyvirus presley |
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);;