RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA358049" and tax_phylum = "Lenarviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lenarviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA358049 · 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
1673414 1673414 PRJNA358049_S_NODE_4202_length_293_cov_2.815574_g4154_i0 PRJNA358049 4202 293 2.815574 8.24963182 Hulunbuir Botou tick virus 1 2972048 Viruses Viruses 135 2.6200000000000003e-27   NTclustered gi|2319492089|gb|ON746338.1| 2972048 g4154 i0 98.684 1.33105802047782 76 1 26 0 195 270 101 26 MAG: Hulunbuir Botou tick virus 1 isolate TIGMIC 7 genomic sequence blastn 390 135 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Hulunbuir Botou tick virus 1
4901101 4901101 PRJNA358049_S_NODE_4_length_2870_cov_5.184332_g3_i0 PRJNA358049 4 2870 5.184332 148.7903284 Viruses 10239 Viruses Viruses 3345 0   NTclustered gi|2396039623|gb|ON812886.1| 2808997 g3 i0 87.987 13.4801393728223 2847 322 99 17 1 2839 2835 1 MAG: Botourmiaviridae sp. isolate TIGMIC_3, complete genome blastn 38688 3345 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Botourmiaviridae sp.
10602551 10602551 PRJNA358049_S_NODE_69_length_1389_cov_5.918657_g58_i0 PRJNA358049 69 1389 5.918657 82.21014573 Erysiphe necator associated ourmia-like virus 36 2741816 Viruses Viruses 970 0   NTclustered gi|1848976605|gb|MN611564.1| 2741816 g58 i0 79.458 1.66810655147588 1402 262 100 24 1 1389 2149 761 Erysiphe necator associated ourmia-like virus 36 isolate PMS12_DN11639, complete genome blastn 2317 970 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Ourmiavirus Erysiphe necator associated ourmia-like virus 36

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