contig_metadata
13 rows where analysis = "diamond" and tax_clade = "Human endogenous retroviruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22640150 | 22640150 | PRJNA981359_S_NODE_60618_length_260_cov_1.374332_g60518_i0 | PRJNA981359 | 60618 | 260 | 1.374332 | 3.5732632 | Human endogenous retrovirus K | 45617 | Viruses | Viruses | 54.3 | 3.91e-6 | NR | CAA76882.1 | 45617 | g60518 | i0 | 61.4 | 5.58461538461538 | 44 | 17 | 50.8 | 0 | 128 | 259 | 571 | 614 | CAA76882.1 pol protein [Human endogenous retrovirus K] | diamond | 1452 | 54.3 | 1 | Viruses | Human endogenous retroviruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Human endogenous retrovirus K | ||
| 27279253 | 27279253 | PRJNA981359_S_NODE_46163_length_289_cov_0.842593_g46063_i0 | PRJNA981359 | 46163 | 289 | 0.842593 | 2.43509377 | Human endogenous retrovirus K | 45617 | Viruses | Viruses | 88.6 | 2.64e-19 | NR | ABA28250.1 | 45617 | g46063 | i0 | 52.9 | 5.26297577854671 | 85 | 40 | 88.2 | 0 | 257 | 3 | 101 | 185 | ABA28250.1 protease, partial [Human endogenous retrovirus K] | diamond | 1521 | 88.6 | 1 | Viruses | Human endogenous retroviruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Human endogenous retrovirus K | ||
| 27294830 | 27294830 | PRJNA1241156_S_NODE_48243_length_280_cov_4.987342_g47783_i0 | PRJNA1241156 | 48243 | 280 | 4.987342 | 13.9645576 | Human endogenous retrovirus K | 45617 | Viruses | Viruses | 70.5 | 1.04e-11 | NR | CAA76882.1 | 45617 | g47783 | i0 | 49.3 | 4.82142857142857 | 75 | 38 | 80.4 | 0 | 235 | 11 | 199 | 273 | CAA76882.1 pol protein [Human endogenous retrovirus K] | diamond | 1350 | 71.2 | 0.990168539325843 | Viruses | Human endogenous retroviruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Human endogenous retrovirus K | ||
| 27595171 | 27595171 | PRJNA982720_S_NODE_9184_length_247_cov_0.839080_g9156_i0 | PRJNA982720 | 9184 | 247 | 0.83908 | 2.0725276 | Human endogenous retrovirus K | 45617 | Viruses | Viruses | 106 | 2.07e-26 | NR | ABA28250.1 | 45617 | g9156 | i0 | 63 | 3.93522267206478 | 81 | 30 | 98.4 | 0 | 244 | 2 | 101 | 181 | ABA28250.1 protease, partial [Human endogenous retrovirus K] | diamond | 972 | 106 | 1 | Viruses | Human endogenous retroviruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Human endogenous retrovirus K | ||
| 27749872 | 27749872 | PRJNA835051_S_NODE_82364_length_183_cov_0.792857_g82068_i0 | PRJNA835051 | 82364 | 183 | 0.792857 | 1.45092831 | Multiple sclerosis associated retrovirus | 62805 | Viruses | Viruses | 59.3 | 2.44e-8 | NR | AAB66528.1 | 62805 | g82068 | i0 | 59.6 | 0.852459016393443 | 52 | 21 | 85.2 | 0 | 25 | 180 | 81 | 132 | AAB66528.1 polyprotein, partial [Multiple sclerosis associated retrovirus] | diamond | 156 | 59.3 | 1 | Viruses | Human endogenous retroviruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Human endogenous retrovirus W | ||
| 28037155 | 28037155 | PRJNA981359_S_NODE_20425_length_359_cov_0.727273_g20325_i0 | PRJNA981359 | 20425 | 359 | 0.727273 | 2.61091007 | HERV-H/env6 | 57282 | Viruses | Viruses | 78.6 | 3.8e-14 | NR | CAB94193.2 | 129526 | g20325 | i0 | 43.7 | 0.994428969359331 | 119 | 67 | 99.4 | 0 | 357 | 1 | 366 | 484 | CAB94193.2 envelope protein [HERV-H/env60] | diamond | 357 | 78.6 | 1 | Viruses | Human endogenous retroviruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Human endogenous retrovirus H | ||
| 28515968 | 28515968 | PRJNA835051_S_NODE_24467_length_263_cov_2.372727_g24171_i0 | PRJNA835051 | 24467 | 263 | 2.372727 | 6.24027201 | root | 1 | Root_unresolved | Root_unresolved | 70.9 | 6.04e-12 | NR | CAA76882.1 | 45617 | g24171 | i0 | 39.1 | 5.97718631178707 | 87 | 53 | 99.2 | 0 | 261 | 1 | 329 | 415 | CAA76882.1 pol protein [Human endogenous retrovirus K] | diamond | 1572 | 70.9 | 1 | Viruses | Human endogenous retroviruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Human endogenous retrovirus K | ||
| 29286593 | 29286593 | PRJNA473799_P_NODE_35309_length_251_cov_0.865169_g35035_i0 | PRJNA473799 | 35309 | 251 | 0.865169 | 2.17157419 | Multiple sclerosis associated retrovirus element | 89382 | Viruses | Viruses | 47 | 1.33e-4 | NR | AAD48372.1 | 89382 | g35035 | i0 | 46 | 0.597609561752988 | 50 | 27 | 59.8 | 0 | 159 | 10 | 1 | 50 | AAD48372.1 unknown protein U5/1 [Multiple sclerosis associated retrovirus element] | diamond | 150 | 47 | 1 | Viruses | Human endogenous retroviruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Human endogenous retrovirus W | ||
| 29300022 | 29300022 | PRJNA981359_S_NODE_70229_length_246_cov_0.867052_g70129_i0 | PRJNA981359 | 70229 | 246 | 0.867052 | 2.13294792 | Human endogenous retrovirus K | 45617 | Viruses | Viruses | 75.5 | 1.01e-13 | NR | CAA71418.1 | 45617 | g70129 | i0 | 66.7 | 7.68292682926829 | 63 | 21 | 76.8 | 0 | 206 | 18 | 224 | 286 | CAA71418.1 gag protein, partial [Human endogenous retrovirus K] | diamond | 1890 | 75.5 | 1 | Viruses | Human endogenous retroviruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Human endogenous retrovirus K | ||
| 29442404 | 29442404 | PRJNA312615_P_NODE_32490_length_215_cov_0.861446_g32339_i0 | PRJNA312615 | 32490 | 215 | 0.861446 | 1.8521089 | Multiple sclerosis associated retrovirus element | 89382 | Viruses | Viruses | 41.6 | 0.00877 | NR | AAD48373.1 | 89382 | g32339 | i0 | 55.9 | 0.474418604651163 | 34 | 15 | 47.4 | 0 | 102 | 1 | 14 | 47 | AAD48373.1 unknown protein U5/2 [Multiple sclerosis associated retrovirus element] | diamond | 102 | 41.6 | 1 | Viruses | Human endogenous retroviruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Human endogenous retrovirus W | ||
| 30057779 | 30057779 | PRJNA981359_S_NODE_58631_length_264_cov_0.816754_g58531_i0 | PRJNA981359 | 58631 | 264 | 0.816754 | 2.15623056 | Human endogenous retrovirus HCML-ARV | 228277 | Viruses | Viruses | 90.5 | 7.99e-19 | NR | AAP06677.1 | 228277 | g58531 | i0 | 59.7 | 2.61363636363636 | 77 | 31 | 87.5 | 0 | 264 | 34 | 25 | 101 | AAP06677.1 pol protein [Human endogenous retrovirus HCML-ARV] | diamond | 690 | 91.3 | 0.991237677984666 | Viruses | Human endogenous retroviruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Human endogenous retrovirus | ||
| 31284102 | 31284102 | PRJNA706190_P_NODE_36575_length_182_cov_0.992481_g36439_i0 | PRJNA706190 | 36575 | 182 | 0.992481 | 1.80631542 | Human endogenous retrovirus K | 45617 | Viruses | Viruses | 72.4 | 1.11e-13 | NR | ABA28250.1 | 45617 | g36439 | i0 | 53.3 | 6.90659340659341 | 60 | 28 | 98.9 | 0 | 3 | 182 | 52 | 111 | ABA28250.1 protease, partial [Human endogenous retrovirus K] | diamond | 1257 | 72.8 | 0.994505494505495 | Viruses | Human endogenous retroviruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Human endogenous retrovirus K | ||
| 31382602 | 31382602 | PRJNA879221_P_NODE_54156_length_247_cov_0.885057_g54016_i0 | PRJNA879221 | 54156 | 247 | 0.885057 | 2.18609079 | Multiple sclerosis associated retrovirus | 62805 | Viruses | Viruses | 49.3 | 1.87e-4 | NR | AAB66528.1 | 62805 | g54016 | i0 | 61.5 | 0.983805668016194 | 39 | 15 | 47.4 | 0 | 239 | 123 | 299 | 337 | AAB66528.1 polyprotein, partial [Multiple sclerosis associated retrovirus] | diamond | 243 | 49.7 | 0.991951710261569 | Viruses | Human endogenous retroviruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Human endogenous retrovirus W |
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);;