contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1066877" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4006844 | 4006844 | PRJNA1066877_S_NODE_5584_length_219_cov_0.870588_g5549_i0 | PRJNA1066877 | 5584 | 219 | 0.870588 | 1.90658772 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 322 | 1.34e-83 | NTclustered | gi|2059625654|tpg|BK028308.1| | 2832643 | g5549 | i0 | 93.151 | 1 | 219 | 15 | 100 | 0 | 1 | 219 | 118472 | 118254 | MAG TPA_asm: Caudoviricetes sp. isolate ct2xv2, partial genome | blastn | 219 | 322 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4840959 | 4840959 | PRJNA1066877_S_NODE_12124_length_164_cov_0.913043_g12089_i0 | PRJNA1066877 | 12124 | 164 | 0.913043 | 1.49739052 | Aliceevansviridae | 3044455 | Viruses | Viruses | 281 | 1.6000000000000001e-71 | NTclustered | gi|2437983729|ref|NC_070651.1| | 1718281 | g12089 | i0 | 97.561 | 97.0609756097561 | 164 | 4 | 100 | 0 | 1 | 164 | 27056 | 27219 | Streptococcus phage 128, complete genome | blastn | 15918 | 281 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aliceevansviridae | Moineauvirus | Moineauvirus mv128 | |||
| 5283294 | 5283294 | PRJNA1066877_S_NODE_8745_length_186_cov_1.313869_g8710_i0 | PRJNA1066877 | 8745 | 186 | 1.313869 | 2.44379634 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 283 | 5.179999999999999e-72 | NTclustered | gi|2059625654|tpg|BK028308.1| | 2832643 | g8710 | i0 | 94.086 | 1 | 186 | 11 | 100 | 0 | 1 | 186 | 118066 | 118251 | MAG TPA_asm: Caudoviricetes sp. isolate ct2xv2, partial genome | blastn | 186 | 283 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7390603 | 7390603 | PRJNA1066877_S_NODE_11406_length_167_cov_0.864407_g11371_i0 | PRJNA1066877 | 11406 | 167 | 0.864407 | 1.44355969 | Pahexavirus | 1982251 | Viruses | Viruses | 298 | 1.63e-76 | NTclustered | gi|1336448649|gb|MG820645.1| | 2079404 | g11371 | i0 | 98.802 | 99.3053892215569 | 167 | 2 | 100 | 0 | 1 | 167 | 11741 | 11907 | Propionibacterium phage pa3-SS3, complete genome | blastn | 16584 | 298 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage pa3-SS3 | ||||
| 11659028 | 11659028 | PRJNA1066877_S_NODE_7330_length_198_cov_1.919463_g7295_i0 | PRJNA1066877 | 7330 | 198 | 1.919463 | 3.80053674 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 316 | 5.51e-82 | NTclustered | gi|2059625654|tpg|BK028308.1| | 2832643 | g7295 | i0 | 95.477 | 1.0050505050505 | 199 | 8 | 100 | 1 | 1 | 198 | 131286 | 131088 | MAG TPA_asm: Caudoviricetes sp. isolate ct2xv2, partial genome | blastn | 199 | 316 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16757392 | 16757392 | PRJNA1066877_S_NODE_934_length_438_cov_1.357326_g899_i0 | PRJNA1066877 | 934 | 438 | 1.357326 | 5.94508788 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 809 | 0 | NTclustered | gi|2057978434|tpg|BK046703.1| | 2832643 | g899 | i0 | 100 | 1 | 438 | 0 | 100 | 0 | 1 | 438 | 10075 | 9638 | MAG TPA_asm: Caudoviricetes sp. isolate ctLaR6, partial genome | blastn | 438 | 809 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19305962 | 19305962 | PRJNA1066877_S_NODE_12356_length_163_cov_1.210526_g12321_i0 | PRJNA1066877 | 12356 | 163 | 1.210526 | 1.97315738 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 219 | 1.2699999999999999e-52 | NTclustered | gi|2059625654|tpg|BK028308.1| | 2832643 | g12321 | i0 | 90.798 | 1 | 163 | 15 | 100 | 0 | 1 | 163 | 77825 | 77987 | MAG TPA_asm: Caudoviricetes sp. isolate ct2xv2, partial genome | blastn | 163 | 219 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21857109 | 21857109 | PRJNA1066877_S_NODE_10998_length_169_cov_1.275000_g10963_i0 | PRJNA1066877 | 10998 | 169 | 1.275 | 2.15475 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 307 | 2.73e-79 | NTclustered | gi|2914754492|gb|OR221467.1| | 2832643 | g10963 | i0 | 99.408 | 2.6094674556213 | 169 | 1 | 100 | 0 | 1 | 169 | 15003 | 15171 | MAG: Caudoviricetes sp. isolate MSP1619 genomic sequence | blastn | 441 | 307 | 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);;