RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA879067", tax_phylum = "Duplornaviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 6 ✖

tax_phylum 1

  • Duplornaviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA879067 · 6 ✖

analysis 1

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
2131266 2131266 PRJNA879067_P_NODE_73422_length_370_cov_1.797980_g69937_i0 PRJNA879067 73422 370 1.79798 6.652526 Coltivirus dermacentoris 3428066 Viruses Viruses 562 1.31e-155   NTclustered gi|2758887253|gb|PP473574.1| 46839 g69937 i0 96.746 40.0702702702703 338 9 91 2 20 356 4826 4490 MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence blastn 14826 562 1 Viruses   Orthornavirae Duplornaviricota Resentoviricetes Reovirales Spinareoviridae Coltivirus Coltivirus dermacentoris
5958354 5958354 PRJNA879067_P_NODE_44245_length_577_cov_7.464286_g40784_i0 PRJNA879067 44245 577 7.464286 43.06893022 Skokie reo-like virus 2789444 Viruses Viruses 54.7 0.016   NTclustered gi|1940198086|gb|MT757475.1| 2789444 g40784 i0 100 0.0502599653379549 29 0 5 0 549 577 2965 2993 Skokie reo-like virus strain CHNdf-1 hypothetical protein gene, partial cds blastn 29 54.7 1 Viruses   Orthornavirae Duplornaviricota Resentoviricetes Reovirales     Skokie reo-like virus
8509132 8509132 PRJNA879067_P_NODE_84167_length_321_cov_3.487903_g80681_i0 PRJNA879067 84167 321 3.487903 11.19616863 Skokie reo-like virus 2789444 Viruses Viruses 52.8 0.03   NTclustered gi|1940198086|gb|MT757475.1| 2789444 g80681 i0 100 0.0872274143302181 28 0 9 0 1 28 2993 2966 Skokie reo-like virus strain CHNdf-1 hypothetical protein gene, partial cds blastn 28 52.8 1 Viruses   Orthornavirae Duplornaviricota Resentoviricetes Reovirales     Skokie reo-like virus
14883509 14883509 PRJNA879067_P_NODE_57632_length_466_cov_1.872774_g54147_i0 PRJNA879067 57632 466 1.872774 8.72712684 Skokie reo-like virus 2789444 Viruses Viruses 52.8 0.045   NTclustered gi|1940198086|gb|MT757475.1| 2789444 g54147 i0 100 0.0600858369098712 28 0 6 0 439 466 2966 2993 Skokie reo-like virus strain CHNdf-1 hypothetical protein gene, partial cds blastn 28 52.8 1 Viruses   Orthornavirae Duplornaviricota Resentoviricetes Reovirales     Skokie reo-like virus
19980525 19980525 PRJNA879067_P_NODE_108596_length_244_cov_0.900585_g105110_i0 PRJNA879067 108596 244 0.900585 2.1974274 Chemarfal virus 260 3063286 Viruses Viruses 348 2.51e-91   NTclustered gi|2626079958|gb|OR270550.1| 3063286 g105110 i0 94.273 0.930327868852459 227 13 93 0 17 243 1059 1285 MAG: Chemarfal virus 260 isolate ML188 genomic sequence blastn 227 348 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales     Chemarfal virus 260
21255882 21255882 PRJNA879067_P_NODE_107377_length_246_cov_0.884393_g103891_i0 PRJNA879067 107377 246 0.884393 2.17560678 Skokie reo-like virus 2789444 Viruses Viruses 54.7 0.006   NTclustered gi|1940198086|gb|MT757475.1| 2789444 g103891 i0 100 0.117886178861789 29 0 12 0 218 246 2966 2994 Skokie reo-like virus strain CHNdf-1 hypothetical protein gene, partial cds blastn 29 54.7 1 Viruses   Orthornavirae Duplornaviricota Resentoviricetes Reovirales     Skokie reo-like virus

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