contig_metadata
21 rows where bioproject = "PRJNA1174770" and tax_phylum = "Uroviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 316305 | 316305 | PRJNA1174770_P_NODE_10261_length_165_cov_0.887931_g10172_i0 | PRJNA1174770 | 10261 | 165 | 0.887931 | 1.46508615 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 272 | 9.73e-69 | NTclustered | gi|2914962682|gb|OR221991.1| | 2832643 | g10172 | i0 | 96.914 | 1.96363636363636 | 162 | 5 | 98 | 0 | 4 | 165 | 53697 | 53536 | MAG: Caudoviricetes sp. isolate MSP0133 genomic sequence | blastn | 324 | 272 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1590976 | 1590976 | PRJNA1174770_P_NODE_9682_length_166_cov_0.880342_g9593_i0 | PRJNA1174770 | 9682 | 166 | 0.880342 | 1.46136772 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 302 | 1.2500000000000001e-77 | NTclustered | gi|2914986982|gb|OR222125.1| | 2832643 | g9593 | i0 | 99.398 | 3.75301204819277 | 166 | 1 | 100 | 0 | 1 | 166 | 22646 | 22811 | MAG: Caudoviricetes sp. isolate MSP0855 genomic sequence | blastn | 623 | 302 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5419358 | 5419358 | PRJNA1174770_P_NODE_6505_length_184_cov_1.237037_g6416_i0 | PRJNA1174770 | 6505 | 184 | 1.237037 | 2.27614808 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 65.8 | 2.02e-6 | NTclustered | gi|2059917061|tpg|BK041566.1| | 2832643 | g6416 | i0 | 93.182 | 0.239130434782609 | 44 | 3 | 24 | 0 | 57 | 100 | 3333 | 3376 | MAG TPA_asm: Caudoviricetes sp. isolate ctKPv40, partial genome | blastn | 44 | 65.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6694255 | 6694255 | PRJNA1174770_P_NODE_9546_length_166_cov_0.888889_g9457_i0 | PRJNA1174770 | 9546 | 166 | 0.888889 | 1.47555574 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 291 | 2.7099999999999998e-74 | NTclustered | gi|2915045223|gb|OR222781.1| | 2832643 | g9457 | i0 | 98.193 | 1 | 166 | 3 | 100 | 0 | 1 | 166 | 18910 | 19075 | MAG: Caudoviricetes sp. isolate MSP0579 genomic sequence | blastn | 166 | 291 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7969520 | 7969520 | PRJNA1174770_P_NODE_10667_length_164_cov_0.904348_g10578_i0 | PRJNA1174770 | 10667 | 164 | 0.904348 | 1.48313072 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 303 | 3.42e-78 | NTclustered | gi|2056734783|tpg|BK044972.1| | 2832643 | g10578 | i0 | 100 | 25.890243902439 | 164 | 0 | 100 | 0 | 1 | 164 | 2038 | 1875 | MAG TPA_asm: Caudoviricetes sp. isolate ctaxg3, partial genome | blastn | 4246 | 303 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15619055 | 15619055 | PRJNA1174770_P_NODE_7153_length_176_cov_1.622047_g7064_i0 | PRJNA1174770 | 7153 | 176 | 1.622047 | 2.85480272 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 224 | 2.9699999999999996e-54 | NTclustered | gi|2914824635|gb|OR222226.1| | 2832643 | g7064 | i0 | 92.357 | 1.78977272727273 | 157 | 12 | 89 | 0 | 19 | 175 | 16933 | 17089 | MAG: Caudoviricetes sp. isolate MSP0745 genomic sequence | blastn | 315 | 224 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16893397 | 16893397 | PRJNA1174770_P_NODE_9554_length_166_cov_0.888889_g9465_i0 | PRJNA1174770 | 9554 | 166 | 0.888889 | 1.47555574 | Lactococcus phage D6890 | 2979363 | Viruses | Viruses | 307 | 2.69e-79 | NTclustered | gi|2306485016|gb|OP323077.1| | 2979363 | g9465 | i0 | 100 | 60.2590361445783 | 166 | 0 | 100 | 0 | 1 | 166 | 25893 | 25728 | Lactococcus phage D6890, complete genome | blastn | 10003 | 307 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lactococcus phage D6890 | |||||
| 18167897 | 18167897 | PRJNA1174770_P_NODE_4255_length_223_cov_2.333333_g4166_i0 | PRJNA1174770 | 4255 | 223 | 2.333333 | 5.20333259 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 65.8 | 2.54e-6 | NTclustered | gi|1862931302|emb|LR798196.1| | 2100421 | g4166 | i0 | 93.182 | 0.197309417040359 | 44 | 3 | 20 | 0 | 65 | 108 | 7986 | 7943 | uncultured Caudovirales phage genome assembly | blastn | 44 | 65.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 20717623 | 20717623 | PRJNA1174770_P_NODE_11157_length_163_cov_1.368421_g11068_i0 | PRJNA1174770 | 11157 | 163 | 1.368421 | 2.23052623 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 237 | 3.49e-58 | NTclustered | gi|2914852300|gb|OR221708.1| | 2832643 | g11068 | i0 | 93.252 | 1 | 163 | 8 | 100 | 3 | 1 | 163 | 881 | 722 | MAG: Caudoviricetes sp. isolate MSP1326 genomic sequence | blastn | 163 | 237 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20717686 | 20717686 | PRJNA1174770_P_NODE_8957_length_167_cov_0.881356_g8868_i0 | PRJNA1174770 | 8957 | 167 | 0.881356 | 1.47186452 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 276 | 7.64e-70 | NTclustered | gi|2057046044|tpg|BK049375.1| | 2832643 | g8868 | i0 | 96.407 | 1 | 167 | 6 | 100 | 0 | 1 | 167 | 44113 | 43947 | MAG TPA_asm: Caudoviricetes sp. isolate ctqLd1, partial genome | blastn | 167 | 276 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24542273 | 24542273 | PRJNA1174770_P_NODE_6320_length_186_cov_1.518248_g6231_i0 | PRJNA1174770 | 6320 | 186 | 1.518248 | 2.82394128 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 95.5 | 4.46e-21 | NR | DAX53090.1 | 2832643 | g6231 | i0 | 77.2 | 2.79032258064516 | 57 | 13 | 91.9 | 0 | 185 | 15 | 538 | 594 | DAX53090.1 MAG TPA: stabilization protein [Caudoviricetes sp.] | diamond | 519 | 95.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26755480 | 26755480 | PRJNA1174770_P_NODE_8961_length_167_cov_0.881356_g8872_i0 | PRJNA1174770 | 8961 | 167 | 0.881356 | 1.47186452 | Bordetella phage PY223 | 3118915 | Viruses | Viruses | 72 | 7.6e-14 | NR | WVR18334.1 | 3118915 | g8872 | i0 | 66.7 | 0.970059880239521 | 54 | 18 | 97 | 0 | 162 | 1 | 20 | 73 | WVR18334.1 hypothetical protein y223_00054 [Bordetella phage PY223] | diamond | 162 | 72 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Bordetella phage PY223 | |||||
| 27103671 | 27103671 | PRJNA1174770_P_NODE_5102_length_205_cov_1.320513_g5013_i0 | PRJNA1174770 | 5102 | 205 | 1.320513 | 2.70705165 | Bordetella phage PY223 | 3118915 | Viruses | Viruses | 87.4 | 4.06e-18 | NR | WVR18339.1 | 3118915 | g5013 | i0 | 60.3 | 0.995121951219512 | 68 | 27 | 99.5 | 0 | 2 | 205 | 252 | 319 | WVR18339.1 TMP repeat [Bordetella phage PY223] | diamond | 204 | 87.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Bordetella phage PY223 | |||||
| 27597029 | 27597029 | PRJNA1174770_P_NODE_1484_length_404_cov_1.374648_g1395_i0 | PRJNA1174770 | 1484 | 404 | 1.374648 | 5.55357792 | Viruses | 10239 | Viruses | Viruses | 69.7 | 3.11e-12 | NR | XOS42973.1 | 2832643 | g1395 | i0 | 48.1 | 2.25 | 77 | 28 | 54.2 | 2 | 3 | 221 | 52 | 120 | XOS42973.1 MAG: hypothetical protein MSP0968_16 [Caudoviricetes sp.] | diamond | 909 | 70.1 | 0.994293865905849 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27609394 | 27609394 | PRJNA1174770_P_NODE_5004_length_207_cov_1.329114_g4915_i0 | PRJNA1174770 | 5004 | 207 | 1.329114 | 2.75126598 | Bordetella phage PY223 | 3118915 | Viruses | Viruses | 57.4 | 5.49e-8 | NR | WVR18342.1 | 3118915 | g4915 | i0 | 80.6 | 0.449275362318841 | 31 | 6 | 44.9 | 0 | 114 | 206 | 1 | 31 | WVR18342.1 baseplate assembly protein V [Bordetella phage PY223] | diamond | 93 | 57.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Bordetella phage PY223 | |||||
| 28082821 | 28082821 | PRJNA1174770_P_NODE_11225_length_163_cov_0.912281_g11136_i0 | PRJNA1174770 | 11225 | 163 | 0.912281 | 1.48701803 | Pseudomonas phage ZRG1 | 3032262 | Viruses | Viruses | 85.1 | 1.48e-17 | NR | WID42089.1 | 3032262 | g11136 | i0 | 69.8 | 0.975460122699387 | 53 | 16 | 97.5 | 0 | 5 | 163 | 335 | 387 | WID42089.1 cellulase family glycosylhydrolase [Pseudomonas phage ZRG1] | diamond | 159 | 85.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage ZRG1 | |||||
| 28777426 | 28777426 | PRJNA1174770_P_NODE_10407_length_165_cov_0.870690_g10318_i0 | PRJNA1174770 | 10407 | 165 | 0.87069 | 1.4366385 | Corynebacterium phage Darwin | 2047869 | Viruses | Viruses | 64.7 | 2.26e-10 | NR | YP_009620320.1 | 2047869 | g10318 | i0 | 66.7 | 1.85454545454545 | 48 | 16 | 87.3 | 0 | 145 | 2 | 400 | 447 | YP_009620320.1 ribonucleotide reductase [Corynebacterium phage Darwin] | diamond | 306 | 64.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zierdtviridae | Ceetrepovirus | Ceetrepovirus darwin | |||
| 29851173 | 29851173 | PRJNA1174770_P_NODE_10191_length_165_cov_0.887931_g10102_i0 | PRJNA1174770 | 10191 | 165 | 0.887931 | 1.46508615 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 113 | 2.41e-30 | NR | XOR94885.1 | 2832643 | g10102 | i0 | 94.5 | 1 | 55 | 3 | 100 | 0 | 165 | 1 | 81 | 135 | XOR94885.1 MAG: helix-turn-helix DNA-binding domain-containing protein [Caudoviricetes sp.] | diamond | 165 | 113 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30735646 | 30735646 | PRJNA1174770_P_NODE_4214_length_224_cov_1.760000_g4125_i0 | PRJNA1174770 | 4214 | 224 | 1.76 | 3.9424 | Bordetella phage PY223 | 3118915 | Viruses | Viruses | 117 | 1.08e-28 | NR | WVR18288.1 | 3118915 | g4125 | i0 | 82.2 | 0.977678571428571 | 73 | 13 | 97.8 | 0 | 219 | 1 | 460 | 532 | WVR18288.1 DNA repair exonuclease SbcCD ATPase subunit [Bordetella phage PY223] | diamond | 219 | 117 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Bordetella phage PY223 | |||||
| 31652256 | 31652256 | PRJNA1174770_P_NODE_6737_length_181_cov_1.242424_g6648_i0 | PRJNA1174770 | 6737 | 181 | 1.242424 | 2.24878744 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 81.6 | 3.08e-16 | NR | CAB4124912.1 | 2100421 | g6648 | i0 | 73.1 | 0.861878453038674 | 52 | 14 | 86.2 | 0 | 158 | 3 | 654 | 705 | CAB4124912.1 NAT_SF domain containing protein [uncultured Caudovirales phage] | diamond | 156 | 81.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32190338 | 32190338 | PRJNA1174770_P_NODE_7858_length_169_cov_1.350000_g7769_i0 | PRJNA1174770 | 7858 | 169 | 1.35 | 2.2815 | Bordetella phage PY223 | 3118915 | Viruses | Viruses | 99.4 | 1.6000000000000002e-22 | NR | WVR18294.1 | 3118915 | g7769 | i0 | 83.9 | 0.994082840236686 | 56 | 9 | 99.4 | 0 | 2 | 169 | 564 | 619 | WVR18294.1 CHC2 zinc finger protein [Bordetella phage PY223] | diamond | 168 | 99.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Bordetella phage PY223 |
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);;