contig_metadata
16 rows where bioproject = "PRJNA1122875" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4104553 | 4104553 | PRJNA1122875_P_NODE_19564_length_377_cov_1.519737_g19340_i0 | PRJNA1122875 | 19564 | 377 | 1.519737 | 5.72940849 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.01 | NTclustered | gi|2052241503|tpg|BK019419.1| | 2832643 | g19340 | i0 | 96.97 | 0.0875331564986737 | 33 | 0 | 8 | 1 | 148 | 179 | 101378 | 101410 | MAG TPA_asm: Caudoviricetes sp. isolate ctyBb16, partial genome | blastn | 33 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11755888 | 11755888 | PRJNA1122875_P_NODE_10150_length_520_cov_1.035794_g9931_i0 | PRJNA1122875 | 10150 | 520 | 1.035794 | 5.3861288 | Methylophilales phage MEP4 | 3003801 | Viruses | Viruses | 57.8 | 1.16e-6 | NR | WBF78151.1 | 3003801 | g9931 | i0 | 38.4 | 0.496153846153846 | 86 | 49 | 47.3 | 2 | 8 | 253 | 118 | 203 | WBF78151.1 hypothetical protein MEP402_gp31 [Methylophilales phage MEP402] | diamond | 258 | 57.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zobellviridae | Methylophilales phage MEP402 | ||||
| 11756098 | 11756098 | PRJNA1122875_P_NODE_25170_length_331_cov_1.089147_g24946_i0 | PRJNA1122875 | 25170 | 331 | 1.089147 | 3.60507657 | Crassvirales sp. | 2960088 | Viruses | Viruses | 612 | 1.14e-170 | NTclustered | gi|2053230001|tpg|BK035415.1| | 2960088 | g24946 | i0 | 100 | 4 | 331 | 0 | 100 | 0 | 1 | 331 | 43654 | 43984 | MAG TPA_asm: Crassvirales sp. isolate ctuIB16, partial genome | blastn | 1324 | 612 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Crassvirales | Crassvirales sp. | ||||
| 11756375 | 11756375 | PRJNA1122875_P_NODE_50890_length_244_cov_0.900585_g50666_i0 | PRJNA1122875 | 50890 | 244 | 0.900585 | 2.1974274 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 451 | 1.86e-122 | NTclustered | gi|2057950350|tpg|BK046180.1| | 2832643 | g50666 | i0 | 100 | 1 | 244 | 0 | 100 | 0 | 1 | 244 | 6186 | 6429 | MAG TPA_asm: Caudoviricetes sp. isolate ctgei1, partial genome | blastn | 244 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15580323 | 15580323 | PRJNA1122875_P_NODE_17613_length_398_cov_0.947692_g17389_i0 | PRJNA1122875 | 17613 | 398 | 0.947692 | 3.77181416 | Dulem virus 40 | 3145758 | Viruses | Viruses | 187 | 9.999999999999999e-43 | NTclustered | gi|2750933247|gb|PP511379.1| | 3145758 | g17389 | i0 | 81.982 | 0.557788944723618 | 222 | 38 | 56 | 2 | 3 | 223 | 37001 | 37221 | Dulem virus 40 isolate Duke_21_1, complete genome | blastn | 222 | 187 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Dulem virus 40 | |||||
| 19403551 | 19403551 | PRJNA1122875_P_NODE_34936_length_280_cov_1.391304_g34712_i0 | PRJNA1122875 | 34936 | 280 | 1.391304 | 3.8956512 | Propionibacterium phage QueenBey | 1654782 | Viruses | Viruses | 468 | 2.16e-127 | NTclustered | gi|1725329243|ref|NC_031005.2| | 1654782 | g34712 | i0 | 96.786 | 99.6285714285714 | 280 | 9 | 100 | 0 | 1 | 280 | 12120 | 11841 | Propionibacterium phage QueenBey, complete genome | blastn | 27896 | 468 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage QueenBey | ||||
| 19403704 | 19403704 | PRJNA1122875_P_NODE_48276_length_246_cov_0.890173_g48052_i0 | PRJNA1122875 | 48276 | 246 | 0.890173 | 2.18982558 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 444 | 3.14e-120 | NTclustered | gi|2053147871|tpg|BK018915.1| | 2832643 | g48052 | i0 | 99.187 | 7.02845528455285 | 246 | 2 | 100 | 0 | 1 | 246 | 15762 | 15517 | MAG TPA_asm: Caudoviricetes sp. isolate ctZfJ1, partial genome | blastn | 1729 | 444 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20679202 | 20679202 | PRJNA1122875_P_NODE_43617_length_251_cov_0.865169_g43393_i0 | PRJNA1122875 | 43617 | 251 | 0.865169 | 2.17157419 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 128 | 3.67e-25 | NTclustered | gi|2057984038|tpg|BK046807.1| | 2832643 | g43393 | i0 | 90.909 | 0.681274900398406 | 99 | 3 | 39 | 6 | 143 | 241 | 126826 | 126918 | MAG TPA_asm: Caudoviricetes sp. isolate ct57N1, partial genome | blastn | 171 | 128 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20679252 | 20679252 | PRJNA1122875_P_NODE_47417_length_247_cov_0.885057_g47193_i0 | PRJNA1122875 | 47417 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 76.8 | 1.32e-9 | NTclustered | gi|2914786415|gb|OR222567.1| | 2832643 | g47193 | i0 | 86.111 | 1.93927125506073 | 72 | 8 | 29 | 2 | 170 | 240 | 84161 | 84231 | MAG: Caudoviricetes sp. isolate MSP0365 genomic sequence | blastn | 479 | 76.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23230039 | 23230039 | PRJNA1122875_P_NODE_3999_length_765_cov_1.803468_g3803_i0 | PRJNA1122875 | 3999 | 765 | 1.803468 | 13.7965302 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.021 | NTclustered | gi|2914964766|gb|OR222006.1| | 2832643 | g3803 | i0 | 100 | 0.0379084967320261 | 29 | 0 | 4 | 0 | 652 | 680 | 15184 | 15156 | MAG: Caudoviricetes sp. isolate MSP0115 genomic sequence | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27386431 | 27386431 | PRJNA1122875_P_NODE_44143_length_250_cov_0.870056_g43919_i0 | PRJNA1122875 | 44143 | 250 | 0.870056 | 2.17514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 95.5 | 1.14e-20 | NR | DAH28747.1 | 2832643 | g43919 | i0 | 57.3 | 0.984 | 82 | 35 | 98.4 | 0 | 4 | 249 | 590 | 671 | DAH28747.1 MAG TPA: tail protein [Caudoviricetes sp.] | diamond | 246 | 95.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27512559 | 27512559 | PRJNA1122875_P_NODE_18723_length_386_cov_0.984026_g18499_i0 | PRJNA1122875 | 18723 | 386 | 0.984026 | 3.79834036 | Caudovirales sp. ctOwN3 | 2656725 | Viruses | Viruses | 45.4 | 0.019 | NR | QGH72153.1 | 2656725 | g18499 | i0 | 36.5 | 0.83160621761658 | 63 | 37 | 46.6 | 1 | 345 | 166 | 174 | 236 | QGH72153.1 MAG: primase [Caudovirales sp. ctOwN3] | diamond | 321 | 45.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudovirales sp. ctOwN3 | |||||
| 29248980 | 29248980 | PRJNA1122875_P_NODE_47049_length_247_cov_1.758621_g46825_i0 | PRJNA1122875 | 47049 | 247 | 1.758621 | 4.34379387 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 40 | 0.0271 | NR | DAR99514.1 | 2832643 | g46825 | i0 | 78.9 | 0.230769230769231 | 19 | 4 | 23.1 | 0 | 62 | 6 | 15 | 33 | DAR99514.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 57 | 40 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29269708 | 29269708 | PRJNA1122875_P_NODE_18389_length_389_cov_1.348101_g18165_i0 | PRJNA1122875 | 18389 | 389 | 1.348101 | 5.24411289 | Viruses | 10239 | Viruses | Viruses | 43.5 | 0.00982 | NR | BAQ85168.1 | 1407671 | g18165 | i0 | 49 | 1.12596401028278 | 49 | 23 | 37.8 | 1 | 234 | 88 | 26 | 72 | BAQ85168.1 phage terminase small subunit [uncultured Mediterranean phage uvMED] | diamond | 438 | 43.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | uncultured Mediterranean phage uvMED | |||||
| 30291692 | 30291692 | PRJNA1122875_P_NODE_11472_length_491_cov_2.511962_g11250_i0 | PRJNA1122875 | 11472 | 491 | 2.511962 | 12.33373342 | Methylophilales phage MEP4 | 3003801 | Viruses | Viruses | 72 | 4.51e-12 | NR | WBF78151.1 | 3003801 | g11250 | i0 | 36.8 | 1.40529531568228 | 133 | 69 | 72.1 | 5 | 1 | 354 | 71 | 203 | WBF78151.1 hypothetical protein MEP402_gp31 [Methylophilales phage MEP402] | diamond | 690 | 72 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zobellviridae | Methylophilales phage MEP402 | ||||
| 30480983 | 30480983 | PRJNA1122875_P_NODE_51273_length_243_cov_1.358824_g51049_i0 | PRJNA1122875 | 51273 | 243 | 1.358824 | 3.30194232 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 65.9 | 1.68e-10 | NR | CAB4196822.1 | 2100421 | g51049 | i0 | 43.8 | 3.93827160493827 | 80 | 39 | 96.3 | 3 | 7 | 240 | 175 | 250 | CAB4196822.1 TIGR02452, TIGR02452 family protein [uncultured Caudovirales phage] | diamond | 957 | 65.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch |
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);;