RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJNA541476", tax_kingdom = "Orthornavirae" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 2 ✖

tax_kingdom 1

  • Orthornavirae · 2 ✖

bioproject 1

  • PRJNA541476 · 2 ✖

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
15812037 15812037 PRJNA541476_P_NODE_5553_length_481_cov_2.968137_g5351_i0 PRJNA541476 5553 481 2.968137 14.27673897 Shenzhen dicistro-like virus 2789378 Viruses Viruses 817 0   NTclustered gi|1940198121|gb|MT757492.1| 2789378 g5351 i0 97.297 2.77754677754678 481 13 100 0 1 481 8600 8120 Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds blastn 1336 817 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Shenzhen dicistro-like virus
18360819 18360819 PRJNA541476_P_NODE_7735_length_406_cov_3.426426_g7531_i0 PRJNA541476 7735 406 3.426426 13.91128956 Shenzhen dicistro-like virus 2789378 Viruses Viruses 708 0   NTclustered gi|1940198121|gb|MT757492.1| 2789378 g7531 i0 98.039 2.90147783251232 408 6 100 2 1 406 8570 8977 Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds blastn 1178 708 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Shenzhen dicistro-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);;