RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1136957" and tax_kingdom = "Heunggongvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Heunggongvirae · 4 ✖

bioproject 1

  • PRJNA1136957 · 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
27355015 27355015 PRJNA1136957_S_NODE_11883_length_249_cov_1.284211_g11786_i0 PRJNA1136957 11883 249 1.284211 3.19768539 Pseudomonas phage OBP 1124849 Viruses Viruses 45.1 0.00574   NR YP_004958196.1 1124849 g11786 i0 35.6 0.710843373493976 59 38 71.1 0 230 54 1 59 YP_004958196.1 hypothetical protein OBP_289 [Pseudomonas phage OBP] diamond 177 45.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Petsuvirus Pseudomonas phage OBP
30733832 30733832 PRJNA1136957_S_NODE_16114_length_217_cov_1.500000_g16017_i0 PRJNA1136957 16114 217 1.5 3.255 Caudoviricetes sp. 2832643 Viruses Viruses 43.5 0.0033   NR DAV53031.1 2832643 g16017 i0 88.9 0.248847926267281 18 2 24.9 0 62 9 2 19 DAV53031.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 54 43.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31112828 31112828 PRJNA1136957_S_NODE_13855_length_232_cov_1.554913_g13758_i0 PRJNA1136957 13855 232 1.554913 3.60739816 Caudoviricetes sp. 2832643 Viruses Viruses 145 1.4099999999999999e-42   NR DAV52985.1 2832643 g13758 i0 88 0.969827586206897 75 9 97 0 6 230 38 112 DAV52985.1 MAG TPA: Terminase small subunit [Caudoviricetes sp.] diamond 225 145 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31840241 31840241 PRJNA1136957_S_NODE_14957_length_224_cov_2.957576_g14860_i0 PRJNA1136957 14957 224 2.957576 6.62497024 Caudoviricetes sp. 2832643 Viruses Viruses 39.7 0.0345   NR DAV53021.1 2832643 g14860 i0 42.5 0.535714285714286 40 23 53.6 0 86 205 1 40 DAV53021.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 120 39.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes 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);;