contig_metadata
11 rows where bioproject = "PRJEB14803" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3536393 | 3536393 | PRJEB14803_P_NODE_22063_length_242_cov_2.125604_g21597_i0 | PRJEB14803 | 22063 | 242 | 2.125604 | 5.14396168 | Viruses | 10239 | Viruses | Viruses | 58.4 | 4.69e-4 | NTclustered | gi|2371567475|gb|OP753449.1| | 2999102 | g21597 | i0 | 97.059 | 3.23553719008264 | 34 | 1 | 14 | 0 | 144 | 177 | 13162 | 13129 | Clostridium phage A2, complete genome | blastn | 783 | 58.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Clostridium phage A2 | |||||
| 5123918 | 5123918 | PRJEB14803_P_NODE_40605_length_164_cov_1.240310_g40139_i0 | PRJEB14803 | 40605 | 164 | 1.24031 | 2.0341084 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 52.8 | 0.014 | NTclustered | gi|1839166743|emb|LR796581.1| | 2100421 | g40139 | i0 | 100 | 0.170731707317073 | 28 | 0 | 17 | 0 | 63 | 90 | 29581 | 29608 | uncultured Caudovirales phage genome assembly | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 5124004 | 5124004 | PRJEB14803_P_NODE_8665_length_447_cov_3.077670_g8203_i0 | PRJEB14803 | 8665 | 447 | 3.07767 | 13.7571849 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 69.4 | 4.3e-7 | NTclustered | gi|2914779711|gb|OR222261.1| | 2832643 | g8203 | i0 | 97.5 | 7.32662192393736 | 40 | 1 | 9 | 0 | 4 | 43 | 17 | 56 | MAG: Caudoviricetes sp. isolate MSP0706 genomic sequence | blastn | 3275 | 69.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10224166 | 10224166 | PRJEB14803_P_NODE_26309_length_215_cov_1.677778_g25843_i0 | PRJEB14803 | 26309 | 215 | 1.677778 | 3.6072227 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 387 | 4.57e-103 | NTclustered | gi|2058080539|tpg|BK043135.1| | 2832643 | g25843 | i0 | 99.07 | 97.9767441860465 | 215 | 2 | 100 | 0 | 1 | 215 | 10188 | 10402 | MAG TPA_asm: Caudoviricetes sp. isolate ctJGW4, partial genome | blastn | 21065 | 387 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14049528 | 14049528 | PRJEB14803_P_NODE_19352_length_265_cov_1.330435_g18886_i0 | PRJEB14803 | 19352 | 265 | 1.330435 | 3.52565275 | Cyprinid herpesvirus 3 | 3050271 | Viruses | Viruses | 180 | 1.06e-40 | NTclustered | gi|1063455788|gb|KX544843.1| | 3050271 | g18886 | i0 | 85.799 | 44.6 | 169 | 24 | 64 | 0 | 3 | 171 | 244411 | 244243 | Cyprinid herpesvirus 3 isolate J2_101110, complete genome | blastn | 11819 | 180 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Alloherpesviridae | Cyvirus | Cyprinid herpesvirus 3 | ||
| 19146962 | 19146962 | PRJEB14803_P_NODE_31316_length_192_cov_40.834395_g30850_i0 | PRJEB14803 | 31316 | 192 | 40.834395 | 78.4020384 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 316 | 5.31e-82 | NTclustered | gi|2058128472|tpg|BK034062.1| | 2832643 | g30850 | i0 | 96.354 | 429.90625 | 192 | 7 | 100 | 0 | 1 | 192 | 39313 | 39504 | MAG TPA_asm: Caudoviricetes sp. isolate ctw8r9, partial genome | blastn | 82542 | 316 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21698137 | 21698137 | PRJEB14803_P_NODE_25678_length_219_cov_1.206522_g25212_i0 | PRJEB14803 | 25678 | 219 | 1.206522 | 2.64228318 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|2058076380|tpg|BK043048.1| | 2832643 | g25212 | i0 | 100 | 0.132420091324201 | 29 | 0 | 13 | 0 | 191 | 219 | 5292 | 5264 | MAG TPA_asm: Caudoviricetes sp. isolate ctyYL4, partial genome | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21698193 | 21698193 | PRJEB14803_P_NODE_34778_length_180_cov_5.193103_g34312_i0 | PRJEB14803 | 34778 | 180 | 5.193103 | 9.3475854 | Pseudomonas phage sp. 30-3 | 2972143 | Viruses | Viruses | 106 | 1.16e-18 | NTclustered | gi|2296132097|dbj|LC727698.1| | 2972143 | g34312 | i0 | 95.455 | 29.8333333333333 | 66 | 3 | 37 | 0 | 81 | 146 | 239382 | 239317 | Pseudomonas phage sp. 30-3 phi30-3 DNA, complete genome | blastn | 5370 | 106 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Arenbergviridae | Wroclawvirus | Pseudomonas phage sp. 30-3 | |||
| 21698310 | 21698310 | PRJEB14803_P_NODE_8958_length_438_cov_1.759305_g8495_i0 | PRJEB14803 | 8958 | 438 | 1.759305 | 7.7057559 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 62.1 | 7.03e-5 | NTclustered | gi|2059632675|tpg|BK028438.1| | 2832643 | g8495 | i0 | 92.857 | 1.98630136986301 | 42 | 3 | 10 | 0 | 313 | 354 | 42472 | 42431 | MAG TPA_asm: Caudoviricetes sp. isolate ctawJ4, partial genome | blastn | 870 | 62.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29780365 | 29780365 | PRJEB14803_P_NODE_10991_length_383_cov_3.652299_g10526_i0 | PRJEB14803 | 10991 | 383 | 3.652299 | 13.98830517 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 47.4 | 0.00101 | NR | DAT76221.1 | 2832643 | g10526 | i0 | 36.6 | 0.642297650130548 | 82 | 45 | 58.7 | 2 | 377 | 153 | 35 | 116 | DAT76221.1 MAG TPA: Single strand binding protein [Caudoviricetes sp.] | diamond | 246 | 47.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31708201 | 31708201 | PRJEB14803_P_NODE_32057_length_190_cov_1.290323_g31591_i0 | PRJEB14803 | 32057 | 190 | 1.290323 | 2.4516137 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 41.6 | 0.0488 | NR | DAK65929.1 | 2832643 | g31591 | i0 | 33.3 | 0.805263157894737 | 51 | 33 | 80.5 | 1 | 29 | 181 | 271 | 320 | DAK65929.1 MAG TPA: carbohydrate esterase [Caudoviricetes sp.] | diamond | 153 | 41.6 | 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);;