contig_metadata
11 rows where bioproject = "PRJNA975724", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2221666 | 2221666 | PRJNA975724_S_NODE_48562_length_300_cov_1.731278_g48381_i0 | PRJNA975724 | 48562 | 300 | 1.731278 | 5.193834 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g48381 | i0 | 94.444 | 0.213333333333333 | 36 | 1 | 12 | 1 | 1 | 36 | 8 | 42 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 64 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 3497938 | 3497938 | PRJNA975724_S_NODE_85723_length_245_cov_1.343023_g85542_i0 | PRJNA975724 | 85723 | 245 | 1.343023 | 3.29040635 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g85542 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 1 | 28 | 14 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 3498159 | 3498159 | PRJNA975724_S_NODE_93343_length_231_cov_2.259494_g93162_i0 | PRJNA975724 | 93343 | 231 | 2.259494 | 5.21943114 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g93162 | i0 | 100 | 0.61038961038961 | 29 | 0 | 13 | 0 | 203 | 231 | 41 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 7324678 | 7324678 | PRJNA975724_S_NODE_64846_length_271_cov_1.085859_g64665_i0 | PRJNA975724 | 64846 | 271 | 1.085859 | 2.94267789 | Pestivirus bovis | 3052619 | Viruses | Viruses | 93.5 | 1.46e-14 | NTclustered | gi|1169640532|emb|LT837585.1| | 11099 | g64665 | i0 | 96.429 | 0.516605166051661 | 56 | 2 | 21 | 0 | 1 | 56 | 12222 | 12167 | Bovine viral diarrhea virus 1 genome assembly, complete genome: monopartite | blastn | 140 | 93.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 7325270 | 7325270 | PRJNA975724_S_NODE_8726_length_463_cov_12.217949_g8545_i0 | PRJNA975724 | 8726 | 463 | 12.217949 | 56.56910387 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 60.2 | 2.69e-4 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g8545 | i0 | 91.304 | 0.41036717062635 | 46 | 1 | 9 | 3 | 1 | 43 | 13 | 58 | Carnation latent virus isolate KL, complete genome | blastn | 190 | 60.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 13699779 | 13699779 | PRJNA975724_S_NODE_4031_length_549_cov_40.115546_g3853_i0 | PRJNA975724 | 4031 | 549 | 40.115546 | 220.23434754 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.015 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g3853 | i0 | 100 | 0.0528233151183971 | 29 | 0 | 5 | 0 | 521 | 549 | 34 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 13700484 | 13700484 | PRJNA975724_S_NODE_67371_length_267_cov_0.917526_g67190_i0 | PRJNA975724 | 67371 | 267 | 0.917526 | 2.44979442 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g67190 | i0 | 100 | 0.213483146067416 | 29 | 0 | 11 | 0 | 239 | 267 | 34 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 14973343 | 14973343 | PRJNA975724_S_NODE_1372_length_737_cov_2.978916_g1223_i0 | PRJNA975724 | 1372 | 737 | 2.978916 | 21.95461092 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.021 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g1223 | i0 | 100 | 0.039348710990502 | 29 | 0 | 4 | 0 | 1 | 29 | 13 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 16248567 | 16248567 | PRJNA975724_S_NODE_2433_length_629_cov_12.215827_g2262_i0 | PRJNA975724 | 2433 | 629 | 12.215827 | 76.83755183 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.017 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g2262 | i0 | 100 | 0.0461049284578696 | 29 | 0 | 5 | 0 | 1 | 29 | 6 | 34 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 16249540 | 16249540 | PRJNA975724_S_NODE_61413_length_276_cov_1.837438_g61232_i0 | PRJNA975724 | 61413 | 276 | 1.837438 | 5.07132888 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g61232 | i0 | 100 | 0.206521739130435 | 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 | |||
| 17523518 | 17523518 | PRJNA975724_S_NODE_16454_length_404_cov_4.833837_g16273_i0 | PRJNA975724 | 16454 | 404 | 4.833837 | 19.52870148 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.011 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g16273 | i0 | 100 | 0.141089108910891 | 29 | 0 | 7 | 0 | 376 | 404 | 34 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 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);;