contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA881257" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5961808 | 5961808 | PRJNA881257_P_NODE_14365_length_169_cov_0.866667_g14120_i0 | PRJNA881257 | 14365 | 169 | 0.866667 | 1.46466723 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 302 | 1.27e-77 | NTclustered | gi|2914929825|gb|OR221561.1| | 2832643 | g14120 | i0 | 98.817 | 2 | 169 | 2 | 100 | 0 | 1 | 169 | 44501 | 44333 | MAG: Caudoviricetes sp. isolate MSP1509 genomic sequence | blastn | 338 | 302 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9786437 | 9786437 | PRJNA881257_P_NODE_12788_length_180_cov_1.259542_g12543_i0 | PRJNA881257 | 12788 | 180 | 1.259542 | 2.2671756 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 289 | 1.07e-73 | NTclustered | gi|2058017641|tpg|BK041878.1| | 2832643 | g12543 | i0 | 95.556 | 12.9888888888889 | 180 | 8 | 100 | 0 | 1 | 180 | 20863 | 20684 | MAG TPA_asm: Caudoviricetes sp. isolate ctc2P18, partial genome | blastn | 2338 | 289 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12337716 | 12337716 | PRJNA881257_P_NODE_17630_length_163_cov_0.912281_g17385_i0 | PRJNA881257 | 17630 | 163 | 0.912281 | 1.48701803 | Skunavirus Lj | 2845456 | Viruses | Viruses | 246 | 5.8099999999999995e-61 | NTclustered | gi|1864370029|ref|NC_049369.1| | 1636583 | g17385 | i0 | 93.865 | 94.9325153374233 | 163 | 10 | 100 | 0 | 1 | 163 | 12649 | 12811 | Lactococcus phage 936 group phage PhiLj, complete genome | blastn | 15474 | 246 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Skunavirus | Skunavirus Lj | ||||
| 15268583 | 15268583 | PRJNA881257_P_NODE_14352_length_169_cov_0.866667_g14107_i0 | PRJNA881257 | 14352 | 169 | 0.866667 | 1.46466723 | Tequatrovirus | 10663 | Viruses | Viruses | 313 | 5.859999999999999e-81 | NTclustered | gi|2721715921|emb|OZ035787.1| | 10665 | g14107 | i0 | 100 | 100 | 169 | 0 | 100 | 0 | 1 | 169 | 40734 | 40902 | Tequatrovirus T4 genome assembly, chromosome: 1 | blastn | 16900 | 313 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Tequatrovirus | Tequatrovirus T4 | ||
| 23810795 | 23810795 | PRJNA881257_P_NODE_15259_length_167_cov_0.881356_g15014_i0 | PRJNA881257 | 15259 | 167 | 0.881356 | 1.47186452 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 287 | 3.53e-73 | NTclustered | gi|2053078945|tpg|BK020046.1| | 2832643 | g15014 | i0 | 97.605 | 1 | 167 | 4 | 100 | 0 | 1 | 167 | 4840 | 4674 | MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome | blastn | 167 | 287 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 25084648 | 25084648 | PRJNA881257_P_NODE_16560_length_165_cov_0.896552_g16315_i0 | PRJNA881257 | 16560 | 165 | 0.896552 | 1.4793108 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 300 | 4.46e-77 | NTclustered | gi|2058141179|tpg|BK034303.1| | 2832643 | g16315 | i0 | 99.394 | 4.01818181818182 | 165 | 1 | 100 | 0 | 1 | 165 | 30912 | 31076 | MAG TPA_asm: Caudoviricetes sp. isolate ctKX34, partial genome | blastn | 663 | 300 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 25084668 | 25084668 | PRJNA881257_P_NODE_18120_length_162_cov_0.920354_g17875_i0 | PRJNA881257 | 18120 | 162 | 0.920354 | 1.49097348 | Andhravirus sealphi | 3059730 | Viruses | Viruses | 185 | 1.2699999999999999e-42 | NTclustered | gi|2438087507|ref|NC_070880.1| | 2835941 | g17875 | i0 | 88.312 | 7.4382716049382704 | 154 | 18 | 95 | 0 | 1 | 154 | 9916 | 10069 | Staphylococcus phage SeAlphi, complete genome | blastn | 1205 | 185 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rountreeviridae | Andhravirus | Andhravirus sealphi |
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);;