contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJEB49404" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3541449 | 3541449 | PRJEB49404_P_NODE_305003_length_261_cov_0.878378_g291202_i0 | PRJEB49404 | 305003 | 261 | 0.878378 | 2.29256658 | Pahexavirus | 1982251 | Viruses | Viruses | 422 | 1.57e-113 | NTclustered | gi|1338076736|gb|MG820636.1| | 2079403 | g291202 | i0 | 95.785 | 99.9310344827586 | 261 | 11 | 100 | 0 | 1 | 261 | 9558 | 9818 | Propionibacterium phage pa29399-1-D_2, complete genome | blastn | 26082 | 422 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage pa29399-1-D_2 | ||||
| 3541642 | 3541642 | PRJEB49404_P_NODE_591323_length_161_cov_1.344262_g577522_i0 | PRJEB49404 | 591323 | 161 | 1.344262 | 2.16426182 | Pahexavirus | 1982251 | Viruses | Viruses | 283 | 4.3599999999999995e-72 | NTclustered | gi|330858398|ref|NC_015454.1| | 504501 | g577522 | i0 | 98.742 | 99.4782608695652 | 159 | 2 | 99 | 0 | 1 | 159 | 13182 | 13024 | Propionibacterium phage PAD20 endogenous virus, complete genome | blastn | 16016 | 283 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PAD20 | ||||
| 9028225 | 9028225 | PRJEB49404_P_NODE_298168_length_265_cov_1.632743_g284367_i0 | PRJEB49404 | 298168 | 265 | 1.632743 | 4.32676895 | Pijolavirus Pf17397FPD1 | 3431676 | Viruses | Viruses | 390 | 4.519999999999999e-104 | NTclustered | gi|2190146233|gb|OM131411.1| | 2914026 | g284367 | i0 | 93.258 | 2.86037735849057 | 267 | 14 | 100 | 3 | 1 | 265 | 15808 | 16072 | Pseudomonas phage Pf17397_F_PD1, complete genome | blastn | 758 | 390 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autotranscriptaviridae | Pijolavirus | Pijolavirus Pf17397FPD1 | ||
| 11194300 | 11194300 | PRJEB49404_P_NODE_311489_length_257_cov_1.128440_g297688_i0 | PRJEB49404 | 311489 | 257 | 1.12844 | 2.9000908 | Aliceevansviridae | 3044455 | Viruses | Viruses | 464 | 2.5299999999999998e-126 | NTclustered | gi|2437984287|ref|NC_070663.1| | 2365018 | g297688 | i0 | 99.225 | 101.019455252918 | 258 | 1 | 100 | 1 | 1 | 257 | 20848 | 21105 | Streptococcus phage CHPC1046, complete genome | blastn | 25962 | 464 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aliceevansviridae | Moineauvirus | Moineauvirus CHPC1046 | |||
| 11573564 | 11573564 | PRJEB49404_P_NODE_174290_length_388_cov_1.893983_g160497_i0 | PRJEB49404 | 174290 | 388 | 1.893983 | 7.3486540400000004 | Escherichia phage a48 | 3017792 | Viruses | Viruses | 279 | 1.56e-70 | NTclustered | gi|2419110972|gb|OQ067375.1| | 3017792 | g160497 | i0 | 79.744 | 100.376288659794 | 390 | 75 | 100 | 4 | 1 | 388 | 30693 | 31080 | Escherichia phage a48, complete genome | blastn | 38946 | 279 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Tequatrovirus | Escherichia phage a48 | ||
| 14142442 | 14142442 | PRJEB49404_P_NODE_570452_length_165_cov_1.801587_g556651_i0 | PRJEB49404 | 570452 | 165 | 1.801587 | 2.97261855 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 305 | 9.59e-79 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g556651 | i0 | 100 | 223.927272727273 | 165 | 0 | 100 | 0 | 1 | 165 | 18168 | 18332 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 36948 | 305 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17960591 | 17960591 | PRJEB49404_P_NODE_465475_length_191_cov_2.618421_g451674_i0 | PRJEB49404 | 465475 | 191 | 2.618421 | 5.00118411 | Cutibacterium phage CaCom2 | 3053652 | Viruses | Viruses | 329 | 6.78e-86 | NTclustered | gi|2523356271|gb|OR088869.1| | 3053652 | g451674 | i0 | 97.895 | 99.2513089005236 | 190 | 4 | 99 | 0 | 2 | 191 | 12677 | 12866 | Cutibacterium phage CaCom2, complete genome | blastn | 18957 | 329 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Cutibacterium phage CaCom2 | ||||
| 25217314 | 25217314 | PRJEB49404_P_NODE_653200_length_150_cov_1.108108_g639399_i0 | PRJEB49404 | 653200 | 150 | 1.108108 | 1.662162 | Tequatrovirus | 10663 | Viruses | Viruses | 278 | 1.85e-70 | NTclustered | gi|2721715921|emb|OZ035787.1| | 10665 | g639399 | i0 | 100 | 99.6933333333333 | 150 | 0 | 100 | 0 | 1 | 150 | 38207 | 38356 | Tequatrovirus T4 genome assembly, chromosome: 1 | blastn | 14954 | 278 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Tequatrovirus | Tequatrovirus T4 |
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);;