contig_metadata
12 rows where bioproject = "PRJNA1011844" and tax_phylum = "Preplasmiviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6534706 | 6534706 | PRJNA1011844_P_NODE_171566_length_226_cov_3.777778_g162985_i0 | PRJNA1011844 | 171566 | 226 | 3.777778 | 8.53777828 | Aviadenovirus hydropericardii | 3250174 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1779935074|gb|MK572850.1| | 190063 | g162985 | i0 | 97.059 | 0.150442477876106 | 34 | 0 | 15 | 1 | 130 | 163 | 44016 | 43984 | Fowl aviadenovirus C strain INT4-ATTENUATED-AG234 | blastn | 34 | 56.5 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Aviadenovirus | Aviadenovirus hydropericardii | ||
| 11205366 | 11205366 | PRJNA1011844_P_NODE_173149_length_221_cov_9.297297_g164568_i0 | PRJNA1011844 | 173149 | 221 | 9.297297 | 20.54702637 | root | 1 | Root_unresolved | Root_unresolved | 374 | 3.68e-99 | NTclustered | gi|313361|emb|X73487.1| | 28282 | g164568 | i0 | 100 | 17.3619909502262 | 202 | 0 | 91 | 0 | 12 | 213 | 30915 | 31116 | Adenovirus type 12 DNA, complete genome | blastn | 3837 | 374 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus adami | ||
| 27666734 | 27666734 | PRJNA1011844_P_NODE_106264_length_310_cov_3.704641_g97691_i0 | PRJNA1011844 | 106264 | 310 | 3.704641 | 11.4843871 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 62 | 7.34e-9 | NR | DBA50496.1 | 3115894 | g97691 | i0 | 43.4 | 1.09354838709677 | 113 | 47 | 92.9 | 2 | 299 | 12 | 54 | 166 | DBA50496.1 MAG TPA_asm: Adintoc2 [Adintovirus bos4377] | diamond | 339 | 62 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 28014182 | 28014182 | PRJNA1011844_P_NODE_66165_length_479_cov_2.568966_g57734_i0 | PRJNA1011844 | 66165 | 479 | 2.568966 | 12.30534714 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 52 | 1.71e-4 | NR | DAC81404.1 | 2609864 | g57734 | i0 | 29 | 1.87265135699374 | 100 | 70 | 62 | 1 | 109 | 405 | 25 | 124 | DAC81404.1 TPA_asm: hypothetical protein [Pimephales minnow adintovirus] | diamond | 897 | 52 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 29403170 | 29403170 | PRJNA1011844_P_NODE_147689_length_250_cov_0.870056_g139110_i0 | PRJNA1011844 | 147689 | 250 | 0.870056 | 2.17514 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 85.9 | 1.41e-17 | NR | DAC81401.1 | 2609864 | g139110 | i0 | 56.6 | 2.736 | 76 | 33 | 91.2 | 0 | 20 | 247 | 74 | 149 | DAC81401.1 TPA_asm: integrase [Pimephales minnow adintovirus] | diamond | 684 | 86.7 | 0.990772779700115 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 30508669 | 30508669 | PRJNA1011844_P_NODE_123673_length_278_cov_2.278049_g115096_i0 | PRJNA1011844 | 123673 | 278 | 2.278049 | 6.33297622 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 86.3 | 1.45e-17 | NR | DAC81401.1 | 2609864 | g115096 | i0 | 53 | 2.68705035971223 | 83 | 39 | 89.6 | 0 | 26 | 274 | 1 | 83 | DAC81401.1 TPA_asm: integrase [Pimephales minnow adintovirus] | diamond | 747 | 86.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 31077512 | 31077512 | PRJNA1011844_P_NODE_121595_length_281_cov_1.971154_g113018_i0 | PRJNA1011844 | 121595 | 281 | 1.971154 | 5.53894274 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 71.2 | 1.5e-12 | NR | DAC81394.1 | 2609864 | g113018 | i0 | 54.8 | 0.779359430604982 | 73 | 33 | 77.9 | 0 | 225 | 7 | 7 | 79 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 219 | 71.2 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 31330235 | 31330235 | PRJNA1011844_P_NODE_148736_length_249_cov_1.431818_g140157_i0 | PRJNA1011844 | 148736 | 249 | 1.431818 | 3.56522682 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 75.1 | 2.67e-15 | NR | DAC81395.1 | 2609864 | g140157 | i0 | 50.6 | 0.951807228915663 | 79 | 39 | 95.2 | 0 | 7 | 243 | 5 | 83 | DAC81395.1 TPA_asm: gasderminX [Pimephales minnow adintovirus] | diamond | 237 | 75.1 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 31393750 | 31393750 | PRJNA1011844_P_NODE_154416_length_245_cov_2.232558_g145836_i0 | PRJNA1011844 | 154416 | 245 | 2.232558 | 5.4697671 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 63.9 | 7.9e-10 | NR | DAC81396.1 | 2609864 | g145836 | i0 | 45.7 | 1.71428571428571 | 70 | 38 | 85.7 | 0 | 34 | 243 | 1 | 70 | DAC81396.1 TPA_asm: acintoc2 [Pimephales minnow adintovirus] | diamond | 420 | 63.9 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 31773001 | 31773001 | PRJNA1011844_P_NODE_119137_length_285_cov_1.259434_g110560_i0 | PRJNA1011844 | 119137 | 285 | 1.259434 | 3.5893869 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 54.3 | 5.54e-7 | NR | DAC81395.1 | 2609864 | g110560 | i0 | 51 | 0.515789473684211 | 49 | 24 | 51.6 | 0 | 256 | 110 | 60 | 108 | DAC81395.1 TPA_asm: gasderminX [Pimephales minnow adintovirus] | diamond | 147 | 54.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 32216126 | 32216126 | PRJNA1011844_P_NODE_127958_length_272_cov_2.427136_g119380_i0 | PRJNA1011844 | 127958 | 272 | 2.427136 | 6.60180992 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 86.7 | 1.78e-18 | NR | DAC81394.1 | 2609864 | g119380 | i0 | 52.9 | 1.86397058823529 | 85 | 40 | 93.8 | 0 | 13 | 267 | 89 | 173 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 507 | 87.4 | 0.991990846681922 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 32753041 | 32753041 | PRJNA1011844_P_NODE_134740_length_263_cov_4.915789_g126162_i0 | PRJNA1011844 | 134740 | 263 | 4.915789 | 12.92852507 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 78.2 | 2.79e-15 | NR | DAC81394.1 | 2609864 | g126162 | i0 | 51.2 | 1.95057034220532 | 84 | 41 | 95.8 | 0 | 10 | 261 | 91 | 174 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 513 | 78.6 | 0.994910941475827 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus |
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);;