contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA395690" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9339691 | 9339691 | PRJNA395690_P_NODE_16568_length_199_cov_3.113333_g16416_i0 | PRJNA395690 | 16568 | 199 | 3.113333 | 6.19553267 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 87.8 | 3.28e-19 | NR | XOR63532.1 | 2832643 | g16416 | i0 | 87.5 | 0.603015075376884 | 40 | 5 | 60.3 | 0 | 198 | 79 | 210 | 249 | XOR63532.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 120 | 87.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26600241 | 26600241 | PRJNA395690_P_NODE_9141_length_269_cov_1.536364_g8989_i0 | PRJNA395690 | 9141 | 269 | 1.536364 | 4.13281916 | Rhizobium phage RHEph12 | 2836128 | Viruses | Viruses | 58.9 | 9.35e-8 | NR | QXV74108.1 | 2836128 | g8989 | i0 | 39.3 | 0.992565055762082 | 89 | 44 | 98.1 | 3 | 264 | 1 | 39 | 118 | QXV74108.1 hypothetical protein [Rhizobium phage RHEph12] | diamond | 267 | 58.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rhizobium phage RHEph12 | |||||
| 26726773 | 26726773 | PRJNA395690_P_NODE_24561_length_176_cov_1.125984_g24409_i0 | PRJNA395690 | 24561 | 176 | 1.125984 | 1.98173184 | Bacillus phage vB_BanS-Thrax4 | 2951252 | Viruses | Viruses | 88.2 | 1.36e-18 | NR | UUV46691.1 | 2951252 | g24409 | i0 | 78 | 3.5625 | 50 | 11 | 85.2 | 0 | 175 | 26 | 229 | 278 | UUV46691.1 portal protein [Bacillus phage vB_BanS-Thrax4] | diamond | 627 | 88.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Tsamsavirus | Bacillus phage vB_BanS-Thrax4 | ||||
| 26822364 | 26822364 | PRJNA395690_P_NODE_5761_length_335_cov_1.272727_g5611_i0 | PRJNA395690 | 5761 | 335 | 1.272727 | 4.26363545 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 102 | 4.34e-25 | NR | XOR29226.1 | 2832643 | g5611 | i0 | 84.2 | 0.51044776119403 | 57 | 9 | 51 | 0 | 2 | 172 | 70 | 126 | XOR29226.1 MAG: putative phage structural protein [Caudoviricetes sp.] | diamond | 171 | 102 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26885701 | 26885701 | PRJNA395690_P_NODE_15101_length_209_cov_1.293750_g14949_i0 | PRJNA395690 | 15101 | 209 | 1.29375 | 2.7039375 | Agrobacterium phage Atu_ph | 3435407 | Viruses | Viruses | 52 | 1.3e-5 | NR | YP_009612363.1 | 2024264 | g14949 | i0 | 56.8 | 0.5311004784689 | 37 | 16 | 53.1 | 0 | 2 | 112 | 544 | 580 | YP_009612363.1 virion structural protein [Agrobacterium phage Atu_ph07] | diamond | 111 | 52 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Polybotosvirus | Polybotosvirus Atuph07 | ||||
| 27075332 | 27075332 | PRJNA395690_P_NODE_24302_length_176_cov_1.606299_g24150_i0 | PRJNA395690 | 24302 | 176 | 1.606299 | 2.82708624 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.6 | 1.56e-13 | NR | XOS27320.1 | 2832643 | g24150 | i0 | 72.9 | 0.818181818181818 | 48 | 13 | 81.8 | 0 | 32 | 175 | 1 | 48 | XOS27320.1 MAG: hypothetical protein MSP0001_128 [Caudoviricetes sp.] | diamond | 144 | 73.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27201578 | 27201578 | PRJNA395690_P_NODE_29102_length_166_cov_2.564103_g28950_i0 | PRJNA395690 | 29102 | 166 | 2.564103 | 4.25641098 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 69.7 | 9.54e-13 | NR | XOR29222.1 | 2832643 | g28950 | i0 | 58.2 | 0.993975903614458 | 55 | 23 | 99.4 | 0 | 1 | 165 | 137 | 191 | XOR29222.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 165 | 69.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27328317 | 27328317 | PRJNA395690_P_NODE_10423_length_252_cov_1.640394_g10271_i0 | PRJNA395690 | 10423 | 252 | 1.640394 | 4.13379288 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 93.2 | 6.69e-22 | NR | XOS54562.1 | 2832643 | g10271 | i0 | 63.8 | 0.821428571428571 | 69 | 25 | 82.1 | 0 | 25 | 231 | 63 | 131 | XOS54562.1 MAG: hypothetical protein MSP0309_123 [Caudoviricetes sp.] | diamond | 207 | 93.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28370171 | 28370171 | PRJNA395690_P_NODE_26306_length_171_cov_2.360656_g26154_i0 | PRJNA395690 | 26306 | 171 | 2.360656 | 4.03672176 | Bacillus phage | 458639 | Viruses | Viruses | 45.1 | 0.00179 | NR | YP_001429701.1 | 458639 | g26154 | i0 | 39.3 | 0.982456140350877 | 56 | 32 | 94.7 | 1 | 3 | 164 | 113 | 168 | YP_001429701.1 HsdM [Bacillus phage 0305phi8-36] | diamond | 168 | 45.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Bacillus phage 0305phi8-36 | |||||
| 28433433 | 28433433 | PRJNA395690_P_NODE_34226_length_162_cov_1.469027_g34074_i0 | PRJNA395690 | 34226 | 162 | 1.469027 | 2.37982374 | Bacillus phage vB_BanS_Skywalker | 2894789 | Viruses | Viruses | 50.1 | 3.2e-5 | NR | YP_010680710.1 | 2894789 | g34074 | i0 | 47.1 | 3.77777777777778 | 51 | 27 | 94.4 | 0 | 6 | 158 | 2768 | 2818 | YP_010680710.1 tail length tape measure protein [Bacillus phage vB_BanS_Skywalker] | diamond | 612 | 50.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Tsamsavirus | Tsamsavirus skywalker | ||||
| 29601304 | 29601304 | PRJNA395690_P_NODE_15650_length_205_cov_2.269231_g15498_i0 | PRJNA395690 | 15650 | 205 | 2.269231 | 4.65192355 | Vibrio phage vB_VcorM_GR7B | 2711165 | Viruses | Viruses | 51.6 | 1.27e-5 | NR | QJT70928.1 | 2711165 | g15498 | i0 | 50 | 0.64390243902439 | 44 | 21 | 62.9 | 1 | 16 | 144 | 193 | 236 | QJT70928.1 hypothetical protein GR7B_00130 [Vibrio phage vB_VcorM_GR7B] | diamond | 132 | 51.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage vB_VcorM_GR7B | |||||
| 29917519 | 29917519 | PRJNA395690_P_NODE_24711_length_175_cov_1.619048_g24559_i0 | PRJNA395690 | 24711 | 175 | 1.619048 | 2.833334 | Bacillus phage vB_BcoS-136 | 2419619 | Viruses | Viruses | 87.8 | 1.49e-18 | NR | YP_010681548.1 | 2419619 | g24559 | i0 | 72.7 | 0.942857142857143 | 55 | 15 | 94.3 | 0 | 173 | 9 | 213 | 267 | YP_010681548.1 DNA ligase [Bacillus phage vB_BcoS-136] | diamond | 165 | 87.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Kenyattavirus | Kenyattavirus kv136 | ||||
| 30075215 | 30075215 | PRJNA395690_P_NODE_24132_length_177_cov_1.007812_g23980_i0 | PRJNA395690 | 24132 | 177 | 1.007812 | 1.78382724 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 67.4 | 3.4e-12 | NR | XOR28709.1 | 2832643 | g23980 | i0 | 66.7 | 1.54237288135593 | 45 | 15 | 76.3 | 0 | 176 | 42 | 13 | 57 | XOR28709.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 273 | 67.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30106837 | 30106837 | PRJNA395690_P_NODE_28212_length_167_cov_1.296610_g28060_i0 | PRJNA395690 | 28212 | 167 | 1.29661 | 2.1653387 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 83.6 | 4.08e-17 | NR | XOR46457.1 | 2832643 | g28060 | i0 | 74.5 | 1.97604790419162 | 55 | 14 | 98.8 | 0 | 165 | 1 | 16 | 70 | XOR46457.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 330 | 83.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30360188 | 30360188 | PRJNA395690_P_NODE_26792_length_170_cov_1.950413_g26640_i0 | PRJNA395690 | 26792 | 170 | 1.950413 | 3.3157021 | Bacillus phage pW2 | 2500559 | Viruses | Viruses | 86.7 | 6.51e-19 | NR | YP_010680046.1 | 2500559 | g26640 | i0 | 67.9 | 1.97647058823529 | 56 | 18 | 98.8 | 0 | 170 | 3 | 11 | 66 | YP_010680046.1 putative structural protein [Bacillus phage pW2] | diamond | 336 | 86.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sophritavirus | Sophritavirus pW2 | ||||
| 30454788 | 30454788 | PRJNA395690_P_NODE_14313_length_215_cov_1.228916_g14161_i0 | PRJNA395690 | 14313 | 215 | 1.228916 | 2.6421694 | Erwinia phage pEa_SNUABM_37 | 2859246 | Viruses | Viruses | 71.6 | 1.5e-13 | NR | QXO10073.1 | 2859246 | g14161 | i0 | 45.9 | 2.05116279069767 | 74 | 35 | 96.3 | 1 | 210 | 4 | 33 | 106 | QXO10073.1 hypothetical protein pEaSNUABM37_00112 [Erwinia phage pEa_SNUABM_37] | diamond | 441 | 71.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Erwinia phage pEa_SNUABM_37 | |||||
| 30643919 | 30643919 | PRJNA395690_P_NODE_33593_length_163_cov_0.894737_g33441_i0 | PRJNA395690 | 33593 | 163 | 0.894737 | 1.45842131 | Acinetobacter phage vB_AbaM_ME3 | 1837876 | Viruses | Viruses | 63.9 | 4.23e-10 | NR | YP_009595852.1 | 1837876 | g33441 | i0 | 54.7 | 0.975460122699387 | 53 | 24 | 97.5 | 0 | 5 | 163 | 129 | 181 | YP_009595852.1 hypothetical protein FDH01_gp020 [Acinetobacter phage vB_AbaM_ME3] | diamond | 159 | 63.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Metrivirus | Metrivirus ME3 | ||||
| 31212358 | 31212358 | PRJNA395690_P_NODE_31295_length_165_cov_0.879310_g31143_i0 | PRJNA395690 | 31295 | 165 | 0.87931 | 1.4508615 | Rhizobium phage RHph_I42 | 2509736 | Viruses | Viruses | 62 | 2.02e-9 | NR | QIG74767.1 | 2509736 | g31143 | i0 | 51 | 0.890909090909091 | 49 | 24 | 89.1 | 0 | 151 | 5 | 246 | 294 | QIG74767.1 tail sheath protein [Rhizobium phage RHph_I42] | diamond | 147 | 62 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rhizobium phage RHph_I42 | |||||
| 31307600 | 31307600 | PRJNA395690_P_NODE_24275_length_176_cov_1.669291_g24123_i0 | PRJNA395690 | 24275 | 176 | 1.669291 | 2.93795216 | Stenotrophomonas phage RAS14 | 2996120 | Viruses | Viruses | 50.4 | 2.84e-5 | NR | WAX21787.1 | 2996120 | g24123 | i0 | 41.4 | 0.988636363636364 | 58 | 31 | 97.2 | 2 | 172 | 2 | 11 | 66 | WAX21787.1 hypothetical protein [Stenotrophomonas phage RAS14] | diamond | 174 | 50.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Stenotrophomonas phage RAS14 | |||||
| 31655423 | 31655423 | PRJNA395690_P_NODE_35757_length_161_cov_0.910714_g35605_i0 | PRJNA395690 | 35757 | 161 | 0.910714 | 1.46624954 | Cytobacillus phage Bfsp1 | 2961991 | Viruses | Viruses | 78.6 | 2.85e-15 | NR | UTC25172.1 | 2961991 | g35605 | i0 | 78 | 0.763975155279503 | 41 | 9 | 76.4 | 0 | 160 | 38 | 549 | 589 | UTC25172.1 tail fibers protein [Cytobacillus phage Bfsp1] | diamond | 123 | 78.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Salasmaviridae | Cytobacillus phage Bfsp1 | ||||
| 31687147 | 31687147 | PRJNA395690_P_NODE_19677_length_187_cov_1.826087_g19525_i0 | PRJNA395690 | 19677 | 187 | 1.826087 | 3.41478269 | Bacillus phage vB_BcoS-136 | 2419619 | Viruses | Viruses | 92.8 | 4.14e-20 | NR | YP_010681477.1 | 2419619 | g19525 | i0 | 69.4 | 1.98930481283422 | 62 | 19 | 99.5 | 0 | 186 | 1 | 597 | 658 | YP_010681477.1 AAA-like domain protein [Bacillus phage vB_BcoS-136] | diamond | 372 | 92.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Kenyattavirus | Kenyattavirus kv136 | ||||
| 31718880 | 31718880 | PRJNA395690_P_NODE_19157_length_188_cov_2.726619_g19005_i0 | PRJNA395690 | 19157 | 188 | 2.726619 | 5.12604372 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 53.1 | 3.67e-6 | NR | XOS28129.1 | 2832643 | g19005 | i0 | 48.3 | 0.925531914893617 | 58 | 30 | 92.6 | 0 | 182 | 9 | 253 | 310 | XOS28129.1 MAG: hypothetical protein MSP0001_937 [Caudoviricetes sp.] | diamond | 174 | 53.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31940155 | 31940155 | PRJNA395690_P_NODE_6837_length_308_cov_2.938224_g6685_i0 | PRJNA395690 | 6837 | 308 | 2.938224 | 9.04972992 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 165 | 1.01e-48 | NR | XOR63532.1 | 2832643 | g6685 | i0 | 78.2 | 0.983766233766234 | 101 | 22 | 98.4 | 0 | 5 | 307 | 71 | 171 | XOR63532.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 303 | 165 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32193517 | 32193517 | PRJNA395690_P_NODE_9918_length_258_cov_1.464115_g9766_i0 | PRJNA395690 | 9918 | 258 | 1.464115 | 3.7774167 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 49.3 | 2.15e-4 | NR | XOS28128.1 | 2832643 | g9766 | i0 | 38 | 0.918604651162791 | 79 | 47 | 89.5 | 1 | 235 | 5 | 351 | 429 | XOS28128.1 MAG: hypothetical protein MSP0001_936 [Caudoviricetes sp.] | diamond | 237 | 49.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32225173 | 32225173 | PRJNA395690_P_NODE_35638_length_161_cov_0.910714_g35486_i0 | PRJNA395690 | 35638 | 161 | 0.910714 | 1.46624954 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 107 | 1.03e-25 | NR | CAB4241121.1 | 2100421 | g35486 | i0 | 88.7 | 12.7453416149068 | 53 | 6 | 98.8 | 0 | 3 | 161 | 339 | 391 | CAB4241121.1 DEXDc domain containing protein [uncultured Caudovirales phage] | diamond | 2052 | 107 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32320349 | 32320349 | PRJNA395690_P_NODE_30319_length_165_cov_3.017241_g30167_i0 | PRJNA395690 | 30319 | 165 | 3.017241 | 4.97844765 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 49.3 | 5.75e-5 | NR | XOR29233.1 | 2832643 | g30167 | i0 | 52.2 | 0.836363636363636 | 46 | 22 | 83.6 | 0 | 165 | 28 | 146 | 191 | XOR29233.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 138 | 49.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32635824 | 32635824 | PRJNA395690_P_NODE_20120_length_186_cov_1.817518_g19968_i0 | PRJNA395690 | 20120 | 186 | 1.817518 | 3.38058348 | Thermus phage TSP4 | 1298530 | Viruses | Viruses | 46.2 | 0.00101 | NR | QAY18172.1 | 1298530 | g19968 | i0 | 73.1 | 0.419354838709677 | 26 | 7 | 41.9 | 0 | 182 | 105 | 306 | 331 | QAY18172.1 hypothetical protein [Thermus phage TSP4] | diamond | 78 | 46.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Oshimavirus | Thermus phage TSP4 |
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);;