contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA940501" and tax_kingdom = "Bamfordvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8575204 | 8575204 | PRJNA940501_S_NODE_95487_length_241_cov_1.595960_g94669_i0 | PRJNA940501 | 95487 | 241 | 1.59596 | 3.8462636 | Edafosvirus sp. | 2487765 | Viruses | Viruses | 111 | 1.02e-26 | NR | AYV78014.1 | 2487765 | g94669 | i0 | 63.8 | 1.9792531120332 | 80 | 29 | 99.6 | 0 | 240 | 1 | 371 | 450 | AYV78014.1 MAG: elongation factor 1 alpha long form [Edafosvirus sp.] | diamond | 477 | 111 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Edafosvirus sp. | |||
| 26771976 | 26771976 | PRJNA940501_S_NODE_107261_length_233_cov_1.968421_g106443_i0 | PRJNA940501 | 107261 | 233 | 1.968421 | 4.58642093 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 88.2 | 2.91e-18 | NR | YP_010782467.1 | 2126985 | g106443 | i0 | 65.7 | 0.862660944206009 | 67 | 22 | 86.3 | 1 | 216 | 16 | 422 | 487 | YP_010782467.1 hypothetical protein QJ857_gp0240 [Tupanvirus soda lake] | diamond | 201 | 88.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 27689060 | 27689060 | PRJNA940501_S_NODE_7024_length_557_cov_21.217899_g6313_i0 | PRJNA940501 | 7024 | 557 | 21.217899 | 118.18369743 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 107 | 5.77e-25 | NR | YP_010782214.1 | 2126985 | g6313 | i0 | 43.7 | 0.727109515260323 | 135 | 61 | 72.2 | 5 | 556 | 155 | 76 | 196 | YP_010782214.1 exonuclease [Tupanvirus soda lake] | diamond | 405 | 107 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 28004625 | 28004625 | PRJNA940501_S_NODE_2745_length_1385_cov_8.323398_g2533_i0 | PRJNA940501 | 2745 | 1385 | 8.323398 | 115.2790623 | Bodo saltans virus | 2024608 | Viruses | Viruses | 229 | 2.38e-69 | NR | YP_010778932.1 | 2024608 | g2533 | i0 | 70.9 | 0.327075812274368 | 151 | 44 | 32.7 | 0 | 28 | 480 | 37 | 187 | YP_010778932.1 N6-adenine methyltransferase [Bodo saltans virus] | diamond | 453 | 229 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Theiavirus | Theiavirus salishense | ||
| 28793545 | 28793545 | PRJNA940501_S_NODE_185067_length_198_cov_1.212903_g184249_i0 | PRJNA940501 | 185067 | 198 | 1.212903 | 2.40154794 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 68.6 | 1.37e-11 | NR | DAC81401.1 | 2609864 | g184249 | i0 | 53.1 | 2.90909090909091 | 64 | 30 | 97 | 0 | 5 | 196 | 98 | 161 | DAC81401.1 TPA_asm: integrase [Pimephales minnow adintovirus] | diamond | 576 | 68.6 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 29488175 | 29488175 | PRJNA940501_S_NODE_77610_length_255_cov_1.108491_g76792_i0 | PRJNA940501 | 77610 | 255 | 1.108491 | 2.82665205 | Hyperionvirus sp. | 2487770 | Viruses | Viruses | 63.2 | 2.86e-9 | NR | AYV84279.1 | 2487770 | g76792 | i0 | 43.4 | 0.894117647058824 | 76 | 41 | 89.4 | 1 | 4 | 231 | 95 | 168 | AYV84279.1 MAG: endonuclease/exonuclease/phosphatase family [Hyperionvirus sp.] | diamond | 228 | 63.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hyperionvirus sp. | |||
| 29677433 | 29677433 | PRJNA940501_S_NODE_312890_length_164_cov_19.289256_g312072_i0 | PRJNA940501 | 312890 | 164 | 19.289256 | 31.63437984 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 58.2 | 2.71e-8 | NR | DAC81394.1 | 2609864 | g312072 | i0 | 69.4 | 0.658536585365854 | 36 | 11 | 65.9 | 0 | 108 | 1 | 7 | 42 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 108 | 58.2 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 29835610 | 29835610 | PRJNA940501_S_NODE_291731_length_169_cov_1.277778_g290913_i0 | PRJNA940501 | 291731 | 169 | 1.277778 | 2.15944482 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 76.3 | 6.55e-16 | NR | QCF47477.1 | 1543320 | g290913 | i0 | 68 | 1.77514792899408 | 50 | 16 | 88.8 | 0 | 2 | 151 | 89 | 138 | QCF47477.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus] | diamond | 300 | 76.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 30316947 | 30316947 | PRJNA940501_S_NODE_17572_length_378_cov_3.865672_g16755_i0 | PRJNA940501 | 17572 | 378 | 3.865672 | 14.61224016 | Tupanvirus | 2094720 | Viruses | Viruses | 121 | 1.83e-30 | NR | YP_010781083.1 | 2126984 | g16755 | i0 | 55.9 | 1.63492063492063 | 102 | 44 | 81 | 1 | 362 | 57 | 223 | 323 | YP_010781083.1 hypothetical protein QJ856_gp0282 [Tupanvirus deep ocean] | diamond | 618 | 122 | 0.991803278688525 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus altamarinense | ||
| 30751979 | 30751979 | PRJNA940501_S_NODE_213154_length_189_cov_1.287671_g212336_i0 | PRJNA940501 | 213154 | 189 | 1.287671 | 2.43369819 | Hyperionvirus sp. | 2487770 | Viruses | Viruses | 72.4 | 5.81e-14 | NR | AYV84438.1 | 2487770 | g212336 | i0 | 53.4 | 0.920634920634921 | 58 | 27 | 92.1 | 0 | 184 | 11 | 11 | 68 | AYV84438.1 MAG: hypothetical protein Hyperionvirus25_24 [Hyperionvirus sp.] | diamond | 174 | 72.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hyperionvirus sp. | |||
| 31036592 | 31036592 | PRJNA940501_S_NODE_7015_length_558_cov_4.219417_g6304_i0 | PRJNA940501 | 7015 | 558 | 4.219417 | 23.54434686 | Hyperionvirus sp. | 2487770 | Viruses | Viruses | 91.7 | 1.01e-18 | NR | AYV83005.1 | 2487770 | g6304 | i0 | 44.7 | 0.553763440860215 | 103 | 54 | 54.8 | 2 | 1 | 306 | 159 | 259 | AYV83005.1 MAG: YchF/TatD family DNA exonuclease [Hyperionvirus sp.] | diamond | 309 | 91.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hyperionvirus sp. | |||
| 31384161 | 31384161 | PRJNA940501_S_NODE_8736_length_498_cov_3.017582_g7958_i0 | PRJNA940501 | 8736 | 498 | 3.017582 | 15.02755836 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 91.7 | 1.5e-18 | NR | AYV75160.1 | 2487775 | g7958 | i0 | 38 | 0.728915662650602 | 121 | 64 | 72.3 | 2 | 494 | 135 | 229 | 339 | AYV75160.1 MAG: hypothetical protein Terrestrivirus1_34 [Terrestrivirus sp.] | diamond | 363 | 91.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 31479087 | 31479087 | PRJNA940501_S_NODE_25916_length_337_cov_5.982993_g25098_i0 | PRJNA940501 | 25916 | 337 | 5.982993 | 20.16268641 | Marseillevirus LCMAC1 | 2506602 | Viruses | Viruses | 47 | 0.00285 | NR | QBK85868.1 | 2506602 | g25098 | i0 | 40 | 1.01483679525223 | 60 | 32 | 53.4 | 2 | 6 | 185 | 106 | 161 | QBK85868.1 MAG: hypothetical protein LCMAC101_04630 [Marseillevirus LCMAC101] | diamond | 342 | 47 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Marseilleviridae | Marseillevirus LCMAC101 | |||
| 31573942 | 31573942 | PRJNA940501_S_NODE_185716_length_198_cov_0.909677_g184898_i0 | PRJNA940501 | 185716 | 198 | 0.909677 | 1.80116046 | Larimichthys croaker adintovirus | 2609857 | Viruses | Viruses | 53.1 | 4.17e-6 | NR | DBA47690.1 | 2609857 | g184898 | i0 | 59.5 | 2.5 | 37 | 12 | 51.5 | 1 | 107 | 6 | 276 | 312 | DBA47690.1 MAG TPA_asm: Integrase [Adintovirus homo13306] | diamond | 495 | 53.1 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Larimichthys croaker adintovirus | |||
| 32466770 | 32466770 | PRJNA940501_S_NODE_43779_length_294_cov_4.505976_g42961_i0 | PRJNA940501 | 43779 | 294 | 4.505976 | 13.24756944 | Tupanvirus | 2094720 | Viruses | Viruses | 97.1 | 1.14e-21 | NR | YP_010781083.1 | 2126984 | g42961 | i0 | 56.6 | 1.69387755102041 | 83 | 35 | 84.7 | 1 | 294 | 46 | 242 | 323 | YP_010781083.1 hypothetical protein QJ856_gp0282 [Tupanvirus deep ocean] | diamond | 498 | 97.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus altamarinense | ||
| 32617591 | 32617591 | PRJNA940501_S_NODE_399740_length_150_cov_1.056075_g398922_i0 | PRJNA940501 | 399740 | 150 | 1.056075 | 1.5841125 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 95.9 | 4.83e-24 | NR | QCF47486.1 | 1543320 | g398922 | i0 | 92 | 2 | 50 | 4 | 100 | 0 | 1 | 150 | 50 | 99 | QCF47486.1 putative RNA-dependent DNA polymerase, partial [Erythrocytic necrosis virus] | diamond | 300 | 95.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 32711988 | 32711988 | PRJNA940501_S_NODE_230700_length_184_cov_1.007092_g229882_i0 | PRJNA940501 | 230700 | 184 | 1.007092 | 1.85304928 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 58.9 | 4.74e-9 | NR | QCF47477.1 | 1543320 | g229882 | i0 | 74.3 | 1.14130434782609 | 35 | 9 | 57.1 | 0 | 159 | 55 | 89 | 123 | QCF47477.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus] | diamond | 210 | 58.9 | 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);;