contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA1123436" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26817229 | 26817229 | PRJNA1123436_P_NODE_114401_length_245_cov_0.895349_g113187_i0 | PRJNA1123436 | 114401 | 245 | 0.895349 | 2.19360505 | uncultured Mediterranean phage uvMED | 1407671 | Viruses | Viruses | 60.8 | 1.13e-8 | NR | BAR38468.1 | 1407671 | g113187 | i0 | 47 | 0.808163265306122 | 66 | 34 | 79.6 | 1 | 6 | 200 | 87 | 152 | BAR38468.1 phage major capsid protein, HK97 family (TIGR01554) [uncultured Mediterranean phage uvMED] | diamond | 198 | 60.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | uncultured Mediterranean phage uvMED | |||||
| 26848897 | 26848897 | PRJNA1123436_P_NODE_32481_length_448_cov_1.973333_g31269_i0 | PRJNA1123436 | 32481 | 448 | 1.973333 | 8.84053184 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 99.4 | 7.339999999999999e-24 | NR | XOR12525.1 | 2832643 | g31269 | i0 | 51 | 0.669642857142857 | 100 | 49 | 67 | 0 | 89 | 388 | 1 | 100 | XOR12525.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 300 | 99.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27228169 | 27228169 | PRJNA1123436_P_NODE_2023_length_2187_cov_2.449858_g1648_i0 | PRJNA1123436 | 2023 | 2187 | 2.449858 | 53.57839446 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 49.7 | 7.31e-4 | NR | CAB4189656.1 | 2100421 | g1648 | i0 | 44.8 | 0.0795610425240055 | 58 | 30 | 7.7 | 2 | 221 | 388 | 2 | 59 | CAB4189656.1 hypothetical protein UFOVP1196_6 [uncultured Caudovirales phage] | diamond | 174 | 49.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27259930 | 27259930 | PRJNA1123436_P_NODE_109543_length_247_cov_0.885057_g108329_i0 | PRJNA1123436 | 109543 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 41.6 | 0.0303 | NR | AXH71882.1 | 2832643 | g108329 | i0 | 40 | 0.607287449392713 | 50 | 30 | 60.7 | 0 | 175 | 26 | 36 | 85 | AXH71882.1 MAG: putative holin [Caudoviricetes sp.] | diamond | 150 | 41.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27259952 | 27259952 | PRJNA1123436_P_NODE_126223_length_241_cov_0.916667_g125009_i0 | PRJNA1123436 | 126223 | 241 | 0.916667 | 2.20916747 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 48.1 | 4.19e-4 | NR | CAB4143460.1 | 2100421 | g125009 | i0 | 62.5 | 0.49792531120332 | 40 | 12 | 49.8 | 1 | 120 | 239 | 1 | 37 | CAB4143460.1 RfaG Glycosyltransferase [uncultured Caudovirales phage] | diamond | 120 | 48.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27354886 | 27354886 | PRJNA1123436_P_NODE_46403_length_368_cov_1.410169_g45189_i0 | PRJNA1123436 | 46403 | 368 | 1.410169 | 5.18942192 | Microbacterium phage Kozie | 2885981 | Viruses | Viruses | 45.8 | 0.0126 | NR | YP_010750760.1 | 2885981 | g45189 | i0 | 68.4 | 0.309782608695652 | 38 | 12 | 31 | 0 | 11 | 124 | 135 | 172 | YP_010750760.1 tape measure protein [Microbacterium phage Kozie] | diamond | 114 | 45.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Kozievirus | Kozievirus kozie | ||||
| 27386517 | 27386517 | PRJNA1123436_P_NODE_84923_length_269_cov_1.178571_g83709_i0 | PRJNA1123436 | 84923 | 269 | 1.178571 | 3.17035599 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 95.5 | 1.1e-20 | NR | XOR12496.1 | 2832643 | g83709 | i0 | 55.7 | 0.8810408921933092 | 79 | 35 | 88.1 | 0 | 237 | 1 | 314 | 392 | XOR12496.1 MAG: gp10 protein [Caudoviricetes sp.] | diamond | 237 | 95.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27575803 | 27575803 | PRJNA1123436_P_NODE_99984_length_250_cov_0.870056_g98770_i0 | PRJNA1123436 | 99984 | 250 | 0.870056 | 2.17514 | Mycobacterium phage PP | 2077134 | Viruses | Viruses | 61.6 | 1.21e-9 | NR | YP_010062240.1 | 2077134 | g98770 | i0 | 49.2 | 0.732 | 61 | 31 | 73.2 | 0 | 250 | 68 | 65 | 125 | YP_010062240.1 holin [Mycobacterium phage PP] | diamond | 183 | 61.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sagamiharavirus | Sagamiharavirus PP | ||||
| 28080809 | 28080809 | PRJNA1123436_P_NODE_107685_length_247_cov_0.885057_g106471_i0 | PRJNA1123436 | 107685 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 72.8 | 3.45e-14 | NR | XOS42921.1 | 2832643 | g106471 | i0 | 60.9 | 1.55465587044534 | 64 | 25 | 77.7 | 0 | 54 | 245 | 1 | 64 | XOS42921.1 MAG: hypothetical protein MSP0963_53 [Caudoviricetes sp.] | diamond | 384 | 72.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28428328 | 28428328 | PRJNA1123436_P_NODE_124226_length_242_cov_0.911243_g123012_i0 | PRJNA1123436 | 124226 | 242 | 0.911243 | 2.20520806 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 109 | 1.39e-25 | NR | CAB4164039.1 | 2100421 | g123012 | i0 | 63.3 | 0.979338842975207 | 79 | 29 | 97.9 | 0 | 237 | 1 | 3078 | 3156 | CAB4164039.1 hypothetical protein UFOVP812_308 [uncultured Caudovirales phage] | diamond | 237 | 109 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28554732 | 28554732 | PRJNA1123436_P_NODE_76487_length_285_cov_0.806604_g75273_i0 | PRJNA1123436 | 76487 | 285 | 0.806604 | 2.2988214 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 84.3 | 4.89e-18 | NR | CAB4196854.1 | 2100421 | g75273 | i0 | 70.9 | 0.578947368421053 | 55 | 16 | 57.9 | 0 | 120 | 284 | 1 | 55 | CAB4196854.1 CYTH domain containing protein [uncultured Caudovirales phage] | diamond | 165 | 84.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28743980 | 28743980 | PRJNA1123436_P_NODE_104287_length_248_cov_0.880000_g103073_i0 | PRJNA1123436 | 104287 | 248 | 0.88 | 2.1824 | Aeromonas phage 4_4512 | 2588516 | Viruses | Viruses | 164 | 3.09e-49 | NR | QEG08943.1 | 2588516 | g103073 | i0 | 90.2 | 0.991935483870968 | 82 | 8 | 99.2 | 0 | 246 | 1 | 98 | 179 | QEG08943.1 putative NinG recombination protein [Aeromonas phage 4_4512] | diamond | 246 | 164 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aeromonas phage 4_4512 | |||||
| 28775443 | 28775443 | PRJNA1123436_P_NODE_102627_length_249_cov_0.875000_g101413_i0 | PRJNA1123436 | 102627 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 44.7 | 6.07e-4 | NR | DAT55734.1 | 2832643 | g101413 | i0 | 36.7 | 1.12048192771084 | 49 | 29 | 59 | 1 | 148 | 2 | 1 | 47 | DAT55734.1 MAG TPA: late expression factor 5 [Caudoviricetes sp.] | diamond | 279 | 44.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29059846 | 29059846 | PRJNA1123436_P_NODE_82528_length_273_cov_1.540000_g81314_i0 | PRJNA1123436 | 82528 | 273 | 1.54 | 4.2042 | Podoviridae sp. ctJDl18 | 2825242 | Viruses | Viruses | 63.5 | 1.65e-9 | NR | DAG00264.1 | 2825242 | g81314 | i0 | 40 | 0.879120879120879 | 80 | 48 | 87.9 | 0 | 32 | 271 | 72 | 151 | DAG00264.1 MAG TPA: putative receptor protein kinase TMK1-like kinase, TRANSFERASE [Podoviridae sp. ctJDl18] | diamond | 240 | 63.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Podoviridae sp. ctJDl18 | |||||
| 29659210 | 29659210 | PRJNA1123436_P_NODE_105550_length_248_cov_0.880000_g104336_i0 | PRJNA1123436 | 105550 | 248 | 0.88 | 2.1824 | Alphaproteobacteria phage PhiJL | 279383 | Viruses | Viruses | 44.7 | 0.0074400000000000004 | NR | YP_223935.1 | 2681607 | g104336 | i0 | 33.8 | 0.82258064516129 | 68 | 42 | 78.6 | 1 | 20 | 214 | 29 | 96 | YP_223935.1 gp11 [Alphaproteobacteria phage PhiJL001] | diamond | 204 | 44.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Mesyanzhinovviridae | Keylargovirus | Keylargovirus JL001 | |||
| 29849157 | 29849157 | PRJNA1123436_P_NODE_105491_length_248_cov_0.880000_g104277_i0 | PRJNA1123436 | 105491 | 248 | 0.88 | 2.1824 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 85.5 | 1.94e-17 | NR | DAI02292.1 | 2832643 | g104277 | i0 | 64.3 | 0.67741935483871 | 56 | 20 | 67.7 | 0 | 5 | 172 | 303 | 358 | DAI02292.1 MAG TPA: Cytosine specific methyltransferase [Caudoviricetes sp.] | diamond | 168 | 85.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30164811 | 30164811 | PRJNA1123436_P_NODE_72012_length_293_cov_1.400000_g70798_i0 | PRJNA1123436 | 72012 | 293 | 1.4 | 4.102 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 94.4 | 5.73e-22 | NR | DAG21215.1 | 2832643 | g70798 | i0 | 53.4 | 2.6518771331058 | 88 | 41 | 90.1 | 0 | 13 | 276 | 81 | 168 | DAG21215.1 MAG TPA: Protein of unknown function (DUF1492) [Caudoviricetes sp.] | diamond | 777 | 94.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30344340 | 30344340 | PRJNA1123436_P_NODE_69332_length_299_cov_1.960177_g68118_i0 | PRJNA1123436 | 69332 | 299 | 1.960177 | 5.86092923 | root | 1 | Root_unresolved | Root_unresolved | 169 | 1.0999999999999999e-47 | NR | DAO01422.1 | 2832643 | g68118 | i0 | 83.8 | 1.9866220735786 | 99 | 16 | 99.3 | 0 | 1 | 297 | 167 | 265 | DAO01422.1 MAG TPA: Small RNA degrading nuclease 1/RNA, microRNA turnover, protein-RNA complex [Caudoviricetes sp.] | diamond | 594 | 170 | 0.994117647058824 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31081390 | 31081390 | PRJNA1123436_P_NODE_24255_length_530_cov_1.853392_g23049_i0 | PRJNA1123436 | 24255 | 530 | 1.853392 | 9.8229776 | Enterococcus phage MSF2 | 2577028 | Viruses | Viruses | 177 | 6.799999999999998e-48 | NR | QDF15353.1 | 2577028 | g23049 | i0 | 66.7 | 0.730188679245283 | 129 | 42 | 73 | 1 | 392 | 6 | 316 | 443 | QDF15353.1 tail protein [Enterococcus phage MSF2] | diamond | 387 | 177 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Efquatrovirus | Enterococcus phage MSF2 | ||||
| 31207209 | 31207209 | PRJNA1123436_P_NODE_43875_length_380_cov_0.977199_g42661_i0 | PRJNA1123436 | 43875 | 380 | 0.977199 | 3.7133562 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 84.3 | 1.86e-18 | NR | CAB4126300.1 | 2100421 | g42661 | i0 | 57.1 | 1.72894736842105 | 70 | 30 | 55.3 | 0 | 296 | 87 | 20 | 89 | CAB4126300.1 hypothetical protein UFOVP70_44 [uncultured Caudovirales phage] | diamond | 657 | 84.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31681911 | 31681911 | PRJNA1123436_P_NODE_85937_length_267_cov_1.190722_g84723_i0 | PRJNA1123436 | 85937 | 267 | 1.190722 | 3.17922774 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 106 | 2.38e-24 | NR | DAT02330.1 | 2832643 | g84723 | i0 | 55.1 | 1 | 89 | 40 | 100 | 0 | 267 | 1 | 187 | 275 | DAT02330.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 267 | 106 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32030183 | 32030183 | PRJNA1123436_P_NODE_120798_length_243_cov_0.905882_g119584_i0 | PRJNA1123436 | 120798 | 243 | 0.905882 | 2.20129326 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 72.8 | 2.51e-13 | NR | CAB4196795.1 | 2100421 | g119584 | i0 | 44.3 | 0.975308641975309 | 79 | 40 | 96.3 | 2 | 242 | 9 | 78 | 153 | CAB4196795.1 hypothetical protein UFOVP1290_315 [uncultured Caudovirales phage] | diamond | 237 | 72.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32219993 | 32219993 | PRJNA1123436_P_NODE_117878_length_244_cov_0.900585_g116664_i0 | PRJNA1123436 | 117878 | 244 | 0.900585 | 2.1974274 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 80.1 | 2.7e-15 | NR | CAB4131346.1 | 2100421 | g116664 | i0 | 63.2 | 0.934426229508197 | 76 | 27 | 92.2 | 1 | 231 | 7 | 478 | 553 | CAB4131346.1 hypothetical protein UFOVP120_82, partial [uncultured Caudovirales phage] | diamond | 228 | 80.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32441710 | 32441710 | PRJNA1123436_P_NODE_102939_length_249_cov_0.875000_g101725_i0 | PRJNA1123436 | 102939 | 249 | 0.875 | 2.17875 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 44.3 | 0.011 | NR | CAB5194552.1 | 2100421 | g101725 | i0 | 37.9 | 0.698795180722892 | 58 | 36 | 69.9 | 0 | 248 | 75 | 203 | 260 | CAB5194552.1 hypothetical protein UFOVP168_9 [uncultured Caudovirales phage] | diamond | 174 | 44.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32504873 | 32504873 | PRJNA1123436_P_NODE_103399_length_249_cov_0.875000_g102185_i0 | PRJNA1123436 | 103399 | 249 | 0.875 | 2.17875 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 81.6 | 7.71e-16 | NR | CAB4196818.1 | 2100421 | g102185 | i0 | 44.4 | 0.975903614457831 | 81 | 45 | 97.6 | 0 | 247 | 5 | 357 | 437 | CAB4196818.1 hypothetical protein UFOVP1290_338 [uncultured Caudovirales phage] | diamond | 243 | 81.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32809023 | 32809023 | PRJNA1123436_P_NODE_102660_length_249_cov_0.875000_g101446_i0 | PRJNA1123436 | 102660 | 249 | 0.875 | 2.17875 | root | 1 | Root_unresolved | Root_unresolved | 41.6 | 0.00905 | NR | BAR16039.1 | 1407671 | g101446 | i0 | 45 | 1.2289156626506 | 40 | 22 | 48.2 | 0 | 69 | 188 | 9 | 48 | BAR16039.1 hypothetical protein [uncultured Mediterranean phage uvMED] | diamond | 306 | 41.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | uncultured Mediterranean phage uvMED |
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);;