contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA662254" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21030769 | 21030769 | PRJNA662254_P_NODE_22597_length_346_cov_1.410256_g21946_i0 | PRJNA662254 | 22597 | 346 | 1.410256 | 4.87948576 | Partitiviridae sp. | 1955170 | Viruses | Viruses | 127 | 7.85e-33 | NR | QDH91349.1 | 1955170 | g21946 | i0 | 55.9 | 1.02312138728324 | 118 | 49 | 99.7 | 1 | 346 | 2 | 172 | 289 | QDH91349.1 MAG: hypothetical protein H3Bulk427771_000001, partial [Partitiviridae sp.] | diamond | 354 | 127 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Partitiviridae sp. | |||
| 27808175 | 27808175 | PRJNA662254_P_NODE_36604_length_277_cov_1.235294_g35953_i0 | PRJNA662254 | 36604 | 277 | 1.235294 | 3.42176438 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 85.1 | 7.44e-17 | NR | AVM87439.1 | 3063761 | g35953 | i0 | 44.4 | 1.07220216606498 | 99 | 48 | 99.6 | 1 | 276 | 1 | 977 | 1075 | AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] | diamond | 297 | 85.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Danio blood picornavirus/Zebrafish picornavirus 2 | ||||
| 27902520 | 27902520 | PRJNA662254_P_NODE_8525_length_576_cov_2.037773_g7886_i0 | PRJNA662254 | 8525 | 576 | 2.037773 | 11.73757248 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 224 | 4.5500000000000005e-64 | NR | QUS52515.1 | RQ13 | g7886 | i0 | 56 | 8.953125 | 191 | 83 | 99.5 | 1 | 574 | 2 | 2166 | 2355 | QUS52515.1 polyprotein [ludopivirus A1] | diamond | 5157 | 224 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Ludopivirus | Zebrafish jaw picornavirus | ||
| 27997535 | 27997535 | PRJNA662254_P_NODE_38705_length_270_cov_0.964467_g38054_i0 | PRJNA662254 | 38705 | 270 | 0.964467 | 2.6040609 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 102 | 7.429999999999999e-23 | NR | AVM87439.1 | 3063761 | g38054 | i0 | 51.1 | 0.977777777777778 | 88 | 43 | 97.8 | 0 | 265 | 2 | 284 | 371 | AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] | diamond | 264 | 102 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Danio blood picornavirus/Zebrafish picornavirus 2 | ||||
| 28029123 | 28029123 | PRJNA662254_P_NODE_965_length_1749_cov_1.733294_g758_i0 | PRJNA662254 | 965 | 1749 | 1.733294 | 30.31531206 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 158 | 1.82e-36 | NR | YP_009552756.1 | RQ13 | g758 | i0 | 42.6 | 0.382504288164666 | 223 | 118 | 37.2 | 5 | 1094 | 1744 | 1703 | 1921 | YP_009552756.1 polyprotein [Rhimavirus A] | diamond | 669 | 158 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish jaw picornavirus | |||
| 29229021 | 29229021 | PRJNA662254_P_NODE_489_length_2268_cov_3.131663_g378_i0 | PRJNA662254 | 489 | 2268 | 3.131663 | 71.02611684 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 1383 | 0 | NR | 6T0W_C | RQ01 | g378 | i0 | 90.3 | 0.992063492063492 | 750 | 73 | 99.2 | 0 | 2251 | 2 | 10 | 759 | 6T0W_C Chain C, Polymerase PB2 [Influenza B virus] | diamond | 2250 | 1383 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 29260134 | 29260134 | PRJNA662254_P_NODE_1289_length_1542_cov_29.628999_g1023_i0 | PRJNA662254 | 1289 | 1542 | 29.628999 | 456.87916458 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 576 | 1.6099999999999998e-200 | NR | AVM87625.1 | RQ01 | g1023 | i0 | 64 | 0.918287937743191 | 472 | 165 | 90.9 | 3 | 1482 | 82 | 1 | 472 | AVM87625.1 NA [Wuhan spiny eel influenza virus] | diamond | 1416 | 576 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza B-like virus | |||
| 29291894 | 29291894 | PRJNA662254_P_NODE_25189_length_329_cov_1.203125_g24538_i0 | PRJNA662254 | 25189 | 329 | 1.203125 | 3.95828125 | Tolivirales sp. | 2809914 | Viruses | Viruses | 127 | 1.4799999999999998e-31 | NR | WRQ65483.1 | 2809914 | g24538 | i0 | 62.5 | 1.92401215805471 | 104 | 39 | 94.8 | 0 | 327 | 16 | 373 | 476 | WRQ65483.1 hypothetical protein [Tolivirales sp.] | diamond | 633 | 127 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 29386814 | 29386814 | PRJNA662254_P_NODE_9_length_7241_cov_33.650112_g7_i0 | PRJNA662254 | 9 | 7241 | 33.650112 | 2436.60460992 | Zebrafish gut calicivirus | RQ08 | Viruses | Viruses | 1520 | 0 | NR | XBS25272.1 | RQ08 | g7 | i0 | 39.4 | 0.935091838143903 | 2257 | 1237 | 90.7 | 43 | 7143 | 574 | 10 | 2203 | XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] | diamond | 6771 | 1520 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Caliciviridae | Zebrafish gut calicivirus | |||
| 30049683 | 30049683 | PRJNA662254_P_NODE_7071_length_640_cov_1.768959_g6447_i0 | PRJNA662254 | 7071 | 640 | 1.768959 | 11.3213376 | Qianjiang marna-like virus 118 | 3347539 | Viruses | Viruses | 144 | 1.2e-35 | NR | XHA88256.1 | 3347539 | g6447 | i0 | 41.1 | 2.2125 | 158 | 88 | 74.1 | 2 | 166 | 639 | 1767 | 1919 | XHA88256.1 MAG: polyprotein [Qianjiang marna-like virus 118] | diamond | 1416 | 144 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Qianjiang marna-like virus 118 | |||
| 30397914 | 30397914 | PRJNA662254_P_NODE_733_length_1968_cov_1.868602_g577_i0 | PRJNA662254 | 733 | 1968 | 1.868602 | 36.77408736 | Ripigyrd virus | 3130284 | Viruses | Viruses | 496 | 1.32e-155 | NR | WZH59377.1 | 3130284 | g577 | i0 | 46 | 1.62957317073171 | 533 | 284 | 81.1 | 3 | 1927 | 332 | 909 | 1438 | WZH59377.1 MAG: RNA-dependent RNA polymerase [Ripigyrd virus] | diamond | 3207 | 496 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Ripigyrd virus | |||
| 30555197 | 30555197 | PRJNA662254_P_NODE_873_length_1831_cov_40.051195_g685_i0 | PRJNA662254 | 873 | 1831 | 40.051195 | 733.33738045 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 713 | 1.09e-251 | NR | AVM87624.1 | RQ01 | g685 | i0 | 62.6 | 0.932277444019661 | 569 | 209 | 93.1 | 3 | 75 | 1778 | 3 | 568 | AVM87624.1 hemagglutinin, partial [Wuhan spiny eel influenza virus] | diamond | 1707 | 713 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza B-like virus | |||
| 30744934 | 30744934 | PRJNA662254_P_NODE_25554_length_327_cov_1.023622_g24903_i0 | PRJNA662254 | 25554 | 327 | 1.023622 | 3.34724394 | Flumine marna-like virus 13 | 2941464 | Viruses | Viruses | 118 | 2.18e-28 | NR | UQB76244.1 | 2941464 | g24903 | i0 | 52.4 | 0.963302752293578 | 105 | 50 | 96.3 | 0 | 13 | 327 | 241 | 345 | UQB76244.1 nonstructural protein, partial [Flumine marna-like virus 13] | diamond | 315 | 118 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Flumine marna-like virus 13 | |||
| 32547852 | 32547852 | PRJNA662254_P_NODE_6919_length_647_cov_1.442509_g6299_i0 | PRJNA662254 | 6919 | 647 | 1.442509 | 9.33303323 | Durnavirales sp. | 2809355 | Viruses | Viruses | 123 | 5.56e-29 | NR | WRQ64726.1 | 2809355 | g6299 | i0 | 31.9 | 1.0015455950541 | 216 | 145 | 99.7 | 2 | 647 | 3 | 147 | 361 | WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.] | diamond | 648 | 123 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Durnavirales sp. | ||||
| 32622667 | 32622667 | PRJNA662254_P_NODE_7940_length_599_cov_1.671103_g7312_i0 | PRJNA662254 | 7940 | 599 | 1.671103 | 10.00990697 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 77.4 | 1.01e-12 | NR | NP_740444.1 | RQ13 | g7312 | i0 | 42.4 | 3.96661101836394 | 99 | 55 | 48.6 | 2 | 2 | 292 | 366 | 464 | NP_740444.1 3D [aichivirus A1] | diamond | 2376 | 77.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Kobuvirus | Zebrafish jaw picornavirus |
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);;