contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA982106" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4792122 | 4792122 | PRJNA982106_P_NODE_4_length_9164_cov_18.789792_g1_i0 | PRJNA982106 | 4 | 9164 | 18.789792 | 1721.89653888 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 1885 | 0 | NR | WWV86902.1 | 1530251 | g1 | i0 | 72 | 0.42099519860323 | 1286 | 348 | 41.8 | 7 | 1801 | 5628 | 2 | 1285 | WWV86902.1 MAG: hypothetical protein, partial [Picornaviridae sp.] | diamond | 3858 | 1885 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 22948935 | 22948935 | PRJNA982106_P_NODE_3958_length_449_cov_1.194149_g3719_i0 | PRJNA982106 | 3958 | 449 | 1.194149 | 5.36172901 | Streptomyces phage RosaAsantewaa | 2562347 | Viruses | Viruses | 114 | 4.88e-26 | NR | QBZ73603.1 | 2562347 | g3719 | i0 | 58.3 | 0.641425389755011 | 96 | 36 | 62.8 | 2 | 449 | 168 | 1182 | 1275 | QBZ73603.1 DNA primase/polymerase [Streptomyces phage RosaAsantewaa] | diamond | 288 | 114 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Scapunavirus | Streptomyces phage RosaAsantewaa | ||||
| 26715377 | 26715377 | PRJNA982106_P_NODE_2961_length_508_cov_1.482759_g2722_i0 | PRJNA982106 | 2961 | 508 | 1.482759 | 7.53241572 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 291 | 2.4099999999999998e-95 | NR | AXG64379.1 | RQ01 | g2722 | i0 | 87.6 | 6.98622047244094 | 169 | 21 | 99.8 | 0 | 2 | 508 | 18 | 186 | AXG64379.1 nucleoprotein, partial [Influenza B virus] | diamond | 3549 | 291 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 26836600 | 26836600 | PRJNA982106_P_NODE_28041_length_245_cov_0.895349_g27801_i0 | PRJNA982106 | 28041 | 245 | 0.895349 | 2.19360505 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 44.3 | 0.00167 | NR | DAT63459.1 | 2832643 | g27801 | i0 | 49.1 | 1.23673469387755 | 55 | 21 | 67.3 | 2 | 23 | 187 | 37 | 84 | DAT63459.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 303 | 44.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26962843 | 26962843 | PRJNA982106_P_NODE_2762_length_524_cov_1.177384_g2524_i0 | PRJNA982106 | 2762 | 524 | 1.177384 | 6.16949216 | Streptomyces phage Scap1 | 2041354 | Viruses | Viruses | 115 | 2.15e-29 | NR | YP_009615371.1 | 2041354 | g2524 | i0 | 52.6 | 1.32824427480916 | 116 | 55 | 66.4 | 0 | 356 | 9 | 1 | 116 | YP_009615371.1 holin [Streptomyces phage Scap1] | diamond | 696 | 115 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Scapunavirus | Scapunavirus scap1 | ||||
| 27279277 | 27279277 | PRJNA982106_P_NODE_3583_length_468_cov_0.845570_g3344_i0 | PRJNA982106 | 3583 | 468 | 0.84557 | 3.9572676 | Streptomyces phage Bing | 2079427 | Viruses | Viruses | 197 | 3.239999999999999e-55 | NR | YP_009622884.1 | 2079427 | g3344 | i0 | 68.2 | 1.98717948717949 | 154 | 49 | 98.7 | 0 | 468 | 7 | 692 | 845 | YP_009622884.1 RNA-dependent RNA polymerase [Streptomyces phage Bing] | diamond | 930 | 197 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Bingvirus | Bingvirus bing | ||||
| 27437405 | 27437405 | PRJNA982106_P_NODE_1723_length_673_cov_1.421667_g1491_i0 | PRJNA982106 | 1723 | 673 | 1.421667 | 9.56781891 | Streptomyces phage LibertyBell | 2301574 | Viruses | Viruses | 147 | 1.34e-41 | NR | AXQ61246.1 | 2301574 | g1491 | i0 | 58.5 | 1.06537890044577 | 123 | 50 | 54.4 | 1 | 377 | 12 | 2 | 124 | AXQ61246.1 hypothetical protein SEA_LIBERTYBELL_5 [Streptomyces phage LibertyBell] | diamond | 717 | 147 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Streptomyces phage LibertyBell | |||||
| 27437408 | 27437408 | PRJNA982106_P_NODE_18363_length_263_cov_1.394737_g18123_i0 | PRJNA982106 | 18363 | 263 | 1.394737 | 3.66815831 | Inoviridae sp. | 2219103 | Viruses | Viruses | 62 | 7.07e-9 | NR | DAW95818.1 | 2219103 | g18123 | i0 | 39.8 | 1.90494296577947 | 83 | 47 | 93.5 | 2 | 263 | 18 | 23 | 103 | DAW95818.1 MAG TPA: Protein C [Inoviridae sp.] | diamond | 501 | 62 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 27759230 | 27759230 | PRJNA982106_P_NODE_6324_length_379_cov_1.006536_g6084_i0 | PRJNA982106 | 6324 | 379 | 1.006536 | 3.81477144 | Scapunavirus | 2560225 | Viruses | Viruses | 132 | 3.18e-35 | NR | YP_009615366.1 | 2041354 | g6084 | i0 | 53.2 | 2.95250659630607 | 126 | 59 | 99.7 | 0 | 378 | 1 | 37 | 162 | YP_009615366.1 minor tail protein [Streptomyces phage Scap1] | diamond | 1119 | 132 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Scapunavirus | Scapunavirus scap1 | ||||
| 28194745 | 28194745 | PRJNA982106_P_NODE_28406_length_244_cov_0.900585_g28166_i0 | PRJNA982106 | 28406 | 244 | 0.900585 | 2.1974274 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 118 | 2.19e-29 | NR | NP_116744.1 | 696863 | g28166 | i0 | 71.6 | 2.98770491803279 | 81 | 23 | 99.6 | 0 | 2 | 244 | 222 | 302 | NP_116744.1 nucleocapsid protein [Sprivivirus cyprinus] | diamond | 729 | 118 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 29110685 | 29110685 | PRJNA982106_P_NODE_31708_length_242_cov_0.893491_g31468_i0 | PRJNA982106 | 31708 | 242 | 0.893491 | 2.16224822 | Harvfovirus sp. | 2487768 | Viruses | Viruses | 91.7 | 2.27e-19 | NR | AYV81261.1 | 2487768 | g31468 | i0 | 55 | 1.98347107438017 | 80 | 36 | 99.2 | 0 | 242 | 3 | 70 | 149 | AYV81261.1 MAG: DNA polymerase family B elongation subunit [Harvfovirus sp.] | diamond | 480 | 91.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Harvfovirus sp. | |||
| 29205483 | 29205483 | PRJNA982106_P_NODE_24009_length_248_cov_0.880000_g23769_i0 | PRJNA982106 | 24009 | 248 | 0.88 | 2.1824 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 123 | 1.52e-30 | NR | NP_116748.1 | 696863 | g23769 | i0 | 80.5 | 0.991935483870968 | 82 | 16 | 99.2 | 0 | 1 | 246 | 1748 | 1829 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 246 | 123 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 29495453 | 29495453 | PRJNA982106_P_NODE_16850_length_272_cov_1.547739_g16610_i0 | PRJNA982106 | 16850 | 272 | 1.547739 | 4.20985008 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 173 | 2.7799999999999995e-48 | NR | NP_056659.1 | RQ01 | g16610 | i0 | 92.2 | 18.8602941176471 | 90 | 7 | 99.3 | 0 | 3 | 272 | 570 | 659 | NP_056659.1 polymerase PA [Influenza B virus (B/Lee/1940)] | diamond | 5130 | 173 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 29521004 | 29521004 | PRJNA982106_P_NODE_17770_length_267_cov_1.067010_g17530_i0 | PRJNA982106 | 17770 | 267 | 1.06701 | 2.8489167 | Streptomyces phage Scap1 | 2041354 | Viruses | Viruses | 128 | 3.5e-32 | NR | YP_009615401.1 | 2041354 | g17530 | i0 | 73 | 1 | 89 | 22 | 100 | 1 | 267 | 1 | 568 | 654 | YP_009615401.1 RNA-dependent RNA polymerase [Streptomyces phage Scap1] | diamond | 267 | 128 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Scapunavirus | Scapunavirus scap1 | ||||
| 29552387 | 29552387 | PRJNA982106_P_NODE_26190_length_246_cov_0.890173_g25950_i0 | PRJNA982106 | 26190 | 246 | 0.890173 | 2.18982558 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 102 | 2.86e-23 | NR | NP_116748.1 | 696863 | g25950 | i0 | 65.4 | 0.98780487804878 | 81 | 28 | 98.8 | 0 | 3 | 245 | 1828 | 1908 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 243 | 102 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 30063824 | 30063824 | PRJNA982106_P_NODE_13151_length_298_cov_0.857778_g12911_i0 | PRJNA982106 | 13151 | 298 | 0.857778 | 2.55617844 | Scapunavirus | 2560225 | Viruses | Viruses | 108 | 2.29e-26 | NR | QBZ73600.1 | 2562347 | g12911 | i0 | 57.3 | 1.95302013422819 | 96 | 41 | 96.6 | 0 | 10 | 297 | 87 | 182 | QBZ73600.1 membrane protein [Streptomyces phage RosaAsantewaa] | diamond | 582 | 108 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Scapunavirus | Streptomyces phage RosaAsantewaa | ||||
| 30184263 | 30184263 | PRJNA982106_P_NODE_32272_length_241_cov_0.916667_g32032_i0 | PRJNA982106 | 32272 | 241 | 0.916667 | 2.20916747 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 118 | 7.6e-29 | NR | NP_116748.1 | 696863 | g32032 | i0 | 72.2 | 0.983402489626556 | 79 | 22 | 98.3 | 0 | 3 | 239 | 1825 | 1903 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 237 | 118 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 30279466 | 30279466 | PRJNA982106_P_NODE_8052_length_350_cov_1.093863_g7812_i0 | PRJNA982106 | 8052 | 350 | 1.093863 | 3.8285205 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 131 | 2.49e-36 | NR | DAG32307.1 | 2832643 | g7812 | i0 | 92.3 | 2.78571428571429 | 65 | 5 | 55.7 | 0 | 350 | 156 | 91 | 155 | DAG32307.1 MAG TPA: IS66 Orf2 like protein [Caudoviricetes sp.] | diamond | 975 | 131 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30658220 | 30658220 | PRJNA982106_P_NODE_10693_length_320_cov_0.935223_g10453_i0 | PRJNA982106 | 10693 | 320 | 0.935223 | 2.9927136 | Streptomyces phage Bing | 2079427 | Viruses | Viruses | 176 | 1.67e-51 | NR | YP_009622880.1 | 2079427 | g10453 | i0 | 80.2 | 3.9375 | 106 | 20 | 99.4 | 1 | 318 | 1 | 1 | 105 | YP_009622880.1 DNA helicase [Streptomyces phage Bing] | diamond | 1260 | 176 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Bingvirus | Bingvirus bing | ||||
| 30689726 | 30689726 | PRJNA982106_P_NODE_25693_length_247_cov_0.885057_g25453_i0 | PRJNA982106 | 25693 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 47.8 | 2.59e-4 | NR | DAI33279.1 | 2832643 | g25453 | i0 | 91.3 | 0.279352226720648 | 23 | 2 | 27.9 | 0 | 130 | 62 | 12 | 34 | DAI33279.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 69 | 47.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30980394 | 30980394 | PRJNA982106_P_NODE_19874_length_254_cov_1.276243_g19634_i0 | PRJNA982106 | 19874 | 254 | 1.276243 | 3.24165722 | Bingvirus | 2560103 | Viruses | Viruses | 114 | 3.8500000000000006e-27 | NR | YP_009622884.1 | 2079427 | g19634 | i0 | 69.9 | 5.87007874015748 | 83 | 25 | 98 | 0 | 4 | 252 | 381 | 463 | YP_009622884.1 RNA-dependent RNA polymerase [Streptomyces phage Bing] | diamond | 1491 | 114 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Bingvirus | Bingvirus bing | ||||
| 31100415 | 31100415 | PRJNA982106_P_NODE_13155_length_298_cov_0.808889_g12915_i0 | PRJNA982106 | 13155 | 298 | 0.808889 | 2.41048922 | Streptomyces phage Kardashian | 2601691 | Viruses | Viruses | 132 | 1.31e-36 | NR | QEQ93881.1 | 2601691 | g12915 | i0 | 67.3 | 0.986577181208054 | 98 | 32 | 98.7 | 0 | 2 | 295 | 65 | 162 | QEQ93881.1 hypothetical protein SEA_KARDASHIAN_16 [Streptomyces phage Kardashian] | diamond | 294 | 132 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Bingvirus | Streptomyces phage Kardashian | ||||
| 31131879 | 31131879 | PRJNA982106_P_NODE_31195_length_242_cov_0.911243_g30955_i0 | PRJNA982106 | 31195 | 242 | 0.911243 | 2.20520806 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 118 | 1.4999999999999996e-29 | NR | NP_116744.1 | 696863 | g30955 | i0 | 78.2 | 1.93388429752066 | 78 | 17 | 96.7 | 0 | 2 | 235 | 3 | 80 | NP_116744.1 nucleocapsid protein [Sprivivirus cyprinus] | diamond | 468 | 118 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 31638062 | 31638062 | PRJNA982106_P_NODE_2476_length_552_cov_1.202505_g2238_i0 | PRJNA982106 | 2476 | 552 | 1.202505 | 6.6378276 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 217 | 7.87e-66 | NR | 7XVR_A | RQ01 | g2238 | i0 | 61.7 | 1.98913043478261 | 183 | 70 | 99.5 | 0 | 550 | 2 | 172 | 354 | 7XVR_A Chain A, Neuraminidase [Wuhan spiny eel influenza virus] | diamond | 1098 | 217 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza B-like virus | |||
| 32901917 | 32901917 | PRJNA982106_P_NODE_11900_length_308_cov_1.234043_g11660_i0 | PRJNA982106 | 11900 | 308 | 1.234043 | 3.80085244 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 130 | 1.68e-32 | NR | DAF69193.1 | 2832643 | g11660 | i0 | 61.2 | 1.00324675324675 | 103 | 39 | 99.4 | 1 | 307 | 2 | 195 | 297 | DAF69193.1 MAG TPA: Preneck appendage protein helix, VIRAL PROTEIN.05A [Caudoviricetes sp.] | diamond | 309 | 130 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32907956 | 32907956 | PRJNA982106_P_NODE_4060_length_445_cov_1.099462_g3821_i0 | PRJNA982106 | 4060 | 445 | 1.099462 | 4.8926059 | Viruses | 10239 | Viruses | Viruses | 150 | 4.249999999999999e-43 | NR | YP_009615398.1 | 2041354 | g3821 | i0 | 49.3 | 2.89213483146067 | 142 | 71 | 95.7 | 1 | 434 | 9 | 49 | 189 | YP_009615398.1 HNH endonuclease [Streptomyces phage Scap1] | diamond | 1287 | 151 | 0.993377483443709 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Scapunavirus | Scapunavirus scap1 |
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);;