contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA846486" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 833288 | 833288 | PRJNA846486_P_NODE_46501_length_203_cov_1.922078_g46405_i0 | PRJNA846486 | 46501 | 203 | 1.922078 | 3.90181834 | Siphoviridae sp. ctHip2 | 2827830 | Viruses | Viruses | 276 | 9.64e-70 | NTclustered | gi|2052861377|tpg|BK032497.1| | 2827830 | g46405 | i0 | 91.133 | 1.90147783251232 | 203 | 18 | 100 | 0 | 1 | 203 | 280078 | 279876 | MAG TPA_asm: Siphoviridae sp. ctHip2, partial genome | blastn | 386 | 276 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctHip2 | |||||
| 3783312 | 3783312 | PRJNA846486_P_NODE_76583_length_169_cov_0.866667_g76487_i0 | PRJNA846486 | 76583 | 169 | 0.866667 | 1.46466723 | Viruses | 10239 | Viruses | Viruses | 52.8 | 0.014 | NTclustered | gi|593775691|ref|NC_023703.1| | 1089121 | g76487 | i0 | 100 | 1.32544378698225 | 28 | 0 | 17 | 0 | 115 | 142 | 54235 | 54262 | Mycobacterium phage Dori, complete genome | blastn | 224 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Mycobacterium phage Dori | |||||
| 11036904 | 11036904 | PRJNA846486_P_NODE_25069_length_260_cov_1.175355_g24973_i0 | PRJNA846486 | 25069 | 260 | 1.175355 | 3.055923 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 315 | 2.7399999999999992e-81 | NTclustered | gi|2914915209|gb|OR221265.1| | 2832643 | g24973 | i0 | 88.462 | 1 | 260 | 30 | 100 | 0 | 1 | 260 | 14321 | 14580 | MAG: Caudoviricetes sp. isolate MSP1851 genomic sequence | blastn | 260 | 315 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16135935 | 16135935 | PRJNA846486_P_NODE_39713_length_216_cov_1.245509_g39617_i0 | PRJNA846486 | 39713 | 216 | 1.245509 | 2.69029944 | EBPR siphovirus 2 | 1048521 | Viruses | Viruses | 100 | 6.71e-17 | NTclustered | gi|337731200|gb|JF412297.1| | 1048521 | g39617 | i0 | 82.906 | 0.541666666666667 | 117 | 15 | 54 | 4 | 76 | 191 | 46401 | 46289 | EBPR siphovirus 2, partial sequence | blastn | 117 | 100 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | EBPR siphovirus 2 | |||||
| 16135989 | 16135989 | PRJNA846486_P_NODE_67013_length_177_cov_1.625000_g66917_i0 | PRJNA846486 | 67013 | 177 | 1.625 | 2.87625 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 206 | 1.08e-48 | NTclustered | gi|2488203061|emb|OX382667.1| | 2100421 | g66917 | i0 | 93.571 | 15.9661016949153 | 140 | 6 | 78 | 3 | 1 | 138 | 2317 | 2179 | MAG: uncultured Caudovirales phage genome assembly, chromosome: HRS-ES12-C324 | blastn | 2826 | 206 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 17411513 | 17411513 | PRJNA846486_P_NODE_79494_length_168_cov_0.873950_g79398_i0 | PRJNA846486 | 79494 | 168 | 0.87395 | 1.468236 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.014 | NTclustered | gi|2053031715|tpg|BK024073.1| | 2832643 | g79398 | i0 | 100 | 0.166666666666667 | 28 | 0 | 17 | 0 | 13 | 40 | 11638 | 11611 | MAG TPA_asm: Caudoviricetes sp. isolate ctof750, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17411550 | 17411550 | PRJNA846486_P_NODE_91754_length_163_cov_0.912281_g91658_i0 | PRJNA846486 | 91754 | 163 | 0.912281 | 1.48701803 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 302 | 1.22e-77 | NTclustered | gi|2054570731|tpg|BK021107.1| | 2832643 | g91658 | i0 | 100 | 2.99386503067485 | 163 | 0 | 100 | 0 | 1 | 163 | 12203 | 12041 | MAG TPA_asm: Caudoviricetes sp. isolate ctI4P1, partial genome | blastn | 488 | 302 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19959728 | 19959728 | PRJNA846486_P_NODE_68976_length_175_cov_1.650794_g68880_i0 | PRJNA846486 | 68976 | 175 | 1.650794 | 2.8888895 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 172 | 1.08e-38 | NTclustered | gi|1839221816|emb|LR797096.1| | 2100421 | g68880 | i0 | 87.5 | 9.47428571428572 | 152 | 16 | 86 | 3 | 11 | 161 | 16747 | 16598 | uncultured Caudovirales phage genome assembly | blastn | 1658 | 172 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 21235379 | 21235379 | PRJNA846486_P_NODE_69097_length_175_cov_1.523810_g69001_i0 | PRJNA846486 | 69097 | 175 | 1.52381 | 2.6666675 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 318 | 1.32e-82 | NTclustered | gi|2054472816|tpg|BK031770.1| | 2832643 | g69001 | i0 | 99.429 | 1.16 | 175 | 1 | 100 | 0 | 1 | 175 | 6830 | 6656 | MAG TPA_asm: Caudoviricetes sp. isolate ctpsk1, partial genome | blastn | 203 | 318 | 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);;