contig_metadata
21 rows where bioproject = "PRJNA1016321" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2710090 | 2710090 | PRJNA1016321_P_NODE_42103_length_271_cov_2.141414_g41872_i0 | PRJNA1016321 | 42103 | 271 | 2.141414 | 5.80323194 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 429 | 9.83e-116 | NTclustered | gi|2053209494|tpg|BK017127.1| | 2832643 | g41872 | i0 | 97.984 | 4.12177121771218 | 248 | 4 | 92 | 1 | 24 | 271 | 11611 | 11857 | MAG TPA_asm: Caudoviricetes sp. isolate ctfoB3, partial genome | blastn | 1117 | 429 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5262371 | 5262371 | PRJNA1016321_P_NODE_30165_length_331_cov_1.689922_g29934_i0 | PRJNA1016321 | 30165 | 331 | 1.689922 | 5.59364182 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 309 | 1.68e-79 | NTclustered | gi|2914783463|gb|OR222447.1| | 2832643 | g29934 | i0 | 91.228 | 0.688821752265861 | 228 | 18 | 69 | 2 | 89 | 315 | 50991 | 51217 | MAG: Caudoviricetes sp. isolate MSP0948 genomic sequence | blastn | 228 | 309 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5262402 | 5262402 | PRJNA1016321_P_NODE_32245_length_318_cov_1.551020_g32014_i0 | PRJNA1016321 | 32245 | 318 | 1.55102 | 4.9322436 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 313 | 1.24e-80 | NTclustered | gi|2914783463|gb|OR222447.1| | 2832643 | g32014 | i0 | 84.591 | 1 | 318 | 46 | 100 | 1 | 1 | 318 | 36409 | 36095 | MAG: Caudoviricetes sp. isolate MSP0948 genomic sequence | blastn | 318 | 313 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7812307 | 7812307 | PRJNA1016321_P_NODE_42287_length_271_cov_1.131313_g42056_i0 | PRJNA1016321 | 42287 | 271 | 1.131313 | 3.06585823 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 207 | 5.01e-49 | NTclustered | gi|2914783463|gb|OR222447.1| | 2832643 | g42056 | i0 | 80.755 | 2.4169741697417 | 265 | 51 | 98 | 0 | 7 | 271 | 38464 | 38200 | MAG: Caudoviricetes sp. isolate MSP0948 genomic sequence | blastn | 655 | 207 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10362364 | 10362364 | PRJNA1016321_P_NODE_12889_length_552_cov_2.319415_g12666_i0 | PRJNA1016321 | 12889 | 552 | 2.319415 | 12.8031708 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 346 | 2.23e-90 | NTclustered | gi|1436214368|gb|MH617486.1| | 2832643 | g12666 | i0 | 78.707 | 1.90036231884058 | 526 | 106 | 95 | 5 | 28 | 551 | 31551 | 31030 | MAG: Caudoviricetes sp. isolate ctce_1, complete genome | blastn | 1049 | 346 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10362509 | 10362509 | PRJNA1016321_P_NODE_20809_length_416_cov_3.069971_g20578_i0 | PRJNA1016321 | 20809 | 416 | 3.069971 | 12.77107936 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 438 | 2.629999999999999e-118 | NTclustered | gi|1990397921|gb|MW347459.1| | 2832643 | g20578 | i0 | 86.098 | 0.985576923076923 | 410 | 53 | 98 | 4 | 9 | 416 | 237 | 644 | MAG: Caudoviricetes sp. isolate 3nj-TERL-60 terminase large subunit gene, partial cds | blastn | 410 | 438 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11638597 | 11638597 | PRJNA1016321_P_NODE_56130_length_241_cov_0.916667_g55899_i0 | PRJNA1016321 | 56130 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 418 | 1.8599999999999995e-112 | NTclustered | gi|2914760312|gb|OR221747.1| | 2832643 | g55899 | i0 | 97.925 | 4.78423236514523 | 241 | 5 | 100 | 0 | 1 | 241 | 7332 | 7572 | MAG: Caudoviricetes sp. isolate MSP1289 genomic sequence | blastn | 1153 | 418 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12912878 | 12912878 | PRJNA1016321_P_NODE_17051_length_470_cov_2.801008_g16821_i0 | PRJNA1016321 | 17051 | 470 | 2.801008 | 13.1647376 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 830 | 0 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g16821 | i0 | 98.511 | 412.234042553192 | 470 | 7 | 100 | 0 | 1 | 470 | 17951 | 18420 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 193750 | 830 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16736147 | 16736147 | PRJNA1016321_P_NODE_14494_length_517_cov_1.029279_g14266_i0 | PRJNA1016321 | 14494 | 517 | 1.029279 | 5.32137243 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 399 | 1.5699999999999997e-106 | NTclustered | gi|2914783463|gb|OR222447.1| | 2832643 | g14266 | i0 | 82.378 | 0.911025145067698 | 471 | 71 | 90 | 10 | 45 | 509 | 42907 | 43371 | MAG: Caudoviricetes sp. isolate MSP0948 genomic sequence | blastn | 471 | 399 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18011800 | 18011800 | PRJNA1016321_P_NODE_55935_length_241_cov_1.339286_g55704_i0 | PRJNA1016321 | 55935 | 241 | 1.339286 | 3.22767926 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 169 | 2.0599999999999997e-37 | NTclustered | gi|2914783463|gb|OR222447.1| | 2832643 | g55704 | i0 | 82.653 | 0.813278008298755 | 196 | 28 | 80 | 5 | 1 | 193 | 40881 | 40689 | MAG: Caudoviricetes sp. isolate MSP0948 genomic sequence | blastn | 196 | 169 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20561179 | 20561179 | PRJNA1016321_P_NODE_56717_length_238_cov_2.490909_g56486_i0 | PRJNA1016321 | 56717 | 238 | 2.490909 | 5.92836342 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 385 | 1.86e-102 | NTclustered | gi|2057899373|tpg|BK051134.1| | 2832643 | g56486 | i0 | 95.798 | 36.3445378151261 | 238 | 10 | 100 | 0 | 1 | 238 | 7552 | 7789 | MAG TPA_asm: Caudoviricetes sp. isolate ctS2e9, partial genome | blastn | 8650 | 385 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24385771 | 24385771 | PRJNA1016321_P_NODE_4000_length_1014_cov_3.747078_g3840_i0 | PRJNA1016321 | 4000 | 1014 | 3.747078 | 37.99537092 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1821 | 0 | NTclustered | gi|2915047850|gb|OR222814.1| | 2832643 | g3840 | i0 | 99.698 | 1.73175542406312 | 995 | 3 | 98 | 0 | 20 | 1014 | 57973 | 56979 | MAG: Caudoviricetes sp. isolate MSP0542 genomic sequence | blastn | 1756 | 1821 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26749571 | 26749571 | PRJNA1016321_P_NODE_29961_length_332_cov_2.428571_g29730_i0 | PRJNA1016321 | 29961 | 332 | 2.428571 | 8.06285572 | Thermus phage phiYS4 | 407392 | Viruses | Viruses | 177 | 4.45e-49 | NR | YP_874015.1 | 407392 | g29730 | i0 | 77.3 | 0.993975903614458 | 110 | 24 | 99.4 | 1 | 2 | 331 | 743 | 851 | YP_874015.1 hypothetical protein YS40_002 [Thermus phage phiYS40] | diamond | 330 | 177 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thermus phage phiYS40 | |||||
| 27161006 | 27161006 | PRJNA1016321_P_NODE_34882_length_304_cov_1.017316_g34651_i0 | PRJNA1016321 | 34882 | 304 | 1.017316 | 3.09264064 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 174 | 7.21e-50 | NR | XOR12631.1 | 2832643 | g34651 | i0 | 81.2 | 0.996710526315789 | 101 | 19 | 99.7 | 0 | 2 | 304 | 228 | 328 | XOR12631.1 MAG: ATP-dependent DNA helicase uvsW [Caudoviricetes sp.] | diamond | 303 | 174 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27571984 | 27571984 | PRJNA1016321_P_NODE_35384_length_301_cov_1.350877_g35153_i0 | PRJNA1016321 | 35384 | 301 | 1.350877 | 4.06613977 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 135 | 2.03e-36 | NR | XOR12615.1 | 2832643 | g35153 | i0 | 61 | 0.996677740863787 | 100 | 39 | 99.7 | 0 | 2 | 301 | 35 | 134 | XOR12615.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 300 | 135 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27698661 | 27698661 | PRJNA1016321_P_NODE_49824_length_249_cov_0.875000_g49593_i0 | PRJNA1016321 | 49824 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 92 | 2.1500000000000003e-21 | NR | XOR12618.1 | 2832643 | g49593 | i0 | 56.1 | 0.987951807228916 | 82 | 36 | 98.8 | 0 | 248 | 3 | 10 | 91 | XOR12618.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 246 | 92 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29623813 | 29623813 | PRJNA1016321_P_NODE_51490_length_246_cov_3.942197_g51259_i0 | PRJNA1016321 | 51490 | 246 | 3.942197 | 9.69780462 | Brevibacillus phage Jenst | 1691954 | Viruses | Viruses | 105 | 2.32e-24 | NR | YP_009199142.1 | 1691954 | g51259 | i0 | 60.8 | 0.963414634146341 | 79 | 31 | 96.3 | 0 | 9 | 245 | 98 | 176 | YP_009199142.1 putative ribonucleotide-diphosphate reductase subunit alpha [Brevibacillus phage Jenst] | diamond | 237 | 105 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Jenstvirus | Jenstvirus jenst | ||||
| 30729942 | 30729942 | PRJNA1016321_P_NODE_53194_length_244_cov_2.070175_g52963_i0 | PRJNA1016321 | 53194 | 244 | 2.070175 | 5.051227 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 123 | 1.94e-30 | NR | XOR12644.1 | 2832643 | g52963 | i0 | 79.7 | 0.909836065573771 | 74 | 15 | 91 | 0 | 243 | 22 | 281 | 354 | XOR12644.1 MAG: putative primase [Caudoviricetes sp.] | diamond | 222 | 123 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31267213 | 31267213 | PRJNA1016321_P_NODE_31875_length_320_cov_2.202429_g31644_i0 | PRJNA1016321 | 31875 | 320 | 2.202429 | 7.0477728 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 119 | 2.5199999999999997e-30 | NR | XOR12614.1 | 2832643 | g31644 | i0 | 63.2 | 0.815625 | 87 | 32 | 81.6 | 0 | 318 | 58 | 221 | 307 | XOR12614.1 MAG: structural phage protein [Caudoviricetes sp.] | diamond | 261 | 119 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31298752 | 31298752 | PRJNA1016321_P_NODE_32655_length_315_cov_3.508264_g32424_i0 | PRJNA1016321 | 32655 | 315 | 3.508264 | 11.0510316 | Bacillus phage Stills | 1610833 | Viruses | Viruses | 78.6 | 1.03e-14 | NR | YP_009196920.1 | 1610833 | g32424 | i0 | 77.8 | 0.866666666666667 | 45 | 10 | 42.9 | 0 | 8 | 142 | 267 | 311 | YP_009196920.1 hypothetical protein CPT_Stills35 [Bacillus phage Stills] | diamond | 273 | 78.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Slashvirus | Slashvirus stills | ||||
| 32089623 | 32089623 | PRJNA1016321_P_NODE_46498_length_255_cov_1.362637_g46267_i0 | PRJNA1016321 | 46498 | 255 | 1.362637 | 3.47472435 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 92.4 | 2.77e-20 | NR | XOR12615.1 | 2832643 | g46267 | i0 | 60 | 0.882352941176471 | 75 | 29 | 88.2 | 1 | 248 | 24 | 230 | 303 | XOR12615.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 225 | 92.4 | 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);;