contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJNA635874" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18459071 | 18459071 | PRJNA635874_P_NODE_19935_length_353_cov_1.100000_g19788_i0 | PRJNA635874 | 19935 | 353 | 1.1 | 3.883 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 185 | 1.04e-53 | NR | XOS43889.1 | 2832643 | g19788 | i0 | 75.9 | 1.87818696883853 | 116 | 28 | 98.6 | 0 | 5 | 352 | 97 | 212 | XOS43889.1 MAG: phage protein [Caudoviricetes sp.] | diamond | 663 | 185 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26637749 | 26637749 | PRJNA635874_P_NODE_58741_length_246_cov_0.890173_g58594_i0 | PRJNA635874 | 58741 | 246 | 0.890173 | 2.18982558 | Campylobacter phage CJLB-4 | 2781358 | Viruses | Viruses | 67.4 | 1.66e-12 | NR | QPB10280.1 | 2781358 | g58594 | i0 | 62.3 | 0.646341463414634 | 53 | 20 | 64.6 | 0 | 231 | 73 | 37 | 89 | QPB10280.1 hypothetical protein [Campylobacter phage CJLB-4] | diamond | 159 | 67.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lambdavirus | Campylobacter phage CJLB-4 | ||||
| 26732445 | 26732445 | PRJNA635874_P_NODE_9241_length_479_cov_1.546798_g9094_i0 | PRJNA635874 | 9241 | 479 | 1.546798 | 7.40916242 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 112 | 9.32e-29 | NR | DAH93386.1 | 2832643 | g9094 | i0 | 62.4 | 0.532359081419624 | 85 | 32 | 53.2 | 0 | 256 | 2 | 1 | 85 | DAH93386.1 MAG TPA: hypothetical protein, partial [Caudoviricetes sp.] | diamond | 255 | 112 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26859841 | 26859841 | PRJNA635874_P_NODE_62761_length_245_cov_0.895349_g62614_i0 | PRJNA635874 | 62761 | 245 | 0.895349 | 2.19360505 | Stenotrophomonas phage Silvanus | 2859659 | Viruses | Viruses | 81.6 | 7.76e-16 | NR | QYW02488.1 | 2859659 | g62614 | i0 | 62.8 | 0.955102040816327 | 78 | 29 | 95.5 | 0 | 236 | 3 | 803 | 880 | QYW02488.1 tape measure protein [Stenotrophomonas phage Silvanus] | diamond | 234 | 81.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Stenotrophomonas phage Silvanus | |||||
| 27365763 | 27365763 | PRJNA635874_P_NODE_64003_length_244_cov_0.900585_g63856_i0 | PRJNA635874 | 64003 | 244 | 0.900585 | 2.1974274 | Staphylococcus phage S-CoN_Ph17 | 3076573 | Viruses | Viruses | 149 | 4.729999999999999e-42 | NR | WNM54416.1 | 3076573 | g63856 | i0 | 92.5 | 2.95081967213115 | 80 | 6 | 98.4 | 0 | 241 | 2 | 61 | 140 | WNM54416.1 portal protein [Staphylococcus phage S-CoN_Ph17] | diamond | 720 | 149 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sextaecvirus | Staphylococcus phage S-CoN_Ph17 | ||||
| 27776131 | 27776131 | PRJNA635874_P_NODE_58244_length_247_cov_0.879310_g58097_i0 | PRJNA635874 | 58244 | 247 | 0.87931 | 2.1718957 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 70.1 | 8.78e-12 | NR | CAB4241496.1 | 2100421 | g58097 | i0 | 41.8 | 0.959514170040486 | 79 | 46 | 96 | 0 | 237 | 1 | 30 | 108 | CAB4241496.1 Myoviridae tail sheath stabiliser [uncultured Caudovirales phage] | diamond | 237 | 70.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27933815 | 27933815 | PRJNA635874_P_NODE_36805_length_279_cov_1.097087_g36658_i0 | PRJNA635874 | 36805 | 279 | 1.097087 | 3.06087273 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 112 | 1.9e-26 | NR | XOS19684.1 | 2832643 | g36658 | i0 | 63.9 | 0.89247311827957 | 83 | 30 | 89.2 | 0 | 4 | 252 | 238 | 320 | XOS19684.1 MAG: putative tail fiber protein [Caudoviricetes sp.] | diamond | 249 | 112 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30017902 | 30017902 | PRJNA635874_P_NODE_70131_length_242_cov_0.911243_g69984_i0 | PRJNA635874 | 70131 | 242 | 0.911243 | 2.20520806 | Acinetobacter phage vB_AbaP_Acibel | 2865959 | Viruses | Viruses | 123 | 1.18e-32 | NR | YP_009103227.1 | 1481187 | g69984 | i0 | 67.5 | 0.991735537190083 | 80 | 26 | 99.2 | 0 | 3 | 242 | 28 | 107 | YP_009103227.1 DNA primase [Acinetobacter phage vB_AbaP_Acibel007] | diamond | 240 | 123 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autoscriptoviridae | Daemvirus | Daemvirus acibel007 | ||
| 31376690 | 31376690 | PRJNA635874_P_NODE_21716_length_342_cov_1.144981_g21569_i0 | PRJNA635874 | 21716 | 342 | 1.144981 | 3.91583502 | Escherichia phage Lambda | 2681611 | Viruses | Viruses | 71.2 | 8.07e-14 | NR | NP_040643.1 | 2681611 | g21569 | i0 | 46.9 | 0.56140350877193 | 64 | 34 | 56.1 | 0 | 205 | 14 | 1 | 64 | NP_040643.1 hypothetical protein lambdap73 [Escherichia phage Lambda] | diamond | 192 | 71.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lambdavirus | Lambdavirus lambda | ||||
| 31882524 | 31882524 | PRJNA635874_P_NODE_26517_length_317_cov_1.618852_g26370_i0 | PRJNA635874 | 26517 | 317 | 1.618852 | 5.13176084 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 97.4 | 4.599999999999999e-24 | NR | XOR26773.1 | 2832643 | g26370 | i0 | 94 | 0.473186119873817 | 50 | 3 | 47.3 | 0 | 151 | 2 | 1 | 50 | XOR26773.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 150 | 97.4 | 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);;