contig_metadata
19 rows where bioproject = "PRJNA1034995", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 168510 | 168510 | PRJNA1034995_S_NODE_40341_length_203_cov_3.725000_g40185_i0 | PRJNA1034995 | 40341 | 203 | 3.725 | 7.56175 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g40185 | i0 | 100 | 0.694581280788177 | 29 | 0 | 14 | 0 | 175 | 203 | 41 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 2718826 | 2718826 | PRJNA1034995_S_NODE_21443_length_362_cov_12.686520_g21287_i0 | PRJNA1034995 | 21443 | 362 | 12.68652 | 45.9252024 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.01 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g21287 | i0 | 100 | 0.157458563535912 | 29 | 0 | 8 | 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 | |||
| 2718959 | 2718959 | PRJNA1034995_S_NODE_39143_length_209_cov_8.180723_g38987_i0 | PRJNA1034995 | 39143 | 209 | 8.180723 | 17.09771107 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g38987 | i0 | 100 | 0.674641148325359 | 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 | ||
| 3995009 | 3995009 | PRJNA1034995_S_NODE_31544_length_258_cov_2.990698_g31388_i0 | PRJNA1034995 | 31544 | 258 | 2.990698 | 7.71600084 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g31388 | i0 | 100 | 0.546511627906977 | 29 | 0 | 11 | 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 | ||
| 3995039 | 3995039 | PRJNA1034995_S_NODE_35184_length_232_cov_7.380952_g35028_i0 | PRJNA1034995 | 35184 | 232 | 7.380952 | 17.12380864 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g35028 | i0 | 100 | 0.607758620689655 | 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 | ||
| 6110871 | 6110871 | PRJNA1034995_S_NODE_35525_length_230_cov_5.914439_g35369_i0 | PRJNA1034995 | 35525 | 230 | 5.914439 | 13.6032097 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.006 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g35369 | i0 | 100 | 0.647826086956522 | 29 | 0 | 13 | 0 | 1 | 29 | 13 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 149 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 6546434 | 6546434 | PRJNA1034995_S_NODE_23166_length_339_cov_7.418919_g23010_i0 | PRJNA1034995 | 23166 | 339 | 7.418919 | 25.15013541 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.009 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g23010 | i0 | 100 | 0.168141592920354 | 29 | 0 | 9 | 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 | |||
| 8660817 | 8660817 | PRJNA1034995_S_NODE_35707_length_229_cov_5.838710_g35551_i0 | PRJNA1034995 | 35707 | 229 | 5.83871 | 13.3706459 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.006 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g35551 | i0 | 96.875 | 0.633187772925764 | 32 | 1 | 14 | 0 | 1 | 32 | 13 | 44 | Carnation latent virus isolate KL, complete genome | blastn | 145 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 11646986 | 11646986 | PRJNA1034995_S_NODE_28530_length_282_cov_10.849372_g28374_i0 | PRJNA1034995 | 28530 | 282 | 10.849372 | 30.59522904 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g28374 | i0 | 100 | 0.202127659574468 | 29 | 0 | 10 | 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 | |||
| 12922234 | 12922234 | PRJNA1034995_S_NODE_39411_length_208_cov_2.884848_g39255_i0 | PRJNA1034995 | 39411 | 208 | 2.884848 | 6.00048384 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g39255 | i0 | 100 | 0.682692307692308 | 30 | 0 | 14 | 0 | 179 | 208 | 42 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 142 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 12922259 | 12922259 | PRJNA1034995_S_NODE_42991_length_191_cov_1.101351_g42835_i0 | PRJNA1034995 | 42991 | 191 | 1.101351 | 2.10358041 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g42835 | i0 | 96.97 | 0.319371727748691 | 33 | 0 | 17 | 1 | 160 | 191 | 38 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 61 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 15471219 | 15471219 | PRJNA1034995_S_NODE_18853_length_404_cov_28.565097_g18698_i0 | PRJNA1034995 | 18853 | 404 | 28.565097 | 115.40299188 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.011 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g18698 | i0 | 100 | 0.349009900990099 | 29 | 0 | 7 | 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 | ||
| 18020234 | 18020234 | PRJNA1034995_S_NODE_22175_length_352_cov_12.249191_g22019_i0 | PRJNA1034995 | 22175 | 352 | 12.249191 | 43.11715232 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g22019 | i0 | 100 | 0.403409090909091 | 30 | 0 | 9 | 0 | 323 | 352 | 42 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 142 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 19294324 | 19294324 | PRJNA1034995_S_NODE_42496_length_193_cov_3.060000_g42340_i0 | PRJNA1034995 | 42496 | 193 | 3.06 | 5.9058 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g42340 | i0 | 100 | 0.730569948186529 | 29 | 0 | 15 | 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 | ||
| 20569651 | 20569651 | PRJNA1034995_S_NODE_35097_length_233_cov_3.147368_g34941_i0 | PRJNA1034995 | 35097 | 233 | 3.147368 | 7.33336744 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 58.4 | 4.48e-4 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g34941 | i0 | 100 | 0.613733905579399 | 31 | 0 | 13 | 0 | 1 | 31 | 13 | 43 | Carnation latent virus isolate KL, complete genome | blastn | 143 | 58.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 21845387 | 21845387 | PRJNA1034995_S_NODE_36358_length_225_cov_8.175824_g36202_i0 | PRJNA1034995 | 36358 | 225 | 8.175824 | 18.395604 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g36202 | i0 | 100 | 0.626666666666667 | 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 | ||
| 23120740 | 23120740 | PRJNA1034995_S_NODE_39419_length_208_cov_2.606061_g39263_i0 | PRJNA1034995 | 39419 | 208 | 2.606061 | 5.42060688 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g39263 | i0 | 100 | 0.274038461538462 | 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 | |||
| 24394499 | 24394499 | PRJNA1034995_S_NODE_26160_length_305_cov_8.618321_g26004_i0 | PRJNA1034995 | 26160 | 305 | 8.618321 | 26.28587905 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 60.2 | 1.7e-4 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g26004 | i0 | 97.222 | 0.311475409836066 | 36 | 0 | 12 | 1 | 270 | 305 | 42 | 8 | Carnation latent virus isolate KL, complete genome | blastn | 95 | 60.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 24394627 | 24394627 | PRJNA1034995_S_NODE_46100_length_178_cov_2.044444_g45944_i0 | PRJNA1034995 | 46100 | 178 | 2.044444 | 3.63911032 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 52.8 | 0.015 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g45944 | i0 | 100 | 0.157303370786517 | 28 | 0 | 16 | 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 |
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);;