contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA688931" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27599533 | 27599533 | PRJNA688931_P_NODE_30684_length_183_cov_1.365672_g30471_i0 | PRJNA688931 | 30684 | 183 | 1.365672 | 2.49917976 | Vandenendeviridae | 3424680 | Viruses | Viruses | 112 | 1.51e-29 | NR | YP_010766635.1 | 2873460 | g30471 | i0 | 90.7 | 2.65573770491803 | 54 | 5 | 88.5 | 0 | 182 | 21 | 15 | 68 | YP_010766635.1 endolysin [Pseudomonas phage M5.1] | diamond | 486 | 112 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Kremarvirus | Kremarvirus M51 | |||
| 27619502 | 27619502 | PRJNA688931_P_NODE_35724_length_168_cov_1.462185_g35511_i0 | PRJNA688931 | 35724 | 168 | 1.462185 | 2.4564708 | Myoviridae sp. ctThM1 | 2656730 | Viruses | Viruses | 92 | 4.539999999999999e-23 | NR | QGH72617.1 | 2656730 | g35511 | i0 | 84.8 | 0.821428571428571 | 46 | 7 | 82.1 | 0 | 138 | 1 | 1 | 46 | QGH72617.1 MAG: hypothetical protein [Myoviridae sp. ctThM1] | diamond | 138 | 92 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Myoviridae sp. ctThM1 | |||||
| 28010012 | 28010012 | PRJNA688931_P_NODE_36885_length_167_cov_1.050847_g36672_i0 | PRJNA688931 | 36885 | 167 | 1.050847 | 1.75491449 | Otagovirus | 2560197 | Viruses | Viruses | 51.6 | 7.76e-7 | NR | UAV90041.1 | 2873461 | g36672 | i0 | 48.8 | 1.47305389221557 | 41 | 21 | 73.7 | 0 | 140 | 18 | 1 | 41 | UAV90041.1 hypothetical protein REC_192 [Pseudomonas phage REC] | diamond | 246 | 52 | 0.992307692307692 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Otagovirus | Pseudomonas phage REC | |||
| 28945771 | 28945771 | PRJNA688931_P_NODE_42728_length_163_cov_0.877193_g42515_i0 | PRJNA688931 | 42728 | 163 | 0.877193 | 1.42982459 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.6 | 5.2e-14 | NR | XOR43005.1 | 2832643 | g42515 | i0 | 74.1 | 0.993865030674847 | 54 | 14 | 99.4 | 0 | 1 | 162 | 10 | 63 | XOR43005.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 162 | 73.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29135214 | 29135214 | PRJNA688931_P_NODE_4309_length_539_cov_2.504082_g4101_i0 | PRJNA688931 | 4309 | 539 | 2.504082 | 13.49700198 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 149 | 1.31e-39 | NR | YP_010803269.1 | 3060017 | g4101 | i0 | 49.3 | 0.768089053803339 | 138 | 70 | 76.8 | 0 | 535 | 122 | 276 | 413 | YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense] | diamond | 414 | 149 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 29450443 | 29450443 | PRJNA688931_P_NODE_370_length_1520_cov_6.359619_g325_i0 | PRJNA688931 | 370 | 1520 | 6.359619 | 96.6662088 | Thelebolus microsporus partitivirus 1 | 2501047 | Viruses | Viruses | 248 | 4.79e-72 | NR | AZT88598.1 | 2501047 | g325 | i0 | 36.1 | 8.38618421052632 | 446 | 258 | 86.1 | 7 | 1415 | 108 | 63 | 491 | AZT88598.1 RNA-dependent RNA polymerase [Thelebolus microsporus partitivirus 1] | diamond | 12747 | 248 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Thelebolus microsporus partitivirus 1 | |||
| 29461868 | 29461868 | PRJNA688931_P_NODE_20950_length_223_cov_2.890805_g20737_i0 | PRJNA688931 | 20950 | 223 | 2.890805 | 6.44649515 | Mimiviridae | 549779 | Viruses | Viruses | 101 | 3.37e-23 | NR | ARF12269.1 | 1977640 | g20737 | i0 | 52.1 | 1.97757847533632 | 73 | 35 | 98.2 | 0 | 4 | 222 | 22 | 94 | ARF12269.1 ornithine decarboxylase [Klosneuvirus KNV1] | diamond | 441 | 101 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Klosneuvirus | Klosneuvirus KNV1 | ||
| 29861176 | 29861176 | PRJNA688931_P_NODE_42251_length_163_cov_0.903509_g42038_i0 | PRJNA688931 | 42251 | 163 | 0.903509 | 1.47271967 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 42 | 0.0127 | NR | CAB4132255.1 | 2100421 | g42038 | i0 | 45.7 | 0.846625766871166 | 46 | 24 | 82.8 | 1 | 29 | 163 | 1 | 46 | CAB4132255.1 hypothetical protein UFOVP248_4 [uncultured Caudovirales phage] | diamond | 138 | 42 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30524620 | 30524620 | PRJNA688931_P_NODE_39353_length_165_cov_0.913793_g39140_i0 | PRJNA688931 | 39353 | 165 | 0.913793 | 1.50775845 | Pseudomonas phage REC | 2873461 | Viruses | Viruses | 62 | 1.9e-10 | NR | UAV89899.1 | 2873461 | g39140 | i0 | 90 | 0.545454545454545 | 30 | 3 | 54.5 | 0 | 75 | 164 | 1 | 30 | UAV89899.1 polynucleotide kinase [Pseudomonas phage REC] | diamond | 90 | 62 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Otagovirus | Pseudomonas phage REC | |||
| 30682432 | 30682432 | PRJNA688931_P_NODE_44113_length_161_cov_3.000000_g43900_i0 | PRJNA688931 | 44113 | 161 | 3 | 4.83 | Rhizopus microsporus narnavirus 3 | 3156534 | Viruses | Viruses | 107 | 1.49e-25 | NR | BFM51658.1 | 3156534 | g43900 | i0 | 90.6 | 0.987577639751553 | 53 | 5 | 98.8 | 0 | 1 | 159 | 471 | 523 | BFM51658.1 RNA-dependent RNA polymerase [Rhizopus microsporus narnavirus 3] | diamond | 159 | 107 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Rhizopus microsporus narnavirus 3 | ||
| 30777469 | 30777469 | PRJNA688931_P_NODE_28414_length_191_cov_1.091549_g28201_i0 | PRJNA688931 | 28414 | 191 | 1.091549 | 2.08485859 | Catovirus CTV1 | 1977631 | Viruses | Viruses | 67.8 | 2.71e-11 | NR | ARF08384.1 | 1977631 | g28201 | i0 | 50.8 | 0.989528795811518 | 63 | 31 | 99 | 0 | 191 | 3 | 344 | 406 | ARF08384.1 choline dehydrogenase / GMC-type oxidoreductase [Catovirus CTV1] | diamond | 189 | 67.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus CTV1 | ||
| 30872119 | 30872119 | PRJNA688931_P_NODE_1834_length_836_cov_3.289708_g1681_i0 | PRJNA688931 | 1834 | 836 | 3.289708 | 27.50195888 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 409 | 1.06e-139 | NR | YP_010803269.1 | 3060017 | g1681 | i0 | 69.1 | 0.997607655502392 | 278 | 85 | 99.8 | 1 | 835 | 2 | 85 | 361 | YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense] | diamond | 834 | 409 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 30872162 | 30872162 | PRJNA688931_P_NODE_44574_length_154_cov_2.571429_g44361_i0 | PRJNA688931 | 44574 | 154 | 2.571429 | 3.96000066 | Pseudomonas phage vB_PsyM_KIL1 | 1777065 | Viruses | Viruses | 60.1 | 2.82e-9 | NR | YP_009276064.1 | 1777065 | g44361 | i0 | 77.4 | 0.603896103896104 | 31 | 7 | 60.4 | 0 | 152 | 60 | 29 | 59 | YP_009276064.1 hypothetical protein BH774_gp067 [Pseudomonas phage vB_PsyM_KIL1] | diamond | 93 | 60.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Flaumdravirus | Flaumdravirus KIL4 | |||
| 31251294 | 31251294 | PRJNA688931_P_NODE_18135_length_241_cov_1.083333_g17922_i0 | PRJNA688931 | 18135 | 241 | 1.083333 | 2.61083253 | Downy mildew lesion associated splipalmivirus 4 | 2719525 | Viruses | Viruses | 52.4 | 1.02e-5 | NR | WNA22213.1 | 2719525 | g17922 | i0 | 40 | 0.746887966804979 | 60 | 35 | 74.7 | 1 | 182 | 3 | 40 | 98 | WNA22213.1 MAG: hypothetical protein [Downy mildew lesion associated splipalmivirus 4] | diamond | 180 | 52.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Jakapalmivirus | Jakapalmivirus italiense | ||
| 31630868 | 31630868 | PRJNA688931_P_NODE_30396_length_184_cov_1.259259_g30183_i0 | PRJNA688931 | 30396 | 184 | 1.259259 | 2.31703656 | Pseudomonas phage vB_PseuGesM_254 | 3092638 | Viruses | Viruses | 48.9 | 1.22e-5 | NR | WOZ57421.1 | 3092638 | g30183 | i0 | 41.5 | 0.864130434782609 | 53 | 29 | 83.2 | 1 | 6 | 158 | 32 | 84 | WOZ57421.1 hypothetical protein [Pseudomonas phage vB_PseuGesM_254] | diamond | 159 | 48.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Chemalvirus | Chemalvirus PseuGes254 | |||
| 31788837 | 31788837 | PRJNA688931_P_NODE_14237_length_274_cov_1.982222_g14024_i0 | PRJNA688931 | 14237 | 274 | 1.982222 | 5.43128828 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 45.1 | 0.00244 | NR | DAS36713.1 | 2832643 | g14024 | i0 | 36.2 | 0.755474452554745 | 69 | 40 | 71.2 | 2 | 33 | 227 | 25 | 93 | DAS36713.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 207 | 45.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31978833 | 31978833 | PRJNA688931_P_NODE_31378_length_180_cov_2.564885_g31165_i0 | PRJNA688931 | 31378 | 180 | 2.564885 | 4.616793 | Pseudomonas phage vB_PpS_SYP | 3020390 | Viruses | Viruses | 53.1 | 1.46e-6 | NR | WCO82025.1 | 3020390 | g31165 | i0 | 58 | 0.833333333333333 | 50 | 21 | 83.3 | 0 | 4 | 153 | 127 | 176 | WCO82025.1 hypothetical protein vBPpSSYP_43 [Pseudomonas phage vB_PpS_SYP] | diamond | 150 | 53.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage vB_PpS_SYP |
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);;