RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1067370" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1067370 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
5283824 5283824 PRJNA1067370_P_NODE_66945_length_269_cov_1.571429_g66396_i0 PRJNA1067370 66945 269 1.571429 4.22714401 Polerovirus PLRV 3431772 Viruses Viruses 497 2.63e-136   NTclustered gi|1480117866|gb|MG356502.1| 12045 g66396 i0 100 99.9925650557621 269 0 100 0 1 269 3736 4004 Potato leafroll virus isolate PLRV165, complete genome blastn 26898 497 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae Polerovirus Polerovirus PLRV
7833252 7833252 PRJNA1067370_P_NODE_16887_length_453_cov_1.052632_g16339_i0 PRJNA1067370 16887 453 1.052632 4.76842296 Potyvirus batataplumei 3240478 Viruses Viruses 826 0   NTclustered gi|765527324|gb|KP115610.1| 12844 g16339 i0 99.558 100.105960264901 453 2 100 0 1 453 10013 10465 Sweet potato feathery mottle virus isolate IS90, complete genome blastn 45348 826 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus batataplumei
9108192 9108192 PRJNA1067370_P_NODE_11208_length_545_cov_1.169492_g10666_i0 PRJNA1067370 11208 545 1.169492 6.3737314 Potyvirus batataplumei 3240478 Viruses Viruses 970 0   NTclustered gi|765527324|gb|KP115610.1| 12844 g10666 i0 98.895 99.9449541284404 543 6 99 0 3 545 8088 8630 Sweet potato feathery mottle virus isolate IS90, complete genome blastn 54470 970 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus batataplumei
14209555 14209555 PRJNA1067370_P_NODE_38792_length_323_cov_1.064000_g38244_i0 PRJNA1067370 38792 323 1.064 3.43672 Potyvirus batataplumei 3240478 Viruses Viruses 592 1.4499999999999999e-164   NTclustered gi|765527324|gb|KP115610.1| 12844 g38244 i0 99.69 99.4860681114551 323 1 100 0 1 323 9098 8776 Sweet potato feathery mottle virus isolate IS90, complete genome blastn 32134 592 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus batataplumei
16757985 16757985 PRJNA1067370_P_NODE_73574_length_259_cov_1.655914_g73025_i0 PRJNA1067370 73574 259 1.655914 4.28881726 Polerovirus PLRV 3431772 Viruses Viruses 468 1.98e-127   NTclustered gi|1377542796|gb|MF062487.1| 12045 g73025 i0 99.228 99.953667953668 259 2 100 0 1 259 5285 5027 Potato leafroll virus isolate EP, complete genome blastn 25888 468 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae Polerovirus Polerovirus PLRV
23132954 23132954 PRJNA1067370_P_NODE_14559_length_484_cov_1.114355_g14012_i0 PRJNA1067370 14559 484 1.114355 5.3934782 Potyvirus batataplumei 3240478 Viruses Viruses 867 0   NTclustered gi|765527324|gb|KP115610.1| 12844 g14012 i0 98.967 99.9276859504132 484 5 100 0 1 484 9570 9087 Sweet potato feathery mottle virus isolate IS90, complete genome blastn 48365 867 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus batataplumei

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