RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA976345" and tax_phylum = "Nucleocytoviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nucleocytoviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA976345 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
27594927 27594927 PRJNA976345_P_NODE_86304_length_200_cov_2.060606_g84696_i0 PRJNA976345 86304 200 2.060606 4.121212 Poxvirus euperipatoides37252 3117303 Viruses Viruses 50.4 4.06e-5   NR DBA47182.1 3117303 g84696 i0 52.5 0.6 40 19 60 0 72 191 47 86 DBA47182.1 MAG TPA_asm: MegaRT2 [Poxvirus euperipatoides37252] diamond 120 50.4 1 Viruses   Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Poxvirus euperipatoides37252
31194692 31194692 PRJNA976345_P_NODE_5155_length_827_cov_6.685606_g3899_i0 PRJNA976345 5155 827 6.685606 55.28996162 Poxvirus euperipatoides37252 3117303 Viruses Viruses 129 1.19e-29   NR DBA47182.1 3117303 g3899 i0 36.9 3.34824667472793 214 125 75.8 3 691 65 51 259 DBA47182.1 MAG TPA_asm: MegaRT2 [Poxvirus euperipatoides37252] diamond 2769 129 1 Viruses   Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Poxvirus euperipatoides37252
32775779 32775779 PRJNA976345_P_NODE_192540_length_152_cov_1.290598_g190932_i0 PRJNA976345 192540 152 1.290598 1.96170896 Poxvirus euperipatoides37252 3117303 Viruses Viruses 44.7 0.00226   NR DBA47182.1 3117303 g190932 i0 50 1.44078947368421 38 19 75 0 152 39 47 84 DBA47182.1 MAG TPA_asm: MegaRT2 [Poxvirus euperipatoides37252] diamond 219 44.7 1 Viruses   Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Poxvirus euperipatoides37252

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