RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA565584" and tax_phylum = "Kitrinoviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kitrinoviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA565584 · 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
1830895 1830895 PRJNA565584_P_NODE_160022_length_255_cov_3.384615_g158870_i0 PRJNA565584 160022 255 3.384615 8.63076825 Tobamovirus tabaci 3432891 Viruses Viruses 472 1.5e-128   NTclustered gi|1823692201|gb|MN186255.1| 12242 g158870 i0 100 100 255 0 100 0 1 255 685 431 Tobacco mosaic virus isolate Henan9-2-2017 CP, MP, 183K protein, and 130K protein genes, complete cds blastn 25500 472 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus tabaci
3687042 3687042 PRJNA565584_P_NODE_96143_length_305_cov_1.650862_g94991_i0 PRJNA565584 96143 305 1.650862 5.0351291 root 1 Root_unresolved Root_unresolved 564 2.95e-156   NTclustered gi|5777741|emb|Z36974.2| 12295 g94991 i0 100 18.944262295082 305 0 100 0 1 305 892 1196 Tobacco rattle virus genes for coat protein, 28.7 kDa & 32.8 kDa proteins, genomic RNA blastn 5778 564 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobravirus Tobravirus tabaci
13308412 13308412 PRJNA565584_P_NODE_105791_length_291_cov_1.412844_g104639_i0 PRJNA565584 105791 291 1.412844 4.11137604 Hepacivirus hominis 3052230 Viruses Viruses 54.7 0.007   NTclustered gi|1152729060|gb|KY620690.1| 3052230 g104639 i0 100 0.0996563573883162 29 0 10 0 259 287 9592 9620 Hepacivirus hominis isolate sP189489 polyprotein gene, complete cds blastn 29 54.7 1 Viruses   Orthornavirae Kitrinoviricota Flasuviricetes Amarillovirales Flaviviridae Hepacivirus Hepacivirus hominis

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