contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA1067370" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 180599 | 180599 | PRJNA1067370_P_NODE_111561_length_242_cov_0.911243_g111012_i0 | PRJNA1067370 | 111561 | 242 | 0.911243 | 2.20520806 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 70.9 | 3.59e-12 | NR | XOR08214.1 | 2832643 | g111012 | i0 | 80 | 0.495867768595041 | 40 | 8 | 49.6 | 0 | 120 | 239 | 1 | 40 | XOR08214.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 120 | 70.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20582218 | 20582218 | PRJNA1067370_P_NODE_78817_length_251_cov_2.359551_g78268_i0 | PRJNA1067370 | 78817 | 251 | 2.359551 | 5.92247301 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 150 | 1.1299999999999998e-41 | NR | QHJ79729.1 | 2832643 | g78268 | i0 | 89 | 0.9800796812749 | 82 | 9 | 98 | 0 | 2 | 247 | 310 | 391 | QHJ79729.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 246 | 150 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26655479 | 26655479 | PRJNA1067370_P_NODE_73661_length_259_cov_1.575269_g73112_i0 | PRJNA1067370 | 73661 | 259 | 1.575269 | 4.07994671 | Salmonella phage vB_SenS-EnJE6 | 2603849 | Viruses | Viruses | 123 | 1.11e-33 | NR | YP_010747040.1 | 2603849 | g73112 | i0 | 70.4 | 0.938223938223938 | 81 | 24 | 93.8 | 0 | 245 | 3 | 40 | 120 | YP_010747040.1 HNH endonuclease [Salmonella phage vB_SenS-EnJE6] | diamond | 243 | 123 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Jerseyvirus | Jerseyvirus EnJE6 | |||
| 27003743 | 27003743 | PRJNA1067370_P_NODE_22342_length_401_cov_1.362805_g21794_i0 | PRJNA1067370 | 22342 | 401 | 1.362805 | 5.46484805 | Hafnia phage TS33 | 3110108 | Viruses | Viruses | 214 | 3.51e-62 | NR | WQY91225.1 | 3110108 | g21794 | i0 | 82 | 0.99501246882793 | 133 | 24 | 99.5 | 0 | 2 | 400 | 308 | 440 | WQY91225.1 hypothetical protein [Hafnia phage TS33] | diamond | 399 | 214 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Hafnia phage TS33 | ||||
| 27161834 | 27161834 | PRJNA1067370_P_NODE_91002_length_248_cov_0.880000_g90453_i0 | PRJNA1067370 | 91002 | 248 | 0.88 | 2.1824 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 157 | 8.749999999999999e-43 | NR | DAQ80061.1 | 2832643 | g90453 | i0 | 98.8 | 0.979838709677419 | 81 | 1 | 98 | 0 | 1 | 243 | 265 | 345 | DAQ80061.1 MAG TPA: tail protein, partial [Caudoviricetes sp.] | diamond | 243 | 157 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27446711 | 27446711 | PRJNA1067370_P_NODE_72703_length_260_cov_2.818182_g72154_i0 | PRJNA1067370 | 72703 | 260 | 2.818182 | 7.3272732 | Salmonella phage vB_SalM-LPST94 | 2282399 | Viruses | Viruses | 156 | 2.9299999999999996e-42 | NR | AXF41693.1 | 2282399 | g72154 | i0 | 92.9 | 0.969230769230769 | 84 | 6 | 96.9 | 0 | 257 | 6 | 558 | 641 | AXF41693.1 hypothetical protein LPST94_00131 [Salmonella phage vB_SalM-LPST94] | diamond | 252 | 156 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Ackermannviridae | Kuttervirus | Salmonella phage vB_SalM-LPST94 | ||
| 27501443 | 27501443 | PRJNA1067370_P_NODE_87303_length_249_cov_0.875000_g86754_i0 | PRJNA1067370 | 87303 | 249 | 0.875 | 2.17875 | Viruses | 10239 | Viruses | Viruses | 74.3 | 3.08e-13 | NR | QVD49250.1 | 2829408 | g86754 | i0 | 50 | 1.96385542168675 | 82 | 41 | 98.8 | 0 | 249 | 4 | 334 | 415 | QVD49250.1 hypothetical protein LUCX_180 [Xanthomonas phage vB_XciM_LucasX] | diamond | 489 | 74.7 | 0.994645247657296 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Xanthomonas phage vB_XciM_LucasX | |||||
| 28046373 | 28046373 | PRJNA1067370_P_NODE_98605_length_246_cov_0.890173_g98056_i0 | PRJNA1067370 | 98605 | 246 | 0.890173 | 2.18982558 | Acinetobacter phage Phab24 | 2855484 | Viruses | Viruses | 49.3 | 9.5e-5 | NR | QXM18455.1 | 2855484 | g98056 | i0 | 44.7 | 0.573170731707317 | 47 | 26 | 57.3 | 0 | 4 | 144 | 129 | 175 | QXM18455.1 structural protein [Acinetobacter phage Phab24] | diamond | 141 | 49.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Acinetobacter phage Phab24 | |||||
| 28298864 | 28298864 | PRJNA1067370_P_NODE_48366_length_300_cov_1.356828_g47818_i0 | PRJNA1067370 | 48366 | 300 | 1.356828 | 4.070484 | uncultured Mediterranean phage uvMED | 1407671 | Viruses | Viruses | 43.9 | 0.0273 | NR | BAR31668.1 | 1407671 | g47818 | i0 | 40.3 | 1.44 | 72 | 40 | 71 | 2 | 275 | 63 | 223 | 292 | BAR31668.1 spry domain protein [uncultured Mediterranean phage uvMED] | diamond | 432 | 43.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | uncultured Mediterranean phage uvMED | |||||
| 28330410 | 28330410 | PRJNA1067370_P_NODE_28846_length_361_cov_1.402778_g28298_i0 | PRJNA1067370 | 28846 | 361 | 1.402778 | 5.06402858 | Hafnia phage TS33 | 3110108 | Viruses | Viruses | 195 | 1.72e-57 | NR | WQY91229.1 | 3110108 | g28298 | i0 | 79.3 | 1.00554016620499 | 121 | 24 | 99.7 | 1 | 1 | 360 | 179 | 299 | WQY91229.1 62kDa structural protein [Hafnia phage TS33] | diamond | 363 | 195 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Hafnia phage TS33 | ||||
| 28606309 | 28606309 | PRJNA1067370_P_NODE_95587_length_246_cov_1.780347_g95038_i0 | PRJNA1067370 | 95587 | 246 | 1.780347 | 4.37965362 | Viruses | 10239 | Viruses | Viruses | 48.9 | 2.03e-5 | NR | AXN57962.1 | 2282400 | g95038 | i0 | 39.7 | 2.82926829268293 | 58 | 35 | 70.7 | 0 | 2 | 175 | 15 | 72 | AXN57962.1 putative membrane protein [Acinetobacter phage ABPH49] | diamond | 696 | 48.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Acinetobacter phage ABPH49 | |||||
| 28614768 | 28614768 | PRJNA1067370_P_NODE_83847_length_250_cov_0.870056_g83298_i0 | PRJNA1067370 | 83847 | 250 | 0.870056 | 2.17514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 108 | 2.94e-25 | NR | AXH72798.1 | 2832643 | g83298 | i0 | 63 | 0.972 | 81 | 30 | 97.2 | 0 | 243 | 1 | 4 | 84 | AXH72798.1 MAG: structural protein [Caudoviricetes sp.] | diamond | 243 | 108 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29120030 | 29120030 | PRJNA1067370_P_NODE_17869_length_441_cov_1.790761_g17321_i0 | PRJNA1067370 | 17869 | 441 | 1.790761 | 7.89725601 | Virus Rctr197k | 1924548 | Viruses | Viruses | 72 | 1.58e-11 | NR | APU88843.1 | 1924548 | g17321 | i0 | 50 | 0.91156462585034 | 70 | 35 | 47.6 | 0 | 215 | 6 | 41 | 110 | APU88843.1 conserved hypothetical protein [Virus Rctr197k] | diamond | 402 | 72 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Virus Rctr197k | |||||
| 29183243 | 29183243 | PRJNA1067370_P_NODE_85589_length_249_cov_1.715909_g85040_i0 | PRJNA1067370 | 85589 | 249 | 1.715909 | 4.27261341 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 108 | 1.5200000000000002e-27 | NR | UOF79436.1 | 2832643 | g85040 | i0 | 69 | 0.855421686746988 | 71 | 22 | 85.5 | 0 | 216 | 4 | 1 | 71 | UOF79436.1 hypothetical protein [Caudoviricetes sp.] | diamond | 213 | 108 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30383602 | 30383602 | PRJNA1067370_P_NODE_56233_length_286_cov_0.840376_g55684_i0 | PRJNA1067370 | 56233 | 286 | 0.840376 | 2.40347536 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 42.7 | 0.0173 | NR | DAZ76384.1 | 2832643 | g55684 | i0 | 58.1 | 0.451048951048951 | 43 | 18 | 45.1 | 0 | 285 | 157 | 1 | 43 | DAZ76384.1 MAG TPA: putative DNA-binding protein [Caudoviricetes sp.] | diamond | 129 | 42.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30635800 | 30635800 | PRJNA1067370_P_NODE_94713_length_247_cov_0.885057_g94164_i0 | PRJNA1067370 | 94713 | 247 | 0.885057 | 2.18609079 | Erythrobacter phage vB_EliS-L | 2909139 | Viruses | Viruses | 73.9 | 1.89e-14 | NR | UIS25310.1 | 2909139 | g94164 | i0 | 54.5 | 0.801619433198381 | 66 | 28 | 77.7 | 2 | 10 | 201 | 80 | 145 | UIS25310.1 hypothetical protein [Erythrobacter phage vB_EliS-L02] | diamond | 198 | 73.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Erythrobacter phage vB_EliS-L02 | |||||
| 31140994 | 31140994 | PRJNA1067370_P_NODE_102875_length_244_cov_0.935673_g102326_i0 | PRJNA1067370 | 102875 | 244 | 0.935673 | 2.28304212 | Hafnia phage TS33 | 3110108 | Viruses | Viruses | 163 | 7.269999999999999e-45 | NR | WQY91228.1 | 3110108 | g102326 | i0 | 92.6 | 0.995901639344262 | 81 | 6 | 99.6 | 0 | 243 | 1 | 81 | 161 | WQY91228.1 DNA polymerase I [Hafnia phage TS33] | diamond | 243 | 163 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Hafnia phage TS33 | ||||
| 31584438 | 31584438 | PRJNA1067370_P_NODE_77036_length_254_cov_1.569061_g76487_i0 | PRJNA1067370 | 77036 | 254 | 1.569061 | 3.98541494 | Serratia phage Eta | 1282995 | Viruses | Viruses | 140 | 1.33e-38 | NR | YP_008130344.1 | 1282995 | g76487 | i0 | 84.5 | 0.992125984251969 | 84 | 13 | 99.2 | 0 | 3 | 254 | 123 | 206 | YP_008130344.1 major head protein [Serratia phage Eta] | diamond | 252 | 140 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Seretavirus | Seretavirus eta | |||
| 31932032 | 31932032 | PRJNA1067370_P_NODE_51617_length_293_cov_1.172727_g51068_i0 | PRJNA1067370 | 51617 | 293 | 1.172727 | 3.43609011 | Shigella phage vB_SboS_Gloob | 2902746 | Viruses | Viruses | 84 | 2.22e-16 | NR | UHS65013.1 | 2902746 | g51068 | i0 | 51.3 | 0.819112627986348 | 80 | 39 | 81.9 | 0 | 242 | 3 | 207 | 286 | UHS65013.1 putative tail spike protein [Shigella phage vB_SboS_Gloob] | diamond | 240 | 84 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Ackermannviridae | Agtrevirus | Shigella phage vB_SboS_Gloob | ||
| 32027155 | 32027155 | PRJNA1067370_P_NODE_85658_length_249_cov_1.596591_g85109_i0 | PRJNA1067370 | 85658 | 249 | 1.596591 | 3.97551159 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 64.3 | 1.01e-9 | NR | CAB4122043.1 | 2100421 | g85109 | i0 | 47.1 | 0.843373493975904 | 70 | 37 | 84.3 | 0 | 1 | 210 | 136 | 205 | CAB4122043.1 SSL2 DNA or RNA helicases of superfamily II [uncultured Caudovirales phage] | diamond | 210 | 64.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32501881 | 32501881 | PRJNA1067370_P_NODE_112559_length_241_cov_1.779762_g112010_i0 | PRJNA1067370 | 112559 | 241 | 1.779762 | 4.28922642 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 73.9 | 1.44e-13 | NR | CAB4154031.1 | 2100421 | g112010 | i0 | 42.9 | 0.95850622406639 | 77 | 40 | 90.9 | 1 | 233 | 15 | 72 | 148 | CAB4154031.1 Thrombospondin type-1 (TSP1) repeat, partial [uncultured Caudovirales phage] | diamond | 231 | 73.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32565334 | 32565334 | PRJNA1067370_P_NODE_9479_length_588_cov_8.110680_g8945_i0 | PRJNA1067370 | 9479 | 588 | 8.11068 | 47.6907984 | uncultured Mediterranean phage uvMED | 1407671 | Viruses | Viruses | 104 | 2.9599999999999993e-24 | NR | BAQ88411.1 | 1407671 | g8945 | i0 | 43.2 | 0.637755102040816 | 125 | 66 | 61.7 | 3 | 91 | 453 | 55 | 178 | BAQ88411.1 phage morphogenesis protein [uncultured Mediterranean phage uvMED] | diamond | 375 | 104 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | uncultured Mediterranean phage uvMED | |||||
| 32722502 | 32722502 | PRJNA1067370_P_NODE_74160_length_258_cov_2.032432_g73611_i0 | PRJNA1067370 | 74160 | 258 | 2.032432 | 5.24367456 | Luteibacter phage vB_LflM-Pluto | 2948611 | Viruses | Viruses | 73.6 | 9.98e-15 | NR | USN16375.1 | 2948611 | g73611 | i0 | 43 | 0.918604651162791 | 79 | 40 | 89.5 | 2 | 242 | 12 | 14 | 89 | USN16375.1 hypothetical protein PLUTO_00590 [Luteibacter phage vB_LflM-Pluto] | diamond | 237 | 73.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lindbergviridae | Plutovirus | Plutovirus pluto |
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);;