RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA1122875", tax_phylum = "Kitrinoviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 15 ✖

tax_phylum 1

  • Kitrinoviricota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1122875 · 15 ✖

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
277552 277552 PRJNA1122875_P_NODE_1_length_7435_cov_16.765145_g0_i0 PRJNA1122875 1 7435 16.765145 1246.48853075 Camellia ringspot associated virus 3 2606571 Viruses Viruses 10595 0   NTclustered gi|1732260873|gb|MK050796.1| 2606571 g0 i0 92.444 2.11956960322798 7425 551 99 7 8 7430 7429 13 Camellia ringspot associated virus 3 isolate CJ5_807, complete genome blastn 15759 10595 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae   Camellia ringspot associated virus 3
277581 277581 PRJNA1122875_P_NODE_22721_length_348_cov_1.854545_g22497_i0 PRJNA1122875 22721 348 1.854545 6.4538166 Carlavirus lilii 3427777 Viruses Viruses 638 1.99e-178   NTclustered gi|2246792753|gb|MT882680.1| 12173 g22497 i0 99.713 26.9942528735632 348 1 100 0 1 348 191 538 Lily symptomless virus isolate L-B4 RNA-dependent RNA polymerase (RdRp), triple gene block protein 1 (tgb1), triple gene block protein 2 (tgb2), triple gene block protein 3 (tgb3), coat protein (cp), and 16 kDa protein (16kDa) genes, complete cds blastn 9394 638 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus lilii
1552378 1552378 PRJNA1122875_P_NODE_4482_length_731_cov_0.975684_g4282_i0 PRJNA1122875 4482 731 0.975684 7.13225004 Carlavirus lilii 3427777 Viruses Viruses 1256 0   NTclustered gi|2430128996|gb|OM311167.1| 12173 g4282 i0 97.802 19.922024623803 728 16 99 0 1 728 1861 2588 Lily symptomless virus isolate LSV/BJ-3, complete genome blastn 14563 1256 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus lilii
2828219 2828219 PRJNA1122875_P_NODE_24323_length_337_cov_1.261364_g24099_i0 PRJNA1122875 24323 337 1.261364 4.25079668 Carlavirus lilii 3427777 Viruses Viruses 601 2.52e-167   NTclustered gi|146188487|emb|AM263208.1| 12173 g24099 i0 98.813 20.4718100890208 337 4 100 0 1 337 3658 3994 Lily symptomless virus complete genome, isolate SMi blastn 6899 601 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus lilii
6655378 6655378 PRJNA1122875_P_NODE_226_length_1753_cov_1.948214_g190_i0 PRJNA1122875 226 1753 1.948214 34.15219142 Camellia ringspot associated virus 2 2606570 Viruses Viruses 1991 0   NTclustered gi|1732260861|gb|MK050793.1| 2606570 g190 i0 87.172 8.62635482030804 1754 223 100 2 1 1753 4961 6713 Camellia ringspot associated virus 2 isolate CJ5-6003, complete genome blastn 15122 1991 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae   Camellia ringspot associated virus 2
7930420 7930420 PRJNA1122875_P_NODE_20147_length_371_cov_1.540268_g19923_i0 PRJNA1122875 20147 371 1.540268 5.71439428 Carlavirus lilii 3427777 Viruses Viruses 630 3.5599999999999985e-176   NTclustered gi|289467474|gb|GU440579.1| 12173 g19923 i0 97.305 19.9865229110512 371 10 100 0 1 371 3041 3411 Lily symptomless virus isolate LSV-jj, complete genome blastn 7415 630 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus lilii
9205573 9205573 PRJNA1122875_P_NODE_26988_length_318_cov_1.175510_g26764_i0 PRJNA1122875 26988 318 1.17551 3.7381218 Carlavirus lilii 3427777 Viruses Viruses 555 1.8599999999999998e-153   NTclustered gi|61273|emb|X15343.1| 12173 g26764 i0 98.113 40.8270440251572 318 6 100 0 1 318 1473 1156 Lily symptomless virus RNA 3-terminal region encoding 25kD, 12kD, 7kD, 16kD proteins and 32kD coat protein blastn 12983 555 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus lilii
9205931 9205931 PRJNA1122875_P_NODE_68_length_2396_cov_4.247955_g51_i0 PRJNA1122875 68 2396 4.247955 101.7810018 Carlavirus lilii 3427777 Viruses Viruses 4248 0   NTclustered gi|61273|emb|X15343.1| 12173 g51 i0 98.664 48.093489148581 2396 32 100 0 1 2396 2573 178 Lily symptomless virus RNA 3-terminal region encoding 25kD, 12kD, 7kD, 16kD proteins and 32kD coat protein blastn 115232 4248 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus lilii
14306329 14306329 PRJNA1122875_P_NODE_16212_length_415_cov_1.532164_g15988_i0 PRJNA1122875 16212 415 1.532164 6.3584806 Carlavirus lilii 3427777 Viruses Viruses 726 0   NTclustered gi|2246792767|gb|MT882682.1| 12173 g15988 i0 98.309 26.9397590361446 414 7 99 0 1 414 1037 624 Lily symptomless virus isolate L-D9 RNA-dependent RNA polymerase (RdRp), triple gene block protein 1 (tgb1), triple gene block protein 2 (tgb2), triple gene block protein 3 (tgb3), coat protein (cp), and 16 kDa protein (16kDa) genes, complete cds blastn 11180 726 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus lilii
19403560 19403560 PRJNA1122875_P_NODE_356_length_1577_cov_1.425532_g311_i0 PRJNA1122875 356 1577 1.425532 22.48063964 Carlavirus lilii 3427777 Viruses Viruses 2808 0   NTclustered gi|37674199|ref|NC_005138.1| 12173 g311 i0 98.795 23.147114774889 1577 19 100 0 1 1577 4150 5726 Lily symptomless virus, complete genome blastn 36503 2808 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus lilii
20678947 20678947 PRJNA1122875_P_NODE_20637_length_367_cov_0.952381_g20413_i0 PRJNA1122875 20637 367 0.952381 3.49523827 Carlavirus lilii 3427777 Viruses Viruses 667 0   NTclustered gi|37674199|ref|NC_005138.1| 12173 g20413 i0 99.455 20.0054495912807 367 2 100 0 1 367 2669 3035 Lily symptomless virus, complete genome blastn 7342 667 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus lilii
20679319 20679319 PRJNA1122875_P_NODE_52017_length_243_cov_0.888235_g51793_i0 PRJNA1122875 52017 243 0.888235 2.15841105 Cucumovirus CMV 3428131 Viruses Viruses 414 2.4299999999999998e-111   NTclustered gi|2644120974|gb|OR916009.1| 12305 g51793 i0 97.521 99.1069958847737 242 6 99 0 2 243 1406 1165 Cucumber mosaic virus isolate DHH segment RNA1, complete sequence blastn 24083 414 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Bromoviridae Cucumovirus Cucumovirus CMV
23230245 23230245 PRJNA1122875_P_NODE_6439_length_630_cov_1.793537_g6223_i0 PRJNA1122875 6439 630 1.793537 11.2992831 Camellia ringspot associated virus 2 2606570 Viruses Viruses 859 0   NTclustered gi|1732260861|gb|MK050793.1| 2606570 g6223 i0 91.27 7.78888888888889 630 55 100 0 1 630 6787 7416 Camellia ringspot associated virus 2 isolate CJ5-6003, complete genome blastn 4907 859 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae   Camellia ringspot associated virus 2
26901327 26901327 PRJNA1122875_P_NODE_40821_length_259_cov_1.430108_g40597_i0 PRJNA1122875 40821 259 1.430108 3.70397972 Viruses 10239 Viruses Viruses 167 1.02e-45   NR QGX73514.1 2686012 g40597 i0 93 2.97683397683398 86 6 99.6 0 2 259 609 694 QGX73514.1 RNA dependent RNA polymerase [Camellia japonica associated betaflexivirus 2] diamond 771 167 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae   Camellia japonica associated betaflexivirus 2
32714532 32714532 PRJNA1122875_P_NODE_21420_length_359_cov_1.244755_g21196_i0 PRJNA1122875 21420 359 1.244755 4.46867045 Viruses 10239 Viruses Viruses 218 3.58e-63   NR QEJ80628.1 2606570 g21196 i0 86.6 2.98328690807799 119 16 99.4 0 2 358 671 789 QEJ80628.1 replicase [Camellia ringspot associated virus 2] diamond 1071 218 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae   Camellia ringspot associated virus 2

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