contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA1112809" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6598349 | 6598349 | PRJNA1112809_P_NODE_194046_length_241_cov_0.916667_g190771_i0 | PRJNA1112809 | 194046 | 241 | 0.916667 | 2.20916747 | root | 1 | Root_unresolved | Root_unresolved | 149 | 2.21e-41 | NR | QKY78963.1 | 2743903 | g190771 | i0 | 82.3 | 1.96680497925311 | 79 | 14 | 98.3 | 0 | 3 | 239 | 21 | 99 | QKY78963.1 methyltransferase [Arthrobacter phage Jinkies] | diamond | 474 | 150 | 0.993333333333333 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Berryhillviridae | Jinkiesvirus | Jinkiesvirus jinkies | |||
| 14247683 | 14247683 | PRJNA1112809_P_NODE_111392_length_310_cov_1.924051_g108117_i0 | PRJNA1112809 | 111392 | 310 | 1.924051 | 5.9645581 | Curvibacter phage P26 | 1983783 | Viruses | Viruses | 145 | 4.61e-40 | NR | ASJ79166.1 | 1983783 | g108117 | i0 | 61.2 | 2.24516129032258 | 116 | 32 | 99.7 | 1 | 2 | 310 | 204 | 319 | ASJ79166.1 major structural protein [Curvibacter phage P26059A] | diamond | 696 | 145 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Curvibacter phage P26059A | |||||
| 18070293 | 18070293 | PRJNA1112809_P_NODE_105915_length_320_cov_0.935223_g102640_i0 | PRJNA1112809 | 105915 | 320 | 0.935223 | 2.9927136 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 98.2 | 3.84e-23 | NR | DAL87444.1 | 2832643 | g102640 | i0 | 55.3 | 1.959375 | 103 | 38 | 96.6 | 3 | 12 | 320 | 1 | 95 | DAL87444.1 MAG TPA: hypothetical protein, partial [Caudoviricetes sp.] | diamond | 627 | 98.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26995516 | 26995516 | PRJNA1112809_P_NODE_146922_length_266_cov_2.419689_g143647_i0 | PRJNA1112809 | 146922 | 266 | 2.419689 | 6.43637274 | root | 1 | Root_unresolved | Root_unresolved | 78.6 | 1.12e-14 | NR | DAG38904.1 | 2832643 | g143647 | i0 | 45.9 | 4.96240601503759 | 85 | 39 | 95.9 | 2 | 256 | 2 | 365 | 442 | DAG38904.1 MAG TPA: N-acetylmuramoyl-L-alanine amidase [Caudoviricetes sp.] | diamond | 1320 | 79 | 0.994936708860759 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27289087 | 27289087 | PRJNA1112809_P_NODE_108803_length_314_cov_3.419087_g105528_i0 | PRJNA1112809 | 108803 | 314 | 3.419087 | 10.73593318 | Mu-like cryoconite phage AB | 2761371 | Viruses | Viruses | 54.3 | 7.16e-6 | NR | QMV49911.1 | 2761371 | g105528 | i0 | 51 | 0.468152866242038 | 49 | 24 | 46.8 | 0 | 148 | 2 | 6 | 54 | QMV49911.1 MAG: terminase large subunit [Mu-like cryoconite phage AB09] | diamond | 147 | 54.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Mu-like cryoconite phage AB09 | |||||
| 27510466 | 27510466 | PRJNA1112809_P_NODE_92783_length_347_cov_1.671533_g89508_i0 | PRJNA1112809 | 92783 | 347 | 1.671533 | 5.80021951 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 97.1 | 6.820000000000001e-21 | NR | XOS14019.1 | 2832643 | g89508 | i0 | 55.2 | 1.49567723342939 | 87 | 37 | 73.5 | 2 | 2 | 256 | 352 | 438 | XOS14019.1 MAG: hypothetical protein MSP0127_89 [Caudoviricetes sp.] | diamond | 519 | 97.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27700056 | 27700056 | PRJNA1112809_P_NODE_165444_length_251_cov_0.865169_g162169_i0 | PRJNA1112809 | 165444 | 251 | 0.865169 | 2.17157419 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 64.7 | 1.6e-10 | NR | XOR82757.1 | 2832643 | g162169 | i0 | 56 | 0.597609561752988 | 50 | 22 | 59.8 | 0 | 251 | 102 | 137 | 186 | XOR82757.1 MAG: hypothetical protein MSP1879_11 [Caudoviricetes sp.] | diamond | 150 | 64.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27763147 | 27763147 | PRJNA1112809_P_NODE_23144_length_1054_cov_3.459735_g20400_i0 | PRJNA1112809 | 23144 | 1054 | 3.459735 | 36.4656069 | Curvibacter phage P26 | 1983783 | Viruses | Viruses | 169 | 2.9299999999999996e-48 | NR | ASJ79165.1 | 1983783 | g20400 | i0 | 67.2 | 0.364326375711575 | 128 | 42 | 36.4 | 0 | 561 | 178 | 5 | 132 | ASJ79165.1 head decoration protein D [Curvibacter phage P26059A] | diamond | 384 | 169 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Curvibacter phage P26059A | |||||
| 27857485 | 27857485 | PRJNA1112809_P_NODE_124965_length_290_cov_1.774194_g121690_i0 | PRJNA1112809 | 124965 | 290 | 1.774194 | 5.1451626 | Providencia phage PSTNGR1 | 2783542 | Viruses | Viruses | 160 | 6.24e-44 | NR | QPB11250.1 | 2783542 | g121690 | i0 | 78.1 | 0.993103448275862 | 96 | 21 | 99.3 | 0 | 1 | 288 | 61 | 156 | QPB11250.1 terminase large subunit [Providencia phage PSTNGR1] | diamond | 288 | 160 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autonotataviridae | Jeruvirus | Jeruvirus PSTNGR1 | ||
| 27920656 | 27920656 | PRJNA1112809_P_NODE_155885_length_258_cov_1.518919_g152610_i0 | PRJNA1112809 | 155885 | 258 | 1.518919 | 3.91881102 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 97.8 | 4.82e-22 | NR | XOR51180.1 | 2832643 | g152610 | i0 | 61.7 | 1.93023255813953 | 81 | 31 | 94.2 | 0 | 256 | 14 | 227 | 307 | XOR51180.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 498 | 97.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28015589 | 28015589 | PRJNA1112809_P_NODE_182945_length_244_cov_2.175439_g179670_i0 | PRJNA1112809 | 182945 | 244 | 2.175439 | 5.30807116 | Ralstonia phage PY | 3145150 | Viruses | Viruses | 138 | 1.4e-36 | NR | XAO34296.1 | 3145150 | g179670 | i0 | 86.7 | 0.922131147540984 | 75 | 10 | 92.2 | 0 | 9 | 233 | 299 | 373 | XAO34296.1 hypothetical protein HMHLAPFJ_00002 [Ralstonia phage PY059YO380] | diamond | 225 | 138 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Ralstonia phage PY059YO380 | |||||
| 28583870 | 28583870 | PRJNA1112809_P_NODE_112447_length_308_cov_3.008511_g109172_i0 | PRJNA1112809 | 112447 | 308 | 3.008511 | 9.26621388 | Pseudomonas phage Noxifer | 2006684 | Viruses | Viruses | 114 | 7.95e-31 | NR | YP_009609214.1 | 2006684 | g109172 | i0 | 60.2 | 0.905844155844156 | 93 | 32 | 85.7 | 1 | 292 | 29 | 1 | 93 | YP_009609214.1 hypothetical protein FDI21_gp243 [Pseudomonas phage Noxifer] | diamond | 279 | 114 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Noxifervirus | Noxifervirus noxifer | |||
| 28836340 | 28836340 | PRJNA1112809_P_NODE_61208_length_464_cov_1.575448_g57935_i0 | PRJNA1112809 | 61208 | 464 | 1.575448 | 7.31007872 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 43.5 | 0.034 | NR | DAU58706.1 | 2832643 | g57935 | i0 | 58.7 | 0.297413793103448 | 46 | 16 | 27.8 | 1 | 334 | 462 | 7 | 52 | DAU58706.1 MAG TPA: Terminase small subunit [Caudoviricetes sp.] | diamond | 138 | 43.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29057487 | 29057487 | PRJNA1112809_P_NODE_157928_length_256_cov_1.683060_g154653_i0 | PRJNA1112809 | 157928 | 256 | 1.68306 | 4.3086336 | Erwinia phage vB_EamM_RisingSun | 2026080 | Viruses | Viruses | 90.5 | 1.03e-20 | NR | YP_009612967.1 | 2026080 | g154653 | i0 | 49.4 | 0.97265625 | 83 | 42 | 97.3 | 0 | 254 | 6 | 83 | 165 | YP_009612967.1 hypothetical protein FDI45_gp223 [Erwinia phage vB_EamM_RisingSun] | diamond | 249 | 90.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Risingsunvirus | Risingsunvirus risingsun | |||
| 30469984 | 30469984 | PRJNA1112809_P_NODE_154673_length_259_cov_1.596774_g151398_i0 | PRJNA1112809 | 154673 | 259 | 1.596774 | 4.13564466 | root | 1 | Root_unresolved | Root_unresolved | 172 | 6.01e-52 | NR | AAA66528.1 | 10376 | g151398 | i0 | 100 | 7.96911196911197 | 86 | 0 | 99.6 | 0 | 259 | 2 | 154 | 239 | AAA66528.1 BRLF1, partial [human gammaherpesvirus 4] | diamond | 2064 | 172 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 31015751 | 31015751 | PRJNA1112809_P_NODE_191795_length_241_cov_1.833333_g188520_i0 | PRJNA1112809 | 191795 | 241 | 1.833333 | 4.41833253 | Curvibacter phage P26 | 1983783 | Viruses | Viruses | 86.3 | 1.2e-17 | NR | ASJ79173.1 | 1983783 | g188520 | i0 | 56.6 | 1.03319502074689 | 83 | 33 | 99.6 | 1 | 1 | 240 | 318 | 400 | ASJ79173.1 putative major tail structural protein [Curvibacter phage P26059A] | diamond | 249 | 86.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Curvibacter phage P26059A | |||||
| 31164593 | 31164593 | PRJNA1112809_P_NODE_186315_length_243_cov_1.382353_g183040_i0 | PRJNA1112809 | 186315 | 243 | 1.382353 | 3.35911779 | Takahashivirus | 2843463 | Viruses | Viruses | 43.9 | 0.0147 | NR | YP_009283093.1 | 1815509 | g183040 | i0 | 31.3 | 2.61728395061728 | 80 | 49 | 95.1 | 2 | 11 | 241 | 56 | 132 | YP_009283093.1 RNA polymerase beta subunit [Bacillus phage AR9] | diamond | 636 | 43.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Takahashivirus | Takahashivirus PBS1 | ||||
| 31774526 | 31774526 | PRJNA1112809_P_NODE_148017_length_265_cov_2.229167_g144742_i0 | PRJNA1112809 | 148017 | 265 | 2.229167 | 5.90729255 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.9 | 7.21e-15 | NR | XOF02443.1 | 2832643 | g144742 | i0 | 40.5 | 0.837735849056604 | 74 | 43 | 83.8 | 1 | 3 | 224 | 7 | 79 | XOF02443.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 222 | 73.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32027808 | 32027808 | PRJNA1112809_P_NODE_168258_length_250_cov_0.870056_g164983_i0 | PRJNA1112809 | 168258 | 250 | 0.870056 | 2.17514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 108 | 1.79e-25 | NR | XOS23095.1 | 2832643 | g164983 | i0 | 71.6 | 1.788 | 74 | 18 | 88.8 | 1 | 12 | 233 | 114 | 184 | XOS23095.1 MAG: hypothetical protein MSP0030_169 [Caudoviricetes sp.] | diamond | 447 | 108 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32754561 | 32754561 | PRJNA1112809_P_NODE_153780_length_260_cov_1.267380_g150505_i0 | PRJNA1112809 | 153780 | 260 | 1.26738 | 3.295188 | Ralstonia phage PY | 3145150 | Viruses | Viruses | 71.2 | 1.42e-13 | NR | XAO34305.1 | 3145150 | g150505 | i0 | 61.7 | 0.542307692307692 | 47 | 18 | 54.2 | 0 | 259 | 119 | 73 | 119 | XAO34305.1 hypothetical protein HMHLAPFJ_00011 [Ralstonia phage PY059YO380] | diamond | 141 | 71.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Ralstonia phage PY059YO380 | |||||
| 32817518 | 32817518 | PRJNA1112809_P_NODE_164060_length_251_cov_0.865169_g160785_i0 | PRJNA1112809 | 164060 | 251 | 0.865169 | 2.17157419 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 64.3 | 1.01e-9 | NR | XOS14004.1 | 2832643 | g160785 | i0 | 41 | 0.99203187250996006 | 83 | 49 | 99.2 | 0 | 251 | 3 | 252 | 334 | XOS14004.1 MAG: hypothetical protein MSP0127_74 [Caudoviricetes sp.] | diamond | 249 | 64.3 | 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);;