contig_metadata
6 rows where bioproject = "PRJNA682370" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8317316 | 8317316 | PRJNA682370_S_NODE_13687_length_194_cov_1.440252_g13075_i0 | PRJNA682370 | 13687 | 194 | 1.440252 | 2.79408888 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 353 | 4.1e-93 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g13075 | i0 | 99.485 | 1 | 194 | 1 | 100 | 0 | 1 | 194 | 41136 | 40943 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 194 | 353 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8317449 | 8317449 | PRJNA682370_S_NODE_21187_length_158_cov_1.617886_g20575_i0 | PRJNA682370 | 21187 | 158 | 1.617886 | 2.55625988 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 292 | 7.07e-75 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g20575 | i0 | 100 | 1 | 158 | 0 | 100 | 0 | 1 | 158 | 39952 | 40109 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 158 | 292 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19791177 | 19791177 | PRJNA682370_S_NODE_16376_length_177_cov_1.401408_g15764_i0 | PRJNA682370 | 16376 | 177 | 1.401408 | 2.48049216 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 272 | 1.0499999999999998e-68 | NTclustered | gi|2057009609|tpg|BK048657.1| | 2832643 | g15764 | i0 | 94.35 | 17.1751412429379 | 177 | 10 | 100 | 0 | 1 | 177 | 2673 | 2497 | MAG TPA_asm: Caudoviricetes sp. isolate ct98G4, partial genome | blastn | 3040 | 272 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21066770 | 21066770 | PRJNA682370_S_NODE_20277_length_161_cov_1.253968_g19665_i0 | PRJNA682370 | 20277 | 161 | 1.253968 | 2.01888848 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 292 | 7.24e-75 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g19665 | i0 | 99.379 | 2.93788819875776 | 161 | 1 | 100 | 0 | 1 | 161 | 28842 | 28682 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 473 | 292 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23617239 | 23617239 | PRJNA682370_S_NODE_23659_length_152_cov_1.153846_g23047_i0 | PRJNA682370 | 23659 | 152 | 1.153846 | 1.75384592 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 276 | 6.770000000000001e-70 | NTclustered | gi|2914941530|gb|OR221752.1| | 2832643 | g23047 | i0 | 99.342 | 1 | 152 | 1 | 100 | 0 | 1 | 152 | 45849 | 45698 | MAG: Caudoviricetes sp. isolate MSP1281 genomic sequence | blastn | 152 | 276 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28218876 | 28218876 | PRJNA682370_S_NODE_20246_length_161_cov_1.357143_g19634_i0 | PRJNA682370 | 20246 | 161 | 1.357143 | 2.18500023 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 73.6 | 9.69e-15 | NR | CAB4157731.1 | 2100421 | g19634 | i0 | 60.4 | 0.987577639751553 | 53 | 21 | 98.8 | 0 | 159 | 1 | 41 | 93 | CAB4157731.1 hypothetical protein UFOVP681_42 [uncultured Caudovirales phage] | diamond | 159 | 73.6 | 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);;