contig_metadata
9 rows where bioproject = "PRJNA662254" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10090533 | 10090533 | PRJNA662254_P_NODE_37268_length_275_cov_0.985149_g36617_i0 | PRJNA662254 | 37268 | 275 | 0.985149 | 2.70915975 | root | 1 | Root_unresolved | Root_unresolved | 67.6 | 9.03e-7 | NTclustered | gi|752901008|ref|NC_026421.1| | 10371 | g36617 | i0 | 95.238 | 10.7163636363636 | 42 | 2 | 15 | 0 | 100 | 141 | 136064 | 136105 | Equid herpesvirus 5 strain 2-141/67, complete genome | blastn | 2947 | 67.6 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Percavirus | Percavirus equidgamma5 | ||
| 18480681 | 18480681 | PRJNA662254_P_NODE_46955_length_250_cov_0.870056_g46304_i0 | PRJNA662254 | 46955 | 250 | 0.870056 | 2.17514 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 248 | 2.69e-61 | NTclustered | gi|1839204713|emb|LR797321.1| | 2100421 | g46304 | i0 | 85.593 | 1.892 | 236 | 34 | 94 | 0 | 5 | 240 | 26918 | 26683 | uncultured Caudovirales phage genome assembly | blastn | 473 | 248 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29512821 | 29512821 | PRJNA662254_P_NODE_61150_length_243_cov_0.905882_g60499_i0 | PRJNA662254 | 61150 | 243 | 0.905882 | 2.20129326 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 46.6 | 0.00156 | NR | DAJ28973.1 | 2832643 | g60499 | i0 | 44.6 | 0.691358024691358 | 56 | 30 | 69.1 | 1 | 6 | 173 | 176 | 230 | DAJ28973.1 MAG TPA: SspH2 (Leucine-rich repeat protein) [Caudoviricetes sp.] | diamond | 168 | 46.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30618480 | 30618480 | PRJNA662254_P_NODE_61073_length_243_cov_0.905882_g60422_i0 | PRJNA662254 | 61073 | 243 | 0.905882 | 2.20129326 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 84.3 | 6.29e-17 | NR | CAB4124358.1 | 2100421 | g60422 | i0 | 62.5 | 1.98765432098765 | 80 | 30 | 98.8 | 0 | 1 | 240 | 165 | 244 | CAB4124358.1 prohead core protein [uncultured Caudovirales phage] | diamond | 483 | 84.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31250464 | 31250464 | PRJNA662254_P_NODE_59895_length_244_cov_0.900585_g59244_i0 | PRJNA662254 | 59895 | 244 | 0.900585 | 2.1974274 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 50.4 | 4.49e-5 | NR | CAB4125924.1 | 2100421 | g59244 | i0 | 72.2 | 0.442622950819672 | 36 | 10 | 44.3 | 0 | 153 | 46 | 170 | 205 | CAB4125924.1 hypothetical protein UFOVP57_325 [uncultured Caudovirales phage] | diamond | 108 | 50.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31377150 | 31377150 | PRJNA662254_P_NODE_20756_length_360_cov_1.369338_g20105_i0 | PRJNA662254 | 20756 | 360 | 1.369338 | 4.9296168 | Caudovirales sp. ctOwN3 | 2656725 | Viruses | Viruses | 77.8 | 6.96e-14 | NR | QGH72162.1 | 2656725 | g20105 | i0 | 70.2 | 0.391666666666667 | 47 | 14 | 39.2 | 0 | 143 | 3 | 18 | 64 | QGH72162.1 MAG: terminase large subunit [Caudovirales sp. ctOwN3] | diamond | 141 | 77.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudovirales sp. ctOwN3 | |||||
| 31819732 | 31819732 | PRJNA662254_P_NODE_56297_length_246_cov_0.890173_g55646_i0 | PRJNA662254 | 56297 | 246 | 0.890173 | 2.18982558 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 80.9 | 1.43e-15 | NR | CAB4242000.1 | 2100421 | g55646 | i0 | 61.6 | 1.78048780487805 | 73 | 27 | 87.8 | 1 | 218 | 3 | 495 | 567 | CAB4242000.1 hypothetical protein UFOVP86_10 [uncultured Caudovirales phage] | diamond | 438 | 80.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31851334 | 31851334 | PRJNA662254_P_NODE_55557_length_246_cov_0.890173_g54906_i0 | PRJNA662254 | 55557 | 246 | 0.890173 | 2.18982558 | Ackermannviridae sp. | 2831612 | Viruses | Viruses | 133 | 7.729999999999998e-35 | NR | DAK15747.1 | 2831612 | g54906 | i0 | 80.2 | 0.98780487804878 | 81 | 16 | 98.8 | 0 | 243 | 1 | 56 | 136 | DAK15747.1 MAG TPA: endonuclease [Ackermannviridae sp.] | diamond | 243 | 133 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Ackermannviridae | Ackermannviridae sp. | |||
| 32736749 | 32736749 | PRJNA662254_P_NODE_50260_length_249_cov_0.875000_g49609_i0 | PRJNA662254 | 50260 | 249 | 0.875 | 2.17875 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 56.6 | 5.24e-7 | NR | CAB4161281.1 | 2100421 | g49609 | i0 | 49.4 | 0.927710843373494 | 77 | 35 | 92.8 | 1 | 16 | 246 | 222 | 294 | CAB4161281.1 hypothetical protein UFOVP732_42 [uncultured Caudovirales phage] | diamond | 231 | 56.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch |
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);;