contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA1160211" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24535645 | 24535645 | PRJNA1160211_S_NODE_198320_length_312_cov_23.472803_g197087_i0 | PRJNA1160211 | 198320 | 312 | 23.472803 | 73.23514536 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 180 | 3.82e-51 | NR | DAM46536.1 | 2832643 | g197087 | i0 | 92.6 | 0.913461538461538 | 95 | 7 | 91.3 | 0 | 287 | 3 | 465 | 559 | DAM46536.1 MAG TPA: DNA TOPOISOMERASE IV, B SUBUNIT [Caudoviricetes sp.] | diamond | 285 | 180 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26628836 | 26628836 | PRJNA1160211_S_NODE_32961_length_638_cov_5.329204_g31851_i0 | PRJNA1160211 | 32961 | 638 | 5.329204 | 34.00032152 | Vibrio phage vB_VcorM_GR11A | 2711164 | Viruses | Viruses | 183 | 1.0199999999999999e-52 | NR | QJT71199.1 | 2711164 | g31851 | i0 | 44.3 | 0.996865203761755 | 212 | 108 | 97.8 | 5 | 637 | 14 | 111 | 316 | QJT71199.1 Metallophos_2 domain-containing protein [Vibrio phage vB_VcorM_GR11A] | diamond | 636 | 183 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage vB_VcorM_GR11A | |||||
| 26723349 | 26723349 | PRJNA1160211_S_NODE_103401_length_450_cov_62.053050_g102175_i0 | PRJNA1160211 | 103401 | 450 | 62.05305 | 279.238725 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 63.2 | 1.7e-8 | NR | DAM33087.1 | 2832643 | g102175 | i0 | 66.7 | 0.24 | 36 | 12 | 24 | 0 | 313 | 420 | 120 | 155 | DAM33087.1 MAG TPA: Thymidylate synthase [Caudoviricetes sp.] | diamond | 108 | 63.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27166674 | 27166674 | PRJNA1160211_S_NODE_215822_length_293_cov_9.522727_g214589_i0 | PRJNA1160211 | 215822 | 293 | 9.522727 | 27.90159011 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 77.8 | 1.95e-14 | NR | XOR76547.1 | 2832643 | g214589 | i0 | 49.4 | 0.849829351535836 | 83 | 41 | 85 | 1 | 38 | 286 | 106 | 187 | XOR76547.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 249 | 77.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27166677 | 27166677 | PRJNA1160211_S_NODE_236602_length_273_cov_5.390000_g235369_i0 | PRJNA1160211 | 236602 | 273 | 5.39 | 14.7147 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 131 | 2.69e-34 | NR | CAB5218600.1 | 2100421 | g235369 | i0 | 70.9 | 1.89010989010989 | 86 | 25 | 94.5 | 0 | 15 | 272 | 298 | 383 | CAB5218600.1 COG4695 Phage-related protein [uncultured Caudovirales phage] | diamond | 516 | 131 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27514425 | 27514425 | PRJNA1160211_S_NODE_78943_length_501_cov_2.037383_g77727_i0 | PRJNA1160211 | 78943 | 501 | 2.037383 | 10.20728883 | Acidovorax phage ACP17 | 2010329 | Viruses | Viruses | 78.2 | 2.99e-15 | NR | YP_009609810.1 | 2010329 | g77727 | i0 | 34.2 | 0.682634730538922 | 114 | 73 | 68.3 | 1 | 154 | 495 | 1 | 112 | YP_009609810.1 hypothetical protein FDI24_gp210 [Acidovorax phage ACP17] | diamond | 342 | 78.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Busanvirus | Busanvirus ACP17 | ||||
| 28430159 | 28430159 | PRJNA1160211_S_NODE_253886_length_258_cov_9.529730_g252653_i0 | PRJNA1160211 | 253886 | 258 | 9.52973 | 24.5867034 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 90.1 | 8.99e-20 | NR | XOF00960.1 | 2832643 | g252653 | i0 | 79.6 | 0.627906976744186 | 54 | 11 | 62.8 | 0 | 173 | 12 | 1 | 54 | XOF00960.1 MAG: metal-dependent hydrolase [Caudoviricetes sp.] | diamond | 162 | 90.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29093233 | 29093233 | PRJNA1160211_S_NODE_159588_length_361_cov_5.145833_g158355_i0 | PRJNA1160211 | 159588 | 361 | 5.145833 | 18.57645713 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 78.6 | 4.04e-14 | NR | DAJ88753.1 | 2832643 | g158355 | i0 | 38.7 | 1.13850415512465 | 137 | 66 | 99.7 | 4 | 1 | 360 | 243 | 378 | DAJ88753.1 MAG TPA: DNA TOPOISOMERASE IV, B SUBUNIT [Caudoviricetes sp.] | diamond | 411 | 78.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29238779 | 29238779 | PRJNA1160211_S_NODE_16429_length_738_cov_3.578947_g15505_i0 | PRJNA1160211 | 16429 | 738 | 3.578947 | 26.41262886 | Viruses | 10239 | Viruses | Viruses | 228 | 1.7999999999999996e-68 | NR | QJT71040.1 | 2711164 | g15505 | i0 | 47.6 | 1.86178861788618 | 229 | 119 | 93.1 | 1 | 725 | 39 | 221 | 448 | QJT71040.1 DNA helicase [Vibrio phage vB_VcorM_GR11A] | diamond | 1374 | 228 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage vB_VcorM_GR11A | |||||
| 30325314 | 30325314 | PRJNA1160211_S_NODE_12872_length_775_cov_6.356125_g12016_i0 | PRJNA1160211 | 12872 | 775 | 6.356125 | 49.25996875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52 | 1.72e-4 | NR | DAF77141.1 | 2832643 | g12016 | i0 | 30.1 | 0.526451612903226 | 136 | 89 | 51.9 | 4 | 341 | 742 | 1 | 132 | DAF77141.1 MAG TPA: Pre-mRNA-splicing factor 8, Pre-mRNA-splicing factor, B* complex, branching, snRNP [Caudoviricetes sp.] | diamond | 408 | 52 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30325352 | 30325352 | PRJNA1160211_S_NODE_91912_length_473_cov_7.350000_g90689_i0 | PRJNA1160211 | 91912 | 473 | 7.35 | 34.7655 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 189 | 7.299999999999998e-53 | NR | XOR68119.1 | 2832643 | g90689 | i0 | 55.6 | 3.9323467230444 | 153 | 68 | 97 | 0 | 461 | 3 | 148 | 300 | XOR68119.1 MAG: conserved hypothetical phage-related protein [Caudoviricetes sp.] | diamond | 1860 | 189 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30925302 | 30925302 | PRJNA1160211_S_NODE_10474_length_809_cov_5.283967_g9675_i0 | PRJNA1160211 | 10474 | 809 | 5.283967 | 42.74729303 | Vibrio phage vB_VcorM_GR7B | 2711165 | Viruses | Viruses | 209 | 2.78e-63 | NR | QJT70858.1 | 2711165 | g9675 | i0 | 51 | 0.749072929542645 | 202 | 99 | 74.9 | 0 | 797 | 192 | 46 | 247 | QJT70858.1 hypothetical protein GR7B_00060 [Vibrio phage vB_VcorM_GR7B] | diamond | 606 | 209 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage vB_VcorM_GR7B | |||||
| 32506675 | 32506675 | PRJNA1160211_S_NODE_126359_length_411_cov_1.671598_g125128_i0 | PRJNA1160211 | 126359 | 411 | 1.671598 | 6.87026778 | Pectobacterium phage Nobby | 2320197 | Viruses | Viruses | 52.4 | 1.96e-5 | NR | YP_009812095.1 | 2320197 | g125128 | i0 | 46.8 | 0.452554744525547 | 62 | 28 | 45.3 | 2 | 320 | 135 | 2 | 58 | YP_009812095.1 hypothetical protein HOU16_gp12 [Pectobacterium phage Nobby] | diamond | 186 | 52.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autoscriptoviridae | Phimunavirus | Phimunavirus nobby | ||
| 32506724 | 32506724 | PRJNA1160211_S_NODE_9359_length_828_cov_4.735099_g8609_i0 | PRJNA1160211 | 9359 | 828 | 4.735099 | 39.20661972 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 66.6 | 1.5e-9 | NR | DAF77145.1 | 2832643 | g8609 | i0 | 30.5 | 0.851449275362319 | 118 | 77 | 41.3 | 3 | 483 | 824 | 13 | 129 | DAF77145.1 MAG TPA: putative head-tail adaptor [Caudoviricetes sp.] | diamond | 705 | 66.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32632498 | 32632498 | PRJNA1160211_S_NODE_38960_length_613_cov_27.146296_g37825_i0 | PRJNA1160211 | 38960 | 613 | 27.146296 | 166.40679448 | Siphoviridae sp. ctHip2 | 2827830 | Viruses | Viruses | 67.4 | 1.7e-9 | NR | DAF42699.1 | 2827830 | g37825 | i0 | 34.6 | 0.523654159869494 | 107 | 70 | 52.4 | 0 | 41 | 361 | 39 | 145 | DAF42699.1 MAG TPA: hypothetical protein [Siphoviridae sp. ctHip2] | diamond | 321 | 67.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctHip2 | |||||
| 32727234 | 32727234 | PRJNA1160211_S_NODE_109400_length_439_cov_25.573770_g108171_i0 | PRJNA1160211 | 109400 | 439 | 25.57377 | 112.2688503 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 105 | 2.49e-24 | NR | XOR05787.1 | 2832643 | g108171 | i0 | 59.4 | 0.656036446469248 | 96 | 38 | 65.6 | 1 | 414 | 127 | 180 | 274 | XOR05787.1 MAG: ssDNA binding, DNA repair, recombination and pre-synthesis [Caudoviricetes sp.] | diamond | 288 | 105 | 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);;