RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA781453", tax_kingdom = "Orthornavirae" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 3 ✖

tax_kingdom 1

  • Orthornavirae · 3 ✖

bioproject 1

  • PRJNA781453 · 3 ✖

analysis 1

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
10966852 10966852 PRJNA781453_P_NODE_31029_length_256_cov_1.016393_g30914_i0 PRJNA781453 31029 256 1.016393 2.60196608 Potyvirus rapae 3240607 Viruses Viruses 457 4.22e-124   NTclustered gi|2019445938|dbj|LC537503.1| 12230 g30914 i0 98.828 100 256 3 100 0 1 256 8845 9100 Turnip mosaic virus CHN244 RNA, nearly complete sequence blastn 25600 457 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus rapae
13516061 13516061 PRJNA781453_P_NODE_15851_length_368_cov_1.037288_g15737_i0 PRJNA781453 15851 368 1.037288 3.81721984 Potyvirus rapae 3240607 Viruses Viruses 667 0   NTclustered gi|2019445986|dbj|LC537527.1| 12230 g15737 i0 99.455 99.7255434782609 367 2 99 0 2 368 7384 7750 Turnip mosaic virus CHZH34A RNA, nearly complete sequence blastn 36699 667 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus rapae
14791446 14791446 PRJNA781453_P_NODE_35132_length_248_cov_0.862857_g35017_i0 PRJNA781453 35132 248 0.862857 2.13988536 Potyvirus rapae 3240607 Viruses Viruses 420 5.34e-113   NTclustered gi|2019445942|dbj|LC537505.1| 12230 g35017 i0 97.177 100.008064516129 248 7 100 0 1 248 3048 2801 Turnip mosaic virus CHN254 RNA, nearly complete sequence blastn 24802 420 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus rapae

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