contig_metadata
18 rows where bioproject = "PRJNA1105232" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11691298 | 11691298 | PRJNA1105232_S_NODE_5890_length_248_cov_3.969849_g5674_i0 | PRJNA1105232 | 5890 | 248 | 3.969849 | 9.84522552 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g5674 | i0 | 100 | 0.229838709677419 | 29 | 0 | 12 | 0 | 220 | 248 | 41 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 12966404 | 12966404 | PRJNA1105232_S_NODE_12651_length_183_cov_1.014925_g12435_i0 | PRJNA1105232 | 12651 | 183 | 1.014925 | 1.85731275 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 250 | 5.15e-62 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g12435 | i0 | 98.582 | 3.0655737704918 | 141 | 2 | 100 | 0 | 43 | 183 | 5635 | 5495 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 561 | 250 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 12966436 | 12966436 | PRJNA1105232_S_NODE_2331_length_355_cov_89.588235_g2115_i0 | PRJNA1105232 | 2331 | 355 | 89.588235 | 318.03823425 | Betaentomopoxvirus amoorei | 28321 | Viruses | Viruses | 52.8 | 0.034 | NTclustered | gi|9964314|ref|NC_002520.1| | 28321 | g2115 | i0 | 94.286 | 0.0985915492957746 | 35 | 1 | 10 | 1 | 107 | 140 | 153475 | 153509 | Amsacta moorei entomopoxvirus 'L', complete genome | blastn | 35 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Betaentomopoxvirus | Betaentomopoxvirus amoorei | ||
| 14241403 | 14241403 | PRJNA1105232_S_NODE_18732_length_152_cov_3.145631_g18516_i0 | PRJNA1105232 | 18732 | 152 | 3.145631 | 4.78135912 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 121 | 3.36e-23 | NTclustered | gi|1624806695|gb|MK638714.1| | 1543320 | g18516 | i0 | 92.857 | 46.0986842105263 | 84 | 4 | 54 | 1 | 2 | 83 | 242 | 325 | Erythrocytic necrosis virus isolate SEQ_9 putative RNA-dependent DNA polymerase mRNA, complete cds | blastn | 7007 | 121 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 15515221 | 15515221 | PRJNA1105232_S_NODE_3313_length_311_cov_2.557252_g3097_i0 | PRJNA1105232 | 3313 | 311 | 2.557252 | 7.95305372 | Mimivirus LCMiAC | 2506608 | Viruses | Viruses | 163 | 1.13e-46 | NR | QBK88431.1 | 2506608 | g3097 | i0 | 71.8 | 0.993569131832797 | 103 | 29 | 99.4 | 0 | 310 | 2 | 237 | 339 | QBK88431.1 MAG: GDP-mannose 4,6 dehydratase [Mimivirus LCMiAC01] | diamond | 309 | 163 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus LCMiAC01 | |||
| 18064233 | 18064233 | PRJNA1105232_S_NODE_11655_length_189_cov_1.857143_g11439_i0 | PRJNA1105232 | 11655 | 189 | 1.857143 | 3.51000027 | Pestivirus bovis | 3052619 | Viruses | Viruses | 331 | 1.86e-86 | NTclustered | gi|2858850717|gb|PQ613792.1| | 11099 | g11439 | i0 | 98.404 | 99.9259259259259 | 188 | 3 | 99 | 0 | 1 | 188 | 8781 | 8594 | Bovine viral diarrhea virus 1 isolate USMARC/PI-91-21/MDBK polyprotein gene, complete cds | blastn | 18886 | 331 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 19338412 | 19338412 | PRJNA1105232_S_NODE_1576_length_410_cov_48.667590_g1361_i0 | PRJNA1105232 | 1576 | 410 | 48.66759 | 199.537119 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 712 | 0 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g1361 | i0 | 98.049 | 4.26341463414634 | 410 | 7 | 100 | 1 | 1 | 410 | 8221 | 7813 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 1748 | 712 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 24438473 | 24438473 | PRJNA1105232_S_NODE_10260_length_199_cov_25.033333_g10044_i0 | PRJNA1105232 | 10260 | 199 | 25.033333 | 49.81633267 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g10044 | i0 | 100 | 0.728643216080402 | 29 | 0 | 15 | 0 | 171 | 199 | 41 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 145 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 24438479 | 24438479 | PRJNA1105232_S_NODE_12320_length_185_cov_0.860294_g12104_i0 | PRJNA1105232 | 12320 | 185 | 0.860294 | 1.5915439 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g12104 | i0 | 100 | 0.313513513513514 | 30 | 0 | 16 | 0 | 1 | 30 | 6 | 35 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 27036074 | 27036074 | PRJNA1105232_S_NODE_10602_length_197_cov_1.405405_g10386_i0 | PRJNA1105232 | 10602 | 197 | 1.405405 | 2.76864785 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 73.2 | 2.5e-13 | NR | YP_010803631.1 | 3060017 | g10386 | i0 | 60 | 1.6751269035533 | 55 | 22 | 83.8 | 0 | 31 | 195 | 222 | 276 | YP_010803631.1 thioredoxin-disulfide reductase [Fadolivirus algeromassiliense] | diamond | 330 | 73.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 27668087 | 27668087 | PRJNA1105232_S_NODE_14584_length_172_cov_1.219512_g14368_i0 | PRJNA1105232 | 14584 | 172 | 1.219512 | 2.09756064 | Clandestinovirus | 2831644 | Viruses | Viruses | 48.5 | 1.16e-4 | NR | QYA18833.1 | 2831644 | g14368 | i0 | 43.6 | 0.959302325581395 | 55 | 31 | 95.9 | 0 | 6 | 170 | 173 | 227 | QYA18833.1 hypothetical protein KOM_12_565 [Clandestinovirus] | diamond | 165 | 48.5 | 1 | Viruses | Clandestinovirus | ||||||||
| 28267679 | 28267679 | PRJNA1105232_S_NODE_9866_length_203_cov_1.688312_g9650_i0 | PRJNA1105232 | 9866 | 203 | 1.688312 | 3.42727336 | Mimivirus LCMiAC | 2506608 | Viruses | Viruses | 94.7 | 3.94e-21 | NR | QBK88431.1 | 2506608 | g9650 | i0 | 59.7 | 0.990147783251232 | 67 | 27 | 99 | 0 | 1 | 201 | 267 | 333 | QBK88431.1 MAG: GDP-mannose 4,6 dehydratase [Mimivirus LCMiAC01] | diamond | 201 | 94.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus LCMiAC01 | |||
| 28804372 | 28804372 | PRJNA1105232_S_NODE_13968_length_175_cov_1.452381_g13752_i0 | PRJNA1105232 | 13968 | 175 | 1.452381 | 2.54166675 | Hyperionvirus sp. | 2487770 | Viruses | Viruses | 67.4 | 1.83e-11 | NR | AYV83828.1 | 2487770 | g13752 | i0 | 57.4 | 0.805714285714286 | 47 | 20 | 80.6 | 0 | 153 | 13 | 221 | 267 | AYV83828.1 MAG: putative ubiquitin carboxyl-terminal hydrolase 2 isoform X1 [Hyperionvirus sp.] | diamond | 141 | 67.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hyperionvirus sp. | |||
| 28867725 | 28867725 | PRJNA1105232_S_NODE_15848_length_167_cov_0.881356_g15632_i0 | PRJNA1105232 | 15848 | 167 | 0.881356 | 1.47186452 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 58.2 | 2.82e-8 | NR | DAC81394.1 | 2609864 | g15632 | i0 | 69.4 | 0.646706586826347 | 36 | 11 | 64.7 | 0 | 110 | 3 | 7 | 42 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 108 | 58.2 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 29751568 | 29751568 | PRJNA1105232_S_NODE_10871_length_195_cov_1.068493_g10655_i0 | PRJNA1105232 | 10871 | 195 | 1.068493 | 2.08356135 | Hyperionvirus sp. | 2487770 | Viruses | Viruses | 68.6 | 1.74e-12 | NR | AYV82866.1 | 2487770 | g10655 | i0 | 52.6 | 0.876923076923077 | 57 | 27 | 87.7 | 0 | 172 | 2 | 6 | 62 | AYV82866.1 MAG: homeobox protein 4 [Hyperionvirus sp.] | diamond | 171 | 68.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hyperionvirus sp. | |||
| 31047454 | 31047454 | PRJNA1105232_S_NODE_935_length_498_cov_1.815145_g723_i0 | PRJNA1105232 | 935 | 498 | 1.815145 | 9.0394221 | Kaumoebavirus | 1859492 | Viruses | Viruses | 84 | 2.12e-15 | NR | YP_009352567.1 | 1859492 | g723 | i0 | 44.2 | 1.24096385542169 | 104 | 54 | 60.8 | 3 | 496 | 194 | 393 | 495 | YP_009352567.1 Peroxinectin [Kaumoebavirus] | diamond | 618 | 84 | 1 | Viruses | Kaumoebavirus | ||||||||
| 31869281 | 31869281 | PRJNA1105232_S_NODE_12917_length_181_cov_2.053030_g12701_i0 | PRJNA1105232 | 12917 | 181 | 2.05303 | 3.7159843 | Adintovirus anguilla10665 | 3115889 | Viruses | Viruses | 63.9 | 6.96e-11 | NR | DBA49781.1 | 3115889 | g12701 | i0 | 62.2 | 0.74585635359116 | 45 | 17 | 74.6 | 0 | 171 | 37 | 7 | 51 | DBA49781.1 MAG TPA_asm: Cupiennin [Adintovirus anguilla10665] | diamond | 135 | 63.9 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus anguilla10665 | |||
| 31892280 | 31892280 | PRJNA1105232_S_NODE_7797_length_222_cov_3.606936_g7581_i0 | PRJNA1105232 | 7797 | 222 | 3.606936 | 8.00739792 | Salarius guttatus piscichuvirus | 2951531 | Viruses | Viruses | 59.7 | 3e-8 | NR | QHX39772.1 | 2951531 | g7581 | i0 | 44.6 | 2 | 74 | 39 | 97.3 | 1 | 221 | 6 | 6 | 79 | QHX39772.1 RNA-dependent RNA polymerase [Herr Frank virus 1] | diamond | 444 | 59.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | Salarius guttatus piscichuvirus |
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);;