RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJEB25583" and tax_kingdom = "Sangervirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Sangervirae · 4 ✖

bioproject 1

  • PRJEB25583 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
7675277 7675277 PRJEB25583_P_NODE_6827_length_161_cov_2.274194_g6650_i0 PRJEB25583 6827 161 2.274194 3.66145234 Microviridae sp. 2202644 Viruses Viruses 111 2.18e-20   NTclustered gi|2384853317|gb|OM154838.1| 2202644 g6650 i0 84.821 1.62732919254658 112 15 69 2 51 161 3247 3357 MAG: Microviridae sp. isolate Miresoil microvirus 19, complete genome blastn 262 111 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
8950025 8950025 PRJEB25583_P_NODE_8408_length_150_cov_1.539823_g8231_i0 PRJEB25583 8408 150 1.539823 2.3097345 Microviridae sp. 2202644 Viruses Viruses 108 2.57e-19   NTclustered gi|2302021085|gb|MT208682.1| 2202644 g8231 i0 86.735 0.653333333333333 98 11 65 2 54 150 1108 1204 MAG: Microviridae sp. isolate CN7_L19_366, complete genome blastn 98 108 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
12776588 12776588 PRJEB25583_P_NODE_7971_length_153_cov_1.318966_g7794_i0 PRJEB25583 7971 153 1.318966 2.01801798 Microviridae sp. 2202644 Viruses Viruses 113 5.670000000000001e-21   NTclustered gi|2302015331|gb|MT203336.1| 2202644 g7794 i0 83.2 0.816993464052288 125 19 81 2 4 127 3963 4086 MAG: Microviridae sp. isolate CN7_L15_1011, complete genome blastn 125 113 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
19148464 19148464 PRJEB25583_P_NODE_3336_length_221_cov_3.081522_g3159_i0 PRJEB25583 3336 221 3.081522 6.81016362 Microviridae sp. 2202644 Viruses Viruses 326 1.05e-84   NTclustered gi|2906151359|gb|PQ646576.1| 2202644 g3159 i0 95.61 1.94117647058824 205 5 91 4 3 204 1065 1268 MAG: Microviridae sp. isolate k127_3173000 genomic sequence blastn 429 326 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.

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