contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA797475" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1216828 | 1216828 | PRJNA797475_P_NODE_12301_length_304_cov_2.134199_g12202_i0 | PRJNA797475 | 12301 | 304 | 2.134199 | 6.48796496 | root | 1 | Root_unresolved | Root_unresolved | 556 | 4.919999999999999e-154 | NTclustered | gi|2057959827|tpg|BK046364.1| | 2832643 | g12202 | i0 | 99.671 | 6.99013157894737 | 304 | 1 | 100 | 0 | 1 | 304 | 17072 | 16769 | MAG TPA_asm: Caudoviricetes sp. isolate ctThn6, partial genome | blastn | 2125 | 556 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2057330 | 2057330 | PRJNA797475_P_NODE_27242_length_244_cov_1.801170_g27143_i0 | PRJNA797475 | 27242 | 244 | 1.80117 | 4.3948548 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 91.6 | 4.66e-14 | NTclustered | gi|2053002793|tpg|BK016874.1| | 2832643 | g27143 | i0 | 91.176 | 0.573770491803279 | 68 | 4 | 27 | 2 | 13 | 79 | 20656 | 20722 | MAG TPA_asm: Caudoviricetes sp. isolate ct3b510, partial genome | blastn | 140 | 91.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4609694 | 4609694 | PRJNA797475_P_NODE_19404_length_261_cov_1.324468_g19305_i0 | PRJNA797475 | 19404 | 261 | 1.324468 | 3.45686148 | Microbacterium phage Rasputia | 2762419 | Viruses | Viruses | 259 | 1.31e-64 | NTclustered | gi|1896093454|gb|MT639646.1| | 2762419 | g19305 | i0 | 84.733 | 1.86206896551724 | 262 | 36 | 100 | 4 | 1 | 261 | 10146 | 10404 | Microbacterium phage Rasputia, complete genome | blastn | 486 | 259 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rogerhendrixvirus | Microbacterium phage Rasputia | ||||
| 5884866 | 5884866 | PRJNA797475_P_NODE_16785_length_274_cov_1.532338_g16686_i0 | PRJNA797475 | 16785 | 274 | 1.532338 | 4.19860612 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 507 | 4.47e-139 | NTclustered | gi|2059879362|tpg|BK040996.1| | 2832643 | g16686 | i0 | 100 | 89.1532846715328 | 274 | 0 | 100 | 0 | 1 | 274 | 12298 | 12025 | MAG TPA_asm: Caudoviricetes sp. isolate ctGGP1, partial genome | blastn | 24428 | 507 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13970948 | 13970948 | PRJNA797475_P_NODE_4471_length_472_cov_3.077694_g4373_i0 | PRJNA797475 | 4471 | 472 | 3.077694 | 14.52671568 | root | 1 | Root_unresolved | Root_unresolved | 231 | 5.49e-56 | NTclustered | gi|2627592510|gb|OQ077661.1| | 10298 | g4373 | i0 | 90.751 | 1.46398305084746 | 173 | 16 | 37 | 0 | 1 | 173 | 158240 | 158068 | Mutant Human alphaherpesvirus 1 clone H129-Syn-G2, complete sequence | blastn | 691 | 231 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha1 | ||
| 15245379 | 15245379 | PRJNA797475_P_NODE_27812_length_244_cov_0.900585_g27713_i0 | PRJNA797475 | 27812 | 244 | 0.900585 | 2.1974274 | Viruses | 10239 | Viruses | Viruses | 377 | 3.1999999999999997e-100 | NTclustered | gi|2887273002|gb|PQ198869.1| | 3367546 | g27713 | i0 | 96.491 | 100.229508196721 | 228 | 8 | 93 | 0 | 1 | 228 | 15105 | 15332 | Cutibacterium phage CAP 7-1, complete genome | blastn | 24456 | 377 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Cutibacterium phage CAP 7-1 | |||||
| 16519834 | 16519834 | PRJNA797475_P_NODE_18593_length_265_cov_1.447917_g18494_i0 | PRJNA797475 | 18593 | 265 | 1.447917 | 3.83698005 | root | 1 | Root_unresolved | Root_unresolved | 377 | 3.5200000000000003e-100 | NTclustered | gi|2043520657|gb|MZ092003.1| | 2836077 | g18494 | i0 | 92.453 | 1012.03773584906 | 265 | 19 | 100 | 1 | 1 | 265 | 83802 | 83539 | Paenibacillus phage Pd_22F, complete genome | blastn | 268190 | 377 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Paenibacillus phage Pd_22F | |||||
| 21183903 | 21183903 | PRJNA797475_P_NODE_26657_length_245_cov_0.895349_g26558_i0 | PRJNA797475 | 26657 | 245 | 0.895349 | 2.19360505 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 420 | 5.26e-113 | NTclustered | gi|2054522050|tpg|BK047489.1| | 2832643 | g26558 | i0 | 97.551 | 39.8857142857143 | 245 | 6 | 100 | 0 | 1 | 245 | 3909 | 3665 | MAG TPA_asm: Caudoviricetes sp. isolate ct6OE4, partial genome | blastn | 9772 | 420 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22458589 | 22458589 | PRJNA797475_P_NODE_26158_length_246_cov_0.890173_g26059_i0 | PRJNA797475 | 26158 | 246 | 0.890173 | 2.18982558 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 455 | 1.4500000000000002e-123 | NTclustered | gi|2052219208|tpg|BK056481.1| | 2832643 | g26059 | i0 | 100 | 100.719512195122 | 246 | 0 | 100 | 0 | 1 | 246 | 6176 | 5931 | MAG TPA_asm: Caudoviricetes sp. isolate ctnG82, partial genome | blastn | 24777 | 455 | 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);;