contig_metadata
19 rows where bioproject = "PRJNA688931" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1944659 | 1944659 | PRJNA688931_P_NODE_44142_length_161_cov_2.303571_g43929_i0 | PRJNA688931 | 44142 | 161 | 2.303571 | 3.70874931 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 292 | 7.24e-75 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g43929 | i0 | 99.379 | 264.844720496894 | 161 | 1 | 100 | 0 | 1 | 161 | 18411 | 18251 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 42640 | 292 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4496646 | 4496646 | PRJNA688931_P_NODE_40264_length_164_cov_2.121739_g40051_i0 | PRJNA688931 | 40264 | 164 | 2.121739 | 3.47965196 | Kremarvirus VCM | 3430280 | Viruses | Viruses | 209 | 7.68e-50 | NTclustered | gi|985769500|ref|NC_029065.1| | 1729937 | g40051 | i0 | 89.634 | 6 | 164 | 17 | 100 | 0 | 1 | 164 | 42692 | 42529 | Pseudomonas phage VCM genome assembly VCM, chromosome : 1 | blastn | 984 | 209 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Kremarvirus | Kremarvirus VCM | |||
| 5772207 | 5772207 | PRJNA688931_P_NODE_42325_length_163_cov_0.903509_g42112_i0 | PRJNA688931 | 42325 | 163 | 0.903509 | 1.47271967 | Marine virus AFVG_250M1017 | 2693035 | Viruses | Viruses | 52.8 | 0.014 | NTclustered | gi|1789809979|gb|MN694335.1| | 2693035 | g42112 | i0 | 96.774 | 0.190184049079755 | 31 | 1 | 19 | 0 | 120 | 150 | 8465 | 8495 | MAG: Marine virus AFVG_250M1017, complete genome | blastn | 31 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marine virus AFVG_250M1017 | |||||
| 8321633 | 8321633 | PRJNA688931_P_NODE_27667_length_194_cov_1.048276_g27454_i0 | PRJNA688931 | 27667 | 194 | 1.048276 | 2.03365544 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 154 | 4.46e-33 | NTclustered | gi|2914888999|gb|OR222612.1| | 2832643 | g27454 | i0 | 81.122 | 2.02061855670103 | 196 | 33 | 100 | 4 | 1 | 194 | 22735 | 22928 | MAG: Caudoviricetes sp. isolate MSP0322 genomic sequence | blastn | 392 | 154 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18520533 | 18520533 | PRJNA688931_P_NODE_24795_length_205_cov_1.673077_g24582_i0 | PRJNA688931 | 24795 | 205 | 1.673077 | 3.42980785 | Paenibacillus phage Pahemo | 2835998 | Viruses | Viruses | 60.2 | 1.07e-4 | NTclustered | gi|2044627981|gb|MW927522.1| | 2835998 | g24582 | i0 | 97.222 | 0.175609756097561 | 36 | 0 | 17 | 1 | 171 | 205 | 41934 | 41899 | Paenibacillus phage Pahemo, complete genome | blastn | 36 | 60.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Fernvirus | Paenibacillus phage Pahemo | ||||
| 18520665 | 18520665 | PRJNA688931_P_NODE_41275_length_164_cov_0.886957_g41062_i0 | PRJNA688931 | 41275 | 164 | 0.886957 | 1.45460948 | Mimasvirus CBB | 2560628 | Viruses | Viruses | 265 | 1.6199999999999998e-66 | NTclustered | gi|1631916624|ref|NC_041878.1| | 2772511 | g41062 | i0 | 95.732 | 4.99390243902439 | 164 | 7 | 100 | 0 | 1 | 164 | 323678 | 323841 | Pectobacterium phage CBB, complete genome | blastn | 819 | 265 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Mimasvirus | Mimasvirus CBB | ||||
| 23621354 | 23621354 | PRJNA688931_P_NODE_25519_length_202_cov_1.535948_g25306_i0 | PRJNA688931 | 25519 | 202 | 1.535948 | 3.10261496 | Omahavirus UNOG1W1 | 3431222 | Viruses | Viruses | 268 | 1.5999999999999998e-67 | NTclustered | gi|2725655757|gb|PP551948.2| | 3136609 | g25306 | i0 | 90.594 | 19.3514851485149 | 202 | 19 | 100 | 0 | 1 | 202 | 59116 | 58915 | Pseudomonas phage UNO-G1W1, complete genome | blastn | 3909 | 268 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Omahavirus | Omahavirus UNOG1W1 | |||
| 24894802 | 24894802 | PRJNA688931_P_NODE_41740_length_163_cov_1.315789_g41527_i0 | PRJNA688931 | 41740 | 163 | 1.315789 | 2.14473607 | Omahavirus UNOG1W1 | 3431222 | Viruses | Viruses | 268 | 1.24e-67 | NTclustered | gi|2725655757|gb|PP551948.2| | 3136609 | g41527 | i0 | 96.319 | 11.6625766871166 | 163 | 6 | 100 | 0 | 1 | 163 | 31257 | 31419 | Pseudomonas phage UNO-G1W1, complete genome | blastn | 1901 | 268 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Omahavirus | Omahavirus UNOG1W1 | |||
| 25404591 | 25404591 | PRJNA688931_P_NODE_42020_length_163_cov_0.912281_g41807_i0 | PRJNA688931 | 42020 | 163 | 0.912281 | 1.48701803 | Pahexavirus | 1982251 | Viruses | Viruses | 294 | 2.04e-75 | NTclustered | gi|849254459|ref|NC_027373.1| | 1500800 | g41807 | i0 | 99.383 | 99.680981595092 | 162 | 1 | 99 | 0 | 1 | 162 | 10888 | 11049 | Propionibacterium phage PHL030N00, complete genome | blastn | 16248 | 294 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PHL117M01 | ||||
| 27599533 | 27599533 | PRJNA688931_P_NODE_30684_length_183_cov_1.365672_g30471_i0 | PRJNA688931 | 30684 | 183 | 1.365672 | 2.49917976 | Vandenendeviridae | 3424680 | Viruses | Viruses | 112 | 1.51e-29 | NR | YP_010766635.1 | 2873460 | g30471 | i0 | 90.7 | 2.65573770491803 | 54 | 5 | 88.5 | 0 | 182 | 21 | 15 | 68 | YP_010766635.1 endolysin [Pseudomonas phage M5.1] | diamond | 486 | 112 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Kremarvirus | Kremarvirus M51 | |||
| 27619502 | 27619502 | PRJNA688931_P_NODE_35724_length_168_cov_1.462185_g35511_i0 | PRJNA688931 | 35724 | 168 | 1.462185 | 2.4564708 | Myoviridae sp. ctThM1 | 2656730 | Viruses | Viruses | 92 | 4.539999999999999e-23 | NR | QGH72617.1 | 2656730 | g35511 | i0 | 84.8 | 0.821428571428571 | 46 | 7 | 82.1 | 0 | 138 | 1 | 1 | 46 | QGH72617.1 MAG: hypothetical protein [Myoviridae sp. ctThM1] | diamond | 138 | 92 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Myoviridae sp. ctThM1 | |||||
| 28010012 | 28010012 | PRJNA688931_P_NODE_36885_length_167_cov_1.050847_g36672_i0 | PRJNA688931 | 36885 | 167 | 1.050847 | 1.75491449 | Otagovirus | 2560197 | Viruses | Viruses | 51.6 | 7.76e-7 | NR | UAV90041.1 | 2873461 | g36672 | i0 | 48.8 | 1.47305389221557 | 41 | 21 | 73.7 | 0 | 140 | 18 | 1 | 41 | UAV90041.1 hypothetical protein REC_192 [Pseudomonas phage REC] | diamond | 246 | 52 | 0.992307692307692 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Otagovirus | Pseudomonas phage REC | |||
| 28945771 | 28945771 | PRJNA688931_P_NODE_42728_length_163_cov_0.877193_g42515_i0 | PRJNA688931 | 42728 | 163 | 0.877193 | 1.42982459 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.6 | 5.2e-14 | NR | XOR43005.1 | 2832643 | g42515 | i0 | 74.1 | 0.993865030674847 | 54 | 14 | 99.4 | 0 | 1 | 162 | 10 | 63 | XOR43005.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 162 | 73.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29861176 | 29861176 | PRJNA688931_P_NODE_42251_length_163_cov_0.903509_g42038_i0 | PRJNA688931 | 42251 | 163 | 0.903509 | 1.47271967 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 42 | 0.0127 | NR | CAB4132255.1 | 2100421 | g42038 | i0 | 45.7 | 0.846625766871166 | 46 | 24 | 82.8 | 1 | 29 | 163 | 1 | 46 | CAB4132255.1 hypothetical protein UFOVP248_4 [uncultured Caudovirales phage] | diamond | 138 | 42 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30524620 | 30524620 | PRJNA688931_P_NODE_39353_length_165_cov_0.913793_g39140_i0 | PRJNA688931 | 39353 | 165 | 0.913793 | 1.50775845 | Pseudomonas phage REC | 2873461 | Viruses | Viruses | 62 | 1.9e-10 | NR | UAV89899.1 | 2873461 | g39140 | i0 | 90 | 0.545454545454545 | 30 | 3 | 54.5 | 0 | 75 | 164 | 1 | 30 | UAV89899.1 polynucleotide kinase [Pseudomonas phage REC] | diamond | 90 | 62 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Otagovirus | Pseudomonas phage REC | |||
| 30872162 | 30872162 | PRJNA688931_P_NODE_44574_length_154_cov_2.571429_g44361_i0 | PRJNA688931 | 44574 | 154 | 2.571429 | 3.96000066 | Pseudomonas phage vB_PsyM_KIL1 | 1777065 | Viruses | Viruses | 60.1 | 2.82e-9 | NR | YP_009276064.1 | 1777065 | g44361 | i0 | 77.4 | 0.603896103896104 | 31 | 7 | 60.4 | 0 | 152 | 60 | 29 | 59 | YP_009276064.1 hypothetical protein BH774_gp067 [Pseudomonas phage vB_PsyM_KIL1] | diamond | 93 | 60.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Flaumdravirus | Flaumdravirus KIL4 | |||
| 31630868 | 31630868 | PRJNA688931_P_NODE_30396_length_184_cov_1.259259_g30183_i0 | PRJNA688931 | 30396 | 184 | 1.259259 | 2.31703656 | Pseudomonas phage vB_PseuGesM_254 | 3092638 | Viruses | Viruses | 48.9 | 1.22e-5 | NR | WOZ57421.1 | 3092638 | g30183 | i0 | 41.5 | 0.864130434782609 | 53 | 29 | 83.2 | 1 | 6 | 158 | 32 | 84 | WOZ57421.1 hypothetical protein [Pseudomonas phage vB_PseuGesM_254] | diamond | 159 | 48.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Chemalvirus | Chemalvirus PseuGes254 | |||
| 31788837 | 31788837 | PRJNA688931_P_NODE_14237_length_274_cov_1.982222_g14024_i0 | PRJNA688931 | 14237 | 274 | 1.982222 | 5.43128828 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 45.1 | 0.00244 | NR | DAS36713.1 | 2832643 | g14024 | i0 | 36.2 | 0.755474452554745 | 69 | 40 | 71.2 | 2 | 33 | 227 | 25 | 93 | DAS36713.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 207 | 45.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31978833 | 31978833 | PRJNA688931_P_NODE_31378_length_180_cov_2.564885_g31165_i0 | PRJNA688931 | 31378 | 180 | 2.564885 | 4.616793 | Pseudomonas phage vB_PpS_SYP | 3020390 | Viruses | Viruses | 53.1 | 1.46e-6 | NR | WCO82025.1 | 3020390 | g31165 | i0 | 58 | 0.833333333333333 | 50 | 21 | 83.3 | 0 | 4 | 153 | 127 | 176 | WCO82025.1 hypothetical protein vBPpSSYP_43 [Pseudomonas phage vB_PpS_SYP] | diamond | 150 | 53.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage vB_PpS_SYP |
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);;