RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1073005" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 6 ✖

bioproject 1

  • PRJNA1073005 · 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
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
14215660 14215660 PRJNA1073005_P_NODE_6992_length_324_cov_1.187251_g6873_i0 PRJNA1073005 6992 324 1.187251 3.84669324 Skokie dicistro-like virus 2789443 Viruses Viruses 560 4.09e-155   NTclustered gi|1935607033|gb|MT747992.1| 2789443 g6873 i0 97.84 1 324 7 100 0 1 324 267 590 Skokie dicistro-like virus strain USAdf-2 polyprotein 1 and polyprotein 2 genes, complete cds blastn 324 560 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Skokie dicistro-like virus
14215667 14215667 PRJNA1073005_P_NODE_8072_length_280_cov_1.487923_g7953_i0 PRJNA1073005 8072 280 1.487923 4.1661844 Skokie dicistro-like virus 2789443 Viruses Viruses 496 9.92e-136   NTclustered gi|1940198090|gb|MT757477.1| 2789443 g7953 i0 98.571 5 280 4 100 0 1 280 979 700 Skokie dicistro-like virus strain CHNdf-3 polyprotein gene, partial cds blastn 1400 496 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Skokie dicistro-like virus

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