contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA949785" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4761642 | 4761642 | PRJNA949785_P_NODE_444_length_1579_cov_2.203851_g392_i0 | PRJNA949785 | 444 | 1579 | 2.203851 | 34.79880729 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 631 | 2.2999999999999993e-203 | NR | AVM87439.1 | 3063761 | g392 | i0 | 60.8 | 0.955668144395187 | 503 | 193 | 94.8 | 2 | 1497 | 1 | 1 | 503 | AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] | diamond | 1509 | 631 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Danio blood picornavirus/Zebrafish picornavirus 2 | ||||
| 27088856 | 27088856 | PRJNA949785_P_NODE_342_length_1700_cov_6.175784_g299_i0 | PRJNA949785 | 342 | 1700 | 6.175784 | 104.988328 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 426 | 3.28e-128 | NR | XBH24011.1 | RQ13 | g299 | i0 | 51 | 2.35588235294118 | 445 | 208 | 77.8 | 8 | 1696 | 374 | 1947 | 2385 | XBH24011.1 MAG: polyprotein [Coleura bat picornavirus] | diamond | 4005 | 426 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Zebrafish jaw picornavirus | ||||
| 27373485 | 27373485 | PRJNA949785_P_NODE_11643_length_300_cov_0.819383_g11446_i0 | PRJNA949785 | 11643 | 300 | 0.819383 | 2.458149 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 57.8 | 3.77e-7 | NR | CAB4132264.1 | 2100421 | g11446 | i0 | 40.2 | 1.07 | 107 | 57 | 100 | 3 | 1 | 300 | 291 | 397 | CAB4132264.1 hypothetical protein UFOVP248_7 [uncultured Caudovirales phage] | diamond | 321 | 57.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28162692 | 28162692 | PRJNA949785_P_NODE_17305_length_246_cov_0.890173_g17108_i0 | PRJNA949785 | 17305 | 246 | 0.890173 | 2.18982558 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 88.2 | 3.33e-18 | NR | XOR02773.1 | 2832643 | g17108 | i0 | 57.3 | 1 | 82 | 29 | 98.8 | 2 | 245 | 3 | 238 | 314 | XOR02773.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 246 | 88.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28232035 | 28232035 | PRJNA949785_P_NODE_9386_length_340_cov_2.561798_g9189_i0 | PRJNA949785 | 9386 | 340 | 2.561798 | 8.7101132 | Gammaretrovirus | 153135 | Viruses | Viruses | 212 | 3.8099999999999994e-61 | NR | NP_057933.2 | 11801 | g9189 | i0 | 97.3 | 4.94117647058824 | 112 | 3 | 98.8 | 0 | 338 | 3 | 1193 | 1304 | NP_057933.2 Pr180 [Moloney murine leukemia virus] | diamond | 1680 | 212 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 28383566 | 28383566 | PRJNA949785_P_NODE_17206_length_246_cov_0.890173_g17009_i0 | PRJNA949785 | 17206 | 246 | 0.890173 | 2.18982558 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 134 | 2.49e-34 | NR | XCM68338.1 | 3003959 | g17009 | i0 | 76.8 | 1 | 82 | 19 | 100 | 0 | 1 | 246 | 267 | 348 | XCM68338.1 MAG: structural polyprotein, partial [Picornavirales sp.] | diamond | 246 | 134 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 28636429 | 28636429 | PRJNA949785_P_NODE_6967_length_410_cov_1.599407_g6770_i0 | PRJNA949785 | 6967 | 410 | 1.599407 | 6.5575687 | Alishewanella phage vB_AspM_Slicko | 3038238 | Viruses | Viruses | 48.5 | 0.00124 | NR | WGH49528.1 | 3038238 | g6770 | i0 | 40 | 0.585365853658537 | 80 | 40 | 55.6 | 4 | 138 | 365 | 38 | 113 | WGH49528.1 hypothetical protein [Alishewanella phage vB_AspM_Slicko01] | diamond | 240 | 48.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Alishewanella phage vB_AspM_Slicko01 | |||||
| 28800437 | 28800437 | PRJNA949785_P_NODE_5167_length_495_cov_2.701422_g4970_i0 | PRJNA949785 | 5167 | 495 | 2.701422 | 13.3720389 | Viruses | 10239 | Viruses | Viruses | 119 | 1.51e-27 | NR | WPV63372.1 | 3084702 | g4970 | i0 | 45.8 | 1.74545454545455 | 131 | 71 | 79.4 | 0 | 2 | 394 | 437 | 567 | WPV63372.1 MAG: RNA-dependent RNA polymerase [Wenzhou shrew picornavirus 1] | diamond | 864 | 120 | 0.991666666666667 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Wenzhou shrew picornavirus 1 | ||||
| 28952180 | 28952180 | PRJNA949785_P_NODE_9608_length_336_cov_1.171103_g9411_i0 | PRJNA949785 | 9608 | 336 | 1.171103 | 3.93490608 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 68.9 | 8.76e-12 | NR | BCT22600.1 | RQ14 | g9411 | i0 | 35.1 | 0.991071428571429 | 111 | 69 | 97.3 | 2 | 6 | 332 | 44 | 153 | BCT22600.1 hypothetical protein [Carp edema virus] | diamond | 333 | 68.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 29141593 | 29141593 | PRJNA949785_P_NODE_3269_length_648_cov_3.059130_g3088_i0 | PRJNA949785 | 3269 | 648 | 3.05913 | 19.8231624 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 60.1 | 1.07e-6 | NR | BCT22626.1 | RQ14 | g3088 | i0 | 36.9 | 0.388888888888889 | 84 | 43 | 34.3 | 1 | 645 | 424 | 229 | 312 | BCT22626.1 putative DNA-binding virion core protein [Carp edema virus] | diamond | 252 | 60.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 29362469 | 29362469 | PRJNA949785_P_NODE_16909_length_247_cov_0.885057_g16712_i0 | PRJNA949785 | 16909 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 82.8 | 9e-17 | NR | DAP03080.1 | 2832643 | g16712 | i0 | 56.1 | 0.995951417004049 | 82 | 35 | 98.4 | 1 | 247 | 5 | 138 | 219 | DAP03080.1 MAG TPA: hypothetical protein, partial [Caudoviricetes sp.] | diamond | 246 | 82.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29621103 | 29621103 | PRJNA949785_P_NODE_17250_length_246_cov_0.890173_g17053_i0 | PRJNA949785 | 17250 | 246 | 0.890173 | 2.18982558 | Potexvirus | 12176 | Viruses | Viruses | 86.3 | 1.94e-17 | NR | BDG15104.1 | 12177 | g17053 | i0 | 80 | 2.4390243902439 | 50 | 10 | 61 | 0 | 1 | 150 | 1033 | 1082 | BDG15104.1 RNA-dependent RNA polymerase [Clover yellow mosaic virus] | diamond | 600 | 86.3 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus flavitrifolii | ||
| 30246932 | 30246932 | PRJNA949785_P_NODE_8452_length_363_cov_1.593103_g8255_i0 | PRJNA949785 | 8452 | 363 | 1.593103 | 5.78296389 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 90.9 | 2.16e-18 | NR | WLN26256.1 | 3065075 | g8255 | i0 | 51.7 | 0.71900826446281 | 87 | 42 | 71.9 | 0 | 97 | 357 | 229 | 315 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 261 | 90.9 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 30373492 | 30373492 | PRJNA949785_P_NODE_15712_length_251_cov_0.865169_g15515_i0 | PRJNA949785 | 15712 | 251 | 0.865169 | 2.17157419 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 88.6 | 2.17e-18 | NR | BCT22672.1 | RQ14 | g15515 | i0 | 51.8 | 0.99203187250996006 | 83 | 40 | 99.2 | 0 | 1 | 249 | 330 | 412 | BCT22672.1 sialidase [Carp edema virus] | diamond | 249 | 88.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 30530976 | 30530976 | PRJNA949785_P_NODE_4633_length_526_cov_2.039735_g4437_i0 | PRJNA949785 | 4633 | 526 | 2.039735 | 10.7290061 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 101 | 1.66e-22 | NR | BCT22606.1 | RQ14 | g4437 | i0 | 44.8 | 0.496197718631179 | 87 | 48 | 49.6 | 0 | 99 | 359 | 177 | 263 | BCT22606.1 hypothetical protein AL387_gp060 [Carp edema virus] | diamond | 261 | 101 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 30594143 | 30594143 | PRJNA949785_P_NODE_1733_length_904_cov_6.815884_g1587_i0 | PRJNA949785 | 1733 | 904 | 6.815884 | 61.61559136 | Nucleocytoviricota sp. | 2809609 | Viruses | Viruses | 59.3 | 4.57e-6 | NR | UZT28929.1 | 2809609 | g1587 | i0 | 41.9 | 0.245575221238938 | 74 | 38 | 24.6 | 1 | 207 | 428 | 1 | 69 | UZT28929.1 hypothetical protein [Nucleocytoviricota sp.] | diamond | 222 | 59.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Nucleocytoviricota sp. | ||||||
| 30657391 | 30657391 | PRJNA949785_P_NODE_17693_length_245_cov_0.895349_g17496_i0 | PRJNA949785 | 17693 | 245 | 0.895349 | 2.19360505 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 73.2 | 2.88e-14 | NR | UZH43396.1 | RQ14 | g17496 | i0 | 50 | 1.61632653061224 | 66 | 33 | 80.8 | 0 | 46 | 243 | 33 | 98 | UZH43396.1 uracil DNA glycosylase, partial [Carp edema virus] | diamond | 396 | 73.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 31131098 | 31131098 | PRJNA949785_P_NODE_12255_length_291_cov_0.908257_g12058_i0 | PRJNA949785 | 12255 | 291 | 0.908257 | 2.64302787 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 68.6 | 5.71e-11 | NR | BCT22678.1 | RQ14 | g12058 | i0 | 36.7 | 0.927835051546392 | 90 | 57 | 92.8 | 0 | 277 | 8 | 1875 | 1964 | BCT22678.1 B22R protein [Carp edema virus] | diamond | 270 | 68.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 31289317 | 31289317 | PRJNA949785_P_NODE_8055_length_375_cov_1.529801_g7858_i0 | PRJNA949785 | 8055 | 375 | 1.529801 | 5.73675375 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 123 | 1.11e-29 | NR | BCT22673.1 | RQ14 | g7858 | i0 | 77.9 | 0.544 | 68 | 15 | 54.4 | 0 | 3 | 206 | 1103 | 1170 | BCT22673.1 DNA-dependent RNA polymerase subunit rpo132 [Carp edema virus] | diamond | 204 | 123 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 31352771 | 31352771 | PRJNA949785_P_NODE_11796_length_297_cov_1.375000_g11599_i0 | PRJNA949785 | 11796 | 297 | 1.375 | 4.08375 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 70.9 | 1.01e-13 | NR | BCT22645.1 | RQ14 | g11599 | i0 | 50 | 0.707070707070707 | 70 | 35 | 70.7 | 0 | 13 | 222 | 5 | 74 | BCT22645.1 S-S bond formation pathway protein [Carp edema virus] | diamond | 210 | 70.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 31352777 | 31352777 | PRJNA949785_P_NODE_16516_length_248_cov_0.880000_g16319_i0 | PRJNA949785 | 16516 | 248 | 0.88 | 2.1824 | Shahe picorna-like virus 8 | 1923451 | Viruses | Viruses | 51.2 | 4.17e-5 | NR | APG77369.1 | 1923451 | g16319 | i0 | 39.7 | 0.883064516129032 | 73 | 44 | 88.3 | 0 | 2 | 220 | 95 | 167 | APG77369.1 hypothetical protein 1 [Shahe picorna-like virus 8] | diamond | 219 | 51.2 | 1 | Viruses | Shahe picorna-like virus 8 | ||||||||
| 31738674 | 31738674 | PRJNA949785_P_NODE_2257_length_784_cov_1.610408_g2092_i0 | PRJNA949785 | 2257 | 784 | 1.610408 | 12.62559872 | Gammaretrovirus | 153135 | Viruses | Viruses | 533 | 6.909999999999999e-174 | NR | ABU54795.1 | 11786 | g2092 | i0 | 99.2 | 8.95408163265306 | 260 | 2 | 99.5 | 0 | 3 | 782 | 667 | 926 | ABU54795.1 gag-pro-pol polyprotein [Murine leukemia virus] | diamond | 7020 | 537 | 0.992551210428305 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 31795305 | 31795305 | PRJNA949785_P_NODE_5977_length_454_cov_1.606299_g5780_i0 | PRJNA949785 | 5977 | 454 | 1.606299 | 7.29259746 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 52.4 | 1.6e-4 | NR | YP_006576515.1 | RQ13 | g5780 | i0 | 25.5 | 0.958149779735683 | 145 | 91 | 92.5 | 3 | 421 | 2 | 1327 | 1459 | YP_006576515.1 polyprotein [gallivirus A1] | diamond | 435 | 52.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Gallivirus | Zebrafish jaw picornavirus | ||
| 31826974 | 31826974 | PRJNA949785_P_NODE_15217_length_254_cov_1.220994_g15020_i0 | PRJNA949785 | 15217 | 254 | 1.220994 | 3.10132476 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 52.4 | 1.57e-5 | NR | CAB4196514.1 | 2100421 | g15020 | i0 | 51.2 | 1.5 | 41 | 20 | 48.4 | 0 | 119 | 241 | 1 | 41 | CAB4196514.1 RfbB dTDP-D-glucose 4,6-dehydratase [uncultured Caudovirales phage] | diamond | 381 | 52.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31985253 | 31985253 | PRJNA949785_P_NODE_3318_length_643_cov_1.424561_g3137_i0 | PRJNA949785 | 3318 | 643 | 1.424561 | 9.15992723 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 59.3 | 3.02e-6 | NR | WPS63802.1 | RQ13 | g3137 | i0 | 29.3 | 0.685847589424572 | 147 | 94 | 66.3 | 5 | 514 | 89 | 975 | 1116 | WPS63802.1 MAG: polyprotein [Passerivirus GPS] | diamond | 441 | 59.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Passerivirus | Zebrafish jaw picornavirus | ||
| 32016929 | 32016929 | PRJNA949785_P_NODE_14558_length_261_cov_2.457447_g14361_i0 | PRJNA949785 | 14558 | 261 | 2.457447 | 6.41393667 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 48.5 | 5.44e-5 | NR | BCT22656.1 | RQ14 | g14361 | i0 | 40 | 0.977011494252874 | 85 | 42 | 96.6 | 3 | 3 | 254 | 12 | 88 | BCT22656.1 hypothetical protein [Carp edema virus] | diamond | 255 | 48.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus |
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);;