contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA448207" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19564439 | 19564439 | PRJNA448207_P_NODE_1996_length_819_cov_2.229223_g1869_i0 | PRJNA448207 | 1996 | 819 | 2.229223 | 18.25733637 | Foveavirus mali | 35350 | Viruses | Viruses | 534 | 8.219999999999998e-172 | NR | QDK54719.1 | 35350 | g1869 | i0 | 94 | 8.8021978021978 | 267 | 16 | 97.8 | 0 | 1 | 801 | 1032 | 1298 | QDK54719.1 RNA-dependent RNA polymerase [Foveavirus mali] | diamond | 7209 | 534 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Foveavirus | Foveavirus mali | ||
| 29601975 | 29601975 | PRJNA448207_P_NODE_23490_length_263_cov_1.689474_g23327_i0 | PRJNA448207 | 23490 | 263 | 1.689474 | 4.44331662 | Foveavirus mali | 35350 | Viruses | Viruses | 64.7 | 8.89e-10 | NR | APT69452.1 | 35350 | g23327 | i0 | 43.8 | 0.832699619771863 | 73 | 41 | 83.3 | 0 | 223 | 5 | 616 | 688 | APT69452.1 replicase polyprotein, partial [Foveavirus mali] | diamond | 219 | 64.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Foveavirus | Foveavirus mali | ||
| 29665077 | 29665077 | PRJNA448207_P_NODE_330_length_1551_cov_4.387009_g299_i0 | PRJNA448207 | 330 | 1551 | 4.387009 | 68.04250959 | Qianjiang hepeli-like virus 14 | 3348976 | Viruses | Viruses | 406 | 2.5199999999999998e-132 | NR | XHA85831.1 | 3348976 | g299 | i0 | 55.3 | 0.752417794970986 | 389 | 157 | 72.3 | 5 | 6 | 1127 | 101 | 487 | XHA85831.1 MAG: hypothetical protein [Qianjiang hepeli-like virus 14] | diamond | 1167 | 406 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Qianjiang hepeli-like virus 14 | ||||
| 31339964 | 31339964 | PRJNA448207_P_NODE_14396_length_334_cov_1.268199_g14233_i0 | PRJNA448207 | 14396 | 334 | 1.268199 | 4.23578466 | Foveavirus mali | 35350 | Viruses | Viruses | 197 | 6.31e-56 | NR | QDK54718.1 | 35350 | g14233 | i0 | 90.9 | 0.988023952095808 | 110 | 10 | 98.8 | 0 | 3 | 332 | 484 | 593 | QDK54718.1 RNA-dependent RNA polymerase [Foveavirus mali] | diamond | 330 | 197 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Foveavirus | Foveavirus mali | ||
| 31403426 | 31403426 | PRJNA448207_P_NODE_30436_length_245_cov_0.895349_g30273_i0 | PRJNA448207 | 30436 | 245 | 0.895349 | 2.19360505 | Capillovirus mali | 28347 | Viruses | Viruses | 132 | 1.14e-33 | NR | BBK03475.1 | 28347 | g30273 | i0 | 81.5 | 0.991836734693878 | 81 | 15 | 99.2 | 0 | 2 | 244 | 474 | 554 | BBK03475.1 polyprotein [Capillovirus mali] | diamond | 243 | 132 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali | ||
| 31593244 | 31593244 | PRJNA448207_P_NODE_3836_length_605_cov_1.937970_g3679_i0 | PRJNA448207 | 3836 | 605 | 1.93797 | 11.7247185 | Bromoviridae sp. | 2808998 | Viruses | Viruses | 142 | 1.14e-37 | NR | QXV86509.1 | 2808998 | g3679 | i0 | 37.7 | 0.986776859504132 | 199 | 118 | 96.2 | 3 | 589 | 8 | 31 | 228 | QXV86509.1 movement protein [Bromoviridae sp.] | diamond | 597 | 142 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Bromoviridae sp. | |||
| 32273889 | 32273889 | PRJNA448207_P_NODE_2798_length_706_cov_1.549763_g2651_i0 | PRJNA448207 | 2798 | 706 | 1.549763 | 10.94132678 | Bromovirus | 12300 | Viruses | Viruses | 73.9 | 3.65e-12 | NR | NP_689395.1 | 188141 | g2651 | i0 | 34.6 | 1.3385269121813 | 162 | 92 | 65.4 | 5 | 695 | 234 | 36 | 191 | NP_689395.1 coat protein [Spring beauty latent virus] | diamond | 945 | 73.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Bromovirus | Bromovirus SBLV |
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);;