RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1073005 · 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
4013431 4013431 PRJNA1073005_P_NODE_9144_length_250_cov_0.870056_g9025_i0 PRJNA1073005 9144 250 0.870056 2.17514 Caudoviricetes sp. 2832643 Viruses Viruses 390 4.22e-104   NTclustered gi|2914938452|gb|OR221697.1| 2832643 g9025 i0 94.8 14.92 250 13 100 0 1 250 15262 15013 MAG: Caudoviricetes sp. isolate MSP1348 genomic sequence blastn 3730 390 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
7393708 7393708 PRJNA1073005_P_NODE_6666_length_339_cov_1.157895_g6547_i0 PRJNA1073005 6666 339 1.157895 3.92526405 Tequatrovirus 10663 Viruses Viruses 448 3.4899999999999997e-121   NTclustered gi|2721715921|emb|OZ035787.1| 10665 g6547 i0 100 71.377581120944 242 0 71 0 98 339 38777 38536 Tequatrovirus T4 genome assembly, chromosome: 1 blastn 24197 448 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Straboviridae Tequatrovirus Tequatrovirus T4
9114607 9114607 PRJNA1073005_P_NODE_9708_length_246_cov_0.890173_g9589_i0 PRJNA1073005 9708 246 0.890173 2.18982558 Caudoviricetes sp. 2832643 Viruses Viruses 333 7.089999999999999e-87   NTclustered gi|2915004039|gb|OR222348.1| 2832643 g9589 i0 91.093 6.01219512195122 247 20 100 2 1 246 7704 7949 MAG: Caudoviricetes sp. isolate MSP1050 genomic sequence blastn 1479 333 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
9944162 9944162 PRJNA1073005_P_NODE_8028_length_282_cov_1.354067_g7909_i0 PRJNA1073005 8028 282 1.354067 3.81846894 Christensenvirus 2732061 Viruses Viruses 516 7.67e-142   NTclustered gi|2287965697|gb|OP087522.1| 2972435 g7909 i0 99.645 55.9964539007092 282 1 100 0 1 282 14204 14485 Escherichia phage TR1, complete genome blastn 15791 516 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR1

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