contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA599026" and tax_kingdom = "Heunggongvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26795073 | 26795073 | PRJNA599026_S_NODE_13301_length_274_cov_0.906667_g12845_i0 | PRJNA599026 | 13301 | 274 | 0.906667 | 2.48426758 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 85.1 | 6.74e-17 | NR | XOR00218.1 | 2832643 | g12845 | i0 | 53.3 | 3.28467153284672 | 75 | 34 | 81 | 1 | 235 | 14 | 244 | 318 | XOR00218.1 MAG: ATP-dependent DNA helicase uvsW [Caudoviricetes sp.] | diamond | 900 | 85.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26921703 | 26921703 | PRJNA599026_S_NODE_56782_length_165_cov_0.879310_g56326_i0 | PRJNA599026 | 56782 | 165 | 0.87931 | 1.4508615 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 51.2 | 1.3e-5 | NR | XOR22972.1 | 2832643 | g56326 | i0 | 54.5 | 1.69090909090909 | 44 | 20 | 80 | 0 | 15 | 146 | 671 | 714 | XOR22972.1 MAG: gp186 protein [Caudoviricetes sp.] | diamond | 279 | 51.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27187848 | 27187848 | PRJNA599026_S_NODE_57022_length_165_cov_0.879310_g56566_i0 | PRJNA599026 | 57022 | 165 | 0.87931 | 1.4508615 | Aristophanesvirus | 3424889 | Viruses | Viruses | 109 | 4.49e-26 | NR | QNO11440.1 | 2759203 | g56566 | i0 | 92.6 | 1.96363636363636 | 54 | 4 | 98.2 | 0 | 163 | 2 | 438 | 491 | QNO11440.1 putative DNA polymerase [Acinetobacter phage Aristophanes] | diamond | 324 | 110 | 0.990909090909091 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autoscriptoviridae | Aristophanesvirus | Aristophanesvirus aristophanes | ||
| 27932725 | 27932725 | PRJNA599026_S_NODE_56865_length_165_cov_0.879310_g56409_i0 | PRJNA599026 | 56865 | 165 | 0.87931 | 1.4508615 | Klebsiella phage EI | 2601625 | Viruses | Viruses | 95.5 | 1.45e-22 | NR | QEM42216.1 | 2601625 | g56409 | i0 | 80 | 2 | 55 | 11 | 100 | 0 | 1 | 165 | 134 | 188 | QEM42216.1 exonuclease [Klebsiella phage EI] | diamond | 330 | 95.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage EI | ||||
| 27964228 | 27964228 | PRJNA599026_S_NODE_63245_length_163_cov_0.894737_g62789_i0 | PRJNA599026 | 63245 | 163 | 0.894737 | 1.45842131 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 96.3 | 1.78e-21 | NR | XOS66335.1 | 2832643 | g62789 | i0 | 87 | 0.993865030674847 | 54 | 7 | 99.4 | 0 | 2 | 163 | 1528 | 1581 | XOS66335.1 MAG: hypothetical protein MSP0579_7 [Caudoviricetes sp.] | diamond | 162 | 96.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27995962 | 27995962 | PRJNA599026_S_NODE_68385_length_162_cov_0.893805_g67929_i0 | PRJNA599026 | 68385 | 162 | 0.893805 | 1.4479641 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 75.1 | 2.69e-14 | NR | XOR38069.1 | 2832643 | g67929 | i0 | 68.6 | 0.944444444444444 | 51 | 16 | 94.4 | 0 | 158 | 6 | 1 | 51 | XOR38069.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 153 | 75.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28122159 | 28122159 | PRJNA599026_S_NODE_55685_length_166_cov_0.863248_g55229_i0 | PRJNA599026 | 55685 | 166 | 0.863248 | 1.43299168 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 46.2 | 7.14e-4 | NR | XOQ89781.1 | 2832643 | g55229 | i0 | 46.3 | 0.975903614457831 | 54 | 24 | 97.6 | 1 | 163 | 2 | 130 | 178 | XOQ89781.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 162 | 46.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28406416 | 28406416 | PRJNA599026_S_NODE_63546_length_163_cov_0.894737_g63090_i0 | PRJNA599026 | 63546 | 163 | 0.894737 | 1.45842131 | Halobacterium phage phiH | 169684 | Viruses | Viruses | 70.5 | 6.38e-14 | NR | YP_009981844.1 | 169684 | g63090 | i0 | 81 | 0.773006134969325 | 42 | 8 | 77.3 | 0 | 163 | 38 | 5 | 46 | YP_009981844.1 endonuclease [Halobacterium phage phiH] | diamond | 126 | 70.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vertoviridae | Myohalovirus | Myohalovirus spontanei | |||
| 28564246 | 28564246 | PRJNA599026_S_NODE_54047_length_166_cov_0.871795_g53591_i0 | PRJNA599026 | 54047 | 166 | 0.871795 | 1.4471797 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 106 | 4.15e-25 | NR | XOS29123.1 | 2832643 | g53591 | i0 | 94.5 | 0.993975903614458 | 55 | 3 | 99.4 | 0 | 166 | 2 | 840 | 894 | XOS29123.1 MAG: putative tail fiber protein H [Caudoviricetes sp.] | diamond | 165 | 106 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28848164 | 28848164 | PRJNA599026_S_NODE_71228_length_161_cov_0.910714_g70772_i0 | PRJNA599026 | 71228 | 161 | 0.910714 | 1.46624954 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 62.8 | 1.04e-9 | NR | XOQ89891.1 | 2832643 | g70772 | i0 | 54.4 | 1.06211180124224 | 57 | 22 | 98.8 | 1 | 3 | 161 | 344 | 400 | XOQ89891.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 171 | 62.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29479525 | 29479525 | PRJNA599026_S_NODE_71650_length_161_cov_0.910714_g71194_i0 | PRJNA599026 | 71650 | 161 | 0.910714 | 1.46624954 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 53.9 | 1.39e-6 | NR | CAB4144356.1 | 2100421 | g71194 | i0 | 56.8 | 1.77018633540373 | 44 | 19 | 82 | 0 | 12 | 143 | 162 | 205 | CAB4144356.1 Domain of unknown function DUF927 [uncultured Caudovirales phage] | diamond | 285 | 53.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29524823 | 29524823 | PRJNA599026_S_NODE_64690_length_163_cov_0.894737_g64234_i0 | PRJNA599026 | 64690 | 163 | 0.894737 | 1.45842131 | root | 1 | Root_unresolved | Root_unresolved | 42 | 0.0232 | NR | YP_005098425.1 | 1131315 | g64234 | i0 | 68.8 | 1.49079754601227 | 32 | 9 | 58.9 | 1 | 3 | 98 | 82 | 112 | YP_005098425.1 internal virion protein [Erwinia phage PEp14] | diamond | 243 | 42 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pavtokvirus | Pavtokvirus PEp14 | ||||
| 29732198 | 29732198 | PRJNA599026_S_NODE_35870_length_189_cov_1.435714_g35414_i0 | PRJNA599026 | 35870 | 189 | 1.435714 | 2.71349946 | Pseudomonas phage PE | 3431519 | Viruses | Viruses | 52 | 8.12e-7 | NR | YP_010768246.1 | 2696355 | g35414 | i0 | 40.4 | 1.82539682539683 | 57 | 31 | 85.7 | 1 | 23 | 184 | 4 | 60 | YP_010768246.1 hypothetical protein QGX22_gp118 [Pseudomonas phage PE09] | diamond | 345 | 52 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Otagovirus | Otagovirus PE09 | |||
| 29985125 | 29985125 | PRJNA599026_S_NODE_50811_length_167_cov_0.864407_g50355_i0 | PRJNA599026 | 50811 | 167 | 0.864407 | 1.44355969 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 63.2 | 8.29e-10 | NR | XOR91456.1 | 2832643 | g50355 | i0 | 53.8 | 0.934131736526946 | 52 | 24 | 93.4 | 0 | 8 | 163 | 515 | 566 | XOR91456.1 MAG: tail protein [Caudoviricetes sp.] | diamond | 156 | 63.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30396296 | 30396296 | PRJNA599026_S_NODE_72073_length_161_cov_0.892857_g71617_i0 | PRJNA599026 | 72073 | 161 | 0.892857 | 1.43749977 | Croceibacter phage P2559Y | 1327037 | Viruses | Viruses | 100 | 4.049999999999999e-23 | NR | YP_009010739.1 | 1327037 | g71617 | i0 | 88.7 | 0.987577639751553 | 53 | 6 | 98.8 | 0 | 2 | 160 | 543 | 595 | YP_009010739.1 DNA helicase [Croceibacter phage P2559Y] | diamond | 159 | 100 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Croceibacter phage P2559Y | |||||
| 30459445 | 30459445 | PRJNA599026_S_NODE_57233_length_165_cov_0.879310_g56777_i0 | PRJNA599026 | 57233 | 165 | 0.87931 | 1.4508615 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 42.4 | 0.0107 | NR | XOS67891.1 | 2832643 | g56777 | i0 | 84.2 | 0.690909090909091 | 19 | 3 | 34.5 | 0 | 108 | 164 | 1 | 19 | XOS67891.1 MAG: hypothetical protein MSP0547_22 [Caudoviricetes sp.] | diamond | 114 | 42.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30522207 | 30522207 | PRJNA599026_S_NODE_60313_length_164_cov_0.886957_g59857_i0 | PRJNA599026 | 60313 | 164 | 0.886957 | 1.45460948 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 77.8 | 3.2e-15 | NR | CAB4198347.1 | 2100421 | g59857 | i0 | 61.1 | 1.86585365853659 | 54 | 20 | 97 | 1 | 162 | 4 | 235 | 288 | CAB4198347.1 hypothetical protein UFOVP1309_74 [uncultured Caudovirales phage] | diamond | 306 | 77.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30964688 | 30964688 | PRJNA599026_S_NODE_58334_length_165_cov_0.879310_g57878_i0 | PRJNA599026 | 58334 | 165 | 0.87931 | 1.4508615 | Arthrobacter phage Atuin | 2885972 | Viruses | Viruses | 46.6 | 5.34e-4 | NR | UDL16779.1 | 2885972 | g57878 | i0 | 50 | 0.872727272727273 | 48 | 24 | 87.3 | 0 | 2 | 145 | 57 | 104 | UDL16779.1 minor tail protein [Arthrobacter phage Atuin] | diamond | 144 | 46.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Arthrobacter phage Atuin | |||||
| 31027930 | 31027930 | PRJNA599026_S_NODE_64975_length_163_cov_0.894737_g64519_i0 | PRJNA599026 | 64975 | 163 | 0.894737 | 1.45842131 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 71.6 | 5.01e-13 | NR | XOS01052.1 | 2832643 | g64519 | i0 | 69.8 | 0.975460122699387 | 53 | 14 | 93.9 | 1 | 159 | 7 | 31 | 83 | XOS01052.1 MAG: minor tail protein [Caudoviricetes sp.] | diamond | 159 | 71.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31059643 | 31059643 | PRJNA599026_S_NODE_32395_length_196_cov_1.387755_g31939_i0 | PRJNA599026 | 32395 | 196 | 1.387755 | 2.7199998 | Pseudaeromonas phage vB_PpeM_ KLEP7 | 2928862 | Viruses | Viruses | 71.2 | 1.79e-12 | NR | UNY40321.1 | 2928862 | g31939 | i0 | 57.6 | 1.01020408163265 | 66 | 25 | 98 | 2 | 1 | 192 | 315 | 379 | UNY40321.1 tail fiber protein [Pseudaeromonas phage vB_PpeM_ KLEP7] | diamond | 198 | 71.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudaeromonas phage vB_PpeM_ KLEP7 | |||||
| 31248904 | 31248904 | PRJNA599026_S_NODE_70975_length_161_cov_0.910714_g70519_i0 | PRJNA599026 | 70975 | 161 | 0.910714 | 1.46624954 | Caulobacter phage Percy | 1701809 | Viruses | Viruses | 63.2 | 7.55e-10 | NR | YP_009225269.1 | 1701809 | g70519 | i0 | 54.9 | 2.8695652173913 | 51 | 23 | 95 | 0 | 153 | 1 | 395 | 445 | YP_009225269.1 head-tail adaptor [Caulobacter phage Percy] | diamond | 462 | 63.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autonotataviridae | Percyvirus | Percyvirus percy | ||
| 31597123 | 31597123 | PRJNA599026_S_NODE_64196_length_163_cov_0.894737_g63740_i0 | PRJNA599026 | 64196 | 163 | 0.894737 | 1.45842131 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 42 | 0.0233 | NR | DAZ21175.1 | 2832643 | g63740 | i0 | 47.5 | 1.39877300613497 | 40 | 21 | 73.6 | 0 | 158 | 39 | 729 | 768 | DAZ21175.1 MAG TPA: tail protein [Caudoviricetes sp.] | diamond | 228 | 42 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32860968 | 32860968 | PRJNA599026_S_NODE_66860_length_162_cov_0.902655_g66404_i0 | PRJNA599026 | 66860 | 162 | 0.902655 | 1.4623011 | Acinetobacter phage Acj61 | 760732 | Viruses | Viruses | 108 | 2.23e-26 | NR | YP_004009858.1 | 760732 | g66404 | i0 | 92.6 | 1 | 54 | 4 | 100 | 0 | 1 | 162 | 278 | 331 | YP_004009858.1 RIIB lysis inhibitor [Acinetobacter phage Acj61] | diamond | 162 | 108 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Lasallevirus | Lasallevirus Acj61 |
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);;