contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJEB81463" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12893829 | 12893829 | PRJEB81463_P_NODE_11391_length_301_cov_1.368421_g11119_i0 | PRJEB81463 | 11391 | 301 | 1.368421 | 4.11894721 | uncultured virus | 340016 | Viruses | Viruses | 165 | 3.0399999999999995e-47 | NR | CAH6419174.1 | 340016 | g11119 | i0 | 79.8 | 0.98671096345515 | 99 | 20 | 98.7 | 0 | 299 | 3 | 69 | 167 | CAH6419174.1 S-adenosylmethionine synthetase [uncultured virus] | diamond | 297 | 165 | 1 | Viruses | uncultured virus | ||||||||
| 16717009 | 16717009 | PRJEB81463_P_NODE_12414_length_291_cov_1.417431_g12142_i0 | PRJEB81463 | 12414 | 291 | 1.417431 | 4.12472421 | Edafosvirus sp. | 2487765 | Viruses | Viruses | 129 | 3.91e-33 | NR | AYV78014.1 | 2487765 | g12142 | i0 | 66 | 0.969072164948454 | 94 | 31 | 96.9 | 1 | 286 | 5 | 186 | 278 | AYV78014.1 MAG: elongation factor 1 alpha long form [Edafosvirus sp.] | diamond | 282 | 129 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Edafosvirus sp. | |||
| 26654138 | 26654138 | PRJEB81463_P_NODE_30861_length_200_cov_4.850394_g30589_i0 | PRJEB81463 | 30861 | 200 | 4.850394 | 9.700788 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 109 | 4.58e-27 | NR | DAQ55194.1 | 2832643 | g30589 | i0 | 81.5 | 1.965 | 65 | 12 | 97.5 | 0 | 198 | 4 | 137 | 201 | DAQ55194.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 393 | 109 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26685981 | 26685981 | PRJEB81463_P_NODE_21801_length_251_cov_0.876404_g21529_i0 | PRJEB81463 | 21801 | 251 | 0.876404 | 2.19977404 | environmental Halophage eHP-27 | 1168828 | Viruses | Viruses | 97.4 | 1.21e-21 | NR | AFH22463.1 | 1168828 | g21529 | i0 | 68.2 | 0.788844621513944 | 66 | 21 | 78.9 | 0 | 53 | 250 | 71 | 136 | AFH22463.1 hypothetical protein OSG_eHP27_00055 [environmental Halophage eHP-27] | diamond | 198 | 97.4 | 1 | Viruses | environmental Halophage eHP-27 | ||||||||
| 26748980 | 26748980 | PRJEB81463_P_NODE_6561_length_391_cov_1.364780_g6289_i0 | PRJEB81463 | 6561 | 391 | 1.36478 | 5.3362898 | Haloquadratum phage sp. | 2768784 | Viruses | Viruses | 75.1 | 3.89e-15 | NR | UXF50848.1 | 2768784 | g6289 | i0 | 66.7 | 0.437340153452685 | 57 | 19 | 43.7 | 0 | 3 | 173 | 5 | 61 | UXF50848.1 MAG: hypothetical protein HQRvContig01_40 [Haloquadratum phage sp.] | diamond | 171 | 75.1 | 1 | Viruses | Haloquadratum phage sp. | ||||||||
| 27034247 | 27034247 | PRJEB81463_P_NODE_18182_length_261_cov_3.297872_g17910_i0 | PRJEB81463 | 18182 | 261 | 3.297872 | 8.60744592 | Siphoviridae sp. ctZHD14 | 2827891 | Viruses | Viruses | 132 | 3.49e-34 | NR | DAF55171.1 | 2827891 | g17910 | i0 | 73.6 | 2.88505747126437 | 87 | 23 | 100 | 0 | 1 | 261 | 364 | 450 | DAF55171.1 MAG TPA: DNA TOPOISOMERASE IV, B SUBUNIT [Siphoviridae sp. ctZHD14] | diamond | 753 | 132 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctZHD14 | |||||
| 27097427 | 27097427 | PRJEB81463_P_NODE_10082_length_317_cov_3.631148_g9810_i0 | PRJEB81463 | 10082 | 317 | 3.631148 | 11.51073916 | Harvfovirus sp. | 2487768 | Viruses | Viruses | 71.2 | 6.25e-13 | NR | AYV81692.1 | 2487768 | g9810 | i0 | 37.9 | 0.974763406940063 | 103 | 63 | 97.5 | 1 | 317 | 9 | 51 | 152 | AYV81692.1 MAG: putative eukaryotic translation initiation factor 5A-1 [Harvfovirus sp.] | diamond | 309 | 71.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Harvfovirus sp. | |||
| 27128676 | 27128676 | PRJEB81463_P_NODE_4462_length_475_cov_2.323383_g4191_i0 | PRJEB81463 | 4462 | 475 | 2.323383 | 11.03606925 | Homavirus sp. | 2487769 | Viruses | Viruses | 197 | 2.54e-59 | NR | AYV82419.1 | 2487769 | g4191 | i0 | 56 | 6.00631578947368 | 159 | 68 | 99.8 | 2 | 1 | 474 | 46 | 203 | AYV82419.1 MAG: elongation factor 1-alpha-like protein [Homavirus sp.] | diamond | 2853 | 197 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Homavirus sp. | |||
| 27413820 | 27413820 | PRJEB81463_P_NODE_23843_length_248_cov_0.891429_g23571_i0 | PRJEB81463 | 23843 | 248 | 0.891429 | 2.21074392 | environmental Halophage eHP-28 | 1168829 | Viruses | Viruses | 99.4 | 2.2700000000000003e-22 | NR | AFH22511.1 | 1168829 | g23571 | i0 | 73.8 | 0.737903225806452 | 61 | 16 | 73.8 | 0 | 6 | 188 | 24 | 84 | AFH22511.1 hypothetical protein OSG_eHP28_00095 [environmental Halophage eHP-28] | diamond | 183 | 99.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Kirjokansivirales | Shortaselviridae | environmental Halophage eHP-28 | |||
| 27445417 | 27445417 | PRJEB81463_P_NODE_26303_length_244_cov_1.812865_g26031_i0 | PRJEB81463 | 26303 | 244 | 1.812865 | 4.4233906 | Pithovirus LCPAC1 | 2506587 | Viruses | Viruses | 47 | 0.00117 | NR | QBK90293.1 | 2506587 | g26031 | i0 | 36.5 | 0.774590163934426 | 63 | 37 | 77.5 | 1 | 27 | 215 | 21 | 80 | QBK90293.1 MAG: hypothetical protein LCPAC102_02060 [Pithovirus LCPAC102] | diamond | 189 | 47 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC102 | |||||||
| 27508440 | 27508440 | PRJEB81463_P_NODE_26743_length_244_cov_0.912281_g26471_i0 | PRJEB81463 | 26743 | 244 | 0.912281 | 2.22596564 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 57.4 | 2.49e-7 | NR | CAB4135888.1 | 2100421 | g26471 | i0 | 46.1 | 0.934426229508197 | 76 | 33 | 93.4 | 1 | 236 | 9 | 1 | 68 | CAB4135888.1 hypothetical protein UFOVP300_2 [uncultured Caudovirales phage] | diamond | 228 | 57.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27571405 | 27571405 | PRJEB81463_P_NODE_23864_length_248_cov_0.891429_g23592_i0 | PRJEB81463 | 23864 | 248 | 0.891429 | 2.21074392 | Siphoviridae sp. ctZHD14 | 2827891 | Viruses | Viruses | 122 | 3.6699999999999995e-30 | NR | DAF55203.1 | 2827891 | g23592 | i0 | 65.9 | 0.991935483870968 | 82 | 28 | 99.2 | 0 | 246 | 1 | 603 | 684 | DAF55203.1 MAG TPA: protein of unknown function (DUF5048) [Siphoviridae sp. ctZHD14] | diamond | 246 | 122 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctZHD14 | |||||
| 27792580 | 27792580 | PRJEB81463_P_NODE_27844_length_242_cov_1.739645_g27572_i0 | PRJEB81463 | 27844 | 242 | 1.739645 | 4.2099409 | Satyrvirus sp. | 2487771 | Viruses | Viruses | 91.3 | 7.4e-20 | NR | AYV85455.1 | 2487771 | g27572 | i0 | 52.5 | 1.98347107438017 | 80 | 38 | 99.2 | 0 | 2 | 241 | 129 | 208 | AYV85455.1 MAG: protein phosphatase 2C domain containing protein [Satyrvirus sp.] | diamond | 480 | 91.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Satyrvirus sp. | |||
| 27855522 | 27855522 | PRJEB81463_P_NODE_14025_length_282_cov_1.488038_g13753_i0 | PRJEB81463 | 14025 | 282 | 1.488038 | 4.19626716 | Pacmanvirus S19 | 2862371 | Viruses | Viruses | 78.2 | 9.5e-15 | NR | QYB17578.1 | 2862371 | g13753 | i0 | 43.5 | 1.97872340425532 | 92 | 51 | 97.9 | 1 | 282 | 7 | 123 | 213 | QYB17578.1 hypothetical protein PV-S19_0214 [Pacmanvirus S19] | diamond | 558 | 78.2 | 1 | Viruses | Pacmanvirus S19 | ||||||||
| 27981937 | 27981937 | PRJEB81463_P_NODE_25525_length_245_cov_1.813953_g25253_i0 | PRJEB81463 | 25525 | 245 | 1.813953 | 4.44418485 | Prokaryotic dsDNA virus sp. | 2591644 | Viruses | Viruses | 110 | 2.94e-26 | NR | QDP66585.1 | 2591644 | g25253 | i0 | 61.7 | 0.991836734693878 | 81 | 31 | 99.2 | 0 | 2 | 244 | 29 | 109 | QDP66585.1 MAG: putative capsid assembly protease C [Prokaryotic dsDNA virus sp.] | diamond | 243 | 110 | 1 | Viruses | Prokaryotic dsDNA virus sp. | ||||||||
| 28258575 | 28258575 | PRJEB81463_P_NODE_13886_length_283_cov_1.214286_g13614_i0 | PRJEB81463 | 13886 | 283 | 1.214286 | 3.43642938 | Viruses | 10239 | Viruses | Viruses | 59.7 | 1.76e-9 | NR | YP_009808315.1 | 2301696 | g13614 | i0 | 68.4 | 1.28268551236749 | 38 | 12 | 40.3 | 0 | 127 | 14 | 5 | 42 | YP_009808315.1 hypothetical protein HOT93_gp072 [Gordonia phage Horus] | diamond | 363 | 60.1 | 0.993344425956739 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Horusvirus | Horusvirus horus | ||||
| 28645059 | 28645059 | PRJEB81463_P_NODE_25607_length_245_cov_1.476744_g25335_i0 | PRJEB81463 | 25607 | 245 | 1.476744 | 3.6180228 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 63.5 | 9.19e-10 | NR | XOS47170.1 | 2832643 | g25335 | i0 | 90 | 0.36734693877551 | 30 | 3 | 36.7 | 0 | 241 | 152 | 222 | 251 | XOS47170.1 MAG: putative PhoH-like protein [Caudoviricetes sp.] | diamond | 90 | 63.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28929133 | 28929133 | PRJEB81463_P_NODE_19848_length_254_cov_1.292818_g19576_i0 | PRJEB81463 | 19848 | 254 | 1.292818 | 3.28375772 | Haloquadratum phage sp. | 2768784 | Viruses | Viruses | 87 | 1.11e-17 | NR | UXF50794.1 | 2768784 | g19576 | i0 | 69.6 | 1.7007874015748 | 56 | 17 | 66.1 | 0 | 5 | 172 | 131 | 186 | UXF50794.1 MAG: DNA primase [Haloquadratum phage sp.] | diamond | 432 | 87 | 1 | Viruses | Haloquadratum phage sp. | ||||||||
| 29307920 | 29307920 | PRJEB81463_P_NODE_3269_length_556_cov_2.039337_g3001_i0 | PRJEB81463 | 3269 | 556 | 2.039337 | 11.33871372 | Haloquadratum phage sp. | 2768784 | Viruses | Viruses | 199 | 3.95e-61 | NR | UXF50978.1 | 2768784 | g3001 | i0 | 65 | 0.847122302158273 | 157 | 54 | 84.7 | 1 | 555 | 85 | 52 | 207 | UXF50978.1 MAG: resolvase [Haloquadratum phage sp.] | diamond | 471 | 199 | 1 | Viruses | Haloquadratum phage sp. | ||||||||
| 30065773 | 30065773 | PRJEB81463_P_NODE_20892_length_252_cov_0.871508_g20620_i0 | PRJEB81463 | 20892 | 252 | 0.871508 | 2.19620016 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 127 | 4.81e-34 | NR | XOE95038.1 | 2832643 | g20620 | i0 | 75.3 | 1.92857142857143 | 81 | 20 | 96.4 | 0 | 243 | 1 | 1 | 81 | XOE95038.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 486 | 127 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30855727 | 30855727 | PRJEB81463_P_NODE_22314_length_250_cov_0.881356_g22042_i0 | PRJEB81463 | 22314 | 250 | 0.881356 | 2.20339 | Prokaryotic dsDNA virus sp. | 2591644 | Viruses | Viruses | 135 | 2.4699999999999996e-35 | NR | QDP66584.1 | 2591644 | g22042 | i0 | 88 | 0.9 | 75 | 9 | 90 | 0 | 250 | 26 | 340 | 414 | QDP66584.1 MAG: putative portal protein [Prokaryotic dsDNA virus sp.] | diamond | 225 | 135 | 1 | Viruses | Prokaryotic dsDNA virus sp. | ||||||||
| 31709405 | 31709405 | PRJEB81463_P_NODE_26377_length_244_cov_1.543860_g26105_i0 | PRJEB81463 | 26377 | 244 | 1.54386 | 3.7670184 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 95.9 | 7.45e-21 | NR | DAG25138.1 | 2832643 | g26105 | i0 | 59.3 | 0.995901639344262 | 81 | 30 | 95.9 | 2 | 241 | 8 | 158 | 238 | DAG25138.1 MAG TPA: DNA directed DNA polymerase [Caudoviricetes sp.] | diamond | 243 | 95.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32279092 | 32279092 | PRJEB81463_P_NODE_28199_length_242_cov_0.923077_g27927_i0 | PRJEB81463 | 28199 | 242 | 0.923077 | 2.23384634 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 60.1 | 6.82e-10 | NR | XOR78549.1 | 2832643 | g27927 | i0 | 51.5 | 0.818181818181818 | 66 | 29 | 80.6 | 2 | 231 | 37 | 1 | 64 | XOR78549.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 198 | 60.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32405526 | 32405526 | PRJEB81463_P_NODE_20359_length_253_cov_0.866667_g20087_i0 | PRJEB81463 | 20359 | 253 | 0.866667 | 2.19266751 | environmental Halophage eHP-27 | 1168828 | Viruses | Viruses | 146 | 6.94e-41 | NR | AFH22459.1 | 1168828 | g20087 | i0 | 80.5 | 0.972332015810277 | 82 | 15 | 97.2 | 1 | 251 | 6 | 62 | 142 | AFH22459.1 hypothetical protein OSG_eHP27_00035 [environmental Halophage eHP-27] | diamond | 246 | 146 | 1 | Viruses | environmental Halophage eHP-27 | ||||||||
| 32563913 | 32563913 | PRJEB81463_P_NODE_25919_length_245_cov_0.906977_g25647_i0 | PRJEB81463 | 25919 | 245 | 0.906977 | 2.22209365 | Pseudomonas phage UAntarctica | 2856996 | Viruses | Viruses | 52.8 | 4.1e-7 | NR | QYW06418.1 | 2856996 | g25647 | i0 | 48.8 | 0.52653061224489806 | 43 | 22 | 52.7 | 0 | 103 | 231 | 3 | 45 | QYW06418.1 hypothetical protein uan_006 [Pseudomonas phage UAntarctica] | diamond | 129 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage UAntarctica | |||||
| 32808213 | 32808213 | PRJEB81463_P_NODE_7740_length_361_cov_1.885417_g7468_i0 | PRJEB81463 | 7740 | 361 | 1.885417 | 6.80635537 | Chuvivirus | 2842604 | Viruses | Viruses | 162 | 9.56e-45 | NR | UVF58769.1 | 2842604 | g7468 | i0 | 61.3 | 2.96675900277008 | 119 | 46 | 98.9 | 0 | 4 | 360 | 288 | 406 | UVF58769.1 MAG: S protein [Salarius guttatus piscichuvirus] | diamond | 1071 | 162 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | Chuvivirus |
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);;