RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA498309" and tax_phylum = "Duplornaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Duplornaviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA498309 · 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
1755118 1755118 PRJNA498309_P_NODE_108842_length_175_cov_1.659420_g106693_i0 PRJNA498309 108842 175 1.65942 2.903985 Chemarfal virus 260 3063286 Viruses Viruses 313 6.13e-81   NTclustered gi|2626079958|gb|OR270550.1| 3063286 g106693 i0 98.857 1 175 2 100 0 1 175 1070 1244 MAG: Chemarfal virus 260 isolate ML188 genomic sequence blastn 175 313 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales     Chemarfal virus 260
13234713 13234713 PRJNA498309_P_NODE_50151_length_375_cov_10.130178_g48006_i0 PRJNA498309 50151 375 10.130178 37.9881675 Malassezia restricta associated totivirus 2 3048758 Viruses Viruses 599 1.0199999999999998e-166   NTclustered gi|2512878154|emb|OX637980.1| 3048758 g48006 i0 99.694 0.872 327 1 87 0 22 348 144 470 Malassezia restricta associated totivirus 2 CP gene for capsid protein blastn 327 599 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Malassezia restricta associated totivirus 2
17058035 17058035 PRJNA498309_P_NODE_36914_length_460_cov_2.680851_g34851_i0 PRJNA498309 36914 460 2.680851 12.3319146 Totiviridae sp. 1955172 Viruses Viruses 231 5.3399999999999985e-56   NTclustered gi|2396038768|gb|ON812661.1| 1955172 g34851 i0 79.63 2.34565217391304 324 64 70 2 91 413 4524 4202 MAG: Totiviridae sp. isolate TIGMIC_4, complete genome blastn 1079 231 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Totiviridae sp.
19608364 19608364 PRJNA498309_S_NODE_40596_length_209_cov_3.557471_g38428_i0 PRJNA498309 40596 209 3.557471 7.43511439 Malassezia restricta virus MrV40L 2727863 Viruses Viruses 340 3.49e-89   NTclustered gi|1832308141|gb|MN603497.1| 2727863 g38428 i0 99.465 1.26794258373206 187 1 89 0 1 187 387 201 Malassezia restricta virus MrV40L, complete genome blastn 265 340 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Malassezia restricta virus MrV40L
22158731 22158731 PRJNA498309_S_NODE_25238_length_365_cov_2.821212_g23070_i0 PRJNA498309 25238 365 2.821212 10.2974238 Malassezia restricta virus MrV40L 2727863 Viruses Viruses 606 5.9e-169   NTclustered gi|1832308141|gb|MN603497.1| 2727863 g23070 i0 98.542 1.18630136986301 343 5 94 0 23 365 919 577 Malassezia restricta virus MrV40L, complete genome blastn 433 606 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Malassezia restricta virus MrV40L
23433574 23433574 PRJNA498309_P_NODE_63779_length_311_cov_1.218978_g61631_i0 PRJNA498309 63779 311 1.218978 3.79102158 Malassezia restricta virus MrV40L 2727863 Viruses Viruses 520 6.629999999999998e-143   NTclustered gi|1832308141|gb|MN603497.1| 2727863 g61631 i0 96.785 1.66881028938907 311 10 100 0 1 311 459 769 Malassezia restricta virus MrV40L, complete genome blastn 519 520 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Malassezia restricta virus MrV40L

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