RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA515078" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Orthornavirae · 10 ✖

bioproject 1

  • PRJNA515078 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
4939249 4939249 PRJNA515078_P_NODE_4724_length_440_cov_1.451613_g4491_i0 PRJNA515078 4724 440 1.451613 6.3870972 root 1 Root_unresolved Root_unresolved 811 0   NTclustered gi|1803061242|dbj|LC375022.1| 12211 g4491 i0 100 99.7681818181818 439 0 99 0 1 439 7917 8355 Plum pox virus PPV-D Kg5 genomic RNA, complete genome blastn 43898 811 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus plumpoxi
10039528 10039528 PRJNA515078_P_NODE_608_length_1207_cov_5.194872_g521_i0 PRJNA515078 608 1207 5.194872 62.70210504 root 1 Root_unresolved Root_unresolved 2230 0   NTclustered gi|333301|gb|M21847.1|PPVCPOL 12211 g521 i0 100 99.1267605633803 1207 0 100 0 1 1207 2852 1646 Plum pox potyvirus (PPV) capsid protein and RNA polymerase genes, complete cds blastn 119646 2230 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus plumpoxi
12589879 12589879 PRJNA515078_P_NODE_18030_length_205_cov_1.392857_g17797_i0 PRJNA515078 18030 205 1.392857 2.85535685 root 1 Root_unresolved Root_unresolved 379 7.229999999999999e-101   NTclustered gi|1803061108|dbj|LC374955.1| 12211 g17797 i0 100 100 205 0 100 0 1 205 5851 6055 Plum pox virus PPV-D Ad2 genomic RNA, complete genome blastn 20500 379 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus plumpoxi
13864713 13864713 PRJNA515078_P_NODE_18611_length_201_cov_1.621951_g18378_i0 PRJNA515078 18611 201 1.621951 3.26012151 root 1 Root_unresolved Root_unresolved 372 1.18e-98   NTclustered gi|333303|gb|M26965.1|PPVNIAPRO 12211 g18378 i0 100 100 201 0 100 0 1 201 855 1055 Plum pox potyvirus ORF containing NI-a-like protein mRNA, partial cds blastn 20100 372 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus plumpoxi
13864741 13864741 PRJNA515078_P_NODE_25871_length_171_cov_1.164179_g25638_i0 PRJNA515078 25871 171 1.164179 1.99074609 root 1 Root_unresolved Root_unresolved 316 4.6e-82   NTclustered gi|1803061751|dbj|LC375125.1| 12211 g25638 i0 100 100 171 0 100 0 1 171 6890 6720 Plum pox virus PPV-D Wa7 genomic RNA, complete genome blastn 17100 316 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus plumpoxi
15789501 15789501 PRJNA515078_P_NODE_16593_length_214_cov_1.502825_g16360_i0 PRJNA515078 16593 214 1.502825 3.2160455 Potyvirus euphorbiae 3240527 Viruses Viruses 381 2.1199999999999995e-101   NTclustered gi|1079485077|ref|NC_031339.1| 291286 g16360 i0 98.598 3 214 3 100 0 1 214 8747 8534 Euphorbia ringspot virus isolate PV-0902, complete genome blastn 642 381 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus euphorbiae
18338479 18338479 PRJNA515078_P_NODE_18835_length_200_cov_1.429448_g18602_i0 PRJNA515078 18835 200 1.429448 2.858896 Potyvirus euphorbiae 3240527 Viruses Viruses 364 1.96e-96   NTclustered gi|1079485077|ref|NC_031339.1| 291286 g18602 i0 99.5 3 200 1 100 0 1 200 8990 9189 Euphorbia ringspot virus isolate PV-0902, complete genome blastn 600 364 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus euphorbiae
19612956 19612956 PRJNA515078_P_NODE_31936_length_155_cov_1.644068_g31703_i0 PRJNA515078 31936 155 1.644068 2.5483054 Potyvirus euphorbiae 3240527 Viruses Viruses 287 3.21e-73   NTclustered gi|1079485077|ref|NC_031339.1| 291286 g31703 i0 100 5 155 0 100 0 1 155 9529 9683 Euphorbia ringspot virus isolate PV-0902, complete genome blastn 775 287 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus euphorbiae
20237412 20237412 PRJNA515078_P_NODE_30176_length_159_cov_1.278689_g29943_i0 PRJNA515078 30176 159 1.278689 2.03311551 root 1 Root_unresolved Root_unresolved 294 1.98e-75   NTclustered gi|1803061108|dbj|LC374955.1| 12211 g29943 i0 100 100 159 0 100 0 1 159 7577 7419 Plum pox virus PPV-D Ad2 genomic RNA, complete genome blastn 15900 294 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus plumpoxi
24712950 24712950 PRJNA515078_P_NODE_28240_length_164_cov_1.228346_g28007_i0 PRJNA515078 28240 164 1.228346 2.01448744 Potyvirus euphorbiae 3240527 Viruses Viruses 303 3.42e-78   NTclustered gi|1079485077|ref|NC_031339.1| 291286 g28007 i0 100 2 164 0 100 0 1 164 368 205 Euphorbia ringspot virus isolate PV-0902, complete genome blastn 328 303 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus euphorbiae

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