contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA1188114" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4146908 | 4146908 | PRJNA1188114_P_NODE_17064_length_163_cov_0.894737_g17012_i0 | PRJNA1188114 | 17064 | 163 | 0.894737 | 1.45842131 | Staphylococcus phage vB_SauM_JDF86 | 3038179 | Viruses | Viruses | 61.6 | 2.4e-9 | NR | WFG33963.1 | 3038179 | g17012 | i0 | 49.1 | 1.04907975460123 | 57 | 26 | 99.4 | 1 | 162 | 1 | 44 | 100 | WFG33963.1 hypothetical protein F10086_41 [Staphylococcus phage vB_SauM_JDF86] | diamond | 171 | 61.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Baoshanvirus | Staphylococcus phage vB_SauM_JDF86 | |||
| 27641202 | 27641202 | PRJNA1188114_P_NODE_15924_length_164_cov_0.886957_g15872_i0 | PRJNA1188114 | 15924 | 164 | 0.886957 | 1.45460948 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 78.6 | 2.98e-15 | NR | XOQ88409.1 | 2832643 | g15872 | i0 | 72.2 | 0.98780487804878 | 54 | 15 | 98.8 | 0 | 162 | 1 | 202 | 255 | XOQ88409.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 162 | 78.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27956818 | 27956818 | PRJNA1188114_P_NODE_19445_length_161_cov_0.910714_g19393_i0 | PRJNA1188114 | 19445 | 161 | 0.910714 | 1.46624954 | Achromobacter phage JWF | 1589748 | Viruses | Viruses | 44.3 | 0.00315 | NR | YP_009224008.1 | 1589748 | g19393 | i0 | 46.9 | 0.91304347826087 | 49 | 26 | 91.3 | 0 | 152 | 6 | 3 | 51 | YP_009224008.1 hypothetical protein AXJ13_gp002 [Achromobacter phage JWF] | diamond | 147 | 44.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Achromobacter phage JWF | |||||
| 28177532 | 28177532 | PRJNA1188114_P_NODE_18346_length_162_cov_0.902655_g18294_i0 | PRJNA1188114 | 18346 | 162 | 0.902655 | 1.4623011 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 78.2 | 1.12e-16 | NR | XOR51484.1 | 2832643 | g18294 | i0 | 73.6 | 0.981481481481482 | 53 | 14 | 98.1 | 0 | 2 | 160 | 70 | 122 | XOR51484.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 159 | 78.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29333474 | 29333474 | PRJNA1188114_P_NODE_15389_length_164_cov_1.478261_g15337_i0 | PRJNA1188114 | 15389 | 164 | 1.478261 | 2.42434804 | Nipunavirus | 1982239 | Viruses | Viruses | 91.7 | 7.44e-20 | NR | YP_009603583.1 | 1175654 | g15337 | i0 | 79.6 | 2.96341463414634 | 54 | 11 | 98.8 | 0 | 1 | 162 | 148 | 201 | YP_009603583.1 DNA polymerase [Pseudomonas phage PaMx25] | diamond | 486 | 91.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Nipunavirus | Nipunavirus PaMx25 | ||||
| 30040768 | 30040768 | PRJNA1188114_P_NODE_7311_length_186_cov_1.489051_g7259_i0 | PRJNA1188114 | 7311 | 186 | 1.489051 | 2.76963486 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 118 | 1.14e-30 | NR | XOR59523.1 | 2832643 | g7259 | i0 | 91.8 | 0.983870967741935 | 61 | 5 | 98.4 | 0 | 3 | 185 | 140 | 200 | XOR59523.1 MAG: putative phage protein [Caudoviricetes sp.] | diamond | 183 | 118 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30451736 | 30451736 | PRJNA1188114_P_NODE_18793_length_162_cov_0.902655_g18741_i0 | PRJNA1188114 | 18793 | 162 | 0.902655 | 1.4623011 | Staphylococcus phage Alsa_1 | 3076561 | Viruses | Viruses | 59.3 | 8.89e-10 | NR | WNM50486.1 | 3076561 | g18741 | i0 | 56 | 0.925925925925926 | 50 | 21 | 92.6 | 1 | 4 | 153 | 1 | 49 | WNM50486.1 hypothetical protein Alsa1_CDS0136 [Staphylococcus phage Alsa_1] | diamond | 150 | 59.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Staphylococcus phage Alsa_1 | ||||
| 30596782 | 30596782 | PRJNA1188114_P_NODE_11573_length_169_cov_1.275000_g11521_i0 | PRJNA1188114 | 11573 | 169 | 1.275 | 2.15475 | Pradovirus | 1985733 | Viruses | Viruses | 52 | 6.67e-6 | NR | YP_009275435.1 | 1784979 | g11521 | i0 | 43.8 | 4.27810650887574 | 48 | 27 | 85.2 | 0 | 145 | 2 | 4 | 51 | YP_009275435.1 DNA primase [Xanthomonas phage f20-Xaj] | diamond | 723 | 52 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autonotataviridae | Pradovirus | Pradovirus f20 | ||
| 31273079 | 31273079 | PRJNA1188114_P_NODE_14835_length_165_cov_0.879310_g14783_i0 | PRJNA1188114 | 14835 | 165 | 0.87931 | 1.4508615 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 43.1 | 0.00956 | NR | XOS63369.1 | 2832643 | g14783 | i0 | 51 | 0.927272727272727 | 51 | 25 | 92.7 | 0 | 157 | 5 | 1080 | 1130 | XOS63369.1 MAG: hypothetical protein MSP0629_1, partial [Caudoviricetes sp.] | diamond | 153 | 43.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31715859 | 31715859 | PRJNA1188114_P_NODE_7197_length_187_cov_1.108696_g7145_i0 | PRJNA1188114 | 7197 | 187 | 1.108696 | 2.07326152 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 124 | 4.279999999999999e-34 | NR | XOR59517.1 | 2832643 | g7145 | i0 | 95.2 | 0.994652406417112 | 62 | 3 | 99.5 | 0 | 187 | 2 | 144 | 205 | XOR59517.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 186 | 124 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32158928 | 32158928 | PRJNA1188114_P_NODE_13798_length_166_cov_0.871795_g13746_i0 | PRJNA1188114 | 13798 | 166 | 0.871795 | 1.4471797 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 96.7 | 1.93e-23 | NR | XOR59527.1 | 2832643 | g13746 | i0 | 78.2 | 0.993975903614458 | 55 | 12 | 99.4 | 0 | 166 | 2 | 60 | 114 | XOR59527.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 165 | 96.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32348876 | 32348876 | PRJNA1188114_P_NODE_6579_length_189_cov_1.442857_g6527_i0 | PRJNA1188114 | 6579 | 189 | 1.442857 | 2.72699973 | Acinetobacter phage Presley | 1406780 | Viruses | Viruses | 108 | 1.68e-25 | NR | YP_009007656.1 | 1406780 | g6527 | i0 | 73 | 1 | 63 | 17 | 100 | 0 | 189 | 1 | 52 | 114 | YP_009007656.1 portal protein [Acinetobacter phage Presley] | diamond | 189 | 108 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Presleyvirus | Presleyvirus presley |
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);;