contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA1047749" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6553096 | 6553096 | PRJNA1047749_P_NODE_36226_length_262_cov_3.084656_g35959_i0 | PRJNA1047749 | 36226 | 262 | 3.084656 | 8.08179872 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 69.7 | 1.21e-13 | NR | XOR12066.1 | 2832643 | g35959 | i0 | 60.7 | 0.698473282442748 | 61 | 9 | 52.7 | 1 | 217 | 80 | 1 | 61 | XOR12066.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 183 | 69.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14203858 | 14203858 | PRJNA1047749_P_NODE_34372_length_269_cov_6.010204_g34105_i0 | PRJNA1047749 | 34372 | 269 | 6.010204 | 16.16744876 | Acinetobacter phage LZ35 | 1792222 | Viruses | Viruses | 108 | 2e-27 | NR | YP_009291905.1 | 1792222 | g34105 | i0 | 58.8 | 1.85130111524164 | 85 | 34 | 94.8 | 1 | 269 | 15 | 91 | 174 | YP_009291905.1 HNH endonuclease [Acinetobacter phage LZ35] | diamond | 498 | 108 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Obolenskvirus | Obolenskvirus LZ35 | ||||
| 26591827 | 26591827 | PRJNA1047749_P_NODE_16261_length_312_cov_6.757322_g15994_i0 | PRJNA1047749 | 16261 | 312 | 6.757322 | 21.08284464 | Thermus phage TH115 | 3079687 | Viruses | Viruses | 74.7 | 4.06e-13 | NR | WQZ00051.1 | 3079687 | g15994 | i0 | 57.9 | 0.548076923076923 | 57 | 24 | 54.8 | 0 | 303 | 133 | 296 | 352 | WQZ00051.1 hypothetical protein [Thermus phage TH115] | diamond | 171 | 74.7 | 1 | Viruses | Thermus phage TH115 | ||||||||
| 27667334 | 27667334 | PRJNA1047749_P_NODE_51884_length_197_cov_11.459677_g51617_i0 | PRJNA1047749 | 51884 | 197 | 11.459677 | 22.57556369 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 95.1 | 1.4500000000000002e-21 | NR | XOS14040.1 | 2832643 | g51617 | i0 | 75 | 0.913705583756345 | 60 | 15 | 91.4 | 0 | 2 | 181 | 150 | 209 | XOS14040.1 MAG: hypothetical protein MSP0127_110 [Caudoviricetes sp.] | diamond | 180 | 95.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27699056 | 27699056 | PRJNA1047749_P_NODE_14924_length_319_cov_4.341463_g14659_i0 | PRJNA1047749 | 14924 | 319 | 4.341463 | 13.84926697 | Xanthomonas phage RTH11 | 3044021 | Viruses | Viruses | 157 | 5.05e-42 | NR | WJJ55123.1 | 3044021 | g14659 | i0 | 74 | 0.978056426332288 | 104 | 27 | 97.8 | 0 | 6 | 317 | 733 | 836 | WJJ55123.1 virion structural protein [Xanthomonas phage RTH11] | diamond | 312 | 157 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Xanthomonas phage RTH11 | |||||
| 27825134 | 27825134 | PRJNA1047749_P_NODE_17464_length_312_cov_4.690377_g17197_i0 | PRJNA1047749 | 17464 | 312 | 4.690377 | 14.63397624 | Acinetobacter phage vB_AbaM_ME3 | 1837876 | Viruses | Viruses | 67.4 | 1.82e-10 | NR | YP_009595885.1 | 1837876 | g17197 | i0 | 67.3 | 0.471153846153846 | 49 | 16 | 47.1 | 0 | 312 | 166 | 117 | 165 | YP_009595885.1 hypothetical protein FDH01_gp053 [Acinetobacter phage vB_AbaM_ME3] | diamond | 147 | 67.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Metrivirus | Metrivirus ME3 | ||||
| 28014637 | 28014637 | PRJNA1047749_P_NODE_49405_length_212_cov_4.093525_g49138_i0 | PRJNA1047749 | 49405 | 212 | 4.093525 | 8.678273 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 59.7 | 2.6e-8 | NR | DAW84382.1 | 2832643 | g49138 | i0 | 42.1 | 2.15094339622642 | 76 | 36 | 96.2 | 3 | 207 | 4 | 237 | 312 | DAW84382.1 MAG TPA: portal protein [Caudoviricetes sp.] | diamond | 456 | 59.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28203685 | 28203685 | PRJNA1047749_P_NODE_29846_length_288_cov_3.000000_g29579_i0 | PRJNA1047749 | 29846 | 288 | 3 | 8.64 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 91.7 | 3.13e-19 | NR | XOR52909.1 | 2832643 | g29579 | i0 | 54.3 | 0.729166666666667 | 70 | 32 | 72.9 | 0 | 283 | 74 | 387 | 456 | XOR52909.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 210 | 91.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28203692 | 28203692 | PRJNA1047749_P_NODE_42086_length_244_cov_3.426901_g41819_i0 | PRJNA1047749 | 42086 | 244 | 3.426901 | 8.36163844 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 79.3 | 9.11e-16 | NR | CAB4196828.1 | 2100421 | g41819 | i0 | 50.6 | 1.93032786885246 | 79 | 37 | 97.1 | 2 | 243 | 7 | 125 | 201 | CAB4196828.1 HNHc domain containing protein [uncultured Caudovirales phage] | diamond | 471 | 79.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28519763 | 28519763 | PRJNA1047749_P_NODE_27847_length_295_cov_4.162162_g27580_i0 | PRJNA1047749 | 27847 | 295 | 4.162162 | 12.2783779 | Phage NCTB | 1857647 | Viruses | Viruses | 46.6 | 0.003 | NR | SBV38521.1 | 1857647 | g27580 | i0 | 36 | 1.01694915254237 | 100 | 51 | 88.5 | 2 | 284 | 24 | 618 | 717 | SBV38521.1 Exonuclease SbcC [Phage NCTB] | diamond | 300 | 46.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Phage NCTB | |||||
| 28646061 | 28646061 | PRJNA1047749_P_NODE_39227_length_252_cov_1.458101_g38960_i0 | PRJNA1047749 | 39227 | 252 | 1.458101 | 3.67441452 | Thermus phage Lalka27a | 3289877 | Viruses | Viruses | 130 | 5.5e-33 | NR | XKB89797.1 | 3289877 | g38960 | i0 | 83.8 | 0.880952380952381 | 74 | 12 | 88.1 | 0 | 8 | 229 | 500 | 573 | XKB89797.1 AAA family ATPase [Thermus phage Lalka27a] | diamond | 222 | 130 | 1 | Viruses | Thermus phage Lalka27a | ||||||||
| 28772161 | 28772161 | PRJNA1047749_P_NODE_19187_length_312_cov_3.326360_g18920_i0 | PRJNA1047749 | 19187 | 312 | 3.32636 | 10.3782432 | Thermus phage phiFa | 1400796 | Viruses | Viruses | 50.8 | 1.24e-4 | NR | QKE11347.1 | 1400796 | g18920 | i0 | 71.9 | 0.307692307692308 | 32 | 9 | 30.8 | 0 | 56 | 151 | 894 | 925 | QKE11347.1 distal tail fiber protein [Thermus phage phiFa] | diamond | 96 | 50.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thermus phage phiFa | |||||
| 29056522 | 29056522 | PRJNA1047749_P_NODE_25988_length_300_cov_2.444934_g25721_i0 | PRJNA1047749 | 25988 | 300 | 2.444934 | 7.334802 | Microbacterium phage Zooman | 2885984 | Viruses | Viruses | 95.9 | 1.18e-22 | NR | UDL16371.1 | 2885984 | g25721 | i0 | 92.2 | 0.51 | 51 | 4 | 51 | 0 | 1 | 153 | 104 | 154 | UDL16371.1 hypothetical protein SEA_ZOOMAN_87 [Microbacterium phage Zooman] | diamond | 153 | 95.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Microbacterium phage Zooman | |||||
| 29143298 | 29143298 | PRJNA1047749_P_NODE_33809_length_271_cov_10.893939_g33542_i0 | PRJNA1047749 | 33809 | 271 | 10.893939 | 29.52257469 | Viruses | 10239 | Viruses | Viruses | 59.3 | 3.21e-8 | NR | WZH59143.1 | 3130032 | g33542 | i0 | 53.5 | 1.91512915129151 | 43 | 20 | 47.6 | 0 | 263 | 135 | 10 | 52 | WZH59143.1 MAG: RNA-dependent RNA polymerase, partial [Ripablyg virus] | diamond | 519 | 59.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Ripablyg virus | |||
| 29245861 | 29245861 | PRJNA1047749_P_NODE_46309_length_230_cov_2.261146_g46042_i0 | PRJNA1047749 | 46309 | 230 | 2.261146 | 5.2006358 | Lactobacillus phage Bacchae | 2079429 | Viruses | Viruses | 95.5 | 2.73e-21 | NR | YP_009798078.1 | 2079429 | g46042 | i0 | 59.2 | 0.991304347826087 | 76 | 31 | 99.1 | 0 | 229 | 2 | 267 | 342 | YP_009798078.1 putative recombination / repair related protein [Lactobacillus phage Bacchae] | diamond | 228 | 95.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Harbinvirus | Harbinvirus bacchae | |||
| 29372175 | 29372175 | PRJNA1047749_P_NODE_18349_length_312_cov_3.887029_g18082_i0 | PRJNA1047749 | 18349 | 312 | 3.887029 | 12.12753048 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 72 | 4.27e-12 | NR | XOS54461.1 | 2832643 | g18082 | i0 | 64 | 0.480769230769231 | 50 | 18 | 48.1 | 0 | 162 | 311 | 155 | 204 | XOS54461.1 MAG: phage associated primase [Caudoviricetes sp.] | diamond | 150 | 72 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29372178 | 29372178 | PRJNA1047749_P_NODE_23069_length_301_cov_7.337719_g22802_i0 | PRJNA1047749 | 23069 | 301 | 7.337719 | 22.08653419 | Microbacterium phage Zooman | 2885984 | Viruses | Viruses | 88.2 | 8.6e-19 | NR | UDL16288.1 | 2885984 | g22802 | i0 | 79.6 | 0.488372093023256 | 49 | 10 | 48.8 | 0 | 297 | 151 | 56 | 104 | UDL16288.1 endolysin [Microbacterium phage Zooman] | diamond | 147 | 88.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Microbacterium phage Zooman | |||||
| 29521874 | 29521874 | PRJNA1047749_P_NODE_28950_length_291_cov_5.839450_g28683_i0 | PRJNA1047749 | 28950 | 291 | 5.83945 | 16.9927995 | Tequatrovirus | 10663 | Viruses | Viruses | 197 | 2.1e-61 | NR | 1S68_A | 10665 | g28683 | i0 | 100 | 3.91752577319588 | 95 | 0 | 97.9 | 0 | 287 | 3 | 54 | 148 | 1S68_A Chain A, RNA Ligase 2 [Tequatrovirus T4] | diamond | 1140 | 197 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Tequatrovirus | Tequatrovirus T4 | ||
| 29655887 | 29655887 | PRJNA1047749_P_NODE_42550_length_243_cov_2.200000_g42283_i0 | PRJNA1047749 | 42550 | 243 | 2.2 | 5.346 | Limnohabitans phage DC31 | 2883572 | Viruses | Viruses | 73.9 | 3.85e-13 | NR | XLZ15456.1 | 2883572 | g42283 | i0 | 91.7 | 0.444444444444444 | 36 | 3 | 44.4 | 0 | 243 | 136 | 528 | 563 | XLZ15456.1 ribonucleoside-diphosphate reductase large subunit [Limnohabitans phage DC31] | diamond | 108 | 73.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Pakpunavirus | Limnohabitans phage DC31 | |||
| 30351826 | 30351826 | PRJNA1047749_P_NODE_50412_length_205_cov_14.825758_g50145_i0 | PRJNA1047749 | 50412 | 205 | 14.825758 | 30.3928039 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 112 | 6.870000000000001e-27 | NR | XOR23115.1 | 2832643 | g50145 | i0 | 89.1 | 1.81463414634146 | 64 | 7 | 93.7 | 0 | 13 | 204 | 137 | 200 | XOR23115.1 MAG: tape measure protein [Caudoviricetes sp.] | diamond | 372 | 112 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30983353 | 30983353 | PRJNA1047749_P_NODE_51634_length_199_cov_4.436508_g51367_i0 | PRJNA1047749 | 51634 | 199 | 4.436508 | 8.82865092 | Stenotrophomonas phage RAS14 | 2996120 | Viruses | Viruses | 46.2 | 0.00123 | NR | WAX21948.1 | 2996120 | g51367 | i0 | 59.4 | 1.20603015075377 | 32 | 13 | 48.2 | 0 | 7 | 102 | 118 | 149 | WAX21948.1 hypothetical protein [Stenotrophomonas phage RAS14] | diamond | 240 | 46.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Stenotrophomonas phage RAS14 | |||||
| 31425707 | 31425707 | PRJNA1047749_P_NODE_49056_length_214_cov_4.617021_g48789_i0 | PRJNA1047749 | 49056 | 214 | 4.617021 | 9.88042494 | Adintovirus puccinia11432 | 3115941 | Viruses | Viruses | 96.7 | 4.91e-24 | NR | DBA48721.1 | 3115941 | g48789 | i0 | 77.8 | 0.883177570093458 | 63 | 13 | 88.3 | 1 | 213 | 25 | 6 | 67 | DBA48721.1 MAG TPA_asm: GasderminX [Adintovirus puccinia11432] | diamond | 189 | 96.7 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus puccinia11432 | |||
| 32216679 | 32216679 | PRJNA1047749_P_NODE_34418_length_269_cov_3.846939_g34151_i0 | PRJNA1047749 | 34418 | 269 | 3.846939 | 10.34826591 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 47 | 0.0016 | NR | XOR60419.1 | 2832643 | g34151 | i0 | 33.3 | 0.970260223048327 | 87 | 57 | 97 | 1 | 5 | 265 | 96 | 181 | XOR60419.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 261 | 47 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32564946 | 32564946 | PRJNA1047749_P_NODE_36319_length_262_cov_1.936508_g36052_i0 | PRJNA1047749 | 36319 | 262 | 1.936508 | 5.07365096 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 132 | 3.65e-34 | NR | DAF83380.1 | 2832643 | g36052 | i0 | 74.7 | 0.950381679389313 | 83 | 21 | 95 | 0 | 10 | 258 | 383 | 465 | DAF83380.1 MAG TPA: stabilization protein [Caudoviricetes sp.] | diamond | 249 | 132 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32690445 | 32690445 | PRJNA1047749_P_NODE_11700_length_365_cov_4.202055_g11436_i0 | PRJNA1047749 | 11700 | 365 | 4.202055 | 15.33750075 | Acanthocystis turfacea Chlorella virus GM | 1278266 | Viruses | Viruses | 121 | 7.06e-31 | NR | AGE53463.1 | 1278271 | g11436 | i0 | 83.3 | 0.542465753424658 | 66 | 11 | 54.2 | 0 | 363 | 166 | 106 | 171 | AGE53463.1 DNA ligase [Acanthocystis turfacea Chlorella virus GM0701.1] | diamond | 198 | 121 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Chlorovirus | Acanthocystis turfacea Chlorella virus GM0701.1 | ||
| 32848015 | 32848015 | PRJNA1047749_P_NODE_80_length_1938_cov_89.558713_g62_i0 | PRJNA1047749 | 80 | 1938 | 89.558713 | 1735.64785794 | Hangzhou mito-like virus 5 | 3028982 | Viruses | Viruses | 367 | 1.95e-114 | NR | WEU70943.1 | 3028982 | g62 | i0 | 37.5 | 1.02012383900929 | 659 | 372 | 98.6 | 14 | 6 | 1916 | 20 | 660 | WEU70943.1 MAG: RNA-dependent RNA polymerase, partial [Hangzhou mito-like virus 5] | diamond | 1977 | 367 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Hangzhou mito-like virus 5 |
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);;