contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA773778" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4579794 | 4579794 | PRJNA773778_S_NODE_644_length_1129_cov_2.325758_g580_i0 | PRJNA773778 | 644 | 1129 | 2.325758 | 26.25780782 | Streptococcus phage vB_SbRt-pBovineS21 | 2961981 | Viruses | Viruses | 470 | 4.459999999999999e-157 | NR | UVD41280.1 | 2961981 | g580 | i0 | 63.9 | 1.96368467670505 | 371 | 126 | 97.8 | 4 | 2 | 1105 | 400 | 765 | UVD41280.1 DNA polymerase [Streptococcus phage vB_SbRt-pBovineS21] | diamond | 2217 | 470 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rountreeviridae | Streptococcus phage vB_SbRt-pBovineS21 | ||||
| 8404262 | 8404262 | PRJNA773778_S_NODE_27_length_3070_cov_2.911245_g23_i0 | PRJNA773778 | 27 | 3070 | 2.911245 | 89.3752215 | Streptococcus phage C1 | 2907838 | Viruses | Viruses | 347 | 2.8399999999999994e-106 | NR | NP_852022.1 | 2907838 | g23 | i0 | 57.5 | 0.319543973941368 | 327 | 113 | 31.1 | 5 | 3068 | 2115 | 81 | 390 | NP_852022.1 major head protein [Streptococcus phage C1] | diamond | 981 | 347 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rountreeviridae | Fischettivirus | Fischettivirus C1 | |||
| 9679318 | 9679318 | PRJNA773778_S_NODE_1708_length_785_cov_1.637640_g1586_i0 | PRJNA773778 | 1708 | 785 | 1.63764 | 12.855474 | Streptococcus phage C1 | 2907838 | Viruses | Viruses | 283 | 9.28e-91 | NR | NP_852022.1 | 2907838 | g1586 | i0 | 66.4 | 0.817834394904459 | 214 | 67 | 80.3 | 2 | 682 | 53 | 3 | 215 | NP_852022.1 major head protein [Streptococcus phage C1] | diamond | 642 | 283 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rountreeviridae | Fischettivirus | Fischettivirus C1 | |||
| 13504569 | 13504569 | PRJNA773778_S_NODE_1551_length_816_cov_1.790040_g1432_i0 | PRJNA773778 | 1551 | 816 | 1.79004 | 14.6067264 | Streptococcus phage vB_SbRt-pBovineS21 | 2961981 | Viruses | Viruses | 185 | 3.74e-53 | NR | UVD41290.1 | 2961981 | g1432 | i0 | 49.7 | 0.709558823529412 | 193 | 92 | 70.2 | 3 | 622 | 50 | 8 | 197 | UVD41290.1 upper collar protein [Streptococcus phage vB_SbRt-pBovineS21] | diamond | 579 | 185 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rountreeviridae | Streptococcus phage vB_SbRt-pBovineS21 | ||||
| 19878394 | 19878394 | PRJNA773778_S_NODE_56_length_2435_cov_3.255292_g23_i1 | PRJNA773778 | 56 | 2435 | 3.255292 | 79.2663602 | Streptococcus phage C1 | 2907838 | Viruses | Viruses | 347 | 3.08e-108 | NR | NP_852022.1 | 2907838 | g23 | i1 | 57.5 | 0.402874743326489 | 327 | 113 | 39.2 | 5 | 2433 | 1480 | 81 | 390 | NP_852022.1 major head protein [Streptococcus phage C1] | diamond | 981 | 347 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rountreeviridae | Fischettivirus | Fischettivirus C1 | |||
| 26800131 | 26800131 | PRJNA773778_S_NODE_4341_length_577_cov_6.263889_g4193_i0 | PRJNA773778 | 4341 | 577 | 6.263889 | 36.14263953 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 52 | 2.48e-4 | NR | CAB4140766.1 | 2100421 | g4193 | i0 | 48.8 | 0.21317157712305 | 41 | 19 | 21.3 | 1 | 420 | 542 | 1 | 39 | CAB4140766.1 hypothetical protein UFOVP395_101 [uncultured Caudovirales phage] | diamond | 123 | 52 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28095650 | 28095650 | PRJNA773778_S_NODE_785_length_1049_cov_4.102459_g712_i0 | PRJNA773778 | 785 | 1049 | 4.102459 | 43.03479491 | Streptococcus phage C1 | 2907838 | Viruses | Viruses | 142 | 8.099999999999998e-35 | NR | NP_852022.1 | 2907838 | g712 | i0 | 66.7 | 0.283126787416587 | 99 | 33 | 28.3 | 0 | 753 | 1049 | 3 | 101 | NP_852022.1 major head protein [Streptococcus phage C1] | diamond | 297 | 142 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rountreeviridae | Fischettivirus | Fischettivirus C1 | |||
| 28159033 | 28159033 | PRJNA773778_S_NODE_1505_length_825_cov_1.577128_g1390_i0 | PRJNA773778 | 1505 | 825 | 1.577128 | 13.011306 | Streptococcus phage vB_SbRt-pBovineS21 | 2961981 | Viruses | Viruses | 127 | 3.8e-29 | NR | UVD41285.1 | 2961981 | g1390 | i0 | 33.6 | 3.01454545454545 | 277 | 170 | 98.9 | 7 | 821 | 6 | 193 | 460 | UVD41285.1 tail fiber protein [Streptococcus phage vB_SbRt-pBovineS21] | diamond | 2487 | 127 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rountreeviridae | Streptococcus phage vB_SbRt-pBovineS21 | ||||
| 28284862 | 28284862 | PRJNA773778_S_NODE_35226_length_265_cov_2.234375_g35076_i0 | PRJNA773778 | 35226 | 265 | 2.234375 | 5.92109375 | Streptococcus phage C1 | 2907838 | Viruses | Viruses | 106 | 4.31e-25 | NR | NP_852022.1 | 2907838 | g35076 | i0 | 58.2 | 1.03018867924528 | 91 | 33 | 98.5 | 2 | 263 | 3 | 113 | 202 | NP_852022.1 major head protein [Streptococcus phage C1] | diamond | 273 | 106 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rountreeviridae | Fischettivirus | Fischettivirus C1 | |||
| 28537890 | 28537890 | PRJNA773778_S_NODE_987_length_965_cov_2.676009_g900_i0 | PRJNA773778 | 987 | 965 | 2.676009 | 25.82348685 | Streptococcus phage vB_SbRt-pBovineS21 | 2961981 | Viruses | Viruses | 209 | 7.520000000000001e-59 | NR | UVD41285.1 | 2961981 | g900 | i0 | 45 | 1.71917098445596 | 251 | 125 | 74 | 3 | 44 | 757 | 1 | 251 | UVD41285.1 tail fiber protein [Streptococcus phage vB_SbRt-pBovineS21] | diamond | 1659 | 209 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rountreeviridae | Streptococcus phage vB_SbRt-pBovineS21 | ||||
| 28916342 | 28916342 | PRJNA773778_S_NODE_40808_length_250_cov_2.271186_g40658_i0 | PRJNA773778 | 40808 | 250 | 2.271186 | 5.677965 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 4.85e-8 | NR | DAT45187.1 | 2832643 | g40658 | i0 | 69.7 | 0.396 | 33 | 10 | 39.6 | 0 | 69 | 167 | 2 | 34 | DAT45187.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 99 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29043058 | 29043058 | PRJNA773778_S_NODE_8288_length_462_cov_1.879177_g8138_i0 | PRJNA773778 | 8288 | 462 | 1.879177 | 8.68179774 | Streptococcus phage C1 | 2907838 | Viruses | Viruses | 171 | 3.69e-46 | NR | NP_852013.1 | 2907838 | g8138 | i0 | 62 | 0.837662337662338 | 129 | 49 | 83.8 | 0 | 76 | 462 | 146 | 274 | NP_852013.1 DNA polymerase [Streptococcus phage C1] | diamond | 387 | 171 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rountreeviridae | Fischettivirus | Fischettivirus C1 | |||
| 29737246 | 29737246 | PRJNA773778_S_NODE_18150_length_341_cov_1.802239_g18000_i0 | PRJNA773778 | 18150 | 341 | 1.802239 | 6.14563499 | Streptococcus phage C1 | 2907838 | Viruses | Viruses | 137 | 9.24e-35 | NR | NP_852013.1 | 2907838 | g18000 | i0 | 57.5 | 0.994134897360704 | 113 | 48 | 99.4 | 0 | 3 | 341 | 155 | 267 | NP_852013.1 DNA polymerase [Streptococcus phage C1] | diamond | 339 | 137 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rountreeviridae | Fischettivirus | Fischettivirus C1 | |||
| 30243037 | 30243037 | PRJNA773778_S_NODE_29012_length_287_cov_0.864486_g28862_i0 | PRJNA773778 | 29012 | 287 | 0.864486 | 2.48107482 | Streptococcus phage vB_SbRt-pBovineS21 | 2961981 | Viruses | Viruses | 168 | 2.26e-46 | NR | UVD41280.1 | 2961981 | g28862 | i0 | 83.7 | 1.92334494773519 | 92 | 15 | 96.2 | 0 | 11 | 286 | 531 | 622 | UVD41280.1 DNA polymerase [Streptococcus phage vB_SbRt-pBovineS21] | diamond | 552 | 168 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rountreeviridae | Streptococcus phage vB_SbRt-pBovineS21 | ||||
| 30464513 | 30464513 | PRJNA773778_S_NODE_33053_length_272_cov_2.321608_g32903_i0 | PRJNA773778 | 33053 | 272 | 2.321608 | 6.31477376 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 85.1 | 2.82e-18 | NR | DAJ88160.1 | 2832643 | g32903 | i0 | 65.5 | 0.606617647058823 | 55 | 19 | 60.7 | 0 | 167 | 3 | 16 | 70 | DAJ88160.1 MAG TPA: hypothetical protein, partial [Caudoviricetes sp.] | diamond | 165 | 85.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31253985 | 31253985 | PRJNA773778_S_NODE_10635_length_420_cov_1.642651_g10485_i0 | PRJNA773778 | 10635 | 420 | 1.642651 | 6.8991342 | Streptococcus phage vB_SbRt-pBovineS21 | 2961981 | Viruses | Viruses | 124 | 5.58e-30 | NR | UVD41280.1 | 2961981 | g10485 | i0 | 50.4 | 0.992857142857143 | 139 | 68 | 98.6 | 1 | 7 | 420 | 108 | 246 | UVD41280.1 DNA polymerase [Streptococcus phage vB_SbRt-pBovineS21] | diamond | 417 | 124 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rountreeviridae | Streptococcus phage vB_SbRt-pBovineS21 | ||||
| 32076503 | 32076503 | PRJNA773778_S_NODE_43278_length_247_cov_1.287356_g43128_i0 | PRJNA773778 | 43278 | 247 | 1.287356 | 3.17976932 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 112 | 1.57e-26 | NR | QHJ84213.1 | 2832643 | g43128 | i0 | 72 | 0.910931174089069 | 75 | 20 | 91.1 | 1 | 227 | 3 | 395 | 468 | QHJ84213.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 225 | 112 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32361503 | 32361503 | PRJNA773778_S_NODE_37959_length_257_cov_1.597826_g37809_i0 | PRJNA773778 | 37959 | 257 | 1.597826 | 4.10641282 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 84 | 3.38e-19 | NR | DAR99093.1 | 2832643 | g37809 | i0 | 62.7 | 0.782101167315175 | 67 | 25 | 78.2 | 0 | 3 | 203 | 4 | 70 | DAR99093.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 201 | 84 | 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);;