contig_metadata
14 rows where bioproject = "PRJNA358049" and tax_phylum = "Uroviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1673081 | 1673081 | PRJNA358049_S_NODE_102_length_1255_cov_10.310116_g89_i0 | PRJNA358049 | 102 | 1255 | 10.310116 | 129.3919558 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1759 | 0 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g89 | i0 | 100 | 0.758565737051793 | 952 | 0 | 76 | 0 | 1 | 952 | 3081 | 4032 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 952 | 1759 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5502201 | 5502201 | PRJNA358049_S_NODE_16705_length_166_cov_2.059829_g16657_i0 | PRJNA358049 | 16705 | 166 | 2.059829 | 3.41931614 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 302 | 1.2500000000000001e-77 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g16657 | i0 | 99.398 | 1 | 166 | 1 | 100 | 0 | 1 | 166 | 1962 | 2127 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 166 | 302 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8051642 | 8051642 | PRJNA358049_S_NODE_10187_length_202_cov_1.699346_g10139_i0 | PRJNA358049 | 10187 | 202 | 1.699346 | 3.43267892 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 298 | 2.05e-76 | NTclustered | gi|2058131980|tpg|BK034131.1| | 2832643 | g10139 | i0 | 97.159 | 0.871287128712871 | 176 | 5 | 87 | 0 | 1 | 176 | 176 | 1 | MAG TPA_asm: Caudoviricetes sp. isolate ctKof4, partial genome | blastn | 176 | 298 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11877335 | 11877335 | PRJNA358049_S_NODE_2430_length_379_cov_1.672727_g2382_i0 | PRJNA358049 | 2430 | 379 | 1.672727 | 6.33963533 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 579 | 1.3399999999999999e-160 | NTclustered | gi|2057811317|tpg|BK055200.1| | 2832643 | g2382 | i0 | 94.195 | 52.6965699208443 | 379 | 22 | 100 | 0 | 1 | 379 | 2769 | 3147 | MAG TPA_asm: Caudoviricetes sp. isolate ct1CL5, partial genome | blastn | 19972 | 579 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11877346 | 11877346 | PRJNA358049_S_NODE_2750_length_358_cov_3.029126_g2702_i0 | PRJNA358049 | 2750 | 358 | 3.029126 | 10.84427108 | Clostridium phage phiCT453A | 1567012 | Viruses | Viruses | 333 | 1.0800000000000001e-86 | NTclustered | gi|971821384|ref|NC_028991.1| | 1567012 | g2702 | i0 | 91.393 | 17.608938547486 | 244 | 19 | 68 | 2 | 33 | 275 | 15762 | 15520 | Clostridium phage phiCT453A, complete genome | blastn | 6304 | 333 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Clostridium phage phiCT453A | |||||
| 14427239 | 14427239 | PRJNA358049_S_NODE_12_length_2185_cov_6.935861_g11_i0 | PRJNA358049 | 12 | 2185 | 6.935861 | 151.54856285 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 3133 | 0 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g11 | i0 | 100 | 8.23340961098398 | 1696 | 0 | 78 | 0 | 1 | 1696 | 5720 | 4025 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 17990 | 3133 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15100906 | 15100906 | PRJNA358049_S_NODE_16872_length_166_cov_1.256410_g16824_i0 | PRJNA358049 | 16872 | 166 | 1.25641 | 2.0856406 | Viruses | 10239 | Viruses | Viruses | 285 | 1.26e-72 | NTclustered | gi|2051129665|tpg|BK015520.1| | 2825502 | g16824 | i0 | 97.59 | 18.0180722891566 | 166 | 4 | 100 | 0 | 1 | 166 | 48075 | 48240 | MAG TPA_asm: Siphoviridae sp. ctRNB7, partial genome | blastn | 2991 | 285 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctRNB7 | |||||
| 15701250 | 15701250 | PRJNA358049_S_NODE_17073_length_165_cov_2.698276_g17025_i0 | PRJNA358049 | 17073 | 165 | 2.698276 | 4.4521554 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 281 | 1.62e-71 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g17025 | i0 | 100 | 9.23636363636364 | 152 | 0 | 92 | 0 | 1 | 152 | 5891 | 5740 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 1524 | 281 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15701408 | 15701408 | PRJNA358049_S_NODE_5433_length_262_cov_1.516432_g5385_i0 | PRJNA358049 | 5433 | 262 | 1.516432 | 3.97305184 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 484 | 1.99e-132 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g5385 | i0 | 100 | 5.95801526717557 | 262 | 0 | 100 | 0 | 1 | 262 | 1738 | 1477 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 1561 | 484 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18250220 | 18250220 | PRJNA358049_S_NODE_16375_length_167_cov_1.728814_g16327_i0 | PRJNA358049 | 16375 | 167 | 1.728814 | 2.88711938 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 303 | 3.5e-78 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g16327 | i0 | 99.401 | 295.137724550898 | 167 | 1 | 100 | 0 | 1 | 167 | 18136 | 18302 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 49288 | 303 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18250453 | 18250453 | PRJNA358049_S_NODE_75_length_1377_cov_17.953313_g64_i0 | PRJNA358049 | 75 | 1377 | 17.953313 | 247.21712001 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1954 | 0 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g64 | i0 | 100 | 7.10167029774873 | 1058 | 0 | 100 | 0 | 20 | 1077 | 6717 | 7774 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 9779 | 1954 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19524392 | 19524392 | PRJNA358049_S_NODE_1656_length_451_cov_2.783582_g1611_i0 | PRJNA358049 | 1656 | 451 | 2.783582 | 12.55395482 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 828 | 0 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g1611 | i0 | 99.779 | 1.66740576496674 | 452 | 0 | 100 | 1 | 1 | 451 | 6109 | 6560 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 752 | 828 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22075273 | 22075273 | PRJNA358049_S_NODE_4598_length_281_cov_3.887931_g4550_i0 | PRJNA358049 | 4598 | 281 | 3.887931 | 10.92508611 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 477 | 3.6099999999999986e-130 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g4550 | i0 | 100 | 0.918149466192171 | 258 | 0 | 92 | 0 | 1 | 258 | 895 | 638 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 258 | 477 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24624901 | 24624901 | PRJNA358049_S_NODE_2780_length_356_cov_13.485342_g2732_i0 | PRJNA358049 | 2780 | 356 | 13.485342 | 48.00781752 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 658 | 0 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g2732 | i0 | 100 | 11.2415730337079 | 356 | 0 | 100 | 0 | 1 | 356 | 645 | 290 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 4002 | 658 | 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);;