RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA543299" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA543299 · 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
2394106 2394106 PRJNA543299_P_NODE_17962_length_177_cov_1.984375_g17805_i0 PRJNA543299 17962 177 1.984375 3.51234375 root 1 Root_unresolved Root_unresolved 320 3.71e-83   NTclustered gi|2083028918|gb|MZ375242.1| 10760 g17805 i0 100 88.593220338983 173 0 98 0 5 177 10645 10473 Mutant Escherichia phage T7 clone T7_50S, complete genome blastn 15681 320 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Autographivirales Autotranscriptaviridae Teseptimavirus Teseptimavirus T7
4946801 4946801 PRJNA543299_P_NODE_1704_length_527_cov_1.196653_g1562_i0 PRJNA543299 1704 527 1.196653 6.30636131 root 1 Root_unresolved Root_unresolved 974 0   NTclustered gi|2083029198|gb|MZ375249.1| 10760 g1562 i0 100 100 527 0 100 0 1 527 9963 10489 Mutant Escherichia phage T7 clone T7_90L, complete genome blastn 52700 974 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Autographivirales Autotranscriptaviridae Teseptimavirus Teseptimavirus T7
6887231 6887231 PRJNA543299_P_NODE_20406_length_167_cov_0.864407_g20249_i0 PRJNA543299 20406 167 0.864407 1.44355969 Caudoviricetes sp. 2832643 Viruses Viruses 226 7.799999999999999e-55   NTclustered gi|2915004039|gb|OR222348.1| 2832643 g20249 i0 92.903 3.78443113772455 155 11 93 0 1 155 23224 23378 MAG: Caudoviricetes sp. isolate MSP1050 genomic sequence blastn 632 226 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
11988362 11988362 PRJNA543299_P_NODE_20410_length_167_cov_0.864407_g20253_i0 PRJNA543299 20410 167 0.864407 1.44355969 Maltschvirus maltsch 2956182 Viruses Viruses 209 7.85e-50   NTclustered gi|1839173810|emb|LR796687.1| 2100421 g20253 i0 89.222 1 167 18 100 0 1 167 937 771 uncultured Caudovirales phage genome assembly blastn 167 209 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch

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