RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJDB4470" and tax_phylum = "Duplornaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Duplornaviricota · 2 ✖

tax_kingdom 1

bioproject 1

  • PRJDB4470 · 2 ✖

analysis 1

  • blastn · 2 ✖

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
2559428 2559428 PRJDB4470_P_NODE_48023_length_299_cov_1.784000_g46870_i0 PRJDB4470 48023 299 1.784 5.33416 Skokie reo-like virus 2789444 Viruses Viruses 494 3.84e-135   NTclustered gi|1933757587|gb|MW177748.1| 2789444 g46870 i0 97.895 0.953177257525084 285 6 95 0 15 299 193 477 Skokie reo-like virus strain USAdf hypothetical protein 2 gene, complete cds blastn 285 494 1 Viruses   Orthornavirae Duplornaviricota Resentoviricetes Reovirales     Skokie reo-like virus
7661971 7661971 PRJDB4470_P_NODE_58707_length_254_cov_2.429268_g57552_i0 PRJDB4470 58707 254 2.429268 6.17034072 Alphachrysovirus perseae 2955248 Viruses Viruses 433 7.05e-117   NTclustered gi|1694999054|ref|NC_043506.1| 1587509 g57552 i0 100 0.921259842519685 234 0 92 0 1 234 2839 2606 Persea americana chrysovirus segment RNA1, complete sequence blastn 234 433 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Chrysoviridae Alphachrysovirus Alphachrysovirus perseae

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