contig_metadata
6 rows where bioproject = "PRJNA1215813" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29112647 | 29112647 | PRJNA1215813_P_NODE_4388_length_366_cov_1.064846_g4308_i0 | PRJNA1215813 | 4388 | 366 | 1.064846 | 3.89733636 | Avipoxvirus | 10260 | Viruses | Viruses | 58.5 | 4.26e-7 | NR | WWM22175.1 | 1928336 | g4308 | i0 | 40 | 1.9672131147541 | 60 | 36 | 49.2 | 0 | 348 | 169 | 4 | 63 | WWM22175.1 MAG: ankyrin repeat family protein [Avipoxvirus sp.] | diamond | 720 | 58.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Avipoxvirus | Avipoxvirus sp. | ||
| 29472363 | 29472363 | PRJNA1215813_P_NODE_6770_length_301_cov_1.368421_g6690_i0 | PRJNA1215813 | 6770 | 301 | 1.368421 | 4.11894721 | Tupanvirus deep ocean | 2126984 | Viruses | Viruses | 53.9 | 3.42e-6 | NR | YP_010781270.1 | 2126984 | g6690 | i0 | 41.7 | 0.478405315614618 | 48 | 28 | 47.8 | 0 | 48 | 191 | 10 | 57 | YP_010781270.1 putative ORFan [Tupanvirus deep ocean] | diamond | 144 | 53.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus altamarinense | ||
| 30072608 | 30072608 | PRJNA1215813_P_NODE_9632_length_252_cov_0.871508_g9552_i0 | PRJNA1215813 | 9632 | 252 | 0.871508 | 2.19620016 | Harvfovirus sp. | 2487768 | Viruses | Viruses | 64.7 | 6.31e-10 | NR | AYV81699.1 | 2487768 | g9552 | i0 | 52.1 | 1.80952380952381 | 48 | 23 | 57.1 | 0 | 89 | 232 | 286 | 333 | AYV81699.1 MAG: hypothetical protein Harvfovirus53_9 [Harvfovirus sp.] | diamond | 456 | 64.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Harvfovirus sp. | |||
| 30326004 | 30326004 | PRJNA1215813_P_NODE_12092_length_243_cov_1.011765_g12012_i0 | PRJNA1215813 | 12092 | 243 | 1.011765 | 2.45858895 | Barrevirus sp. | 2487763 | Viruses | Viruses | 48.5 | 2.48e-4 | NR | AYV77273.1 | 2487763 | g12012 | i0 | 33.3 | 0.925925925925926 | 75 | 48 | 92.6 | 1 | 232 | 8 | 37 | 109 | AYV77273.1 MAG: START domain containing protein [Barrevirus sp.] | diamond | 225 | 48.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Barrevirus sp. | |||
| 32633168 | 32633168 | PRJNA1215813_P_NODE_920_length_744_cov_3.295082_g850_i0 | PRJNA1215813 | 920 | 744 | 3.295082 | 24.51541008 | Barrevirus sp. | 2487763 | Viruses | Viruses | 99 | 3.76e-21 | NR | AYV77273.1 | 2487763 | g850 | i0 | 28.2 | 0.870967741935484 | 216 | 148 | 86.3 | 5 | 703 | 62 | 10 | 220 | AYV77273.1 MAG: START domain containing protein [Barrevirus sp.] | diamond | 648 | 99 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Barrevirus sp. | |||
| 32696285 | 32696285 | PRJNA1215813_P_NODE_980_length_724_cov_3.218126_g907_i0 | PRJNA1215813 | 980 | 724 | 3.218126 | 23.29923224 | Barrevirus sp. | 2487763 | Viruses | Viruses | 111 | 6.48e-26 | NR | AYV77273.1 | 2487763 | g907 | i0 | 28 | 0.874309392265193 | 211 | 148 | 86.2 | 2 | 709 | 86 | 11 | 220 | AYV77273.1 MAG: START domain containing protein [Barrevirus sp.] | diamond | 633 | 111 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Barrevirus sp. |
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);;