contig_metadata
10 rows where bioproject = "PRJNA857143", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 844039 | 844039 | PRJNA857143_S_NODE_40581_length_422_cov_24.621777_g39489_i0 | PRJNA857143 | 40581 | 422 | 24.621777 | 103.90389894 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.011 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g39489 | i0 | 100 | 0.135071090047393 | 29 | 0 | 7 | 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 | |||
| 3787181 | 3787181 | PRJNA857143_S_NODE_100203_length_313_cov_1.350000_g99110_i0 | PRJNA857143 | 100203 | 313 | 1.35 | 4.2255 | Hepacivirus | 11102 | Viruses | Viruses | 108 | 6.16e-19 | NTclustered | gi|288815570|gb|GQ870502.1| | 2847144 | g99110 | i0 | 92.105 | 24.2555910543131 | 76 | 6 | 24 | 0 | 238 | 313 | 539 | 464 | Hepatitis C virus subtype 1a isolate 1/910 clone 2A3-49 polyprotein gene, partial cds | blastn | 7592 | 108 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Hepacivirus | Hepacivirus hominis | ||
| 5946074 | 5946074 | PRJNA857143_S_NODE_102965_length_310_cov_1.223629_g101872_i0 | PRJNA857143 | 102965 | 310 | 1.223629 | 3.7932499 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g101872 | i0 | 100 | 0.454838709677419 | 29 | 0 | 9 | 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 | ||
| 5946606 | 5946606 | PRJNA857143_S_NODE_154765_length_263_cov_1.236842_g153672_i0 | PRJNA857143 | 154765 | 263 | 1.236842 | 3.25289446 | Hepacivirus hominis | 3052230 | Viruses | Viruses | 126 | 1.39e-24 | NTclustered | gi|557126858|gb|JQ061326.1| | 3052230 | g153672 | i0 | 86.726 | 1.83269961977186 | 113 | 15 | 43 | 0 | 149 | 261 | 512 | 400 | Hepatitis C virus isolate C003_E_2A3C4 from USA polyprotein (gp1) gene, partial cds; and nonfunctional protein F (gp2) gene, partial sequence | blastn | 482 | 126 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Hepacivirus | Hepacivirus hominis | ||
| 5946904 | 5946904 | PRJNA857143_S_NODE_18165_length_548_cov_12.233684_g17094_i0 | PRJNA857143 | 18165 | 548 | 12.233684 | 67.04058832 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.015 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g17094 | i0 | 100 | 0.0529197080291971 | 29 | 0 | 5 | 0 | 520 | 548 | 34 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 11439081 | 11439081 | PRJNA857143_S_NODE_6829_length_779_cov_2.352691_g5971_i0 | PRJNA857143 | 6829 | 779 | 2.352691 | 18.32746289 | Hepacivirus | 11102 | Viruses | Viruses | 438 | 5.129999999999999e-118 | NTclustered | gi|212675038|gb|EU781799.1| | 2847144 | g5971 | i0 | 86.352 | 82.2464698331194 | 403 | 54 | 52 | 1 | 356 | 757 | 666 | 264 | Hepatitis C virus subtype 1a isolate 01-39, complete genome | blastn | 64070 | 440 | 0.995454545454545 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Hepacivirus | Hepacivirus hominis | ||
| 13598285 | 13598285 | PRJNA857143_S_NODE_92671_length_322_cov_1.204819_g91578_i0 | PRJNA857143 | 92671 | 322 | 1.204819 | 3.87951718 | Hepacivirus hominis | 3052230 | Viruses | Viruses | 65.8 | 3.88e-6 | NTclustered | gi|190171155|gb|EU256104.1| | 2847144 | g91578 | i0 | 90 | 1.22360248447205 | 50 | 5 | 16 | 0 | 6 | 55 | 747 | 796 | Hepatitis C virus subtype 1a isolate HCV-1a/US/BID-V430/2005, complete genome | blastn | 394 | 65.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Hepacivirus | Hepacivirus hominis | ||
| 14871206 | 14871206 | PRJNA857143_S_NODE_141452_length_273_cov_1.955000_g140359_i0 | PRJNA857143 | 141452 | 273 | 1.955 | 5.33715 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 52.8 | 0.025 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g140359 | i0 | 96.875 | 0.117216117216117 | 32 | 0 | 12 | 1 | 1 | 32 | 14 | 44 | Carnation latent virus isolate KL, complete genome | blastn | 32 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 19970366 | 19970366 | PRJNA857143_S_NODE_194776_length_242_cov_0.923077_g193683_i0 | PRJNA857143 | 194776 | 242 | 0.923077 | 2.23384634 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g193683 | i0 | 100 | 0.235537190082645 | 29 | 0 | 12 | 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 | |||
| 22520405 | 22520405 | PRJNA857143_S_NODE_186858_length_245_cov_1.500000_g185765_i0 | PRJNA857143 | 186858 | 245 | 1.5 | 3.675 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g185765 | i0 | 100 | 0.579591836734694 | 30 | 0 | 12 | 0 | 1 | 30 | 13 | 42 | Carnation latent virus isolate KL, complete genome | blastn | 142 | 56.5 | 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);;