RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1120060" and tax_phylum = "Commensaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Commensaviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1120060 · 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
274485 274485 PRJNA1120060_P_NODE_998941_length_312_cov_2.569038_g981012_i0 PRJNA1120060 998941 312 2.569038 8.01539856 Alphatorquevirus sp. 2809145 Viruses Viruses 52.8 0.029   NTclustered gi|2894906387|tpg|BK069140.1| 2809145 g981012 i0 100 0.0897435897435897 28 0 9 0 77 104 878 905 MAG TPA_asm: Alphatorquevirus sp. isolate SRR2037084_NODE_1060 genomic sequence blastn 28 52.8 1 Viruses   Shotokuvirae Commensaviricota Cardeaviricetes Sanitavirales Anelloviridae Alphatorquevirus Alphatorquevirus sp.
5356990 5356990 PRJNA1120060_P_NODE_261345_length_435_cov_3.635359_g244454_i0 PRJNA1120060 261345 435 3.635359 15.81381165 TTV-like mini virus 93678 Viruses Viruses 52.8 0.042   NTclustered gi|2164987747|gb|MN771414.1| 93678 g244454 i0 100 0.064367816091954 28 0 6 0 20 47 1952 1979 MAG: TTV-like mini virus isolate SAfiA-350-43, complete genome blastn 28 52.8 1 Viruses   Shotokuvirae Commensaviricota Cardeaviricetes Sanitavirales Anelloviridae Betatorquevirus TTV-like mini virus
16849141 16849141 PRJNA1120060_P_NODE_835214_length_316_cov_2.481481_g817301_i0 PRJNA1120060 835214 316 2.481481 7.84147996 TTV-like mini virus 93678 Viruses Viruses 54.7 0.008   NTclustered gi|2164985327|gb|MN770248.1| 93678 g817301 i0 96.97 0.522151898734177 33 0 10 1 118 150 282 313 MAG: TTV-like mini virus isolate SAfiA-300-21, complete genome blastn 165 54.7 1 Viruses   Shotokuvirae Commensaviricota Cardeaviricetes Sanitavirales Anelloviridae Betatorquevirus TTV-like mini virus

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