contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA889065" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 863304 | 863304 | PRJNA889065_S_NODE_13241_length_265_cov_2.518018_g13003_i0 | PRJNA889065 | 13241 | 265 | 2.518018 | 6.6727477 | Betaentomopoxvirus amoorei | 28321 | Viruses | Viruses | 52.8 | 0.024 | NTclustered | gi|9964314|ref|NC_002520.1| | 28321 | g13003 | i0 | 94.286 | 0.132075471698113 | 35 | 1 | 13 | 1 | 149 | 182 | 153509 | 153475 | Amsacta moorei entomopoxvirus 'L', complete genome | blastn | 35 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Betaentomopoxvirus | Betaentomopoxvirus amoorei | ||
| 2138831 | 2138831 | PRJNA889065_S_NODE_30582_length_174_cov_1.755725_g30344_i0 | PRJNA889065 | 30582 | 174 | 1.755725 | 3.0549615 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 274 | 2.87e-69 | NTclustered | gi|1624806771|gb|MK638752.1| | 1543320 | g30344 | i0 | 98.089 | 0.902298850574713 | 157 | 3 | 90 | 0 | 18 | 174 | 1 | 157 | Erythrocytic necrosis virus isolate SEQ_55 hypothetical protein mRNA, partial cds | blastn | 157 | 274 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 3414094 | 3414094 | PRJNA889065_S_NODE_16343_length_240_cov_2.568528_g16105_i0 | PRJNA889065 | 16343 | 240 | 2.568528 | 6.1644672 | Mimivirus sp. | 2742700 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2770799496|gb|PQ010613.1| | 2742700 | g16105 | i0 | 97.059 | 0.141666666666667 | 34 | 0 | 14 | 1 | 170 | 203 | 849630 | 849598 | Mimivirus sp. isolate 2401, partial genome | blastn | 34 | 56.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus | Mimivirus sp. | ||
| 9791300 | 9791300 | PRJNA889065_S_NODE_28168_length_182_cov_1.985612_g27930_i0 | PRJNA889065 | 28168 | 182 | 1.985612 | 3.61381384 | Moumouvirus sp. 'Monve' | 1128131 | Viruses | Viruses | 52.8 | 0.015 | NTclustered | gi|371944392|gb|JN885995.1| | 1128131 | g27930 | i0 | 96.774 | 0.17032967032967 | 31 | 1 | 17 | 0 | 46 | 76 | 10039 | 10009 | Moumouvirus Monve isolate Mv13-mv, partial genome | blastn | 31 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Moumouvirus | Moumouvirus sp. 'Monve' |
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);;