RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "blastn", bioproject = "PRJNA407886" and tax_phylum = "Kitrinoviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kitrinoviricota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJNA407886 · 18 ✖

analysis 1

  • blastn · 18 ✖

tax_clade 0

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
2968769 2968769 PRJNA407886_P_NODE_72843_length_248_cov_1.760000_g71149_i0 PRJNA407886 72843 248 1.76 4.3648 Capillovirus mali 28347 Viruses Viruses 401 1.9299999999999994e-107   NTclustered gi|381393149|gb|JQ308181.1| 28347 g71149 i0 95.951 99.5846774193548 247 10 99 0 1 247 4570 4816 Apple stem grooving virus isolate ASGV-CHN, complete genome blastn 24697 401 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Capillovirus Capillovirus mali
6794655 6794655 PRJNA407886_P_NODE_20366_length_562_cov_2.316973_g18681_i0 PRJNA407886 20366 562 2.316973 13.02138826 Capillovirus mali 28347 Viruses Viruses 756 0   NTclustered gi|1463747790|gb|MF616381.1| 28347 g18681 i0 90.925 48.6903914590747 562 51 100 0 1 562 2812 2251 Capillovirus mali isolate JLSG, complete genome blastn 27364 756 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Capillovirus Capillovirus mali
6795056 6795056 PRJNA407886_P_NODE_37606_length_360_cov_1.285714_g35912_i0 PRJNA407886 37606 360 1.285714 4.6285704 Capillovirus mali 28347 Viruses Viruses 544 4.6199999999999996e-150   NTclustered gi|1783301349|gb|MK599422.1| 28347 g35912 i0 93.889 30.7972222222222 360 22 100 0 1 360 4440 4081 Capillovirus mali isolate L3, complete genome blastn 11087 544 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Capillovirus Capillovirus mali
9346220 9346220 PRJNA407886_P_NODE_76768_length_245_cov_0.895349_g75074_i0 PRJNA407886 76768 245 0.895349 2.19360505 Capillovirus mali 28347 Viruses Viruses 368 1.93e-97   NTclustered gi|390994805|gb|JX080219.1| 28347 g75074 i0 93.852 21.9959183673469 244 15 99 0 2 245 290 47 Apple stem grooving virus isolate Aus-V2 movement protein and polyprotein genes, partial cds blastn 5389 368 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Capillovirus Capillovirus mali
13835808 13835808 PRJNA407886_P_NODE_52311_length_296_cov_2.331839_g50617_i0 PRJNA407886 52311 296 2.331839 6.90224344 Capillovirus 12174 Viruses Viruses 459 1.39e-124   NTclustered gi|1845308772|gb|MN495979.1| 28347 g50617 i0 94.595 100.027027027027 296 16 100 0 1 296 5658 5953 Capillovirus mali, complete genome blastn 29608 459 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Capillovirus Capillovirus mali
14446670 14446670 PRJNA407886_P_NODE_59152_length_276_cov_2.674877_g57458_i0 PRJNA407886 59152 276 2.674877 7.38266052 Trichovirus mali 12175 Viruses Viruses 364 2.869999999999999e-96   NTclustered gi|526455363|gb|KF134394.1| 12175 g57458 i0 90.545 95.3659420289855 275 26 99 0 1 275 273 547 Apple chlorotic leaf spot virus isolate FF coat protein gene, partial cds blastn 26321 364 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus mali
15719788 15719788 PRJNA407886_P_NODE_27073_length_450_cov_1.480106_g25380_i0 PRJNA407886 27073 450 1.480106 6.660477 Capillovirus mali 28347 Viruses Viruses 660 0   NTclustered gi|381393149|gb|JQ308181.1| 28347 g25380 i0 93.111 55.6111111111111 450 31 100 0 1 450 745 1194 Apple stem grooving virus isolate ASGV-CHN, complete genome blastn 25025 660 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Capillovirus Capillovirus mali
15720187 15720187 PRJNA407886_P_NODE_47633_length_313_cov_1.283333_g45939_i0 PRJNA407886 47633 313 1.283333 4.01683229 Capillovirus mali 28347 Viruses Viruses 512 1.12e-140   NTclustered gi|930068503|gb|KR106996.1| 28347 g45939 i0 96.166 97.8051118210863 313 12 100 0 1 313 6034 6346 Capillovirus mali isolate ASGV_kfp, complete genome blastn 30613 512 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Capillovirus Capillovirus mali
16995590 16995590 PRJNA407886_P_NODE_77354_length_244_cov_2.701754_g75660_i0 PRJNA407886 77354 244 2.701754 6.59227976 Capillovirus mali 28347 Viruses Viruses 412 8.759999999999998e-111   NTclustered gi|939193295|gb|KR185346.1| 28347 g75660 i0 97.51 98.7213114754098 241 6 99 0 4 244 5925 5685 Capillovirus mali isolate Cuiguan, complete genome blastn 24088 412 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Capillovirus Capillovirus mali
18268287 18268287 PRJNA407886_P_NODE_10355_length_959_cov_1.881490_g9050_i0 PRJNA407886 10355 959 1.88149 18.0434891 Capillovirus mali 28347 Viruses Viruses 1290 0   NTclustered gi|939193295|gb|KR185346.1| 28347 g9050 i0 90.928 47.6350364963504 959 87 100 0 1 959 3039 3997 Capillovirus mali isolate Cuiguan, complete genome blastn 45682 1290 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Capillovirus Capillovirus mali
19542735 19542735 PRJNA407886_P_NODE_19636_length_579_cov_1.563241_g17955_i0 PRJNA407886 19636 579 1.563241 9.05116539 Capillovirus mali 28347 Viruses Viruses 795 0   NTclustered gi|939193295|gb|KR185346.1| 28347 g17955 i0 92.171 96.5613126079447 562 44 97 0 1 562 5140 5701 Capillovirus mali isolate Cuiguan, complete genome blastn 55909 795 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Capillovirus Capillovirus mali
19542887 19542887 PRJNA407886_P_NODE_26836_length_453_cov_1.415789_g25144_i0 PRJNA407886 26836 453 1.415789 6.41352417 Capillovirus mali 28347 Viruses Viruses 606 7.469999999999996e-169   NTclustered gi|2842974839|gb|OR763046.1| 28347 g25144 i0 93.204 90.6578366445916 412 28 91 0 42 453 5557 5146 Capillovirus mali isolate A3, complete genome blastn 41068 606 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Capillovirus Capillovirus mali
20818741 20818741 PRJNA407886_P_NODE_26837_length_453_cov_1.410526_g25145_i0 PRJNA407886 26837 453 1.410526 6.38968278 Capillovirus mali 28347 Viruses Viruses 784 0   NTclustered gi|939193295|gb|KR185346.1| 28347 g25145 i0 98.004 99.3399558498896 451 9 99 0 1 451 5905 6355 Capillovirus mali isolate Cuiguan, complete genome blastn 45001 784 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Capillovirus Capillovirus mali
20819821 20819821 PRJNA407886_P_NODE_78857_length_243_cov_1.282353_g77163_i0 PRJNA407886 78857 243 1.282353 3.11611779 Capillovirus mali 28347 Viruses Viruses 372 1.48e-98   NTclustered gi|939193295|gb|KR185346.1| 28347 g77163 i0 94.583 2.92592592592593 240 13 99 0 1 240 751 990 Capillovirus mali isolate Cuiguan, complete genome blastn 711 372 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Capillovirus Capillovirus mali
23369335 23369335 PRJNA407886_P_NODE_35439_length_374_cov_1.521595_g33745_i0 PRJNA407886 35439 374 1.521595 5.6907653 Capillovirus mali 28347 Viruses Viruses 213 1.54e-50   NTclustered gi|1249614036|dbj|LC184612.1| 28347 g33745 i0 81.467 3.68181818181818 259 48 69 0 2 260 2828 3086 Apple stem grooving virus genomic RNA, complete genome, isolate: Nagami blastn 1377 213 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Capillovirus Capillovirus mali
23369411 23369411 PRJNA407886_P_NODE_39779_length_348_cov_1.010909_g38085_i0 PRJNA407886 39779 348 1.010909 3.51796332 Capillovirus mali 28347 Viruses Viruses 368 2.88e-97   NTclustered gi|939193295|gb|KR185346.1| 28347 g38085 i0 96.413 20.8563218390805 223 8 64 0 126 348 1230 1008 Capillovirus mali isolate Cuiguan, complete genome blastn 7258 368 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Capillovirus Capillovirus mali
23370198 23370198 PRJNA407886_P_NODE_77679_length_244_cov_1.350877_g75985_i0 PRJNA407886 77679 244 1.350877 3.29613988 Capillovirus mali 28347 Viruses Viruses 340 4.189999999999999e-89   NTclustered gi|939193295|gb|KR185346.1| 28347 g75985 i0 92.437 1.95081967213115 238 18 98 0 7 244 2461 2224 Capillovirus mali isolate Cuiguan, complete genome blastn 476 340 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Capillovirus Capillovirus mali
23370350 23370350 PRJNA407886_P_NODE_9519_length_1019_cov_2.165962_g8306_i0 PRJNA407886 9519 1019 2.165962 22.07115278 Capillovirus mali 28347 Viruses Viruses 1448 0   NTclustered gi|939193295|gb|KR185346.1| 28347 g8306 i0 92.338 99.7939156035329 1018 78 99 0 2 1019 5174 4157 Capillovirus mali isolate Cuiguan, complete genome blastn 101690 1448 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Capillovirus Capillovirus mali

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;