contig_metadata
4 rows where bioproject = "PRJNA891846", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 867346 | 867346 | PRJNA891846_P_NODE_38101_length_250_cov_0.870056_g37881_i0 | PRJNA891846 | 38101 | 250 | 0.870056 | 2.17514 | Prunevirus unicamelliae | 3241187 | Viruses | Viruses | 187 | 5.949999999999998e-43 | NTclustered | gi|2500380498|ref|NC_076655.1| | 2606569 | g37881 | i0 | 83.01 | 0.824 | 206 | 35 | 82 | 0 | 42 | 247 | 4595 | 4800 | Camellia ringspot associated virus 1 isolate CJ5, complete genome | blastn | 206 | 187 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Prunevirus unicamelliae | ||
| 9795447 | 9795447 | PRJNA891846_P_NODE_4748_length_664_cov_1.377327_g4543_i0 | PRJNA891846 | 4748 | 664 | 1.377327 | 9.14545128 | Camellia japonica associated betaflexivirus 1 | 2686011 | Viruses | Viruses | 606 | 1.1299999999999999e-168 | NTclustered | gi|1785471203|gb|MN532567.1| | 2686011 | g4543 | i0 | 91.743 | 5.92771084337349 | 436 | 36 | 98 | 0 | 229 | 664 | 7000 | 7435 | Camellia japonica associated betaflexivirus 1 isolate CAM2NGS2019 RNA dependent RNA polymerase (ORF1), movement protein (ORF2), and coat protein (ORF3) genes, complete cds | blastn | 3936 | 606 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Camellia japonica associated betaflexivirus 1 | |||
| 30348243 | 30348243 | PRJNA891846_P_NODE_42612_length_245_cov_1.790698_g42392_i0 | PRJNA891846 | 42612 | 245 | 1.790698 | 4.3872101 | Prunevirus | 1914295 | Viruses | Viruses | 164 | 7.24e-45 | NR | YP_010799543.1 | 2606569 | g42392 | i0 | 91.4 | 2.97551020408163 | 81 | 7 | 99.2 | 0 | 245 | 3 | 1710 | 1790 | YP_010799543.1 replicase [Camellia ringspot associated virus 1] | diamond | 729 | 165 | 0.993939393939394 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Prunevirus unicamelliae | ||
| 31667366 | 31667366 | PRJNA891846_P_NODE_5457_length_622_cov_1.360656_g5247_i0 | PRJNA891846 | 5457 | 622 | 1.360656 | 8.46328032 | Camellia japonica associated betaflexivirus 1 | 2686011 | Viruses | Viruses | 317 | 5.049999999999999e-104 | NR | QGY72523.1 | 2686011 | g5247 | i0 | 98.2 | 0.795819935691318 | 165 | 3 | 79.6 | 0 | 127 | 621 | 1 | 165 | QGY72523.1 movement protein [Camellia japonica associated betaflexivirus 1] | diamond | 495 | 317 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Camellia japonica associated betaflexivirus 1 |
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);;