contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA870096" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27371568 | 27371568 | PRJNA870096_S_NODE_8883_length_621_cov_6.205882_g7376_i0 | PRJNA870096 | 8883 | 621 | 6.205882 | 38.53852722 | Moloney murine leukemia virus | 11801 | Viruses | Viruses | 394 | 1.98e-123 | NR | NP_057933.2 | 11801 | g7376 | i0 | 96.6 | 3.98067632850242 | 206 | 7 | 99.5 | 0 | 620 | 3 | 1087 | 1292 | NP_057933.2 Pr180 [Moloney murine leukemia virus] | diamond | 2472 | 394 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 27466155 | 27466155 | PRJNA870096_S_NODE_10983_length_556_cov_6.996101_g9399_i0 | PRJNA870096 | 10983 | 556 | 6.996101 | 38.89832156 | uncultured virus | 340016 | Viruses | Viruses | 107 | 1.41e-23 | NR | CAH6421308.1 | 340016 | g9399 | i0 | 43.7 | 0.642086330935252 | 119 | 66 | 63.7 | 1 | 3 | 356 | 394 | 512 | CAH6421308.1 PQQ-binding beta-propeller repeat protein [uncultured virus] | diamond | 357 | 107 | 1 | Viruses | uncultured virus | ||||||||
| 27907735 | 27907735 | PRJNA870096_S_NODE_28345_length_337_cov_2.374150_g26681_i0 | PRJNA870096 | 28345 | 337 | 2.37415 | 8.0008855 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 119 | 4.41e-29 | NR | YP_009448811.1 | 2023057 | g26681 | i0 | 58 | 2.32344213649852 | 100 | 40 | 89 | 1 | 337 | 38 | 355 | 452 | YP_009448811.1 Serine-tRNA synthetase, type1 [Orpheovirus IHUMI-LCC2] | diamond | 783 | 119 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 28097420 | 28097420 | PRJNA870096_S_NODE_136565_length_153_cov_1.154545_g134901_i0 | PRJNA870096 | 136565 | 153 | 1.154545 | 1.76645385 | Retroviridae sp. | 2681591 | Viruses | Viruses | 73.2 | 2.06e-13 | NR | UGO47158.1 | 2681591 | g134901 | i0 | 56.5 | 3.66666666666667 | 46 | 20 | 90.2 | 0 | 141 | 4 | 287 | 332 | UGO47158.1 MAG: envelope protein [Retroviridae sp.] | diamond | 561 | 73.2 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Retroviridae sp. | |||
| 28255241 | 28255241 | PRJNA870096_S_NODE_59606_length_227_cov_2.000000_g57942_i0 | PRJNA870096 | 59606 | 227 | 2 | 4.54 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 68.6 | 1.97e-11 | NR | YP_010782487.1 | 2126985 | g57942 | i0 | 53.2 | 1.73127753303965 | 62 | 28 | 81.9 | 1 | 227 | 42 | 277 | 337 | YP_010782487.1 phosphoribosyl transferase domain protein [Tupanvirus soda lake] | diamond | 393 | 68.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 28926431 | 28926431 | PRJNA870096_S_NODE_91748_length_184_cov_1.021277_g90084_i0 | PRJNA870096 | 91748 | 184 | 1.021277 | 1.87914968 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 43.5 | 0.00391 | NR | NP_859022.1 | RQ13 | g90084 | i0 | 36.4 | 3.45652173913043 | 55 | 34 | 89.7 | 1 | 183 | 19 | 51 | 104 | NP_859022.1 2A [Kobuvirus bejaponia] | diamond | 636 | 43.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Kobuvirus | Zebrafish jaw picornavirus | ||
| 29139688 | 29139688 | PRJNA870096_S_NODE_42909_length_270_cov_2.850220_g41245_i0 | PRJNA870096 | 42909 | 270 | 2.85022 | 7.695594 | uncultured virus | 340016 | Viruses | Viruses | 52.4 | 2.02e-5 | NR | CAK7994547.1 | 340016 | g41245 | i0 | 52.6 | 0.633333333333333 | 57 | 24 | 60 | 2 | 26 | 187 | 439 | 495 | CAK7994547.1 Hypothetical protein POVR1_LOCUS71 [uncultured virus] | diamond | 171 | 52.4 | 1 | Viruses | uncultured virus | ||||||||
| 29360484 | 29360484 | PRJNA870096_S_NODE_137529_length_153_cov_0.872727_g135865_i0 | PRJNA870096 | 137529 | 153 | 0.872727 | 1.33527231 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 61.2 | 3.33e-9 | NR | WAB24476.1 | RQ13 | g135865 | i0 | 60 | 0.980392156862745 | 50 | 20 | 98 | 0 | 1 | 150 | 2561 | 2610 | WAB24476.1 polyprotein [Avian megrivirus] | diamond | 150 | 61.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Megrivirus | Zebrafish jaw picornavirus | ||
| 29739044 | 29739044 | PRJNA870096_S_NODE_136970_length_153_cov_0.872727_g135306_i0 | PRJNA870096 | 136970 | 153 | 0.872727 | 1.33527231 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 70.9 | 2.62e-13 | NR | QHX41416.1 | 696863 | g135306 | i0 | 60 | 3.92156862745098 | 50 | 20 | 98 | 0 | 3 | 152 | 104 | 153 | QHX41416.1 glycoprotein, partial [Sprivivirus cyprinus] | diamond | 600 | 70.9 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 29936976 | 29936976 | PRJNA870096_S_NODE_35491_length_299_cov_3.023438_g33827_i0 | PRJNA870096 | 35491 | 299 | 3.023438 | 9.04007962 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 74.3 | 6.01e-13 | NR | QJX58422.1 | RQ13 | g33827 | i0 | 44.3 | 4.69565217391304 | 97 | 52 | 95.3 | 2 | 299 | 15 | 2256 | 2352 | QJX58422.1 polyprotein [Salivirus A] | diamond | 1404 | 74.7 | 0.994645247657296 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Salivirus | Zebrafish jaw picornavirus | ||
| 29992072 | 29992072 | PRJNA870096_S_NODE_94631_length_181_cov_1.601449_g92967_i0 | PRJNA870096 | 94631 | 181 | 1.601449 | 2.89862269 | uncultured virus | 340016 | Viruses | Viruses | 47.4 | 3.67e-4 | NR | CAK7994547.1 | 340016 | g92967 | i0 | 40 | 0.994475138121547 | 60 | 35 | 97.8 | 1 | 3 | 179 | 431 | 490 | CAK7994547.1 Hypothetical protein POVR1_LOCUS71 [uncultured virus] | diamond | 180 | 47.4 | 1 | Viruses | uncultured virus | ||||||||
| 30781870 | 30781870 | PRJNA870096_S_NODE_32194_length_315_cov_3.375000_g30530_i0 | PRJNA870096 | 32194 | 315 | 3.375 | 10.63125 | Riboviria sp. | 2585031 | Viruses | Viruses | 72.4 | 3.22e-12 | NR | WKV34572.1 | 2585031 | g30530 | i0 | 60.7 | 0.533333333333333 | 56 | 22 | 53.3 | 0 | 292 | 125 | 497 | 552 | WKV34572.1 MAG: RNA-dependent RNA polymerase, partial [Riboviria sp.] | diamond | 168 | 72.4 | 1 | Viruses | Riboviria sp. | ||||||||
| 30813451 | 30813451 | PRJNA870096_S_NODE_50834_length_247_cov_1.504902_g49170_i0 | PRJNA870096 | 50834 | 247 | 1.504902 | 3.71710794 | Pithovirus LCPAC2 | 2506591 | Viruses | Viruses | 74.3 | 1.32e-13 | NR | QBK91025.1 | 2506591 | g49170 | i0 | 70.2 | 0.57085020242915 | 47 | 14 | 57.1 | 0 | 102 | 242 | 217 | 263 | QBK91025.1 MAG: uncharacterized protein LCPAC201_03260 [Pithovirus LCPAC201] | diamond | 141 | 74.3 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC201 | |||||||
| 30876661 | 30876661 | PRJNA870096_S_NODE_108974_length_170_cov_1.133858_g107310_i0 | PRJNA870096 | 108974 | 170 | 1.133858 | 1.9275586 | Rocky Mountain birnavirus | 3077841 | Viruses | Viruses | 99.4 | 1.6000000000000002e-22 | NR | WNN64190.1 | 3077841 | g107310 | i0 | 92.9 | 0.988235294117647 | 56 | 4 | 98.8 | 0 | 168 | 1 | 761 | 816 | WNN64190.1 VP1 [Rocky Mountain birnavirus] | diamond | 168 | 99.4 | 1 | Viruses | Orthornavirae | Birnaviridae | Rocky Mountain birnavirus | ||||||
| 31224045 | 31224045 | PRJNA870096_S_NODE_26115_length_352_cov_6.935275_g24451_i0 | PRJNA870096 | 26115 | 352 | 6.935275 | 24.412168 | uncultured virus | 340016 | Viruses | Viruses | 63.2 | 9.21e-9 | NR | CAK7995066.1 | 340016 | g24451 | i0 | 77.3 | 0.758522727272727 | 44 | 10 | 37.5 | 0 | 350 | 219 | 1455 | 1498 | CAK7995066.1 Hypothetical protein POVR1_LOCUS584 [uncultured virus] | diamond | 267 | 63.2 | 1 | Viruses | uncultured virus | ||||||||
| 31414069 | 31414069 | PRJNA870096_S_NODE_64036_length_219_cov_1.363636_g62372_i0 | PRJNA870096 | 64036 | 219 | 1.363636 | 2.98636284 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 52 | 1.56e-5 | NR | QMI57975.1 | RQ13 | g62372 | i0 | 52.3 | 2.83561643835616 | 44 | 21 | 60.3 | 0 | 85 | 216 | 1029 | 1072 | QMI57975.1 polyprotein, partial [Pacific black duck sicinivirus-like virus] | diamond | 621 | 52 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Sicinivirus | Zebrafish jaw picornavirus | ||
| 31825037 | 31825037 | PRJNA870096_S_NODE_6797_length_717_cov_4.065282_g5446_i0 | PRJNA870096 | 6797 | 717 | 4.065282 | 29.14807194 | Gammaretrovirus murleu | 3428959 | Viruses | Viruses | 476 | 1.2799999999999998e-165 | NR | 8WUS_E | 11801 | g5446 | i0 | 99.1 | 2.91213389121339 | 232 | 2 | 97.1 | 0 | 697 | 2 | 138 | 369 | 8WUS_E Chain E, Gag-Pol polyprotein [Moloney murine leukemia virus] | diamond | 2088 | 476 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 31951696 | 31951696 | PRJNA870096_S_NODE_126097_length_159_cov_1.017241_g124433_i0 | PRJNA870096 | 126097 | 159 | 1.017241 | 1.61741319 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 52.8 | 2.51e-6 | NR | AMR72046.1 | 696863 | g124433 | i0 | 49 | 3.84905660377358 | 51 | 26 | 96.2 | 0 | 3 | 155 | 126 | 176 | AMR72046.1 glycoprotein, partial [Sprivivirus cyprinus] | diamond | 612 | 52.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 31951697 | 31951697 | PRJNA870096_S_NODE_12777_length_514_cov_10.719745_g11154_i0 | PRJNA870096 | 12777 | 514 | 10.719745 | 55.0994893 | uncultured virus | 340016 | Viruses | Viruses | 113 | 1.03e-25 | NR | CAH6421308.1 | 340016 | g11154 | i0 | 46.2 | 0.694552529182879 | 119 | 63 | 68.9 | 1 | 3 | 356 | 394 | 512 | CAH6421308.1 PQQ-binding beta-propeller repeat protein [uncultured virus] | diamond | 357 | 113 | 1 | Viruses | uncultured virus | ||||||||
| 32300181 | 32300181 | PRJNA870096_S_NODE_55079_length_237_cov_0.953608_g53415_i0 | PRJNA870096 | 55079 | 237 | 0.953608 | 2.26005096 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 104 | 2.33e-24 | NR | ADI48258.1 | RQ13 | g53415 | i0 | 57.1 | 0.974683544303797 | 77 | 32 | 97.5 | 1 | 2 | 232 | 121 | 196 | ADI48258.1 3D, partial [Bat kobuvirus TM003k] | diamond | 231 | 104 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Kobuvirus | Zebrafish jaw picornavirus | ||
| 32331816 | 32331816 | PRJNA870096_S_NODE_108579_length_170_cov_1.511811_g106915_i0 | PRJNA870096 | 108579 | 170 | 1.511811 | 2.5700787 | uncultured virus | 340016 | Viruses | Viruses | 52.4 | 5.48e-6 | NR | CAK7994547.1 | 340016 | g106915 | i0 | 47.4 | 1.00588235294118 | 57 | 25 | 91.8 | 1 | 1 | 156 | 444 | 500 | CAK7994547.1 Hypothetical protein POVR1_LOCUS71 [uncultured virus] | diamond | 171 | 52.4 | 1 | Viruses | uncultured virus | ||||||||
| 32394822 | 32394822 | PRJNA870096_S_NODE_115399_length_165_cov_2.459016_g113735_i0 | PRJNA870096 | 115399 | 165 | 2.459016 | 4.0573764 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 72.4 | 4.3e-13 | NR | NP_116744.1 | 696863 | g113735 | i0 | 64.8 | 0.981818181818182 | 54 | 19 | 98.2 | 0 | 4 | 165 | 335 | 388 | NP_116744.1 nucleocapsid protein [Sprivivirus cyprinus] | diamond | 162 | 72.4 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 32647099 | 32647099 | PRJNA870096_S_NODE_63520_length_220_cov_1.237288_g61856_i0 | PRJNA870096 | 63520 | 220 | 1.237288 | 2.7220336 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 94.7 | 1.41e-20 | NR | NP_116748.1 | 696863 | g61856 | i0 | 64.4 | 0.995454545454545 | 73 | 26 | 99.5 | 0 | 1 | 219 | 1802 | 1874 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 219 | 94.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 32710354 | 32710354 | PRJNA870096_S_NODE_23120_length_375_cov_4.475904_g21458_i0 | PRJNA870096 | 23120 | 375 | 4.475904 | 16.78464 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 142 | 8.29e-40 | NR | YP_010802923.1 | 3060017 | g21458 | i0 | 58.9 | 0.992 | 124 | 51 | 99.2 | 0 | 2 | 373 | 102 | 225 | YP_010802923.1 O-methyltransferase [Fadolivirus algeromassiliense] | diamond | 372 | 142 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense |
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);;