RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA565584", tax_phylum = "Duplornaviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 3 ✖

tax_phylum 1

  • Duplornaviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA565584 · 3 ✖

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
1832982 1832982 PRJNA565584_P_NODE_742_length_4335_cov_64.441107_g592_i0 PRJNA565584 742 4335 64.441107 2793.52198845 Pseudomonas phage ER16 2917704 Viruses Viruses 99 5.73e-15   NTclustered gi|2209092821|gb|OM650249.1| 2917704 g592 i0 87.5 0.0202998846597463 88 8 2 3 4219 4306 156 72 Pseudomonas phage ER16 segment M, complete sequence blastn 88 99 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae   Pseudomonas phage ER16
4384240 4384240 PRJNA565584_P_NODE_344_length_6500_cov_20.218142_g251_i0 PRJNA565584 344 6500 20.218142 1314.17923 Red mite associated cystovirus 2936548 Viruses Viruses 11956 0   NTclustered gi|2239998150|gb|ON160022.1| 2936548 g251 i0 100 1.89492307692308 6474 0 99 0 1 6474 3 6476 Red mite associated cystovirus isolate RMACTV1-L P14, P15, P7, P2, P4, and P1 genes, complete cds blastn 12317 11956 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Cystovirus Red mite associated cystovirus
8209126 8209126 PRJNA565584_P_NODE_2067_length_2360_cov_299.196327_g1778_i0 PRJNA565584 2067 2360 299.196327 7061.0333172 Red mite associated cystovirus 2936548 Viruses Viruses 4344 0   NTclustered gi|2239998157|gb|ON160023.1| 2936548 g1778 i0 100 1.66694915254237 2352 0 99 0 9 2360 2352 1 Red mite associated cystovirus isolate RMACTV1-S P8, P12, P9, and P5 genes, complete cds blastn 3934 4344 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Cystovirus Red mite associated cystovirus

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