contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA812001" and tax_phylum = "Kitrinoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 810394 | 810394 | PRJNA812001_P_NODE_14001_length_430_cov_5.156863_g13755_i0 | PRJNA812001 | 14001 | 430 | 5.156863 | 22.1745109 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 52.8 | 0.041 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g13755 | i0 | 100 | 0.0651162790697674 | 28 | 0 | 7 | 0 | 1 | 28 | 7 | 34 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 5914344 | 5914344 | PRJNA812001_P_NODE_72985_length_258_cov_1.248649_g72739_i0 | PRJNA812001 | 72985 | 258 | 1.248649 | 3.22151442 | Potexvirus cymbidii | 3433819 | Viruses | Viruses | 466 | 7.08e-127 | NTclustered | gi|90968201|emb|AM236036.1| | 12178 | g72739 | i0 | 99.225 | 11.2209302325581 | 258 | 2 | 100 | 0 | 1 | 258 | 283 | 26 | Cymbidium mosaic virus partial RdRp gene for RNA-dependent RNA polymerase, isolate FRA07, genomic RNA | blastn | 2895 | 466 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus cymbidii | ||
| 7189070 | 7189070 | PRJNA812001_P_NODE_61246_length_273_cov_4.155000_g61000_i0 | PRJNA812001 | 61246 | 273 | 4.155 | 11.34315 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 52.8 | 0.025 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g61000 | i0 | 100 | 0.102564102564103 | 28 | 0 | 10 | 0 | 246 | 273 | 34 | 7 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 9739082 | 9739082 | PRJNA812001_P_NODE_75668_length_254_cov_1.701657_g75422_i0 | PRJNA812001 | 75668 | 254 | 1.701657 | 4.32220878 | Potexvirus cymbidii | 3433819 | Viruses | Viruses | 459 | 1.1599999999999999e-124 | NTclustered | gi|939193298|gb|KR185347.1| | 12178 | g75422 | i0 | 99.213 | 28.9606299212598 | 254 | 2 | 100 | 0 | 1 | 254 | 4747 | 4494 | Cymbidium mosaic virus isolate China, complete genome | blastn | 7356 | 459 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus cymbidii | ||
| 9739161 | 9739161 | PRJNA812001_P_NODE_8_length_6187_cov_10.969905_g3_i0 | PRJNA812001 | 8 | 6187 | 10.969905 | 678.70802235 | Potexvirus cymbidii | 3433819 | Viruses | Viruses | 11326 | 0 | NTclustered | gi|1964785387|gb|MT833930.1| | 12178 | g3 | i0 | 99.709 | 35.9754323581704 | 6187 | 18 | 100 | 0 | 1 | 6187 | 6198 | 12 | Cymbidium mosaic virus isolate Chenshan, complete genome | blastn | 222580 | 11326 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus cymbidii | ||
| 21212741 | 21212741 | PRJNA812001_P_NODE_35277_length_321_cov_1.241935_g35031_i0 | PRJNA812001 | 35277 | 321 | 1.241935 | 3.98661135 | Potexvirus cymbidii | 3433819 | Viruses | Viruses | 593 | 3.9899999999999986e-165 | NTclustered | gi|284002549|dbj|AB541545.1| | 12178 | g35031 | i0 | 100 | 99.981308411215 | 321 | 0 | 100 | 0 | 1 | 321 | 441 | 121 | Cymbidium mosaic virus CP gene for coat protein, complete cds, strain: CYK12 | blastn | 32094 | 593 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus cymbidii | ||
| 23763142 | 23763142 | PRJNA812001_P_NODE_30719_length_333_cov_3.615385_g30473_i0 | PRJNA812001 | 30719 | 333 | 3.615385 | 12.03923205 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 60.2 | 1.88e-4 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g30473 | i0 | 97.222 | 0.198198198198198 | 36 | 0 | 11 | 1 | 1 | 35 | 8 | 43 | Carnation latent virus isolate KL, complete genome | blastn | 66 | 60.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi |
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);;