RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA998413" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 3 ✖

bioproject 1

  • PRJNA998413 · 3 ✖

analysis 1

  • blastn · 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
4807166 4807166 PRJNA998413_S_NODE_7444_length_244_cov_1.060773_g7413_i0 PRJNA998413 7444 244 1.060773 2.58828612 Carlavirus latensdianthi 3427766 Viruses Viruses 54.7 0.006   NTclustered gi|1995060321|gb|MN450069.1| 12164 g7413 i0 100 0.577868852459016 29 0 12 0 1 29 13 41 Carnation latent virus isolate KL, complete genome blastn 141 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
7356772 7356772 PRJNA998413_S_NODE_11626_length_214_cov_1.688742_g11595_i0 PRJNA998413 11626 214 1.688742 3.61390788 Emesvirus zinderi 329852 Viruses Viruses 396 7.559999999999996e-106   NTclustered gi|329402167|gb|HQ332490.1| 12022 g11595 i0 100 99.5514018691589 214 0 100 0 1 214 3230 3443 Enterobacteria phage MS2 isolate 862B assembly protein (mat), coat protein (cp), lysis protein (lys), and replicase protein (rep) genes, complete cds blastn 21304 396 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae Emesvirus Emesvirus zinderi
8632223 8632223 PRJNA998413_S_NODE_2527_length_336_cov_1.062271_g2496_i0 PRJNA998413 2527 336 1.062271 3.56923056 Emesvirus zinderi 329852 Viruses Viruses 599 9.029999999999998e-167   NTclustered gi|225421599|gb|FJ799517.1| 12022 g2496 i0 99.099 94.4047619047619 333 3 99 0 4 336 2274 2606 Enterobacterio phage MS2 clone L1.G40.6 assembly protein (MS2g1), coat protein (MS2g2), lysis protein (MS2g3), and replicase protein (MS2g4) genes, complete cds blastn 31720 599 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae Emesvirus Emesvirus zinderi

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