RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA611476" 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

bioproject 1

  • PRJNA611476 · 2 ✖

analysis 1

  • diamond · 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
26763695 26763695 PRJNA611476_P_NODE_8301_length_673_cov_2.145000_g7527_i0 PRJNA611476 8301 673 2.145 14.43585 Sea turtle neural virus 1 3112944 Viruses Viruses 49.3 0.0065   NR WET19891.1 3112944 g7527 i0 52.5 0.178306092124814 40 19 17.8 0 673 554 458 497 WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1] diamond 120 49.3 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Chuvivirus Sea turtle neural virus 1
30788384 30788384 PRJNA611476_P_NODE_40814_length_334_cov_1.314176_g40023_i0 PRJNA611476 40814 334 1.314176 4.38934784 Chuvivirus 2842604 Viruses Viruses 140 4.71e-37   NR WET19887.1 2842604 g40023 i0 60.9 1.97604790419162 110 43 98.8 0 332 3 255 364 WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1] diamond 660 140 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Chuvivirus Chuvivirus

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