RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA577580 · 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
1839450 1839450 PRJNA577580_P_NODE_10082_length_288_cov_3.153488_g10004_i0 PRJNA577580 10082 288 3.153488 9.08204544 Caudoviricetes sp. vir323 3068356 Viruses Viruses 102 2.61e-17   NTclustered gi|2587525388|tpg|BK063679.1| 3068356 g10004 i0 87.5 3.68402777777778 88 11 90 0 10 97 8906 8819 TPA_asm: Caudoviricetes sp. vir323 genomic sequence blastn 1061 102 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp. vir323
13318068 13318068 PRJNA577580_P_NODE_8211_length_316_cov_1.358025_g8133_i0 PRJNA577580 8211 316 1.358025 4.291359 Caudoviricetes sp. 2832643 Viruses Viruses 80.5 1.36e-10   NTclustered gi|2914774203|gb|OR222100.1| 2832643 g8133 i0 88.235 27.8481012658228 68 6 21 2 169 235 33141 33207 MAG: Caudoviricetes sp. isolate MSP0010 genomic sequence blastn 8800 80.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
14592919 14592919 PRJNA577580_P_NODE_4912_length_404_cov_2.592145_g4834_i0 PRJNA577580 4912 404 2.592145 10.4722658 Caudoviricetes sp. vir323 3068356 Viruses Viruses 121 1.05e-22   NTclustered gi|2587525388|tpg|BK063679.1| 3068356 g4834 i0 75.397 5.22772277227723 252 60 79 2 78 328 9381 9131 TPA_asm: Caudoviricetes sp. vir323 genomic sequence blastn 2112 121 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp. vir323
18415951 18415951 PRJNA577580_P_NODE_3575_length_476_cov_3.548387_g3497_i0 PRJNA577580 3575 476 3.548387 16.89032212 Pseudomonas phage Lu11 1161927 Viruses Viruses 63.9 2.14e-5   NTclustered gi|388684650|ref|NC_017972.1| 1161927 g3497 i0 87.719 0.672268907563025 57 4 12 2 32 88 124877 124824 Pseudomonas phage Lu11, complete genome blastn 320 63.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage Lu11

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