contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA1214993" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26724002 | 26724002 | PRJNA1214993_P_NODE_11361_length_327_cov_0.921260_g11175_i0 | PRJNA1214993 | 11361 | 327 | 0.92126 | 3.0125202 | Aspo dicistro-like virus | 2994985 | Viruses | Viruses | 62.4 | 1.21e-8 | NR | UZO29912.1 | 2994985 | g11175 | i0 | 58.7 | 0.422018348623853 | 46 | 19 | 42.2 | 0 | 318 | 181 | 298 | 343 | UZO29912.1 MAG: RNA-dependent RNA polymerase, partial [Aspo dicistro-like virus] | diamond | 138 | 62.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aspo dicistro-like virus | |||
| 27009267 | 27009267 | PRJNA1214993_P_NODE_23002_length_247_cov_0.896552_g22816_i0 | PRJNA1214993 | 23002 | 247 | 0.896552 | 2.21448344 | Hepelivirales sp. | 2809460 | Viruses | Viruses | 61.2 | 1.24e-8 | NR | WAY16469.1 | 2809460 | g22816 | i0 | 63.6 | 0.534412955465587 | 44 | 16 | 53.4 | 0 | 240 | 109 | 1697 | 1740 | WAY16469.1 nonstructural polyprotein [Hepelivirales sp.] | diamond | 132 | 61.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepelivirales sp. | ||||
| 27388922 | 27388922 | PRJNA1214993_P_NODE_24403_length_245_cov_0.895349_g24217_i0 | PRJNA1214993 | 24403 | 245 | 0.895349 | 2.19360505 | Feldmannia irregularis virus a | 231992 | Viruses | Viruses | 48.5 | 3.35e-4 | NR | YP_009665724.1 | 231992 | g24217 | i0 | 39.3 | 0.746938775510204 | 61 | 33 | 69.8 | 1 | 202 | 32 | 64 | 124 | YP_009665724.1 FirrV-1-A48 precursor [Feldmannia irregularis virus a] | diamond | 183 | 48.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Phaeovirus | Phaeovirus irregularis | ||
| 27452085 | 27452085 | PRJNA1214993_P_NODE_15663_length_282_cov_0.813397_g15477_i0 | PRJNA1214993 | 15663 | 282 | 0.813397 | 2.29377954 | Homavirus sp. | 2487769 | Viruses | Viruses | 94.4 | 1.04e-20 | NR | AYV82419.1 | 2487769 | g15477 | i0 | 45.6 | 0.957446808510638 | 90 | 49 | 95.7 | 0 | 278 | 9 | 233 | 322 | AYV82419.1 MAG: elongation factor 1-alpha-like protein [Homavirus sp.] | diamond | 270 | 94.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Homavirus sp. | |||
| 29756641 | 29756641 | PRJNA1214993_P_NODE_1171_length_932_cov_4.679860_g1033_i0 | PRJNA1214993 | 1171 | 932 | 4.67986 | 43.6162952 | Durnavirales sp. | 2809355 | Viruses | Viruses | 212 | 3.08e-61 | NR | WRQ64726.1 | 2809355 | g1033 | i0 | 37.2 | 0.978540772532189 | 304 | 188 | 97.2 | 3 | 14 | 919 | 179 | 481 | WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.] | diamond | 912 | 212 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Durnavirales sp. | ||||
| 30483467 | 30483467 | PRJNA1214993_P_NODE_3513_length_565_cov_2.371951_g3331_i0 | PRJNA1214993 | 3513 | 565 | 2.371951 | 13.40152315 | Gammapartitivirus sp. | 2809420 | Viruses | Viruses | 95.9 | 2.99e-19 | NR | UDL14336.1 | 2809420 | g3331 | i0 | 36.5 | 0.886725663716814 | 167 | 100 | 85.5 | 2 | 490 | 8 | 102 | 268 | UDL14336.1 MAG: RNA-dependent RNA polymerase [Gammapartitivirus sp.] | diamond | 501 | 95.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Gammapartitivirus | Gammapartitivirus sp. | ||
| 30736085 | 30736085 | PRJNA1214993_P_NODE_1374_length_877_cov_4.638060_g1225_i0 | PRJNA1214993 | 1374 | 877 | 4.63806 | 40.6757862 | Pseudogymnoascus destructans partitivirus-pa | 1685502 | Viruses | Viruses | 181 | 5.7e-49 | NR | YP_009259752.1 | 1685502 | g1225 | i0 | 43.2 | 3.8072976054732 | 229 | 115 | 78 | 4 | 89 | 772 | 277 | 491 | YP_009259752.1 RNA-dependent RNA polymerase [Pseudogymnoascus destructans partitivirus-pa] | diamond | 3339 | 181 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Pseudogymnoascus destructans partitivirus-pa | |||
| 30894300 | 30894300 | PRJNA1214993_P_NODE_19614_length_253_cov_0.866667_g19428_i0 | PRJNA1214993 | 19614 | 253 | 0.866667 | 2.19266751 | Qianjiang marna-like virus 1 | 3347518 | Viruses | Viruses | 55.8 | 1.04e-6 | NR | XHA88237.1 | 3347528 | g19428 | i0 | 34.9 | 0.984189723320158 | 83 | 50 | 98.4 | 1 | 250 | 2 | 403 | 481 | XHA88237.1 MAG: putative viral coat protein [Qianjiang marna-like virus 108] | diamond | 249 | 55.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Qianjiang marna-like virus 108 | |||
| 30957521 | 30957521 | PRJNA1214993_P_NODE_24294_length_245_cov_0.906977_g24108_i0 | PRJNA1214993 | 24294 | 245 | 0.906977 | 2.22209365 | uncultured marine Microviridae | 1385659 | Viruses | Viruses | 42.4 | 0.0479 | NR | AGT39893.1 | 1385659 | g24108 | i0 | 39.7 | 0.83265306122449 | 68 | 40 | 83.3 | 1 | 215 | 12 | 80 | 146 | AGT39893.1 major capsid protein, partial [uncultured marine Microviridae] | diamond | 204 | 42.4 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | uncultured marine Microviridae | |||
| 31558254 | 31558254 | PRJNA1214993_P_NODE_26696_length_228_cov_2.464516_g26510_i0 | PRJNA1214993 | 26696 | 228 | 2.464516 | 5.61909648 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 75.5 | 8.79e-14 | NR | URG14752.1 | 1530251 | g26510 | i0 | 47.3 | 0.973684210526316 | 74 | 38 | 97.4 | 1 | 5 | 226 | 554 | 626 | URG14752.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] | diamond | 222 | 75.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 31779272 | 31779272 | PRJNA1214993_P_NODE_11397_length_326_cov_1.541502_g11211_i0 | PRJNA1214993 | 11397 | 326 | 1.541502 | 5.02529652 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 67.8 | 1.67e-10 | NR | WLN26256.1 | 3065075 | g11211 | i0 | 46.2 | 0.598159509202454 | 65 | 35 | 59.8 | 0 | 6 | 200 | 170 | 234 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 195 | 67.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 31842514 | 31842514 | PRJNA1214993_P_NODE_17437_length_268_cov_1.600000_g17251_i0 | PRJNA1214993 | 17437 | 268 | 1.6 | 4.288 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 43.5 | 0.0277 | NR | ASG92535.1 | 3003959 | g17251 | i0 | 32.4 | 0.828358208955224 | 74 | 49 | 82.8 | 1 | 34 | 255 | 285 | 357 | ASG92535.1 putative structural protein [Picornavirales N_OV_003] | diamond | 222 | 43.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 31937460 | 31937460 | PRJNA1214993_P_NODE_2877_length_621_cov_4.065693_g2698_i0 | PRJNA1214993 | 2877 | 621 | 4.065693 | 25.24795353 | Durnavirales sp. | 2809355 | Viruses | Viruses | 95.5 | 5.8e-19 | NR | WRQ64726.1 | 2809355 | g2698 | i0 | 33 | 0.85024154589372 | 176 | 115 | 83.6 | 3 | 521 | 3 | 11 | 186 | WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.] | diamond | 528 | 95.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Durnavirales sp. | ||||
| 32019720 | 32019720 | PRJNA1214993_P_NODE_15378_length_284_cov_1.094787_g15192_i0 | PRJNA1214993 | 15378 | 284 | 1.094787 | 3.10919508 | Narnavirus | 186767 | Viruses | Viruses | 61.6 | 1.38e-8 | NR | UYL94525.1 | 2985682 | g15192 | i0 | 38.3 | 2.55633802816901 | 81 | 48 | 83.5 | 1 | 48 | 284 | 140 | 220 | UYL94525.1 MAG: RNA-dependent RNA polymerase [Leptosphaeria biglobosa narnavirus 7] | diamond | 726 | 61.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Leptosphaeria biglobosa narnavirus 7 | ||
| 32190852 | 32190852 | PRJNA1214993_P_NODE_7998_length_383_cov_1.258065_g7812_i0 | PRJNA1214993 | 7998 | 383 | 1.258065 | 4.81838895 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 90.5 | 3.46e-18 | NR | URG14752.1 | 1530251 | g7812 | i0 | 43.3 | 0.759791122715405 | 97 | 55 | 76 | 0 | 378 | 88 | 112 | 208 | URG14752.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] | diamond | 291 | 90.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 32380670 | 32380670 | PRJNA1214993_P_NODE_10659_length_336_cov_1.779468_g10473_i0 | PRJNA1214993 | 10659 | 336 | 1.779468 | 5.97901248 | Ohio dicistro-like virus | 2789442 | Viruses | Viruses | 63.5 | 5.75e-9 | NR | QPN36938.1 | 2789442 | g10473 | i0 | 39.6 | 1.625 | 91 | 55 | 81.3 | 0 | 9 | 281 | 2470 | 2560 | QPN36938.1 polyprotein [Ohio dicistro-like virus] | diamond | 546 | 63.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Ohio dicistro-like virus | |||
| 32903926 | 32903926 | PRJNA1214993_P_NODE_8840_length_366_cov_1.972696_g8654_i0 | PRJNA1214993 | 8840 | 366 | 1.972696 | 7.22006736 | Narnavirus | 186767 | Viruses | Viruses | 48.5 | 0.00135 | NR | QTE76053.1 | 2818058 | g8654 | i0 | 29.7 | 4.81147540983607 | 111 | 68 | 87.7 | 4 | 17 | 337 | 120 | 224 | QTE76053.1 RNA-dependent RNA polymerase [Neofusicoccum parvum narnavirus 3] | diamond | 1761 | 48.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Neofusicoccum parvum narnavirus 3 |
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);;