contig_metadata
30 rows where analysis = "diamond", bioproject = "PRJNA757618" and tax_phylum = "Uroviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26957852 | 26957852 | PRJNA757618_P_NODE_14202_length_308_cov_1.991489_g13150_i0 | PRJNA757618 | 14202 | 308 | 1.991489 | 6.13378612 | Siphoviridae sp. ctHip2 | 2827830 | Viruses | Viruses | 70.5 | 7.43e-12 | NR | DAF42696.1 | 2827830 | g13150 | i0 | 44 | 0.818181818181818 | 84 | 47 | 81.8 | 0 | 286 | 35 | 48 | 131 | DAF42696.1 MAG TPA: LexA-binding, inner membrane-associated putative hydrolase [Siphoviridae sp. ctHip2] | diamond | 252 | 70.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctHip2 | |||||
| 27179180 | 27179180 | PRJNA757618_P_NODE_14482_length_306_cov_1.802575_g13430_i0 | PRJNA757618 | 14482 | 306 | 1.802575 | 5.5158795 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 166 | 1.13e-46 | NR | XOR20246.1 | 2832643 | g13430 | i0 | 77.5 | 6 | 102 | 23 | 100 | 0 | 1 | 306 | 231 | 332 | XOR20246.1 MAG: putative phage protein [Caudoviricetes sp.] | diamond | 1836 | 166 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27369357 | 27369357 | PRJNA757618_P_NODE_6403_length_477_cov_1.534653_g5351_i0 | PRJNA757618 | 6403 | 477 | 1.534653 | 7.32029481 | Achromobacter phage vB_AchrS_AchV4 | 2796514 | Viruses | Viruses | 125 | 8.18e-30 | NR | YP_009997603.1 | 2796514 | g5351 | i0 | 47.4 | 0.849056603773585 | 135 | 71 | 84.9 | 0 | 428 | 24 | 670 | 804 | YP_009997603.1 DNA primase [Achromobacter phage vB_AchrS_AchV4] | diamond | 405 | 125 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Casjensviridae | Gediminasvirus | Gediminasvirus AchV4 | |||
| 27463884 | 27463884 | PRJNA757618_P_NODE_24903_length_258_cov_1.675676_g23851_i0 | PRJNA757618 | 24903 | 258 | 1.675676 | 4.32324408 | Microbacterium phage Magritte | 3077798 | Viruses | Viruses | 72.8 | 1.14e-12 | NR | WNN95069.1 | 3077798 | g23851 | i0 | 59.4 | 0.744186046511628 | 64 | 26 | 74.4 | 0 | 65 | 256 | 1 | 64 | WNN95069.1 Ro-like RNA binding protein [Microbacterium phage Magritte] | diamond | 192 | 72.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Microbacterium phage Magritte | |||||
| 27558271 | 27558271 | PRJNA757618_P_NODE_32164_length_250_cov_0.875706_g31112_i0 | PRJNA757618 | 32164 | 250 | 0.875706 | 2.189265 | Halogranum tailed virus 1 | 1273749 | Viruses | Viruses | 82.8 | 3.26e-16 | NR | YP_008059284.1 | 1273749 | g31112 | i0 | 68.3 | 0.72 | 60 | 19 | 72 | 0 | 1 | 180 | 678 | 737 | YP_008059284.1 ribonucleotide reductase [Halogranum tailed virus 1] | diamond | 180 | 82.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thumleimavirales | Halomagnusviridae | Hagravirus | Hagravirus capitaneum | ||
| 27653376 | 27653376 | PRJNA757618_P_NODE_7964_length_400_cov_1.345566_g6912_i0 | PRJNA757618 | 7964 | 400 | 1.345566 | 5.382264 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 85.5 | 1.78e-16 | NR | DAJ88794.1 | 2832643 | g6912 | i0 | 45.3 | 0.7125 | 95 | 50 | 71.3 | 1 | 301 | 17 | 80 | 172 | DAJ88794.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 285 | 85.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27716740 | 27716740 | PRJNA757618_P_NODE_7084_length_436_cov_1.085399_g6032_i0 | PRJNA757618 | 7084 | 436 | 1.085399 | 4.73233964 | Siphoviridae sp. ctHip2 | 2827830 | Viruses | Viruses | 154 | 6.86e-41 | NR | DAF42606.1 | 2827830 | g6032 | i0 | 51 | 0.98394495412844 | 143 | 66 | 95.6 | 2 | 19 | 435 | 159 | 301 | DAF42606.1 MAG TPA: DNA TRANSLOCASE FTSK [Siphoviridae sp. ctHip2] | diamond | 429 | 154 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctHip2 | |||||
| 27811283 | 27811283 | PRJNA757618_P_NODE_9064_length_371_cov_1.379195_g8012_i0 | PRJNA757618 | 9064 | 371 | 1.379195 | 5.11681345 | Siphoviridae sp. ctHip2 | 2827830 | Viruses | Viruses | 50.4 | 7.96e-5 | NR | DAF42572.1 | 2827830 | g8012 | i0 | 31 | 0.679245283018868 | 84 | 55 | 67.9 | 1 | 25 | 276 | 65 | 145 | DAF42572.1 MAG TPA: TcpE family [Siphoviridae sp. ctHip2] | diamond | 252 | 50.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctHip2 | |||||
| 27842465 | 27842465 | PRJNA757618_P_NODE_20464_length_275_cov_1.000000_g19412_i0 | PRJNA757618 | 20464 | 275 | 1 | 2.75 | Halorubrum tailed virus 28 | 2878009 | Viruses | Viruses | 63.2 | 1.4e-10 | NR | YP_010358331.1 | 2878009 | g19412 | i0 | 74.4 | 0.425454545454545 | 39 | 10 | 42.5 | 0 | 113 | 229 | 57 | 95 | YP_010358331.1 hypothetical protein M1M39_gp28 [Halorubrum tailed virus 28] | diamond | 117 | 63.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Suolaviridae | Pormufvirus | Pormufvirus salinum | |||
| 27842481 | 27842481 | PRJNA757618_P_NODE_47004_length_242_cov_0.923077_g45952_i0 | PRJNA757618 | 47004 | 242 | 0.923077 | 2.23384634 | Microbacterium phage Magritte | 3077798 | Viruses | Viruses | 78.2 | 6.73e-15 | NR | WNN95044.1 | 3077798 | g45952 | i0 | 42.2 | 1.02892561983471 | 83 | 43 | 96.7 | 2 | 1 | 234 | 85 | 167 | WNN95044.1 ASCE ATPase [Microbacterium phage Magritte] | diamond | 249 | 78.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Microbacterium phage Magritte | |||||
| 28063596 | 28063596 | PRJNA757618_P_NODE_5865_length_524_cov_1.483370_g4815_i0 | PRJNA757618 | 5865 | 524 | 1.48337 | 7.7728588 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 183 | 4.04e-51 | NR | DAJ88750.1 | 2832643 | g4815 | i0 | 54.9 | 1.91221374045802 | 173 | 76 | 97.9 | 2 | 515 | 3 | 374 | 546 | DAJ88750.1 MAG TPA: DNA packaging protein [Caudoviricetes sp.] | diamond | 1002 | 183 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28126919 | 28126919 | PRJNA757618_P_NODE_41565_length_245_cov_0.901163_g40513_i0 | PRJNA757618 | 41565 | 245 | 0.901163 | 2.20784935 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 50.1 | 2.43e-5 | NR | DAX27699.1 | 2832643 | g40513 | i0 | 91.7 | 0.293877551020408 | 24 | 2 | 29.4 | 0 | 81 | 152 | 1 | 24 | DAX27699.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 72 | 50.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28316332 | 28316332 | PRJNA757618_P_NODE_5966_length_513_cov_1.956818_g4916_i0 | PRJNA757618 | 5966 | 513 | 1.956818 | 10.03847634 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 234 | 5.469999999999999e-72 | NR | XOR20233.1 | 2832643 | g4916 | i0 | 68.8 | 0.935672514619883 | 160 | 50 | 93.6 | 0 | 33 | 512 | 1 | 160 | XOR20233.1 MAG: putative phage protein [Caudoviricetes sp.] | diamond | 480 | 234 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28379385 | 28379385 | PRJNA757618_P_NODE_7286_length_426_cov_1.450425_g6234_i0 | PRJNA757618 | 7286 | 426 | 1.450425 | 6.1788105 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 107 | 5.54e-24 | NR | XOR20233.1 | 2832643 | g6234 | i0 | 51.5 | 0.711267605633803 | 101 | 41 | 65.5 | 1 | 3 | 281 | 390 | 490 | XOR20233.1 MAG: putative phage protein [Caudoviricetes sp.] | diamond | 303 | 107 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28695348 | 28695348 | PRJNA757618_P_NODE_32727_length_249_cov_1.545455_g31675_i0 | PRJNA757618 | 32727 | 249 | 1.545455 | 3.84818295 | Microbacterium phage Magritte | 3077798 | Viruses | Viruses | 80.1 | 2.73e-15 | NR | WNN95023.1 | 3077798 | g31675 | i0 | 48.8 | 0.987951807228916 | 82 | 42 | 98.8 | 0 | 3 | 248 | 253 | 334 | WNN95023.1 DNA helicase [Microbacterium phage Magritte] | diamond | 246 | 80.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Microbacterium phage Magritte | |||||
| 28758248 | 28758248 | PRJNA757618_P_NODE_9867_length_355_cov_2.510638_g8815_i0 | PRJNA757618 | 9867 | 355 | 2.510638 | 8.9127649 | Mycobacterium phage KashFlow | 2794948 | Viruses | Viruses | 52.8 | 2.98e-5 | NR | QPO16709.1 | 2794948 | g8815 | i0 | 62.2 | 0.743661971830986 | 45 | 17 | 38 | 0 | 350 | 216 | 110 | 154 | QPO16709.1 hypothetical protein SEA_KASHFLOW_103 [Mycobacterium phage KashFlow] | diamond | 264 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Omegavirus | Mycobacterium phage KashFlow | ||||
| 28979481 | 28979481 | PRJNA757618_P_NODE_49228_length_227_cov_2.012987_g48176_i0 | PRJNA757618 | 49228 | 227 | 2.012987 | 4.56948049 | Tenacibaculum phage PTm1 | 2547425 | Viruses | Viruses | 84.7 | 4e-19 | NR | YP_009873779.1 | 2547425 | g48176 | i0 | 52 | 0.991189427312775 | 75 | 36 | 99.1 | 0 | 2 | 226 | 5 | 79 | YP_009873779.1 HNH endonuclease [Tenacibaculum phage PTm1] | diamond | 225 | 84.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Shirahamavirus | Shirahamavirus PTm1 | ||||
| 29421168 | 29421168 | PRJNA757618_P_NODE_9289_length_366_cov_1.419795_g8237_i0 | PRJNA757618 | 9289 | 366 | 1.419795 | 5.1964497 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 43.1 | 0.0158 | NR | XOQ96733.1 | 2832643 | g8237 | i0 | 55.9 | 0.278688524590164 | 34 | 14 | 27 | 1 | 266 | 364 | 15 | 48 | XOQ96733.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 102 | 43.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29736867 | 29736867 | PRJNA757618_P_NODE_49190_length_227_cov_2.967532_g48138_i0 | PRJNA757618 | 49190 | 227 | 2.967532 | 6.73629764 | Shewanella phage S | 3454094 | Viruses | Viruses | 55.5 | 1.98e-7 | NR | QBQ71192.1 | 2559821 | g48138 | i0 | 41.3 | 0.991189427312775 | 75 | 44 | 99.1 | 0 | 1 | 225 | 59 | 133 | QBQ71192.1 minor tail protein [Shewanella phage S0112] | diamond | 225 | 55.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Shewanella phage S0112 | |||||
| 29895099 | 29895099 | PRJNA757618_P_NODE_13471_length_314_cov_2.639004_g12419_i0 | PRJNA757618 | 13471 | 314 | 2.639004 | 8.28647256 | Mycobacterium phage Maddy2 | 3240400 | Viruses | Viruses | 90.5 | 4.29e-19 | NR | XDT02042.1 | 3240400 | g12419 | i0 | 69.8 | 0.506369426751592 | 53 | 16 | 50.6 | 0 | 266 | 108 | 4 | 56 | XDT02042.1 hypothetical protein [Mycobacterium phage Maddy2] | diamond | 159 | 90.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Mycobacterium phage Maddy2 | |||||
| 30021519 | 30021519 | PRJNA757618_P_NODE_9791_length_357_cov_1.095070_g8739_i0 | PRJNA757618 | 9791 | 357 | 1.09507 | 3.9093999 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 88.2 | 1.57e-17 | NR | DAJ88750.1 | 2832643 | g8739 | i0 | 38.1 | 0.991596638655462 | 118 | 73 | 99.2 | 0 | 2 | 355 | 126 | 243 | DAJ88750.1 MAG TPA: DNA packaging protein [Caudoviricetes sp.] | diamond | 354 | 88.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30179208 | 30179208 | PRJNA757618_P_NODE_5992_length_510_cov_2.237986_g4942_i0 | PRJNA757618 | 5992 | 510 | 2.237986 | 11.4137286 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 94.7 | 4.73e-19 | NR | DAJ88753.1 | 2832643 | g4942 | i0 | 48.9 | 1.06470588235294 | 90 | 43 | 51.2 | 1 | 265 | 5 | 7 | 96 | DAJ88753.1 MAG TPA: DNA TOPOISOMERASE IV, B SUBUNIT [Caudoviricetes sp.] | diamond | 543 | 94.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30589983 | 30589983 | PRJNA757618_P_NODE_13633_length_313_cov_1.291667_g12581_i0 | PRJNA757618 | 13633 | 313 | 1.291667 | 4.04291771 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 84 | 3.14e-17 | NR | CAB4137888.1 | 2100421 | g12581 | i0 | 67.2 | 1.34185303514377 | 67 | 21 | 63.3 | 1 | 198 | 1 | 1 | 67 | CAB4137888.1 FolE GTP cyclohydrolase I [uncultured Caudovirales phage] | diamond | 420 | 84 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30653073 | 30653073 | PRJNA757618_P_NODE_15353_length_300_cov_1.343612_g14301_i0 | PRJNA757618 | 15353 | 300 | 1.343612 | 4.030836 | Achromobacter phage vB_AchrS_AchV4 | 2796514 | Viruses | Viruses | 65.9 | 5.48e-10 | NR | YP_009997552.1 | 2796514 | g14301 | i0 | 35.7 | 0.98 | 98 | 59 | 98 | 2 | 1 | 294 | 31 | 124 | YP_009997552.1 tail assembly protein [Achromobacter phage vB_AchrS_AchV4] | diamond | 294 | 65.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Casjensviridae | Gediminasvirus | Gediminasvirus AchV4 | |||
| 30811228 | 30811228 | PRJNA757618_P_NODE_36254_length_248_cov_0.880000_g35202_i0 | PRJNA757618 | 36254 | 248 | 0.88 | 2.1824 | Halorubrum tailed virus BLv36 | 3056369 | Viruses | Viruses | 155 | 5.62e-42 | NR | WLW38133.1 | 3056369 | g35202 | i0 | 93.9 | 0.991935483870968 | 82 | 5 | 99.2 | 0 | 246 | 1 | 405 | 486 | WLW38133.1 hypothetical protein [Halorubrum tailed virus BLv36] | diamond | 246 | 155 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Halorubrum tailed virus BLv36 | |||||
| 30874401 | 30874401 | PRJNA757618_P_NODE_23434_length_263_cov_1.610526_g22382_i0 | PRJNA757618 | 23434 | 263 | 1.610526 | 4.23568338 | Haloarcula tailed virus 2 | 2877989 | Viruses | Viruses | 72.4 | 1.32e-12 | NR | YP_010357750.1 | 2877989 | g22382 | i0 | 47.6 | 0.935361216730038 | 82 | 39 | 93.5 | 2 | 263 | 18 | 192 | 269 | YP_010357750.1 hypothetical protein M1M34_gp013 [Haloarcula tailed virus 2] | diamond | 246 | 72.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thumleimavirales | Soleiviridae | Eilatmyovirus | Eilatmyovirus salis | ||
| 30937763 | 30937763 | PRJNA757618_P_NODE_23474_length_263_cov_1.378947_g22422_i0 | PRJNA757618 | 23474 | 263 | 1.378947 | 3.62663061 | Ralstonia phage PY | 3145150 | Viruses | Viruses | 136 | 7.82e-36 | NR | XAO34295.1 | 3145150 | g22422 | i0 | 79.8 | 0.958174904942966 | 84 | 16 | 94.7 | 1 | 10 | 258 | 347 | 430 | XAO34295.1 hypothetical protein HMHLAPFJ_00001 [Ralstonia phage PY059YO380] | diamond | 252 | 136 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Ralstonia phage PY059YO380 | |||||
| 31190007 | 31190007 | PRJNA757618_P_NODE_42795_length_244_cov_0.912281_g41743_i0 | PRJNA757618 | 42795 | 244 | 0.912281 | 2.22596564 | environmental Halophage eHP-18 | 1168820 | Viruses | Viruses | 82 | 2.84e-16 | NR | AFH22161.1 | 1168820 | g41743 | i0 | 53.9 | 0.934426229508197 | 76 | 33 | 91 | 1 | 1 | 222 | 120 | 195 | AFH22161.1 hypothetical protein OSG_eHP18_00020 [environmental Halophage eHP-18] | diamond | 228 | 82 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | environmental Halophage eHP-18 | |||||
| 32739823 | 32739823 | PRJNA757618_P_NODE_38100_length_247_cov_0.885057_g37048_i0 | PRJNA757618 | 38100 | 247 | 0.885057 | 2.18609079 | Haloarcula tailed virus 3 | 2877990 | Viruses | Viruses | 75.1 | 5.16e-15 | NR | YP_010357889.1 | 2877990 | g37048 | i0 | 43.8 | 0.97165991902834 | 80 | 44 | 97.2 | 1 | 2 | 241 | 34 | 112 | YP_010357889.1 hypothetical protein M1M35_gp25 [Haloarcula tailed virus 3] | diamond | 240 | 75.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Kirjokansivirales | Pyrstoviridae | Hatrivirus | Hatrivirus caudatum | ||
| 32771050 | 32771050 | PRJNA757618_P_NODE_11660_length_332_cov_1.193050_g10608_i0 | PRJNA757618 | 11660 | 332 | 1.19305 | 3.960926 | Mycobacterium phage Nitzel | 2652404 | Viruses | Viruses | 135 | 2.0800000000000002e-36 | NR | YP_009960444.1 | 2652404 | g10608 | i0 | 67.7 | 0.894578313253012 | 99 | 32 | 89.5 | 0 | 326 | 30 | 216 | 314 | YP_009960444.1 replication initiation protein [Mycobacterium phage Nitzel] | diamond | 297 | 135 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Cheoctovirus | Cheoctovirus nitzel |
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);;