contig_metadata
23 rows where bioproject = "PRJNA494251" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1106772 | 1106772 | PRJNA494251_P_NODE_31541_length_266_cov_9.233161_g31227_i0 | PRJNA494251 | 31541 | 266 | 9.233161 | 24.56020826 | Autosignataviridae | 3424636 | Viruses | Viruses | 470 | 5.669999999999999e-128 | NTclustered | gi|15462|emb|Y00105.1| | 10761 | g31227 | i0 | 100 | 11.3270676691729 | 254 | 0 | 95 | 0 | 10 | 263 | 947 | 694 | Bacteriophage SP6 gene for RNA polymerase | blastn | 3013 | 470 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lederbergvirus | Lederbergvirus Sf6 | ||||
| 3026416 | 3026416 | PRJNA494251_P_NODE_46123_length_244_cov_0.900585_g45809_i0 | PRJNA494251 | 46123 | 244 | 0.900585 | 2.1974274 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 244 | 3.3799999999999997e-60 | NTclustered | gi|2914995474|gb|OR222237.1| | 2832643 | g45809 | i0 | 85.062 | 0.987704918032787 | 241 | 34 | 98 | 2 | 5 | 244 | 12072 | 11833 | MAG: Caudoviricetes sp. isolate MSP0729 genomic sequence | blastn | 241 | 244 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4302054 | 4302054 | PRJNA494251_P_NODE_17084_length_338_cov_17.686792_g16771_i0 | PRJNA494251 | 17084 | 338 | 17.686792 | 59.78135696 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 582 | 9.15e-162 | NTclustered | gi|2053033389|tpg|BK024106.1| | 2832643 | g16771 | i0 | 98.777 | 17.0562130177515 | 327 | 4 | 97 | 0 | 4 | 330 | 415 | 89 | MAG TPA_asm: Caudoviricetes sp. isolate ct1083, partial genome | blastn | 5765 | 582 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6210274 | 6210274 | PRJNA494251_P_NODE_25545_length_288_cov_2.762791_g25231_i0 | PRJNA494251 | 25545 | 288 | 2.762791 | 7.95683808 | Autosignataviridae | 3424636 | Viruses | Viruses | 505 | 1.7e-138 | NTclustered | gi|15462|emb|Y00105.1| | 10761 | g25231 | i0 | 100 | 9.20486111111111 | 273 | 0 | 95 | 0 | 13 | 285 | 2284 | 2012 | Bacteriophage SP6 gene for RNA polymerase | blastn | 2651 | 505 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lederbergvirus | Lederbergvirus Sf6 | ||||
| 7484864 | 7484864 | PRJNA494251_P_NODE_10426_length_415_cov_11.312865_g10120_i0 | PRJNA494251 | 10426 | 415 | 11.312865 | 46.94838975 | Autosignataviridae | 3424636 | Viruses | Viruses | 756 | 0 | NTclustered | gi|15462|emb|Y00105.1| | 10761 | g10120 | i0 | 99.758 | 8.99277108433735 | 413 | 0 | 99 | 1 | 4 | 415 | 1618 | 2030 | Bacteriophage SP6 gene for RNA polymerase | blastn | 3732 | 756 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lederbergvirus | Lederbergvirus Sf6 | ||||
| 11954018 | 11954018 | PRJNA494251_P_NODE_25930_length_287_cov_1.289720_g25616_i0 | PRJNA494251 | 25930 | 287 | 1.28972 | 3.7014964 | Bacillus phage Maceta | 2282408 | Viruses | Viruses | 67.6 | 9.48e-7 | NTclustered | gi|1432229668|gb|MH538296.1| | 2282408 | g25616 | i0 | 100 | 0.125435540069686 | 36 | 0 | 13 | 0 | 250 | 285 | 29 | 64 | Bacillus phage Maceta, complete genome | blastn | 36 | 67.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Bastillevirus | Bacillus phage Maceta | |||
| 13229338 | 13229338 | PRJNA494251_P_NODE_45611_length_244_cov_0.900585_g45297_i0 | PRJNA494251 | 45611 | 244 | 0.900585 | 2.1974274 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 451 | 1.86e-122 | NTclustered | gi|2914983096|gb|OR222107.1| | 2832643 | g45297 | i0 | 100 | 3 | 244 | 0 | 100 | 0 | 1 | 244 | 171747 | 171990 | MAG: Caudoviricetes sp. isolate MSP0002 genomic sequence | blastn | 732 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14504199 | 14504199 | PRJNA494251_P_NODE_42292_length_247_cov_0.885057_g41978_i0 | PRJNA494251 | 42292 | 247 | 0.885057 | 2.18609079 | Hapunavirus VP882 | 261726 | Viruses | Viruses | 440 | 4.079999999999999e-119 | NTclustered | gi|126010846|ref|NC_009016.1| | 2913982 | g41978 | i0 | 98.785 | 1 | 247 | 3 | 100 | 0 | 1 | 247 | 36915 | 37161 | Vibrio phage VP882, complete genome | blastn | 247 | 440 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Hapunavirus | Hapunavirus VP882 | ||||
| 16409493 | 16409493 | PRJNA494251_P_NODE_10733_length_410_cov_6.094955_g10427_i0 | PRJNA494251 | 10733 | 410 | 6.094955 | 24.9893155 | Autosignataviridae | 3424636 | Viruses | Viruses | 730 | 0 | NTclustered | gi|15462|emb|Y00105.1| | 10761 | g10427 | i0 | 100 | 10.4853658536585 | 395 | 0 | 96 | 0 | 4 | 398 | 1236 | 1630 | Bacteriophage SP6 gene for RNA polymerase | blastn | 4299 | 730 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lederbergvirus | Lederbergvirus Sf6 | ||||
| 17684707 | 17684707 | PRJNA494251_P_NODE_50754_length_235_cov_5.339506_g50440_i0 | PRJNA494251 | 50754 | 235 | 5.339506 | 12.5478391 | Autosignataviridae | 3424636 | Viruses | Viruses | 422 | 1.39e-113 | NTclustered | gi|15462|emb|Y00105.1| | 10761 | g50440 | i0 | 100 | 8.61276595744681 | 228 | 0 | 97 | 0 | 5 | 232 | 1137 | 910 | Bacteriophage SP6 gene for RNA polymerase | blastn | 2024 | 422 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lederbergvirus | Lederbergvirus Sf6 | ||||
| 21508883 | 21508883 | PRJNA494251_P_NODE_45597_length_244_cov_0.900585_g45283_i0 | PRJNA494251 | 45597 | 244 | 0.900585 | 2.1974274 | root | 1 | Root_unresolved | Root_unresolved | 285 | 1.99e-72 | NTclustered | gi|2043520657|gb|MZ092003.1| | 2836077 | g45283 | i0 | 91.707 | 697.200819672131 | 205 | 17 | 84 | 0 | 40 | 244 | 83887 | 83683 | Paenibacillus phage Pd_22F, complete genome | blastn | 170117 | 285 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Paenibacillus phage Pd_22F | |||||
| 23427784 | 23427784 | PRJNA494251_P_NODE_33699_length_260_cov_1.235294_g33385_i0 | PRJNA494251 | 33699 | 260 | 1.235294 | 3.2117644 | Littlefixvirus littlefix | 2845959 | Viruses | Viruses | 316 | 7.61e-82 | NTclustered | gi|1859648885|ref|NC_048697.1| | 2079289 | g33385 | i0 | 88.76 | 0.992307692307692 | 258 | 29 | 99 | 0 | 1 | 258 | 8341 | 8084 | Pseudomonas phage Littlefix, complete genome | blastn | 258 | 316 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Littlefixvirus | Littlefixvirus littlefix | |||
| 25333172 | 25333172 | PRJNA494251_P_NODE_23160_length_299_cov_8.840708_g22846_i0 | PRJNA494251 | 23160 | 299 | 8.840708 | 26.43371692 | Autosignataviridae | 3424636 | Viruses | Viruses | 459 | 1.4000000000000002e-124 | NTclustered | gi|15462|emb|Y00105.1| | 10761 | g22846 | i0 | 100 | 14.6153846153846 | 248 | 0 | 83 | 0 | 9 | 256 | 288 | 41 | Bacteriophage SP6 gene for RNA polymerase | blastn | 4370 | 459 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lederbergvirus | Lederbergvirus Sf6 | ||||
| 25333209 | 25333209 | PRJNA494251_P_NODE_33420_length_260_cov_5.791444_g33106_i0 | PRJNA494251 | 33420 | 260 | 5.791444 | 15.0577544 | Autosignataviridae | 3424636 | Viruses | Viruses | 449 | 7.190000000000001e-122 | NTclustered | gi|15462|emb|Y00105.1| | 10761 | g33106 | i0 | 100 | 13.9038461538462 | 243 | 0 | 93 | 0 | 15 | 257 | 599 | 357 | Bacteriophage SP6 gene for RNA polymerase | blastn | 3615 | 449 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lederbergvirus | Lederbergvirus Sf6 | ||||
| 26665194 | 26665194 | PRJNA494251_P_NODE_5181_length_560_cov_1.215606_g4887_i0 | PRJNA494251 | 5181 | 560 | 1.215606 | 6.8073936 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 60.8 | 3.47e-7 | NR | XOR05084.1 | 2832643 | g4887 | i0 | 47.5 | 0.739285714285714 | 61 | 30 | 31.6 | 1 | 1 | 177 | 312 | 372 | XOR05084.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 414 | 60.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27740627 | 27740627 | PRJNA494251_P_NODE_24944_length_291_cov_1.412844_g24630_i0 | PRJNA494251 | 24944 | 291 | 1.412844 | 4.11137604 | Rhizobium phage RHph_TM39 | 2509768 | Viruses | Viruses | 55.5 | 2.22e-6 | NR | QIG77325.1 | 2509768 | g24630 | i0 | 34.1 | 0.938144329896907 | 91 | 58 | 93.8 | 1 | 279 | 7 | 239 | 327 | QIG77325.1 portal vertex protein of head [Rhizobium phage RHph_TM39] | diamond | 273 | 55.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Kleczkowskaviridae | Cuauhnahuacvirus | Rhizobium phage RHph_TM39 | |||
| 29287316 | 29287316 | PRJNA494251_P_NODE_21469_length_309_cov_0.915254_g21155_i0 | PRJNA494251 | 21469 | 309 | 0.915254 | 2.82813486 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 62.8 | 7.02e-9 | NR | CAB4180527.1 | 2100421 | g21155 | i0 | 60.9 | 0.446601941747573 | 46 | 18 | 44.7 | 0 | 307 | 170 | 256 | 301 | CAB4180527.1 hypothetical protein UFOVP1040_70 [uncultured Caudovirales phage] | diamond | 138 | 62.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29350647 | 29350647 | PRJNA494251_P_NODE_15169_length_356_cov_1.402827_g14856_i0 | PRJNA494251 | 15169 | 356 | 1.402827 | 4.99406412 | Escherichia phage vB_EcoM_IME392 | 2301649 | Viruses | Viruses | 93.6 | 1.61e-19 | NR | AXY86103.1 | 2301649 | g14856 | i0 | 42.1 | 0.960674157303371 | 114 | 66 | 96.1 | 0 | 353 | 12 | 204 | 317 | AXY86103.1 putative major capsid protein [Escherichia phage vB_EcoM_IME392] | diamond | 342 | 93.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Escherichia phage vB_EcoM_IME392 | |||||
| 29571516 | 29571516 | PRJNA494251_P_NODE_590_length_1389_cov_11.214286_g473_i0 | PRJNA494251 | 590 | 1389 | 11.214286 | 155.76643254 | Ralstonia phage RP13 | 2743402 | Viruses | Viruses | 162 | 8.71e-41 | NR | BCG50090.1 | 2743402 | g473 | i0 | 48.7 | 0.341252699784017 | 158 | 81 | 34.1 | 0 | 14 | 487 | 316 | 473 | BCG50090.1 hypothetical protein [Ralstonia phage RP13] | diamond | 474 | 162 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Ralstonia phage RP13 | |||||
| 30139725 | 30139725 | PRJNA494251_P_NODE_23352_length_299_cov_1.230088_g23038_i0 | PRJNA494251 | 23352 | 299 | 1.230088 | 3.67796312 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 41.2 | 0.0218 | NR | DAU75828.1 | 2832643 | g23038 | i0 | 58.6 | 0.290969899665552 | 29 | 12 | 29.1 | 0 | 127 | 213 | 1 | 29 | DAU75828.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 87 | 41.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30519293 | 30519293 | PRJNA494251_P_NODE_43493_length_246_cov_0.890173_g43179_i0 | PRJNA494251 | 43493 | 246 | 0.890173 | 2.18982558 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 41.2 | 0.0254 | NR | XOR29627.1 | 2832643 | g43179 | i0 | 54.1 | 0.451219512195122 | 37 | 16 | 45.1 | 1 | 5 | 115 | 15 | 50 | XOR29627.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 111 | 41.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31056696 | 31056696 | PRJNA494251_P_NODE_23015_length_300_cov_2.035242_g22701_i0 | PRJNA494251 | 23015 | 300 | 2.035242 | 6.105726 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 69.7 | 2.12e-11 | NR | XOR60344.1 | 2832643 | g22701 | i0 | 39.1 | 1.55 | 87 | 52 | 86 | 1 | 280 | 23 | 140 | 226 | XOR60344.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 465 | 69.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32700438 | 32700438 | PRJNA494251_P_NODE_20860_length_312_cov_1.861925_g20546_i0 | PRJNA494251 | 20860 | 312 | 1.861925 | 5.809206 | Vibrio phage 15 | 2963171 | Viruses | Viruses | 110 | 6.73e-26 | NR | CAH9015086.1 | 2963171 | g20546 | i0 | 50.5 | 0.971153846153846 | 101 | 50 | 97.1 | 0 | 8 | 310 | 364 | 464 | CAH9015086.1 conserved hypothetical protein [Vibrio phage 150E35-1] | diamond | 303 | 110 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage 150E35-1 |
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);;