RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA815356" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 3 ✖

tax_phylum 1

tax_kingdom 1

bioproject 1

  • PRJNA815356 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
819071 819071 PRJNA815356_P_NODE_1601_length_512_cov_2.917995_g1439_i0 PRJNA815356 1601 512 2.917995 14.9401344 Caudoviricetes sp. 2832643 Viruses Viruses 782 0   NTclustered gi|2054434277|tpg|BK035998.1| 2832643 g1439 i0 97.797 447.8515625 454 9 88 1 1 453 17966 18419 MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome blastn 229300 782 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
11022893 11022893 PRJNA815356_P_NODE_3129_length_385_cov_1.698718_g2966_i0 PRJNA815356 3129 385 1.698718 6.5400643 Tequatrovirus cromcrrp10 2843954 Viruses Viruses 270 9.32e-68   NTclustered gi|1376355127|gb|MG775043.2| 2079276 g2966 i0 81.734 33.6519480519481 323 59 84 0 52 374 109742 110064 Citrobacter phage vB_CroM_CrRp10, complete genome blastn 12956 270 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Straboviridae Tequatrovirus Tequatrovirus cromcrrp10
17397511 17397511 PRJNA815356_P_NODE_7294_length_273_cov_1.560000_g7131_i0 PRJNA815356 7294 273 1.56 4.2588 Caudoviricetes sp. 2832643 Viruses Viruses 466 7.55e-127   NTclustered gi|2914933639|gb|OR221620.1| 2832643 g7131 i0 97.445 1.003663003663 274 5 100 2 1 273 8263 7991 MAG: Caudoviricetes sp. isolate MSP1439 genomic sequence blastn 274 466 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);;