contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA816047" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25729743 | 25729743 | PRJNA816047a_S_NODE_44922_length_311_cov_83.554622_g42262_i0 | PRJNA816047 | 44922 | 311 | 83.554622 | 259.85487442 | Narnavirus sp. | 2587225 | Viruses | Viruses | 71.3 | 8.02e-8 | NTclustered | gi|2686256125|emb|OZ008436.1| | 2587225 | g42262 | i0 | 100 | 12.7138263665595 | 38 | 0 | 12 | 0 | 2 | 39 | 1111 | 1074 | Apocryptovirus menelaus Segment 2, partial CDS | blastn | 3954 | 71.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Narnavirus sp. | ||
| 25768756 | 25768756 | PRJNA816047a_S_NODE_23170_length_422_cov_70.776504_g20516_i0 | PRJNA816047 | 23170 | 422 | 70.776504 | 298.67684688 | Orthornavirae | 2732396 | Viruses | Viruses | 71.3 | 1.12e-7 | NTclustered | gi|2686256125|emb|OZ008436.1| | 2587225 | g20516 | i0 | 100 | 9.33649289099526 | 38 | 0 | 9 | 0 | 4 | 41 | 1111 | 1074 | Apocryptovirus menelaus Segment 2, partial CDS | blastn | 3940 | 71.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Narnavirus sp. | ||
| 26415442 | 26415442 | PRJNA816047b_S_NODE_39999_length_270_cov_1.081218_g37687_i0 | PRJNA816047 | 39999 | 270 | 1.081218 | 2.9192886 | Narnavirus sp. | 2587225 | Viruses | Viruses | 62.1 | 4.11e-5 | NTclustered | gi|2686256125|emb|OZ008436.1| | 2587225 | g37687 | i0 | 100 | 12.3148148148148 | 33 | 0 | 12 | 0 | 1 | 33 | 1106 | 1074 | Apocryptovirus menelaus Segment 2, partial CDS | blastn | 3325 | 62.1 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Narnavirus sp. | ||
| 26422290 | 26422290 | PRJNA816047d_S_NODE_74559_length_267_cov_7026.439252_g72724_i0 | PRJNA816047 | 74559 | 267 | 7026.439252 | 18760.59280284 | StochSRVP_11 levi-like virus | 3038628 | Viruses | Viruses | 75 | 5.21e-9 | NTclustered | gi|2484124043|gb|OQ722337.1| | 3038628 | g72724 | i0 | 97.674 | 16.5692883895131 | 43 | 1 | 16 | 0 | 193 | 235 | 70 | 112 | MAG: StochSRVP_11 levi-like virus isolate SRVP22_05, partial genome | blastn | 4424 | 75 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | StochSRVP_11 levi-like virus |
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);;