contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA911178" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12371620 | 12371620 | PRJNA911178_P_NODE_254950_length_248_cov_1.320000_g252476_i0 | PRJNA911178 | 254950 | 248 | 1.32 | 3.2736 | Xanthomonas phage RTH11 | 3044021 | Viruses | Viruses | 114 | 1.74e-27 | NR | WJJ54884.1 | 3044021 | g252476 | i0 | 67.9 | 0.979838709677419 | 81 | 26 | 98 | 0 | 5 | 247 | 412 | 492 | WJJ54884.1 hypothetical protein [Xanthomonas phage RTH11] | diamond | 243 | 114 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Xanthomonas phage RTH11 | |||||
| 26612748 | 26612748 | PRJNA911178_P_NODE_186581_length_279_cov_1.485437_g184108_i0 | PRJNA911178 | 186581 | 279 | 1.485437 | 4.14436923 | Thermus phage phiYS4 | 407392 | Viruses | Viruses | 45.1 | 0.00861 | NR | YP_874043.1 | 407392 | g184108 | i0 | 33.8 | 1.52688172043011 | 71 | 45 | 76.3 | 1 | 33 | 245 | 515 | 583 | YP_874043.1 hypothetical protein YS40_030 [Thermus phage phiYS40] | diamond | 426 | 45.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thermus phage phiYS40 | |||||
| 26707597 | 26707597 | PRJNA911178_P_NODE_201301_length_271_cov_1.464646_g198827_i0 | PRJNA911178 | 201301 | 271 | 1.464646 | 3.96919066 | Thermus phage YS4 | 2494333 | Viruses | Viruses | 111 | 2.86e-27 | NR | AZU97646.1 | 2494333 | g198827 | i0 | 58.4 | 0.985239852398524 | 89 | 37 | 98.5 | 0 | 5 | 271 | 100 | 188 | AZU97646.1 RecA/RadA recombinase [Thermus phage YS40_Isch] | diamond | 267 | 111 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thermus phage YS40_Isch | |||||
| 26960999 | 26960999 | PRJNA911178_P_NODE_255702_length_248_cov_0.880000_g253228_i0 | PRJNA911178 | 255702 | 248 | 0.88 | 2.1824 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 100 | 9.36e-25 | NR | CAB4159673.1 | 2100421 | g253228 | i0 | 67.1 | 1.98387096774194 | 82 | 26 | 99.2 | 1 | 246 | 1 | 23 | 103 | CAB4159673.1 hypothetical protein UFOVP716_27 [uncultured Caudovirales phage] | diamond | 492 | 100 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 26961001 | 26961001 | PRJNA911178_P_NODE_261302_length_247_cov_0.885057_g258828_i0 | PRJNA911178 | 261302 | 247 | 0.885057 | 2.18609079 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 41.6 | 0.0278 | NR | CAB5194869.1 | 2100421 | g258828 | i0 | 37.8 | 0.546558704453441 | 45 | 21 | 54.7 | 1 | 110 | 244 | 47 | 84 | CAB5194869.1 NAT_SF domain containing protein [uncultured Caudovirales phage] | diamond | 135 | 41.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27751259 | 27751259 | PRJNA911178_P_NODE_129664_length_324_cov_1.601594_g127192_i0 | PRJNA911178 | 129664 | 324 | 1.601594 | 5.18916456 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 191 | 7.769999999999999e-54 | NR | XOR37202.1 | 2832643 | g127192 | i0 | 81.3 | 0.990740740740741 | 107 | 20 | 99.1 | 0 | 2 | 322 | 173 | 279 | XOR37202.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 321 | 191 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28540663 | 28540663 | PRJNA911178_P_NODE_292167_length_241_cov_0.916667_g289693_i0 | PRJNA911178 | 292167 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 139 | 2.76e-39 | NR | XOR37213.1 | 2832643 | g289693 | i0 | 83.3 | 0.970954356846473 | 78 | 13 | 97.1 | 0 | 8 | 241 | 80 | 157 | XOR37213.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 234 | 139 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28635359 | 28635359 | PRJNA911178_P_NODE_103227_length_356_cov_2.575972_g100756_i0 | PRJNA911178 | 103227 | 356 | 2.575972 | 9.17046032 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 131 | 5.099999999999999e-33 | NR | XOS51630.1 | 2832643 | g100756 | i0 | 60.6 | 0.918539325842697 | 109 | 42 | 91.9 | 1 | 30 | 356 | 233 | 340 | XOS51630.1 MAG: virion structural protein [Caudoviricetes sp.] | diamond | 327 | 131 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28792872 | 28792872 | PRJNA911178_P_NODE_97407_length_365_cov_2.181507_g94937_i0 | PRJNA911178 | 97407 | 365 | 2.181507 | 7.96250055 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 90.1 | 3.31e-18 | NR | DAH75483.1 | 2832643 | g94937 | i0 | 50.6 | 0.715068493150685 | 87 | 40 | 70.7 | 2 | 267 | 10 | 110 | 194 | DAH75483.1 MAG TPA: 4-amino-4-deoxy-L-arabinose (L-Ara4N) transferase protein [Caudoviricetes sp.] | diamond | 261 | 90.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28856001 | 28856001 | PRJNA911178_P_NODE_292448_length_241_cov_0.916667_g289974_i0 | PRJNA911178 | 292448 | 241 | 0.916667 | 2.20916747 | Cyprinid herpesvirus 1 | 317858 | Viruses | Viruses | 43.1 | 0.019 | NR | YP_007003701.1 | 317858 | g289974 | i0 | 31.2 | 0.95850622406639 | 77 | 48 | 95.9 | 3 | 4 | 234 | 92 | 163 | YP_007003701.1 protein ORF32 [Cyprinid herpesvirus 1] | diamond | 231 | 43.1 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Alloherpesviridae | Cyvirus | Cyprinid herpesvirus 1 | ||
| 28951062 | 28951062 | PRJNA911178_P_NODE_163428_length_293_cov_2.704545_g160955_i0 | PRJNA911178 | 163428 | 293 | 2.704545 | 7.92431685 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 87.4 | 5.91e-20 | NR | XOR15690.1 | 2832643 | g160955 | i0 | 50.5 | 3.11262798634812 | 101 | 44 | 97.3 | 2 | 9 | 293 | 1 | 101 | XOR15690.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 912 | 87.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29487432 | 29487432 | PRJNA911178_P_NODE_290750_length_241_cov_1.791667_g288276_i0 | PRJNA911178 | 290750 | 241 | 1.791667 | 4.31791747 | Thermus phage phiLo | 2301536 | Viruses | Viruses | 91.7 | 1.09e-19 | NR | AYJ73948.1 | 2301536 | g288276 | i0 | 92 | 9.03734439834025 | 50 | 4 | 62.2 | 0 | 92 | 241 | 1 | 50 | AYJ73948.1 putative transposase [Thermus phage phiLo] | diamond | 2178 | 91.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thermus phage phiLo | |||||
| 29739973 | 29739973 | PRJNA911178_P_NODE_286810_length_242_cov_0.911243_g284336_i0 | PRJNA911178 | 286810 | 242 | 0.911243 | 2.20520806 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 93.2 | 3.2800000000000002e-22 | NR | CAB4148433.1 | 2100421 | g284336 | i0 | 93.9 | 0.607438016528926 | 49 | 3 | 60.7 | 0 | 96 | 242 | 1 | 49 | CAB4148433.1 hypothetical protein UFOVP529_5 [uncultured Caudovirales phage] | diamond | 147 | 93.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29898228 | 29898228 | PRJNA911178_P_NODE_250571_length_249_cov_0.875000_g248097_i0 | PRJNA911178 | 250571 | 249 | 0.875 | 2.17875 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 89.4 | 4.25e-19 | NR | CAB4145015.1 | 2100421 | g248097 | i0 | 46.9 | 0.975903614457831 | 81 | 41 | 97.6 | 1 | 2 | 244 | 166 | 244 | CAB4145015.1 Histone deacetylase domain containing protein [uncultured Caudovirales phage] | diamond | 243 | 89.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30624680 | 30624680 | PRJNA911178_P_NODE_276873_length_244_cov_0.900585_g274399_i0 | PRJNA911178 | 276873 | 244 | 0.900585 | 2.1974274 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 119 | 9.52e-32 | NR | CAB4145045.1 | 2100421 | g274399 | i0 | 67.9 | 0.959016393442623 | 78 | 25 | 95.9 | 0 | 6 | 239 | 51 | 128 | CAB4145045.1 hypothetical protein UFOVP465_18 [uncultured Caudovirales phage] | diamond | 234 | 119 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30972478 | 30972478 | PRJNA911178_P_NODE_255714_length_248_cov_0.880000_g253240_i0 | PRJNA911178 | 255714 | 248 | 0.88 | 2.1824 | Xanthomonas phage RTH11 | 3044021 | Viruses | Viruses | 141 | 6.7e-37 | NR | WJJ55045.1 | 3044021 | g253240 | i0 | 83.5 | 0.955645161290323 | 79 | 13 | 95.6 | 0 | 10 | 246 | 196 | 274 | WJJ55045.1 NAD-dependent DNA ligase [Xanthomonas phage RTH11] | diamond | 237 | 141 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Xanthomonas phage RTH11 | |||||
| 31256731 | 31256731 | PRJNA911178_P_NODE_247035_length_250_cov_0.870056_g244561_i0 | PRJNA911178 | 247035 | 250 | 0.870056 | 2.17514 | Agrobacterium phage OLIVR5 | 2723773 | Viruses | Viruses | 67 | 2.21e-12 | NR | YP_010107292.1 | 2723773 | g244561 | i0 | 50 | 0.696 | 58 | 29 | 69.6 | 0 | 240 | 67 | 26 | 83 | YP_010107292.1 hypothetical protein KNU99_gp251 [Agrobacterium phage OLIVR5] | diamond | 174 | 67 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pootjesviridae | Heverleevirus | Heverleevirus OLIVR5 | |||
| 31446593 | 31446593 | PRJNA911178_P_NODE_33856_length_587_cov_0.848249_g31487_i0 | PRJNA911178 | 33856 | 587 | 0.848249 | 4.97922163 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 46.2 | 0.0143 | NR | DAL57084.1 | 2832643 | g31487 | i0 | 32.6 | 0.439522998296422 | 86 | 53 | 41.4 | 1 | 40 | 282 | 57 | 142 | DAL57084.1 MAG TPA_asm: holin [Caudoviricetes sp.] | diamond | 258 | 46.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31509971 | 31509971 | PRJNA911178_P_NODE_219736_length_261_cov_1.579787_g217262_i0 | PRJNA911178 | 219736 | 261 | 1.579787 | 4.12324407 | Rhodococcus phage MacGully | 3069508 | Viruses | Viruses | 43.9 | 0.0177 | NR | WNY15157.1 | 3069508 | g217262 | i0 | 32.2 | 1 | 87 | 51 | 93.1 | 2 | 1 | 243 | 26 | 110 | WNY15157.1 minor tail protein [Rhodococcus phage MacGully] | diamond | 261 | 43.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zierdtviridae | Rhodococcus phage MacGully |
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);;