contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1085664" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1468171 | 1468171 | PRJNA1085664_S_NODE_24822_length_177_cov_1.074627_g24403_i0 | PRJNA1085664 | 24822 | 177 | 1.074627 | 1.90208979 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 58.4 | 3.21e-4 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g24403 | i0 | 97.143 | 0.19774011299435 | 35 | 0 | 19 | 1 | 1 | 34 | 15 | 49 | Carnation latent virus isolate KL, complete genome | blastn | 35 | 58.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 15496175 | 15496175 | PRJNA1085664_S_NODE_18193_length_204_cov_1.490683_g17774_i0 | PRJNA1085664 | 18193 | 204 | 1.490683 | 3.04099332 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g17774 | i0 | 100 | 0.279411764705882 | 29 | 0 | 14 | 0 | 1 | 29 | 6 | 34 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 18045322 | 18045322 | PRJNA1085664_S_NODE_36635_length_151_cov_0.870370_g36216_i0 | PRJNA1085664 | 36635 | 151 | 0.87037 | 1.3142587 | Pestivirus bovis | 3052619 | Viruses | Viruses | 230 | 5.299999999999999e-56 | NTclustered | gi|972905812|gb|KU200260.1| | 11099 | g36216 | i0 | 94.04 | 93.6291390728477 | 151 | 9 | 100 | 0 | 1 | 151 | 8809 | 8959 | Bovine viral diarrhea virus 1, partial genome | blastn | 14138 | 230 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 18868989 | 18868989 | PRJNA1085664_S_NODE_6755_length_330_cov_1.637631_g6336_i0 | PRJNA1085664 | 6755 | 330 | 1.637631 | 5.4041823 | Pestivirus | 11095 | Viruses | Viruses | 584 | 2.48e-162 | NTclustered | gi|2672396898|gb|PP277983.1| | 11099 | g6336 | i0 | 98.78 | 52.4212121212121 | 328 | 4 | 99 | 0 | 1 | 328 | 10047 | 9720 | Bovine viral diarrhea virus 1 isolate NX2023, complete genome | blastn | 17299 | 584 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 19319349 | 19319349 | PRJNA1085664_S_NODE_7376_length_317_cov_3.281022_g6957_i0 | PRJNA1085664 | 7376 | 317 | 3.281022 | 10.40083974 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 58.4 | 6.38e-4 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g6957 | i0 | 100 | 0.0977917981072555 | 31 | 0 | 10 | 0 | 1 | 31 | 8 | 38 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 31 | 58.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 20143699 | 20143699 | PRJNA1085664_S_NODE_12656_length_244_cov_2.034826_g12237_i0 | PRJNA1085664 | 12656 | 244 | 2.034826 | 4.96497544 | Pestivirus | 11095 | Viruses | Viruses | 442 | 1.1199999999999994e-119 | NTclustered | gi|1093530907|gb|KT943518.1| | 11099 | g12237 | i0 | 99.587 | 49.7377049180328 | 242 | 1 | 99 | 0 | 3 | 244 | 8195 | 7954 | Bovine viral diarrhea virus 1 isolate BJ1201, complete genome | blastn | 12136 | 446 | 0.991031390134529 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis |
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);;