contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJEB11523" and tax_phylum = "Uroviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16590650 | 16590650 | PRJEB11523_P_NODE_7754_length_166_cov_0.871795_g7676_i0 | PRJEB11523 | 7754 | 166 | 0.871795 | 1.4471797 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 90.9 | 6.680000000000001e-21 | NR | XOR84851.1 | 2832643 | g7676 | i0 | 77.8 | 0.975903614457831 | 54 | 12 | 97.6 | 0 | 165 | 4 | 109 | 162 | XOR84851.1 MAG: hypothetical protein MSP1807_40 [Caudoviricetes sp.] | diamond | 162 | 90.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20414391 | 20414391 | PRJEB11523_P_NODE_657_length_744_cov_53.620144_g594_i0 | PRJEB11523 | 657 | 744 | 53.620144 | 398.93387136 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 77.4 | 3.41e-13 | NR | CAB4164374.1 | 2100421 | g594 | i0 | 50.6 | 0.326612903225806 | 81 | 36 | 32.7 | 1 | 706 | 464 | 125 | 201 | CAB4164374.1 Calcineurin-like phosphoesterase domain, ApaH type [uncultured Caudovirales phage] | diamond | 243 | 77.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 26621165 | 26621165 | PRJEB11523_P_NODE_1701_length_429_cov_16.315789_g1623_i0 | PRJEB11523 | 1701 | 429 | 16.315789 | 69.99473481 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 74.7 | 1.5e-12 | NR | XOE97089.1 | 2832643 | g1623 | i0 | 38.3 | 0.657342657342657 | 94 | 57 | 65 | 1 | 19 | 297 | 289 | 382 | XOE97089.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 282 | 74.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27158864 | 27158864 | PRJEB11523_P_NODE_4742_length_216_cov_3.449102_g4664_i0 | PRJEB11523 | 4742 | 216 | 3.449102 | 7.45006032 | Pseudomonas phage GP1 | 2055238 | Viruses | Viruses | 80.1 | 1.83e-15 | NR | SPF82110.1 | 2055238 | g4664 | i0 | 54.5 | 1.84722222222222 | 66 | 30 | 91.7 | 0 | 13 | 210 | 310 | 375 | SPF82110.1 DNA Polymerase [Pseudomonas phage GP100] | diamond | 399 | 80.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zobellviridae | Pseudomonas phage GP100 | ||||
| 27222166 | 27222166 | PRJEB11523_P_NODE_3263_length_275_cov_2.637168_g3185_i0 | PRJEB11523 | 3263 | 275 | 2.637168 | 7.252212 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 95.5 | 2.0499999999999999e-23 | NR | CAB4204047.1 | 2100421 | g3185 | i0 | 50.6 | 0.883636363636364 | 81 | 40 | 88.4 | 0 | 248 | 6 | 1 | 81 | CAB4204047.1 Protein of unknown function DUF3127 [uncultured Caudovirales phage] | diamond | 243 | 95.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27696490 | 27696490 | PRJEB11523_P_NODE_4144_length_235_cov_1.370968_g4066_i0 | PRJEB11523 | 4144 | 235 | 1.370968 | 3.2217748 | Crassvirales sp. | 2960088 | Viruses | Viruses | 63.9 | 1.13e-9 | NR | DAG93832.1 | 2960088 | g4066 | i0 | 46.2 | 0.995744680851064 | 78 | 40 | 97 | 1 | 5 | 232 | 135 | 212 | DAG93832.1 MAG TPA: amidotransferase class II [Crassvirales sp.] | diamond | 234 | 63.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Crassvirales | Crassvirales sp. | ||||
| 28232686 | 28232686 | PRJEB11523_P_NODE_4266_length_231_cov_0.967033_g4188_i0 | PRJEB11523 | 4266 | 231 | 0.967033 | 2.23384623 | Phormidium phage Pf-WMP4 | 2913979 | Viruses | Viruses | 82.8 | 2.47e-16 | NR | YP_762665.1 | 2913979 | g4188 | i0 | 59.4 | 1.58441558441558 | 64 | 26 | 83.1 | 0 | 3 | 194 | 227 | 290 | YP_762665.1 tail protein [Phormidium phage Pf-WMP4] | diamond | 366 | 82.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Saffermanviridae | Wumpquatrovirus | Wumpquatrovirus WMP4 | |||
| 28327524 | 28327524 | PRJEB11523_P_NODE_5486_length_198_cov_11.604027_g5408_i0 | PRJEB11523 | 5486 | 198 | 11.604027 | 22.97597346 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 87.4 | 1.91e-20 | NR | CAB4196850.1 | 2100421 | g5408 | i0 | 67.3 | 0.787878787878788 | 52 | 17 | 78.8 | 0 | 27 | 182 | 59 | 110 | CAB4196850.1 hypothetical protein UFOVP1290_370 [uncultured Caudovirales phage] | diamond | 156 | 87.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29211884 | 29211884 | PRJEB11523_P_NODE_3569_length_258_cov_5.645933_g3491_i0 | PRJEB11523 | 3569 | 258 | 5.645933 | 14.56650714 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 85.5 | 3.92e-17 | NR | CAB4133792.1 | 2100421 | g3491 | i0 | 59.5 | 0.86046511627907 | 74 | 28 | 83.7 | 2 | 24 | 239 | 514 | 587 | CAB4133792.1 Intramolecular chaperone auto-processing domain containing protein [uncultured Caudovirales phage] | diamond | 222 | 85.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29401144 | 29401144 | PRJEB11523_P_NODE_1629_length_443_cov_7.373096_g1551_i0 | PRJEB11523 | 1629 | 443 | 7.373096 | 32.66281528 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 139 | 9.96e-37 | NR | XOQ89889.1 | 2832643 | g1551 | i0 | 51.1 | 0.941309255079007 | 139 | 67 | 93.5 | 1 | 435 | 22 | 1 | 139 | XOQ89889.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 417 | 139 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29716642 | 29716642 | PRJEB11523_P_NODE_5410_length_200_cov_2.615894_g5332_i0 | PRJEB11523 | 5410 | 200 | 2.615894 | 5.231788 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 55.8 | 4.8e-7 | NR | DAN35668.1 | 2832643 | g5332 | i0 | 46.7 | 1.8 | 60 | 29 | 85.5 | 1 | 198 | 28 | 78 | 137 | DAN35668.1 MAG TPA: EKC/KEOPS complex subunit LAGE3, EKC/KEOPS, t6A modification, RNA BINDING, partial [Caudoviricetes sp.] | diamond | 360 | 55.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29748206 | 29748206 | PRJEB11523_P_NODE_2911_length_297_cov_3.495968_g2833_i0 | PRJEB11523 | 2911 | 297 | 3.495968 | 10.38302496 | Flavobacterium phage vB_FspS_hattifnatt9-1 | 2686246 | Viruses | Viruses | 74.7 | 1.53e-14 | NR | YP_009854656.1 | 2686246 | g2833 | i0 | 55.6 | 0.636363636363636 | 63 | 28 | 63.6 | 0 | 296 | 108 | 76 | 138 | YP_009854656.1 hypothetical protein HWC88_gp04 [Flavobacterium phage vB_FspS_hattifnatt9-1] | diamond | 189 | 74.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Hattifnattvirus | Hattifnattvirus hattifnatt | ||||
| 29906544 | 29906544 | PRJEB11523_P_NODE_7191_length_171_cov_1.672131_g7113_i0 | PRJEB11523 | 7191 | 171 | 1.672131 | 2.85934401 | Podoviridae sp. ctnCN2 | 2825274 | Viruses | Viruses | 70.9 | 1.75e-12 | NR | DAE07523.1 | 2825274 | g7113 | i0 | 66.1 | 0.982456140350877 | 56 | 19 | 98.2 | 0 | 1 | 168 | 246 | 301 | DAE07523.1 MAG TPA: DNA polymerase [Podoviridae sp. ctnCN2] | diamond | 168 | 70.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Podoviridae sp. ctnCN2 | |||||
| 30095812 | 30095812 | PRJEB11523_P_NODE_3692_length_252_cov_29.625616_g3614_i0 | PRJEB11523 | 3692 | 252 | 29.625616 | 74.65655232 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 129 | 1.87e-34 | NR | CAB4153114.1 | 2100421 | g3614 | i0 | 77.2 | 3.72619047619048 | 79 | 18 | 94 | 0 | 15 | 251 | 96 | 174 | CAB4153114.1 S-adenosyl-L-methionine-dependent methyltransferase [uncultured Caudovirales phage] | diamond | 939 | 129 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30158873 | 30158873 | PRJEB11523_P_NODE_692_length_728_cov_5.768778_g628_i0 | PRJEB11523 | 692 | 728 | 5.768778 | 41.99670384 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 117 | 5.69e-28 | NR | XOR00901.1 | 2832643 | g628 | i0 | 41.2 | 0.60989010989011 | 148 | 84 | 61 | 2 | 17 | 460 | 48 | 192 | XOR00901.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 444 | 117 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30569623 | 30569623 | PRJEB11523_P_NODE_6973_length_174_cov_1.224000_g6895_i0 | PRJEB11523 | 6973 | 174 | 1.224 | 2.12976 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 70.9 | 1.73e-12 | NR | CAB4142457.1 | 2100421 | g6895 | i0 | 59.6 | 0.896551724137931 | 52 | 21 | 89.7 | 0 | 172 | 17 | 467 | 518 | CAB4142457.1 AAA domain containing protein [uncultured Caudovirales phage] | diamond | 156 | 70.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30854178 | 30854178 | PRJEB11523_P_NODE_1554_length_455_cov_29.992611_g1476_i0 | PRJEB11523 | 1554 | 455 | 29.992611 | 136.46638005 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 64.7 | 5.78e-9 | NR | CAB4171276.1 | 2100421 | g1476 | i0 | 35.5 | 0.613186813186813 | 93 | 54 | 61.3 | 3 | 130 | 408 | 71 | 157 | CAB4171276.1 Gn_AT_II domain containing protein [uncultured Caudovirales phage] | diamond | 279 | 64.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31044154 | 31044154 | PRJEB11523_P_NODE_3675_length_253_cov_6.691176_g3597_i0 | PRJEB11523 | 3675 | 253 | 6.691176 | 16.92867528 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 84 | 1.27e-16 | NR | CAB5214222.1 | 2100421 | g3597 | i0 | 61 | 0.699604743083004 | 59 | 23 | 70 | 0 | 22 | 198 | 449 | 507 | CAB5214222.1 Phage-like element PBSX protein, XkdF [uncultured Caudovirales phage] | diamond | 177 | 84 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31169945 | 31169945 | PRJEB11523_P_NODE_7315_length_169_cov_2.116667_g7237_i0 | PRJEB11523 | 7315 | 169 | 2.116667 | 3.57716723 | Flavobacterium phage FPSV-S1 | 2575345 | Viruses | Viruses | 66.2 | 2.33e-11 | NR | QCW20360.1 | 2575345 | g7237 | i0 | 56.1 | 1.01183431952663 | 57 | 24 | 99.4 | 1 | 168 | 1 | 163 | 219 | QCW20360.1 hypothetical protein [Flavobacterium phage FPSV-S1] | diamond | 171 | 66.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Winoviridae | Flavobacterium phage FPSV-S1 | ||||
| 31454885 | 31454885 | PRJEB11523_P_NODE_396_length_957_cov_43.174009_g340_i0 | PRJEB11523 | 396 | 957 | 43.174009 | 413.17526613 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 463 | 3.389999999999999e-160 | NR | CAB5194664.1 | 2100421 | g340 | i0 | 76.1 | 0.918495297805643 | 293 | 69 | 91.5 | 1 | 888 | 13 | 1 | 293 | CAB5194664.1 Terminase-like family [uncultured Caudovirales phage] | diamond | 879 | 463 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31581501 | 31581501 | PRJEB11523_P_NODE_5116_length_207_cov_0.968354_g5038_i0 | PRJEB11523 | 5116 | 207 | 0.968354 | 2.00449278 | Mycobacterium phage Boilgate | 2859636 | Viruses | Viruses | 41.6 | 0.00915 | NR | QYC55117.1 | 2859636 | g5038 | i0 | 58.6 | 0.420289855072464 | 29 | 12 | 42 | 0 | 32 | 118 | 40 | 68 | QYC55117.1 hypothetical protein SEA_BOILGATE_36 [Mycobacterium phage Boilgate] | diamond | 87 | 41.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Mycobacterium phage Boilgate | |||||
| 31796423 | 31796423 | PRJEB11523_P_NODE_7537_length_167_cov_0.864407_g7459_i0 | PRJEB11523 | 7537 | 167 | 0.864407 | 1.44355969 | Viruses | 10239 | Viruses | Viruses | 45.1 | 0.00204 | NR | YP_008061165.1 | 1007869 | g7459 | i0 | 68.8 | 1.1497005988024 | 32 | 10 | 57.5 | 0 | 156 | 61 | 528 | 559 | YP_008061165.1 baseplate wedge subunit [Rhodococcus phage E3] | diamond | 192 | 45.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rhodococcus phage E3 | |||||
| 31897639 | 31897639 | PRJEB11523_P_NODE_3817_length_247_cov_2.414141_g3739_i0 | PRJEB11523 | 3817 | 247 | 2.414141 | 5.96292827 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 51.2 | 3.88e-5 | NR | CAB5223985.1 | 2100421 | g3739 | i0 | 80.6 | 0.437246963562753 | 36 | 7 | 43.7 | 0 | 110 | 3 | 350 | 385 | CAB5223985.1 hypothetical protein UFOVP388_40 [uncultured Caudovirales phage] | diamond | 108 | 51.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32087499 | 32087499 | PRJEB11523_P_NODE_6658_length_178_cov_1.581395_g6580_i0 | PRJEB11523 | 6658 | 178 | 1.581395 | 2.8148831 | Glutamicibacter phage Montesquieu | 2891956 | Viruses | Viruses | 67 | 4.08e-11 | NR | CAH1192963.1 | 2891956 | g6580 | i0 | 61.5 | 0.876404494382023 | 52 | 20 | 87.6 | 0 | 178 | 23 | 173 | 224 | CAH1192963.1 Endonuclease [Glutamicibacter phage Montesquieu] | diamond | 156 | 67 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Glutamicibacter phage Montesquieu |
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);;