contig_metadata
4 rows where bioproject = "PRJNA1200128" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26692668 | 26692668 | PRJNA1200128_S_NODE_28921_length_181_cov_1.021739_g28812_i0 | PRJNA1200128 | 28921 | 181 | 1.021739 | 1.84934759 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 71.2 | 2e-14 | NR | QCF47502.1 | 1543320 | g28812 | i0 | 82.1 | 1.50828729281768 | 39 | 7 | 64.6 | 0 | 46 | 162 | 43 | 81 | QCF47502.1 hypothetical protein, partial [Erythrocytic necrosis virus] | diamond | 273 | 71.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 28683350 | 28683350 | PRJNA1200128_S_NODE_39847_length_162_cov_1.403361_g39738_i0 | PRJNA1200128 | 39847 | 162 | 1.403361 | 2.27344482 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 41.6 | 0.0114 | NR | QCF47486.1 | 1543320 | g39738 | i0 | 71 | 1.14814814814815 | 31 | 8 | 57.4 | 1 | 2 | 94 | 55 | 84 | QCF47486.1 putative RNA-dependent DNA polymerase, partial [Erythrocytic necrosis virus] | diamond | 186 | 42 | 0.990476190476191 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 29030711 | 29030711 | PRJNA1200128_S_NODE_14008_length_227_cov_1.532609_g13899_i0 | PRJNA1200128 | 14008 | 227 | 1.532609 | 3.47902243 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 42 | 0.0266 | NR | QCF47477.1 | 1543320 | g13899 | i0 | 66.7 | 0.713656387665198 | 27 | 9 | 35.7 | 0 | 227 | 147 | 102 | 128 | QCF47477.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus] | diamond | 162 | 42 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 32885052 | 32885052 | PRJNA1200128_S_NODE_22740_length_196_cov_1.176471_g22631_i0 | PRJNA1200128 | 22740 | 196 | 1.176471 | 2.30588316 | Adintovirus anguilla10665 | 3115889 | Viruses | Viruses | 95.9 | 2.7e-23 | NR | DBA49781.1 | 3115889 | g22631 | i0 | 67.2 | 1.95918367346939 | 64 | 21 | 98 | 0 | 192 | 1 | 7 | 70 | DBA49781.1 MAG TPA_asm: Cupiennin [Adintovirus anguilla10665] | diamond | 384 | 95.9 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus anguilla10665 |
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);;