RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA493827" and tax_phylum = "Kitrinoviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kitrinoviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA493827 · 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
8124762 8124762 PRJNA493827_P_NODE_202807_length_247_cov_0.885057_g200609_i0 PRJNA493827 202807 247 0.885057 2.18609079 Erysiphe necator associated deltaflexivirus 3 2743096 Viruses Viruses 268 2.04e-67   NTclustered gi|1851774021|gb|MN627465.1| 2743096 g200609 i0 86.235 1 247 34 100 0 1 247 3066 3312 Erysiphe necator associated deltaflexivirus 3 isolate PMS3_168, complete genome blastn 247 268 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Deltaflexiviridae Deltaflexivirus Erysiphe necator associated deltaflexivirus 3
9397906 9397906 PRJNA493827_P_NODE_116968_length_316_cov_1.267490_g114770_i0 PRJNA493827 116968 316 1.26749 4.0052684 Erysiphe necator associated deltaflexivirus 3 2743096 Viruses Viruses 215 3.57e-51   NTclustered gi|1851774021|gb|MN627465.1| 2743096 g114770 i0 87.568 0.585443037974684 185 23 59 0 132 316 516 700 Erysiphe necator associated deltaflexivirus 3 isolate PMS3_168, complete genome blastn 185 215 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Deltaflexiviridae Deltaflexivirus Erysiphe necator associated deltaflexivirus 3
10033262 10033262 PRJNA493827_P_NODE_136008_length_293_cov_1.050000_g133810_i0 PRJNA493827 136008 293 1.05 3.0765 Tobamovirus 12234 Viruses Viruses 531 2.86e-146   NTclustered gi|388240205|emb|HE818430.1| 12242 g133810 i0 99.317 99.8668941979522 293 2 100 0 1 293 1933 1641 Tobacco mosaic virus isolate Huidong, complete genome blastn 29261 531 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus tabaci
19599157 19599157 PRJNA493827_P_NODE_52296_length_492_cov_0.904535_g50106_i0 PRJNA493827 52296 492 0.904535 4.4503122 Erysiphe necator associated deltaflexivirus 3 2743096 Viruses Viruses 438 3.149999999999999e-118   NTclustered gi|1851774021|gb|MN627465.1| 2743096 g50106 i0 84.13 0.934959349593496 460 66 92 6 38 492 7385 6928 Erysiphe necator associated deltaflexivirus 3 isolate PMS3_168, complete genome blastn 460 438 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Deltaflexiviridae Deltaflexivirus Erysiphe necator associated deltaflexivirus 3
20871327 20871327 PRJNA493827_P_NODE_104837_length_334_cov_1.750958_g102639_i0 PRJNA493827 104837 334 1.750958 5.84819972 Deltaflexivirus sclerotiniae 3428204 Viruses Viruses 244 4.84e-60   NTclustered gi|2219865456|gb|OK001448.1| 1788309 g102639 i0 80.428 0.979041916167665 327 58 97 3 1 324 4138 4461 Sclerotinia sclerotiorum deltaflexivirus 1 isolate SCH941, complete genome blastn 327 244 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Deltaflexiviridae Deltaflexivirus Deltaflexivirus sclerotiniae
20874897 20874897 PRJNA493827_P_NODE_49097_length_510_cov_2.665904_g46907_i0 PRJNA493827 49097 510 2.665904 13.5961104 Crinivirus ipomeae 3428114 Viruses Viruses 52.8 0.05   NTclustered gi|2073490320|gb|MW260351.1| 81931 g46907 i0 100 0.219607843137255 28 0 5 0 420 447 4059 4086 Sweet potato chlorotic stunt virus isolate 19-2043_2 segment 1 polyprotein (p227), RNA-dependent RNA polymerase (RdRp), suppressor of RNA silencing (RNaseIII), and hypothetical protein (p7) genes, complete cds blastn 112 52.8 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae Crinivirus Crinivirus ipomeae

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