RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA798511" and tax_kingdom = "Shotokuvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Shotokuvirae · 3 ✖

bioproject 1

  • PRJNA798511 · 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
3769459 3769459 PRJNA798511_P_NODE_85223_length_256_cov_1.464481_g80957_i0 PRJNA798511 85223 256 1.464481 3.74907136 Begomovirus 10814 Viruses Viruses 473 4.189999999999999e-129   NTclustered gi|2636060190|dbj|LC790473.1| 10832 g80957 i0 100 100 256 0 100 0 1 256 521 266 Tomato yellow leaf curl virus Kanagawa3 DNA, complete genome blastn 25600 473 1 Viruses   Shotokuvirae Cressdnaviricota Repensiviricetes Geplafuvirales Geminiviridae Begomovirus Begomovirus coheni
22467846 22467846 PRJNA798511_P_NODE_59698_length_318_cov_5.514286_g55432_i0 PRJNA798511 59698 318 5.514286 17.53542948 Nanoviridae sp. 2723992 Viruses Viruses 52.8 0.03   NTclustered gi|2302015506|gb|MT203386.1| 2723992 g55432 i0 96.875 0.10062893081761 32 0 10 1 256 286 198 229 MAG: Nanoviridae sp. isolate CN8_L15_4547, complete genome blastn 32 52.8 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Mulpavirales Nanoviridae   Nanoviridae sp.
23743935 23743935 PRJNA798511_P_NODE_88299_length_251_cov_0.865169_g84033_i0 PRJNA798511 88299 251 0.865169 2.17157419 Polyomavirus myotis5169 3117250 Viruses Viruses 52.8 0.023   NTclustered gi|2710391313|tpg|BK066489.1| 3117250 g84033 i0 100 0.111553784860558 28 0 11 0 49 76 405 432 MAG TPA_asm: Polyomavirus myotis5169 isolate Polyoma5169 genomic sequence blastn 28 52.8 1 Viruses   Shotokuvirae Cossaviricota Papovaviricetes Sepolyvirales Polyomaviridae   Polyomavirus myotis5169

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