contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA1041773" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26845562 | 26845562 | PRJNA1041773_P_NODE_66701_length_268_cov_0.794872_g66368_i0 | PRJNA1041773 | 66701 | 268 | 0.794872 | 2.13025696 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 99.4 | 5.08e-22 | NR | XOR53596.1 | 2832643 | g66368 | i0 | 50.6 | 0.996268656716418 | 89 | 44 | 99.6 | 0 | 268 | 2 | 416 | 504 | XOR53596.1 MAG: putative major tail tube protein [Caudoviricetes sp.] | diamond | 267 | 99.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26932281 | 26932281 | PRJNA1041773_P_NODE_64602_length_271_cov_2.000000_g64269_i0 | PRJNA1041773 | 64602 | 271 | 2 | 5.42 | Peduoviridae | 2946167 | Viruses | Viruses | 73.6 | 7.62e-13 | NR | CAB4123312.1 | 2100421 | g64269 | i0 | 43.8 | 3.9520295202952 | 89 | 49 | 98.5 | 1 | 4 | 270 | 524 | 611 | CAB4123312.1 hypothetical protein UFOVP40_12 [uncultured Caudovirales phage] | diamond | 1071 | 73.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 26971823 | 26971823 | PRJNA1041773_P_NODE_39982_length_335_cov_1.175573_g39649_i0 | PRJNA1041773 | 39982 | 335 | 1.175573 | 3.93816955 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 77.8 | 1.11e-15 | NR | XOR11972.1 | 2832643 | g39649 | i0 | 57.1 | 1.38805970149254 | 77 | 33 | 69 | 0 | 334 | 104 | 50 | 126 | XOR11972.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 465 | 77.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27256427 | 27256427 | PRJNA1041773_P_NODE_72963_length_257_cov_1.809783_g72630_i0 | PRJNA1041773 | 72963 | 257 | 1.809783 | 4.65114231 | Acinetobacter phage pB23 | 3110418 | Viruses | Viruses | 60.5 | 9.62e-9 | NR | WQY99633.1 | 3110418 | g72630 | i0 | 69.6 | 1.00389105058366 | 46 | 13 | 53.7 | 1 | 138 | 1 | 53 | 97 | WQY99633.1 hypothetical protein [Acinetobacter phage pB23] | diamond | 258 | 60.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Acinetobacter phage pB23 | |||||
| 27762043 | 27762043 | PRJNA1041773_P_NODE_74264_length_255_cov_1.692308_g73931_i0 | PRJNA1041773 | 74264 | 255 | 1.692308 | 4.3153854 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 104 | 1.37e-26 | NR | CAB4162850.1 | 2100421 | g73931 | i0 | 65.5 | 1.97647058823529 | 84 | 29 | 98.8 | 0 | 253 | 2 | 25 | 108 | CAB4162850.1 small terminase protein [uncultured Caudovirales phage] | diamond | 504 | 104 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27856431 | 27856431 | PRJNA1041773_P_NODE_65805_length_269_cov_1.571429_g65472_i0 | PRJNA1041773 | 65805 | 269 | 1.571429 | 4.22714401 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 55.5 | 1.08e-7 | NR | XOR08502.1 | 2832643 | g65472 | i0 | 72.5 | 0.446096654275093 | 40 | 11 | 44.6 | 0 | 148 | 267 | 1 | 40 | XOR08502.1 MAG: Cro [Caudoviricetes sp.] | diamond | 120 | 55.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28961839 | 28961839 | PRJNA1041773_P_NODE_84808_length_248_cov_0.880000_g84475_i0 | PRJNA1041773 | 84808 | 248 | 0.88 | 2.1824 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 95.9 | 2.58e-22 | NR | XOR87881.1 | 2832643 | g84475 | i0 | 46.3 | 3.91935483870968 | 82 | 43 | 98 | 1 | 6 | 248 | 41 | 122 | XOR87881.1 MAG: hypothetical protein MSP1685_59 [Caudoviricetes sp.] | diamond | 972 | 95.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28993474 | 28993474 | PRJNA1041773_P_NODE_54248_length_291_cov_2.770642_g53915_i0 | PRJNA1041773 | 54248 | 291 | 2.770642 | 8.06256822 | Escherichia phage Halfdan | 2234092 | Viruses | Viruses | 78.2 | 2.29e-14 | NR | YP_010731769.1 | 2234092 | g53915 | i0 | 83.7 | 0.443298969072165 | 43 | 7 | 44.3 | 0 | 134 | 6 | 325 | 367 | YP_010731769.1 DNA primase/helicase [Escherichia phage Halfdan] | diamond | 129 | 78.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Halfdanvirus | Halfdanvirus halfdan | ||||
| 29530000 | 29530000 | PRJNA1041773_P_NODE_27830_length_395_cov_1.670807_g27499_i0 | PRJNA1041773 | 27830 | 395 | 1.670807 | 6.59968765 | Rhizobium phage B1VFA | 2759201 | Viruses | Viruses | 175 | 6.91e-50 | NR | QNG62573.1 | 2759201 | g27499 | i0 | 79.2 | 0.80506329113924 | 106 | 22 | 80.5 | 0 | 374 | 57 | 367 | 472 | QNG62573.1 RNA-2',3'-PO4:RNA-5'-OH ligase [Rhizobium phage B1VFA] | diamond | 318 | 175 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rhizobium phage B1VFA | |||||
| 29687484 | 29687484 | PRJNA1041773_P_NODE_52770_length_295_cov_1.436937_g52437_i0 | PRJNA1041773 | 52770 | 295 | 1.436937 | 4.23896415 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 116 | 2.5699999999999997e-30 | NR | XOR08439.1 | 2832643 | g52437 | i0 | 63.3 | 0.996610169491525 | 98 | 36 | 99.7 | 0 | 1 | 294 | 76 | 173 | XOR08439.1 MAG: putative HNH endonuclease [Caudoviricetes sp.] | diamond | 294 | 116 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29813998 | 29813998 | PRJNA1041773_P_NODE_98571_length_242_cov_0.911243_g98238_i0 | PRJNA1041773 | 98571 | 242 | 0.911243 | 2.20520806 | Rhizobium phage V1VFA-S | 2763532 | Viruses | Viruses | 48.5 | 9.96e-5 | NR | QNH71706.1 | 2763532 | g98238 | i0 | 61.8 | 0.84297520661157 | 34 | 13 | 42.1 | 0 | 133 | 234 | 1 | 34 | QNH71706.1 hypothetical protein V1VFAS_001 [Rhizobium phage V1VFA-S] | diamond | 204 | 48.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rhizobium phage V1VFA-S | |||||
| 30320151 | 30320151 | PRJNA1041773_P_NODE_44592_length_318_cov_4.465306_g44259_i0 | PRJNA1041773 | 44592 | 318 | 4.465306 | 14.19967308 | Pseudomonas phage phiK7A1 | 2759194 | Viruses | Viruses | 75.5 | 4.18e-15 | NR | QNR53848.1 | 2759194 | g44259 | i0 | 60.7 | 0.528301886792453 | 56 | 22 | 52.8 | 0 | 315 | 148 | 49 | 104 | QNR53848.1 hypothetical protein phiK7A1_060 [Pseudomonas phage phiK7A1] | diamond | 168 | 75.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Torinovirus | Torinovirus K7A1 | |||
| 30351719 | 30351719 | PRJNA1041773_P_NODE_51412_length_298_cov_6.720000_g51079_i0 | PRJNA1041773 | 51412 | 298 | 6.72 | 20.0256 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 62.4 | 7.66e-9 | NR | CAB4131766.1 | 2100421 | g51079 | i0 | 54.2 | 0.483221476510067 | 48 | 22 | 48.3 | 0 | 152 | 295 | 1 | 48 | CAB4131766.1 hypothetical protein UFOVP131_37 [uncultured Caudovirales phage] | diamond | 144 | 62.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30383179 | 30383179 | PRJNA1041773_P_NODE_101693_length_241_cov_0.916667_g101360_i0 | PRJNA1041773 | 101693 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 1.7e-6 | NR | DAQ07319.1 | 2832643 | g101360 | i0 | 46.9 | 1.0954356846473 | 49 | 26 | 61 | 0 | 95 | 241 | 7 | 55 | DAQ07319.1 MAG TPA: intron associated endonuclease [Caudoviricetes sp.] | diamond | 264 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30603835 | 30603835 | PRJNA1041773_P_NODE_92153_length_245_cov_0.895349_g91820_i0 | PRJNA1041773 | 92153 | 245 | 0.895349 | 2.19360505 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 95.5 | 1.04e-20 | NR | CAB4153242.1 | 2100421 | g91820 | i0 | 69.1 | 0.991836734693878 | 81 | 25 | 99.2 | 0 | 1 | 243 | 719 | 799 | CAB4153242.1 Tip attachment protein J [uncultured Caudovirales phage] | diamond | 243 | 95.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30690617 | 30690617 | PRJNA1041773_P_NODE_55833_length_288_cov_1.432558_g55500_i0 | PRJNA1041773 | 55833 | 288 | 1.432558 | 4.12576704 | root | 1 | Root_unresolved | Root_unresolved | 49.3 | 7.05e-5 | NR | CAB4160936.1 | 2100421 | g55500 | i0 | 35.8 | 2.42708333333333 | 81 | 50 | 82.3 | 2 | 283 | 47 | 36 | 116 | CAB4160936.1 hypothetical protein UFOVP728_20 [uncultured Caudovirales phage] | diamond | 699 | 49.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31006645 | 31006645 | PRJNA1041773_P_NODE_101254_length_241_cov_0.916667_g100921_i0 | PRJNA1041773 | 101254 | 241 | 0.916667 | 2.20916747 | Viruses | 10239 | Viruses | Viruses | 130 | 1.51e-34 | NR | QDJ97871.1 | 2591344 | g100921 | i0 | 81.3 | 4.9792531120332 | 80 | 15 | 99.6 | 0 | 241 | 2 | 195 | 274 | QDJ97871.1 hypothetical protein PALS2_246 [Staphylococcus phage PALS_2] | diamond | 1200 | 131 | 0.99236641221374 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Staphylococcus phage PALS_2 | |||||
| 31235732 | 31235732 | PRJNA1041773_P_NODE_26955_length_401_cov_2.067073_g26624_i0 | PRJNA1041773 | 26955 | 401 | 2.067073 | 8.28896273 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 47 | 0.0063 | NR | XOR53655.1 | 2832643 | g26624 | i0 | 29.1 | 0.875311720698254 | 117 | 73 | 86.8 | 4 | 39 | 386 | 131 | 238 | XOR53655.1 MAG: putative tail protein [Caudoviricetes sp.] | diamond | 351 | 47 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31615438 | 31615438 | PRJNA1041773_P_NODE_96976_length_243_cov_0.905882_g96643_i0 | PRJNA1041773 | 96976 | 243 | 0.905882 | 2.20129326 | Acinetobacter phage nACB1 | 3015924 | Viruses | Viruses | 140 | 6.08e-40 | NR | WAW11624.1 | 3015924 | g96643 | i0 | 83.8 | 0.91358024691358 | 74 | 12 | 91.4 | 0 | 242 | 21 | 30 | 103 | WAW11624.1 endolysin [Acinetobacter phage nACB1] | diamond | 222 | 140 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Acinetobacter phage nACB1 | ||||
| 31868343 | 31868343 | PRJNA1041773_P_NODE_92617_length_244_cov_2.701754_g92284_i0 | PRJNA1041773 | 92617 | 244 | 2.701754 | 6.59227976 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 133 | 3.25e-34 | NR | CAB4151292.1 | 2100421 | g92284 | i0 | 81.5 | 0.995901639344262 | 81 | 15 | 99.6 | 0 | 244 | 2 | 290 | 370 | CAB4151292.1 hypothetical protein UFOVP590_10 [uncultured Caudovirales phage] | diamond | 243 | 133 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32184966 | 32184966 | PRJNA1041773_P_NODE_32918_length_365_cov_3.147260_g32586_i0 | PRJNA1041773 | 32918 | 365 | 3.14726 | 11.487499 | Sphingomonas phage Kimi | 3065696 | Viruses | Viruses | 131 | 3.77e-33 | NR | WLJ71034.1 | 3065696 | g32586 | i0 | 55.4 | 1.9972602739726 | 121 | 54 | 99.5 | 0 | 363 | 1 | 285 | 405 | WLJ71034.1 putative structural protein [Sphingomonas phage Kimi] | diamond | 729 | 131 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sphingomonas phage Kimi | |||||
| 32280015 | 32280015 | PRJNA1041773_P_NODE_24979_length_416_cov_1.760933_g24648_i0 | PRJNA1041773 | 24979 | 416 | 1.760933 | 7.32548128 | Escherichia phage HK97 | 2681617 | Viruses | Viruses | 81.3 | 6.53e-17 | NR | NP_037752.1 | 2681617 | g24648 | i0 | 48.9 | 2.64663461538462 | 92 | 47 | 66.3 | 0 | 415 | 140 | 15 | 106 | NP_037752.1 holin/anti-holin [Escherichia phage HK97] | diamond | 1101 | 81.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Byrnievirus | Byrnievirus HK97 | ||||
| 32374857 | 32374857 | PRJNA1041773_P_NODE_102199_length_240_cov_2.161677_g101866_i0 | PRJNA1041773 | 102199 | 240 | 2.161677 | 5.1880248 | Microcystis phage Me-ZS1 | 2483660 | Viruses | Viruses | 80.1 | 2.56e-15 | NR | AZF88180.1 | 2483660 | g101866 | i0 | 56.6 | 1.9 | 76 | 33 | 95 | 0 | 1 | 228 | 412 | 487 | AZF88180.1 DNA primase/helicase [Microcystis phage Me-ZS1] | diamond | 456 | 80.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Microcystis phage Me-ZS1 | |||||
| 32596155 | 32596155 | PRJNA1041773_P_NODE_53940_length_292_cov_1.771689_g53607_i0 | PRJNA1041773 | 53940 | 292 | 1.771689 | 5.17333188 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 51.6 | 5.13e-5 | NR | AXH76957.1 | 2832643 | g53607 | i0 | 33.7 | 1.03767123287671 | 101 | 56 | 99.7 | 2 | 1 | 291 | 326 | 419 | AXH76957.1 MAG: pectate lyase superfamily protein [Caudoviricetes sp.] | diamond | 303 | 51.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);;