RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA527965" 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

  • PRJNA527965 · 4 ✖

analysis 1

  • blastn · 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
11975631 11975631 PRJNA527965_S_NODE_2850_length_227_cov_0.921875_g2767_i0 PRJNA527965 2850 227 0.921875 2.09265625 Pahexavirus procrass1 1982304 Viruses Viruses 407 3.7499999999999994e-109   NTclustered gi|906476013|ref|NC_027626.1| 1655019 g2767 i0 99.115 99.0748898678414 226 2 99 0 1 226 5597 5372 Propionibacterium phage Procrass1, complete genome blastn 22490 407 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Pahexavirus procrass1
12593308 12593308 PRJNA527965_S_NODE_5010_length_167_cov_2.227273_g4927_i0 PRJNA527965 5010 167 2.227273 3.71954591 Pahexavirus 1982251 Viruses Viruses 298 1.63e-76   NTclustered gi|330858398|ref|NC_015454.1| 504501 g4927 i0 98.81 87.6766467065868 168 1 100 1 1 167 26322 26489 Propionibacterium phage PAD20 endogenous virus, complete genome blastn 14642 298 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Pahexavirus PAD20
14525808 14525808 PRJNA527965_S_NODE_5492_length_160_cov_1.264000_g5409_i0 PRJNA527965 5492 160 1.264 2.0224 Propionibacterium phage pa63 2079410 Viruses Viruses 267 4.35e-67   NTclustered gi|1338076744|gb|MG820637.1| 2079410 g5409 i0 96.855 99.28125 159 5 99 0 1 159 6789 6947 Propionibacterium phage pa63, complete genome blastn 15885 267 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Propionibacterium phage pa63
18965929 18965929 PRJNA527965_S_NODE_4415_length_179_cov_2.576389_g4332_i0 PRJNA527965 4415 179 2.576389 4.61173631 Pahexavirus 1982251 Viruses Viruses 326 8.09e-85   NTclustered gi|408905837|ref|NC_018842.1| 1229792 g4332 i0 99.441 100.134078212291 179 1 100 0 1 179 162 340 Propionibacterium phage P1.1, complete genome blastn 17924 326 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Pahexavirus P11

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