contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA1115053" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11708284 | 11708284 | PRJNA1115053_S_NODE_850_length_1920_cov_57.183804_g481_i0 | PRJNA1115053 | 850 | 1920 | 57.183804 | 1097.9290368 | Gammaretrovirus | 153135 | Viruses | Viruses | 1156 | 0 | NR | NP_040333.1 | 11795 | g481 | i0 | 96.3 | 5.5453125 | 592 | 22 | 92.5 | 0 | 143 | 1918 | 144 | 735 | NP_040333.1 RNA-dependent DNA polymerase, partial [Friend murine leukemia virus] | diamond | 10647 | 1165 | 0.992274678111588 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 28299687 | 28299687 | PRJNA1115053_S_NODE_256866_length_173_cov_2.323077_g255049_i0 | PRJNA1115053 | 256866 | 173 | 2.323077 | 4.01892321 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 96.3 | 4.59e-24 | NR | QCF47486.1 | 1543320 | g255049 | i0 | 79.3 | 1.00578034682081 | 58 | 11 | 98.8 | 1 | 3 | 173 | 33 | 90 | QCF47486.1 putative RNA-dependent DNA polymerase, partial [Erythrocytic necrosis virus] | diamond | 174 | 96.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 28520843 | 28520843 | PRJNA1115053_S_NODE_264227_length_171_cov_1.703125_g262410_i0 | PRJNA1115053 | 264227 | 171 | 1.703125 | 2.91234375 | Larimichthys croaker adintovirus | 2609857 | Viruses | Viruses | 90.5 | 9.22e-20 | NR | DAC81309.1 | 2609857 | g262410 | i0 | 75 | 2.92982456140351 | 56 | 14 | 98.2 | 0 | 3 | 170 | 155 | 210 | DAC81309.1 TPA_asm: integrase [Larimichthys croaker adintovirus] | diamond | 501 | 90.5 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Larimichthys croaker adintovirus | |||
| 28647155 | 28647155 | PRJNA1115053_S_NODE_154787_length_216_cov_5.098266_g152970_i0 | PRJNA1115053 | 154787 | 216 | 5.098266 | 11.01225456 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 48.9 | 2.46e-5 | NR | QCF47491.1 | 1543320 | g152970 | i0 | 54.3 | 0.638888888888889 | 46 | 18 | 61.1 | 2 | 172 | 41 | 24 | 68 | QCF47491.1 RNA-dependent DNA polymerase [Erythrocytic necrosis virus] | diamond | 138 | 48.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 29562581 | 29562581 | PRJNA1115053_S_NODE_149030_length_220_cov_1.627119_g147213_i0 | PRJNA1115053 | 149030 | 220 | 1.627119 | 3.5796618 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 74.7 | 8.6e-16 | NR | QCF47522.1 | 1543320 | g147213 | i0 | 76.6 | 1.97727272727273 | 47 | 11 | 64.1 | 0 | 25 | 165 | 21 | 67 | QCF47522.1 hypothetical protein, partial [Erythrocytic necrosis virus] | diamond | 435 | 74.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 29941786 | 29941786 | PRJNA1115053_S_NODE_260851_length_172_cov_1.705426_g259034_i0 | PRJNA1115053 | 260851 | 172 | 1.705426 | 2.93333272 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 96.7 | 3.2299999999999997e-24 | NR | QCF47486.1 | 1543320 | g259034 | i0 | 83 | 0.924418604651163 | 53 | 9 | 92.4 | 0 | 14 | 172 | 1 | 53 | QCF47486.1 putative RNA-dependent DNA polymerase, partial [Erythrocytic necrosis virus] | diamond | 159 | 96.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 29941789 | 29941789 | PRJNA1115053_S_NODE_303031_length_160_cov_2.461538_g301214_i0 | PRJNA1115053 | 303031 | 160 | 2.461538 | 3.9384608 | Larimichthys croaker adintovirus | 2609857 | Viruses | Viruses | 69.3 | 4.42e-12 | NR | DAC81309.1 | 2609857 | g301214 | i0 | 60.8 | 1.9125 | 51 | 20 | 95.6 | 0 | 153 | 1 | 230 | 280 | DAC81309.1 TPA_asm: integrase [Larimichthys croaker adintovirus] | diamond | 306 | 69.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Larimichthys croaker adintovirus | |||
| 30122101 | 30122101 | PRJNA1115053_S_NODE_64272_length_307_cov_2.223485_g62455_i0 | PRJNA1115053 | 64272 | 307 | 2.223485 | 6.8260989500000004 | Viruses | 10239 | Viruses | Viruses | 80.5 | 8.95e-16 | NR | DAC81253.1 | 2609866 | g62455 | i0 | 66.1 | 1.1628664495114 | 62 | 18 | 60.6 | 1 | 186 | 1 | 162 | 220 | DAC81253.1 TPA_asm: penton [Astyanax tetra cavefish adintovirus] | diamond | 357 | 81.3 | 0.990159901599016 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Astyanax tetra cavefish adintovirus | |||
| 30248879 | 30248879 | PRJNA1115053_S_NODE_100832_length_258_cov_2.455814_g99015_i0 | PRJNA1115053 | 100832 | 258 | 2.455814 | 6.33600012 | Viruses | 10239 | Viruses | Viruses | 73.6 | 6.44e-13 | NR | AVM87439.1 | 2116200 | g99015 | i0 | 48.1 | 1.75581395348837 | 79 | 37 | 87.2 | 1 | 33 | 257 | 917 | 995 | AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] | diamond | 453 | 73.9 | 0.995940460081191 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Wuhan sharpbelly picornavirus 1 | ||||
| 30889571 | 30889571 | PRJNA1115053_S_NODE_71814_length_294_cov_21.505976_g69997_i0 | PRJNA1115053 | 71814 | 294 | 21.505976 | 63.22756944 | Moloney murine leukemia virus | 11801 | Viruses | Viruses | 154 | 6.21e-41 | NR | NP_057933.2 | 11801 | g69997 | i0 | 97.5 | 0.816326530612245 | 80 | 2 | 81.6 | 0 | 292 | 53 | 1256 | 1335 | NP_057933.2 Pr180 [Moloney murine leukemia virus] | diamond | 240 | 154 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 31141893 | 31141893 | PRJNA1115053_S_NODE_332335_length_153_cov_1.900000_g330518_i0 | PRJNA1115053 | 332335 | 153 | 1.9 | 2.907 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 56.2 | 1.24e-7 | NR | DAC81394.1 | 2609864 | g330518 | i0 | 68.6 | 0.686274509803922 | 35 | 11 | 68.6 | 0 | 105 | 1 | 7 | 41 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 105 | 56.2 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 31426800 | 31426800 | PRJNA1115053_S_NODE_109896_length_249_cov_4.893204_g108079_i0 | PRJNA1115053 | 109896 | 249 | 4.893204 | 12.18407796 | Marsupial endogenous gammaretrovirus 2 | 3386030 | Viruses | Viruses | 61.2 | 1.19e-8 | NR | DBA62710.1 | 3386030 | g108079 | i0 | 51.7 | 1.44578313253012 | 60 | 29 | 72.3 | 0 | 3 | 182 | 425 | 484 | DBA62710.1 TPA_asm: Gag [Marsupial endogenous gammaretrovirus 2] | diamond | 360 | 61.2 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Marsupial endogenous gammaretrovirus 2 | ||
| 31711526 | 31711526 | PRJNA1115053_S_NODE_258357_length_173_cov_1.292308_g256540_i0 | PRJNA1115053 | 258357 | 173 | 1.292308 | 2.23569284 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 41.6 | 0.0134 | NR | QCF47486.1 | 1543320 | g256540 | i0 | 60.7 | 0.485549132947977 | 28 | 11 | 48.6 | 0 | 24 | 107 | 59 | 86 | QCF47486.1 putative RNA-dependent DNA polymerase, partial [Erythrocytic necrosis virus] | diamond | 84 | 41.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 31734013 | 31734013 | PRJNA1115053_S_NODE_298377_length_162_cov_0.899160_g296560_i0 | PRJNA1115053 | 298377 | 162 | 0.89916 | 1.4566392 | Viruses | 10239 | Viruses | Viruses | 71.6 | 6.5e-13 | NR | DAC81309.1 | 2609857 | g296560 | i0 | 66.7 | 3.55555555555556 | 48 | 16 | 88.9 | 0 | 3 | 146 | 189 | 236 | DAC81309.1 TPA_asm: integrase [Larimichthys croaker adintovirus] | diamond | 576 | 71.6 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Larimichthys croaker adintovirus | |||
| 31869596 | 31869596 | PRJNA1115053_S_NODE_84497_length_277_cov_1.747863_g82680_i0 | PRJNA1115053 | 84497 | 277 | 1.747863 | 4.84158051 | Astyanax tetra cavefish adintovirus | 2609866 | Viruses | Viruses | 45.1 | 0.00388 | NR | DAC81251.1 | 2609866 | g82680 | i0 | 26.6 | 0.693140794223827 | 64 | 47 | 69.3 | 0 | 25 | 216 | 65 | 128 | DAC81251.1 TPA_asm: Bcl2 [Astyanax tetra cavefish adintovirus] | diamond | 192 | 45.1 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Astyanax tetra cavefish adintovirus | |||
| 32249709 | 32249709 | PRJNA1115053_S_NODE_197538_length_195_cov_1.302632_g195721_i0 | PRJNA1115053 | 197538 | 195 | 1.302632 | 2.5401324 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 72.8 | 2.08e-14 | NR | QCF47477.1 | 1543320 | g195721 | i0 | 65.6 | 0.984615384615385 | 64 | 19 | 95.4 | 2 | 190 | 5 | 35 | 97 | QCF47477.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus] | diamond | 192 | 72.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 32849099 | 32849099 | PRJNA1115053_S_NODE_330200_length_154_cov_1.297297_g328383_i0 | PRJNA1115053 | 330200 | 154 | 1.297297 | 1.99783738 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 80.1 | 1.63e-17 | NR | QCF47477.1 | 1543320 | g328383 | i0 | 73.5 | 1.90909090909091 | 49 | 13 | 95.5 | 0 | 4 | 150 | 84 | 132 | QCF47477.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus] | diamond | 294 | 80.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus |
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);;