contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA1199330" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26819569 | 26819569 | PRJNA1199330_P_NODE_69201_length_282_cov_2.636364_g68502_i0 | PRJNA1199330 | 69201 | 282 | 2.636364 | 7.43454648 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 187 | 4.85e-56 | NR | XOS63399.1 | 2832643 | g68502 | i0 | 97.8 | 0.98936170212766 | 93 | 2 | 98.9 | 0 | 281 | 3 | 225 | 317 | XOS63399.1 MAG: hypothetical protein MSP0629_31 [Caudoviricetes sp.] | diamond | 279 | 187 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27009169 | 27009169 | PRJNA1199330_P_NODE_77122_length_275_cov_2.227723_g76423_i0 | PRJNA1199330 | 77122 | 275 | 2.227723 | 6.12623825 | Acinetobacter phage vB_AbaM_ME3 | 1837876 | Viruses | Viruses | 81.6 | 8.44e-16 | NR | YP_009595879.1 | 1837876 | g76423 | i0 | 46.2 | 1.01454545454545 | 93 | 45 | 99.3 | 2 | 1 | 273 | 86 | 175 | YP_009595879.1 hypothetical protein FDH01_gp047 [Acinetobacter phage vB_AbaM_ME3] | diamond | 279 | 81.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Metrivirus | Metrivirus ME3 | ||||
| 27704725 | 27704725 | PRJNA1199330_P_NODE_52944_length_300_cov_1.374449_g52245_i0 | PRJNA1199330 | 52944 | 300 | 1.374449 | 4.123347 | Acinetobacter phage vB_AbaM_ME3 | 1837876 | Viruses | Viruses | 81.6 | 1.15e-15 | NR | YP_009595854.1 | 1837876 | g52245 | i0 | 86.7 | 0.45 | 45 | 6 | 45 | 0 | 2 | 136 | 352 | 396 | YP_009595854.1 major head protein [Acinetobacter phage vB_AbaM_ME3] | diamond | 135 | 81.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Metrivirus | Metrivirus ME3 | ||||
| 27862103 | 27862103 | PRJNA1199330_P_NODE_117165_length_240_cov_2.706587_g116466_i0 | PRJNA1199330 | 117165 | 240 | 2.706587 | 6.4958088 | Acinetobacter phage nACB1 | 3015924 | Viruses | Viruses | 132 | 7.709999999999999e-34 | NR | WAW11592.1 | 3015924 | g116466 | i0 | 84.8 | 0.9875 | 79 | 12 | 98.8 | 0 | 238 | 2 | 663 | 741 | WAW11592.1 DNA-dependent RNA polymerase [Acinetobacter phage nACB1] | diamond | 237 | 132 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Acinetobacter phage nACB1 | ||||
| 28083147 | 28083147 | PRJNA1199330_P_NODE_50145_length_302_cov_3.113537_g49446_i0 | PRJNA1199330 | 50145 | 302 | 3.113537 | 9.40288174 | Acinetobacter phage vB_AbaM_ME3 | 1837876 | Viruses | Viruses | 70.5 | 8.59e-13 | NR | YP_009595842.1 | 1837876 | g49446 | i0 | 63 | 0.536423841059603 | 54 | 20 | 53.6 | 0 | 302 | 141 | 92 | 145 | YP_009595842.1 head completion protein [Acinetobacter phage vB_AbaM_ME3] | diamond | 162 | 70.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Metrivirus | Metrivirus ME3 | ||||
| 28525440 | 28525440 | PRJNA1199330_P_NODE_109847_length_246_cov_2.658960_g109148_i0 | PRJNA1199330 | 109847 | 246 | 2.65896 | 6.5410416 | Acinetobacter phage Presley | 1406780 | Viruses | Viruses | 55.5 | 7.89e-7 | NR | YP_009007619.1 | 1406780 | g109148 | i0 | 54.5 | 0.670731707317073 | 55 | 20 | 61 | 1 | 153 | 4 | 1 | 55 | YP_009007619.1 nucleotide diphosphate associated with X (NUDIX) protein [Acinetobacter phage Presley] | diamond | 165 | 55.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Presleyvirus | Presleyvirus presley | |||
| 28840911 | 28840911 | PRJNA1199330_P_NODE_111008_length_245_cov_4.831395_g110309_i0 | PRJNA1199330 | 111008 | 245 | 4.831395 | 11.83691775 | Acinetobacter phage nACB1 | 3015924 | Viruses | Viruses | 126 | 1.1999999999999999e-32 | NR | WAW11604.1 | 3015924 | g110309 | i0 | 76.5 | 0.991836734693878 | 81 | 19 | 99.2 | 0 | 244 | 2 | 104 | 184 | WAW11604.1 DNA helicase [Acinetobacter phage nACB1] | diamond | 243 | 126 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Acinetobacter phage nACB1 | ||||
| 28935835 | 28935835 | PRJNA1199330_P_NODE_99128_length_254_cov_1.624309_g98429_i0 | PRJNA1199330 | 99128 | 254 | 1.624309 | 4.12574486 | Burkholderia phage FLC9 | 2906467 | Viruses | Viruses | 94.7 | 1.84e-21 | NR | BDD79555.1 | 2906467 | g98429 | i0 | 54.2 | 1.97244094488189 | 83 | 38 | 98 | 0 | 2 | 250 | 7 | 89 | BDD79555.1 hypothetical protein [Burkholderia phage FLC9] | diamond | 501 | 94.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Burkholderia phage FLC9 | |||||
| 29156985 | 29156985 | PRJNA1199330_P_NODE_64329_length_287_cov_1.182243_g63630_i0 | PRJNA1199330 | 64329 | 287 | 1.182243 | 3.39303741 | Acinetobacter phage vB_AbaM_ME3 | 1837876 | Viruses | Viruses | 78.6 | 1.25e-15 | NR | YP_009595864.1 | 1837876 | g63630 | i0 | 57.8 | 0.668989547038328 | 64 | 27 | 66.9 | 0 | 285 | 94 | 127 | 190 | YP_009595864.1 hypothetical protein FDH01_gp032 [Acinetobacter phage vB_AbaM_ME3] | diamond | 192 | 78.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Metrivirus | Metrivirus ME3 | ||||
| 29314649 | 29314649 | PRJNA1199330_P_NODE_113629_length_244_cov_0.912281_g112930_i0 | PRJNA1199330 | 113629 | 244 | 0.912281 | 2.22596564 | Acinetobacter phage vB_AbaM_ME3 | 1837876 | Viruses | Viruses | 60.5 | 1.09e-8 | NR | YP_009595926.1 | 1837876 | g112930 | i0 | 53.8 | 0.639344262295082 | 52 | 24 | 63.9 | 0 | 157 | 2 | 1 | 52 | YP_009595926.1 hypothetical protein FDH01_gp094 [Acinetobacter phage vB_AbaM_ME3] | diamond | 156 | 60.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Metrivirus | Metrivirus ME3 | ||||
| 29472255 | 29472255 | PRJNA1199330_P_NODE_98710_length_254_cov_2.403315_g98011_i0 | PRJNA1199330 | 98710 | 254 | 2.403315 | 6.1044201 | Acinetobacter phage vB_AbaM_ME3 | 1837876 | Viruses | Viruses | 41.2 | 0.0158 | NR | YP_009596033.1 | 1837876 | g98011 | i0 | 39.5 | 0.507874015748031 | 43 | 26 | 50.8 | 0 | 149 | 21 | 1 | 43 | YP_009596033.1 hypothetical protein FDH01_gp260 [Acinetobacter phage vB_AbaM_ME3] | diamond | 129 | 41.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Metrivirus | Metrivirus ME3 | ||||
| 29630000 | 29630000 | PRJNA1199330_P_NODE_115970_length_242_cov_1.260355_g115271_i0 | PRJNA1199330 | 115970 | 242 | 1.260355 | 3.0500591 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 79 | 2.76e-15 | NR | DAT54007.1 | 2832643 | g115271 | i0 | 63.8 | 0.71900826446281 | 58 | 21 | 71.9 | 0 | 64 | 237 | 1 | 58 | DAT54007.1 MAG TPA: intron associated endonuclease [Caudoviricetes sp.] | diamond | 174 | 79 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29693186 | 29693186 | PRJNA1199330_P_NODE_60390_length_290_cov_1.972350_g59691_i0 | PRJNA1199330 | 60390 | 290 | 1.97235 | 5.719815 | Xanthomonas phage Xoo-sp14 | 2769337 | Viruses | Viruses | 62 | 1.15e-8 | NR | QNR51863.1 | 2769337 | g59691 | i0 | 41.3 | 1.88275862068966 | 80 | 46 | 81.7 | 1 | 278 | 42 | 235 | 314 | QNR51863.1 hypothetical protein Xoosp14_172 [Xanthomonas phage Xoo-sp14] | diamond | 546 | 62 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Xanthomonas phage Xoo-sp14 | |||||
| 29756558 | 29756558 | PRJNA1199330_P_NODE_92891_length_260_cov_2.433155_g92192_i0 | PRJNA1199330 | 92891 | 260 | 2.433155 | 6.326203 | Acinetobacter phage vB_AbaM_ME3 | 1837876 | Viruses | Viruses | 103 | 1.53e-25 | NR | YP_009595891.1 | 1837876 | g92192 | i0 | 71.6 | 0.853846153846154 | 74 | 21 | 85.4 | 0 | 23 | 244 | 1 | 74 | YP_009595891.1 hypothetical protein FDH01_gp059 [Acinetobacter phage vB_AbaM_ME3] | diamond | 222 | 103 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Metrivirus | Metrivirus ME3 | ||||
| 30609493 | 30609493 | PRJNA1199330_P_NODE_115753_length_242_cov_1.846154_g115054_i0 | PRJNA1199330 | 115753 | 242 | 1.846154 | 4.46769268 | Acinetobacter phage vB_AbaM_ME3 | 1837876 | Viruses | Viruses | 137 | 8.78e-36 | NR | YP_009595894.1 | 1837876 | g115054 | i0 | 77.2 | 0.979338842975207 | 79 | 18 | 97.9 | 0 | 6 | 242 | 220 | 298 | YP_009595894.1 DNA primase/helicase [Acinetobacter phage vB_AbaM_ME3] | diamond | 237 | 137 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Metrivirus | Metrivirus ME3 | ||||
| 30799117 | 30799117 | PRJNA1199330_P_NODE_66334_length_285_cov_1.471698_g65635_i0 | PRJNA1199330 | 66334 | 285 | 1.471698 | 4.1943393 | Acinetobacter phage vB_AbaM_ME3 | 1837876 | Viruses | Viruses | 157 | 3.21e-45 | NR | YP_009595903.1 | 1837876 | g65635 | i0 | 77.1 | 1.01052631578947 | 96 | 21 | 100 | 1 | 285 | 1 | 32 | 127 | YP_009595903.1 hypothetical protein FDH01_gp071 [Acinetobacter phage vB_AbaM_ME3] | diamond | 288 | 157 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Metrivirus | Metrivirus ME3 | ||||
| 31526416 | 31526416 | PRJNA1199330_P_NODE_33796_length_356_cov_1.653710_g33097_i0 | PRJNA1199330 | 33796 | 356 | 1.65371 | 5.8872076 | Acinetobacter phage vB_AbaM_ME3 | 1837876 | Viruses | Viruses | 128 | 1.9499999999999998e-32 | NR | YP_009595841.1 | 1837876 | g33097 | i0 | 58.2 | 0.926966292134832 | 110 | 46 | 92.7 | 0 | 2 | 331 | 86 | 195 | YP_009595841.1 RNA (guanine-N1-)-methyltransferase [Acinetobacter phage vB_AbaM_ME3] | diamond | 330 | 128 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Metrivirus | Metrivirus ME3 |
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);;