contig_metadata
12 rows where bioproject = "PRJNA1115053", tax_kingdom = "Orthornavirae" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 229689 | 229689 | PRJNA1115053_S_NODE_88681_length_272_cov_1.257642_g86864_i0 | PRJNA1115053 | 88681 | 272 | 1.257642 | 3.42078624 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g86864 | i0 | 100 | 0.209558823529412 | 29 | 0 | 11 | 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 | |||
| 1498080 | 1498080 | PRJNA1115053_S_NODE_140042_length_226_cov_1.409836_g138225_i0 | PRJNA1115053 | 140042 | 226 | 1.409836 | 3.18622936 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g138225 | i0 | 100 | 0.623893805309734 | 29 | 0 | 13 | 0 | 1 | 29 | 13 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 4051585 | 4051585 | PRJNA1115053_S_NODE_198084_length_195_cov_0.947368_g196267_i0 | PRJNA1115053 | 198084 | 195 | 0.947368 | 1.8473676 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g196267 | i0 | 94.595 | 0.333333333333333 | 37 | 0 | 18 | 2 | 161 | 195 | 42 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 65 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 7876789 | 7876789 | PRJNA1115053_S_NODE_164907_length_211_cov_1.059524_g163090_i0 | PRJNA1115053 | 164907 | 211 | 1.059524 | 2.23559564 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g163090 | i0 | 100 | 0.270142180094787 | 29 | 0 | 14 | 0 | 183 | 211 | 34 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 11703074 | 11703074 | PRJNA1115053_S_NODE_182550_length_202_cov_1.056604_g180733_i0 | PRJNA1115053 | 182550 | 202 | 1.056604 | 2.13434008 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g180733 | i0 | 100 | 0.698019801980198 | 29 | 0 | 14 | 0 | 1 | 29 | 13 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 11703663 | 11703663 | PRJNA1115053_S_NODE_206990_length_191_cov_1.297297_g205173_i0 | PRJNA1115053 | 206990 | 191 | 1.297297 | 2.47783727 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g205173 | i0 | 100 | 0.743455497382199 | 30 | 0 | 16 | 0 | 162 | 191 | 42 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 142 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 12976664 | 12976664 | PRJNA1115053_S_NODE_118011_length_242_cov_3.070352_g116194_i0 | PRJNA1115053 | 118011 | 242 | 3.070352 | 7.43025184 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g116194 | i0 | 100 | 0.582644628099174 | 29 | 0 | 12 | 0 | 214 | 242 | 41 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 15532124 | 15532124 | PRJNA1115053_S_NODE_80553_length_282_cov_1.807531_g78736_i0 | PRJNA1115053 | 80553 | 282 | 1.807531 | 5.09723742 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 58.4 | 5.59e-4 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g78736 | i0 | 92.683 | 0.656028368794326 | 41 | 2 | 15 | 1 | 242 | 282 | 52 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 185 | 58.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 18077154 | 18077154 | PRJNA1115053_S_NODE_229735_length_182_cov_1.956835_g227918_i0 | PRJNA1115053 | 229735 | 182 | 1.956835 | 3.5614397 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g227918 | i0 | 100 | 0.313186813186813 | 29 | 0 | 16 | 0 | 154 | 182 | 34 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 18081323 | 18081323 | PRJNA1115053_S_NODE_86815_length_274_cov_1.974026_g84998_i0 | PRJNA1115053 | 86815 | 274 | 1.974026 | 5.40883124 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g84998 | i0 | 100 | 0.631386861313869 | 29 | 0 | 11 | 0 | 1 | 29 | 13 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 173 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 20624416 | 20624416 | PRJNA1115053_S_NODE_137877_length_227_cov_2.657609_g136060_i0 | PRJNA1115053 | 137877 | 227 | 2.657609 | 6.03277243 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g136060 | i0 | 100 | 0.251101321585903 | 29 | 0 | 13 | 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 | |||
| 24450415 | 24450415 | PRJNA1115053_S_NODE_176600_length_204_cov_36.391304_g174783_i0 | PRJNA1115053 | 176600 | 204 | 36.391304 | 74.23826016 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 58.4 | 3.83e-4 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g174783 | i0 | 100 | 0.28921568627451 | 31 | 0 | 15 | 0 | 1 | 31 | 6 | 36 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 59 | 58.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 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);;