contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA674048" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5746621 | 5746621 | PRJNA674048_P_NODE_29085_length_166_cov_1.777778_g28882_i0 | PRJNA674048 | 29085 | 166 | 1.777778 | 2.95111148 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 305 | 9.67e-79 | NTclustered | gi|2914923246|gb|OR221428.1| | 2832643 | g28882 | i0 | 100 | 0.993975903614458 | 165 | 0 | 99 | 0 | 2 | 166 | 26063 | 25899 | MAG: Caudoviricetes sp. isolate MSP1664 genomic sequence | blastn | 165 | 305 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7021639 | 7021639 | PRJNA674048_P_NODE_11146_length_279_cov_1.356522_g10943_i0 | PRJNA674048 | 11146 | 279 | 1.356522 | 3.78469638 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 499 | 7.63e-137 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g10943 | i0 | 98.929 | 299.982078853047 | 280 | 2 | 100 | 1 | 1 | 279 | 18036 | 18315 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 83695 | 499 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8296405 | 8296405 | PRJNA674048_P_NODE_23627_length_181_cov_1.416667_g23424_i0 | PRJNA674048 | 23627 | 181 | 1.416667 | 2.56416727 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 270 | 3.899999999999999e-68 | NTclustered | gi|2914801975|gb|OR221226.1| | 2832643 | g23424 | i0 | 93.855 | 0.988950276243094 | 179 | 11 | 99 | 0 | 1 | 179 | 24330 | 24508 | MAG: Caudoviricetes sp. isolate MSP1897 genomic sequence | blastn | 179 | 270 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8819103 | 8819103 | PRJNA674048_P_NODE_25947_length_172_cov_1.691057_g25744_i0 | PRJNA674048 | 25947 | 172 | 1.691057 | 2.90861804 | Pahexavirus | 1982251 | Viruses | Viruses | 307 | 2.79e-79 | NTclustered | gi|1269173928|gb|MF919533.1| | 2041563 | g25744 | i0 | 98.837 | 99.9825581395349 | 172 | 2 | 100 | 0 | 1 | 172 | 18067 | 18238 | Propionibacterium phage Supernova, complete genome | blastn | 17197 | 307 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage Supernova | ||||
| 10094766 | 10094766 | PRJNA674048_P_NODE_31408_length_163_cov_1.824561_g31205_i0 | PRJNA674048 | 31408 | 163 | 1.824561 | 2.97403443 | Andhravirus | 2732589 | Viruses | Viruses | 302 | 1.22e-77 | NTclustered | gi|2154937499|gb|OK574338.1| | 2894773 | g31205 | i0 | 100 | 11.9141104294479 | 163 | 0 | 100 | 0 | 1 | 163 | 10431 | 10593 | Staphylococcus phage vB_SurP-PSU3, complete genome | blastn | 1942 | 302 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rountreeviridae | Andhravirus | Staphylococcus phage vB_SurP-PSU3 | |||
| 16468935 | 16468935 | PRJNA674048_P_NODE_27693_length_168_cov_0.873950_g27490_i0 | PRJNA674048 | 27693 | 168 | 0.87395 | 1.468236 | Pahexavirus | 1982251 | Viruses | Viruses | 261 | 2.15e-65 | NTclustered | gi|408905834|ref|NC_018839.1| | 1229784 | g27490 | i0 | 94.643 | 99.1428571428571 | 168 | 9 | 100 | 0 | 1 | 168 | 877 | 1044 | Propionibacterium phage P14.4, complete genome | blastn | 16656 | 263 | 0.992395437262357 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus P144 | ||||
| 17221160 | 17221160 | PRJNA674048_P_NODE_26734_length_169_cov_2.058333_g26531_i0 | PRJNA674048 | 26734 | 169 | 2.058333 | 3.47858277 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 274 | 2.7699999999999997e-69 | NTclustered | gi|2914801975|gb|OR221226.1| | 2832643 | g26531 | i0 | 95.858 | 1 | 169 | 7 | 100 | 0 | 1 | 169 | 10843 | 10675 | MAG: Caudoviricetes sp. isolate MSP1897 genomic sequence | blastn | 169 | 274 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21045665 | 21045665 | PRJNA674048_P_NODE_24877_length_176_cov_1.637795_g24674_i0 | PRJNA674048 | 24877 | 176 | 1.637795 | 2.8825192 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 281 | 1.74e-71 | NTclustered | gi|2052959616|tpg|BK030187.1| | 2832643 | g24674 | i0 | 95.455 | 3.25 | 176 | 8 | 100 | 0 | 1 | 176 | 7623 | 7448 | MAG TPA_asm: Caudoviricetes sp. isolate ctKvY4, partial genome | blastn | 572 | 281 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21045687 | 21045687 | PRJNA674048_P_NODE_28497_length_167_cov_0.881356_g28294_i0 | PRJNA674048 | 28497 | 167 | 0.881356 | 1.47186452 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 303 | 3.5e-78 | NTclustered | gi|2914991939|gb|OR222195.1| | 2832643 | g28294 | i0 | 99.401 | 99.934131736527 | 167 | 1 | 100 | 0 | 1 | 167 | 44304 | 44470 | MAG: Caudoviricetes sp. isolate MSP0785 genomic sequence | blastn | 16689 | 303 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23595926 | 23595926 | PRJNA674048_P_NODE_20939_length_192_cov_1.916084_g20736_i0 | PRJNA674048 | 20939 | 192 | 1.916084 | 3.67888128 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 209 | 9.27e-50 | NTclustered | gi|2056991258|tpg|BK023538.1| | 2832643 | g20736 | i0 | 88.136 | 9.15625 | 177 | 20 | 92 | 1 | 1 | 176 | 1710 | 1886 | MAG TPA_asm: Caudoviricetes sp. isolate ctWA52, partial genome | blastn | 1758 | 209 | 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);;