contig_metadata
3 rows where analysis = "diamond", bioproject = "PRJNA734348" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9645839 | 9645839 | PRJNA734348_P_NODE_136048_length_238_cov_2.896970_g135350_i0 | PRJNA734348 | 136048 | 238 | 2.89697 | 6.8947886 | Mitovirus sp. | 2587224 | Viruses | Viruses | 78.6 | 6.78e-15 | NR | QDH87999.1 | 2587224 | g135350 | i0 | 62.5 | 2.50840336134454 | 64 | 23 | 80.7 | 1 | 47 | 238 | 12 | 74 | QDH87999.1 MAG: RNA-dependent RNA polymerase, partial [Mitovirus sp.] | diamond | 597 | 78.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 12197481 | 12197481 | PRJNA734348_P_NODE_37830_length_318_cov_1.208163_g37134_i0 | PRJNA734348 | 37830 | 318 | 1.208163 | 3.84195834 | Leviviridae sp. | 2027243 | Viruses | Viruses | 94.4 | 6.7e-20 | NR | WNK16400.1 | 2027243 | g37134 | i0 | 51.5 | 0.971698113207547 | 103 | 48 | 97.2 | 1 | 316 | 8 | 126 | 226 | WNK16400.1 MAG: putative replicase protein [Leviviridae sp.] | diamond | 309 | 94.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 29809791 | 29809791 | PRJNA734348_P_NODE_46311_length_296_cov_3.403587_g45614_i0 | PRJNA734348 | 46311 | 296 | 3.403587 | 10.07461752 | Mihkrovirus | 2842867 | Viruses | Viruses | 80.1 | 6.9e-17 | NR | QDH88675.1 | 2027243 | g45614 | i0 | 49.4 | 1.69256756756757 | 87 | 44 | 88.2 | 0 | 2 | 262 | 31 | 117 | QDH88675.1 MAG: hypothetical protein H1Bulk304066_000002 [Leviviridae sp.] | diamond | 501 | 80.9 | 0.990111248454882 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae 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);;