contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJEB25583" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 986402 | 986402 | PRJEB25583_P_NODE_2921_length_237_cov_2.575000_g2744_i0 | PRJEB25583 | 2921 | 237 | 2.575 | 6.10275 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 55.8 | 1.33e-7 | NR | XOS01519.1 | 2832643 | g2744 | i0 | 73 | 0.468354430379747 | 37 | 10 | 46.8 | 0 | 126 | 236 | 85 | 121 | XOS01519.1 MAG: hypothetical protein MSP1228_72 [Caudoviricetes sp.] | diamond | 111 | 55.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27222603 | 27222603 | PRJEB25583_P_NODE_7183_length_158_cov_2.735537_g7006_i0 | PRJEB25583 | 7183 | 158 | 2.735537 | 4.32214846 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 49.7 | 4.14e-5 | NR | CAB5212338.1 | 2100421 | g7006 | i0 | 49.1 | 1.00632911392405 | 53 | 26 | 98.7 | 1 | 157 | 2 | 442 | 494 | CAB5212338.1 hypothetical protein UFOVP187_1, partial [uncultured Caudovirales phage] | diamond | 159 | 49.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27444330 | 27444330 | PRJEB25583_P_NODE_7103_length_159_cov_1.418033_g6926_i0 | PRJEB25583 | 7103 | 159 | 1.418033 | 2.25467247 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 82 | 1.65e-16 | NR | DAQ76512.1 | 2832643 | g6926 | i0 | 76.9 | 0.981132075471698 | 52 | 12 | 98.1 | 0 | 2 | 157 | 619 | 670 | DAQ76512.1 MAG TPA: RNA dependent RNA polymerase [Caudoviricetes sp.] | diamond | 156 | 82 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28106962 | 28106962 | PRJEB25583_P_NODE_3845_length_207_cov_0.964706_g3668_i0 | PRJEB25583 | 3845 | 207 | 0.964706 | 1.99694142 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 114 | 1.95e-27 | NR | XOS01502.1 | 2832643 | g3668 | i0 | 80.6 | 0.971014492753623 | 67 | 13 | 97.1 | 0 | 3 | 203 | 579 | 645 | XOS01502.1 MAG: tape measure protein [Caudoviricetes sp.] | diamond | 201 | 114 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28201580 | 28201580 | PRJEB25583_P_NODE_4246_length_198_cov_1.465839_g4069_i0 | PRJEB25583 | 4246 | 198 | 1.465839 | 2.90236122 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 86.7 | 1.47e-19 | NR | CAB4145788.1 | 2100421 | g4069 | i0 | 61.5 | 0.984848484848485 | 65 | 25 | 98.5 | 0 | 196 | 2 | 15 | 79 | CAB4145788.1 Ftn Ferritin-like protein [uncultured Caudovirales phage] | diamond | 195 | 86.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28391214 | 28391214 | PRJEB25583_P_NODE_7046_length_159_cov_3.942623_g6869_i0 | PRJEB25583 | 7046 | 159 | 3.942623 | 6.26877057 | Pseudomonas phage vB_PpuM-Illi-2 | 3132640 | Viruses | Viruses | 67.8 | 1.38e-11 | NR | WYW00804.1 | 3132640 | g6869 | i0 | 62.7 | 2.90566037735849 | 51 | 19 | 96.2 | 0 | 2 | 154 | 183 | 233 | WYW00804.1 PAAR motif of membrane protein [Pseudomonas phage vB_PpuM-Illi-2] | diamond | 462 | 67.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage vB_PpuM-Illi-2 | |||||
| 28517609 | 28517609 | PRJEB25583_P_NODE_4047_length_202_cov_1.393939_g3870_i0 | PRJEB25583 | 4047 | 202 | 1.393939 | 2.81575678 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 52.4 | 5.32e-6 | NR | CAB4125486.1 | 2100421 | g3870 | i0 | 59 | 3.46039603960396 | 39 | 16 | 57.9 | 0 | 86 | 202 | 6 | 44 | CAB4125486.1 COG4186 Predicted phosphoesterase or phosphohydrolase [uncultured Caudovirales phage] | diamond | 699 | 52.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29047994 | 29047994 | PRJEB25583_P_NODE_7648_length_155_cov_1.313559_g7471_i0 | PRJEB25583 | 7648 | 155 | 1.313559 | 2.03601645 | root | 1 | Root_unresolved | Root_unresolved | 59.3 | 1.07e-8 | NR | CAB4197085.1 | 2100421 | g7471 | i0 | 52.9 | 1.9741935483871 | 51 | 24 | 98.7 | 0 | 154 | 2 | 188 | 238 | CAB4197085.1 PcnB tRNA nucleotidyltransferase/poly(A) polymerase [uncultured Caudovirales phage] | diamond | 306 | 59.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29338542 | 29338542 | PRJEB25583_P_NODE_5369_length_178_cov_1.106383_g5192_i0 | PRJEB25583 | 5369 | 178 | 1.106383 | 1.96936174 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 79.3 | 1.96e-15 | NR | CAB4242046.1 | 2100421 | g5192 | i0 | 79.6 | 0.825842696629214 | 49 | 10 | 82.6 | 0 | 154 | 8 | 191 | 239 | CAB4242046.1 hypothetical protein UFOVP86_29 [uncultured Caudovirales phage] | diamond | 147 | 79.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29780466 | 29780466 | PRJEB25583_P_NODE_5911_length_171_cov_1.313433_g5734_i0 | PRJEB25583 | 5911 | 171 | 1.313433 | 2.24597043 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 101 | 2.14e-24 | NR | XOE99716.1 | 2832643 | g5734 | i0 | 92.2 | 0.894736842105263 | 51 | 4 | 89.5 | 0 | 155 | 3 | 220 | 270 | XOE99716.1 MAG: major head protein [Caudoviricetes sp.] | diamond | 153 | 101 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29811911 | 29811911 | PRJEB25583_P_NODE_3611_length_213_cov_1.227273_g3434_i0 | PRJEB25583 | 3611 | 213 | 1.227273 | 2.61409149 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 63.9 | 7.16e-11 | NR | DAG79865.1 | 2832643 | g3434 | i0 | 70.8 | 0.676056338028169 | 48 | 14 | 67.6 | 0 | 146 | 3 | 3 | 50 | DAG79865.1 MAG TPA: head closure knob [Caudoviricetes sp.] | diamond | 144 | 63.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29938510 | 29938510 | PRJEB25583_P_NODE_2551_length_256_cov_1.497717_g2374_i0 | PRJEB25583 | 2551 | 256 | 1.497717 | 3.83415552 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 70.5 | 8.01e-13 | NR | CAB4126237.1 | 2100421 | g2374 | i0 | 46.7 | 0.87890625 | 75 | 40 | 87.9 | 0 | 23 | 247 | 55 | 129 | CAB4126237.1 hflK, HflK protein [uncultured Caudovirales phage] | diamond | 225 | 70.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30633303 | 30633303 | PRJEB25583_P_NODE_5613_length_174_cov_4.569343_g5436_i0 | PRJEB25583 | 5613 | 174 | 4.569343 | 7.95065682 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 91.3 | 1.09e-22 | NR | CAB4197014.1 | 2100421 | g5436 | i0 | 79.2 | 0.913793103448276 | 53 | 11 | 91.4 | 0 | 167 | 9 | 10 | 62 | CAB4197014.1 hypothetical protein UFOVP1290_534 [uncultured Caudovirales phage] | diamond | 159 | 91.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31107303 | 31107303 | PRJEB25583_P_NODE_7815_length_154_cov_1.299145_g7638_i0 | PRJEB25583 | 7815 | 154 | 1.299145 | 2.0006833 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 50.8 | 1.56e-5 | NR | XOR91458.1 | 2832643 | g7638 | i0 | 51.9 | 3 | 52 | 23 | 97.4 | 1 | 151 | 2 | 13 | 64 | XOR91458.1 MAG: phage tail tape measure protein [Caudoviricetes sp.] | diamond | 462 | 50.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31195386 | 31195386 | PRJEB25583_P_NODE_7255_length_158_cov_1.280992_g7078_i0 | PRJEB25583 | 7255 | 158 | 1.280992 | 2.02396736 | root | 1 | Root_unresolved | Root_unresolved | 53.9 | 1.32e-6 | NR | CAB4142727.1 | 2100421 | g7078 | i0 | 51.9 | 1.9746835443038 | 52 | 25 | 98.7 | 0 | 1 | 156 | 520 | 571 | CAB4142727.1 PolA DNA polymerase I - 3'-5' exonuclease and polymerase domains [uncultured Caudovirales phage] | diamond | 312 | 53.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31233656 | 31233656 | PRJEB25583_P_NODE_4295_length_197_cov_1.437500_g4118_i0 | PRJEB25583 | 4295 | 197 | 1.4375 | 2.831875 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 93.2 | 4.02e-21 | NR | CAB4215519.1 | 2100421 | g4118 | i0 | 76.9 | 0.989847715736041 | 65 | 15 | 99 | 0 | 195 | 1 | 208 | 272 | CAB4215519.1 hypothetical protein UFOVP1475_24 [uncultured Caudovirales phage] | diamond | 195 | 93.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31423592 | 31423592 | PRJEB25583_P_NODE_3616_length_213_cov_1.051136_g3439_i0 | PRJEB25583 | 3616 | 213 | 1.051136 | 2.23891968 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 84.7 | 4.51e-18 | NR | CAB4132611.1 | 2100421 | g3439 | i0 | 59.4 | 0.901408450704225 | 64 | 26 | 90.1 | 0 | 20 | 211 | 72 | 135 | CAB4132611.1 ATP-grasp fold, RimK-type [uncultured Caudovirales phage] | diamond | 192 | 84.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31455321 | 31455321 | PRJEB25583_P_NODE_4396_length_195_cov_1.278481_g4219_i0 | PRJEB25583 | 4396 | 195 | 1.278481 | 2.49303795 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 89.7 | 1.09e-19 | NR | XOQ93795.1 | 2832643 | g4219 | i0 | 83 | 0.815384615384615 | 53 | 9 | 81.5 | 0 | 193 | 35 | 68 | 120 | XOQ93795.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 159 | 89.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31613390 | 31613390 | PRJEB25583_P_NODE_4936_length_185_cov_1.047297_g4759_i0 | PRJEB25583 | 4936 | 185 | 1.047297 | 1.93749945 | Freshwater phage uvFW-CGR-AMD-COM-C429 | 1838153 | Viruses | Viruses | 67.8 | 1.61e-11 | NR | ANH49360.1 | 1838153 | g4759 | i0 | 70.2 | 0.762162162162162 | 47 | 14 | 76.2 | 0 | 1 | 141 | 247 | 293 | ANH49360.1 hypothetical protein uvFWCGRAMDCOMC429_037 [Freshwater phage uvFW-CGR-AMD-COM-C429] | diamond | 141 | 67.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Freshwater phage uvFW-CGR-AMD-COM-C429 | |||||
| 32119711 | 32119711 | PRJEB25583_P_NODE_7918_length_153_cov_1.801724_g7741_i0 | PRJEB25583 | 7918 | 153 | 1.801724 | 2.75663772 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 61.6 | 3.92e-10 | NR | XOQ91038.1 | 2832643 | g7741 | i0 | 51 | 0.96078431372549 | 49 | 24 | 96.1 | 0 | 1 | 147 | 74 | 122 | XOQ91038.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 147 | 61.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32562799 | 32562799 | PRJEB25583_P_NODE_8399_length_150_cov_1.681416_g8222_i0 | PRJEB25583 | 8399 | 150 | 1.681416 | 2.522124 | Flavobacterium phage vB_FspM_immuto_2-6A | 2801477 | Viruses | Viruses | 41.2 | 0.0339 | NR | YP_010114446.1 | 2801477 | g8222 | i0 | 42.9 | 0.98 | 49 | 26 | 98 | 2 | 148 | 2 | 120 | 166 | YP_010114446.1 phosphoesterase [Flavobacterium phage vB_FspM_immuto_2-6A] | diamond | 147 | 41.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Immutovirus | Immutovirus immuto | ||||
| 32814419 | 32814419 | PRJEB25583_P_NODE_5860_length_171_cov_2.925373_g5683_i0 | PRJEB25583 | 5860 | 171 | 2.925373 | 5.00238783 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 67 | 6.43e-12 | NR | CAB4130040.1 | 2100421 | g5683 | i0 | 58.5 | 1.91228070175439 | 53 | 20 | 93 | 2 | 3 | 161 | 128 | 178 | CAB4130040.1 hypothetical protein UFOVP117_225 [uncultured Caudovirales phage] | diamond | 327 | 67 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32877368 | 32877368 | PRJEB25583_P_NODE_6140_length_168_cov_1.732824_g5963_i0 | PRJEB25583 | 6140 | 168 | 1.732824 | 2.91114432 | Arthrobacter phage 1191A | 3053731 | Viruses | Viruses | 45.4 | 0.00135 | NR | WJZ27836.1 | 3053731 | g5963 | i0 | 41.8 | 0.982142857142857 | 55 | 32 | 98.2 | 0 | 167 | 3 | 183 | 237 | WJZ27836.1 endonuclease [Arthrobacter phage 1191A] | diamond | 165 | 45.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Arthrobacter phage 1191A |
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);;