RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB28062" and tax_phylum = "Preplasmiviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Preplasmiviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJEB28062 · 4 ✖

analysis 1

  • diamond · 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
29622214 29622214 PRJEB28062_P_NODE_89790_length_345_cov_15.448529_g87428_i0 PRJEB28062 89790 345 15.448529 53.29742505 Thermus phage phiKo 2301535 Viruses Viruses 53.1 2.7e-6   NR AYJ74683.1 2301535 g87428 i0 45.3 0.652173913043478 75 37 62.6 2 327 112 28 101 AYJ74683.1 hypothetical protein phiKo_08 [Thermus phage phiKo] diamond 225 53.1 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
29843650 29843650 PRJEB28062_P_NODE_108191_length_291_cov_3.504587_g105828_i0 PRJEB28062 108191 291 3.504587 10.19834817 Thermus phage phiKo 2301535 Viruses Viruses 118 1.06e-32   NR AYJ74693.1 2301535 g105828 i0 77.8 0.742268041237113 72 16 74.2 0 274 59 1 72 AYJ74693.1 hypothetical protein phiKo_18 [Thermus phage phiKo] diamond 216 118 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
31265530 31265530 PRJEB28062_P_NODE_46075_length_529_cov_21.065789_g43732_i0 PRJEB28062 46075 529 21.065789 111.43802381 Thermus phage phiKo 2301535 Viruses Viruses 125 2.5899999999999993e-34   NR AYJ74693.1 2301535 g43732 i0 83.3 0.408317580340265 72 12 40.8 0 19 234 1 72 AYJ74693.1 hypothetical protein phiKo_18 [Thermus phage phiKo] diamond 216 125 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
31581950 31581950 PRJEB28062_P_NODE_49536_length_507_cov_8.983871_g47188_i0 PRJEB28062 49536 507 8.983871 45.54822597 Thermus phage phiKo 2301535 Viruses Viruses 49.7 1e-4   NR AYJ74697.1 2301535 g47188 i0 58.5 0.242603550295858 41 15 23.1 1 196 312 31 71 AYJ74697.1 hypothetical protein phiKo_22 [Thermus phage phiKo] diamond 123 49.7 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo

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