contig_metadata
15 rows where bioproject = "PRJNA666695", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1908405 | 1908405 | PRJNA666695_S_NODE_36062_length_333_cov_1.784247_g34968_i0 | PRJNA666695 | 36062 | 333 | 1.784247 | 5.94154251 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.009 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g34968 | i0 | 96.97 | 0.183183183183183 | 33 | 0 | 10 | 1 | 302 | 333 | 38 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 61 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 3181690 | 3181690 | PRJNA666695_S_NODE_141923_length_183_cov_2.288732_g140829_i0 | PRJNA666695 | 141923 | 183 | 2.288732 | 4.18837956 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g140829 | i0 | 100 | 0.770491803278688 | 29 | 0 | 16 | 0 | 155 | 183 | 41 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 3183081 | 3183081 | PRJNA666695_S_NODE_3183_length_880_cov_28.550656_g2527_i0 | PRJNA666695 | 3183 | 880 | 28.550656 | 251.2457728 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.025 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g2527 | i0 | 100 | 0.0329545454545455 | 29 | 0 | 3 | 0 | 852 | 880 | 41 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 3184342 | 3184342 | PRJNA666695_S_NODE_86983_length_234_cov_2.145078_g85889_i0 | PRJNA666695 | 86983 | 234 | 2.145078 | 5.01948252 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g85889 | i0 | 100 | 0.602564102564103 | 29 | 0 | 12 | 0 | 206 | 234 | 41 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 4458826 | 4458826 | PRJNA666695_S_NODE_147904_length_179_cov_1.666667_g146810_i0 | PRJNA666695 | 147904 | 179 | 1.666667 | 2.98333393 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g146810 | i0 | 100 | 0.787709497206704 | 29 | 0 | 16 | 0 | 151 | 179 | 41 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 12111315 | 12111315 | PRJNA666695_S_NODE_27470_length_368_cov_3.522936_g26377_i0 | PRJNA666695 | 27470 | 368 | 3.522936 | 12.96440448 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 58.4 | 7.51e-4 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g26377 | i0 | 100 | 0.388586956521739 | 31 | 0 | 8 | 0 | 338 | 368 | 43 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 143 | 58.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 14662546 | 14662546 | PRJNA666695_S_NODE_95072_length_225_cov_1.907609_g93978_i0 | PRJNA666695 | 95072 | 225 | 1.907609 | 4.29212025 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g93978 | i0 | 100 | 0.257777777777778 | 30 | 0 | 13 | 0 | 196 | 225 | 35 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 15935739 | 15935739 | PRJNA666695_S_NODE_62593_length_268_cov_7.744493_g61499_i0 | PRJNA666695 | 62593 | 268 | 7.744493 | 20.75524124 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g61499 | i0 | 100 | 0.544776119402985 | 30 | 0 | 11 | 0 | 239 | 268 | 42 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 146 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 17208241 | 17208241 | PRJNA666695_S_NODE_11354_length_518_cov_5.559748_g10293_i0 | PRJNA666695 | 11354 | 518 | 5.559748 | 28.79949464 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.014 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g10293 | i0 | 100 | 0.055984555984556 | 29 | 0 | 6 | 0 | 490 | 518 | 34 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 18483255 | 18483255 | PRJNA666695_S_NODE_144655_length_181_cov_2.564286_g143561_i0 | PRJNA666695 | 144655 | 181 | 2.564286 | 4.64135766 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g143561 | i0 | 94.595 | 0.823204419889503 | 37 | 0 | 20 | 2 | 145 | 181 | 47 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 149 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 18484931 | 18484931 | PRJNA666695_S_NODE_48395_length_297_cov_3.785156_g47301_i0 | PRJNA666695 | 48395 | 297 | 3.785156 | 11.24191332 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g47301 | i0 | 100 | 0.474747474747475 | 29 | 0 | 10 | 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 | ||
| 21033218 | 21033218 | PRJNA666695_S_NODE_137457_length_187_cov_0.945205_g136363_i0 | PRJNA666695 | 137457 | 187 | 0.945205 | 1.76753335 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 52.8 | 0.016 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g136363 | i0 | 100 | 0.149732620320856 | 28 | 0 | 15 | 0 | 1 | 28 | 15 | 42 | Carnation latent virus isolate KL, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 21034690 | 21034690 | PRJNA666695_S_NODE_33997_length_340_cov_4.719064_g32903_i0 | PRJNA666695 | 33997 | 340 | 4.719064 | 16.0448176 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 60.2 | 1.92e-4 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g32903 | i0 | 94.872 | 0.197058823529412 | 39 | 1 | 11 | 1 | 1 | 38 | 6 | 44 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 67 | 60.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 22307814 | 22307814 | PRJNA666695_S_NODE_128338_length_194_cov_1.052288_g127244_i0 | PRJNA666695 | 128338 | 194 | 1.052288 | 2.04143872 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g127244 | i0 | 96.97 | 0.314432989690722 | 33 | 0 | 17 | 1 | 1 | 33 | 6 | 37 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 61 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 22310592 | 22310592 | PRJNA666695_S_NODE_80318_length_242_cov_3.547264_g79224_i0 | PRJNA666695 | 80318 | 242 | 3.547264 | 8.58437888 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g79224 | 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 |
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);;