contig_metadata
4 rows where analysis = "diamond", bioproject = "PRJNA911178" and tax_phylum = "Lenarviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26675951 | 26675951 | PRJNA911178_P_NODE_153961_length_301_cov_2.057018_g151488_i0 | PRJNA911178 | 153961 | 301 | 2.057018 | 6.19162418 | Oidiodendron maius splipalmivirus 1 | 2769353 | Viruses | Viruses | 45.1 | 0.0115 | NR | QNN89179.1 | 2769353 | g151488 | i0 | 45.5 | 0.438538205980066 | 44 | 23 | 43.9 | 1 | 300 | 169 | 706 | 748 | QNN89179.1 putative RNA dependent RNA polymerase [Oidiodendron maius splipalmivirus 1] | diamond | 132 | 45.1 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Delepalmivirus | Delepalmivirus oidiodendri | ||
| 27656514 | 27656514 | PRJNA911178_P_NODE_222344_length_260_cov_1.176471_g219870_i0 | PRJNA911178 | 222344 | 260 | 1.176471 | 3.0588246 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 85.5 | 1.72e-17 | NR | URG16567.1 | 2809572 | g219870 | i0 | 51.2 | 2.91923076923077 | 82 | 36 | 94.6 | 1 | 256 | 11 | 172 | 249 | URG16567.1 MAG: RNA dependent RNA polymerase, partial [Mitoviridae sp.] | diamond | 759 | 85.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 28729928 | 28729928 | PRJNA911178_P_NODE_85967_length_385_cov_1.708333_g83499_i0 | PRJNA911178 | 85967 | 385 | 1.708333 | 6.57708205 | Mbeech associated narna-like virus 34 | 3066960 | Viruses | Viruses | 144 | 9.57e-39 | NR | WPR17352.1 | 3066960 | g83499 | i0 | 52.8 | 0.958441558441558 | 123 | 58 | 95.8 | 0 | 376 | 8 | 92 | 214 | WPR17352.1 MAG: RNA-dependent RNA polymerase, partial [Mbeech associated narna-like virus 34] | diamond | 369 | 144 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Mbeech associated narna-like virus 34 | |||
| 30940911 | 30940911 | PRJNA911178_P_NODE_141574_length_312_cov_1.857741_g139101_i0 | PRJNA911178 | 141574 | 312 | 1.857741 | 5.79615192 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 56.6 | 1.1e-6 | NR | UJQ92506.1 | 2809572 | g139101 | i0 | 39 | 0.740384615384615 | 77 | 46 | 74 | 1 | 287 | 57 | 399 | 474 | UJQ92506.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.] | diamond | 231 | 56.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae 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);;