contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA1150539" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8689646 | 8689646 | PRJNA1150539_S_NODE_1127_length_2446_cov_133.513696_g867_i0 | PRJNA1150539 | 1127 | 2446 | 133.513696 | 3265.74500416 | Moloney murine leukemia virus | 11801 | Viruses | Viruses | 1295 | 0 | NR | NP_057933.2 | 11801 | g867 | i0 | 97.6 | 2.42477514309076 | 659 | 16 | 80.8 | 0 | 2304 | 328 | 677 | 1335 | NP_057933.2 Pr180 [Moloney murine leukemia virus] | diamond | 5931 | 1295 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 26596807 | 26596807 | PRJNA1150539_S_NODE_16621_length_396_cov_2.439628_g16026_i0 | PRJNA1150539 | 16621 | 396 | 2.439628 | 9.66092688 | Adintovirus anguilla10665 | 3115889 | Viruses | Viruses | 65.1 | 3.06e-10 | NR | DBA49781.1 | 3115889 | g16026 | i0 | 62.2 | 0.340909090909091 | 45 | 17 | 34.1 | 0 | 269 | 135 | 7 | 51 | DBA49781.1 MAG TPA_asm: Cupiennin [Adintovirus anguilla10665] | diamond | 135 | 65.1 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus anguilla10665 | |||
| 26596808 | 26596808 | PRJNA1150539_S_NODE_21561_length_377_cov_1.013158_g20965_i0 | PRJNA1150539 | 21561 | 377 | 1.013158 | 3.81960566 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 186 | 1.29e-51 | NR | WKU61618.1 | 3063761 | g20965 | i0 | 96.7 | 0.724137931034483 | 91 | 3 | 72.4 | 0 | 376 | 104 | 2130 | 2220 | WKU61618.1 polyprotein [Zebrafish picornavirus 2] | diamond | 273 | 186 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 27798638 | 27798638 | PRJNA1150539_S_NODE_71684_length_277_cov_2.264706_g71088_i0 | PRJNA1150539 | 71684 | 277 | 2.264706 | 6.27323562 | Adintovirus anguilla10665 | 3115889 | Viruses | Viruses | 137 | 1.57e-37 | NR | DBA49786.1 | 3115889 | g71088 | i0 | 68.5 | 2.98916967509025 | 92 | 29 | 99.6 | 0 | 276 | 1 | 168 | 259 | DBA49786.1 MAG TPA_asm: PacK [Adintovirus anguilla10665] | diamond | 828 | 137 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus anguilla10665 | |||
| 28177059 | 28177059 | PRJNA1150539_S_NODE_33506_length_344_cov_2.450185_g32910_i0 | PRJNA1150539 | 33506 | 344 | 2.450185 | 8.4286364 | Astyanax tetra cavefish adintovirus | 2609866 | Viruses | Viruses | 155 | 1.2099999999999996e-43 | NR | DAC81252.1 | 2609866 | g32910 | i0 | 74 | 2.625 | 100 | 26 | 87.2 | 0 | 309 | 10 | 145 | 244 | DAC81252.1 TPA_asm: integrase [Astyanax tetra cavefish adintovirus] | diamond | 903 | 155 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Astyanax tetra cavefish adintovirus | |||
| 28556370 | 28556370 | PRJNA1150539_S_NODE_99047_length_244_cov_2.637427_g98451_i0 | PRJNA1150539 | 99047 | 244 | 2.637427 | 6.43532188 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 51.2 | 9.68e-6 | NR | QCF47477.1 | 1543320 | g98451 | i0 | 68.6 | 0.860655737704918 | 35 | 11 | 43 | 0 | 183 | 79 | 89 | 123 | QCF47477.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus] | diamond | 210 | 51.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 28619530 | 28619530 | PRJNA1150539_S_NODE_49767_length_311_cov_4.474790_g49171_i0 | PRJNA1150539 | 49767 | 311 | 4.47479 | 13.9165969 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 66.2 | 3.24e-11 | NR | QCF47477.1 | 1543320 | g49171 | i0 | 69 | 0.810289389067524 | 42 | 13 | 40.5 | 0 | 74 | 199 | 86 | 127 | QCF47477.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus] | diamond | 252 | 66.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 28619539 | 28619539 | PRJNA1150539_S_NODE_93467_length_250_cov_0.870056_g92871_i0 | PRJNA1150539 | 93467 | 250 | 0.870056 | 2.17514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 108 | 7.16e-27 | NR | XOR92084.1 | 2832643 | g92871 | i0 | 67.9 | 0.936 | 78 | 25 | 93.6 | 0 | 16 | 249 | 142 | 219 | XOR92084.1 MAG: hypothetical protein MSP1531_13 [Caudoviricetes sp.] | diamond | 234 | 108 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28966827 | 28966827 | PRJNA1150539_S_NODE_59568_length_295_cov_2.171171_g58972_i0 | PRJNA1150539 | 59568 | 295 | 2.171171 | 6.40495445 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 91.3 | 3.58e-21 | NR | DAR96134.1 | 2832643 | g58972 | i0 | 54.5 | 0.783050847457627 | 77 | 34 | 77.3 | 1 | 32 | 259 | 27 | 103 | DAR96134.1 MAG TPA: Single strand binding protein [Caudoviricetes sp.] | diamond | 231 | 91.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28966830 | 28966830 | PRJNA1150539_S_NODE_80848_length_265_cov_1.244792_g80252_i0 | PRJNA1150539 | 80848 | 265 | 1.244792 | 3.2986988 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 58.5 | 3.42e-8 | NR | DAC81397.1 | 2609864 | g80252 | i0 | 46.3 | 1.83396226415094 | 54 | 29 | 61.1 | 0 | 58 | 219 | 71 | 124 | DAC81397.1 TPA_asm: adenain [Pimephales minnow adintovirus] | diamond | 486 | 58.5 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 28998586 | 28998586 | PRJNA1150539_S_NODE_8888_length_453_cov_3.594737_g8294_i0 | PRJNA1150539 | 8888 | 453 | 3.594737 | 16.28415861 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 155 | 3.73e-41 | NR | DAN99113.1 | 2832643 | g8294 | i0 | 56.6 | 0.960264900662252 | 145 | 63 | 96 | 0 | 3 | 437 | 507 | 651 | DAN99113.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 435 | 155 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29250645 | 29250645 | PRJNA1150539_S_NODE_48129_length_314_cov_3.755187_g47533_i0 | PRJNA1150539 | 48129 | 314 | 3.755187 | 11.79128718 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 54.7 | 9.76e-7 | NR | QCF47477.1 | 1543320 | g47533 | i0 | 85.2 | 0.25796178343949 | 27 | 4 | 25.8 | 0 | 96 | 16 | 33 | 59 | QCF47477.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus] | diamond | 81 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 29522799 | 29522799 | PRJNA1150539_S_NODE_13470_length_412_cov_4.790560_g12875_i0 | PRJNA1150539 | 13470 | 412 | 4.79056 | 19.7371072 | Astyanax tetra cavefish adintovirus | 2609866 | Viruses | Viruses | 102 | 4.65e-24 | NR | YP_010796956.1 | 2609866 | g12875 | i0 | 53.8 | 1.87135922330097 | 93 | 33 | 62.6 | 2 | 412 | 155 | 134 | 223 | YP_010796956.1 FtsK [Terrapene box turtle adintovirus] | diamond | 771 | 103 | 0.990291262135922 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Amphintovirales | Eupolintoviridae | Betadintovirus | Astyanax tetra cavefish adintovirus | ||
| 30766999 | 30766999 | PRJNA1150539_S_NODE_12834_length_416_cov_4.411079_g12239_i0 | PRJNA1150539 | 12834 | 416 | 4.411079 | 18.35008864 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 90.5 | 1.06e-20 | NR | DAD61086.1 | 2832643 | g12239 | i0 | 54.3 | 0.663461538461538 | 92 | 37 | 66.3 | 2 | 26 | 301 | 1 | 87 | DAD61086.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 276 | 90.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30798487 | 30798487 | PRJNA1150539_S_NODE_72554_length_276_cov_1.576355_g71958_i0 | PRJNA1150539 | 72554 | 276 | 1.576355 | 4.3507398 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 54.3 | 4.06e-7 | NR | QCF47491.1 | 1543320 | g71958 | i0 | 61.7 | 1.02173913043478 | 47 | 13 | 45.7 | 2 | 153 | 28 | 12 | 58 | QCF47491.1 RNA-dependent DNA polymerase [Erythrocytic necrosis virus] | diamond | 282 | 54.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 30893510 | 30893510 | PRJNA1150539_S_NODE_92434_length_251_cov_0.865169_g91838_i0 | PRJNA1150539 | 92434 | 251 | 0.865169 | 2.17157419 | Salarius guttatus piscichuvirus | 2951531 | Viruses | Viruses | 52.8 | 1.25e-5 | NR | YP_010840939.1 | 2951531 | g91838 | i0 | 40.7 | 1.02788844621514 | 86 | 47 | 98 | 2 | 246 | 1 | 24 | 109 | YP_010840939.1 L protein [Hardyhead chuvirus] | diamond | 258 | 52.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | Salarius guttatus piscichuvirus | ||
| 31165236 | 31165236 | PRJNA1150539_S_NODE_18875_length_386_cov_5.373802_g18279_i0 | PRJNA1150539 | 18875 | 386 | 5.373802 | 20.74287572 | root | 1 | Root_unresolved | Root_unresolved | 52 | 6.16e-6 | NR | QCF47508.1 | 1543320 | g18279 | i0 | 66.7 | 0.878238341968912 | 36 | 12 | 28 | 0 | 182 | 75 | 23 | 58 | QCF47508.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus] | diamond | 339 | 52 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 31177450 | 31177450 | PRJNA1150539_S_NODE_56835_length_299_cov_4.066372_g56239_i0 | PRJNA1150539 | 56835 | 299 | 4.066372 | 12.15845228 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 87 | 4.32e-20 | NR | QCF47508.1 | 1543320 | g56239 | i0 | 95.2 | 0.421404682274247 | 42 | 2 | 42.1 | 0 | 128 | 3 | 17 | 58 | QCF47508.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus] | diamond | 126 | 87 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 31367678 | 31367678 | PRJNA1150539_S_NODE_100836_length_243_cov_0.905882_g100240_i0 | PRJNA1150539 | 100836 | 243 | 0.905882 | 2.20129326 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 73.2 | 5.75e-14 | NR | BCT22576.1 | RQ14 | g100240 | i0 | 53.1 | 1 | 81 | 37 | 98.8 | 1 | 2 | 241 | 86 | 166 | BCT22576.1 deoxyuridine triphosphatase [Carp edema virus] | diamond | 243 | 73.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 31494136 | 31494136 | PRJNA1150539_S_NODE_78576_length_268_cov_1.184615_g77980_i0 | PRJNA1150539 | 78576 | 268 | 1.184615 | 3.1747682 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 51.6 | 2.28e-6 | NR | DAH73462.1 | 2832643 | g77980 | i0 | 32.8 | 0.75 | 67 | 44 | 73.9 | 1 | 259 | 62 | 4 | 70 | DAH73462.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 201 | 51.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31766391 | 31766391 | PRJNA1150539_S_NODE_70677_length_278_cov_5.390244_g70081_i0 | PRJNA1150539 | 70677 | 278 | 5.390244 | 14.98487832 | Viruses | 10239 | Viruses | Viruses | 47.4 | 0.00137 | NR | QHD64841.1 | 2695360 | g70081 | i0 | 33 | 2.84892086330935 | 88 | 50 | 95 | 2 | 272 | 9 | 724 | 802 | QHD64841.1 RdRp [Erysiphe necator associated ssRNA virus 2] | diamond | 792 | 47.4 | 1 | Viruses | Erysiphe necator associated ssRNA virus 2 | ||||||||
| 32031838 | 32031838 | PRJNA1150539_S_NODE_23598_length_370_cov_4.666667_g23002_i0 | PRJNA1150539 | 23598 | 370 | 4.666667 | 17.2666679 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 57.8 | 1.15e-7 | NR | QCF47477.1 | 1543320 | g23002 | i0 | 59.2 | 0.397297297297297 | 49 | 15 | 39.7 | 1 | 148 | 2 | 20 | 63 | QCF47477.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus] | diamond | 147 | 57.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 32727130 | 32727130 | PRJNA1150539_S_NODE_66640_length_284_cov_3.104265_g66044_i0 | PRJNA1150539 | 66640 | 284 | 3.104265 | 8.8161126 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 101 | 3.1e-25 | NR | QCF47477.1 | 1543320 | g66044 | i0 | 79 | 0.654929577464789 | 62 | 13 | 65.5 | 0 | 98 | 283 | 6 | 67 | QCF47477.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus] | diamond | 186 | 101 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 32758539 | 32758539 | PRJNA1150539_S_NODE_10740_length_432_cov_3.740947_g10145_i0 | PRJNA1150539 | 10740 | 432 | 3.740947 | 16.16089104 | Hokovirus HKV1 | 1977638 | Viruses | Viruses | 78.2 | 1.37e-13 | NR | ARF10689.1 | 1977638 | g10145 | i0 | 37.7 | 0.791666666666667 | 114 | 68 | 77.1 | 2 | 378 | 46 | 2131 | 2244 | ARF10689.1 hypothetical protein Hokovirus_2_216 [Hokovirus HKV1] | diamond | 342 | 78.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hokovirus | Hokovirus HKV1 |
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);;