contig_metadata
3 rows where bioproject = "PRJNA382357", tax_kingdom = "Orthornavirae" and tax_phylum = "Negarnaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 31040169 | 31040169 | PRJNA382357_P_NODE_113195_length_229_cov_1.547619_g112456_i0 | PRJNA382357 | 113195 | 229 | 1.547619 | 3.54404751 | Chuvivirus | 2842604 | Viruses | Viruses | 82.4 | 3.12e-16 | NR | WET19887.1 | 2842604 | g112456 | i0 | 69.6 | 1.46724890829694 | 56 | 17 | 73.4 | 0 | 2 | 169 | 312 | 367 | WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1] | diamond | 336 | 82.4 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Chuvivirus | ||
| 31908400 | 31908400 | PRJNA382357_P_NODE_39277_length_365_cov_5.631579_g38538_i0 | PRJNA382357 | 39277 | 365 | 5.631579 | 20.55526335 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 98.2 | 5.91e-21 | NR | WLN26256.1 | 3065075 | g38538 | i0 | 50.5 | 0.747945205479452 | 91 | 45 | 74.8 | 0 | 14 | 286 | 142 | 232 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 273 | 98.2 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 32730329 | 32730329 | PRJNA382357_P_NODE_34200_length_388_cov_3.247706_g33461_i0 | PRJNA382357 | 34200 | 388 | 3.247706 | 12.60109928 | Salarius guttatus piscichuvirus | 2951531 | Viruses | Viruses | 56.6 | 2.81e-6 | NR | YP_010840939.1 | 2951531 | g33461 | i0 | 48.5 | 0.510309278350515 | 66 | 33 | 50.3 | 1 | 11 | 205 | 14 | 79 | YP_010840939.1 L protein [Hardyhead chuvirus] | diamond | 198 | 56.6 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | Salarius guttatus piscichuvirus |
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);;