RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1197996 · 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
1598989 1598989 PRJNA1197996_S_NODE_782_length_774_cov_7.038516_g743_i0 PRJNA1197996 782 774 7.038516 54.47811384 Caudoviricetes sp. 2832643 Viruses Viruses 56.5 0.006   NTclustered gi|2914806051|gb|OR221530.1| 2832643 g743 i0 100 0.22609819121447 30 0 4 0 745 774 43955 43984 MAG: Caudoviricetes sp. isolate MSP1551 genomic sequence blastn 175 56.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
6701768 6701768 PRJNA1197996_S_NODE_15806_length_289_cov_1.106481_g15752_i0 PRJNA1197996 15806 289 1.106481 3.19773009 Enterococcus phage SSMH01 3075855 Viruses Viruses 119 2.6e-22   NTclustered gi|2583824285|gb|OR360270.1| 3075855 g15752 i0 91.011 21.0692041522491 89 6 31 2 1 89 41684 41598 Enterococcus phage SSMH01, complete genome blastn 6089 119 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Efquatrovirus Enterococcus phage SSMH01
13077894 13077894 PRJNA1197996_S_NODE_6471_length_382_cov_7.485437_g6417_i0 PRJNA1197996 6471 382 7.485437 28.59436934 Caudoviricetes sp. 2832643 Viruses Viruses 52.8 0.036   NTclustered gi|2057049160|tpg|BK049431.1| 2832643 g6417 i0 100 0.0732984293193717 28 0 7 0 303 330 11323 11296 MAG TPA_asm: Caudoviricetes sp. isolate ctWOy1, partial genome blastn 28 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
24550324 24550324 PRJNA1197996_S_NODE_27720_length_243_cov_0.864706_g27666_i0 PRJNA1197996 27720 243 0.864706 2.10123558 Caudoviricetes sp. 2832643 Viruses Viruses 75 4.67e-9   NTclustered gi|2059887386|tpg|BK041116.1| 2832643 g27666 i0 94 17.4979423868313 50 1 21 2 186 235 29246 29293 MAG TPA_asm: Caudoviricetes sp. isolate ctF2D3, partial genome blastn 4252 75 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);;