contig_metadata
19 rows where bioproject = "PRJNA983838" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 964803 | 964803 | PRJNA983838_P_NODE_117461_length_243_cov_0.917647_g115094_i0 | PRJNA983838 | 117461 | 243 | 0.917647 | 2.22988221 | Cutibacterium phage vB_CacS-HV1 | 3236917 | Viruses | Viruses | 388 | 1.47e-103 | NTclustered | gi|2780182484|gb|PQ037195.1| | 3236917 | g115094 | i0 | 95.473 | 99.843621399177 | 243 | 11 | 100 | 0 | 1 | 243 | 5830 | 6072 | Cutibacterium phage vB_CacS-HV1, complete genome | blastn | 24262 | 388 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Cutibacterium phage vB_CacS-HV1 | ||||
| 965678 | 965678 | PRJNA983838_P_NODE_78601_length_304_cov_1.350649_g76234_i0 | PRJNA983838 | 78601 | 304 | 1.350649 | 4.10597296 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 562 | 1.06e-155 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g76234 | i0 | 100 | 1.22368421052632 | 304 | 0 | 100 | 0 | 1 | 304 | 49362 | 49059 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 372 | 562 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7342566 | 7342566 | PRJNA983838_P_NODE_115606_length_244_cov_1.543860_g113239_i0 | PRJNA983838 | 115606 | 244 | 1.54386 | 3.7670184 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 451 | 1.86e-122 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g113239 | i0 | 100 | 1.89754098360656 | 244 | 0 | 100 | 0 | 1 | 244 | 42777 | 42534 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 463 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7343517 | 7343517 | PRJNA983838_P_NODE_78206_length_305_cov_1.581897_g75839_i0 | PRJNA983838 | 78206 | 305 | 1.581897 | 4.82478585 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 564 | 2.95e-156 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g75839 | i0 | 100 | 1 | 305 | 0 | 100 | 0 | 1 | 305 | 42023 | 42327 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 305 | 564 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13718269 | 13718269 | PRJNA983838_P_NODE_108131_length_250_cov_0.881356_g105764_i0 | PRJNA983838 | 108131 | 250 | 0.881356 | 2.20339 | Podoviridae sp. ctbh1 | 2675446 | Viruses | Viruses | 313 | 9.41e-81 | NTclustered | gi|1407520932|gb|MH511048.1| | 2675446 | g105764 | i0 | 89.243 | 1.004 | 251 | 25 | 99 | 1 | 1 | 249 | 26940 | 26690 | MAG: Podoviridae sp. ctbh1, complete genome | blastn | 251 | 313 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Podoviridae sp. ctbh1 | |||||
| 14992779 | 14992779 | PRJNA983838_P_NODE_118932_length_242_cov_0.923077_g116565_i0 | PRJNA983838 | 118932 | 242 | 0.923077 | 2.23384634 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 370 | 5.3e-98 | NTclustered | gi|2914951202|gb|OR221908.1| | 2832643 | g116565 | i0 | 94.215 | 14.8801652892562 | 242 | 14 | 100 | 0 | 1 | 242 | 37783 | 37542 | MAG: Caudoviricetes sp. isolate MSP1097 genomic sequence | blastn | 3601 | 370 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14993852 | 14993852 | PRJNA983838_P_NODE_88232_length_281_cov_2.115385_g85865_i0 | PRJNA983838 | 88232 | 281 | 2.115385 | 5.94423185 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 520 | 5.909999999999999e-143 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g85865 | i0 | 100 | 1 | 281 | 0 | 100 | 0 | 1 | 281 | 47373 | 47093 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 281 | 520 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17542724 | 17542724 | PRJNA983838_P_NODE_118514_length_242_cov_0.923077_g116147_i0 | PRJNA983838 | 118514 | 242 | 0.923077 | 2.23384634 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 418 | 1.8699999999999998e-112 | NTclustered | gi|2056737341|tpg|BK045029.1| | 2832643 | g116147 | i0 | 97.925 | 7.16942148760331 | 241 | 5 | 99 | 0 | 2 | 242 | 34012 | 34252 | MAG TPA_asm: Caudoviricetes sp. isolate ctqcb9, partial genome | blastn | 1735 | 418 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18816647 | 18816647 | PRJNA983838_P_NODE_124195_length_208_cov_4.111111_g121827_i0 | PRJNA983838 | 124195 | 208 | 4.111111 | 8.55111088 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 385 | 1.58e-102 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g121827 | i0 | 100 | 1 | 208 | 0 | 100 | 0 | 1 | 208 | 23160 | 22953 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 208 | 385 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18817630 | 18817630 | PRJNA983838_P_NODE_88875_length_280_cov_1.507246_g86508_i0 | PRJNA983838 | 88875 | 280 | 1.507246 | 4.2202888 | Erythrobacter phage vB_EliS-L02 | 2909139 | Viruses | Viruses | 202 | 2.42e-47 | NTclustered | gi|2177198975|gb|OL955261.1| | 2909139 | g86508 | i0 | 79.859 | 2.66071428571429 | 283 | 51 | 100 | 6 | 1 | 280 | 56458 | 56737 | Erythrobacter phage vB_EliS-L02, complete genome | blastn | 745 | 202 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Erythrobacter phage vB_EliS-L02 | |||||
| 27247563 | 27247563 | PRJNA983838_P_NODE_60083_length_371_cov_1.916107_g57716_i0 | PRJNA983838 | 60083 | 371 | 1.916107 | 7.10875697 | Burkholderia phage BCSR5 | 2805747 | Viruses | Viruses | 61.6 | 4.06e-8 | NR | QRE00266.1 | 2805747 | g57716 | i0 | 33.6 | 0.865229110512129 | 107 | 59 | 80.9 | 2 | 65 | 364 | 1166 | 1267 | QRE00266.1 hypothetical protein [Burkholderia phage BCSR5] | diamond | 321 | 61.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Burkholderia phage BCSR5 | |||||
| 28005723 | 28005723 | PRJNA983838_P_NODE_94345_length_269_cov_3.494898_g91978_i0 | PRJNA983838 | 94345 | 269 | 3.494898 | 9.40127562 | Burkholderia phage BCSR5 | 2805747 | Viruses | Viruses | 50.4 | 6.97e-5 | NR | QRE00125.1 | 2805747 | g91978 | i0 | 48.1 | 0.602230483271376 | 54 | 23 | 55.8 | 2 | 151 | 2 | 8 | 60 | QRE00125.1 hypothetical protein [Burkholderia phage BCSR5] | diamond | 162 | 50.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Burkholderia phage BCSR5 | |||||
| 28226239 | 28226239 | PRJNA983838_P_NODE_96306_length_266_cov_1.616580_g93939_i0 | PRJNA983838 | 96306 | 266 | 1.61658 | 4.3001028 | Burkholderia phage BcepSaruman | 2530032 | Viruses | Viruses | 105 | 3.16e-24 | NR | YP_009904021.1 | 2530032 | g93939 | i0 | 54.5 | 0.992481203007519 | 88 | 40 | 99.2 | 0 | 264 | 1 | 609 | 696 | YP_009904021.1 DNA helicase [Burkholderia phage BcepSaruman] | diamond | 264 | 105 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarumanvirus | Sarumanvirus bcepsaruman | ||||
| 28352751 | 28352751 | PRJNA983838_P_NODE_44106_length_479_cov_1.152709_g41740_i0 | PRJNA983838 | 44106 | 479 | 1.152709 | 5.52147611 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 99.4 | 4.34e-22 | NR | DAY69243.1 | 2832643 | g41740 | i0 | 32.9 | 0.989561586638831 | 158 | 99 | 97.1 | 3 | 2 | 466 | 103 | 256 | DAY69243.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 474 | 99.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28668697 | 28668697 | PRJNA983838_P_NODE_75547_length_313_cov_1.300000_g73180_i0 | PRJNA983838 | 75547 | 313 | 1.3 | 4.069 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 112 | 1.83e-26 | NR | DAH47890.1 | 2832643 | g73180 | i0 | 48.1 | 0.996805111821086 | 104 | 49 | 99.7 | 2 | 2 | 313 | 331 | 429 | DAH47890.1 MAG TPA: Protein recA [Caudoviricetes sp.] | diamond | 312 | 112 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28763163 | 28763163 | PRJNA983838_P_NODE_63847_length_354_cov_3.996441_g61480_i0 | PRJNA983838 | 63847 | 354 | 3.996441 | 14.14740114 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 43.5 | 0.0421 | NR | DAH47995.1 | 2832643 | g61480 | i0 | 21.7 | 0.703389830508475 | 83 | 65 | 70.3 | 0 | 354 | 106 | 36 | 118 | DAH47995.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 249 | 43.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31163502 | 31163502 | PRJNA983838_P_NODE_39055_length_530_cov_2.179431_g36695_i0 | PRJNA983838 | 39055 | 530 | 2.179431 | 11.5509843 | Ralstonia phage phiRSL1 | 1980924 | Viruses | Viruses | 80.5 | 4.96e-14 | NR | YP_001950009.1 | 1980924 | g36695 | i0 | 38.8 | 0.583018867924528 | 103 | 62 | 58.3 | 1 | 214 | 522 | 256 | 357 | YP_001950009.1 ATPase [Ralstonia phage phiRSL1] | diamond | 309 | 80.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Mieseafarmvirus | Mieseafarmvirus RSL1 | ||||
| 31827784 | 31827784 | PRJNA983838_P_NODE_73777_length_318_cov_2.179592_g71410_i0 | PRJNA983838 | 73777 | 318 | 2.179592 | 6.93110256 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 50.1 | 1.76e-4 | NR | DAP34417.1 | 2832643 | g71410 | i0 | 33 | 0.858490566037736 | 91 | 48 | 80.2 | 3 | 39 | 293 | 156 | 239 | DAP34417.1 MAG TPA: DnaJ domain protein [Caudoviricetes sp.] | diamond | 273 | 50.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32397622 | 32397622 | PRJNA983838_P_NODE_119639_length_240_cov_2.814371_g117272_i0 | PRJNA983838 | 119639 | 240 | 2.814371 | 6.7544904 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.4 | 1.46e-5 | NR | DAH47901.1 | 2832643 | g117272 | i0 | 54 | 3.075 | 50 | 22 | 61.3 | 1 | 94 | 240 | 541 | 590 | DAH47901.1 MAG TPA: DNA ligase [Caudoviricetes sp.] | diamond | 738 | 52.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);;