contig_metadata
17 rows where bioproject = "PRJNA1249042" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1629345 | 1629345 | PRJNA1249042_S_NODE_50622_length_209_cov_2.265060_g50408_i0 | PRJNA1249042 | 50622 | 209 | 2.26506 | 4.7339754 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 311 | 2.74e-80 | NTclustered | gi|2059975306|tpg|BK025796.1| | 2832643 | g50408 | i0 | 95.385 | 1.32057416267943 | 195 | 9 | 93 | 0 | 1 | 195 | 58273 | 58467 | MAG TPA_asm: Caudoviricetes sp. isolate ctrin26, partial genome | blastn | 276 | 311 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4181418 | 4181418 | PRJNA1249042_S_NODE_15204_length_280_cov_1359.059072_g14990_i0 | PRJNA1249042 | 15204 | 280 | 1359.059072 | 3805.3654016 | Enterococcus phage SSMH01 | 3075855 | Viruses | Viruses | 134 | 8.960000000000001e-27 | NTclustered | gi|2583824285|gb|OR360270.1| | 3075855 | g14990 | i0 | 95.294 | 52.5142857142857 | 85 | 2 | 30 | 2 | 1 | 85 | 41681 | 41599 | Enterococcus phage SSMH01, complete genome | blastn | 14704 | 134 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Efquatrovirus | Enterococcus phage SSMH01 | ||||
| 5458182 | 5458182 | PRJNA1249042_S_NODE_80865_length_177_cov_2.044776_g80651_i0 | PRJNA1249042 | 80865 | 177 | 2.044776 | 3.61925352 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|1839143214|emb|LR796235.1| | 2100421 | g80651 | i0 | 100 | 0.163841807909605 | 29 | 0 | 16 | 0 | 137 | 165 | 109131 | 109159 | uncultured Caudovirales phage genome assembly | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 8007514 | 8007514 | PRJNA1249042_S_NODE_100587_length_161_cov_1.508475_g100373_i0 | PRJNA1249042 | 100587 | 161 | 1.508475 | 2.42864475 | Staphylococcus phage vB_SurP-PSU3 | 2894773 | Viruses | Viruses | 292 | 7.24e-75 | NTclustered | gi|2154937499|gb|OK574338.1| | 2894773 | g100373 | i0 | 99.379 | 21.7826086956522 | 161 | 1 | 100 | 0 | 1 | 161 | 9395 | 9235 | Staphylococcus phage vB_SurP-PSU3, complete genome | blastn | 3507 | 292 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rountreeviridae | Andhravirus | Staphylococcus phage vB_SurP-PSU3 | |||
| 11833182 | 11833182 | PRJNA1249042_S_NODE_55550_length_203_cov_2.350000_g55336_i0 | PRJNA1249042 | 55550 | 203 | 2.35 | 4.7705 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.018 | NTclustered | gi|2058061185|tpg|BK042745.1| | 2832643 | g55336 | i0 | 100 | 0.137931034482759 | 28 | 0 | 14 | 0 | 176 | 203 | 33 | 6 | MAG TPA_asm: Caudoviricetes sp. isolate ct08t7, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18206654 | 18206654 | PRJNA1249042_S_NODE_97995_length_163_cov_1.175000_g97781_i0 | PRJNA1249042 | 97995 | 163 | 1.175 | 1.91525 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 110 | 7.95e-20 | NTclustered | gi|2052972878|tpg|BK030454.1| | 2832643 | g97781 | i0 | 78.882 | 0.987730061349693 | 161 | 34 | 99 | 0 | 3 | 163 | 33642 | 33802 | MAG TPA_asm: Caudoviricetes sp. isolate ctQfE6, partial genome | blastn | 161 | 110 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22030943 | 22030943 | PRJNA1249042_S_NODE_117438_length_150_cov_1.514019_g117224_i0 | PRJNA1249042 | 117438 | 150 | 1.514019 | 2.2710285 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 233 | 4.07e-57 | NTclustered | gi|2057873023|tpg|BK050697.1| | 2832643 | g117224 | i0 | 94.667 | 1 | 150 | 8 | 100 | 0 | 1 | 150 | 4320 | 4469 | MAG TPA_asm: Caudoviricetes sp. isolate cteKi71, partial genome | blastn | 150 | 233 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23306525 | 23306525 | PRJNA1249042_S_NODE_104679_length_158_cov_1.626087_g104465_i0 | PRJNA1249042 | 104679 | 158 | 1.626087 | 2.56921746 | Siphoviridae sp. ctkcl3 | 2826445 | Viruses | Viruses | 231 | 1.5599999999999998e-56 | NTclustered | gi|2051087633|tpg|BK014775.1| | 2826445 | g104465 | i0 | 93.038 | 1 | 158 | 11 | 100 | 0 | 1 | 158 | 712 | 555 | MAG TPA_asm: Siphoviridae sp. ctkcl3, partial genome | blastn | 158 | 231 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctkcl3 | |||||
| 24580797 | 24580797 | PRJNA1249042_S_NODE_35280_length_231_cov_1719.882979_g35066_i0 | PRJNA1249042 | 35280 | 231 | 1719.882979 | 3972.92968149 | Enterococcus phage SSMH01 | 3075855 | Viruses | Viruses | 134 | 7.17e-27 | NTclustered | gi|2583824285|gb|OR360270.1| | 3075855 | g35066 | i0 | 95.294 | 59.9134199134199 | 85 | 2 | 37 | 2 | 1 | 85 | 41681 | 41599 | Enterococcus phage SSMH01, complete genome | blastn | 13840 | 134 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Efquatrovirus | Enterococcus phage SSMH01 | ||||
| 24580891 | 24580891 | PRJNA1249042_S_NODE_45580_length_216_cov_1.630058_g45366_i0 | PRJNA1249042 | 45580 | 216 | 1.630058 | 3.52092528 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.019 | NTclustered | gi|2054449737|tpg|BK031291.1| | 2832643 | g45366 | i0 | 100 | 0.12962962962963 | 28 | 0 | 13 | 0 | 172 | 199 | 120225 | 120252 | MAG TPA_asm: Caudoviricetes sp. isolate ct3F98, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24580941 | 24580941 | PRJNA1249042_S_NODE_51220_length_208_cov_3.103030_g51006_i0 | PRJNA1249042 | 51220 | 208 | 3.10303 | 6.4543024 | Herelleviridae sp. | 2831613 | Viruses | Viruses | 340 | 3.4699999999999996e-89 | NTclustered | gi|2053222532|tpg|BK035302.1| | 2831613 | g51006 | i0 | 96.154 | 6.99038461538461 | 208 | 8 | 100 | 0 | 1 | 208 | 7567 | 7360 | MAG TPA_asm: Herelleviridae sp. isolate ctznq1, partial genome | blastn | 1454 | 340 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Herelleviridae sp. | ||||
| 28115823 | 28115823 | PRJNA1249042_S_NODE_98845_length_162_cov_1.974790_g98631_i0 | PRJNA1249042 | 98845 | 162 | 1.97479 | 3.1991598 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 97.1 | 4.23e-22 | NR | DAT71371.1 | 2832643 | g98631 | i0 | 83 | 0.981481481481482 | 53 | 9 | 98.1 | 0 | 161 | 3 | 110 | 162 | DAT71371.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 159 | 97.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29599663 | 29599663 | PRJNA1249042_S_NODE_78850_length_179_cov_1.713235_g78636_i0 | PRJNA1249042 | 78850 | 179 | 1.713235 | 3.06669065 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 103 | 1.86e-26 | NR | DAV29426.1 | 2832643 | g78636 | i0 | 77.2 | 9.63687150837989 | 57 | 13 | 95.5 | 0 | 7 | 177 | 54 | 110 | DAV29426.1 MAG TPA: YopX protein [Caudoviricetes sp.] | diamond | 1725 | 103 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30326939 | 30326939 | PRJNA1249042_S_NODE_86412_length_172_cov_2.186047_g86198_i0 | PRJNA1249042 | 86412 | 172 | 2.186047 | 3.76000084 | Xanthomonas phage CP1 | 2994055 | Viruses | Viruses | 40.8 | 0.0105 | NR | YP_007238114.1 | 2994055 | g86198 | i0 | 45 | 0.697674418604651 | 40 | 22 | 69.8 | 0 | 152 | 33 | 17 | 56 | YP_007238114.1 hypothetical protein G176_gp44 [Xanthomonas phage CP1] | diamond | 120 | 40.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Klementvirus | Klementvirus CP1 | ||||
| 31084738 | 31084738 | PRJNA1249042_S_NODE_39095_length_225_cov_3.098901_g38881_i0 | PRJNA1249042 | 39095 | 225 | 3.098901 | 6.97252725 | Listeria phage vB_Lino_VEfB7 | 2712944 | Viruses | Viruses | 80.9 | 9.94e-16 | NR | QIG60834.1 | 2712944 | g38881 | i0 | 76.1 | 0.613333333333333 | 46 | 11 | 61.3 | 0 | 223 | 86 | 423 | 468 | QIG60834.1 putative major capsid protein [Listeria phage vB_Lino_VEfB7] | diamond | 138 | 80.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Pecentumvirus | Listeria phage vB_Lino_VEfB7 | |||
| 32223427 | 32223427 | PRJNA1249042_S_NODE_25018_length_252_cov_1.349282_g24804_i0 | PRJNA1249042 | 25018 | 252 | 1.349282 | 3.40019064 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 55.8 | 4.95e-7 | NR | DAO50445.1 | 2832643 | g24804 | i0 | 60 | 0.476190476190476 | 40 | 16 | 47.6 | 0 | 131 | 250 | 30 | 69 | DAO50445.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 120 | 55.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32886073 | 32886073 | PRJNA1249042_S_NODE_10200_length_307_cov_2.515152_g9986_i0 | PRJNA1249042 | 10200 | 307 | 2.515152 | 7.72151664 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.6 | 3.01e-14 | NR | DAH73638.1 | 2832643 | g9986 | i0 | 40.6 | 0.986970684039088 | 101 | 57 | 98.7 | 2 | 306 | 4 | 16 | 113 | DAH73638.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 303 | 73.6 | 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);;