RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA667863" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA667863 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
26954865 26954865 PRJNA667863_P_NODE_15182_length_244_cov_0.900585_g15148_i0 PRJNA667863 15182 244 0.900585 2.1974274 Ralstonia phage RSF1 1689679 Viruses Viruses 84.3 8.31e-17   NR YP_009207926.2 1689679 g15148 i0 46.8 0.971311475409836 79 38 92.2 1 225 1 171 249 YP_009207926.2 polymerase [Ralstonia phage RSF1] diamond 237 84.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Chiangmaivirus Chiangmaivirus RSF1
28060647 28060647 PRJNA667863_P_NODE_16945_length_241_cov_0.916667_g16911_i0 PRJNA667863 16945 241 0.916667 2.20916747 Microbacterium phage Zooman 2885984 Viruses Viruses 71.2 1.15e-12   NR UDL16380.1 2885984 g16911 i0 83 0.5850622406639 47 6 58.5 2 3 143 209 253 UDL16380.1 RecA-like DNA recombinase [Microbacterium phage Zooman] diamond 141 71.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Microbacterium phage Zooman
28786721 28786721 PRJNA667863_P_NODE_12727_length_248_cov_1.742857_g12693_i0 PRJNA667863 12727 248 1.742857 4.32228536 Caudoviricetes sp. 2832643 Viruses Viruses 57 2.79e-7   NR XOR60164.1 2832643 g12693 i0 59.3 0.653225806451613 54 21 65.3 1 170 9 1 53 XOR60164.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 162 57 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30207686 30207686 PRJNA667863_P_NODE_7752_length_272_cov_1.984925_g7718_i0 PRJNA667863 7752 272 1.984925 5.398996 Caudoviricetes sp. 2832643 Viruses Viruses 139 2.7e-37   NR DAN41809.1 2832643 g7718 i0 72.2 1.97426470588235 90 25 99.3 0 3 272 204 293 DAN41809.1 MAG TPA: major capsid protein [Caudoviricetes sp.] diamond 537 139 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32009886 32009886 PRJNA667863_P_NODE_3578_length_333_cov_0.888462_g3544_i0 PRJNA667863 3578 333 0.888462 2.95857846 Erwinia phage AH 3040788 Viruses Viruses 52.4 3.94e-5   NR QZA70451.1 2869568 g3544 i0 30 2.76576576576577 110 73 99.1 2 4 333 75 180 QZA70451.1 major capsid protein [Erwinia phage AH03] diamond 921 52.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Ahotrevirus Ahotrevirus AH03

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