RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJNA976345", tax_kingdom = "Orthornavirae" and tax_phylum = "Negarnaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Negarnaviricota · 2 ✖

tax_kingdom 1

  • Orthornavirae · 2 ✖

bioproject 1

  • PRJNA976345 · 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
28106038 28106038 PRJNA976345_P_NODE_64305_length_223_cov_2.877660_g62697_i0 PRJNA976345 64305 223 2.87766 6.4171818 Quaranjavirus 1299308 Viruses Viruses 49.3 1.37e-4   NR AJG39088.1 1608078 g62697 i0 49 1.21076233183856 49 25 65.9 0 66 212 669 717 AJG39088.1 PB1 [Shuangao Insect Virus 4] diamond 270 49.3 1 Viruses   Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Quaranjavirus Shuangao Insect Virus 4
31549468 31549468 PRJNA976345_P_NODE_38676_length_276_cov_1.721992_g37069_i0 PRJNA976345 38676 276 1.721992 4.75269792 Viruses 10239 Viruses Viruses 60.5 2.61e-8   NR QPL15373.1 2792587 g37069 i0 31.9 3.8695652173913 94 56 98.9 3 275 3 56 144 QPL15373.1 nucleoprotein [Hymenopteran phasma-related virus OKIAV233] diamond 1068 60.5 1 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes Elliovirales Phasmaviridae   Hymenopteran phasma-related virus OKIAV233

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