RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA807685" and tax_kingdom = "Bamfordvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Bamfordvirae · 6 ✖

bioproject 1

  • PRJNA807685 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
26769296 26769296 PRJNA807685_P_NODE_45461_length_181_cov_1.840278_g44388_i0 PRJNA807685 45461 181 1.840278 3.33090318 Adintovirus androctonus13 3115887 Viruses Viruses 76.3 1.43e-14   NR DBA46911.1 3115887 g44388 i0 55.9 0.977900552486188 59 26 97.8 0 178 2 113 171 DBA46911.1 MAG TPA_asm: Integrase [Adintovirus androctonus13035] diamond 177 76.3 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus androctonus13035
26896209 26896209 PRJNA807685_P_NODE_56061_length_163_cov_1.888889_g54988_i0 PRJNA807685 56061 163 1.888889 3.07888907 Poxvirus euperipatoides37252 3117303 Viruses Viruses 52 6.64e-6   NR DBA47182.1 3117303 g54988 i0 52.5 2.39263803680982 40 19 73.6 0 36 155 47 86 DBA47182.1 MAG TPA_asm: MegaRT2 [Poxvirus euperipatoides37252] diamond 390 52 1 Viruses   Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Poxvirus euperipatoides37252
29075460 29075460 PRJNA807685_P_NODE_64688_length_153_cov_1.525862_g63615_i0 PRJNA807685 64688 153 1.525862 2.33456886 Adintovirus androctonus13 3115887 Viruses Viruses 108 5.14e-26   NR DBA46910.1 3115887 g63615 i0 92 0.980392156862745 50 4 98 0 151 2 281 330 DBA46910.1 MAG TPA_asm: PolBb [Adintovirus androctonus13035] diamond 150 108 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus androctonus13035
30939019 30939019 PRJNA807685_P_NODE_40314_length_193_cov_2.730769_g39241_i0 PRJNA807685 40314 193 2.730769 5.27038417 Adintovirus androctonus13 3115887 Viruses Viruses 87 3.62e-19   NR DBA46914.1 3115887 g39241 i0 63.5 2.87564766839378 63 23 97.9 0 192 4 106 168 DBA46914.1 MAG TPA_asm: PacK [Adintovirus androctonus13035] diamond 555 87 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus androctonus13035
31508074 31508074 PRJNA807685_P_NODE_62256_length_156_cov_0.983193_g61183_i0 PRJNA807685 62256 156 0.983193 1.53378108 Adintovirus androctonus13 3115887 Viruses Viruses 53.9 9.28e-7   NR DBA46918.1 3115887 g61183 i0 55 1.53846153846154 40 18 76.9 0 122 3 1 40 DBA46918.1 MAG TPA_asm: Penton+ [Adintovirus androctonus13035] diamond 240 53.9 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus androctonus13035
32552200 32552200 PRJNA807685_P_NODE_36539_length_205_cov_1.904762_g35466_i0 PRJNA807685 36539 205 1.904762 3.9047621 Adintovirus androctonus13 3115887 Viruses Viruses 79 6.11e-16   NR DBA46917.1 3115887 g35466 i0 52.2 0.980487804878049 67 32 98 0 3 203 143 209 DBA46917.1 MAG TPA_asm: Penton [Adintovirus androctonus13035] diamond 201 79 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus androctonus13035

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