contig_metadata
22 rows where analysis = "blastn" and tax_clade = "RNA satellites"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1718502 | 1718502 | PRJNA473201_P_NODE_3002_length_1144_cov_13.519141_g2576_i0 | PRJNA473201 | 3002 | 1144 | 13.519141 | 154.65897304 | Peony yellowing associated secovirus satellite RNA | 2800989 | Viruses | Viruses | 1295 | 0 | NTclustered | gi|1898324217|gb|MN259157.1| | 2800989 | g2576 | i0 | 91.272 | 0.831293706293706 | 951 | 81 | 83 | 2 | 2 | 951 | 6 | 955 | Peony yellowing associated secovirus satellite RNA strain BJ 31 kDa protein gene, complete cds | blastn | 951 | 1295 | 1 | Viruses | RNA satellites | Peony yellowing associated secovirus satellite RNA | |||||||
| 2279325 | 2279325 | PRJNA1022587_S_NODE_22_length_988_cov_3.144262_g20_i0 | PRJNA1022587 | 22 | 988 | 3.144262 | 31.06530856 | Viruses | 10239 | Viruses | Viruses | 867 | 0 | NTclustered | gi|1408257600|ref|NC_037663.1| | 2219109 | g20 | i0 | 97.624 | 5.1497975708502 | 505 | 12 | 51 | 0 | 3 | 507 | 3905 | 3401 | Botrytis cinerea hypovirus 1 satellite-like RNA, complete genome | blastn | 5088 | 872 | 0.994266055045872 | Viruses | RNA satellites | Botrytis cinerea hypovirus 1 satellite-like RNA | |||||||
| 6000547 | 6000547 | PRJNA922057_P_NODE_1425_length_380_cov_2.508143_g1382_i0 | PRJNA922057 | 1425 | 380 | 2.508143 | 9.5309434 | Bamboo mosaic virus satellite RNA | 190811 | Viruses | Viruses | 662 | 0 | NTclustered | gi|1242862488|dbj|LC223294.1| | 190811 | g1382 | i0 | 98.404 | 98.9421052631579 | 376 | 6 | 99 | 0 | 5 | 380 | 835 | 460 | Bamboo mosaic virus satellite RNA genomic RNA, complete sequence, clone: Bvu_a-15 | blastn | 37598 | 662 | 1 | Viruses | RNA satellites | Bamboo mosaic virus satellite RNA | |||||||
| 6107317 | 6107317 | PRJNA1022587_S_NODE_65_length_691_cov_4.220065_g63_i0 | PRJNA1022587 | 65 | 691 | 4.220065 | 29.16064915 | Viruses | 10239 | Viruses | Viruses | 1184 | 0 | NTclustered | gi|1408257600|ref|NC_037663.1| | 2219109 | g63 | i0 | 97.678 | 8.01302460202605 | 689 | 16 | 99 | 0 | 3 | 691 | 3905 | 3217 | Botrytis cinerea hypovirus 1 satellite-like RNA, complete genome | blastn | 5537 | 1190 | 0.994957983193277 | Viruses | RNA satellites | Botrytis cinerea hypovirus 1 satellite-like RNA | |||||||
| 8085877 | 8085877 | PRJNA437204_P_NODE_44427_length_313_cov_1.283333_g44128_i0 | PRJNA437204 | 44427 | 313 | 1.283333 | 4.01683229 | Peony yellowing associated secovirus satellite RNA | 2800989 | Viruses | Viruses | 278 | 4.44e-70 | NTclustered | gi|1898324217|gb|MN259157.1| | 2800989 | g44128 | i0 | 85.036 | 0.875399361022364 | 274 | 39 | 87 | 2 | 1 | 273 | 538 | 810 | Peony yellowing associated secovirus satellite RNA strain BJ 31 kDa protein gene, complete cds | blastn | 274 | 278 | 1 | Viruses | RNA satellites | Peony yellowing associated secovirus satellite RNA | |||||||
| 9371426 | 9371426 | PRJNA473201_P_NODE_3008_length_1142_cov_12.420019_g2581_i0 | PRJNA473201 | 3008 | 1142 | 12.420019 | 141.83661698 | Peony yellowing associated secovirus satellite RNA | 2800989 | Viruses | Viruses | 1290 | 0 | NTclustered | gi|1898324217|gb|MN259157.1| | 2800989 | g2581 | i0 | 91.176 | 0.833625218914186 | 952 | 80 | 83 | 4 | 2 | 951 | 6 | 955 | Peony yellowing associated secovirus satellite RNA strain BJ 31 kDa protein gene, complete cds | blastn | 952 | 1290 | 1 | Viruses | RNA satellites | Peony yellowing associated secovirus satellite RNA | |||||||
| 10731967 | 10731967 | PRJNA556992_P_NODE_363569_length_280_cov_3.864734_g361380_i0 | PRJNA556992 | 363569 | 280 | 3.864734 | 10.8212552 | Cereal yellow dwarf virus-RPV satellite RNA | 191032 | Viruses | Viruses | 58.4 | 5.55e-4 | NTclustered | gi|323236|gb|M63666.1|BYDSATRNA | 191032 | g361380 | i0 | 86.538 | 1.825 | 52 | 7 | 19 | 0 | 3 | 54 | 196 | 247 | Cereal yellow dwarf virus-RPA satellite RNA | blastn | 511 | 58.4 | 1 | Viruses | RNA satellites | Cereal yellow dwarf virus-RPV satellite RNA | |||||||
| 13197300 | 13197300 | PRJNA473201_P_NODE_3411_length_1083_cov_14.568317_g2948_i0 | PRJNA473201 | 3411 | 1083 | 14.568317 | 157.77487311 | Peony yellowing associated secovirus satellite RNA | 2800989 | Viruses | Viruses | 708 | 0 | NTclustered | gi|1898324217|gb|MN259157.1| | 2800989 | g2948 | i0 | 83.462 | 0.797783933518006 | 780 | 109 | 71 | 13 | 20 | 793 | 34 | 799 | Peony yellowing associated secovirus satellite RNA strain BJ 31 kDa protein gene, complete cds | blastn | 864 | 708 | 1 | Viruses | RNA satellites | Peony yellowing associated secovirus satellite RNA | |||||||
| 14158112 | 14158112 | PRJEB64798_P_NODE_85432_length_213_cov_3.304878_g83666_i0 | PRJEB64798 | 85432 | 213 | 3.304878 | 7.03939014 | Solanum nodiflorum mottle virus satellite RNA | 195061 | Viruses | Viruses | 78.7 | 3.09e-10 | NTclustered | gi|332194|gb|J02386.1|MSNR2 | 195061 | g83666 | i0 | 100 | 0.981220657276995 | 42 | 0 | 20 | 0 | 4 | 45 | 49 | 90 | Solanum nodiflorum mottle virus satellite RNA | blastn | 209 | 78.7 | 1 | Viruses | RNA satellites | Solanum nodiflorum mottle virus satellite RNA | |||||||
| 14955941 | 14955941 | PRJNA946307_P_NODE_86092_length_190_cov_2.617021_g85218_i0 | PRJNA946307 | 86092 | 190 | 2.617021 | 4.9723399 | Sclerotinia sclerotiorum hypovirus 7 satellite-like RNA | 2822894 | Viruses | Viruses | 89.8 | 1.24e-13 | NTclustered | gi|2111886850|gb|MW454886.1| | 2822894 | g85218 | i0 | 85.714 | 0.442105263157895 | 84 | 12 | 44 | 0 | 84 | 167 | 118 | 201 | Sclerotinia sclerotiorum hypovirus 7 satellite-like RNA isolate GB375-3 hypothetical protein gene, complete cds | blastn | 84 | 89.8 | 1 | Viruses | RNA satellites | Sclerotinia sclerotiorum hypovirus 7 satellite-like RNA | |||||||
| 15160469 | 15160469 | PRJNA564013_P_NODE_278772_length_239_cov_6.505618_g275920_i0 | PRJNA564013 | 278772 | 239 | 6.505618 | 15.54842702 | Viruses | 10239 | Viruses | Viruses | 372 | 1.45e-98 | NTclustered | gi|1399050144|gb|MG554637.1| | 2219110 | g275920 | i0 | 99.034 | 10.9665271966527 | 207 | 2 | 87 | 0 | 6 | 212 | 1378 | 1172 | Botrytis cinerea hypovirus 1 satellite-like RNA-S, complete genome | blastn | 2621 | 375 | 0.992 | Viruses | RNA satellites | Botrytis cinerea hypovirus 1 satellite-like RNA-S | |||||||
| 16999846 | 16999846 | PRJNA421571_P_NODE_25434_length_671_cov_4.623746_g22961_i0 | PRJNA421571 | 25434 | 671 | 4.623746 | 31.02533566 | Peony yellowing associated secovirus satellite RNA | 2800989 | Viruses | Viruses | 488 | 4.2999999999999986e-133 | NTclustered | gi|1898324217|gb|MN259157.1| | 2800989 | g22961 | i0 | 83.554 | 0.788375558867362 | 529 | 80 | 78 | 6 | 1 | 525 | 430 | 955 | Peony yellowing associated secovirus satellite RNA strain BJ 31 kDa protein gene, complete cds | blastn | 529 | 488 | 1 | Viruses | RNA satellites | Peony yellowing associated secovirus satellite RNA | |||||||
| 17020959 | 17020959 | PRJNA473201_P_NODE_2894_length_1160_cov_14.457222_g2481_i0 | PRJNA473201 | 2894 | 1160 | 14.457222 | 167.7037752 | Peony yellowing associated secovirus satellite RNA | 2800989 | Viruses | Viruses | 1408 | 0 | NTclustered | gi|1898324217|gb|MN259157.1| | 2800989 | g2481 | i0 | 90.26 | 0.929310344827586 | 1078 | 104 | 93 | 1 | 2 | 1079 | 6 | 1082 | Peony yellowing associated secovirus satellite RNA strain BJ 31 kDa protein gene, complete cds | blastn | 1078 | 1408 | 1 | Viruses | RNA satellites | Peony yellowing associated secovirus satellite RNA | |||||||
| 18274478 | 18274478 | PRJNA421571_P_NODE_36495_length_503_cov_1.195349_g33952_i0 | PRJNA421571 | 36495 | 503 | 1.195349 | 6.01260547 | Peony yellowing associated secovirus satellite RNA | 2800989 | Viruses | Viruses | 104 | 1.34e-17 | NTclustered | gi|1898324217|gb|MN259157.1| | 2800989 | g33952 | i0 | 95.385 | 0.129224652087475 | 65 | 3 | 13 | 0 | 439 | 503 | 402 | 338 | Peony yellowing associated secovirus satellite RNA strain BJ 31 kDa protein gene, complete cds | blastn | 65 | 104 | 1 | Viruses | RNA satellites | Peony yellowing associated secovirus satellite RNA | |||||||
| 18733383 | 18733383 | PRJNA902848_P_NODE_14415_length_251_cov_0.876404_g14365_i0 | PRJNA902848 | 14415 | 251 | 0.876404 | 2.19977404 | Sclerotinia sclerotiorum hypovirus 7 satellite-like RNA | 2822894 | Viruses | Viruses | 108 | 4.79e-19 | NTclustered | gi|2111886850|gb|MW454886.1| | 2822894 | g14365 | i0 | 100 | 0.231075697211155 | 58 | 0 | 23 | 0 | 194 | 251 | 214 | 157 | Sclerotinia sclerotiorum hypovirus 7 satellite-like RNA isolate GB375-3 hypothetical protein gene, complete cds | blastn | 58 | 108 | 1 | Viruses | RNA satellites | Sclerotinia sclerotiorum hypovirus 7 satellite-like RNA | |||||||
| 20601782 | 20601782 | PRJNA1095825_P_NODE_238757_length_251_cov_0.865169_g235694_i0 | PRJNA1095825 | 238757 | 251 | 0.865169 | 2.17157419 | Sclerotinia sclerotiorum hypovirus 7 satellite-like RNA | 2822894 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2111886850|gb|MW454886.1| | 2822894 | g235694 | i0 | 100 | 0.115537848605578 | 29 | 0 | 12 | 0 | 1 | 29 | 60 | 88 | Sclerotinia sclerotiorum hypovirus 7 satellite-like RNA isolate GB375-3 hypothetical protein gene, complete cds | blastn | 29 | 54.7 | 1 | Viruses | RNA satellites | Sclerotinia sclerotiorum hypovirus 7 satellite-like RNA | |||||||
| 20845356 | 20845356 | PRJNA473201_P_NODE_3417_length_1082_cov_11.482656_g2954_i0 | PRJNA473201 | 3417 | 1082 | 11.482656 | 124.24233792 | Peony yellowing associated secovirus satellite RNA | 2800989 | Viruses | Viruses | 1476 | 0 | NTclustered | gi|1898324217|gb|MN259157.1| | 2800989 | g2954 | i0 | 91.381 | 0.997227356746765 | 1079 | 91 | 99 | 1 | 3 | 1081 | 1082 | 6 | Peony yellowing associated secovirus satellite RNA strain BJ 31 kDa protein gene, complete cds | blastn | 1079 | 1476 | 1 | Viruses | RNA satellites | Peony yellowing associated secovirus satellite RNA | |||||||
| 22120205 | 22120205 | PRJNA473201_P_NODE_3398_length_1085_cov_63.624506_g2939_i0 | PRJNA473201 | 3398 | 1085 | 63.624506 | 690.3258901 | Peony yellowing associated secovirus satellite RNA | 2800989 | Viruses | Viruses | 691 | 0 | NTclustered | gi|1898324217|gb|MN259157.1| | 2800989 | g2939 | i0 | 83.077 | 7.14285714285714 | 780 | 112 | 71 | 12 | 290 | 1063 | 799 | 34 | Peony yellowing associated secovirus satellite RNA strain BJ 31 kDa protein gene, complete cds | blastn | 7750 | 691 | 1 | Viruses | RNA satellites | Peony yellowing associated secovirus satellite RNA | |||||||
| 22288849 | 22288849 | PRJNA641707_P_NODE_143998_length_240_cov_10.979058_g141335_i0 | PRJNA641707 | 143998 | 240 | 10.979058 | 26.3497392 | Pea enation mosaic virus satellite RNA | 193119 | Viruses | Viruses | 183 | 7.339999999999998e-42 | NTclustered | gi|2329449768|gb|OP357955.1| | 193119 | g141335 | i0 | 100 | 9.41666666666667 | 99 | 0 | 79 | 0 | 1 | 99 | 266 | 168 | Pea enation mosaic virus satellite RNA isolate DSMZ PV-1362, complete sequence | blastn | 2260 | 183 | 1 | Viruses | RNA satellites | Pea enation mosaic virus satellite RNA | |||||||
| 22575922 | 22575922 | PRJNA923277_P_NODE_358_length_826_cov_29.632138_g278_i0 | PRJNA923277 | 358 | 826 | 29.632138 | 244.76145988 | Bamboo mosaic virus satellite RNA | 190811 | Viruses | Viruses | 1338 | 0 | NTclustered | gi|37782359|gb|AY205230.1| | 190811 | g278 | i0 | 95.995 | 99.7506053268765 | 824 | 32 | 99 | 1 | 1 | 824 | 14 | 836 | Satellite RNA of bamboo mosaic potexvirus isolate BSL2 P20 protein gene, complete cds | blastn | 82394 | 1338 | 1 | Viruses | RNA satellites | Bamboo mosaic virus satellite RNA | |||||||
| 24649751 | 24649751 | PRJNA421571_P_NODE_57140_length_351_cov_4.636691_g54591_i0 | PRJNA421571 | 57140 | 351 | 4.636691 | 16.27478541 | Peony yellowing associated secovirus satellite RNA | 2800989 | Viruses | Viruses | 359 | 1.75e-94 | NTclustered | gi|1898324217|gb|MN259157.1| | 2800989 | g54591 | i0 | 89.041 | 0.831908831908832 | 292 | 29 | 83 | 2 | 2 | 293 | 360 | 72 | Peony yellowing associated secovirus satellite RNA strain BJ 31 kDa protein gene, complete cds | blastn | 292 | 359 | 1 | Viruses | RNA satellites | Peony yellowing associated secovirus satellite RNA | |||||||
| 25115933 | 25115933 | PRJNA906294_P_NODE_91240_length_445_cov_8.137097_g87126_i0 | PRJNA906294 | 91240 | 445 | 8.137097 | 36.21008165 | Cnidiuim virus associated satellite | 3133206 | Viruses | Viruses | 337 | 1.0599999999999996e-87 | NTclustered | gi|2698750354|gb|PP486167.1| | 3133206 | g87126 | i0 | 80.574 | 5.92808988764045 | 453 | 75 | 99 | 12 | 2 | 444 | 5 | 454 | Cnidiuim virus associated satellite isolate Socheon-myeon Bonghwa 31 kDa protein gene, complete cds | blastn | 2638 | 337 | 1 | Viruses | RNA satellites | Cnidiuim virus associated satellite |
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);;