RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1199893" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 4 ✖

tax_phylum 1

tax_kingdom 1

bioproject 1

  • PRJNA1199893 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
3595174 3595174 PRJNA1199893_P_NODE_6543_length_376_cov_1.429043_g6469_i0 PRJNA1199893 6543 376 1.429043 5.37320168 Fabavirus 12269 Viruses Viruses 573 6.179999999999999e-159   NTclustered gi|402123137|gb|JX183225.1| 76875 g6469 i0 94.823 29.4202127659574 367 19 98 0 9 375 4670 4304 Broad bean wilt virus 2 isolate RP3 segment RNA1, complete sequence blastn 11062 573 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Fabavirus betaviciae
5429941 5429941 PRJNA1199893_P_NODE_16745_length_243_cov_0.905882_g16670_i0 PRJNA1199893 16745 243 0.905882 2.20129326 Potyvirus yituberosi 3240642 Viruses Viruses 444 3.09e-120   NTclustered gi|1231942940|gb|KX688601.1| 12216 g16670 i0 99.588 100 243 1 100 0 1 243 7138 7380 Potato virus Y isolate INM-W-369-12, complete genome blastn 24300 444 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus yituberosi
11805292 11805292 PRJNA1199893_P_NODE_15410_length_247_cov_0.885057_g15335_i0 PRJNA1199893 15410 247 0.885057 2.18609079 Fabavirus betaviciae 3047702 Viruses Viruses 366 7.02e-97   NTclustered gi|719762958|gb|KM076648.1| 76875 g15335 i0 93.496 19.0161943319838 246 16 99 0 1 246 3859 4104 Broad bean wilt virus 2 isolate LS2 segment RNA1, complete sequence blastn 4697 366 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Fabavirus betaviciae
15629711 15629711 PRJNA1199893_P_NODE_6013_length_392_cov_1.178683_g5939_i0 PRJNA1199893 6013 392 1.178683 4.62043736 Potyvirus yituberosi 3240642 Viruses Viruses 704 0   NTclustered gi|1877819235|gb|MN607724.1| 12216 g5939 i0 99.483 98.6862244897959 387 2 99 0 6 392 8887 8501 Potato virus Y isolate NMG-6 polyprotein gene, complete cds blastn 38685 704 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus yituberosi

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