contig_metadata
3 rows where bioproject = "PRJNA1248424", tax_phylum = "Kitrinoviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1627809 | 1627809 | PRJNA1248424_P_NODE_63902_length_265_cov_1.203125_g57833_i0 | PRJNA1248424 | 63902 | 265 | 1.203125 | 3.18828125 | Potexvirus citriflavivenae | 3433772 | Viruses | Viruses | 484 | 2.0199999999999998e-132 | NTclustered | gi|764160352|ref|NC_026592.1| | 1214459 | g57833 | i0 | 99.623 | 82 | 265 | 1 | 100 | 0 | 1 | 265 | 4890 | 4626 | Citrus yellow vein clearing virus isolate CQ, complete genome | blastn | 21730 | 484 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus citriflavivenae | ||
| 5456772 | 5456772 | PRJNA1248424_P_NODE_78865_length_242_cov_0.911243_g72796_i0 | PRJNA1248424 | 78865 | 242 | 0.911243 | 2.20520806 | Carlavirus unipseudostellariae | 3427802 | Viruses | Viruses | 435 | 1.85e-117 | NTclustered | gi|2314647643|gb|ON241319.1| | 2982810 | g72796 | i0 | 99.17 | 1.99173553719008 | 241 | 2 | 99 | 0 | 2 | 242 | 7846 | 7606 | Pseudostellaria heterophylla carlavirus 1, complete genome | blastn | 482 | 435 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus unipseudostellariae | ||
| 20753968 | 20753968 | PRJNA1248424_P_NODE_32277_length_469_cov_5.244949_g26225_i0 | PRJNA1248424 | 32277 | 469 | 5.244949 | 24.59881081 | Carlavirus unipseudostellariae | 3427802 | Viruses | Viruses | 401 | 3.929999999999999e-107 | NTclustered | gi|2314647643|gb|ON241319.1| | 2982810 | g26225 | i0 | 99.545 | 4.83155650319829 | 220 | 1 | 79 | 0 | 1 | 220 | 6847 | 7066 | Pseudostellaria heterophylla carlavirus 1, complete genome | blastn | 2266 | 401 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus unipseudostellariae |
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);;