contig_metadata
21 rows where bioproject = "PRJNA564013" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4375559 | 4375559 | PRJNA564013_P_NODE_170264_length_333_cov_10.966912_g167414_i0 | PRJNA564013 | 170264 | 333 | 10.966912 | 36.51981696 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 52.8 | 0.031 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g167414 | i0 | 100 | 0.0840840840840841 | 28 | 0 | 8 | 0 | 306 | 333 | 35 | 8 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 4376266 | 4376266 | PRJNA564013_P_NODE_203944_length_302_cov_7.771784_g201093_i0 | PRJNA564013 | 203944 | 302 | 7.771784 | 23.47078768 | Galium odoratum potexvirus | 2738917 | Viruses | Viruses | 503 | 6.459999999999998e-138 | NTclustered | gi|1845309154|gb|MN814316.1| | 2738917 | g201093 | i0 | 99.281 | 21.135761589404 | 278 | 2 | 92 | 0 | 3 | 280 | 436 | 159 | Galium odoratum potexvirus strain pt040-lat-5, complete genome | blastn | 6383 | 503 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Galium odoratum potexvirus | ||
| 4377588 | 4377588 | PRJNA564013_P_NODE_273044_length_243_cov_15.571429_g270192_i0 | PRJNA564013 | 273044 | 243 | 15.571429 | 37.83857247 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g270192 | i0 | 100 | 0.119341563786008 | 29 | 0 | 12 | 0 | 215 | 243 | 36 | 8 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 4378910 | 4378910 | PRJNA564013_P_NODE_341164_length_203_cov_5.577465_g338312_i0 | PRJNA564013 | 341164 | 203 | 5.577465 | 11.32225395 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g338312 | i0 | 100 | 0.142857142857143 | 29 | 0 | 14 | 0 | 1 | 29 | 15 | 43 | Carnation latent virus isolate KL, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 5656763 | 5656763 | PRJNA564013_P_NODE_85345_length_439_cov_20.804233_g82515_i0 | PRJNA564013 | 85345 | 439 | 20.804233 | 91.33058287 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 560 | 5.7e-155 | NTclustered | gi|2520252303|gb|OQ993368.1| | 12188 | g82515 | i0 | 91.063 | 27.879271070615 | 414 | 37 | 94 | 0 | 1 | 414 | 5835 | 5422 | White clover mosaic virus isolate DSMZ PV-1074, complete genome | blastn | 12239 | 560 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 10756650 | 10756650 | PRJNA564013_P_NODE_47789_length_569_cov_14.954724_g45039_i0 | PRJNA564013 | 47789 | 569 | 14.954724 | 85.09237956 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 56.5 | 0.004 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g45039 | i0 | 92.5 | 0.070298769771529 | 40 | 1 | 7 | 2 | 488 | 527 | 43 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 40 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 12027497 | 12027497 | PRJNA564013_P_NODE_180130_length_324_cov_25.551331_g177280_i0 | PRJNA564013 | 180130 | 324 | 25.551331 | 82.78631244 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 481 | 3.28e-131 | NTclustered | gi|388240165|emb|HE818420.1| | 12242 | g177280 | i0 | 97.518 | 86.9506172839506 | 282 | 6 | 87 | 1 | 19 | 299 | 1040 | 759 | Tobacco mosaic virus isolate Fengcheng, complete genome | blastn | 28172 | 481 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 12028733 | 12028733 | PRJNA564013_P_NODE_243870_length_266_cov_7.921951_g241018_i0 | PRJNA564013 | 243870 | 266 | 7.921951 | 21.07238966 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 52.8 | 0.024 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g241018 | i0 | 100 | 0.105263157894737 | 28 | 0 | 11 | 0 | 239 | 266 | 42 | 15 | Carnation latent virus isolate KL, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 12029963 | 12029963 | PRJNA564013_P_NODE_309650_length_219_cov_5.398734_g306798_i0 | PRJNA564013 | 309650 | 219 | 5.398734 | 11.82322746 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g306798 | i0 | 96.97 | 0.150684931506849 | 33 | 1 | 15 | 0 | 20 | 52 | 14 | 46 | Carnation latent virus isolate KL, complete genome | blastn | 33 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 12030956 | 12030956 | PRJNA564013_P_NODE_359850_length_191_cov_23.023077_g356998_i0 | PRJNA564013 | 359850 | 191 | 23.023077 | 43.97407707 | Potexvirus pepini | 3433856 | Viruses | Viruses | 311 | 2.45e-80 | NTclustered | gi|375808845|gb|JN835466.1| | 112229 | g356998 | i0 | 100 | 81.9057591623037 | 168 | 0 | 88 | 0 | 24 | 191 | 6245 | 6412 | Pepino mosaic virus strain CH2, complete genome | blastn | 15644 | 311 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 13886690 | 13886690 | PRJNA564013_P_NODE_342691_length_203_cov_0.915493_g339839_i0 | PRJNA564013 | 342691 | 203 | 0.915493 | 1.85845079 | Potexvirus | 12176 | Viruses | Viruses | 230 | 7.61e-56 | NTclustered | gi|2426915758|dbj|LC613009.1| | 167132 | g339839 | i0 | 87.562 | 1.98029556650246 | 201 | 22 | 98 | 2 | 6 | 203 | 272 | 72 | Tulip virus X Vi genomic RNA, complete genome | blastn | 402 | 230 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus ecstulipae | ||
| 15853794 | 15853794 | PRJNA564013_P_NODE_316573_length_215_cov_4.415584_g313721_i0 | PRJNA564013 | 316573 | 215 | 4.415584 | 9.4935056 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 52.8 | 0.019 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g313721 | i0 | 100 | 0.130232558139535 | 28 | 0 | 13 | 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 | ||
| 18398612 | 18398612 | PRJNA564013_P_NODE_114295_length_389_cov_20.490854_g111453_i0 | PRJNA564013 | 114295 | 389 | 20.490854 | 79.70942206 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 52.8 | 0.037 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g111453 | i0 | 100 | 0.0719794344473008 | 28 | 0 | 7 | 0 | 1 | 28 | 8 | 35 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 18404730 | 18404730 | PRJNA564013_P_NODE_69475_length_484_cov_9.966903_g66664_i0 | PRJNA564013 | 69475 | 484 | 9.966903 | 48.23981052 | Potexvirus flavitrifolii | 3433843 | Viruses | Viruses | 749 | 0 | NTclustered | gi|2217161454|gb|OL584354.1| | 12177 | g66664 | i0 | 96.078 | 11.1611570247934 | 459 | 18 | 95 | 0 | 4 | 462 | 7015 | 6557 | Clover yellow mosaic virus isolate DSMZ PV-0851 genomic sequence | blastn | 5402 | 749 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus flavitrifolii | ||
| 22226678 | 22226678 | PRJNA564013_P_NODE_243738_length_266_cov_13.629268_g240886_i0 | PRJNA564013 | 243738 | 266 | 13.629268 | 36.25385288 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g240886 | i0 | 100 | 0.214285714285714 | 29 | 0 | 11 | 0 | 238 | 266 | 34 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 22228536 | 22228536 | PRJNA564013_P_NODE_341218_length_203_cov_5.021127_g338366_i0 | PRJNA564013 | 341218 | 203 | 5.021127 | 10.19288781 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 209 | 9.92e-50 | NTclustered | gi|2520252303|gb|OQ993368.1| | 12188 | g338366 | i0 | 87.363 | 0.896551724137931 | 182 | 23 | 90 | 0 | 22 | 203 | 5658 | 5839 | White clover mosaic virus isolate DSMZ PV-1074, complete genome | blastn | 182 | 209 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 23500035 | 23500035 | PRJNA564013_P_NODE_151059_length_350_cov_14.269896_g148210_i0 | PRJNA564013 | 151059 | 350 | 14.269896 | 49.944636 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 52.8 | 0.033 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g148210 | i0 | 100 | 0.08 | 28 | 0 | 8 | 0 | 323 | 350 | 42 | 15 | Carnation latent virus isolate KL, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 23504342 | 23504342 | PRJNA564013_P_NODE_371099_length_177_cov_8.724138_g368247_i0 | PRJNA564013 | 371099 | 177 | 8.724138 | 15.44172426 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 52.8 | 0.015 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g368247 | i0 | 100 | 0.15819209039548 | 28 | 0 | 16 | 0 | 1 | 28 | 8 | 35 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 24779024 | 24779024 | PRJNA564013_P_NODE_75320_length_466_cov_5.703704_g72499_i0 | PRJNA564013 | 75320 | 466 | 5.703704 | 26.57926064 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 52.8 | 0.045 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g72499 | i0 | 100 | 0.0600858369098712 | 28 | 0 | 6 | 0 | 30 | 57 | 34 | 7 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 25358925 | 25358925 | PRJNA564013_P_NODE_297860_length_227_cov_1.078313_g295008_i0 | PRJNA564013 | 297860 | 227 | 1.078313 | 2.44777051 | Potexvirus | 12176 | Viruses | Viruses | 276 | 1.1e-69 | NTclustered | gi|2426915758|dbj|LC613009.1| | 167132 | g295008 | i0 | 89.45 | 1.92070484581498 | 218 | 23 | 96 | 0 | 1 | 218 | 3692 | 3475 | Tulip virus X Vi genomic RNA, complete genome | blastn | 436 | 276 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus ecstulipae | ||
| 26889667 | 26889667 | PRJNA564013_P_NODE_344801_length_202_cov_1.382979_g341949_i0 | PRJNA564013 | 344801 | 202 | 1.382979 | 2.79361758 | Tymovirales sp. | 1955157 | Viruses | Viruses | 88.2 | 2.17e-18 | NR | XCO49695.1 | 1955157 | g341949 | i0 | 69.5 | 3.53465346534653 | 59 | 18 | 87.6 | 0 | 201 | 25 | 1669 | 1727 | XCO49695.1 MAG: putative ORF1 protein [Tymovirales sp.] | diamond | 714 | 88.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymovirales sp. |
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);;