RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA339266" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA339266 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
5494918 5494918 PRJNA339266_P_NODE_5405_length_184_cov_2.333333_g5375_i0 PRJNA339266 5405 184 2.333333 4.29333272 Siphoviridae sp. ct3z32 2825327 Viruses Viruses 135 1.51e-27   NTclustered gi|2053181631|tpg|BK016267.1| 2825327 g5375 i0 98.684 1.23913043478261 76 1 83 0 1 76 27015 27090 MAG TPA_asm: Siphoviridae sp. ct3z32, partial genome blastn 228 135 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Siphoviridae sp. ct3z32
5495145 5495145 PRJNA339266_S_NODE_19845_length_150_cov_2.681416_g19834_i0 PRJNA339266 19845 150 2.681416 4.022124 Caudoviricetes sp. 2832643 Viruses Viruses 272 8.609999999999998e-69   NTclustered gi|2057093414|tpg|BK038165.1| 2832643 g19834 i0 99.333 4.99333333333333 150 1 100 0 1 150 6584 6733 MAG TPA_asm: Caudoviricetes sp. isolate ctIkb7, partial genome blastn 749 272 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
5495313 5495313 PRJNA339266_S_NODE_8385_length_187_cov_8.013333_g8374_i0 PRJNA339266 8385 187 8.013333 14.98493271 Caudoviricetes sp. 2832643 Viruses Viruses 200 5.4e-47   NTclustered gi|2058005679|tpg|BK041634.1| 2832643 g8374 i0 91.156 0.978609625668449 147 13 79 0 41 187 21842 21696 MAG TPA_asm: Caudoviricetes sp. isolate ctuTV6, partial genome blastn 183 200 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
14420101 14420101 PRJNA339266_P_NODE_1832_length_234_cov_1.979695_g1802_i0 PRJNA339266 1832 234 1.979695 4.6324863 Caudoviricetes sp. 2832643 Viruses Viruses 52.8 0.021   NTclustered gi|2053141422|tpg|BK018790.1| 2832643 g1802 i0 100 0.11965811965812 28 0 12 0 88 115 3685 3712 MAG TPA_asm: Caudoviricetes sp. isolate ctWJ240, partial genome blastn 28 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
16968746 16968746 PRJNA339266_S_NODE_10794_length_176_cov_2.014388_g10783_i0 PRJNA339266 10794 176 2.014388 3.54532288 Caudoviricetes sp. 2832643 Viruses Viruses 250 4.91e-62   NTclustered gi|2054414991|tpg|BK035615.1| 2832643 g10783 i0 96.078 0.869318181818182 153 6 87 0 24 176 34636 34788 MAG TPA_asm: Caudoviricetes sp. isolate ctfki10, partial genome blastn 153 250 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
20792676 20792676 PRJNA339266_P_NODE_1517_length_245_cov_75.701923_g1487_i0 PRJNA339266 1517 245 75.701923 185.46971135 Caudoviricetes sp. 2832643 Viruses Viruses 52.8 0.022   NTclustered gi|2058161542|tpg|BK034705.1| 2832643 g1487 i0 100 0.114285714285714 28 0 11 0 214 241 7618 7645 MAG TPA_asm: Caudoviricetes sp. isolate ct4d17, partial genome blastn 28 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
24617592 24617592 PRJNA339266_S_NODE_16000_length_159_cov_1.680328_g15989_i0 PRJNA339266 16000 159 1.680328 2.67172152 Caudoviricetes sp. 2832643 Viruses Viruses 254 3.36e-63   NTclustered gi|2054414991|tpg|BK035615.1| 2832643 g15989 i0 95.57 0.993710691823899 158 7 99 0 1 158 3329 3172 MAG TPA_asm: Caudoviricetes sp. isolate ctfki10, partial genome blastn 158 254 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);;