contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJEB80557" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3965418 | 3965418 | PRJEB80557_S_NODE_8224_length_314_cov_2.116981_g7828_i0 | PRJEB80557 | 8224 | 314 | 2.116981 | 6.64732034 | Psychrobacter phage D'Alembert | 2891959 | Viruses | Viruses | 70.5 | 4.05e-13 | NR | CAH1193174.1 | 2891959 | g7828 | i0 | 48.6 | 0.668789808917197 | 70 | 36 | 66.9 | 0 | 103 | 312 | 4 | 73 | CAH1193174.1 Hypothetical protein DAL_58 [Psychrobacter phage D'Alembert] | diamond | 210 | 70.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Psychrobacter phage D'Alembert | |||||
| 26685940 | 26685940 | PRJEB80557_S_NODE_1281_length_684_cov_2.280315_g907_i0 | PRJEB80557 | 1281 | 684 | 2.280315 | 15.5973546 | Thermus phage phiYS4 | 407392 | Viruses | Viruses | 338 | 4.049999999999999e-110 | NR | YP_874043.1 | 407392 | g907 | i0 | 69.9 | 0.960526315789474 | 219 | 66 | 96.1 | 0 | 681 | 25 | 64 | 282 | YP_874043.1 hypothetical protein YS40_030 [Thermus phage phiYS40] | diamond | 657 | 338 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thermus phage phiYS40 | |||||
| 27287102 | 27287102 | PRJEB80557_S_NODE_27243_length_185_cov_1.308824_g26847_i0 | PRJEB80557 | 27243 | 185 | 1.308824 | 2.4213244 | Thermus phage phiLo | 2301536 | Viruses | Viruses | 72.4 | 4.98e-13 | NR | AYJ73985.1 | 2301536 | g26847 | i0 | 72.5 | 0.648648648648649 | 40 | 11 | 64.9 | 0 | 60 | 179 | 237 | 276 | AYJ73985.1 hypothetical protein phiLo_133 [Thermus phage phiLo] | diamond | 120 | 72.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thermus phage phiLo | |||||
| 27413787 | 27413787 | PRJEB80557_S_NODE_8143_length_315_cov_2.770677_g7747_i0 | PRJEB80557 | 8143 | 315 | 2.770677 | 8.72763255 | Acinetobacter phage vB_AbaM_B9 | 2163899 | Viruses | Viruses | 53.9 | 7.33e-6 | NR | AWD93219.1 | 2163899 | g7747 | i0 | 43.8 | 0.847619047619048 | 89 | 38 | 84.8 | 3 | 293 | 27 | 175 | 251 | AWD93219.1 ATP-dependent protease subunit [Acinetobacter phage vB_AbaM_B9] | diamond | 267 | 53.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Acinetobacter phage vB_AbaM_B9 | |||||
| 27824135 | 27824135 | PRJEB80557_S_NODE_26244_length_188_cov_1.870504_g25848_i0 | PRJEB80557 | 26244 | 188 | 1.870504 | 3.51654752 | Enterococcus phage vB_EfaM_Ef2.1 | 2546633 | Viruses | Viruses | 55.5 | 5.73e-7 | NR | QBZ69740.1 | 2546633 | g25848 | i0 | 68.6 | 1.11702127659574 | 35 | 11 | 55.9 | 0 | 105 | 1 | 1 | 35 | QBZ69740.1 hypothetical protein [Enterococcus phage vB_EfaM_Ef2.1] | diamond | 210 | 55.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Kochikohdavirus | Enterococcus phage vB_EfaM_Ef2.1 | |||
| 28013604 | 28013604 | PRJEB80557_S_NODE_13045_length_257_cov_1.692308_g12649_i0 | PRJEB80557 | 13045 | 257 | 1.692308 | 4.34923156 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 58.9 | 8.92e-8 | NR | XOR91458.1 | 2832643 | g12649 | i0 | 50 | 0.840466926070039 | 72 | 36 | 84 | 0 | 23 | 238 | 602 | 673 | XOR91458.1 MAG: phage tail tape measure protein [Caudoviricetes sp.] | diamond | 216 | 58.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28044938 | 28044938 | PRJEB80557_S_NODE_33005_length_169_cov_1.550000_g32609_i0 | PRJEB80557 | 33005 | 169 | 1.55 | 2.6195 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 70.9 | 1.59e-12 | NR | DAS84513.1 | 2832643 | g32609 | i0 | 70.6 | 3.67455621301775 | 51 | 15 | 90.5 | 0 | 15 | 167 | 301 | 351 | DAS84513.1 MAG TPA: Hint [Caudoviricetes sp.] | diamond | 621 | 70.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28392301 | 28392301 | PRJEB80557_S_NODE_17646_length_225_cov_0.886364_g17250_i0 | PRJEB80557 | 17646 | 225 | 0.886364 | 1.994319 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 45.8 | 3.2e-4 | NR | CAB4137975.1 | 2100421 | g17250 | i0 | 69.2 | 0.346666666666667 | 26 | 8 | 34.7 | 0 | 12 | 89 | 47 | 72 | CAB4137975.1 hypothetical protein UFOVP328_168 [uncultured Caudovirales phage] | diamond | 78 | 45.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28543123 | 28543123 | PRJEB80557_S_NODE_4527_length_399_cov_2.720000_g4131_i0 | PRJEB80557 | 4527 | 399 | 2.72 | 10.8528 | Viruses | 10239 | Viruses | Viruses | 103 | 7.4e-23 | NR | QFP93528.1 | 2651067 | g4131 | i0 | 78.3 | 0.902255639097744 | 60 | 13 | 45.1 | 0 | 204 | 383 | 370 | 429 | QFP93528.1 large subunit terminase [Edwardsiella phage vB_EtaM_ET-ABTNL-9] | diamond | 360 | 103 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Edwardsiella phage vB_EtaM_ET-ABTNL-9 | |||||
| 28676605 | 28676605 | PRJEB80557_S_NODE_3587_length_436_cov_1.857881_g3191_i0 | PRJEB80557 | 3587 | 436 | 1.857881 | 8.10036116 | Thermus phage TMA | 699370 | Viruses | Viruses | 109 | 8.03e-28 | NR | YP_004782296.1 | 699370 | g3191 | i0 | 68.4 | 0.543577981651376 | 79 | 23 | 54.4 | 2 | 6 | 242 | 21 | 97 | YP_004782296.1 hypothetical protein TMA_089 [Thermus phage TMA] | diamond | 237 | 109 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thermus phage TMA | |||||
| 28834320 | 28834320 | PRJEB80557_S_NODE_13728_length_251_cov_2.450495_g13332_i0 | PRJEB80557 | 13728 | 251 | 2.450495 | 6.15074245 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 48.1 | 2.89e-4 | NR | XOR14702.1 | 2832643 | g13332 | i0 | 38.2 | 0.812749003984064 | 68 | 35 | 72.9 | 2 | 13 | 195 | 46 | 113 | XOR14702.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 204 | 48.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28929080 | 28929080 | PRJEB80557_S_NODE_11948_length_267_cov_1.600917_g11552_i0 | PRJEB80557 | 11948 | 267 | 1.600917 | 4.27444839 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 140 | 4.7099999999999997e-39 | NR | AXF51923.1 | 2832643 | g11552 | i0 | 70.8 | 1 | 89 | 25 | 98.9 | 1 | 266 | 3 | 7 | 95 | AXF51923.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 267 | 140 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28929082 | 28929082 | PRJEB80557_S_NODE_14308_length_247_cov_1.560606_g13912_i0 | PRJEB80557 | 14308 | 247 | 1.560606 | 3.85469682 | Thermus phage phiYS4 | 407392 | Viruses | Viruses | 76.6 | 2.82e-16 | NR | YP_874100.1 | 407392 | g13912 | i0 | 74.5 | 0.619433198380567 | 51 | 12 | 61.9 | 1 | 2 | 154 | 19 | 68 | YP_874100.1 hypothetical protein YS40_087 [Thermus phage phiYS40] | diamond | 153 | 76.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thermus phage phiYS40 | |||||
| 29971067 | 29971067 | PRJEB80557_S_NODE_17991_length_223_cov_0.896552_g17595_i0 | PRJEB80557 | 17991 | 223 | 0.896552 | 1.99931096 | Thermus phage phiFa | 1400796 | Viruses | Viruses | 100 | 5.79e-25 | NR | AYJ74733.1 | 1400796 | g17595 | i0 | 65.3 | 0.968609865470852 | 72 | 25 | 96.9 | 0 | 222 | 7 | 59 | 130 | AYJ74733.1 ribonuclease H [Thermus phage phiFa] | diamond | 216 | 100 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thermus phage phiFa | |||||
| 30097327 | 30097327 | PRJEB80557_S_NODE_18052_length_222_cov_2.369942_g17656_i0 | PRJEB80557 | 18052 | 222 | 2.369942 | 5.26127124 | Bacillus phage BCD7 | 1136534 | Viruses | Viruses | 59.7 | 2.85e-8 | NR | YP_007005911.1 | 1136534 | g17656 | i0 | 71.1 | 0.513513513513513 | 38 | 11 | 51.4 | 0 | 2 | 115 | 143 | 180 | YP_007005911.1 putative replicative DNA helicase [Bacillus phage BCD7] | diamond | 114 | 59.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Becedseptimavirus | Becedseptimavirus BCD7 | ||||
| 30350753 | 30350753 | PRJEB80557_S_NODE_8932_length_303_cov_3.220472_g8536_i0 | PRJEB80557 | 8932 | 303 | 3.220472 | 9.75803016 | Herelleviridae sp. | 2831613 | Viruses | Viruses | 145 | 3.77e-41 | NR | DAI05689.1 | 2831613 | g8536 | i0 | 75.3 | 3.6831683168316798 | 93 | 22 | 91.1 | 1 | 278 | 3 | 1 | 93 | DAI05689.1 MAG TPA: hypothetical protein [Herelleviridae sp.] | diamond | 1116 | 145 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Herelleviridae sp. | ||||
| 30508197 | 30508197 | PRJEB80557_S_NODE_11373_length_272_cov_2.721973_g10977_i0 | PRJEB80557 | 11373 | 272 | 2.721973 | 7.40376656 | Thermus phage phiYS4 | 407392 | Viruses | Viruses | 47.4 | 0.00123 | NR | YP_874095.1 | 407392 | g10977 | i0 | 44.9 | 0.540441176470588 | 49 | 21 | 47.4 | 1 | 137 | 9 | 1 | 49 | YP_874095.1 hypothetical protein YS40_082 [Thermus phage phiYS40] | diamond | 147 | 47.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thermus phage phiYS40 | |||||
| 30634403 | 30634403 | PRJEB80557_S_NODE_6313_length_350_cov_2.086379_g5917_i0 | PRJEB80557 | 6313 | 350 | 2.086379 | 7.3023265 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 91.3 | 1.2e-18 | NR | XOR79311.1 | 2832643 | g5917 | i0 | 59.4 | 2.68285714285714 | 69 | 28 | 59.1 | 0 | 216 | 10 | 44 | 112 | XOR79311.1 MAG: terminase DNA packaging enzyme large subunit [Caudoviricetes sp.] | diamond | 939 | 91.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30824117 | 30824117 | PRJEB80557_S_NODE_14654_length_244_cov_2.466667_g14258_i0 | PRJEB80557 | 14654 | 244 | 2.466667 | 6.01866748 | Acinetobacter phage vB_AbaM_B9 | 2163899 | Viruses | Viruses | 90.9 | 4.57e-20 | NR | AWD93219.1 | 2163899 | g14258 | i0 | 62 | 0.872950819672131 | 71 | 27 | 87.3 | 0 | 32 | 244 | 31 | 101 | AWD93219.1 ATP-dependent protease subunit [Acinetobacter phage vB_AbaM_B9] | diamond | 213 | 90.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Acinetobacter phage vB_AbaM_B9 | |||||
| 31385916 | 31385916 | PRJEB80557_S_NODE_24256_length_195_cov_0.849315_g23860_i0 | PRJEB80557 | 24256 | 195 | 0.849315 | 1.65616425 | root | 1 | Root_unresolved | Root_unresolved | 102 | 9.01e-25 | NR | AWD93217.1 | 2163899 | g23860 | i0 | 68.8 | 3.93846153846154 | 64 | 20 | 98.5 | 0 | 2 | 193 | 125 | 188 | AWD93217.1 hypothetical protein AB9_137 [Acinetobacter phage vB_AbaM_B9] | diamond | 768 | 103 | 0.990291262135922 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Acinetobacter phage vB_AbaM_B9 | |||||
| 31994071 | 31994071 | PRJEB80557_S_NODE_18418_length_220_cov_3.625731_g18022_i0 | PRJEB80557 | 18418 | 220 | 3.625731 | 7.9766082 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 102 | 5.48e-24 | NR | XOR73472.1 | 2832643 | g18022 | i0 | 66.2 | 0.886363636363636 | 65 | 21 | 88.6 | 1 | 220 | 26 | 44 | 107 | XOR73472.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 195 | 102 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32398237 | 32398237 | PRJEB80557_S_NODE_13679_length_252_cov_0.807882_g13283_i0 | PRJEB80557 | 13679 | 252 | 0.807882 | 2.03586264 | root | 1 | Root_unresolved | Root_unresolved | 63.2 | 1.81e-9 | NR | YP_009837578.1 | 2099336 | g13283 | i0 | 63.2 | 0.904761904761905 | 38 | 14 | 45.2 | 0 | 135 | 22 | 145 | 182 | YP_009837578.1 DnaD-like helicase loader [Anoxybacillus phage A403] | diamond | 228 | 63.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Tandoganvirus | Tandoganvirus A403 | ||||
| 32626482 | 32626482 | PRJEB80557_S_NODE_30500_length_175_cov_2.349206_g30104_i0 | PRJEB80557 | 30500 | 175 | 2.349206 | 4.1111105 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 85.5 | 1.23e-17 | NR | XOR73438.1 | 2832643 | g30104 | i0 | 88 | 0.857142857142857 | 50 | 6 | 85.7 | 0 | 173 | 24 | 398 | 447 | XOR73438.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 150 | 85.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. |
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);;