contig_metadata
17 rows where bioproject = "PRJNA637219" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 608869 | 608869 | PRJNA637219_S_NODE_9861_length_171_cov_1.254098_g9816_i0 | PRJNA637219 | 9861 | 171 | 1.254098 | 2.14450758 | Moineauvirus CHPC928 | 3060339 | Viruses | Viruses | 305 | 9.96e-79 | NTclustered | gi|2437985123|ref|NC_070680.1| | 2365049 | g9816 | i0 | 98.83 | 99.953216374269 | 171 | 2 | 100 | 0 | 1 | 171 | 4693 | 4523 | Streptococcus phage CHPC928, complete genome | blastn | 17092 | 305 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aliceevansviridae | Moineauvirus | Moineauvirus CHPC928 | |||
| 6258698 | 6258698 | PRJNA637219_S_NODE_15365_length_162_cov_1.973451_g15320_i0 | PRJNA637219 | 15365 | 162 | 1.973451 | 3.19699062 | Aliceevansviridae | 3044455 | Viruses | Viruses | 300 | 4.36e-77 | NTclustered | gi|2438273029|ref|NC_071057.1| | 1913083 | g15320 | i0 | 100 | 29.2222222222222 | 162 | 0 | 100 | 0 | 1 | 162 | 23619 | 23458 | Streptococcus phage CHPC1151, complete genome | blastn | 4734 | 300 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aliceevansviridae | Vansinderenvirus | Vansinderenvirus CHPC1232 | |||
| 7532896 | 7532896 | PRJNA637219_S_NODE_12766_length_165_cov_0.879310_g12721_i0 | PRJNA637219 | 12766 | 165 | 0.87931 | 1.4508615 | Moineauvirus | 1623304 | Viruses | Viruses | 305 | 9.59e-79 | NTclustered | gi|2437985630|ref|NC_070691.1| | 1971415 | g12721 | i0 | 100 | 94.8848484848485 | 165 | 0 | 100 | 0 | 1 | 165 | 4688 | 4524 | Streptococcus phage P3681, complete genome | blastn | 15656 | 305 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aliceevansviridae | Moineauvirus | Moineauvirus P3681 | |||
| 8262022 | 8262022 | PRJNA637219_S_NODE_16967_length_161_cov_0.910714_g16922_i0 | PRJNA637219 | 16967 | 161 | 0.910714 | 1.46624954 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 292 | 7.24e-75 | NTclustered | gi|2914849708|gb|OR221454.1| | 2832643 | g16922 | i0 | 99.379 | 1 | 161 | 1 | 100 | 0 | 1 | 161 | 29342 | 29182 | MAG: Caudoviricetes sp. isolate MSP1629 genomic sequence | blastn | 161 | 292 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11358462 | 11358462 | PRJNA637219_S_NODE_14869_length_163_cov_0.894737_g14824_i0 | PRJNA637219 | 14869 | 163 | 0.894737 | 1.45842131 | Moineauvirus | 1623304 | Viruses | Viruses | 302 | 1.22e-77 | NTclustered | gi|63025523|gb|AF348736.3| | 152564 | g14824 | i0 | 100 | 100.993865030675 | 163 | 0 | 100 | 0 | 1 | 163 | 4497 | 4659 | Streptococcus thermophilus bacteriophage MD2 putative tape measure protein, phage structural protein, and receptor binding protein genes, complete cds | blastn | 16462 | 302 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Streptococcus phage MD2 | |||||
| 12088197 | 12088197 | PRJNA637219_S_NODE_15370_length_162_cov_1.840708_g15325_i0 | PRJNA637219 | 15370 | 162 | 1.840708 | 2.98194696 | Salasvirus phi29 | 10756 | Viruses | Viruses | 276 | 7.350000000000001e-70 | NTclustered | gi|15731|emb|X53371.1| | 2884424 | g15325 | i0 | 99.342 | 17.7716049382716 | 152 | 1 | 94 | 0 | 1 | 152 | 161 | 10 | Bacteriophage phi29 temperature sensitive mutant TS2(24) DNA polymerase gene | blastn | 2879 | 276 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Salasmaviridae | Salasvirus | Salasvirus phi29 | |||
| 12634090 | 12634090 | PRJNA637219_S_NODE_10050_length_170_cov_0.809917_g10005_i0 | PRJNA637219 | 10050 | 170 | 0.809917 | 1.3768589 | root | 1 | Root_unresolved | Root_unresolved | 198 | 1.73e-46 | NTclustered | gi|671698184|gb|KM192300.1| | 10359 | g10005 | i0 | 93.893 | 80.2058823529412 | 131 | 8 | 77 | 0 | 22 | 152 | 39139 | 39269 | Human herpesvirus 5 strain Merlin isolate RCMV1528, complete genome | blastn | 13635 | 198 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Cytomegalovirus | Cytomegalovirus humanbeta5 | ||
| 13908999 | 13908999 | PRJNA637219_S_NODE_13611_length_164_cov_0.886957_g13566_i0 | PRJNA637219 | 13611 | 164 | 0.886957 | 1.45460948 | Aliceevansviridae | 3044455 | Viruses | Viruses | 303 | 3.42e-78 | NTclustered | gi|2437983729|ref|NC_070651.1| | 1718281 | g13566 | i0 | 100 | 40.9146341463415 | 164 | 0 | 100 | 0 | 1 | 164 | 22457 | 22620 | Streptococcus phage 128, complete genome | blastn | 6710 | 303 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aliceevansviridae | Moineauvirus | Moineauvirus mv128 | |||
| 15183487 | 15183487 | PRJNA637219_S_NODE_14692_length_163_cov_0.894737_g14647_i0 | PRJNA637219 | 14692 | 163 | 0.894737 | 1.45842131 | Aliceevansviridae | 3044455 | Viruses | Viruses | 302 | 1.22e-77 | NTclustered | gi|2437983812|ref|NC_070653.1| | 1718279 | g14647 | i0 | 100 | 18.9263803680982 | 163 | 0 | 100 | 0 | 1 | 163 | 31215 | 31053 | Streptococcus phage 73, complete genome | blastn | 3085 | 302 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aliceevansviridae | Moineauvirus | Moineauvirus mv73 | |||
| 15183492 | 15183492 | PRJNA637219_S_NODE_16432_length_161_cov_1.821429_g16387_i0 | PRJNA637219 | 16432 | 161 | 1.821429 | 2.93250069 | Salasvirus | 186846 | Viruses | Viruses | 298 | 1.56e-76 | NTclustered | gi|1882288957|ref|NC_049974.1| | 2736266 | g16387 | i0 | 100 | 17.832298136646 | 161 | 0 | 100 | 0 | 1 | 161 | 2363 | 2203 | Bacillus phage Gxv1, complete genome | blastn | 2871 | 298 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Salasmaviridae | Salasvirus | Salasvirus Gxv1 | |||
| 18460989 | 18460989 | PRJNA637219_S_NODE_9995_length_170_cov_1.264463_g9950_i0 | PRJNA637219 | 9995 | 170 | 1.264463 | 2.1495871 | Salasvirus phi29 | 10756 | Viruses | Viruses | 315 | 1.64e-81 | NTclustered | gi|15731|emb|X53371.1| | 2884424 | g9950 | i0 | 100 | 21.4823529411765 | 170 | 0 | 100 | 0 | 1 | 170 | 1483 | 1652 | Bacteriophage phi29 temperature sensitive mutant TS2(24) DNA polymerase gene | blastn | 3652 | 315 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Salasmaviridae | Salasvirus | Salasvirus phi29 | |||
| 20281501 | 20281501 | PRJNA637219_S_NODE_3376_length_257_cov_1.471154_g3331_i0 | PRJNA637219 | 3376 | 257 | 1.471154 | 3.78086578 | Aliceevansviridae | 3044455 | Viruses | Viruses | 464 | 2.5299999999999998e-126 | NTclustered | gi|2437987205|ref|NC_070725.1| | 2069608 | g3331 | i0 | 99.222 | 26.3463035019455 | 257 | 2 | 100 | 0 | 1 | 257 | 5868 | 6124 | Streptococcus phage vB_SthS_VA214, complete genome | blastn | 6771 | 464 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aliceevansviridae | Moineauvirus | Moineauvirus VA214 | |||
| 21011183 | 21011183 | PRJNA637219_S_NODE_14777_length_163_cov_0.894737_g14732_i0 | PRJNA637219 | 14777 | 163 | 0.894737 | 1.45842131 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 302 | 1.22e-77 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g14732 | i0 | 100 | 1.53374233128834 | 163 | 0 | 100 | 0 | 1 | 163 | 37687 | 37525 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 250 | 302 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24107009 | 24107009 | PRJNA637219_S_NODE_1679_length_344_cov_1.427119_g1634_i0 | PRJNA637219 | 1679 | 344 | 1.427119 | 4.90928936 | Salasvirus | 186846 | Viruses | Viruses | 630 | 3.289999999999999e-176 | NTclustered | gi|1882288957|ref|NC_049974.1| | 2736266 | g1634 | i0 | 99.709 | 18.2441860465116 | 344 | 1 | 100 | 0 | 1 | 344 | 3047 | 2704 | Bacillus phage Gxv1, complete genome | blastn | 6276 | 636 | 0.990566037735849 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Salasmaviridae | Salasvirus | Salasvirus Gxv1 | |||
| 24107013 | 24107013 | PRJNA637219_S_NODE_2719_length_281_cov_1.461207_g2674_i0 | PRJNA637219 | 2719 | 281 | 1.461207 | 4.10599167 | Salasvirus | 186846 | Viruses | Viruses | 520 | 5.909999999999999e-143 | NTclustered | gi|15733|emb|X53370.1| | 2884424 | g2674 | i0 | 100 | 17.9928825622776 | 281 | 0 | 100 | 0 | 1 | 281 | 1333 | 1053 | Bacteriophage phi29 temperature sensitive mutant TS2(98) DNA polymerase gene | blastn | 5056 | 520 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Salasmaviridae | Salasvirus | Salasvirus phi29 | |||
| 24835174 | 24835174 | PRJNA637219_S_NODE_5060_length_219_cov_1.152941_g5015_i0 | PRJNA637219 | 5060 | 219 | 1.152941 | 2.52494079 | Moineauvirus VA214 | 3060388 | Viruses | Viruses | 394 | 2.79e-105 | NTclustered | gi|2437987205|ref|NC_070725.1| | 2069608 | g5015 | i0 | 99.087 | 99.4155251141552 | 219 | 2 | 100 | 0 | 1 | 219 | 27248 | 27030 | Streptococcus phage vB_SthS_VA214, complete genome | blastn | 21772 | 394 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aliceevansviridae | Moineauvirus | Moineauvirus VA214 | |||
| 28754755 | 28754755 | PRJNA637219_S_NODE_14567_length_163_cov_0.894737_g14522_i0 | PRJNA637219 | 14567 | 163 | 0.894737 | 1.45842131 | Arthrobacter phage Beagle | 2656522 | Viruses | Viruses | 39.7 | 0.0187 | NR | QGJ92786.1 | 2656522 | g14522 | i0 | 46.5 | 0.791411042944785 | 43 | 21 | 77.3 | 2 | 1 | 126 | 6 | 47 | QGJ92786.1 hypothetical protein PBI_BEAGLE_26 [Arthrobacter phage Beagle] | diamond | 129 | 39.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Arthrobacter phage Beagle |
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);;