RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJEB48872" and tax_kingdom = "Heunggongvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Heunggongvirae · 6 ✖

bioproject 1

  • PRJEB48872 · 6 ✖

analysis 1

  • blastn · 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
5178446 5178446 PRJEB48872_P_NODE_389665_length_235_cov_1.882653_g373853_i0 PRJEB48872 389665 235 1.882653 4.42423455 Escherichia phage Ec_YwIITB1 3366621 Viruses Viruses 209 1.18e-49   NTclustered gi|2870405014|gb|PQ356294.1| 3366621 g373853 i0 83.043 97.8723404255319 230 39 98 0 2 231 128953 129182 Escherichia phage Ec_YwIITB1, complete genome blastn 23000 209 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Straboviridae Tequatrovirus Escherichia phage Ec_YwIITB1
6465855 6465855 PRJEB48872_P_NODE_630586_length_162_cov_1.333333_g614774_i0 PRJEB48872 630586 162 1.333333 2.15999946 Pahexavirus P101A 1982267 Viruses Viruses 294 2.03e-75   NTclustered gi|408905836|ref|NC_018841.1| 1229786 g614774 i0 99.383 98.4444444444444 162 1 100 0 1 162 25819 25980 Propionibacterium phage P101A, complete genome blastn 15948 294 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Pahexavirus P101A
16293489 16293489 PRJEB48872_P_NODE_612873_length_166_cov_0.897638_g597061_i0 PRJEB48872 612873 166 0.897638 1.49007908 Pahexavirus 1982251 Viruses Viruses 257 2.7400000000000003e-64   NTclustered gi|408905836|ref|NC_018841.1| 1229786 g597061 i0 94.578 98.3132530120482 166 9 100 0 1 166 10609 10774 Propionibacterium phage P101A, complete genome blastn 16320 257 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Pahexavirus P101A
18842477 18842477 PRJEB48872_P_NODE_697875_length_150_cov_1.315315_g682063_i0 PRJEB48872 697875 150 1.315315 1.9729725 Pahexavirus 1982251 Viruses Viruses 259 6.71e-65   NTclustered gi|408905834|ref|NC_018839.1| 1229784 g682063 i0 98.63 94.1 146 2 97 0 5 150 7992 7847 Propionibacterium phage P14.4, complete genome blastn 14115 261 0.992337164750958 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Pahexavirus P144
20117263 20117263 PRJEB48872_P_NODE_538716_length_183_cov_1.388889_g522904_i0 PRJEB48872 538716 183 1.388889 2.54166687 Pahexavirus 1982251 Viruses Viruses 305 1.08e-78   NTclustered gi|1631925795|ref|NC_041954.1| 1655013 g522904 i0 96.721 100.453551912568 183 6 100 0 1 183 20677 20859 Propionibacterium phage Keiki, complete genome blastn 18383 305 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Pahexavirus keiki
22667616 22667616 PRJEB48872_P_NODE_492558_length_196_cov_1.458599_g476746_i0 PRJEB48872 492558 196 1.458599 2.85885404 Pahexavirus 1982251 Viruses Viruses 357 3.2099999999999996e-94   NTclustered gi|945393407|gb|KT934381.1| 1747271 g476746 i0 99.49 98.1632653061225 196 1 100 0 1 196 21157 20962 Propionibacterium phage PA1-14, complete genome blastn 19240 357 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Propionibacterium phage PA1-14

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