contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA846110" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4661487 | 4661487 | PRJNA846110_P_NODE_23744_length_249_cov_3.159091_g23499_i0 | PRJNA846110 | 23744 | 249 | 3.159091 | 7.86613659 | Orthophasmavirus wuchangense | 3052553 | Viruses | Viruses | 438 | 1.4799999999999996e-118 | NTclustered | gi|1070619511|ref|NC_031293.1| | 1608097 | g23499 | i0 | 98.394 | 1 | 249 | 4 | 100 | 0 | 1 | 249 | 4796 | 5044 | Wuchang Cockraoch Virus 1 strain WCZL-5 RNA-dependent RNA polymerase (L) gene, complete cds | blastn | 249 | 438 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Phasmaviridae | Orthophasmavirus | Orthophasmavirus wuchangense | ||
| 7211228 | 7211228 | PRJNA846110_P_NODE_26746_length_245_cov_3.802326_g26501_i0 | PRJNA846110 | 26746 | 245 | 3.802326 | 9.3156987 | Orthophasmavirus wuchangense | 3052553 | Viruses | Viruses | 442 | 1.1199999999999994e-119 | NTclustered | gi|1070619511|ref|NC_031293.1| | 1608097 | g26501 | i0 | 99.184 | 1 | 245 | 2 | 100 | 0 | 1 | 245 | 5576 | 5332 | Wuchang Cockraoch Virus 1 strain WCZL-5 RNA-dependent RNA polymerase (L) gene, complete cds | blastn | 245 | 442 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Phasmaviridae | Orthophasmavirus | Orthophasmavirus wuchangense | ||
| 8485767 | 8485767 | PRJNA846110_P_NODE_10867_length_328_cov_2.333333_g10622_i0 | PRJNA846110 | 10867 | 328 | 2.333333 | 7.65333224 | Orthophasmavirus wuchangense | 3052553 | Viruses | Viruses | 595 | 1.1399999999999998e-165 | NTclustered | gi|1070619511|ref|NC_031293.1| | 1608097 | g10622 | i0 | 99.39 | 1.98170731707317 | 328 | 2 | 100 | 0 | 1 | 328 | 4301 | 3974 | Wuchang Cockraoch Virus 1 strain WCZL-5 RNA-dependent RNA polymerase (L) gene, complete cds | blastn | 650 | 595 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Phasmaviridae | Orthophasmavirus | Orthophasmavirus wuchangense |
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);;